Module 4: Statement layout fluency

Debit/credit, original vs outstanding, rolling balance — no Excel. · ~50 min

Progress this module: 0/12 required labs passed

Real statements are not always a simple open-item list. Learn to read debit/credit, original vs outstanding, and rolling-balance layouts.

Prove the statement conceptually: opening balance + movements should equal closing balance — without building a spreadsheet in this course.

S1: one amount column, no running balance or original-vs-outstanding split — the plain open-item list.
S2: charges in debit, payments/credits in credit.
S3: match on outstanding, not original.
S4: invoice and payment on separate lines with a running balance.
S5: a large opening balance carries the historical detail with no per-invoice breakdown behind it — accept the scope boundary, do not force a line-level match against history you were never given.
S6: credits and short-pays can sit alongside invoices with the same-looking numbers — bucket by WHO initiated the adjustment (a vendor-issued credit vs. your own short-pay), not by the amount alone.

Lab 4.1 — Debit/credit statement

This statement uses debit (charges) and credit (payments/credits) columns. Match the six clear charge lines to open AP.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S2 × L1.

Coastal Electrical Wholesale

3 Harbour Rd, Fremantle WA 6160

Statement date: 2026-06-09

Vendor statement(S2 — balance-forward, debit/credit)

AP / ERP extract

Lab 4.2 — Original vs outstanding

Match on outstanding (open) amount — not the original invoice total. Original is shown for context.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S3 × L1.

Granite Ridge Quarries

210 Quarry Rd, Lysterfield VIC 3156

Statement date: 2026-06-07

Vendor statement(S3 — open-item, original vs outstanding)

AP / ERP extract

Lab 4.3 — Rolling balance

Invoice and payment appear on separate lines with a running balance. Match open invoice lines to AP. Leave payment rows unmatched against open AP invoices.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S4 × L2.

Summit Plant Hire

17 Depot Ln, Wacol QLD 4076

Statement date: 2026-06-14

Vendor statement(S4 — balance-forward, rolling balance)

AP / ERP extract

Lab 4.4 — The OB + movements = CB proof (worked ladder)

Work through the same reconciliation proof three times. Stage 1 shows every step worked in full. Stage 2 blanks the FINAL step — you compute it. Stage 3 blanks the final TWO steps. Each blanked value must tie out arithmetically against the running total above it — there's no separate answer key, just the math.

Stage 1 — fully worked

Opening balance (per last month's reconciliation)18420.00
+ Invoices received this month24670.00
− Payments made this month19570.00
− Credit notes received this month19190.00

Stage 2 — final 1 step blank

Opening balance (per last month's reconciliation)18420.00
+ Invoices received this month24670.00
− Payments made this month19570.00
− Credit notes received this month

Stage 3 — final 2 steps blank

Opening balance (per last month's reconciliation)18420.00
+ Invoices received this month24670.00
− Payments made this month
− Credit notes received this month

Lab 4.5 — Layout ID speed round

Answer every question, then check. Pass bar is shown after submit.

1. Simple list: Invoice #, date, amount outstanding only → which archetype?
2. Two amount columns: Original and Outstanding → which archetype?
3. Debit and Credit columns; payments as credits → which archetype?
4. Invoice line then payment line; Balance column runs → which archetype?
5. Huge Opening Balance with many aged items before current invoices → which archetype?
6. Credits and short-pays interleaved with invoices → which archetype?

Lab 4.6 — Large opening balance, no invoice detail (S5)

This vendor's statement opens with a large carried-forward balance and no per-invoice breakdown behind it — you were never given that history. Classify every leftover. Do not invent MISS_ERP lines to explain the opening balance.

Select a card, then click a bucket. Timing and report-flavour mistakes that look like “missing” are critical fails.

Lab 4.7 — Mixed credits and short-pays (S6)

Same-looking numbers, different bucket — the question is WHO initiated the adjustment, the vendor or you. Classify every leftover.

Select a card, then click a bucket. Timing and report-flavour mistakes that look like “missing” are critical fails.

Lab 4.8 — New-vendor first statement (S7)

This is the FIRST-EVER statement from this vendor. Opening balance should be zero — there is no relationship history to carry forward. A nonzero OB here is itself the anomaly, the mirror image of S5's large-OB scope boundary. Classify every leftover.

Select a card, then click a bucket. Timing and report-flavour mistakes that look like “missing” are critical fails.

Lab 4.9 — Combined statement + remittance advice (S8)

This one document has two sections: a periodic-position 'Month End Statement' and a tear-off 'Remittance Advice' confirming a specific payment run. Match the statement section to open AP. The remittance section lines are NOT new items to reconcile — they only confirm a payment already reflected elsewhere. Leave them unmatched.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S8 × L1.

Coates-pattern Hire & Statement Co (synthetic)

1 Tear-off Ct, Archerfield QLD 4108

Statement date: 2026-06-15

Vendor statement(S8 — combined statement + remittance advice)

AP / ERP extract

Lab 4.10 — Multi-currency statement (S9)

This vendor bills in USD; your ledger records in AUD. The statement's face amount is foreign currency (USD) — do not compare it directly to the ledger's local (AUD) amount. Convert first: foreignAmount x exchangeRate = localAmount, then match on that.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S9 × L1.

Pacific Import Components Inc

500 Harbor Blvd, Long Beach CA 90802, USA

Statement date: 2026-06-09

Vendor statement(S9 — multi-currency)

AP / ERP extract

Lab 4.11 — Reference-token ambiguity: PO vs Document No

This vendor's statement prints Customer PO large and first, and Document No small and second. The Customer PO is NOT the join key here — one PO covers multiple invoices. Match on Document No / Their Ref, not the visually prominent PO.

Click a statement line, then click an AP line to pair. Click a pair badge to unlink. Archetypes: S1 × L1.

Meridian Trade Supplies

6 Wharf St, Port Adelaide SA 5015

Statement date: 2026-06-20

Vendor statement(S1 — open-item statement)

AP / ERP extract

Lab 4.12 — Date-locale collision (US vs UK/AU)

Two vendors, two date conventions, the same ambiguous digits. Do not guess — find the corroborating unambiguous date on the SAME page and let it decide the reading.

Select a card, then click a bucket. Timing and report-flavour mistakes that look like “missing” are critical fails.

Previous module Next module

StatementZen Academy Team — Built from StatementZen's own vendor statement reconciliation engineering and casework — pending Michael's named byline commitment (spec.md section 7). · Last updated 21 July 2026