ReferralKnow a company that should run on Procura? Refer it and get rewarded for every signed client.Refer a company, get rewardedDiscover the programmeDiscover
Free Excel templates / Vendor Statement Reconciliation
Free Excel template

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.

Procura
Download

Your country's version.

Each country has its two files: one fully French, one fully English. Direct download, no sign-up.

FRANCE

France

Multi-rate VAT 20/10/5.5/2.1, euro amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

QUEBEC

Québec and Canada

5% GST and 9.975% QST computed on net, dollar amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

AFRIQUE

Africa

18% WAEMU VAT, no-decimal FCFA amounts. Currency, decimals and rates editable in the Settings sheet.French ↓English ↓

By e-mail, optional

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.
Contents

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

Print

One-page summary for the close file

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, enter the supplier, the statement date and the rounding tolerance.

  2. 02

    Copy the statement received: references and amounts, payments and credit notes negative.

  3. 03

    Copy the supplier account from your books for the same period, with the same sign convention.

  4. 04

    The summary explains the difference: lines missing on each side and amount differences. Settle them before paying.

FAQ

Your questions, answered.

Yes: direct download, no sign-up or e-mail. Use it freely internally and duplicate it each month or fiscal year. If you prefer, you can also get it by e-mail.
To find, before paying, invoices you never received, forgotten credit notes, double payments and payments the supplier has not yet received. A monthly reconciliation of the main suppliers prevents chasers, penalties and year-end disputes.
The spreadsheet shows its limits: email approvals, re-entry, duplicates. Procura automates the same cycle (requests, POs, AI 3-way matching, taxes, payments) and is usually deployed within a week.

The same cycle, automated.

Procura replaces the spreadsheet as the team grows: online approvals, AI 3-way matching, taxes filed from the books.