Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Freelancer Finance Tracker ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Freelancer Finance Tracker Spreadsheet Template for Google Sheets & Excel

Hours and an hourly rate sit behind every invoiced figure, expenses are recorded against the project they belong to, and net income is worked out once a project is marked Paid. The Essentials Freelancer Finance Tracker spreadsheet template logs thirty projects with client and project name on each row, marks whether payment has landed, and rolls the year into a Dashboard. Google Sheets and Excel, one file. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Freelancer Finance Tracker Spreadsheet Template
$29
Essentials Freelancer Finance Tracker spreadsheet template - Google Sheets and Excel preview

What's Included

  • Client and project name on every row
  • Hours and an hourly rate behind the invoiced figure
  • A status marking whether payment has landed
  • Expenses recorded against each project
  • Net income worked out for you once a project is marked Paid
  • Total invoiced across every project
  • Total paid, and what is still outstanding
  • A project count on the dashboard
  • One chart across the projects
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • Client and project name on every row
  • Hours and an hourly rate behind the invoiced figure
  • A status marking whether payment has landed
  • Expenses recorded against each project
Ultimate - $29
  • An income log with date, client, project, method, status and invoice number
  • Paid, pending and overdue totalled separately
  • An expense log with categories and a deductible marker
  • Clients ranked by revenue, with profit, margin and average per project
  • A quarterly sheet with a self-employment tax calculation
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Freelancer Finance Tracker Spreadsheet Template is a two-sheet workbook for Google Sheets and Excel, with a How to Use guide on a third tab. It works as an Essentials Freelancer Finance Tracker Excel template and an Essentials Freelancer Finance Tracker Google Sheets template from the same download. Thirty projects with hours, an hourly rate, what was invoiced, what it cost you and what you kept - with a dashboard separating what has been paid from what is still owed. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Freelancer Finance Tracker spreadsheet template

The FinancialAha Essentials Freelancer Finance Tracker Spreadsheet Template runs on two working sheets, with the instructions on a tab of their own. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Freelancer Finance Tracker spreadsheet holds.

  1. 01 of 02

    Project Log

    A row per project, and each carries the whole shape of a job: the client, the project, the hours it took, the rate, what was invoiced, whether it has been paid, what it cost you in expenses and what you kept after them. The hours column is the one that earns its place. A project fee tells you what the work paid; hours against that fee tell you what it paid per hour, which is the figure that separates a client worth keeping from one that only looks profitable. Expenses do the same job from the other side - a job with materials or subcontractors in it is a different job from one without. Net income is worked out for you rather than typed, but only once a project's status is set to Paid - the column stays blank until then, so it never counts income you have not actually collected.

    FinancialAha Freelancer Finance Tracker spreadsheet template - Project Log sheet

  2. 02 of 02

    Dashboard

    What the log adds up to, split by whether the money has arrived. Total invoiced across every project, total paid, and what is outstanding - the figure that tends to get carried in someone's head rather than written down - with the total of your project expenses and the number of projects tracked beside them. That split is the difference between a good month and a paid one. A dashboard that reported only revenue would say the same thing for a freelancer with everything collected and one with half of it thirty days late. A bar chart alongside breaks the projects down by invoice status.

    FinancialAha Freelancer Finance Tracker Google Sheets template - Dashboard sheet

  3. Included guide

    How to Use

    A step-by-step guide on its own tab, covering what each column expects, how the status drives the paid and outstanding figures, and how to change the currency. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Freelancer Finance Tracker Spreadsheet template for Google Sheets

Upload the Essentials Freelancer Finance Tracker Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Freelancer Finance Tracker Google Sheets template needs no conversion step, the chart comes across, and the dashboard recalculates from the log exactly as it does in Excel.

Essentials Freelancer Finance Tracker Google Sheets template setup

A shared copy of the Essentials Freelancer Finance Tracker Google Sheets template is what an accountant can be pointed at directly, and the outstanding figure is the one an accountant asks about first.

Running the Essentials Freelancer Finance Tracker Google Sheet

The Essentials Freelancer Finance Tracker Google Sheet takes a row per project and a status change when payment lands. The dashboard follows from those two habits.

Also available as:

Essentials Freelancer Finance Tracker Spreadsheet template for Excel

The Essentials Freelancer Finance Tracker spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Freelancer Finance Tracker Excel template directly, with no import step, and the chart is a native Excel chart rather than a picture. There are no macros and no VBA in the file.

Essentials Freelancer Finance Tracker Excel template setup

The same Essentials Freelancer Finance Tracker Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Freelancer Finance Tracker spreadsheet download to choose between.

Essentials Freelancer Finance Tracker spreadsheet Excel notes

The Essentials Freelancer Finance Tracker spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt.

Opening the Essentials Freelancer Finance Tracker spreadsheet Excel file

Nothing in the Essentials Freelancer Finance Tracker Excel template is version-specific, so this Essentials Freelancer Finance Tracker spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Freelancer Finance Tracker spreadsheet template tracks

A row per project. This is what the Essentials Freelancer Finance Tracker Spreadsheet Template records for each one:

Client
who the work is for, and what the dashboard groups by
Project
what the work was
Hours
what it actually took, which is what turns a fee into a rate
Effective Rate/Hr auto
what the invoice worked out to per hour, derived rather than entered
Invoiced
what went on the invoice
Status
paid or not, which drives the paid and outstanding figures
Expenses
what the job cost you
Net Income auto
derived once the status is Paid, what you kept after them

Compare builds

FinancialAha Freelancer Finance Tracker spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 2 6
Project rows 16 30 150 income lines
Hours and hourly rate – Yes –
Paid or unpaid status – Yes Yes
Outstanding total – Yes Yes
Expenses – Per project Their own log, with a deductible marker
Net income – Per project Across the business
Profit by client – – Ranked, with margin
Quarterly tax estimate – – Yes, figures you enter
Annual profit and loss – – Automatic, from the two logs
Charts – 1 2

The Free Freelancer Finance Tracker Spreadsheet Template lists projects, clients and amounts with no concept of an invoice or a payment. The FinancialAha Essentials Freelancer Finance Tracker Spreadsheet Template adds the money side: hours and a rate behind the invoiced figure, a paid marker, per-project expenses and net income, and a dashboard splitting what is invoiced into what has been paid and what is outstanding. The Ultimate Freelancer Finance Tracker Spreadsheet Template goes further into the business - separate income and expense logs with a deductible marker, profit ranked by client, a quarterly tax estimate and an annual profit and loss.

Compare the other builds: Free Freelancer Finance Tracker spreadsheet template or the Ultimate Freelancer Finance Tracker spreadsheet template .

Good to know

Notes on working in the Essentials Freelancer Finance Tracker spreadsheet template

  • Hours against the fee is what turns a project into a rate, which is the figure that separates clients worth keeping.
  • Expenses per project matter more than they look - a job with materials in it is a different job from one without.
  • Net income only calculates once a project is marked Paid, so it never counts income that has not actually landed.
  • The status column drives the paid and outstanding totals, so it is the one field worth keeping current.
  • Outstanding is the number most freelancers carry in their head and get wrong.
  • The currency dropdown relabels the money columns across the workbook. It changes the label only and does not convert the numbers.

How to Use the Essentials Freelancer Finance Tracker Spreadsheet Template

1

Log the project

Client, project, hours and your rate.

2

Record the invoice

What went out, and any expenses on the job.

3

Mark it paid

The status drives paid and outstanding.

4

Read the dashboard

Invoiced, paid, and what you are still owed.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Freelancer Finance Tracker Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The chart comes across in the Essentials Freelancer Finance Tracker Google Sheets template, and the dashboard recalculates from the log exactly as it does in Excel.

Is the FinancialAha Essentials Freelancer Finance Tracker Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Freelancer Finance Tracker Excel template opens directly in Excel with no import step. The chart is a native Excel chart rather than a picture, and there are no macros or VBA.

Will the FinancialAha Essentials Freelancer Finance Tracker spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Freelancer Finance Tracker spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

Why does the Essentials Freelancer Finance Tracker spreadsheet record hours if I charge a fixed fee?

Because hours against the fee is what turns a project into an hourly rate, and that is the figure that separates a client worth keeping from one that only looks profitable.

What does the outstanding figure show in the Essentials Freelancer Finance Tracker spreadsheet?

What has been invoiced and not yet paid. A dashboard reporting only revenue would say the same thing for a freelancer with everything collected and one with half of it thirty days late.

Is net income typed or calculated in the Essentials Freelancer Finance Tracker spreadsheet?

Calculated, from the invoiced figure less the expenses on that row - but only once the status is set to Paid. Until then the cell stays blank rather than counting income not yet collected.

How many projects does the Essentials Freelancer Finance Tracker spreadsheet hold?

Thirty, against sixteen on the Free build. The Ultimate build moves to separate income and expense logs.

How do I open the Essentials Freelancer Finance Tracker spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Business Finance Templates

Cash Flow Statement

Twelve months across the page, with operating, investing and financing activities grouped into sections of their own and an annual total closing the grid. The Essentials Cash Flow Statement spreadsheet template carries the cash position month to month - you enter January's opening balance and the rest link forward - and follows the usual accounting convention on the working-capital lines. Three working sheets. Google Sheets and Excel. No macros, no VBA.

$19

Profit & Loss Projection

Year one is what you enter; years two and three are worked out from six assumptions you set - revenue, cost of goods sold and operating expense growth, plus a tax rate. The Essentials Profit & Loss Projection spreadsheet template runs thirteen lines from revenue through gross profit and margin, operating income, EBITDA, interest and income before tax, down to net income, with a dashboard over the top. Google Sheets and Excel. No macros, no VBA.

$19

Sales Forecast

Ten product lines forecast across twelve months, then the same ten again recording what actually happened, with the variance worked out per month in money and as a percentage. The Essentials Sales Forecast spreadsheet template gives every line an annual total and a share-of-total figure, and reports the year total and the implied growth on a dashboard. Two working sheets, Google Sheets and Excel. No macros, no VBA.

$19

Startup Costs

Fourteen one-time costs and twelve monthly operating ones stay on lists of their own, each line carrying an estimate, an actual, the variance and a per-cent-spent figure. The Essentials Startup Costs spreadsheet template builds a first-year total from both, one-time plus twelve months of operating, and sets up to six funding sources against it. A notes column records what each figure assumes. Google Sheets and Excel. No macros, no VBA.

$19
Essentials
Preview
See Freelancer Ultimate Pack 8 templates included • Save $113

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →