All posts
6 min readKrinoDoc Team

Supplier statement reconciliation: the silent month-end job nobody schedules

What supplier statement reconciliation is, why it eats half a day per supplier when the statement arrives as a PDF, and how Irish practices use KrinoDoc to turn the PDF into matched rows before the actual reconciliation starts.

Most Irish practices treat bank reconciliation as a scheduled job. Supplier statement reconciliation tends to be the one that happens when something goes wrong — a supplier rings about an unpaid invoice, a credit note vanishes, the year-end audit flags a creditor balance that nobody can stand over. By then it is a half-day per supplier, not the twenty minutes it should have been.

The mechanics are not complicated. The reason it eats the afternoon is the same reason bank reconciliation does: the statement arrives as a PDF, and the purchase ledger lives in Xero, Sage, or QuickBooks, and nothing automatic happens between the two.

What supplier statement reconciliation actually is

A supplier sends you a statement once a month listing every invoice, credit note, and payment they have recorded against your account. You compare it to the purchase ledger entries for that supplier in your accounts package. Three things have to line up:

  1. Every invoice on the supplier's statement is posted in the purchase ledger (or explained — in dispute, awaiting credit note, posted to the wrong supplier).
  2. Every payment in the purchase ledger has been received and allocated by the supplier.
  3. Closing balance on the statement matches the creditor balance in the accounts for that supplier as at the statement date.

If the three agree, the supplier account is reconciled. If they do not, something is missing, duplicated, miscoded, sitting in dispute, or — most often — has been paid but not allocated by the supplier yet.

That is the job. The four lines above are ten minutes of work. Getting to the point where you can do them is the rest.

Why Irish practices quietly skip it

Bank reconciliation has a forcing function: the VAT3 return, the management accounts, the bank feed turning red in Xero. Supplier statement reconciliation has none of that. Nobody chases it until:

  • A supplier emails about a "long overdue" invoice that was actually paid in March.
  • The auditor pulls a sample of creditor balances at year-end and the figures do not tie.
  • A credit note never arrived and the balance has been silently wrong for six months.
  • Revenue queries an input VAT claim and the supporting invoice is on the statement but not in the ledger.

By the time any of those land, the work is forensic — six months of statements pulled out of the inbox, half of them already deleted, the supplier's portal locked because the email contact left the firm. Twenty minutes a month, done at the time, would have prevented all of it.

Where the time actually goes

The reconciliation itself is quick. The work around it is not. In a typical Irish practice:

  • Pulling the statement out of the inbox. Suppliers send PDFs, Excel attachments, a link to a portal that requires a login nobody remembers, or a paper statement scanned and forwarded by the client. Some come from noreply@ addresses that bookkeepers filter out by accident.
  • Reading the layout. Irish supplier statements range from clean two-column listings to four-page PDFs with the opening balance buried mid-document, credit notes shown as negatives without a clear marker, and payment allocations stuck in a footer.
  • Multi-page statements. A statement for a busy supplier — a wholesaler, a hardware merchant, a utility — runs to ten or twenty pages. The accounts package wants rows; the PDF gives a layout.
  • Matching invoices line-by-line. Open the statement on one screen, open the supplier's account in Xero or Sage on the other, and tick across. Half an hour minimum for any active supplier.
  • Chasing the differences. Missing invoices, unallocated payments, credit notes the supplier processed against a different invoice, FX differences on UK or EU suppliers post-Brexit.

The actual reconciliation — the three checks — is ten minutes. The keying and the eyeballing is the rest of the afternoon.

The Brexit and post-2025 VAT layer

For Irish practices, supplier statement reconciliation is no longer just an internal control. It is increasingly the document that proves the input VAT claim is real:

  • GB suppliers now sit outside the EU VAT system. The statement is often the only consolidated record of what was imported, what VAT was paid at the border, and what was reverse-charged.
  • Postponed VAT accounting on imports means the input VAT figure on the VAT3 has to be matched against C&E records, not the supplier statement directly — but the supplier statement is still the audit trail for the underlying purchase.
  • Revenue's eInvoicing direction is pushing structured supplier data into the accounts package by default for the largest suppliers. The PDF problem does not go away — it concentrates in the long tail of smaller suppliers, who are the ones whose statements are most likely to be wrong.

The practical effect: supplier statement reconciliation has gone from a hygiene job to part of the VAT3 audit trail. Skipping it is more expensive than it was three years ago.

What good looks like

A workable supplier reconciliation routine does three things:

  • Ingests the statement in whatever shape it arrived — PDF, Excel, scan, multi-page bundle, foreign currency — and produces clean rows: invoice number, date, gross, allocation, running balance.
  • Preserves the awkward bits: credit notes as separate rows with a clear sign, FX rates where present, payment allocations linked back to the invoice they cleared.
  • Hands the rows to the accounts package in a shape that can be matched against the supplier's purchase ledger account — CSV in, or pasted into a working paper alongside the ledger export.

Once the statement is structured, the three checks above happen in minutes. The argument with the PDF is the part that has to go.

The judgement calls that stay with the bookkeeper

Worth being explicit about what automation will not do:

  • It will not decide that a missing invoice on the statement is one the supplier never raised versus one the practice lost.
  • It will not ring the supplier to ask why a credit note was applied to the wrong invoice.
  • It will not decide whether an FX difference goes to realised gains/losses or sits in a clearing account.
  • It will not sign off the supplier ledger at year-end.

Automating the front of the workflow is what gives the bookkeeper time to make those calls properly, rather than spending the afternoon keying a twelve-page PDF from a builders' merchant into a working paper.

Where KrinoDoc fits

KrinoDoc handles the ingestion bit — the part before the three checks. Drop in the supplier statement in whatever format it arrived: PDF, photo, scan, multi-page bundle, EU or GB supplier, credit notes mixed with invoices, the lot. Structured rows come out the other side with opening and closing balances preserved, ready to compare against the supplier's account in Xero, Sage, or QuickBooks.

The reconciliation itself stays where it belongs — with the bookkeeper, with the judgement, with the client relationship. The half-day of keying does not.

That is the trade. Three checks in ten minutes, monthly, on every active supplier — instead of a forensic half-day per supplier when something finally goes wrong.

Try it free · See pricing

Supplier statement reconciliation: the silent month-end job nobody schedules | KrinoDoc