(Accounting) Enter credit cash receipts in system currency

Related topics

The following describes the accounting transactions the system creates when a credit cash sales order is entered. This could be necessary to do if you, e.g., want to pay the customer from the cash box, since the customer wants the money in cash. For the purpose of this example, the customer got the wrong sales price, therefore the discount amount is entered on a credit cash receipt.

Note: This example corresponds to (Accounting) Enter cash receipts with VAT in system currency. In that example the gross sales price for item 2 was 60.00. It should be 50.00.

Prerequisites

Quantity item 5
Sales price (difference between original/correct) 10
Discount on order line 5%
Order discount on order header 10%
VAT item 25%
The Update stock on hand field in the Sales order type table N

Created transactions

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

Original sales price: 60.00
Correct sales price: 50.00
Sales price on this credit cash order: 10.00

10.00 * 5 = 50.00

Note: The sales price is the difference between the price entered on the original cash sales order and the correct price.

871 Line discount VAT   2.50
Sales price * Quantity * Discount on order line

Original sales price: 60.00
Correct sales price: 50.00
Sales price on this credit cash order: 10.00

10.00 * 5 * 0.05 = 2.5

Same Note as above.

872 Order discount VAT   4.75
((Sales price * Quantity) – (Sales price * Quantity * Discount on order line)) * Order discount on order header

Original sales price: 60.00
Correct sales price: 50.00
Sales price on this credit cash order: 10.00

((10.00 * 5) – (10.00 * 5 * 0.05)) * 0.10 = 4.75

Same Note as above.

960 VAT output of order lines (i.e. VAT amount for the sales value) 10.69  
(Sales value Gross VAT – Line discount VAT – Order discount VAT) * VAT percentage of VAT handling code

(in SEK): (50.00 – 2.50 – 4.75) * 0.25 = 10.6875 rounded to 10.69

862 Invoice rounding difference   0.44
Total net sales value + Fees + Total VAT amount

Total net sales value in SEK: 50.00 – 2.5 – 4.75 = 42.75

Postage: 80

Total VAT amount: 10,69

Total in SEK: 42.75 + 10.69 = 53.44

Invoice total in SEK: 53.00

Coin adjustment in SEK: 53.00 – 53.44 = -0.44

863 CASH Cash box   53.00  

Related topics