Free Template

Free Invoice & AR Tracking Template

Track every invoice from sent to paid. See aging buckets at a glance, know which clients owe you money, and stop letting receivables fall through the cracks.

Every detail for managing receivables

  • Invoice #, client name, and amount columns
  • Date sent and due date tracking
  • Status field: draft, sent, current, overdue, paid
  • Days outstanding auto-calculated
  • Aging buckets: current, 1-30, 31-60, 61-90, 90+ days
  • Summary dashboard with total outstanding AR
  • Aging analysis with dollar amounts per bucket
  • Average days to payment metric

Who it's for

Service businesses, agencies, and B2B companies that invoice clients and need to stay on top of collections. If you've ever lost track of an unpaid invoice, this template fixes that.

InvoiceClientAmountDueStatusDays
INV-1042Acme Corp$12,500Mar 17Paid0
INV-1043Beacon LLC$8,200Mar 24Current5
INV-1038Delta Inc$15,000Feb 2731-60 days42
INV-1035Forge Co$6,750Feb 961-90 days60
INV-1029Summit Ltd$22,000Jan 490+ days96
INV-1044Neon Digital$4,800Mar 31Current0

Aging Summary

Current

$13,000

2 invoices

1-30 days

$0

0 invoices

31-60 days

$15,000

1 invoice

61-90 days

$6,750

1 invoice

90+ days

$22,000

1 invoice

Total Outstanding$56,750

Get this template free when you join the CentSight waitlist

Join the waitlist and we'll send you this invoice tracking template, plus early access to CentSight when we launch.