Freelancer Finance Suite Spreadsheet Template for Excel & Google Sheets
Track projects and hours, log client income and deductible expenses, set aside the right amount for taxes, and see how many months of runway you have - all in one workbook. Built for solo freelancers and consultants, dual compatible with Microsoft Excel and Google Sheets.
One-time purchase
Freelancer Finance Spreadsheet
Everything in This Freelancer Spreadsheet
Your Freelance Business at a Glance
Open the dashboard and see where you stand. YTD income, deductible expenses, net pre-tax, and effective hourly sit on the top row. Tax reserve balance, projected tax owed, surplus or shortfall, and runway in months sit beneath. A banner flags whether your reserve covers the tax bill.
- 8 KPI cards covering income, tax, and runway
- Reserve banner flags shortfall or surplus
- Income vs expenses and project revenue charts
Track Every Project and Rate
Log each project with client, rate, hours logged, and hours billable. Revenue calculates automatically as billable hours times rate. A status field marks projects Active or Done and totals roll up at the bottom.
- Per-project rate, hours, and status
- Revenue auto-calculated from rate and billable hours
- Hours logged vs billable - separates time from invoiced
Log Invoices and See What's Open
Enter each invoice with date, client, project, amount, and paid date. Leave Paid date empty to mark an invoice open. The Status column flips between Open and Paid automatically, and the total at the bottom feeds the dashboard.
- Date, client, project, amount, paid date
- Status auto-flips between Open and Paid
- YTD total feeds the dashboard
Split Mixed-Use Expenses for Tax
Each expense gets a category, an amount, and a business percentage. Deductible calculates as amount times business percent, so phone at 80% and meals at 50% land in the deductible total at the right share. Use it to keep clean numbers for tax time.
- Category, amount, and business % per row
- Deductible = amount × business %
- Handles phone, meals, home office splits
Know What You Owe and What You Have
The Tax Reserve sheet walks YTD income to deductible to net to tax owed at your setaside rate. Then it shows your current reserve balance and the surplus or shortfall. If the surplus turns negative, raise the rate on Settings.
- Income to deductible to net to tax owed
- Reserve balance vs tax owed
- Surplus or shortfall in plain numbers
See How Long the Reserve Lasts
Set your monthly personal burn on Settings and the dashboard shows runway in months - reserve balance divided by burn. The Income vs Expenses chart by month and the project revenue mix help you see where the money is coming from.
- Runway = reserve / monthly burn
- Income vs expenses by month chart
- Project revenue mix chart
Configure It for Your Practice
Set your business name, currency, and fiscal year. Enter your tax setaside rate, current reserve balance, and monthly personal burn. The rest of the workbook reads these values, so you set them once.
- Business name, currency, fiscal year
- Tax setaside rate and reserve balance
- Monthly personal burn for runway
Up and Running in 15 Minutes
Start on Settings, list your active projects, then log invoices and expenses as they happen. Light gray cells are inputs. Revenue, deductible, tax owed, and KPIs are formulas - they update as you type.
- Settings, then Projects, then Income and Expenses
- Light gray cells are inputs - the rest is formulas
- Built for solo freelancers and consultants
Customizable & Flexible
Adapt the workbook to your practice. Rename categories, add project rows, tweak the tax setaside rate - the formulas update automatically. Works identically in Excel and Google Sheets.
- Rename categories and add project rows
- Adjust setaside rate and reserve balance
- Excel and Google Sheets compatible
Ready to take control of your finances?
Set Up in 15 Minutes
How the Freelancer Suite Works
Open in Excel or Google Sheets
Get instant access after purchase. Open in Microsoft Excel directly, or import into Google Sheets - no software to install, no add-ons.
Configure Your Practice
Set your business name, currency, fiscal year, tax setaside rate, reserve balance, and monthly personal burn on the Settings sheet. Takes about 15 minutes.
List Projects and Log Income
Add your active projects with rate and hours, then log invoices as they go out. Status flips between Open and Paid automatically.
Track Expenses and Tax Reserve
Enter expenses with a business percentage for mixed-use items. The Tax Reserve sheet shows what you owe and whether your reserve covers it.
Customer Reviews
Used by Freelancers and Consultants Worldwide
"If I get half as good at handling my finances as you are at customer service, this'll be the best $26 I've spent lately."
"Great tool! Simplifies financial planning without the hassle of complex spreadsheets."
"I recently purchased your super convenient spreadsheet, it really helps me!"
"They're great and super intuitive. Thank you!"
Built for Solo Operators
Why Freelancers Use This Workbook
Built for Solo Freelancers
Projects, income, expenses, tax reserve, and runway in one workbook - no chart of accounts, no monthly close.
No Formulas to Write
Enter numbers in highlighted input cells. Revenue, deductible, tax owed, runway, and all KPIs are pre-built and update automatically.
Excel and Google Sheets
Works identically in Microsoft Excel and Google Sheets. No macros, no add-ons, no proprietary functions.
Free Lifetime Updates
All future improvements to the freelancer suite included at no extra cost.
Your Financial Data Stays Private
Runs entirely in your spreadsheet. Your data stays in your file - we never see or store it.
One-Time Purchase
Pay once, use forever. No subscriptions, no monthly fees, no recurring charges.
Got Questions?
Frequently Asked Questions
Is this template free to use?
This template is not free, but it is available for a one-time purchase. This purchase gives you lifetime access to the template and all future updates.
What do you mean by lifetime access?
Lifetime access means that you will have access to this template for as long as you need it. You will not be required to pay any additional fees for continued access to the template or any future updates.
Do I need to sign up to use this template?
You don't need to create an account with us. The template works in Google Sheets, so you'll need a Google account. If you don't have one, you can create one for free at google.com. After you purchase the template, copy it to your Google Drive, and start using.
What are the benefits of using this template?
This template offers a range of benefits, including: Easy-to-use interface, Customizable to suit your needs, Secure and private, Regular updates and improvements, One-time purchase for lifetime access.
Can I get future updates?
Yes, you will receive all future updates to this template at no additional cost. This ensures that you always have access to the latest features and improvements.
Do you offer any discounts?
At this time, we do not offer any discounts on this template. However, the template is available for a one-time purchase, which provides lifetime access and free updates.
Do you have any access to my financial data?
No, we do not have access to your financial data when you use this template. The template is designed to be used in your own Google Sheets account, ensuring that your financial information remains private and secure.
Is this template financial advice?
Our templates are not financial advice. They are tools designed to help you manage your personal finances more effectively. If you need personalized financial advice, consider consulting with a financial advisor or accountant.
Can I make my own changes and customize this template?
Yes, you can make your own changes and customize this template to suit your needs. The template is designed to be flexible and adaptable, allowing you to add or remove sections, change formulas, and adjust formatting as needed.
Do you offer technical support?
This is a self-service product, and we do not offer technical support. However, if you encounter any issues or have any questions about the template, please contact our team for assistance. Because everyone's financial situation is unique, consider consulting with a financial advisor or accountant if you need personalized financial advice.
Do you offer refunds?
All sales are final. Because these are digital products delivered instantly, we do not offer refunds.
Can't find the answer you're looking for? Contact our team
Highlights:
Run Your Freelance Business from One Workbook
Get the Freelancer Finance Suite and track projects, income, expenses, tax reserve, and runway in Excel or Google Sheets.