Accounts/allocation tab in FINANCIAL INTERFACE


Contents

Topic in the order

Basic data


image-20240404-153935.png

Field description

Field

Function in the order

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:
incoming credit note,
outgoing credit note,
incoming invoice,
outgoing invoice

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.
→ These should be set to the minimum.

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:
Receivable,
Payable



See below in tax amount rounding.

Sum preserving rounding on single tax amount:
Receivables,
Payables

Further information about tax amount rounding

image-20240404-154015.png

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