Back

Free Excel template

Supplier statement reconciliation template

Start from the balance in your books, list each difference against the supplier’s statement, and the sheet shows the balance the supplier should be showing and anything still unexplained.

Download the Excel file

.xlsx · 9 KB · Works in Excel, LibreOffice and Google Sheets · No sign-up

What is in it

  • A reconciliation sheet with the supplier name, statement date and both balances
  • A list of difference types to pick from: invoices not booked, payments not yet credited, debit notes, TDS, credit notes
  • Each difference added or deducted automatically, with an "unexplained difference" line that should come to zero
  • Room for 50 differences and a note on the action for each

How to use it

  1. Enter the balance payable in your books and the closing balance on the supplier’s statement.
  2. Go through the supplier’s statement line by line and list every item that is not in your books, and every item in your books that is not in the statement.
  3. Pick the type for each difference. The sheet works out whether it adds to or reduces your balance.
  4. When the unexplained difference is zero, send the supplier your list and book the items that are yours to correct.

Blue cells are for your figures; everything else is a formula. The first rows hold an example: replace them with your own. This is a general format, not professional advice for your case.

Want us to do this for you every month? Talk to us.