Skip to content
Pocket Invoice: Free Invoice makerFree Invoice Maker

Free Invoice Tracker Template

Available now
Use the Excel invoice tracker to record:
  • Invoice number
  • Customer
  • Issue date
  • Due date
  • Status
  • Subtotal
  • Tax
  • Total
  • Amount paid
  • Balance

Formula-driven summaries show outstanding, overdue and paid amounts. A clean CSV import template is included.

Read the collection guide
Invoice tracker dashboard preview

Keep invoices, payments, balances and follow-up connected.

What the invoice tracker records

Each row connects one invoice to its customer, dates, currency, amounts, payment status and latest follow-up note. The balance and days-overdue fields are calculated from the entered values and dates.

Use one reporting currency per workbook so the summary totals remain meaningful. Keep the original invoice and payment evidence with the matching invoice number.

  • Invoice number and customer
  • Issue date and due date
  • Subtotal, tax and total
  • Amount paid and balance
  • Status, days overdue and follow-up note

How the Excel summaries work

The Dashboard sheet totals invoiced, paid, outstanding and overdue amounts for the selected reporting year. Monthly formulas use issue dates, while customer balances use the customer names in the invoice log.

Status remains an editable business record. The calculated balance and overdue days help review the entry, but they do not replace reconciliation with bank records or the customer account.

  • Formula-driven balances
  • Outstanding and overdue totals
  • Monthly invoiced and paid totals
  • Customer balance summary
  • No macros or hidden calculations

Review invoices and payments regularly

Match payments to invoice numbers, update partially paid invoices, review due dates and document the latest customer follow-up. Resolve credits, refunds or disputed amounts in the source records before changing the tracker.

The template organizes invoice activity but does not send reminders or decide accounting treatment. Confirm local recordkeeping, tax and collection requirements for the business.

  • Reconcile payments
  • Review overdue balances
  • Document follow-up dates
  • Match credits and adjustments
  • Keep source invoices and payment evidence

Invoice tracker questions.

Can I track invoices in Excel?

Yes. The workbook records invoice and payment details and uses formulas for balance, days overdue, monthly totals and customer balances.

What should an invoice tracker include?

Record the invoice number, customer, issue and due dates, currency, subtotal, tax, total, amount paid, balance, status and follow-up details.

Does the invoice tracker send payment reminders?

No. It organizes invoice status and follow-up notes. Send reminders through the invoicing or communication method used by the business.

Can I import the CSV into another system?

The CSV uses common invoice columns. Review and map every column before importing it into another spreadsheet, bookkeeping or reporting system.

Create a free invoice

Open resource

Invoice payment terms guide

Open resource

Outstanding invoices guide

Open resource

Free business expense tracker

Open resource

Free Invoice Maker

Continue on Web or mobile.

Sign in to manage documents on the Web, or download the app for iPhone and Android.
Sign in on Web Download for iOS Get it on Android