Currency deviation and rounding differences in supplier payments

Manage the rate differences, which are the currency deviations, and record the rounding differences in M3 accounts payable.

Outcome

Currency deviations and rounding differences are recorded on the accounts specified. You can review the individual transactions in 'General Ledger. Display Transactions' (GLS210), and the balance in 'GL Balance File. Display' (GLS215).

Accounts payable and the general ledger are updated according to the accounting rule and accounting option specified.

Before you start

Consider these setup elements:
  • You must configure the financial system.
  • You must define the accounting rules with accounting strings for recording currency deviations in 'Accounting Rules. Set' (CRS630):
    • AP20–301: Exchange rate gains
    • AP30–301: Exchange rate gains
    • AP31–301: Exchange rate gains
    • AP32–301: Exchange rate gains
    • AP33–301: Exchange rate gains
    • AP35–301: Exchange rate gains
    • AP20–302: Exchange rate losses
    • AP30–302: Exchange rate losses
    • AP31–302: Exchange rate losses
    • AP32–302: Exchange rate losses
    • AP33–302: Exchange rate losses
    • AP35–302: Exchange rate losses
  • You must define the accounting option 99 for recording rounding differences in 'AP Accounting Option. Open' (APS020).

Currency deviations and rounding differences

Currency deviations and rounding differences may occur when working with accounts payable and accounts receivable, and with journal vouchers in the general ledger.

Recording currency deviation

If a supplier invoice is created in a foreign currency, the amount is automatically exchanged to local currency in the general ledger for internal purposes.

The payment is recorded and allocated to the original invoice in 'Suppl Payment. Enter Manual' (APS120) or 'Suppl Payment Proposal. Open' (APS130). However, a rate difference may remain in the general ledger. This difference is automatically recorded in M3.

Rate differences are recorded according to the accounting rules defined. See the Before you start section.

This table shows an example of currency deviation when an invoice is paid to a foreign supplier in a foreign currency:
Amount type Foreign currency Rate Local currency Currency deviation
Invoiced amount 1.000 8.2 8.200
Paid amount -1.000 8.0 -8.000 -200
Consequently, this table shows the account entries created when recording the paid amount:
Accounting rules Account Debit Credit
* 8.200
Bank 8000
AP30-301 Rate exchange gain 200
The asterisk (*) indicates the account entry based on the supplier invoice.

Recording rounding differences

A small rounding difference may sometimes occur when the invoice eventually is fully paid. This rounding difference occasionally occurs when several partial payments are used to pay an invoice. The rounding difference is automatically recorded according to the accounting string and VAT method specified for accounting option 99.

For manually writing off rounding differences in (APS120), you can use a user-defined accounting option between 20 and 98, if necessary.
Note: You cannot use option 99 for this purpose.

VAT on currency differences

You can calculate VAT on currency differences. In 'FAM Function. Open Details' (CRS406) the parameter 'Currency rate variance' has these alternatives:
  • 1 = No, VAT will not be calculated.
  • 2 = Yes, VAT will be calculated but no document printed.
  • 3 = Yes, VAT will be calculated and a document will be printed showing the currency rate variance and VAT: Only valid for customer receipts.
You can use the parameter 'Currency rate variance' on these accounts payable payment FAM functions:
  • AP20 Manual payments
  • AP30 Payments: Check
  • AP31 Payments: Electronic Giro
  • AP32 Payments: Manual Giro
  • AP33 Payments: Draft
  • AP35 Payments: Direct Debiting
You can create accounting transactions to different VAT accounts depending on if the currency exchange variance is a gain or a loss. The parameter 'Different VAT Accounts' has these alternatives in (CRS406):
  • 0 = No, do not use different VAT accounts on currency gain and loss
  • 1 = Yes, use different VAT accounts on currency gain and loss

If you select alternative 1, the VAT on currency variance is recorded on different accounts if it is a gain or a loss. If the currency variance is a currency gain, the accounting entries are recorded according to accounting types 111 and 112. If the currency variance is a currency loss, the accounting entries are recorded according to accounting types 211 and 212.

The VAT on currency gains or losses and the currency gains or losses transactions are created per invoice and per VAT code.

This table shows the currency deviation where an invoice is paid to a foreign currency:
Amount type Foreign currency Rate Local currency Currency deviation
Invoice amount 1.000 8.2 8.200
Paid amount -1.000 8.0 -8.000 -200
The parameter 'Different VAT Accounts is set to alternative 1 and the VAT rate is 25%. This table shows the created account entries when recording the paid amount:
Accounting rules Account Debit Credit
* 8.200
Bank 8000
AP30-301 Rate exchange gain 160
AP30-111 VAT on currency difference 40
Related topics