Tax calculation

Tax on sales invoices

The tax on sales invoices, which are created in the Sales Invoices (tfacr1110s000) session, can be calculated at two different levels:

  • The invoice header level
  • The transaction line level

You can use the tax at invoice header level, if only one tax type applies to the invoice. If there are several tax types, you must define the tax by transaction line.

You can define the level of tax calculation for each invoice in the Level of Tax Calc. field of the Sales Invoices (tfacr1110s000) session. You can define the default value in the ACP Parameters (tfacp0100m000) session.

If you select tax calculation at invoice header level in the Sales Invoices (tfacr1110s000) session, you can enter:

  • a tax country
  • a tax code
  • a tax amount

LN calculates a default tax amount that is based on the total invoice amount, the tax country, the tax code, and the invoice's document date. If you do not enter a tax code, the tax amount automatically becomes zero and cannot be changed.

If you select tax calculation at transaction line level in the Sales Invoices (tfacr1110s000) session, you must enter a tax country at invoice header level. However, you cannot enter a tax code or a tax amount. You must enter a tax code and a tax amount separately for each transaction line in the Sales Invoice Transactions (tfacr1111s000) session. LN calculates the total tax amount for the invoice based on the separate tax amounts that are entered for the transaction lines. After entering the transactions, you can view the total tax amount in the Tax Amount field of the Sales Invoices (tfacr1110s000) session.

The default tax amount is calculated based on:

  • The invoice amount (this amount can be net or gross, depending on the value of the Amounts Entered in Financials field in the Tax Codes by Country (tcmcs0136s000) session.
  • The tax country
  • The tax code
  • The document date

In the Tax Codes by Line (tfgld1109m000) session, you can specify the tax amounts. If singular tax is used, only one line is shown. If multiple tax is used, you can specify the tax amounts for each transaction line.

Shifted tax

Shifted tax is kept aside and is not included in the total tax amount. The shifted tax amount is posted to a tax account. Simultaneously, a reverse entry is generated on a tax contra-account. In the tax analysis the amount is included twice:

  • As an entry on the tax account.
  • As a reverse entry on the tax contra-account.

Shifted tax is used in The Netherlands in relation to legislation concerning the responsibility for payment of taxes and social security contributions (invoices from subcontractors to the main contractor). Shifted tax can be used in the European Union for purchase invoices from other EU countries. Such invoices do not state tax, but when posting the invoices you must calculate a fictitious tax amount (against the national tax rate), which is included on the tax report as chargeable and payable.

Tax on purchase invoices

The tax on purchase invoices, which are created in the Purchase Invoice Entry (tfacp2600m000) session, can be calculated at two different levels:

  • The invoice header level
  • The transaction line level

You can use the tax at invoice header level, if only one tax type applies to the invoice. If several tax types apply, you must define the tax by transaction line.

You can define the tax-calculation level by using the Level of Tax Calculation field in the Purchase Invoice Entry (tfacp2600m000) session. The default value of this field depends on the parameter settings for the Accounts Payable module.

If the tax calculation level is at invoice-header level, you can enter a tax code and a tax amount in the Purchase Invoice Entry (tfacp2600m000) session. LN enters a default tax amount that is based on:

  • The gross invoice amount
  • The tax country
  • The tax code
  • The invoice's document date

The incorrect default tax amount appears whenever:

  • the tax code entered is a multiple or singular tax, and
  • a rate for excess amounts has been defined in the Single Tax Rates (tcmcs0132m000) session. The amount entered in the Amount field is always gross amount, including the tax. Tax is filtered from this amount based on the tax rates and is displayed by default in the Tax Amount in Payment Currency field. This amount can be changed if desired.

If you do not enter a tax code, the tax amount automatically becomes zero and cannot be changed.

You must enter the tax code and the tax amount by transaction line in one of the following sessions:

  • The Purchase Invoice Transactions (tfacp1120s000) session, if a cost invoice is concerned.
  • The Tax Transactions (tfacp1112m000) session, if an invoice that is related to orders is concerned. This session can only be activated if the invoice is related to orders and the level of tax calculation is equal to transaction line level.

After you exit one of these sessions, LN calculates the total tax amount, which is displayed in the Purchase Invoice Entry (tfacp2600m000) session.

Note

If multiple tax is used, you can specify the tax amounts for each transaction line in the Tax Codes by Line (tfgld1109m000) session. The Tax Codes by Line (tfgld1109m000) session can be activated when the level of tax calculation equals the header.

If expense tax is used, the tax amounts are reclassed during approval:

  • If there is an exemption on the order the full tax amount is reclassed to the tax variance account in the ACP Parameters (tfacp0100m000) session.
  • If there is no exemption code on the order the tax amount of the order is reclassed to the debit account of the integration transaction (see integration mapping scheme) purchase-expense tax. The credit account of this integration purchase-expense tax is not used. The difference between order and invoice is posted to the variance account.

There are also reversals of tax which is posted during registration, if the tax code of the invoice and the order are different. Then the whole tax of the invoice is reclassed in case of expense tax only. During approval the tax is posted again, but now using the tax code of the order.

If cost items are concerned and the item group equals one of the item group specified in the Item Groups (tcmcs0123m000) session, the tax of this cost item is reclassed to the account that is entered via the Matched Purchase Invoice/Statement Line Transactions (tfacp1133s000) session, which you can start via the Cost Item command of the Specific menu of the Match Purchase Order Lines (tfacp2541m000) session. So not to the debit account of expense purchase tax of the integration mapping scheme: this debit account is only used for purchased items, and for cost items which do not have the item groups specified in the Item Groups (tcmcs0123m000) session equal to the item group of the cost item. And in other cases not to the original cost account.

Tax on advance payments

In some countries tax is charged on advance payments/receipts, which exceed a certain minimum amount. If you want to charge tax on advance payments/receipts, you must select the Calculate Tax on Advance Payments/Receipts check box in the CMG Parameters (tfcmg0100s000) session. You must also enter the minimum amount in the Minimum Amount for Tax Calculation field of the CMG Parameters (tfcmg0100s000) session.

If an advance payment is made or received, you can specify a tax amount in these sessions:

  • Bank Transactions (tfcmg2500m000)
  • Anticipated Payments (Details) (tfcmg2116s000)
  • Anticipated Receipts (Details) (tfcmg2117s000)

LN enters the singular tax amount on the Account for Tax on Advance Payments ledger account and the Account for Tax on Advance Receipts ledger account. You can define these ledger accounts in the Posting Data for Tax Codes (tfgld0171s000) session.

LN enters the multiple tax amount on the Account for Tax on Advance Payments ledger account and the Account for Tax on Advance Receipts ledger account. You can define these ledger accounts in the Posting Data for Multiple Tax Codes (tfgld0170s000) session.

Tax on settled discounts

In some countries the charged tax is settled, for example, when a cash discount is deducted from an invoice. If you select the Adjust Tax for Deductions check box in the CMG Parameters (tfcmg0100s000) session, the tax amount for anticipated payments is adjusted in case of:

  • A discount
  • A late payment
  • Payment differences

You can define the step at which settlement must take place in case of anticipated payments in the Posting Data by Bank/Payment Method (tfcmg0146s000) session.