Other languages

Optional machine translation through Google Translate. Wording may be inaccurate; consult the reviewed Arabic or English edition for precise information. This is not a Zawid-reviewed translation.

The page address is sent to Google only when you press the button. More languages are available in Google Translate. It opens a new tab under Google’s privacy policy. Google privacy policy

Cash Flow and Reports

Manage Accounts in Multiple Currencies Clearly and Accurately

A number alone is not enough when invoices and payments use different currencies. Preserve original amounts, document exchange assumptions, separate fees, and reconcile each currency without inventing automatic conversion.

Our editorial and review policy · About the product developer

Why does currency become part of every transaction?

In a single-currency account, recording the amount and the other party may be enough. When selling, purchasing, or settling in another currency, however, the amount alone is incomplete. You need the transaction currency, any exchange rate used, the date of that rate, and the currency that actually came in or went out. Omitting one of these details leaves the balance open to different interpretations.

Managing multiple currencies does not mean converting every figure into one currency and forgetting the original. Retain the original amount and show a reporting-currency value under a documented policy. That lets you reconcile a supplier or customer statement in the currency used for the transaction while also reviewing an overall business picture.

Choose a base currency for reporting

The base currency is the reference used for consolidated statements and evaluating the business's results. The choice depends on the operating environment and recording requirements; it does not prevent transactions in other currencies. Document the base currency and do not change it midway through operations without a transition plan and qualified review, because the change affects comparisons and balances.

Also retain a separate currency identity for every cashbox or payment account. Do not combine different banknotes under one cash balance, even if a system shows a converted value. The physical count must reconcile each currency separately.

Establish a policy for the exchange-rate source

Rates change, and buying rates, selling rates, and conversion fees can differ by payment method. Define the source your business uses for each transaction type, when the rate is fixed, and who may change it. The source might be the payment provider, a supplier document, or an approved official source appropriate to the business's requirements.

Do not use a rate remembered from a previous day when the document specifies another. Record the source with the transaction where needed, and do not let each user choose a different rate for the same event.

Do not rewrite the rate of an old transaction

When today's rate changes, do not revise previous sales and purchases to use it. A historical transaction should retain its original amount and the rate adopted when it was recorded. Current reports may revalue an open balance under a separate policy, but that does not erase the original transaction record.

If the historical rate was an entry error, correct it through a documented procedure showing the reason and effect. Do not confuse correcting an error with a normal market movement.

Structure the party's account around the agreement

Decide whether a customer or supplier account is managed in one currency or supports several. If a supplier invoices in a particular currency, retaining their balance in that currency is clearer, with a reference value for reporting. Do not settle in another currency without documenting the agreed rate and how fees are allocated.

Where a system supports multiple currencies for the same party, show a separate balance for each currency. Adding the amounts directly into one number has no meaning before conversion at a specified rate. A total in the base currency can also be shown, provided the valuation date is clear and the figure is identified as a reference value that can change.

Separate cashboxes and bank accounts

Keep a balance for each place holding money and its currency:

  • The local-currency cashbox.
  • A foreign-currency cashbox, where applicable.
  • A bank account in its actual currency.
  • A wallet or payment method in its currency.
  • Money still in transit that has not yet arrived.

When converting one currency into another, record the first currency leaving, the second arriving, the conversion rate, and fees. Do not label the difference as an unexplained expense. Distinguish the provider's fee from the rate difference so the record can be matched to the document.

Record the invoice and payment in their respective currencies

An invoice starts with an amount, currency, and date. If the customer pays in that currency, the payment reduces the balance directly. If they pay in another currency, you need an agreed rate at the payment date to calculate how much of the invoice it settles. Retain the original payment amount, its converted value, and the remainder in the invoice currency.

For partial payments, do not recalculate the settled portion whenever the rate changes. Close that portion at the rate adopted for the payment and keep the remainder in its original currency until the next settlement.

Explain exchange differences instead of hiding them

A change in exchange rate can create a difference between the value recorded for an invoice and the amount required to settle it. If the original amounts and documents are correct, that difference is not a cashbox error. Classify it clearly under the adopted accounting policy, separately from transfer fees and commercial discounts.

Do not use one generic “Difference” entry to combine an input error, rate movement, and fees. Each cause has different evidence and a different review path. If the effect requires specialized tax or accounting treatment, consult the appropriate professional rather than guessing.

Worked example: an invoice and partial payment in two currencies

This is a fictional teaching example using currencies labeled “foreign” and “local.” The figures are not current exchange rates or a recommendation of a rate or formal accounting treatment. Assume the payment currency is purchased and handed to the supplier on the same day, with the business paying the fee.

1. The invoice on March 1 in a hypothetical year

The supplier's invoice is for 100 foreign units. At that time, the reference rate is 10 local units for each foreign unit, giving a reference value of 100 × 10 = 1,000 local units. The supplier balance to reconcile is 100 foreign units, not an unlabeled 1,000.

2. The partial payment on March 8

The business buys 40 foreign units at a new hypothetical rate of 11 local units each and pays a separate fee of 5 local units. The payment breakdown is:

ItemCalculation or basisAmountCurrency
Amount the supplier receivesPayment toward the original 10040Foreign
Cost of buying the payment currency40 × 11440Local
Separate provider feeAs documented in the example5Local
Total cash outflow440 + 5445Local
Remaining supplier balance100 − 4060Foreign

If the local-currency account held 2,000 before the transaction, it now holds 2,000 − 445 = 1,555 local units. The fee does not reduce the supplier balance to 55 foreign units: it was paid to the transfer provider in another currency.

3. Separate the rate comparison from the amount settled

The original reference value of the portion settled was 40 × 10 = 400 local units. It now costs 440 to purchase, giving a difference of 40 local units, separate from the fee of 5. This comparison explains the rate movement. Its accounting classification depends on the business's policy and documents; the example is not automatically a journal entry suitable for every organization.

The open balance of 60 foreign units can be estimated at the new hypothetical rate: 60 × 11 = 660 local units. This is a dated reference value, not a new payment or a change to the old invoice. Reconcile 60 with the supplier statement and 1,555 with the local-currency account statement. Do not add those figures directly.

Apply consistent rounding rules

Conversion can produce more decimal places than a currency displays. Define calculation precision and rounding rules in the system instead of manually rounding every intermediate step and then adding the results. Retain the precision needed for internal calculations and display the appropriate number of decimal places on the final document.

If a small rounding difference appears when closing an invoice, use a clear, limited classification under the settings rather than changing the actual payment. Monitor repeated rounding differences: they may indicate inconsistent settings between invoicing and settlement.

Review reports from two perspectives

A useful report shows:

  • The amount and balance in the transaction currency.
  • The value converted into the base currency.
  • The rate and its date, or the valuation policy used.
  • Conversion fees separately.
  • Exchange differences realized at settlement.
  • A clearly dated reference value for open balances.

Do not compare reports that value balances at rates from different dates without understanding the effect. Keep a path back to the original amount so a consolidated figure does not become an unexplained number.

Close each currency separately

At day-end, count each cashbox in its own currency and reconcile its transactions. Match bank accounts to the amounts actually shown on their statements, then review conversions as two linked movements. Do not use a surplus in one currency to cover a shortage in another during reconciliation.

Review transactions missing a rate or source, payments still marked “in transit,” and partially paid invoices. Any manually entered rate outside the policy needs to be identified and reviewed.

Control permissions and keep a rate record

Changing a default rate may affect many transactions. In systems that provide such controls, limit management of rate sources to the appropriate user and record who approved an exceptional rate and why. Do not allow an invoice currency to change after payments exist without a clear correction procedure.

If your system imports rates automatically, check the update time and what happens when the source fails. It should not silently present the last available rate as current after an unsuccessful update. A clear warning is better than an appearance of precision.

What does this mean when using Zawid Accounts?

In Zawid Accounts, review accounts and transactions in their selected currencies. A customer balance in more than one currency does not imply automatic conversion into a unified total or retrieval of a live market rate. Record original amounts in their currencies, retain the reference for any conversion agreement, and review the payment's effect on the correct account.

The reference calculation above is an external explanatory worksheet. It is not a promise of automatic revaluation, exchange-difference posting, or bank integration in the app. Do not enter 445 local units as a payment of 445 foreign units. If you need a settlement involving two currencies, verify the workflow supported by your version and its effect before saving a real transaction.

Learn about multi-currency customer statements, then review separating cashboxes and currencies so the debt's currency is not confused with where the money is held.

Multi-currency implementation checklist

  • Define the base currency and the currencies actually used.
  • Keep a separate cashbox or account for each currency.
  • Document the exchange-rate source, adoption time, and authority to change it.
  • Always retain the transaction's original amount and currency.
  • Do not change historical transaction rates because today's rate moved.
  • Show a separate party balance for each currency.
  • Record payments in their original currency and connect any conversion to the invoice.
  • Separate conversion fees, exchange differences, and discounts.
  • Apply a consistent rounding rule across workflows.
  • Reconcile every cashbox and account in its actual currency.
  • Review transactions with no rate or an exceptional rate.
  • Show the valuation date for open balances in reports.
  • Restrict changes to currencies and rates after transaction approval where the system supports it.
  • Test an invoice, a partial payment, and a conversion before full operation.

Conclusion

Managing multiple currencies starts with preserving the original facts: the amount, currency, and date. Add a reference value at a documented rate without rewriting history whenever the market changes. Separate cashboxes, balances by currency, and documented fees, exchange differences, and rounding make reconciliation possible. A clear system assigns each difference to its real cause and lets you trace a consolidated report back to its original document.

Useful for someone you know?
Share on WhatsApp