Bookkeeping for Freelancers: A Simple Spreadsheet System

A note before you start

This guide is general information about record keeping. It is not tax or accounting advice. Tax rules, deductions, registration thresholds and record retention periods differ between countries and change over time, so please check with a registered accountant or your tax authority about your own situation.

The short answer

Bookkeeping for freelancers means keeping a clear record of the money that comes into your business, the money that goes out, and the invoices still unpaid. A simple spreadsheet with an income log, an expense log, a mileage log and a monthly summary is enough for many sole traders. The key is to update it regularly and keep your receipts, so your accountant has accurate figures at year end.

Why bookkeeping matters

Many freelancers start by treating their business account like a personal one. It works until tax time, when you need to explain what the money was for. Good records do several jobs at once:

• They show whether the business is actually profitable, not just busy
• They help you set money aside for tax
• They make it quick for an accountant to prepare your return, which usually costs less than sorting through a shoebox of papers
• They show who owes you money, so you can chase it
• They give you evidence if your tax authority asks questions

Bookkeeping is also different from accounting. Bookkeeping is the day-to-day recording of transactions. Accounting is the interpretation, reporting and tax work built on those records, and an accountant often does it.

Step 1: separate business and personal money

Before you build any sheet, separate your finances. If you can, open a dedicated business bank account and, if you use one, a separate card for business spending. Pay yourself from the business account to your personal account on a regular basis.

This single step makes everything simpler. Every transaction in the business account is a business transaction, and you do not need to untangle your groceries from your software subscriptions.

If you cannot separate them completely, mark each personal transaction clearly and keep it out of the business records.

Step 2: decide on the basics

Three decisions shape your spreadsheet.

Financial year. Know the start and end dates of your tax year, which differ by country. Set the sheet up around it.

Cash or accrual basis. Under the cash method, you record income when you are paid and expenses when you pay them. Under the accrual method, you record them when you invoice or receive a bill, regardless of payment. Many small sole traders use the cash method, but the rules and options depend on where you live, so ask your accountant which applies.

Categories. Decide on a short list of income and expense categories that match how you work.

Step 3: set up your categories

Keep the list short. Around five or fewer income categories and 15 to 20 expense categories are usually enough.

Type	Example categories
Income	Client projects, retainers, product sales, other
Expenses	Software and subscriptions, equipment, advertising and marketing, professional fees, insurance, phone and internet, travel, home office costs, bank fees, training, subcontractors, office supplies

Whether an expense is deductible depends on your country and circumstances, so a flag on each category that says “check with accountant” is more honest than assuming. Your accountant can confirm the rules and tell you how to treat items such as a home office.

Step 4: build the core sheets

You can do this in Excel or Google Sheets. Make one tab for each of the following.

Income log

Columns to include:

Date	Client	Invoice number	Description	Category	Amount	Status	Date paid

Status can be a drop-down with Paid, Unpaid and Overdue. Add every invoice when you issue it, then update the status when it is paid. Drop-down lists, through data validation, keep entries consistent.

Expense log

Columns to include:

Date	Supplier	Description	Category	Amount	Paid by	Receipt kept?

A “Receipt kept?” column is a small addition that pays off. When your accountant asks for evidence, you know straight away which items have it.

Mileage log

If you drive for work, a mileage or logbook record is often needed to claim vehicle costs, though the method differs by country. Record the date, start and end points, purpose, distance and, if relevant, the odometer readings. Ask your accountant which method suits you.

Invoice tracker

You can combine this with the income log, but a separate view of unpaid invoices helps. For each unpaid invoice, show the client, amount, issue date, due date and the number of days overdue. The formula =TODAY()-E2 gives days since the invoice date, and you can subtract the due date to get days overdue. Sort or filter by that column to see who to chase first.

Monthly summary

A summary tab totals income and expenses by category for each month, using SUMIFS formulas. Profit is income minus expenses, and margin is profit divided by income. Seeing 12 columns side by side shows seasonal patterns and unexpected costs.

Step 5: set aside money for tax

Many freelancers get caught out because no one withholds tax from their income. A common habit is to move a percentage of every payment into a separate savings account as soon as it arrives.

What percentage? That depends on your income, your country and your situation, so ask an accountant to suggest a sensible figure. Whatever you choose, treat it as a reminder amount rather than a precise calculation. You can adjust it after your first return or an accountant’s estimate.

Step 6: a simple routine

Bookkeeping falls apart when it is left for months. A small, regular routine keeps it manageable.

Weekly (15 minutes)

• Enter new invoices and payments received
• Log expenses and add receipts
• Chase invoices that are overdue

Monthly (30 to 45 minutes)

• Reconcile your records against the bank statement: every bank transaction should match a line in your sheets
• Review the monthly summary and note anything odd
• Transfer your tax set-aside, if you do this monthly
• Back up the file

Quarterly or at year end

• Check whether any tax payments or filings are due, as the schedule depends on your country and registration
• Review your pricing and costs against your results

Reconciliation is the step that catches mistakes. If the totals do not match, look for a missing entry, a double entry or a transfer you recorded as income.

Receipts and records

Keep proof for your expenses and income: invoices you issued, bills you received, receipts and bank statements. Photograph paper receipts with your phone and store them in a folder named by month. Use a consistent file naming pattern such as 2027-03-14-Supplier-Amount.jpg.

How long you must keep records depends on your country and the type of record. Tax authorities publish guidance on this, and your accountant can confirm it. If you are unsure, keep them for longer.

What to give your accountant

At year end, your accountant will usually ask for some or all of the following:

• A summary of income and expenses by category
• Your mileage log, if you claim vehicle costs
• Details of larger purchases, such as equipment
• Bank and card statements
• A list of unpaid invoices at year end
• Details of any loans, grants or other money that came into the business
• Receipts or supporting documents on request

Ask your accountant in advance what format they prefer. Many accept a spreadsheet export.

Common mistakes

• Mixing personal and business money. Keep them apart wherever you can.
• Leaving it until tax time. A year of transactions takes much longer to sort than a week.
• Forgetting unpaid invoices. Late payments hurt cash flow more than low sales do.
• Not saving receipts. A missing receipt can make an expense hard to support.
• Treating cash in the bank as profit. The balance includes money you owe in tax and to suppliers.
• Guessing at tax rules. Check with a professional rather than relying on forum posts.

Using a ready-made workbook

You can build everything above yourself, and it is a good way to learn how the pieces fit. If you would prefer to start with the structure in place, the Small Business Bookkeeping Spreadsheet is a workbook with a setup tab, income and expenses logs, a mileage log, an invoice tracker, a monthly profit and loss, a dashboard and a year-end summary with a checklist for your accountant. It comes with a filled example business and works in Excel and Google Sheets, in any currency. It is a record-keeping tool, not tax or accounting advice, and the tax set-aside is a reminder at the percentage you choose.

Your personal money still needs looking after too. If your income is irregular, a separate personal budget with sinking funds for the gaps helps. Our guide to how to make a budget spreadsheet covers the basics, and the Chalkline Money System 2027 offers a ready-made version.

Frequently asked questions

Do freelancers need bookkeeping software?

Not necessarily. A well-organised spreadsheet is enough for many sole traders with a modest number of transactions. Software can help once volume grows, you need automatic bank feeds, or you must issue many invoices or handle sales tax. Ask your accountant what they prefer to receive.

How often should I do my bookkeeping?

Update invoices and expenses weekly, and reconcile against your bank statement monthly. Small, regular sessions are far less painful than a big catch-up at year end.

What records should a freelancer keep?

Generally, invoices you issue, bills and receipts for what you buy, bank and card statements, mileage records if relevant, and any contracts. The exact requirements and retention periods depend on your country, so check with your tax authority or accountant.

Can I do my own bookkeeping and still use an accountant?

Yes. Many freelancers keep their own day-to-day records and hand a clean summary to an accountant for tax, advice and filing. Good records usually make that work quicker for them.

To get the structure set up in one go, see the Small Business Bookkeeping Spreadsheet.