Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Invoice tracker open in Sheets, in the light themeInvoice tracker open in Sheets, in the dark theme

What is in it

Invoices, clients, amounts and whether each is paid, with the total invoiced. The figures are examples to type over.

Client Invoice Tracker
Invoice #Client NameAmount ($)Status
INV-1001Acme Corporation4500Paid
INV-1002Starlight Media2800Pending
INV-1003Apex Logistics6200Paid
INV-1004Vanguard Labs3100Pending
Total Invoiced Revenue=SUM(C4:C7)

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Amount ($)
=SUM(C4:C7)

Filling it in

  • Number invoices in one unbroken sequence. Gaps are the first thing an accountant asks about.
  • Add the date each was sent and the date it is due, so what is overdue can be sorted to the top.
  • Chase on the day after the due date. Late payments get later the longer they are left.

The next step

More templates

All 32 templates