Reading statement layouts
Read debit and credit columns, original and outstanding amounts, running balances, remittance advice and foreign-currency statements. Check that opening balance plus movements equals closing balance.
Supplier statements use several layouts. You may see debit and credit columns, original and outstanding amounts, or a running balance.
Check the statement arithmetic: opening balance + movements should equal closing balance. You can do this even when the statement is not a simple open-item list.
Some documents combine a statement with a tear-off remittance advice, and some vendors bill in a foreign currency. Work out which part of the page is the statement, and which currency each amount is in, before you match anything.
- Open-item list: One amount column and no running balance. This is a straightforward open-item list.
- Debit and credit columns: Charges appear in the debit column; payments and credits appear in the credit column.
- Original and outstanding amounts: Match the outstanding amount, not the original invoice amount.
- Running balance: Invoices and payments appear on separate lines, with a running balance after each line.
- Remittance advice: The remittance lines confirm payments already recorded elsewhere. Match only the statement lines to your open AP.
- Foreign currency: Convert before you compare. Foreign amount × exchange rate = local amount.
Match a debit and credit statement
This statement shows charges in the Debit column and payments or credits in the Credit column. Match the six invoice charges to their open AP entries.
Click a statement line, then click an AP line to pair. Click a pair badge to unlink. The statement and AP extract may use different layouts.
Coastal Electrical Wholesale
3 Harbour Rd, Fremantle WA 6160
Statement date: 2026-06-09
Vendor statement(Balance-forward, debit and credit)
AP / ERP extract
Match the amount still outstanding
Use the outstanding amount when matching, not the original invoice total. The original amount is shown only to explain the invoice history.
Click a statement line, then click an AP line to pair. Click a pair badge to unlink. The statement and AP extract may use different layouts.
Granite Ridge Quarries
210 Quarry Rd, Lysterfield VIC 3156
Statement date: 2026-06-07
Vendor statement(Open-item, original and outstanding amounts)
AP / ERP extract
Use payments to explain the running balance
A rolling statement can show an invoice and its payment on separate lines. When the payment names the invoice, combine them before comparing with AP. INV-7101 for $1,000 less PMT-7101 for $400 leaves $600 outstanding. Match the invoice line to AP and use the payment line to explain the remaining balance.
Click a statement line, then click an AP line to pair. Click a pair badge to unlink. The statement and AP extract may use different layouts.
Summit Plant Hire
17 Depot Ln, Wacol QLD 4076
Statement date: 2026-06-14
Vendor statement(Balance-forward, rolling balance)
AP / ERP extract
Rebuild the closing balance
Work out the closing balance three times, once for each month. Stage 1 is fully worked as an example. In stage 2 you calculate the final running balance yourself, and in stage 3 the final two. Each stage has its own figures, so work from that stage's amounts.
Stage 1 — fully worked
- Opening balance from last month’s reconciliation18420.0018420.00
- + Invoices received this month6250.0024670.00
- − Payments made this month-5100.0019570.00
- − Credit notes received this month-380.0019190.00
Checkpoint — four statement layouts down
You've now read a plain open-item list, a debit/credit layout, an outstanding-vs-original layout, and a rolling-balance layout. You've also checked that the opening balance plus movements equals the closing balance. Next: a statement with a tear-off remittance advice, and a foreign-currency statement.
Separate statement lines from remittance advice
This document contains a 'Month End Statement' and a tear-off 'Remittance Advice'. Match the statement lines to open AP. The remittance lines only confirm payments already recorded elsewhere, so leave them unmatched.
Click a statement line, then click an AP line to pair. Click a pair badge to unlink. The statement and AP extract may use different layouts.
Archerfield Plant Hire Co
1 Tear-off Ct, Archerfield QLD 4108
Statement date: 2026-06-15
Vendor statement(Statement with remittance advice)
AP / ERP extract
Match a foreign-currency statement
The vendor bills in USD, while your ledger records AUD. Convert the statement amount before comparing it with AP: foreign amount × exchange rate = local amount.
Click a statement line, then click an AP line to pair. Click a pair badge to unlink. The statement and AP extract may use different layouts.
Pacific Import Components Inc
500 Harbor Blvd, Long Beach CA 90802, USA
Statement date: 2026-06-09
Vendor statement(Multi-currency statement)
AP / ERP extract
Statement Zen Academy Team — Practical guidance based on Statement Zen's vendor statement reconciliation work. · Last updated