Freelancer Income Tracker: A Google Sheets Setup That Separates Cash and Invoices

NomadFinancials • Printable planning companion • 15 October 2026

Worked examples below are fictional illustrations. Replace the inputs with your own numbers. This is a manual worksheet, not a calculator or accounting system.

Suggested invoice table columns
ColumnPurpose
Invoice IDA unique, stable identifier
Client and projectIdentify the payer and work
Issue and due datesPreserve contractual timing
Invoice amountTotal requested, before payments
Payments appliedTotal linked receipts credited to the invoice
Credits or adjustmentsApproved reductions with explanatory notes
Outstanding amountInvoice amount − applied payments − credits
Invoice balances after recorded payments
InvoiceInvoicedPayments appliedOutstanding
INV-101$1,800$1,800$0
INV-102$1,500$900$600
INV-103$1,200$0$1,200
Total$4,500$2,700$1,800
Receipt detail for the same invoices
ReceiptGross paymentFee withheldNet deposit
INV-101, first installment$900$0$900
INV-101, second installment$900$0$900
INV-102, partial payment$900$27$873
Total$2,700$27$2,673

Your own plan

Date / periodItem / assumptionCash inCash out / allocatedBalance / next action
 
 
 
 
 
 
 
 

Do not count transfers between your own accounts as new income. Keep tax reserves and earmarked funds distinct from freely available cash.

Source guide: nomadfinancials.com/freelancer-income-tracker/