The following describes the accounting transactions the system creates when you invoice project transactions, which can be project activities, project services or items issued to project.
Prerequisites
The following values are used in the transaction calculations for the purpose of this example:
Variable | Value |
---|---|
Project transaction price | 50 |
Project transaction quantity | 12 |
Discount on order line | 5% |
Line discount VAT | 30 |
VAT | 25 % |
Postage | 80 |
VAT output of order lines | 142.50 |
VAT postage | 20 |
Total net sales value | 650.00 |
Total VAT amount | 162.50 |
Total | 812.50 |
Invoice total | 813.00 |
Created transactions
The following transactions are created when a project transaction is invoiced:
Transaction type | Description | Amount Debit |
Amount Credit |
Additional info |
---|---|---|---|---|
750 | Sales value VAT proj final | 600.00 | ||
751 | Line disc. VAT proj final | 30 | ||
960 | VAT output of order lines | 142.50 | ||
827 | Postage VAT | 80 | Postage fee | |
961 | VAT output of order | 20 | VAT amount of postage fee | |
802 | Coin adjustment | 0.50 | ||
A/R | Invoice total | 813.00 | To be accounted on Account Receivable |
Note: Transaction type 802 is a coin adjustment. In the Currency table for the SEK currency, the Adjust inv amount field is 1.00, which means that invoice amounts should always be rounded off to the nearest even Swedish krona.
Calculations
The following equations outline how the values in this example have been calculated:
Calculated value | Equation | Calculation |
---|---|---|
Sales value gross VAT | Project transaction price * Project transaction quantity | 50.00 * 12 = 600.00 |
Line discount VAT | Project transaction price * Project transaction price * Discount on order line | 50.00 * 12 * 0.05 = 30.00 |
VAT output of order lines | (Sales value Gross VAT – Line discount) * VAT percentage of VAT handling code | (600.00 – 30.00) * 0.25 = 142.50 |
VAT postage | Postage * VAT | 80.00 * 0.25 = 20.00 |
Total VAT amount | VAT output of order lines + VAT postage | 142.50 + 20.00 = 162.50 |
Total net sales value | Sales value Gross VAT – Line discount VAT | 600.00 – 30.00 = 857.00 |
Total | Total net sales value + Postage + Total VAT amount | 570.00 + 80.00 + 162.50 = 1041.25 |
Coin adjustment | Invoice total – Total | 813.00 – 812.50 = 0.5 |
Related topics
- Overview of accounting transactions for project order transactions
- (Accounting) Issue material for a project order
- (Accounting) Report services for a project order
- (Accounting) Report activities for a project order
- (Accounting) Receive purchased items for a project order
- (Accounting) Receive manufactured items for a project order
- (Accounting) Close a project phase
- (Accounting) Invoice a project invoice plan