Freelancer Bookkeeping Spreadsheet (Auto-Categorized Summary)

Most freelancer "bookkeeping templates" are one flat list you still have to total up yourself at tax time. This one is two linked tabs: log every payment and expense in the Transactions tab, and the Summary tab calculates your total income, total expenses, net profit, and a full category breakdown automatically — with a rough quarterly tax set-aside estimate built in.

What's inside:

• A Transactions tab with 14 example entries (income and expenses mixed, realistic categories) plus 6 blank rows ready for your own log
• A Summary tab that pulls everything from the Transactions tab automatically using real cross-sheet formulas \u2014 no manual totaling
• An expense category breakdown (Software & Subscriptions, Home Office, Equipment, Marketing, Travel, Professional Services, Other) that updates itself as you log new transactions
• An estimated quarterly tax set-aside calculator \u2014 set your own rate, and it multiplies against your actual Net Profit automatically

Who this is for:

Freelancers and independent contractors who want their income and expenses to organize themselves into a real summary instead of a single long list they have to re-total by hand every quarter.

Format & technical notes:

Delivered as an .xlsx (opens in Excel, Google Sheets, and Numbers) with working formulas across both tabs. No PDF, no macros, no subscription — this is a live spreadsheet tool, and it works offline once downloaded. This is a planning tool, not tax advice — consult a tax professional for your actual filing.