Skip to content

CPD lab · AP

Supplier statement reconciliation

A timber supplier's statement against the purchase ledger: explain every difference with your AI tool, and catch the items that agree on paper but are still wrong.

All the ways to get this lab

Comes with AP and procure-to-pay automation, and with the year. 29 labs open now.

The brief

You are the purchase ledger clerk at Cresswell Brook Homes Ltd, a housebuilder. It is Monday 2 November 2026. Ambrey Timber & Sheet Ltd has sent its statement at 31 October 2026, and the month-end reconciliation is due today.

The pack has Ambrey's statement, our purchase ledger account for Ambrey (AMB01, August to October), our purchase orders and goods received notes, an email from Ambrey and our purchase ledger notes. Every company, person and figure is invented, so you can paste it into any AI tool.

Use your AI tool to reconcile the statement to the ledger. Give one line for every item on the statement, and one for every item open on our ledger that is not on the statement. A paid invoice that is still on the statement is its own line. Use the supplier's invoice number as ref (for example AT-51402), or our own reference for a document only we hold (for example DN-0114).

Amounts are what each side shows as owed to Ambrey, in pounds including VAT: invoices positive, credits negative. statement_amount is the amount on the statement (0 if it isn't there). ledger_amount is the amount open on our ledger (0 if it isn't open there). difference is statement_amount minus ledger_amount.

Action, one per line. AGREED: on both sides at the same amount, and the invoice agrees to our order and goods received. TIMING: our payment has left but reaches Ambrey after the statement date; nothing to do. REQUEST COPY: on the statement, not on our ledger, but we did receive the goods; ask for a copy invoice. CHASE CREDIT: a credit the supplier has agreed but not yet issued. QUERY PRICE: the invoice is priced above the agreed PO price; ask for a credit and pay only the PO value. OUR ERROR: our ledger is wrong; a person corrects the posting. NOT OURS: the item belongs to another company; ask the supplier to move it.

Post nothing and pay nothing: your job is the reconciliation, for the AP supervisor to review. An item that is old but agrees is still AGREED; paying it is a separate decision.

Then write a short review note: what the AI got wrong, what you checked, and what goes to a person.

Objective: To be able to reconcile a supplier statement to the purchase ledger with an AI assistant, explaining every difference by its cause and testing agreed items against orders and goods received, without posting anything from the statement.

What's in the pack

Every name, figure and email in the pack is invented. Use your own AI tool: Claude, ChatGPT, Copilot or Gemini.

  • ambrey-statement.txt

    Ambrey Timber & Sheet Ltd: statement of account at 31 October 2026

  • purchase-ledger-amb01.csv

    Our purchase ledger account AMB01, August to October 2026 (paid and open items)

  • purchase-orders-grn.csv

    Our purchase orders with Ambrey and the goods received against them

  • email-ambrey-returns.txt

    Email from Ambrey's sales ledger, 14 October

  • purchase-ledger-notes.txt

    Our purchase ledger notes: statements, posting rules and group companies

The traps

The pack has 7 deliberate traps: cases where AI tools often get it wrong and a person must check. We don't list them here. Finding them is the job, and your feedback names each one you missed.

What you submit

  1. Your result, as a table with the columns ref, statement_amount, ledger_amount, difference, action, note.
  2. The prompt you used.
  3. A short review note, 150 to 350 words: what the AI got wrong, what you checked, and what goes to a person.

How it's marked

  • Your result, checked line by line against the answer key60%
  • Your review note, marked on traits40%

The review note's traits:

  • Every difference explained by its cause
  • Agreed items tested against orders
  • Nothing posted or paid from the statement
  • Clear follow-up with the supplier and the team
  • Supplier data kept out of personal accounts

Pass at 80. Under 80, read the feedback and try again. Then write your reflection and copy the entry for your CPD record.

Price

  • AP and procure-to-pay automation, £79. The role track and its labs, this one included. No end date.
  • Everything for a year, £199. Every course, role track and lab for 365 days.
  • Monthly, £19.99 a month, cancel any time. Every lesson, plus 8 marked tasks a month, across every course, role track and lab.

Buying for a team, or want a lab built on your own process? CPD for employers.