Freelancer Business Manager — The All-in-One Spreadsheet for Freelance Finances

One spreadsheet that runs the business side of your freelancing — without a monthly subscription.

The Freelancer Business Manager connects the five things freelancers usually track in five disconnected places: your client list, your sales pipeline, your invoices, your income and expenses, and your time. Add a client once, and every sheet reads from that one record. Change a rate in one place and every billable hour reprices itself.

What’s inside (Excel/Google Sheets workbook, 10 sheets, formulas only — no macros):

• Start Here — the 5-minute setup: set your currency label, your tax set-aside %, and a dashboard theme; tour every sheet

• Dashboard — income, expenses, and net year-to-date; outstanding and overdue invoices; tax set-aside total; hours and billable amounts this month; active and weighted pipeline value — with 3 color themes (Slate, Ocean, Forest)

• Clients — the master client table: contact details, hourly rate, payment terms, status. Everything else pulls from here

• Pipeline — every opportunity with value, stage (Lead → Proposal → Negotiating → Won/Lost), probability %, and automatic weighted value

• Invoices — invoice numbers, issue/due dates, amounts paid, outstanding balances, and automatic aging flags: overdue rows turn red, invoices due within 7 days turn amber

• Income & Expenses — categorized money in and out (client work, software, marketing, home office, travel, and more)

• Tax Set-Aside — quarterly income × YOUR set-aside % = what to put aside, with a running balance of estimated payments made. The % is yours to set — no country-specific assumptions baked in

• Time Log — date, client, project, hours, billable or not; billable rows price themselves from the client’s hourly rate

• Invoice View — pick an invoice number from a dropdown and a clean, printable invoice fills itself in

• Example data included — the Dashboard is live on first open so you can see how it all connects; delete the clearly-marked example rows and add your own

Who it’s for: Freelancers, contractors, and solo consultants who are tired of juggling a separate invoice tracker, expense sheet, and time log — and who don’t want to pay a monthly subscription for what one good spreadsheet can do.

Please note: This is an organizational tool. It is not accounting, tax, legal, or financial advice, and no income or business outcome is promised. Tax rules differ by country and region — the set-aside % is a starting point you control, not a recommendation. Consult a qualified professional for your situation.

Files: XLSX workbook. Works in Excel and Google Sheets (File → Import); no macros, formulas only.