Track Invoices vs. Payments Received: A Freelancer Reconciliation Guide

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.

Invoice recordPayment recordWhy the distinction matters
Invoice number and clientInvoice reference on paymentLinks each receipt to the right receivable
Invoice issue and due datesPayment and bank-settlement datesSeparates contract timing from available cash
Invoice totalGross payment, fee, and net depositExplains why the bank amount can be smaller
Credits or approved adjustmentsRefunds and chargebacksPrevents stale balances after a correction
Outstanding amountPayment statusDistinguishes unpaid from pending settlement
ItemAmountEffect
Original invoice$1,200Starting amount owed
Gross client payment$400Reduces amount owed by $400
Processor fee$12Explains settlement difference
Net bank deposit$388Cash reaching the bank
Remaining invoice balance$800$1,200 minus $400

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/track-invoices-vs-payments-received/