Business template
Invoice Payment Tracker
Every invoice you have raised, what is still unpaid, and how many days late each one is.
Free
No signup, no email. Yours to edit and use commercially.
- 49
- live formulas, each one recalculated and checked
- 8
- columns: Invoice, Customer, Issued, Due, Amount, Paid?, Outstanding, Days late
- 8
- figures worked out for you
Whoever keeps track of who has paid · Small businesses invoicing regularly — usually looking for this when invoices go out but nobody is sure which came back.
Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.
About this Invoice Payment Tracker template
Sending invoices is easy; knowing which ones have actually been paid is harder. This free Excel invoice payment tracker lists every invoice with its customer, amount and issue date, sets the due date from your payment terms and counts how many days late each unpaid invoice is.
The summary shows the total invoiced, what has been paid, what is still outstanding, how many invoices are past due and the longest delay.
Good for
- →Freelancers keeping on top of unpaid invoices
- →Small businesses without accounting software
- →Knowing exactly who to chase this week
What it works out for you
Where you stand
- →Total invoiced
- →Paid
- →Still outstanding
- →Invoices unpaid
- →Invoices past due
- →Value past due
- →Worst delay (days)
What is inside the Invoice Payment Tracker template
The table has 8 columns. Calculated columns fill themselves in; the rest are yours to type over.
- →Invoice
- →Customer
- →Issued
- →Due
- →Amount
- →Paid?
- →Outstanding
- →Days late
Settings in the “Settings” box
- →Payment terms (days from issue)
How to use the Invoice Payment Tracker in Excel
Set your payment terms in the box below the table — every due date follows from it. Days late counts from today, so it is right every time you open the file.
The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.
Shaded, boxed cells below the table are settings the formulas read from. Change those first — every row that depends on them updates at once.
Functions and formulas it uses
Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.
COUNTIFIFMAXORSUMSUMIFTODAYQuestions about the Invoice Payment Tracker
How is the due date set?
It is the issue date plus the payment terms you set once below the table, such as 30 days. Change the terms and every due date updates.
How are days late calculated?
Against today's date, for invoices not marked as paid. An invoice that is not yet due shows zero.
How is this different from the Aged Debtors Report?
This tracker records every invoice and whether it has been paid. The Aged Debtors Report covers only unpaid invoices and groups them into 30, 60 and 90+ day buckets.
What you get with the Invoice Payment Tracker
- ✓49 formulas, every one recalculated and checked
- ✓Opens with sample rows already filled in
- ✓Excel, Google Sheets and LibreOffice Calc
- ✓Set up to print on one page wide
- ✓Yours to edit and use commercially
- ✓No signup, no email, no watermark
More business templates
See all Business →
Invoice Payment Tracker
Free — no signup