How to Untangle Mixed Business and Personal Expenses in One Afternoon

The mess looks bigger than it is. A few hours with a highlighter and a simple rule turns months of mixed spending into records you can use.

A woman at a dining table works through a stack of printed statements with coloured highlighters on a calm afternoon

Video version: Untangling months of mixed money in one sitting

Coming soon. Everything in the video is in the written guide below.

To untangle mixed business and personal expenses, download every bank statement since you started freelancing, mark each line as business income, business expense or personal, and list anything unclear separately. Copy the business lines into a simple record. It usually takes one afternoon. Then open a separate account so the mixing stops from today.

Sound familiar?

"I've been mixing money for months and I dread untangling it all."

The dread usually sets in when you realise your tax records will have to come from your bank statements, and those statements are a jumble of clients, rent and late-night takeaways.

Your desired outcome

One methodical afternoon with marked-up statements, and a clean line from now on. You will have a list of business income and expenses, a short list of questions and no more mixing.

Why the mess feels bigger than it is

Avoidance makes this job grow. Every week you do not look, the pile feels heavier and the shame gets louder. In reality, many freelancers have only a few dozen business lines a month among the personal ones, and you can recognise most of them in a second.

You also already know most of the answers. You remember which subscription was for client work and which was for films. The job is not working things out. It is writing down what you know, in one place, once.

Before you start: draw the clean line

Fixing the past while still mixing money is like mopping with the tap running. Before the untangling afternoon, open a separate business account and route clients into it. The post on choosing a business bank account shows how. Pick a date: everything before it gets the afternoon treatment, and everything after it stays clean.

How to untangle mixed business and personal expenses

  1. Download your bank statements from the day you started freelancing to your clean-line date.
  2. Print them or open them in a spreadsheet, with three highlighter colours or three labels ready.
  3. Mark every line: one colour for business income, one for business expenses, one for personal.
  4. Put any line you are unsure about on a separate "unclear" list with a short note.
  5. Copy all business income and expense lines into a four-column record: date, who, amount, what for.
  6. Search your email and supplier accounts for receipts that match the business expenses.
  7. Total the business income and expenses, and file the marked statements in one folder.

The highlighter method

The highlighter method works because it is fast and visual. Do not stop to research each line. If you know it, mark it. If you hesitate for more than a few seconds, it goes on the unclear list. Momentum matters more than perfection here.

Personal lines need no more attention once marked. Most of your statement will be this colour, and that is fine.

Mixed purchases and the unclear list

Some lines will be mixed purchases: a phone used for both work and life, a train ticket that was half a client meeting and half a visit home. Do not try to settle these alone. Note each one with the total and your honest estimate of the business use percentage, plus how you got there. An accountant can confirm what your tax system allows.

Illustrative example

Priyanka's Saturday afternoon

Priyanka, 31, is a freelance editor who had mixed eight months of money in one account. She blocked out a Saturday from 1pm to 5pm and downloaded eight bank statements. She found 31 client payments, 64 business expenses and about 600 personal lines. Nine lines went on the unclear list, including her phone and a laptop bag. Matching receipts took another hour on Sunday. Her final summary was one page, which she took to a one-off accountant review. Priyanka is fictional; the numbers are illustrative.

The summary to take away

When you finish, write a single page like this. It is what an accountant or your own tax return will need.

Untangling summary: [start date] to [clean-line date]

Business income total: ___ (number of payments: ___)

Business expenses total: ___, by category: software ___, equipment ___, travel ___, other ___

Receipts found for: ___ of ___ expenses

Unclear or mixed items (to ask about): 1. ___ 2. ___ 3. ___

Clean line from: ___ (new business account opened)

From the clean-line date, the bookkeeping for beginners routine keeps the record current in minutes a week.

Keeping the line clean afterwards

The afternoon fixes the past. A couple of small habits protect the future. If you pay for something business related with a personal card by accident, move the same amount from the business account to your personal one that week and note it in your record. If a client pays the wrong account, move it across the same day.

Each correction takes a minute. Left alone, they become next year's untangling afternoon.

Mistakes when untangling old finances

  • Trying to do it in ten-minute bursts. You lose your place and your nerve. Block one afternoon.
  • Researching every line. Mark what you know; park the rest. Research only the unclear list.
  • Guessing big items to look tidy. For anything large or mixed, ask rather than assume.
  • Starting before you stop the mixing. Draw the clean line first, or the pile keeps growing.
  • Throwing statements away afterwards. Keep the marked statements and your summary; tax authorities usually expect records to be kept for several years.
You'll know it's working when
  • Every statement line up to your clean-line date has a mark.
  • Your business income and expenses sit in one simple record.
  • The unclear list is short and written down.
  • From your clean-line date, client money and business costs use the business account only.
  • If you stall partway through, finish the marking first and leave receipts for a second session.

This is general information, not tax advice. How mixed items are treated varies, so please confirm the unclear list with an accountant. The pillar guide on separating business and personal money shows the full setup, and keeping track of receipts stops the gap opening up again. The free Money Reset kit helps you set up the clean side in half an hour.

Key takeaways

  • Draw a clean line first, with a separate account from a set date.
  • Mark every old statement line in one afternoon, without stopping to research.
  • Park unclear and mixed items on a short list for an accountant.
  • Finish with a one-page summary and keep the marked statements.

Questions people ask

How do I separate business and personal expenses after mixing them?

Download your bank statements for the period, then go through them line by line. Mark each line as business income, business expense or personal. Put anything unclear on a separate list. Copy the business lines into a simple record sheet. Then open a separate account so the mixing stops from today, and only the past needs this treatment.

What if I can't find receipts for old business expenses?

Your bank statement shows the date, payee and amount, which is a good start. Search your email for digital receipts and invoices, and check supplier accounts where you can often download past receipts. For anything you truly cannot find, note what it was and ask an accountant how your tax authority treats expenses without full receipts.

How do I handle a purchase that was partly business and partly personal?

Note it on a separate list with the total and a sensible estimate of the business share, such as a phone used half for work. Many tax systems allow only the business portion to be claimed, and some have specific rules. Write down how you worked out the share, and ask an accountant to confirm the approach.

Do I need an accountant to fix mixed finances?

Not usually for the sorting itself. You know better than anyone which coffee was personal and which software was for a client. An accountant is most useful afterwards, for checking the unclear lines and the mixed purchases. Bring them a marked-up summary instead of a pile of statements, and the session will be shorter and cheaper.

Not financial or tax advice

FreelancerSave is educational and is not financial, tax, legal or investment advice. Tax rates and percentages are examples only; your real figures depend on your country, income and situation, so confirm them with an accountant or your tax authority. Examples are composites and results vary. Read the full disclaimer.

Cover of the free 30-Minute Freelance Money Reset

Free starter kit

Start clean from today with a simple money setup

In 30 minutes you finish with your real Minimum Month number, a tax set-aside percentage, a separate Tax Pot account and your first three-way money split.

What happens next: an email asking you to reply VERIFY (it proves the address is yours), then your kit and 6 short emails over 12 days with free lessons, one of which describes our upcoming course and its waitlist. After that, at most one email a week. Unsubscribe any time. Privacy policy

Keep reading

More free guides