Skip to content
Pocket Invoice: Free Invoice MakerFree Invoice Maker

Free invoice tracker template

What invoices are outstanding? Which are due? When was the last time you followed up with the customer? Download an invoice tracker to keep a record.

Free invoice tracker template
The Excel template holds:
  • Invoice number
  • Customer
  • Issue date
  • Due date
  • Status
  • Subtotal
  • Tax
  • Total
  • Amount paid
  • Balance

You enter the amount paid. Formulas derive outstanding balances and days overdue from total, amount paid and due date. Excel also summarises invoiced, paid and other amounts. Both files have example rows; replace these with your data.

Combine your invoice numbers with payments and follow-up. Have a record behind the balances.

An invoice record in one row

Keep invoice number, customer, issue date, due date, currency, amounts, status and last follow-up note in one row. Excel has formulas to calculate outstanding balance and days overdue. You enter the total.

Use one reporting currency per workbook; this tool does not convert currencies. Store the source invoices and payment evidence by invoice number, rather than just the numbers in this sheet. There is a minimum balance of zero. Review overpayments, refunds and credits in the source records.

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

Summarise the Excel records

Dashboard sums invoiced amounts, payments, outstanding and overdue balances for the selected invoice issue year. Monthly invoiced and paid amounts are grouped by month of issue. Payments refer to cumulative payments applied against those invoices, rather than payments received during that calendar month.

On the summary sheet, type customer names to match the names in your invoice log and sum the balance for each customer. This customer balance summary is not filtered by reporting year.

You control the status. Setting it to paid or cancelled does not affect the amounts. Balance and overdue formulas are not a substitute for reconciling bank and customer records. Keep the formulas and ensure added rows are included in the summary ranges.

  • Formulas for balances
  • Outstanding and overdue amounts
  • Invoiced amounts and cumulative payments grouped by issue month
  • Total balances per customer name
  • Standard formulas, no macros

Reconcile payments with invoice numbers regularly

When you receive a partial payment, update the invoice record and review the due date. Note the date and content of the latest customer contact. Handle credits, refunds and disputes in the source business records before changing the tracker.

This template organises records. It does not send payment reminders or decide accounting treatment. Follow the recordkeeping, tax and collection requirements that apply to your business.

  • Reconcile payments to invoice numbers
  • Monitor overdue balances
  • Note follow-up dates
  • Verify credits and adjustments
  • Keep source invoices and proof of payment

Invoice tracker questions

Can I track invoices in Excel?

You can. Fill in invoice and payment information. Use the workbook formulas to see outstanding amounts, days overdue, monthly totals and customer balances. Replace the example entries, keep the formulas and compare entries with your own invoices and payment records.

What do I need to enter?

Invoice number, customer, issue date, due date, currency, subtotal, tax, total, amount paid, balance and status. Also include latest follow-up, payment date and notes. You input total and amount paid. A status dropdown is not proof of payment.

Will it automatically let customers know to pay?

No. It keeps track of status and follow-up notes. Use the invoicing or communication system your business uses to send reminders.

Is it possible to import the CSV into another system?

CSV has typical invoice fields and example data. Replace the examples, then match the columns, date and amount formats to your destination system. It has no Excel formulas or Dashboard. Import depends on the destination system.

Free invoice tools

Organise documents in the app

Sign in to Pocket Invoice online or install the iOS or Android app to store and manage business documents.