Skip to content

Dual-currency invoices

Priced in dollars, payable in rand: book the figure you owe.

Many southern African suppliers, clearing agents and forwarders price their lines in US dollars or euros, then print the amount to pay in rand or Namibian dollars in a final box such as “TOTAL INVOICE AMOUNT PAYABLE”. That is two totals on one page, in two currencies, and only one of them belongs in your books. Take the first total on the page and you book the wrong currency; convert it yourself and you book a figure the supplier never asked for.

The payable box decides the total

When an invoice prints its amount to pay in a final box, InvoiceParser Pro stores that figure, in that box’s currency, as the invoice total. It is what you owe, so it is what you review, approve and export.

Where the page text is available, the box is read from the page itself, not left to the AI model alone: the figure printed right after the “TOTAL AMOUNT PAYABLE” label, with its currency code or symbol and its sign. The subtotal becomes the payable amount less the VAT when no discount, shipping or fee line is in play, and the invoice carries a note for the reviewer naming what changed.

It holds back when the page is ambiguous. If a payment line was read, or the page prints two payable boxes, the box is left alone and the invoice is reviewed as read.

The rule follows the box, not a list of currency pairs. The ones a southern African AP desk sees most:

  • US dollar lines, payable in South African rand.
  • Euro lines, payable in Namibian dollars.
  • US dollar lines, payable in Namibian dollars.

The other total is kept, not thrown away

The total in the line-item currency, the USD or EUR figure, is stored with the invoice as a secondary total with its own currency. It comes out in the full Excel and CSV export, and on paid plans it can be added as a column to a custom CSV template. The review screen shows the payable figure.

Some invoices print a column of amounts in the payable currency beside the dollar prices, under a header such as “Amount ZAR”. When that column adds up to the subtotal to the cent, and the line items as first read do not, IPP uses that column for the line items and keeps each line’s description.

Checks that understand two currencies

The arithmetic check only compares figures in the same currency. When the lines are printed in the line currency, they are checked against the line-currency total, or its share before VAT when that total includes VAT, and never against the rand or N$ payable figure. When no line-currency total is known, that comparison is skipped rather than made across two currencies.

The payable total still has to add up: subtotal − discount + shipping + fees + tax = total. A total that is printed nowhere on the page lowers the invoice’s confidence, so a figure the reading worked out for itself does not pass as one the supplier printed.

Settling it later

If a foreign-currency bill is paid at a different rate from the one on the day it was billed, both rates can be recorded beside the invoice: the billing rate and the settlement rate, with the difference shown as higher, lower or unchanged. Neither changes the invoice, and neither is sent to your accounting system. The guide to costing a cross-border load walks through it.

What it does not do

  • It does not convert one total into the other or pick an exchange rate for you. The two totals are never added together.
  • The secondary (line-currency) total is not shown on the review screen; it is in the exports.
  • An invoice that prints two payable boxes, or a payment line, is not adjusted automatically. Review it as read.
  • Xero and Zoho Books pushes do not set VAT tax codes yet; QuickBooks Online bills can carry VAT on your own tax codes for a VAT-registered workspace.

Questions buyers ask

Which total does IPP book on an invoice priced in USD and payable in ZAR?

The amount in the payable box, in its currency: rand, in this case. The US dollar total is kept with the invoice as a secondary total and comes out in the full export.

Will the dollar line items fail the arithmetic check?

No. Lines printed in the line currency are compared with the line-currency total, not the rand or N$ figure. If no line-currency total is known, that comparison is skipped rather than made across currencies.

Does IPP convert between the two currencies?

No. It keeps the figures the supplier printed. If you settle at a different rate, you can record the billing and settlement rates beside the invoice without changing it.

Does the same work for euro invoices payable in Namibian dollars?

Yes. The rule follows the payable box, whichever currency the lines are priced in and whichever currency the box prints.