InkSheet Studio
Freelancer Bookkeeping and Quarterly Tax Tracker Spreadsheet | Invoice Aging, Retainers and Set-Aside - Google Sheets
Freelancer Bookkeeping and Quarterly Tax Tracker Spreadsheet | Invoice Aging, Retainers and Set-Aside - Google Sheets
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
Who owes you, how late are they, and how much of the money that already landed is actually the tax man's?
Most freelancer bookkeeping sheets are a plain income-and-expense ledger. This one is built around the three questions a ledger never answers: which invoices are still open and how overdue they are (with an aging report that buckets them Current / 1–30 / 31–60 / 61–90 / 90+), how much of each prepaid retainer you have actually earned through, and exactly how much of each quarter's profit to hold back for estimated taxes — so April never ambushes you again.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
WHAT'S INSIDE — 12 focused tabs:
- Start Here + Dashboard — plain-English guide plus the whole business on one screen: total outstanding, every aging bucket, late fees accrued, year-to-date income, expenses and net, tax set aside vs. paid, and retainer value still to deliver
- Invoice Register + Aging Report — every invoice with balance, status, days late and a late-fee calculator; open balances bucket themselves automatically
- Income & Expense Log — one row per payment or cost, in Schedule C-style categories freelancers actually use
- Retainer & Package Tracker — prepaid fees drawn down by hours worked or sessions used, with the value remaining per client
- Quarterly Estimated Tax Set-Aside — each IRS quarter's income, expenses and net pulled from your log; your set-aside rate (25% in the samples) applied; what you paid and what's still to pay
- Mileage Log — business miles at an adjustable per-mile rate, deduction calculated per row
- Year-End Summary — income and expenses by category, net profit, mileage totals, the set-aside rollup, and a 1099 checklist (forms you should receive, and forms you must file for contractors paid $600+)
- Annual Summary — the whole year on one tab: a quarterly rollup plus monthly actual vs budget for income, expenses and net, with actual-vs-budget bars and year totals that cross-check themselves against the Year-End Summary
- Annual Tax View — Q1–Q4 income, expenses and net side by side with each quarter's estimated-payment due date, the annual totals, and the estimate lines (taxable income and estimated tax at your rate) ready for your tax pro — a view only, nothing new to type
- Offer Pricing — a 17-line lifecycle cost card: cost one offer line by line (delivery time, changes, allocations, payment fees, tax set-aside, buffer) and get a recommended price built from the true total cost
- Export - Current Year — the current year on one print-ready page, every figure pulled live from the dashboard and year-end summary, ready for your tax pro
- Export - Planning — next year's expected income, expenses and set-aside by month and quarter — a forward plan kept separate from the current-year figures
HOW IT WORKS
1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. Log invoices and payments as they happen. Balances, aging, and late fees keep themselves current from the as-of date you set.
3. Each quarter, open the Set-Aside tab, see your hold-back number, pay it, and record the payment. Done in minutes.
THE SAMPLE STORY
The file comes loaded with a fictional solo design consultant's 2026 so you can watch every flag fire: 12 invoices totaling $18,095 — $7,715 collected, $10,380 still outstanding, including one invoice 120 days past due in the 90+ bucket. The aging report shows $2,280 sitting 1–30 days late, $1,850 at 31–60, $2,400 at 61–90, and $243.60 in accrued late fees from the built-in calculator. Her three retainers have $1,725 of value still to deliver — one drawn down mid-package at 62.5%. And her quarterly set-aside totals $2,096.23 on $8,384.91 of net profit, with $272.09 still to pay clearly flagged. Delete the samples and it's your business instead.
WHY THIS ONE
The freelancer sheets on Etsy split into plain ledgers and plain invoice tools. This is the trio in one Google Sheets file: invoice aging + retainer draw-down + quarterly tax hold-back, with a dashboard that puts all three in front of you every time you open it.
PLEASE READ: This is an organization and calculation tool. It is not tax, accounting, or legal advice, and it does not file anything for you. Estimated-tax rules, late-fee rules, mileage rates, and 1099 thresholds change and vary by situation — confirm your numbers with your tax professional. The set-aside rate (25%), late-fee rate (1.5% per month), and mileage rate ($0.67) are editable starting points, not prescriptions.
FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works at your desk and on your phone.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
Share
