When working with currencies, the values will need to be output into the documents that are sent to the client (the invoice) and the payee (payslip). Additional fields relating to currencies in the payslip and invoice formats have been made available to add to the document layout if multi currency has been enabled.
The sections below describe the additional fields and in which component the currency fields can be found.
Invoices
Component | Data Item | Comments |
Invoice Items | Currency Billing Fee Taxation Total Currency Billing Fee Total Currency Rate Currency Sub Total Taxation Currency Taxation Total Currency Total Charge Ex. Tax Currency Total Inc. Tax Currency Total Ex. Tax | The currency conversion value of the tax calculated on the billing fee. The currency conversion value of the billing fee. The currency conversion of the bill rate. The currency conversion of the tax on the invoice item excluding the currency billing fee. The total of Currency Sub Total Taxation plus Currency Billing Fee Taxation Total The invoice item currency conversion total plus the currency conversion billing fee. Currency Total Ex. Tax plus Currency Sub Total Taxation. The currency conversion value of Invoice Item Total (Currency Rate x Quantity) |
Invoice Header | Exchange Rate Exchange Rate Date Debtor Currency Code Currency Invoice Total | Exchange rate used in the invoice The exchange rate date The currency code used in the conversion The currency conversion value of the invoice total |
Invoice Totals | Debtor Currency Code Exchange Rate | These values will repeat against each invoice total that is output. |
Payslips
Component | Data Item | Comments |
Payee Details Payslip Header | Payee Payment Currency Exchange Rate Exchange Rate Effective Date Current Net Amount Currency Current Net Plus VAT Amount Currency | The payee's currency used to convert the net pay in the pay batch. The exchange rate used in the pay batch. The effective date of the exchange rate used in the pay batch. The converted net pay amount. The net play plus the VAT amount currency conversion. |
Payment Details | BIC IBAN Amount in Payment Currency |
Net Pay | Exchange Rate Exchange Rate Effective Date Payee Currency Code Currency Net Amount Currency Current Net Plus VAT Amount Currency | The exchange rate used in the pay batch. The effective date of the exchange rate used in the pay batch. The payee's currency used to convert the net pay in the pay batch. The converted net pay amount. The net play plus the VAT amount currency conversion. |