Three amounts for one sale
A sale to a customer abroad produces at least three numbers. The invoice shows an amount in a foreign currency. The bank credit shows a different amount in your own currency, after conversion and often after deductions. And somewhere between them sit fees charged by an intermediary. If you record only the credit, you cannot say what the customer was billed; if you record only the invoice, you cannot say what arrived.
Rules for export documentation, tax treatment of such sales and the evidence expected for foreign receipts come from official sources and vary with the kind of supply. Confirm them with a qualified professional. What follows is about keeping the numbers connected.
The invoice line
Start with the invoice. Record its number, date, the customer’s name and country, the currency and the invoiced amount. For example, an invoice for 1,200 units of a foreign currency, dated the 4th, due in thirty days.
Note any tax statement printed on it, such as a reference to zero-rating or a declaration for export, exactly as the document reads. Do not paraphrase; copy the wording or attach the file.
The receipt line
When the money arrives, the bank will show a credit in your currency along with a reference. Record it as a separate transaction, linked to the invoice number. Add the date, the amount credited and any reference or remittance advice that came with it.
Also record any deduction taken before the credit. Intermediary banks sometimes withhold a fee, and the customer’s bank may add another. A shortfall between invoice and receipt is a fact worth capturing, not hiding.
Reconciling in a small table
| Item | Foreign amount | Own-currency amount |
|---|---|---|
| Invoice raised | 1,200 | Not applicable |
| Credit received | Not shown | 98,400 |
| Implied rate | derived | 82.00 per unit |
| Fees noted | derived | 600 |
A table like this reveals two things quickly: the effective rate you actually received and the fee drag per sale. The rate used here is invented purely for the example.
Why the effective rate matters
The rate printed in a news bulletin is not the rate you got. Your bank applies its own, and fees change the outcome again. Over a year of sales, the gap between the headline rate and the realised rate is a real cost, and a record that shows it per sale lets you compare payment routes.
If two customers pay through different channels, the table will show which route delivers more of the invoice value. That information is worth more than any generic advice about transfer services.
Documents to keep together
Keep a small folder per export invoice containing the invoice, the remittance advice, the bank credit advice if provided, and any shipping or delivery proof relevant to the sale. Name the folder with the invoice number and the customer.
Official requirements for evidence of foreign receipts can be specific, including the kind of statement a bank issues. Ask your bank and your adviser what they provide and what you should request, and do it early, since retrospective requests take time.
Unpaid and part-paid invoices
Foreign invoices can drift. Mark each with a due date and review them weekly. If the credit is smaller than expected, write to the customer promptly with the invoice number and the shortfall, in case their bank deducted charges you can ask them to bear.
Do not close an invoice until the sum received, plus any agreed deductions, matches the invoice value in the way you and the customer have agreed.
Keeping the foreign currency visible
In your tracking app, store the foreign amount in the note, even if the transaction itself is in your own currency. A year-end report by customer then shows both sides, and a currency-wise view is just a filter away.
A routine for each foreign invoice
When an export invoice is raised, set a reminder for the due date and another for a week after. If the credit arrives, record it on the same day and tick the invoice off the open list. If it does not, the second reminder prompts a polite follow-up with the invoice number, the amount and the date.
Over time, you will learn which customers pay promptly and which need nudging. That knowledge, built from dated records, is more reliable than a general impression.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

