Vendor Statement Reconciliation
Free Excel vendor statement reconciliation against your books: matching by reference, lines missing on each side, amount differences, unexplained remainder and automatic conclusion.
Your country's version.
Each country has its two files: one fully French, one fully English. Direct download, no sign-up.
Get the template by e-mail, and its updates.
Keep the six files of « Vendor Statement Reconciliation » in your inbox, to find or share them later. The direct download stays free, no sign-up.
- The France, Québec and Africa versions, in French and English.
- If you wish: three e-mails of tips over ten days, once you confirm, then nothing more.
- Your details are never sold, one-click unsubscribe.
What the workbook contains.
Supplier statement
Statement lines, matching status, difference
Our ledger
Supplier account, lines missing from the statement
Summary
Balances, explained difference, unexplained remainder, conclusion
Settings
Supplier, date, tolerance
Instructions
Get started in 3 minutes, cells protected without password
One-page summary for the close file
Up and running in minutes.
- 01
In the Settings sheet, enter the supplier, the statement date and the rounding tolerance.
- 02
Copy the statement received: references and amounts, payments and credit notes negative.
- 03
Copy the supplier account from your books for the same period, with the same sign convention.
- 04
The summary explains the difference: lines missing on each side and amount differences. Settle them before paying.
Your questions, answered.
In the same category.
The same cycle, automated.
Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.