Apps

How to build an invoice tracker

The short answer

Keep one row per invoice with eight columns, five statuses, and a Late view of unpaid invoices past due, oldest first. Mark Paid the day money arrives, and it tells you who owes you and since when.

3 min read

The columns and statuses

In a QuickBooks survey of US small businesses, more than half were owed money on unpaid invoices. Most of it is not refusal; it is invoices nobody followed up. Track invoices you send here, and keep bills you pay in a separate list.

ColumnExampleNote
InvoiceINV-1049Unique; the key for everything
ClientBrightline PhysioThe company you billed
Email[email protected]The accounts address, not your contact
Amount1,250Add currency if you bill in several
Sent and DueTuesday 3rd, Tuesday 17thDue is sent date plus terms
StatusSentDraft, Sent, Reminded, Paid, Written off
NotesPromised payment FridayOne line per contact

How to build an invoice tracker, step by step

  1. Step 1: Create the list

    The columns above, in a sheet or a no-code app. Make Status a dropdown.

  2. Step 2: Bring in every open invoice

    Export from your invoicing or accounting app as CSV, or type them in. Open ones first; paid history can wait.

  3. Step 3: Add a Late view

    Filter: status not Paid or Written off, due date before today. Sort by due date, oldest first.

    Tip. In a sheet, a Days late column does this: =IF(AND(G2<>"Paid",F2<TODAY()),TODAY()-F2,"").

    Do this step in 50agents

    Chase my unpaid invoices

    Build it

    Captain builds this tracker as an app, with To collect, Late and All invoices views, the three totals, and an AI agent that drafts a reminder for your yes. See the ready-made version.

  4. Step 4: Add three totals

    Still to collect (everything Sent or Reminded), Late, and Paid this month. Three numbers you can read in a second.

  5. Step 5: Update it the day money lands

    Check the bank or payment app and mark Paid.

    Watch out. A tracker a week behind the bank sends you chasing clients who already paid.

  6. Step 6: Decide what happens to late ones

    Set a reminder schedule: see how to automate invoice reminders.

What can go wrong

  • Part payments marked Paid

    Half arrives, the row turns green, and the rest is forgotten. Add a Part paid status and the amount still due.

  • Duplicate invoice numbers

    Two invoices called INV-1049 after a template copy. Make the number unique and check before adding.

  • Receivables and bills in one list

    Money in and money out get mixed up. Keep two trackers.

  • Due dates from the wrong terms

    Net 30 for a client on Net 14. Store terms per client and compute the due date from them.

Questions people ask

What should an invoice tracker include?

Invoice number, client, billing email, amount, sent date, due date, status and notes. Add currency and amount paid if you need them.

How do I track unpaid invoices in Excel or Google Sheets?

One row per invoice with a Status dropdown, a Days late formula, and a filter view of everything not Paid with a due date before today, sorted oldest first.

Should I use my accounting app instead?

If every invoice is raised there, yes: it already tracks payments. A separate tracker earns its place when invoices come from several places or you want reminders drafted for you.

What statuses should an invoice have?

Five cover most cases: Draft, Sent, Reminded, Paid and Written off. Make Status a dropdown so the Late view and the totals stay correct.

How do I record a part payment?

Do not mark it Paid. Add the amount still due and a status for part payments, so the Late view and your reminders show what is really owed.

Should bills I pay go in the same tracker?

No. Keep invoices you send and bills you pay in separate lists. Mixed together, the totals stop meaning anything.

Read next

Or let Captain build it

One sentence to Captain. Free to start.

Build it with Captain
How to build an invoice trackerBuild it