Freelancer Bookkeeping Tracker

An invoice goes out, the work gets done, and the payment quietly becomes 120 days late. Nobody notices, because nothing in a plain ledger ages an invoice, accrues the late fee, or asks what is still owed on the retainer. This tracker does all three, in one Google Sheets file, 12 tabs. The Invoice Register ages every open balance into buckets — Current, 1–30, 31–60, 61–90, 90+ — with a late-fee calculator running on each. The Retainer Tracker draws prepaid packages down by hours or sessions and shows the value still to deliver per client. The Quarterly Tax Set-Aside pulls each quarter's income, expenses and net from the log and applies your set-aside rate, with what you paid and what is still to pay.

Around them sit an Income & Expense Log in Schedule C-style categories, a Mileage Log, a Year-End Summary with the 1099 checklist, an Annual Summary and Annual Tax View, an Offer Pricing card, and two print-ready export tabs. The fictional sample year belongs to one solo design consultant: 12 invoices totaling $18,095, $7,715 collected, $10,380 outstanding, $243.60 in accrued late fees, $1,725 of retainer value still to deliver, and $2,096.23 set aside on $8,384.91 of net. An organization and calculation tool, not tax or accounting advice.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished spreadsheet file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.