Accounts Payable and Receivable VAs

Review Multi-Currency Vendor Balances

A QuickBooks Online review for foreign-currency bills, payments, exchange differences, and the vendor balances that never seem to settle.

Review Multi-Currency Vendor Balances blog thumbnail
multi-currencyvendor balancesaccounts payableQuickBooks Online
On this page Jump to section

BLUF: Multi-currency payables fail at the edges: a payment recorded at a different rate, a credit note left in the vendor's currency, or a balance that will not zero because two entries use different exchange rates.

A QuickBooks VA can review these balances and prepare a clean packet. The accounting decision stays with the owner or bookkeeper.

Separate the two balances

Every foreign-currency vendor has a balance in the transaction currency and a home-currency equivalent. The vendor statement speaks in their currency; the general ledger speaks in yours.

Start with the vendor's statement in their currency. Match bills, credits, and payments. Only after that balance agrees should you look at the home-currency value.

Do not try to reconcile both at once. Rate movements make the home-currency balance move for reasons unrelated to the vendor's records.

List the open items in the vendor currency

Export the open bills and credits with the transaction currency, amount, exchange rate, and date. Add the payments applied to each.

The target is simple: open bills minus credits minus payments should equal the vendor statement balance. If it does not, identify the item that is missing, duplicated, or applied to the wrong bill.

Common causes include a payment entered against the wrong bill, a credit note not applied, and a bill entered twice in different currencies.

Check the rate on each entry

Each bill and payment carries an exchange rate. A payment recorded at a materially different rate from the bill leaves a residual balance even when the foreign-currency amounts match exactly.

Record the rate used on both sides. A difference of a few cents is normal; a difference that creates a visible residual is worth investigating before the next payment.

If the rate is wrong, correct it through the proper exchange-difference process rather than editing the original transaction without approval.

Handle credits and prepayments

A vendor credit in a foreign currency can sit unapplied for months. Apply it to the right bill and confirm the remaining balance.

Prepayments create the same problem in reverse. A deposit paid in advance may be recorded as a payment without a bill, then matched later at a different rate.

List these items separately. They are not errors, but they need an owner and a matching plan.

Prepare the exchange-difference packet

When the foreign-currency balance is zero and the home-currency balance is not, the difference is an exchange gain or loss. Prepare a calculation showing the bill rate, the payment rate, the home-currency amounts, and the resulting difference.

Attach the vendor statement and the payment confirmations. Ask the owner or bookkeeper to approve the posting and the account.

Never post the difference to the vendor balance to make it zero. That hides the rate issue and distorts the payable.

Report on open exposure

A monthly summary by currency is useful: total open payables, value in home currency, and the largest items by age. It shows the owner where rate movement matters.

Note any vendor with a balance that has not changed in two cycles. A stale foreign-currency balance is often an unapplied credit or a missing payment.

Boundaries

The assistant does not set exchange rates, choose the accounting policy for gains and losses, or approve payments. The assistant keeps the comparison, the evidence, and the exceptions in one place so the accounting decision is quick and documented.

QuickBooks VA workflow table

Workflow areaWhat the VA prepares
Daily queueInvoices, receipts, bank feeds, and open QuickBooks questions
Weekly reviewOwner approvals, exception list, and unresolved transaction notes
Monthly packetReports, missing documents, and accountant-ready source material

Related resources

Compare the service fit on the QuickBooks VA services page, then use the free consultation form to map the first handoff. For platform context, review QuickBooks Online.

FAQ

Why does a vendor balance change without a new bill?

Exchange-rate movement and payments recorded at a different rate change the home-currency value of an open foreign-currency balance.

Can a VA post the exchange difference?

The VA can prepare the calculation and evidence. The owner or bookkeeper should approve the posting and the account used.

Keep reading

Related QuickBooks VA guides

Browse blog
Catch Duplicate Bills Before They Get Paid thumbnail

Accounts Payable and Receivable VAs

Catch Duplicate Bills Before They Get Paid

Published October 22, 2026

Most duplicate bill payments are visible in the file for weeks before the money leaves. A short review catches them without slowing the payment run.

accounts payableduplicate billsbill reviewQuickBooks Online