Freelancers often track income in whatever format was convenient at the time — a notes app, a bank statement, a mental running total. This guide shows you how to build a proper income tracker in Google Sheets that gives you a clear financial picture: what you've invoiced, what's been paid, what's overdue, and what you actually kept after expenses.
Your Invoice Log
One row per invoice. Columns: client name, project description, invoice date, due date, invoice amount, date paid, amount paid, outstanding balance, and status (Unpaid, Partial, Paid, Overdue).
Outstanding balance:
=F2-G2
Status formula:
=IF(G2>=F2, "Paid", IF(AND(E2<TODAY(), G2<F2), "Overdue", IF(G2>0, "Partial", "Unpaid")))
Your Expense Log
One row per expense. Columns: date, description, category (software, equipment, home office, travel, professional development, etc.), and amount. These are your deductible business expenses.
Monthly Income Summary
Use SUMIFS to calculate monthly invoiced and paid amounts:
Invoiced:
=SUMIFS(InvoiceLog!F:F, InvoiceLog!C:C, ">="&DATE(2026,5,1), InvoiceLog!C:C, "<="&DATE(2026,5,31))
Collected:
=SUMIFS(InvoiceLog!G:G, InvoiceLog!F:F, ">="&DATE(2026,5,1), InvoiceLog!F:F, "<="&DATE(2026,5,31))
Expenses:
=SUMIFS(ExpenseLog!D:D, ExpenseLog!A:A, ">="&DATE(2026,5,1), ExpenseLog!A:A, "<="&DATE(2026,5,31))
Net income: Collected minus Expenses.
Tax Estimate
Add a simple quarterly tax estimate. Freelancers in the US typically owe self-employment tax (15.3%) plus federal income tax on net profit. A rough estimate for planning:
=NetIncome*0.3
Using 30% as a conservative all-in estimate. Set aside this amount each month. This isn't tax advice — consult an accountant — but it keeps you from being surprised at filing time.
The Easy Way: Using SheetXAI in Google Sheets
Example 1: You have invoice and expense data already in the spreadsheet.
"I have an invoice log on Sheet 1 and expense log on Sheet 2. Build a freelance income tracker with monthly invoiced, collected, expenses, and net income, outstanding invoice summary, and a rough quarterly tax estimate."
SheetXAI reads both sheets, builds the monthly summary, adds the outstanding tracker, and calculates the tax estimate.
Example 2: Your invoices are in an invoicing tool.
"Pull invoices from FreshBooks and expenses from my bank export and build a monthly income vs. expense summary with a net income trend."
SheetXAI connects to FreshBooks and builds the income tracker.
Try SheetXAI free and see what it builds for you.
Published May 2026. See also: How to Build an Invoice Tracker in Google Sheets, How to Create a Monthly Expense Report in Google Sheets, and Google Sheets AI Guide.
