Invoice currency and exchange-rate control: preserve the source and the conversion
A practical restaurant control for recording invoice currency, conversion basis, rounding, tax fields, and review evidence without hiding differences.
Currency control begins by preserving what the supplier actually invoiced. Record the invoice currency, each line and document total in that currency, the date fields, and any supplier-stated rate or tax amount. Only then apply the restaurant’s approved conversion policy. A payment may use a different bank rate from the accounting rate; a credit note may arrive later; and rounding at line level can differ from rounding at document level. Those are reconciliation questions, not reasons to overwrite the source. Keep a clear bridge from source amount to converted amount and identify who can approve a departure.
Choose and document the conversion basis
The policy should define the rate source and the relevant date or event for each transaction type. It may distinguish a purchase invoice, receipt, credit note, payment, deposit, or period-end balance. Do not copy a rate from a search result, supplier email, or memory without recording its source and applicability. Show whether the formula multiplies or divides, and keep enough decimal precision during the calculation to reproduce the result before applying the documented rounding rule. If a local tax rule requires a different basis from the accounting conversion, store both decisions with their sources. Current national requirements and adviser review control the final treatment.
- Store the original displayed amount and currency before translating labels, separators, decimal marks, or symbols.
- Record rate source, retrieval or effective date, direction, precision, formula, and rounding method in the conversion evidence.
- Keep invoice, order, accepted receipt, credit, payment, and ledger references together when currency differences can affect matching.
- Flag a rate unavailable, stale, contradictory, or manually overridden instead of substituting an unrecorded number.
- Restrict edits after posting and retain the prior calculation, reviewer, and reason when a correction is required.
Reconcile rounding, tax, and settlement differences
A small difference can arise from line rounding, document rounding, tax calculation, bank settlement, fees, or a rate applied on a different date. First identify the source and stage. Compare source-currency commercial values, the conversion formula, intermediate precision, rounded lines, tax fields, document total, payment evidence, and ledger value. Do not label every residual as an exchange gain or loss, recoverable tax, supplier error, or immaterial amount without the policy and jurisdiction-specific review that supports that classification. When an operator enters an override, require a reason and approval and keep the unadjusted calculation available for comparison.
Clearly labeled illustrative example: one foreign-currency invoice
A restaurant enters this example to test its worksheet. Every currency, amount, date, rate, formula, rounding result, tax field, and status is illustrative and operator-entered; none is a live market rate, supplier fact, applicable tax treatment, payment demand, saving, forecast, or accounting conclusion. Replace all values with the invoice, approved policy, source evidence, and current adviser review.
| Source invoice | Illustrative operator-entered: supplier invoice total USD 1,250.00, with source currency preserved before conversion | Illustrative amount; not a supplier price or demand |
|---|---|---|
| Rate basis | Illustrative operator-entered: local policy test uses 0.92 EUR per USD on an operator-entered reference date | Illustrative rate and date; not a live or universal rate |
| Unrounded conversion | Illustrative operator-entered: USD 1,250.00 × 0.92 = EUR 1,150.0000 before the worksheet’s rounding rule | Illustrative formula; confirm direction and precision |
| Rounded record | Illustrative operator-entered: converted commercial value recorded as EUR 1,150.00 under the stated rounding method | Illustrative rounding only; not an accounting conclusion |
| Review status | Illustrative operator-entered: invoice, receipt, tax fields, rate evidence, payment basis, reviewer, and any residual are recorded separately | Illustrative control status; local policy decides posting |
The illustrative operator-entered bridge keeps USD 1,250.00, the example basis, formula, precision, and rounded EUR 1,150.00 visible. The rate and amounts are examples only; use the approved source and local review before posting.
A repeatable invoice currency-control process
- 1Capture source values. Save invoice currency code, displayed amounts, lines, dates, tax fields, supplier rate, references, and the original document before conversion.
- 2Select approved basis. Apply the local policy’s rate source, relevant date or event, conversion direction, precision, and rounding rule and record the evidence.
- 3Calculate the bridge. Show source amount, formula, intermediate result, line or document rounding, converted amount, and any operator-entered override separately.
- 4Match the transaction. Compare source and converted values with order, accepted receipt, credit, payment, ledger, and tax records and classify residual differences.
- 5Review exceptions. Have an authorised reviewer assess stale or missing rates, overrides, fees, rounding, period, and jurisdiction-specific tax or accounting questions.
- 6Post and preserve. Record the approved result, keep source and calculation evidence, restrict later edits, and link corrections without deleting the prior version.
FAQ
- Which exchange rate should every restaurant use?
- There is no universal rate source or date for every transaction. Define the basis in the restaurant’s approved accounting policy, consider invoice, supply, payment, and local tax requirements, and confirm current questions with the adviser or authority.
- Should I convert the supplier’s tax amount using the same rate?
- Do not assume that. Preserve source tax fields and the commercial conversion, then review the applicable jurisdiction, transaction date, invoice rules, and accounting policy. Tax basis and reporting conversion can require separate documented decisions.
- Why keep more decimals than the displayed total?
- Intermediate precision can make the formula reproducible and help explain differences caused by line or document rounding. Follow the approved precision and rounding rule and show the rounded result separately; never invent hidden precision after the fact.
- How should a payment difference be classified?
- Compare invoice basis, approved accounting rate, bank settlement, fees, payment date, and ledger policy. Record the evidence and ask the responsible accountant whether the residual is an exchange difference, fee, correction, or another category; do not guess.
- Can an operator override a rate?
- Only through a controlled route that records the old calculation, new input, source, reason, approver, date, and effect. An override is an exception to review, not permission to erase the approved basis or the supplier’s original amount.
Keep reading
- Restaurant VAT invoice checklist: verify the fields before recording
A focused checklist for supplier invoices covering identity, dates, quantities, unit prices, discounts, VAT details, references, and national-rule review.
- Restaurant inventory landed cost: build an acquisition-cost worksheet
A practical worksheet for adding freight, handling, non-recoverable tax, discounts, and rebates to restaurant inventory cost without hiding the source invoice.
- Invoice matching issues and how to fix each one
The six ways a three-way match breaks — duplicate invoices, phantom vendors, price drift, quantity gaps, substitution fraud, and statement mismatches.
Browse by category
Want to review your purchasing?
Submit the details and we will confirm which invoices are useful.
Review 3 invoices free