Freelancer Income & Expense Template

Freelancer Income and Expense Spreadsheet with tax-ready P&L, invoice tracker, and quarterly tax estimate. Know what you earned, what you owe, and what to set aside.

WHAT'S INCLUDED (6 sheets):

- Income Log — amount invoiced vs. received, Paid / Unpaid / Overdue

- Expense Log — every cost by category, deductible flag, totals by category

- P&L Dashboard — monthly income, expenses, and net profit, Jan–Dec

- Tax Estimate — self-employment, federal, and state tax from net profit, editable rates, quarterly payment

- Client Summary — invoiced, received, and still owed per client

- Cover & How to Use — start here

PLEASE NOTE:

- Instant digital download. No physical item ships.

- Works in Microsoft Excel and Google Sheets (upload to Google Drive to open in Sheets).

- Example data is included so you can see how it works. Replace the yellow cells with your own numbers — yellow cells are the only ones you edit.

- This is a bookkeeping tool, not tax, legal, or CPA advice.

- Built by an accountant: B.S. Accountancy, ASU W. P. Carey, with revenue-reconciliation experience at Marriott and audit work at PwC.