Skip to main content
Business Finance

Bookkeeping for Freelancers: Simple Setup

Bookkeeping for freelancers made simple: a one-hour setup, the records you need, a sample monthly ledger, a weekly routine, tax set-asides and common mistakes.

By Invoice Creator Editorial Team 6 min readApplicable jurisdiction: General

Bookkeeping for freelancers comes down to four habits: keep business money in its own account, issue numbered invoices, save every receipt, and record each transaction in one place every week. You do not need double-entry accounting or expensive software to start. A business bank account, a simple ledger and a receipts folder can be set up in about an hour and maintained in 20 to 30 minutes a week.

This guide walks through that setup, shows a sample month of freelance books, gives a weekly and monthly routine, and lists the mistakes that cause the most pain at tax time. It is general information, not tax or accounting advice.

Why freelancers need bookkeeping

  • Tax returns. Your income and expense figures must be supported by records if your tax authority asks.
  • Getting paid. An invoice log shows who owes you what and when to chase.
  • Knowing your profit. Revenue is not income. Books show what is left after costs.
  • Setting aside tax. You cannot estimate tax without knowing your profit.
  • Proof of income. Lenders and landlords often ask self-employed people for accounts or bank statements.

The one-hour setup

1. Open a separate account for business money (15 minutes)

Mixing personal and business transactions is the single biggest cause of messy freelance books. A dedicated account, even a second personal account used only for business, makes every statement line relevant. See business bank account for freelancers for the options.

2. Choose cash or accrual basis (5 minutes)

Most freelancers use cash basis: income is recorded when paid and expenses when you pay them. Accrual basis records income when invoiced. The trade-offs are explained in cash vs accrual accounting.

3. Set up your expense categories (10 minutes)

Match categories to the lines on your tax return so year-end is a copy-and-paste job. US freelancers can mirror Schedule C; our list of business expense categories has the standard headings. A typical freelance list:

  • Software and subscriptions
  • Equipment
  • Phone and internet
  • Professional fees (accountant, legal)
  • Advertising and marketing
  • Travel
  • Training and education
  • Bank and payment fees
  • Office costs and supplies

4. Create your ledger (15 minutes)

A spreadsheet with these columns is enough to start: Date, Description, Client or supplier, Category, Money in, Money out, Reference (invoice or receipt number), Notes. Add a separate tab to log invoices with number, client, date issued, due date, amount and date paid. Our invoice tracker spreadsheet guide has ready-made columns and formulas.

5. Make a receipts system (15 minutes)

Create a folder per tax year with subfolders by month, and decide how receipts get there: photo on your phone, forwarded email, or a scanning app. Details are in how to organize receipts for taxes.

A sample month of freelance books

Here is October for a freelance video editor using cash basis.

DateDescriptionCategoryInOutRef
2 OctEditing software subscriptionSoftware$59.99R-1001
5 OctPayment, Northside Gym promo videoSales$1,200.00INV-0031
9 OctExternal SSD 2TBEquipment$149.00R-1002
14 OctStock music licenceCost of services$45.00R-1003
20 OctPayment, Clearwater Realty, 3 listing videosSales$1,650.00INV-0032
28 OctPayment processor feeBank and payment fees$48.15Statement
31 OctInternet, 50% business use of $70Phone and internet$35.00R-1004
Totals$2,850.00$337.14

Profit for October: $2,850.00 - $337.14 = $2,512.86. If the editor sets aside 25% of profit for tax, that is $628.22 to move into a tax savings account. The right percentage depends on your income and country; how much to set aside for taxes explains how to estimate it.

Your weekly and monthly routine

Every week (20 to 30 minutes)

  1. Send invoices for work completed and log them.
  2. Record payments received and mark invoices paid.
  3. Save receipts from the week and log each expense with a category.
  4. Chase any invoice that has passed its due date.

Every month (30 to 45 minutes)

  1. Reconcile. Tick every bank statement line against your ledger. Anything missing gets added; anything personal gets removed.
  2. Check unpaid invoices. Sort by due date and follow up.
  3. Move tax money. Transfer your percentage of the month's profit into a separate savings account.
  4. Review profit. Compare income and expenses with last month and the same month last year.

Every quarter or year

Pay estimated tax if your country requires it (US freelancers, see quarterly estimated taxes), back up your records, and hand clean books to your accountant.

How long to keep freelance records

Keep invoices, receipts, bank statements and your ledger for as long as your tax authority can review your return. The IRS explains its general three-year rule and the longer exceptions on its How long should I keep records? page. In the UK, GOV.UK says self-employed people must keep records for at least 5 years after the 31 January submission deadline. Digital copies are generally fine if they are complete and legible.

Spreadsheet or software?

SpreadsheetAccounting software
CostFreeMonthly subscription
Bank feedsNo, manual entry or CSV importYes, transactions import automatically
ReportsBuild your ownProfit and loss, tax summaries built in
Best forUp to a few dozen transactions a monthHigher volume, VAT or GST, digital tax filing

For a more complete grounding in the principles, read bookkeeping basics.

Common freelance bookkeeping mistakes

  • Using one account for everything. Separating later takes far longer than doing it from day one.
  • Recording payments, not invoices. Without an invoice log, unpaid work slips through.
  • Losing small receipts. Software, fees and travel add up. Capture receipts on the day.
  • Treating client reimbursements as profit. Re-billed expenses need recording as both income and cost.
  • Leaving it until tax season. Twelve months of catch-up is miserable and error-prone.
  • Spending the tax money. Move it out of your main account every month.

Handling tricky freelance transactions

Mixed-use costs

Phone, internet, a car or a home office are often used partly for business. Record only the business share and keep a note of how you worked it out, for example "50% of internet, based on working hours" or a mileage log for vehicle use. Be consistent from month to month.

Platform fees and payouts

If a marketplace or payment processor deducts fees before paying you, record the full invoice amount as income and the fee as an expense, rather than only the net payout. Otherwise your income looks lower than what clients actually paid, and your totals will not match any tax forms the platform issues.

Foreign currency payments

Record the amount received in your home currency on the day it arrives in your account, and note the original currency amount in the description. Any difference between the invoiced value and the amount received after conversion is usually treated as an exchange difference or a bank charge; ask your accountant which they prefer.

Re-billed expenses

If you buy stock music for a client video and add it to their invoice, record the purchase as an expense and the re-billed amount as income. Keep the receipt with a note of which invoice it was charged on.

Owner's drawings

Money you move from the business account to your personal account is not an expense. Record it as drawings so it does not reduce your profit figure.

What to hand your accountant at year-end

  • Your ledger or software export with income and expenses categorised.
  • A list of unpaid invoices at the year-end date.
  • Bank and card statements for every business account.
  • Receipts for large purchases and equipment.
  • Details of any loans, vehicle use and home-office costs.

Clean, reconciled records usually mean a shorter, cheaper engagement, and fewer follow-up questions.

Clean books start with clean invoices. Our free invoice generator gives every invoice a proper number, date and itemised total and downloads it as a PDF for your records, with no account to create.

Frequently asked questions

Do freelancers need to do bookkeeping?

Yes. Even if you never hire an accountant, tax authorities expect self-employed people to keep records of income and expenses that support their tax return. Bookkeeping also tells you whether you are actually profitable, which clients owe you money and how much to set aside for tax. For most freelancers it takes under an hour a week once a simple system is in place.

What is the easiest bookkeeping method for freelancers?

Cash-basis, single-entry bookkeeping is the simplest: record money when it actually comes in or goes out, in one list with columns for date, description, category, amount in and amount out. Combine it with a separate business bank account, an invoice log and a folder for receipts. Accounting software automates much of this, but a well-kept spreadsheet is enough for many freelancers.

Can I use a spreadsheet for freelance bookkeeping?

Yes, a spreadsheet works well for freelancers with a modest number of transactions. Use one tab for income, one for expenses and one for unpaid invoices, with consistent categories that match your tax return. Reconcile it to your bank statement every month. Move to software when the volume becomes hard to manage or when rules such as digital record keeping require it.

How long should freelancers keep their records?

It depends on the country. In the US, the IRS generally expects records to be kept for three years from filing, with longer periods in certain situations. In the UK, self-employed people must keep records for at least five years after the 31 January submission deadline for the tax year. Other countries set their own periods, so check local rules.

Should I hire a bookkeeper as a freelancer?

Consider it when bookkeeping regularly takes more than a couple of hours a week, when you fall months behind, when you register for VAT or GST, or when you have staff or subcontractors. Many freelancers keep their own day-to-day records and pay an accountant once a year for the tax return, which is a cost-effective middle ground.

IC

Invoice Creator Editorial Team

Guides on invoicing, cash flow and small-business finance from Invoice Creator, operated by Next Software Development Company. Content is reviewed for accuracy against the fields our own invoice generator produces.

Try the invoice generator

Related reading