Supplier Statement Reconciliation: A Simple Template for Pakistani Businesses

Supplier Statement Reconciliation: A Simple Template for Pakistani Businesses

In short: Compare your supplier ledger with each supplier’s statement on the same date, list every difference with a reason, and fix the real errors. Most differences come from invoices or cheques in transit, income tax withheld, and missing credit notes. Below is a ready template, a worked example and a six-step monthly routine.

Why supplier statements rarely match on the first try

Every month or quarter, most suppliers send a statement of account showing what they think you owe. Your own supplier ledger (accounts payable) almost never shows the same balance on the same date. That is normal. The goal of supplier statement reconciliation is not to make the two numbers equal by force, but to explain every rupee of difference and fix the items that are genuinely wrong.

Doing this regularly protects you from paying an invoice twice, missing a credit note you are owed, losing track of income tax you withheld, and arguing with a good supplier over a balance nobody can explain.

The reconciliation template

Use one sheet per supplier. Start with both closing balances on the same date, then list each difference in its own row.

ColumnWhat to write
DateDate of the invoice, payment, return or note
ReferenceInvoice number, cheque number, debit or credit note number
In our books (Rs)Amount as recorded in your supplier ledger
In supplier statement (Rs)Amount as shown by the supplier
Difference (Rs)Supplier amount minus your amount
ReasonOne of the usual reasons listed below
Action and ownerWho will fix it and how (post a missing invoice, send a WHT certificate, ask for a credit note)
Cleared onDate the item stopped being a difference

At the bottom, the formula must work: your ledger balance + total of explained differences = supplier statement balance. If it does not, there is still an unexplained item to find.

A worked example

This is an illustrative example, not a real company. On 30 November your ledger shows Rs 1,250,000 payable to a packaging supplier. The supplier’s statement shows Rs 1,410,000. The difference is Rs 160,000.

ItemDifference (Rs)ReasonAction
Invoice dated 30 Nov, goods still on the way95,000Invoice in transitPost when goods and invoice are received; check the GRN
Cheque dispatched 29 Nov50,000Payment in transitNone; confirm it clears next month
Income tax withheld on an October payment15,000Supplier has not recorded the tax deductedSend the withholding certificate and payment proof
Total explained160,0001,250,000 + 160,000 = 1,410,000, so the account is reconciled

The seven usual reasons for a difference

  • Invoices in transit. The supplier has billed, but the invoice or goods have not reached you or have not been posted yet.
  • Payments in transit and post-dated cheques. You have recorded a cheque the supplier has not received or presented. Keep these in a post-dated cheque register so they are easy to match.
  • Income tax withheld. When a prescribed buyer pays for goods, it deducts income tax under section 153 of the Income Tax Ordinance 2001 and credits the supplier with the full amount. The supplier may only record the cash received until it gets your certificate. FBR’s Withholding Income Tax Rate Card (updated to 30 June 2026) shows 5% for companies and 5.5% for other sellers on the active taxpayer list for sale of goods, and double those rates for sellers not on the list.
  • Returns, short supply and rate differences. You sent goods back or were overcharged, but the supplier has not issued the credit note yet.
  • Discounts and claims. Trade discounts, bonus stock or claims agreed verbally but never documented.
  • Posting errors. An invoice entered twice, posted to the wrong supplier or with digits swapped (a difference divisible by 9 is a common sign).
  • Opening balance differences. Old differences carried forward that nobody cleared. Agree the opening balance once, in writing.

Monthly routine in six steps

  1. Ask for statements. Request a statement from your top suppliers by value as of the same month-end date every month.
  2. Print your ledger. Take the supplier ledger for the same period and date.
  3. Tick the matches. Match invoices, payments and notes that appear on both sides with the same amount.
  4. List what is left. Put every unticked item into the template with a reason.
  5. Act on the real errors. Post missing invoices, send WHT certificates, ask for credit notes, reverse duplicates.
  6. Sign it off. Keep the reconciliation with the month-end file and carry open items forward until cleared.

Do it alongside your bank reconciliation and the rest of your month-end closing checklist, because payment differences usually show up in both.

How software makes this faster

In Excel, matching is manual and the ledger is only as reliable as the last person who typed into it. Good accounting software keeps the supplier ledger linked to purchase invoices, goods received, payments, cheques and returns, so you can print a supplier ledger for any date in seconds and see which items are still open. It also records the tax withheld against each payment, which makes the most common difference easy to explain.

Want supplier ledgers you can trust?

See how Switcher Techno keeps purchases, payments, cheques and tax withheld in one ledger.

Frequently asked questions

What is supplier statement reconciliation?

It is the process of comparing your supplier ledger (accounts payable) with the statement of account sent by the supplier on the same date, and explaining or correcting every difference.

How often should I reconcile supplier statements?

Monthly for your main suppliers by value, and at least before the year-end. Doing it every month keeps the list of differences short and easy to clear.

Why does my supplier show a higher balance than my books?

The most common reasons are invoices still in transit, cheques the supplier has not received yet, income tax you withheld that the supplier has not recorded, and credit notes the supplier has not issued.

How do I treat withholding tax in supplier reconciliation?

Credit the supplier with the full invoice amount: part paid in cash and part as tax withheld and deposited. Send the withholding certificate so the supplier can record the same amount on its side.

What if a difference cannot be explained?

Check the opening balance first, then look for duplicates, wrong-supplier postings and swapped digits. If it remains, ask the supplier for a detailed ledger and agree the item in writing.

Can accounting software do supplier reconciliation automatically?

Software cannot read the supplier’s own books, but it gives you an accurate supplier ledger with open invoices, payments, cheques and returns for any date, which makes matching much faster.

Withholding rates are taken from FBR’s Withholding Income Tax Rate Card updated to 30 June 2026 (Finance Act 2026), checked on 20 November 2026. Rates and conditions change, so confirm with your tax adviser. The worked example is illustrative.