Free download — no email required

Free Freelancer Bookkeeping Template (Excel)

A free spreadsheet to track your income and expenses and auto-generate a Profit & Loss statement — built for freelancers, sole traders, and small business owners. Open it in Excel or Google Sheets and start in minutes.

Download the template (.xlsx) See what's inside

Excel (.xlsx) · 5 ready-to-use sheets · works in Google Sheets too · 100% free

What's inside

Five sheets that do the
bookkeeping for you

This freelancer bookkeeping spreadsheet is pre-built with five linked sheets. You only type in the white cells — every total, the live dashboard, and your profit and loss template update themselves.

Income
Log every payment you receive — client, date, and amount. Your total revenue tallies automatically as you go.
Expenses
Record what you spend and pick a category from the built-in dropdown, so your expense breakdown and reports stay clean and accurate.
Live Dashboard
A real-time summary of total income, total expenses, net profit, and where your money is going — updated the moment you add a row.
P&L Statement
A clean, automatic Profit & Loss statement you can share with a client, accountant, or lender — or file at tax time.
Start Here (Instructions)
A short guide sheet that walks you through filling in the template, plus tips to keep your small business bookkeeping accurate.
How to use it

From blank sheet to P&L
in four steps

1
Download & open
Grab the free .xlsx above and open it in Excel or Google Sheets. No sign-up, no email, no cost.
2
Log your income
On the Income sheet, add each payment you receive — client, date, and amount.
3
Log your expenses
On the Expenses sheet, enter what you spend and choose a category from the dropdown.
4
Read your reports
Open the Dashboard and P&L Statement — your totals and profit are already calculated.
Free download

Your free Excel bookkeeping
template, ready to go

Whether you call it a bookkeeping spreadsheet, an income and expense tracker template, or simply a profit and loss template, this free download covers the essentials of small business bookkeeping in one file — no accounting software to learn and no monthly fee. Track everything in your own currency and keep a clean record of your freelance finances.

Download the free template (.xlsx)
No email required Excel & Google Sheets Free to use & share

Tired of maintaining a spreadsheet?

The template is great for getting started — but updating rows by hand gets old fast. Wise Ledger does all of this automatically on your phone: log income and expenses in seconds and get your Profit & Loss, Balance Sheet, budget, and tax estimate instantly. Free to start — the free plan never asks for a card.

Get it on Google Play