currency, note, wage, real money, brazilian currency
Photo by marcojean20 on Pixabay

Bank Feeds

Part of Multi-currency accounting tools

Reconciling foreign-currency payment fees

Trace a foreign payment from invoice through fee, conversion and payout to the bank while retaining the gross amount.

This is an editorial pen name used by the publication, not a claim of an independently verified personal identity. Original editorial credit: Desk Accounting Practice.

Why foreign-currency payment fees are hard to reconcile

The invoice is raised on one date at one rate; the money lands later at the rate the processor or bank applies. Xero applies exchange rates at posting, but those may not align with the actual conversion rates used by payment processors. The ledger amount and the bank amount diverge.

What arrives is a single net deposit. Behind it sit gross sales from multiple orders, sales tax collected, shipping fees charged to customers, processing fees, marketplace commission, refunds and chargebacks, currency conversion fees, and reserve holds and adjustments. Xero sees one deposit while your accounts need each component separately.

Published rates are not the rate you were given. The RBA states its rates are indications of market value only and may differ from those quoted by foreign exchange dealers and other market sources. The data should not be relied upon for regulatory or commercial purposes.

Map every fee layer before you reconcile

Gateway costs go well past the headline rate. Xero's guide lists six fee types to evaluate: transaction fees, fraud protection fees, token storage fees, monthly account fees, setup fees, and authentication fees. Transaction fees typically run 1.2% to 2.9% plus a fixed amount per transaction.

Cross-border payments add their own stack. Airwallex describes PayPal's structure as a standard rate, a fixed fee, a cross-border surcharge and a currency conversion fee, plus an exchange rate mark-up. Most US business commercial transaction rates sit at 2.99% to 3.49% plus a fixed US$0.49.

The conversion margin often sits off-platform. Living Business notes Stripe pays out in NZD at conversion rates set by Stripe. On the receiving side, ASB charges a 2.1% offshore margin, so one payment can carry a processor margin and a bank margin.

Key Fee Components in Cross-Border Payments (Australia)

  • 1%Cross-Border Surcharge
  • 2.1%Currency Conversion Margin
  • 15Average Time per Payout Reconciliation

Set a consistent exchange-rate policy

Choose one rate source and one rate date, record both, and apply them to every foreign-currency transaction. The realistic options are the processor's conversion rate, your bank's rate, the RBA's published rate, or an internal policy rate set by you.

AASB 121 prescribes how foreign currency transactions and foreign operations are included in financial statements and how statements are translated into a presentation currency. The compiled standard applies to annual periods beginning on or after 1 January 2025 but before 1 January 2027. Earlier application is permitted for periods beginning after 24 July 2014 but before 1 January 2025.

Where AASB 121 gives no explicit guidance, AASB 108 provides the basis for selecting and applying accounting policies. Document the policy so the same rate logic is applied every month, not chosen after the payout arrives.

Understand what the published figure represents. Since 1 July 2008 the RBA's US dollar rate is the WM/Reuters Australian Dollar Fix at 4.00 pm Sydney, rounded to four decimals. Most other currencies are calculated by crossing that rate with the RBA's observations of mid-points of buying and selling rates.

These are indications of market value only and may differ from dealer quotes. A published rate is a reference point, not the amount your bank credited.

Exchange Rate Sources: Key Differences in Australia

  • RBA Published RateIndication of market value only; not used for commercial settlement. Based on WM/Reuters AUD fix at 4.00 pm Sydney (since 1 July 2008). Rounded to four decimals.
  • Bank's Conversion RateMay include a margin (e.g., ASB charges 2.1% offshore margin); differs from RBA rates.
  • Processor's Rate (e.g., Stripe, PayPal)Set by platform; often includes mark-up. Stripe pays out in NZD using its own rate.
  • Internal Policy RateCan be set by business; must be documented under AASB 108 for consistency.

Break a single payout into its accounting lines

Treat the deposit as a bundle, not as income. Webgility lists the typical components of a payout; see the preceding section for the full list.

Post the net figure in the bank and allocate the rest. Debit bank for the net amount, debit each fee and commission account for its share, debit refunds and chargebacks, then credit gross sales, tax collected and shipping charged. The gap between the invoice value at your policy rate and the amount settled is the exchange difference.

Webgility estimates 15 to 30 minutes per deposit to create journal entries that break down each payout component correctly. A typical payout carries seven distinct transaction types behind the one bank line.

Reconcile the invoice to the net payout and record the FX difference

Work from the customer invoice in foreign currency down to the deposit. Start with the gross invoice total. Deduct the percentage transaction fee and any fixed fee, then the conversion margin, then refunds or chargebacks, and add or subtract the exchange difference. The result is the bank credit.

Watch for fee on fee when costs are passed on. Where the 2.9% fee is charged back to the client, Stripe includes the extra 2.9% in the total charged, but you are still charged 2.9% of that added client fee. A fixed transaction fee also comes out of your payout.

Decide where the exchange difference lands and stay consistent. It can be recorded as a foreign exchange gain or loss, or folded into the fee cost of the payment. It should not sit unexplained in a suspense account at year end.

Handle refunds, chargebacks and part-payments in foreign currency

A refund will rarely match the original invoice. Currency conversions are finalised at the time of processing, so the refunded amount converts at a different rate from the amount received. The difference has to be recognised rather than assumed away.

For part-payments, generate a separate invoice for each partial payment instead of amending the original. Manual part-payments through the processor's portal are only available in the US. Where they are used, the client fee must be applied manually or your business bears the full fee out of the payout.

Add wording to the invoice template to prevent bite-back, so a shortfall from currency movement or bank charges is not silently absorbed by you. A client paying from a different currency account can be converted twice, once by the processor and again by their own bank. They should check their bank's charges.

Make reconciliation repeatable

Standardise on one method for processing payments. Living Business recommends this so clients are charged consistently and the reconciliation follows the same route each period. This holds whether payments come through a portal, a processor invoice or an accounting system invoice.

Keep separate accounts in the chart of accounts for transaction fees, conversion margins, cross-border surcharges, marketplace commission, and refunds and chargebacks. Compare each payout's deductions and refunds against the amounts allocated to these accounts, and investigate any unexplained difference.

Automate once volume and fee complexity outgrow manual matching. Webgility puts the comfortable manual zone at fewer than 500 monthly entries, transactions that match cleanly to invoices, processors depositing net amounts with minimal fee complexity, and one currency across one or two channels.

300 orders a day is 9,000 transactions a month, which at 45 seconds each consumes about 112.5 hours of finance time monthly.

Further reading: Exchange Rate Definitions and Sources.

More from Bank Feeds

Bank Feeds

Accounting integrations

Plan accounting integrations around source records, posting rules and reconciliation. Check ecommerce, POS and payroll transfers before automating them.