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 / Supplier Invoice Tracker
Free Excel template

Supplier Invoice Tracker

Free Excel supplier invoice register: computed due dates, partial payments, automatic status, configurable taxes (VAT, GST/QST, other) and an accounts payable aging balance 0-30, 31-60, 61-90 and 90+ days, in total and by supplier.

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 « Supplier Invoice Tracker » 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.

Invoices

One row per invoice: due date, taxes, balance, status, bucket

AP aging

Not due, 0-30, 31-60, 61-90, 90+ days, in total and by supplier

Dashboard

Outstanding, overdue, due in 7 days, recoverable taxes

Settings

Currency, decimals, taxes, payment terms, as-of date

Instructions

Get started in 3 minutes, cells protected without password

Print

Print-ready: repeated headers, fit to width

How to use it

Up and running in minutes.

  1. 01

    In the Settings sheet, set the currency, decimals, your taxes and the default payment terms.

  2. 02

    Enter each received invoice: number, supplier, PO number, date and net amount. Due date and taxes compute automatically.

  3. 03

    For each payment, record the amount paid and the date: balance due and status update, partial payments included.

  4. 04

    Read the aging: balance not yet due, then overdue 0-30, 31-60, 61-90 and 90+ days, in total and by supplier.

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.
It sorts the balance due by how long it has been overdue at an as-of date: not yet due, then overdue 0-30, 31-60, 61-90 and 90+ days. Past 60 days every line needs an explanation (dispute, blocked invoice, oversight); past 90 there is a risk of penalties and of damaging the supplier relationship. Taxes on each line are computed from the net amount with the Settings sheet rates.
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.