aging buckets · late fees · CSV export · localStorage · client-side

invoice aging reportaccounts receivable agingoverdue invoice trackerlate fee calculator invoiceAR aging bucketsfreelance invoice trackercollection priority

//// Freelance · Cash Flow

Invoice Aging Report

Know exactly who owes you what and how late they are. Aging buckets, late fees, collection priority, and CSV export. Data stays in your browser.

Corp Tax Rate21%(federal flat rate)

SE Threshold$400(net earnings floor)

FICA Cap 2024$168,600(SS wage base)

Late fee rate

%/mo

Set 0 to hide late fees

Invoices

Client name

Invoice #

Invoice date

Due date

Amount

Amount paid

Status

1–30 days overdueOutstanding: $3,500.0015 days overdueLate fee: $26.25

Client name

Invoice #

Invoice date

Due date

Amount

Amount paid

Status

1–30 days overdueOutstanding: $600.005 days overdueLate fee: $1.50

Client name

Invoice #

Invoice date

Due date

Amount

Amount paid

Status

Current (not yet due)Outstanding: $2,000.00

AR Aging Summary

Total Outstanding AR

$6,100.00

$6,127.75 including accrued late fees

Current (not yet due)

$2,000.00

1 invoice

1–30 days overdue

$4,100.00

2 invoices

Collection Priority

(highest $ × most overdue first)

Client	Outstanding	Days overdue	Bucket
Acme Corp	$3,500.00	15	1–30 days overdue
Bright Ideas LLC	$600.00	5	1–30 days overdue

Total outstanding AR

Sum of (invoice amount − amount paid) for all unpaid/partial invoices

3 open invoices = $6,100.00

= $6,100.00

Overdue amount

Outstanding amount on invoices past their due date

2 overdue invoices = $4,100.00

= $4,100.00

Invoices are overdue the day after their due date

Late fees accrued

Outstanding balance × (rate%/100) × (days overdue / 30)

1.5%/mo on overdue balances = $27.75

= $27.75

At 1.5%/month, compounding monthly. Late fees are only collectible if your contract specifies them.

Total owed including late fees

Outstanding + accrued late fees

$6,100.00 + $27.75 = $6,127.75

= $6,127.75

#ShowYourWork