Accounts/allocation tab in FINANCIAL INTERFACE
Contents
Topic in the order
Basic data
Field description
Field | Function in the order |
---|---|
Change in account assignment | The account assignment field can only be edited if the change in account assignment has been activated in the basic data. This is also connected to the voucher type and the corresponding impersonal account movements that are configured in the basic data. |
Allow change allocation for voucher type draft | Release of the field Allocation in invoicing on the Voucher header data tab if voucher type = Draft. |
Allocation: | Here you can select whether the amount is to be booked as expense or revenue in financial accounting. |
Round up difference | Rounding differences in tax amounts in the ingoing invoicing are used for collective invoices. The maximum value is limited to 99.999.999.999,99 (= (decimal (13,2)). If the tax amounts differs within this difference, the invoicing is booked. Otherwise the system issues the following CargoSoft message: ATTENTION: If an incorrect tax amount that is within this difference is accidentally entered in the incoming invoice, the invoice is posted. It is also possible to post differences to an account - this depends on financial accounting. |
Calculate total tax amount: | See below in tax amount rounding. |
Sum preserving rounding on single tax amount: |
Further information about tax amount rounding
Total tax amount
Calculate total tax amount - Receivable and Calculate total tax amount - Payable.
The dropdown menus control the way taxes are invoiced in the outgoing and incoming invoicing.
The following methods are available:
000 | Calculate tax amount per billing line, sum up tax amounts, round off the total (default). |
---|---|
001 | Caculate tax amount per billing line and round off, them sum up total tax amount. |
002 | Calculate tax amount per billing line, use <Compensated summation>. |
003 | Calculate tax amount per billing line, sum up per tax code, round off per VAT code total. |
004 | Calculate tax amount per billing line,sum up per %-value, round off per %-value total. |
005 | Sum up taxable invoice amounts per tax code, round off then add up tax amounts. |
006 | Sum up taxable invoice amounts per %-value, round off then add up tax amounts. |
007 | Sum up taxable invoice amounts per tax code, add up then round off tax amounts. |
008 | Sum up taxable invoice amounts per %-value, add up then round off tax amounts. |
→ A list of sample calculations can be found below.
Single tax amount
Sum preserving rounding on single tax amount - Receivables and Sum preserving rounding on single tax amount - Payables.
These two flags control whether the calculated values will be saved with 6 decimal places for the sum preserving rounding.
Please activate this checkbox if you are using the sum preserving rounding.
→ These checkboxes may also be activated if the values are to be proof printed on reports.
Sample calculations
000 - Calculate tax amount per billing line, sum up tax amounts, round off the total (default)
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% | = 1.6646 |
---|---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% | = 4.3510 |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% | = 0.9555 |
Sum tax keys: 1.6646 + 4.3510 + 0.9555 = 6.9711 – rounded: 6.97 |
Â
001 - Caculate tax amount per billing line and round off, them sum up total tax amount
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% | = 1.6646 | Rounded: 1.66 |
---|---|---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% | = 4.3510 | Rounded: 4.35 |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% | = 0.9555 | Rounded: 0.96 |
Sum tax keys: 1.66 + 4.35 + 0.96 = 6.97 |
Â
002 - Calculate tax amount per billing line, use <Compensated summation>
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% | = 1.6646 | Rounded: 1.66 |
---|---|---|---|---|
Take difference to the next line: 1.6646 – 1.66 = 0.0046 | ||||
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% | = 4.3510 + 0.0046 = 4.3556 | Rounded: 4.36 |
Take difference to the next line: 4.3556 – 4.36 = -0.0044 | ||||
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% | = 0.9555 – 0.0044 = 0.9511 | Rounded: 0.95 |
Sum tax keys: 1.66 + 4.36 + 0.95 = 6.97 |
Â
003 - Calculate tax amount per billing line, sum up per tax code, round off per VAT code total
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% | = 1.6646 |
---|---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% | = 4.3510 |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% | = 0.9555 |
Sum tax key 7EU: 1.6646 → rounded: 1.66 | |||
Sum tax key 19%: 4.3510 → rounded: 4.35 | |||
Sum tax key 7:      0.9555 → rounded: 0.96 | |||
Sum tax key (total): 1.66 + 4.35 + 0.96 = 6.97 |
Â
004 - Calculate tax amount per billing line,sum up per %-value, round off per %-value total
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% | = 1.6646 |
---|---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% | = 4.3510 |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% | = 0.9555 |
Sum of all tax keys with 7%:   1.6646 + 0.955 = 2.6201 → rounded: 2.62 | |||
Sum of all tax keys with 19%:               4.3510 = 4.3510 → rounded: 4.35 | |||
Sum tax keys (total): 2.62 + 4.35 = 6.97 |
Â
005 - Sum up taxable invoice amounts per tax code, round off then add up tax amounts
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% |
---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% |
Sum tax key 7EU: 23.78 → rounded: 23.78 → 7% → 1.6646 → rounded: 1.66 | ||
Sum tax key 19%: 22.90 → rounded: 22.90 → 19% → 4.351 → rounded: 4.35 | ||
Sum tax key 7:     13.65 → rounded: 13.65 → 7% → 0.9555 → rounded: 0.96 | ||
Sum tax keys (total): 1.66 + 4.35 + 0.96 = 6.97 |
Â
006 - Sum up taxable invoice amounts per %-value, round off then add up tax amounts
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% |
---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% |
Sum of all tax keys with 7%: 23.78 + 13.65 = 37.43 → rounded: 37.43 → 7% → 2.6215 → rounded: 2.62 | ||
Sum of all tax keys with 19%: 22.90 → rounded: 22.90 → 19% → 4.351 → rounded: 4.35 | ||
Sum tax keys (total): 2.62 + 4.35 = 6.97 |
Â
007 - Sum up taxable invoice amounts per tax code, add up then round off tax amounts
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% |
---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% |
Sum tax key 7EU: 23.78 → 7% → 1.6646 → rounded: 1.66 | ||
Sum tax key 19%: 22.90 → 19% → 4.351 → rounded: 4.35 | ||
Sum tax key 7:     13.65 → 7% → 0.9555 → rounded: 0.96 | ||
Sum tax keys (total): 1.66 + 4.35 + 0.96 = 6.97 |
Â
008 - Sum up taxable invoice amounts per %-value, add up then round off tax amounts
Bill. code 1 – 23.78 | Tax key: 7EU | 23.78 * 7% |
---|---|---|
Bill. code 2 – 22.90 | Tax key: 19% | 22.90 * 19% |
Bill. code 3 – 13.65 | Tax key: 7 | 13.65 * 7% |
Sum of all tax keys with 7%:   23.78 + 13.65 = 37.43 → 7% → 2.6215 → rounded: 2.62 | ||
Sum of all tax keys with 19%:                             22.90 → 19% → 4.351 → rounded: 4.35 | ||
Sum tax keys (total): 2.62 + 4.35 = 6.97 |