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.

Harbor Supply Co. · AR AgingUpdated Today
InvoiceClientAmountDueStatusDays
INV-1042Harbor Supply Co.$32,000.00Mar 17Current0
INV-1043Harbor Supply Co.$26,000.00Mar 24Current5
INV-1038Harbor Supply Co.$21,000.00Feb 27Monitor42
INV-1035Harbor Supply Co.$38,000.00Feb 9Monitor60
INV-1029Harbor Supply Co.$8,000.00Jan 490+ days96
INV-1044Harbor Supply Co.$14,000.00Mar 31Current0

Aging Summary

Current

$128,000.00

2 invoices

1-30 days

$46,000.00

1 invoice

31-60 days

$21,000.00

1 invoice

61-90 days

$38,000.00

1 invoice

90+ days

$8,000.00

1 invoice

Total Outstanding$241,000.00

Get this template free when you start your CentSight trial

Start your 14-day free trial and we'll send you this invoice tracking template. $0 today, card on file, cancel anytime — 5-minute setup.