Separate Personal and Business Expenses on a Statement

TL;DR If personal and business transactions share one bank account or card, convert the statements to a spreadsheet and tag every row as Business, Personal, Transfer or Mixed. Total the business rows for your books, and treat personal spending paid from a business account as owner draws (or the equivalent for your business structure), and business costs paid personally as owner contributions or reimbursable expenses. Split mixed-use items with a documented, reasonable method, keep receipts for business items, and prove each statement balances so nothing is lost. Then open a dedicated business account so next year is easier. This is general information; your accountant can tell you how to record things for your business type and country.

Plenty of small businesses start with one bank account for everything. A freelancer gets paid into their personal checking account. A side business buys supplies on the family credit card. A new limited company director pays a software subscription personally because the company card hasn't arrived. It works fine until it's time to do the books or a tax return, and then someone has to go through every line and decide what was what.

This guide explains how to do that systematically: getting the statements into a spreadsheet, a tagging system that holds up, how to handle the accounting side of personal spending from business money and the reverse, mixed-use expenses, a worked example, and how to set things up so you don't have to do it again.

Disclaimer: This article is general bookkeeping information, not tax, legal or accounting advice. How mixed transactions should be recorded, and what's deductible, depends on your business structure and your country's rules. Check with a qualified accountant or tax adviser.

Why separation matters

Accurate books. Your business income and expenses should reflect business activity only. Personal groceries in the expense column overstate costs; client payments sitting unrecorded in a personal account understate income.

Tax. Business expenses may be deductible; personal ones generally aren't. Tax authorities may ask you to support your figures, and a mixed account makes that harder. Clear records of which items were business, with receipts, are much easier to defend.

Liability protection. For companies and LLCs, keeping business and personal finances separate is often cited as important for maintaining the legal separation between owner and business. Ask a lawyer how this applies to you.

Lending and selling. Lenders reviewing business bank statements, or buyers reviewing a business, want to see business activity clearly. Personal spending mixed in raises questions. See our guide to bank statements for a business loan.

Your own clarity. It's hard to know whether the business is profitable when its money and yours are tangled together.

Step 1: get every statement into a spreadsheet

Gather statements for every account and card that has any business activity, whether it's a business account or a personal one. Convert them so every transaction is one row with date, description and a signed amount.

You can copy and paste short statements, use Excel's Power Query, or use SheetStatement, which extracts the rows and checks each statement's opening balance plus activity against the closing balance before export. The free plan includes 3 pages a month; Starter ($9), Pro ($19) and Business ($39) monthly plans cover more.

Combine everything into one table with an Account column so you can see which account each row came from. Our guide to combining multiple bank statements in Excel shows how, including the per-statement balance checks that prove nothing is missing.

Step 2: add tagging columns

Add these columns to the table:

Formulas for Business amount:

=IF([@Use]="Business", [@Amount], IF([@Use]="Mixed", ROUND([@Amount]*[@[Business %]], 2), 0))

Use a data validation dropdown for the Use column so tags stay consistent.

Step 3: tag in passes, not row by row

Going through a year of transactions one row at a time is slow and tiring, and mistakes creep in. Instead, tag in passes:

Pass 1: obvious recurring items. Sort by description. Rent, mortgage, groceries, streaming services and personal phone plans are usually personal. Business software, client payments, business insurance and payment processor payouts are usually business. Tag them in bulk using filters. Our guide to finding recurring payments in a bank statement helps identify them.

Pass 2: transfers. Transfers between your own accounts, credit card payments and savings transfers aren't income or expenses. Tag them as Transfer. Match each one with its other side where both accounts are in the table.

Pass 3: income. Filter deposits. Client payments and sales are business income. Salary from an employer, gifts and refunds of personal purchases are personal. Tax refunds and loans need care; note what they are.

Pass 4: the remainder. What's left is usually a mix of one-off purchases. Check receipts and calendars where needed. A merchant name alone isn't always enough: a hardware store visit could be home repairs or business supplies.

Speed up passes with a keyword lookup table that suggests a Use and Category. See Excel formulas to categorize bank transactions, and if descriptions are messy, our guide to splitting bank transaction descriptions helps produce clean payee names to match on.

Step 4: record the crossover correctly

Once tagged, the crossover transactions need to be reflected in your books. How depends on the account and your business structure.

Personal spending from a business account

When the business account pays for something personal, it isn't a business expense. For sole proprietors and single-owner businesses that keep books, this is commonly recorded as an owner's draw or drawings: money taken out of the business by the owner. For corporations and companies, the treatment can be different, for example as a director's loan, salary or dividend, and the choice can have tax consequences. Ask your accountant how they want these recorded.

Business spending from a personal account

When you pay a business cost personally, the business still incurred the expense. Common approaches:

• Owner contribution: record the expense in the business books, with the other side as money the owner put into the business.
• Reimbursement: the business pays you back. Record the expense, then the reimbursement from the business account to you. Keep the receipts and a simple expense claim.

For companies, reimbursing a director for business expenses paid personally is common and keeps the records clean, but again, follow your accountant's preferred method.

Business income received personally

If a client paid into your personal account, the income still belongs in the business records. Record it as business income, with the other side reflecting that the money went to the owner (for example as a draw, or a balance owed to the business). Then, ideally, move it to the business account.

Step 5: handle mixed-use expenses

Some costs are partly business and partly personal: a phone used for both, a car used for client visits and family trips, internet at a home office. Rules on how to apportion these, and what's allowed, differ by country and by expense type. Common principles:

• Use a reasonable, consistent method. For a phone, that might be the proportion of business use estimated from a typical month's call log or usage. For a vehicle, it's often based on business mileage records.
• Document it. Write down the method and the evidence in your notes, such as a mileage log or a usage sample.
• Apply it consistently. Use the same percentage across the year unless circumstances change.

In the spreadsheet, tag these rows as Mixed and enter the Business % from your documented method. The Business amount column does the rest. This is general information; check what your tax authority allows and how your accountant wants it handled.

Shared household accounts

Sometimes the mixing isn't just personal and business, but also between partners. A joint household account might pay for one partner's business costs, and the other partner's salary might fund it. Tag those rows the same way, but add an Owner column so it's clear whose business each item relates to. If both partners have businesses, keep their business rows separate from the start; mixing two businesses' expenses in one summary is far harder to untangle later.

Step 6: prove the totals

After tagging, run checks:

• Nothing untagged: =COUNTBLANK(Tx[Use]) should be 0.
• Every statement still balances: if you edited rows, re-run the opening plus amounts equals closing check for each statement.
• Tags add up: the sum of Business, Personal, Transfer and Mixed amounts (full amounts) should equal the total of all rows.

=ROUND(SUM(Tx[Amount]) - SUMIFS(Tx[Amount], Tx[Use], "Business") - SUMIFS(Tx[Amount], Tx[Use], "Personal") - SUMIFS(Tx[Amount], Tx[Use], "Transfer") - SUMIFS(Tx[Amount], Tx[Use], "Mixed"), 2)

That should return 0. If not, there's a typo in a tag.

• Transfers net out: where both sides of each transfer are in the table, the sum of Transfer amounts should be close to zero. If it isn't, one side may be missing or a payment to a third party may have been tagged as a transfer by mistake.

Worked example: a freelancer's mixed checking account

A freelance photographer uses one checking account and one credit card for everything. Here's an extract (illustrative):

From this, March business activity shows income of 1,800.00 and business expenses of 649.00 + 28.00 + 22.99 = 699.99. The 40% phone percentage comes from a documented usage review. The camera receipt is saved. The card payment nets out as a transfer.

A pivot table on Business amount by Category and month turns the whole year into a summary ready for the accountant. See our bank statement pivot table guide.

Catching up more than one year

If the account has been mixed for several years and you're catching up, the same method works, with a few adjustments:

• Work one year at a time, starting with the oldest year that still needs to be filed or corrected. Each year's spreadsheet should balance on its own before you move on.
• Reuse your lookup table. The keyword table you build for the first year will tag a large share of the next year's rows automatically. Keep improving it as you go.
• Keep method notes per year. Mixed-use percentages may change if your circumstances changed, for example if you moved to a home office or started using a different car. Record the method for each year separately.
• Expect missing receipts. For older years, some receipts will be gone. Note which business items lack receipts and what other evidence you have, such as invoices in your email, order histories or calendar entries. Your accountant can advise how to handle them.

Our guide to catching up bookkeeping from bank statements covers the wider process of rebuilding records for past periods.

Handing it to your accountant

A helpful package includes:

• The original statement PDFs for every account involved.
• The tagged spreadsheet, with the Use, Business %, Category, Receipt and Note columns.
• A summary of business income and expenses by category.
• A list of crossover items: personal spending from business accounts and business spending from personal accounts, with totals.
• Your method notes for mixed-use percentages.
• Receipts for business expenses, organized by month or category.

Our guide to bank statements for tax preparation covers what preparers commonly request.

Importing only the business side

If you keep books in accounting software, you may only want business transactions there. Options:

• Import only the business account, if one exists, and record crossover items from personal accounts as separate entries.
• Filter the spreadsheet to Business and Mixed rows, using the Business amount, and import that. Be careful: importing a filtered personal account as if it were a bank account means the software's balance won't match any real bank statement, which makes reconciliation impossible. Discuss with your accountant whether to record these as expense entries instead.

For a business account, follow importing a bank statement into QuickBooks Online or the equivalent guide for your software.

Setting up for next year

The best fix is prevention:

1. Open a dedicated business account, and a business card if you use one.
2. Pay all business income into it and update your invoices with the new details.
3. Pay business costs from it, including subscriptions. Move them over one by one.
4. Pay yourself on a schedule, with a regular transfer to your personal account. That transfer is your draw or salary, depending on your structure.
5. When you slip, and you will occasionally, record it straight away as a reimbursement or contribution.
6. Review monthly. A quick month-end close catches crossovers while they're easy to remember.

Common mistakes

Recording the card payment as an expense. Paying the credit card bill isn't an expense; the purchases on the card are. Tag card payments as transfers.

Tagging by merchant alone. The same store can be business one day and personal the next. Check receipts for anything unclear.

Guessing mixed-use percentages. Use a documented, reasonable method and apply it consistently.

Forgetting income in personal accounts. Client payments into personal accounts are still business income.

Deleting personal rows. Keep every row in the spreadsheet and tag it. Deleting rows breaks the balance check and makes the file impossible to verify later.

Start sorting your statements

Upload your statement PDFs to SheetStatement, check each statement's balance, and download a spreadsheet ready for tagging. The free plan includes 3 pages a month.

FAQ

How do I separate personal and business expenses on one bank account?

Convert the statements to a spreadsheet, add a Use column, and tag each transaction as Business, Personal, Transfer or Mixed. Total the business rows and record crossover items as draws, contributions or reimbursements as your accountant advises.

What if I paid a business expense with my personal card?

The business still incurred the expense. It's commonly recorded as an owner contribution, or the business reimburses you. Keep the receipt.

What if I paid something personal from the business account?

For sole proprietors this is commonly recorded as an owner's draw. For companies, the treatment can differ, so ask your accountant.

How do I handle a phone or car used for both?

Tag it as Mixed and apply a business percentage based on a documented, reasonable method, such as a usage sample or mileage log. Rules vary by country, so check what's allowed.

Do I need receipts if I have bank statements?

Bank statements show that money moved, but not what was bought. Keep receipts for business expenses, especially on mixed accounts where the business purpose isn't obvious.

Is this tax advice?

No. It's general bookkeeping information. Speak to an accountant about your business structure and local rules.

How much does SheetStatement cost?

The free plan includes 3 pages a month. Starter is $9 a month, Pro is $19 and Business is $39.