Freelancing often means doing your own accounting.
No body else is in charge of withholding your taxes. No HR department sends you a W-2. For many freelancers, the accounting side of the business is just a folder of invoices, a few clients paying on different schedules, and a number be calculated when April arrives.
That’s why I made this freelancer income tracker for Google Sheets. Nobody wants a surprise during tax season, and a little preparation keeps surprises to a minimum. Log every payment as it comes in, flag what’s still outstanding, and watch your quarterly tax estimate update in the background.
Click here to copy the template to your Google Drive.
What’s Included
The template has three tabs: Income Log, Tax Tracker, and Instructions.
Income Log
One row per payment. The columns cover everything you need for tax documentation and client reporting:
- Date Invoiced and Date Paid
- Client
- Project / Description
- Invoice Number
- Amount Invoiced and Amount Received (tracked separately for partial payments)
- Payment Method (dropdown: Bank Transfer, PayPal, Venmo, Zelle, Check, Cash, Stripe, Other)
- Income Category (dropdown: Freelance, Consulting, Retainer, Royalties, Contract Work, Other)
- Status (dropdown: Paid, Pending, Overdue, Partial, Cancelled)
- Tax Year and Quarter (auto-calculated from the invoice date)
- Notes
The totals row at the bottom calculates gross income and total outstanding automatically. The header bar updates your YTD total and outstanding balance as you add rows.
Tax Tracker
Enter your federal income tax rate, state rate, and the self-employment tax rate at the top. The template pre-fills the SE rate at 15.3% per IRS standards. Change it only if your accountant tells you to.
Below that, the quarterly breakdown pulls income from the Income Log by quarter and year, applies your combined rate, and shows your estimated tax owed for each period alongside the due date. All four 2026 deadlines are listed. Miss one and the IRS charges interest. The tab exists so that doesn’t happen.
The annual summary at the bottom shows gross income, number of invoices, estimated total tax, and estimated take-home after taxes. Income is also broken down by category, pulling directly from the Income Log.
Instructions Tab
Eight steps covering setup, tax rate entry, how partial payments work, and what to do at year-end when your 1099s start arriving. Worth reading on first use.
How to Use It During the Year
Log each payment the day it hits your account. That habit is the whole system. A template you update weekly becomes a reconciliation project. One you update daily is just a record.
Use the Status column as your invoice dashboard. Anything Pending or Overdue is money you haven’t collected. Sort by Status every few weeks and follow up on anything outstanding past 30 days.
The Income Category column matters if your work spans multiple types. Retainer revenue looks different than one-off project work. Knowing the split helps when you’re forecasting or explaining your income mix to an accountant.
How to Use It for Taxes
The Tax Tracker estimates your quarterly liability based on gross income received. Set your rates at the top of that tab and the numbers flow down automatically.
The tracker doesn’t replace an accountant. It means you walk into that conversation with real numbers instead of guesses.
For deductible business expenses, this template pairs with our Google Sheets expense tracker. Income here, expenses there. Your net profit is the difference, and net profit is what your taxes are based on.
If you traveled for client work this year, our travel expense log template handles trip-by-trip documentation. And if you drove for meetings or site visits, the mileage log template keeps that deduction clean.
How to Use It for Client Reporting
Filter by client to see total revenue from a single source. That number is useful when you’re deciding whether a relationship is worth the time it takes, or when you’re preparing a rate increase conversation backed by actual data.
The Income Category breakdown on the Tax Tracker shows where your revenue is coming from. If 80% is retainer work and 20% is project work, that’s worth knowing before you pitch your next client.
Frequently Asked Questions
Do I need to track income if my clients send 1099s?
Yes. A 1099 reflects what your client reported paying you, not necessarily what you received or when. Clients sometimes issue 1099s with errors. Tracking income yourself means you can catch discrepancies before you file. You’re also required to report all freelance income, including payments under $600 that don’t generate a 1099.
How do I handle partial payments?
Use the Amount Invoiced and Amount Received columns separately. Set Status to Partial. When the remaining balance arrives, update Amount Received and change Status to Paid. The totals row tracks both figures so the gap is visible at a glance.
What self-employment tax rate should I use?
The IRS self-employment tax rate is 15.3% on net self-employment earnings up to the Social Security wage base, with 2.9% above that. Federal income tax applies on top of this at whatever marginal rate fits your total income. The Tax Tracker has fields for both. If you’re not sure, start with 25 to 30% as a combined estimate and adjust when you have better information.
When are quarterly estimated tax payments due in 2026?
April 15, June 16, September 15, and January 15, 2027. The Tax Tracker lists all four. Missing a deadline doesn’t mean an automatic penalty, but interest accrues on underpayments. Paying on time is the simpler path.
Can I track multiple income streams in one file?
Yes. Use the Income Category dropdown to separate different types of work. The Tax Tracker breaks totals down by category automatically. For complex situations involving multiple business entities, a separate file per entity is cleaner.
How is this different from the expense tracker?
This template tracks money coming in. The expense tracker tracks money going out. Your net profit for tax purposes is the difference. Use both for a complete picture of your freelance finances.