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.
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 « 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.
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-ready: repeated headers, fit to width
Up and running in minutes.
- 01
In the Settings sheet, set the currency, decimals, your taxes and the default payment terms.
- 02
Enter each received invoice: number, supplier, PO number, date and net amount. Due date and taxes compute automatically.
- 03
For each payment, record the amount paid and the date: balance due and status update, partial payments included.
- 04
Read the aging: balance not yet due, then overdue 0-30, 31-60, 61-90 and 90+ days, in total and by supplier.
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.