Free course · no login required to learn
Learn vendor statement reconciliation
Learn how to match statements to AP extracts, classify the lines left over, and decide what to do next in your accounting system. The course is free, and you can claim a LinkedIn-shareable certificate when you pass.
About 3.5–5 hours · self-paced · syllabus and labs public without signing in
Free reference material
- Decision treePrintable flowchart: follow the branches to classify any item.
- PracticeClassify statement and ledger lines with instant feedback. No login required.
- Exception taxonomyEvery leftover bucket and the AP action that clears it.
- GlossaryThe reconciliation vocabulary, defined plainly.
- Root causes & comparisonsWhy statements and ledgers drift apart in the first place.
- Worked examplesThree reconciliations worked line by line, every figure shown.
- Why extraction quality mattersWhat a bad read costs you further down the process.
What you'll learn
Compare statements with AP extracts
Check invoice reference, amount, and date. Leave a line unmatched when the evidence does not support a pair.
Explain every remaining item
Separate missing items, timing differences, credits, duplicates, mismatches, opening-balance gaps, and report-type issues.
Choose the next AP action
Request an invoice, hold a payment, pull the correct report, or apply a credit according to what the evidence shows.
Check before calling an invoice missing
Review payment timing and the report type before you decide that a bill is absent.
Complete the exception log
Record the evidence, owner, and next action for each open item. The Final Challenge asks you to apply the full process to a mixed set of vendor issues.
Skills you'll practice
How to start
You do not need an account to learn, save verified progress, or claim the certificate.
- 1
Browse the syllabus (no account needed)
Read every module overview and the exception taxonomy. Labs work in your browser and verified progress auto-saves.
- 2
Start Module 1
Orientation takes about 15 minutes. Your signed, anonymous progress follows this browser without a login.
- 3
Claim the certificate when you pass
After the required labs and Final Challenge, enter the certificate name and delivery email. No account or password required.
Syllabus
Full module list — open any module without logging in.
Introduction to reconciliation
Learn what vendor statement reconciliation checks, which three documents you use, and how to read the open amount. The software assigns 21 categories; this module introduces the 20 that need an action or explanation.
Perfect and near-perfect matches
Clear the straightforward matches: clean_match when reference, amount, and date agree; date_corroborated when amount and date support the match; and fuzzy_ref when reference formatting differs.
Date and amount differences
Review date_mismatch, amount_variance, part_paid, and ambiguous_match items. Check the source documents and do not match a line until the evidence supports it.
Items on one side only
Work through items found on only one side: statement_only, not_open_maybe_paid, out_of_period, ledger_only, and ledger_out_of_period. Check the period, report type, and timing before you contact the supplier.
Statement layout fluency
Read debit and credit columns, original and outstanding amounts, and running balances. Check that opening balance plus movements equals closing balance, then review duplicates and grouped matches.
Payments, credits, timing, and opening balances
Handle invoices marked paid in your ledger but still open on the statement (status_conflict and status_conflict_timing), unallocated credits (credit_on_account), and the brought-forward balance check (bbf_anchor). You will also check for the paid-invoices (L3) report trap, where an extract containing only paid items makes open invoices appear missing.
Exception log workflow and course-only concepts
Classify every remaining item, record the evidence and next action, and complete the exception log. You will also check new_vendor_opening, document_type_mismatch, dispute_on_hold, and vendor_data_issue items yourself.
Messy vendor week
Match both sides of a reconciliation, classify the exceptions, and pass to claim Statement Zen Vendor Statement Reconciliation Professional.
Free reconciliation template
Use this workbook to record 26 cause codes, choose from five outcomes, build a formula-driven balance bridge, and run ten checks before sign-off. It includes a dedicated "never chase" outcome for residuals that look like debts but do not need supplier follow-up.
How you earn the certificate
- Pass required labs in Modules 1–7 (practice in-browser; no login).
- Final Challenge: match and classify a messy week. If you treat timing as a missing item or invent opening-balance history, you will need to retry.
- Sign in with a free account and claim Statement Zen Vendor Statement Reconciliation Professional — public verify page + LinkedIn add link.
Exception → next action (preview)
Classification is not the finish line — you learn what to do in AP next.
| Bucket | Typical next action |
|---|---|
| Brought-forward check | If the balances agree, no action is needed. If they differ, identify the prior-period items that explain the gap. |
| Your ledger says paid — still open on their statement | Confirm that the payment cleared your bank, then ask the supplier to apply it. Do not pay the invoice again. |
| Billed by the supplier — not recorded in your ledger | Request the invoice from the supplier and check the charge. Enter it in your accounting system only after you confirm it is valid. |
| Amount doesn't match | Check tax, freight, FX, and short-payment details. Correct the bill or arrange a credit with the supplier, depending on which side is wrong. |
| Part-paid — billed in full, partly settled | Confirm that the partial payment cleared and check that the remaining balance is correct. |
| Charged twice on the statement | Query the duplicate with the supplier. Pay once and do not enter a second bill. |
FAQ
- Do I need to sign in to see the course?
- No. The syllabus, module lessons, labs, cheat sheet, Final Challenge, and certificate claim are public. Verified progress auto-saves in this browser.
- Is the course free?
- Yes. There is no course fee and no account is required for the shareable certificate. A Statement Zen product account is separate and optional.
- How long does it take?
- Allow about 3.5–5 hours, including the Final Challenge. You can work through the modules at your own pace.
- Do I need Excel or a specific ERP?
- No. You do not need Excel or a particular ERP. The exercises use the same core information you would compare in an AP extract and a vendor statement.
- What does the certificate prove?
- Statement Zen Vendor Statement Reconciliation Professional proves you passed the required labs and Final Challenge — judgment on matching and exceptions, not that you used Statement Zen product automation.
- What is vendor statement reconciliation?
- Vendor statement reconciliation compares a vendor's or supplier's statement of account with your accounts payable ledger. You match the lines that agree, investigate the remaining items, and record the next AP action. Common categories include an item missing on one side, timing, credits, duplicates, amount differences, and opening-balance scope. It is different from three-way match, which checks the PO, receipt, and invoice when the invoice is entered.
- Why doesn't my vendor statement match my AP ledger?
- Start by checking timing and the report type. An invoice or payment may have posted after the statement cutoff, and an aged-open-items report will leave out paid invoices. Credits, duplicate entries, amount differences, and an opening balance without supporting detail can also cause a gap. Confirm those points before you treat the item as missing or ask the supplier to correct it.
- How do you reconcile a supplier statement in Excel?
- Put the supplier statement lines and your AP extract lines side by side with the reference, date, and amount. Compare the reference first, then the amount and date. Keep anything that does not match as an exception row. Record whether it is missing, timing, a credit, a duplicate, an amount or reference difference, or an opening-balance issue, and add the next action rather than relying on a highlighted cell alone.
- What's the difference between vendor statement reconciliation and AP reconciliation?
- AP reconciliation, also called AP subledger reconciliation, usually checks your internal records: does the AP subledger detail agree with the general ledger control account? Vendor statement reconciliation works vendor by vendor and compares your records with the supplier's statement. That external comparison can reveal an invoice the supplier issued but that was never entered in your ERP.
- What causes discrepancies between vendor statements and the AP ledger?
- A difference can come from timing, an aged-open report that excludes paid items, a credit or debit note applied on only one side, a duplicate entry, an amount or reference difference, or an opening balance without enough supporting detail. Check the statement period and report type first, then review the invoice, payment, and credit records for the specific line.
- Is vendor statement reconciliation required for audit?
- There is no single audit requirement that applies to every organisation. An auditor may use vendor statement reconciliations when testing accounts payable completeness or existence. Keep the statement, AP extract, matching evidence, and exception log together so the reviewer can follow what was checked and how each difference was resolved. Confirm the required evidence with your auditor or internal policy.
Statement Zen Academy Team — Practical guidance based on Statement Zen's vendor statement reconciliation work. · Last updated