SheetFix AI

Invoice Tracker Template

Logs invoices with amounts, due dates, and payment status, then automatically totals what's outstanding and flags anything past due — so you always know who owes you and when.

Overdue, status & outstanding formulas
Days overdue:      =IF(Status="Paid","",MAX(0,TODAY()-DueDate))
Status flag:       =IF(Status="Paid","Paid",IF(TODAY()>DueDate,"OVERDUE","Open"))
Total outstanding: =SUMIF(StatusRange,"<>Paid",AmountRange)

Try it free

2 of 2 free tries left

How to use it

  1. Create columns for invoice number, client, amount, issue date, due date, and status.
  2. Add the overdue and status formulas so each row updates against today's date.
  3. Use SUMIF to total all unpaid amounts in one cell.
  4. Apply conditional formatting to highlight "OVERDUE" rows.
  5. Want aging buckets (0–30, 31–60, 61–90 days)? Describe it in SheetFix AI for the exact SUMIFS.

Related

Build your own version in seconds

Describe the tweak you need — SheetFix AI writes the formula.