(Accounting) Invoice a BtB transit sales order

Related topics

The following describes the accounting transactions the system creates when you invoice a VAT based item on a BtB transit sales order line.

Cost type = Standard cost

Prerequisites
The following prerequisites apply if the cost type is Standard cost:

Invoiced qty 100
Sales price 50.00 SEK
Cost price 25.00 SEK
VAT item 25%

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
820 Sales value Gross VAT   5000.00
Sales price * Quantity

50.00 * 100 = 5000.00

960 VAT output of order lines   1250.00
Sales value Gross VAT * VAT percentage of VAT handling code

5000.00 * 0.25 = 1250.00

This transaction is the VAT amount for the sales value.

800 Cost of goods sold 2500.00  
Cost price * Quantity

25.00 * 100 = 2500.00

The cost price is always retrieved from the Standard cost field in the Item file irrespective of the purchase price on the corresponding BtB transit purchase order.

902 Stock value transit stock   2500.00
Cost price * Quantity

25.00 * 100 = 2500.00

The cost price is always retrieved as described in Cost of goods sold.

A/R To be accounted on Account Receivable 6250.00    

Cost type = Average purchase price or FIFO

Prerequisites
The following prerequisites apply if the cost type is Average purchase price or FIFO:

Invoiced qty 100
Sales price 50.00 SEK
Cost price 11.00 SEK
VAT item 25%

Created transactions

Transaction type Description Amount
Debit
Amount
Credit
Calculation/Result/Additional info
820 Sales value Gross VAT   5000.00
Sales price * Quantity

50.00 * 100 = 5000.00

960 VAT output of order lines   1250.00
Sales value Gross VAT * VAT percentage of VAT handling code

5000.00 * 0.25 = 1250.00

This transaction is the VAT amount for the sales value.

800 Cost of goods sold 1100.00   In this example, the cost price is FIFO and is calculated as:

(Purchase price * Quantity) + (Purchase price * Quantity * Handling cost)

(10.00 * 100) + (10.00 * 100 * 0.10) = 11.00

If the cost type is Average purchase cost, the cost price is retrieved from:

  • the Average transit cost field in the Item file, if the Separate cost handling field is set to YES in the DIS control file.
  • the Average cost field in the Item file, if the Separate cost handling field is set to NO in the DIS control file.

If the cost type is FIFO, the cost price is retrieved from the corresponding BtB transit purchase order. The cost price is calculated as described above.

902 Stock value transit stock   1100.00
Cost price * Quantity

11.00 * 100 = 1100.00

The cost price is retrieved as described in Cost of goods sold.

A/R To be accounted on Account Receivable 6250.00    

Related topics