Mixing Business and Personal Expenses: How to Untangle at Tax Time

The goal

By the end of this process, you should have:

• A list of every transaction, tagged business or personal
• Total business income
• Total business expenses, broken out by Schedule C category
• A plan to not be in this situation next year

Step 1 — Download everything

CSV exports for the full tax year from every account where business activity happened:

• Bank checking accounts
• Savings accounts (in case transfers went through)
• All credit cards
• Payment platforms (Stripe, PayPal, Venmo business, Cash App business)

Step 2 — Consolidate into one spreadsheet

One workbook. Each tab = one account. One "All Transactions" tab that appends all of them with a new column showing which account it came from.

Columns needed: Date, Description, Amount, Account, Category (blank for now), Notes (blank).

Step 3 — Tag each row

Go through every transaction. Three possible tags:

• Business (then add Schedule C category)
• Personal (exclude from business totals)
• Owner movement (transfers between your accounts, or draws — neither income nor expense)

For unclear rows, check the merchant, date, and amount. Most patterns become obvious after a few dozen.

Step 4 — Resolve the ambiguous ones

Step 5 — Calculate totals

Use SUMIFS on the All Transactions tab, grouped by category.

Example: sum of all rows where Category = "Software" gives your total software spend.

These totals plug directly into tax software or Schedule C.

Step 6 — Sanity checks

1. Does business income match 1099s received? The 1099s you received from clients should be a subset of business income. If total 1099s exceed what you tagged as income, something is miscategorized or missing.
2. Are "Business" totals reasonable? Compare to last year. Massive changes need explanation.
3. Did I miss recurring items? Scan for monthly subscriptions you forgot to tag as business (Adobe, Notion, Zoom, etc.).
4. Did I accidentally tag personal items as business? Filter "Business" rows and scan quickly. Look for grocery stores, personal streaming services, personal utilities.

Step 7 — Document owner's draws retroactively

Every time money left the business (or what should have been the business) to pay for personal things, that's effectively an owner's draw. Create an "Owner Draws" total for the year.

This doesn't go on Schedule C. But it's useful for:

• Your own books (showing how much you paid yourself)
• Explaining account balance changes if audited
• Establishing a pattern of separation going forward

Step 8 — File on time

Once your totals are solid, file. The IRS doesn't care how you reconstructed the numbers, only that they're accurate and you can support them.

Step 9 — Fix next year now

Before you file, open a business checking account and a business credit card. The list of free options. Starting next month, separation is free, clean, and automatic.

How long this takes

• $20k/year in expenses: ~3 hours
• $80k/year in expenses: ~6 hours
• $200k+/year: 10+ hours; consider hiring a bookkeeper for a one-time cleanup

What if you don't have time?

File an extension (Form 4868). Gives you until October 15. Then do the cleanup properly. But note: the extension is for filing, not paying. Estimate and pay what you'll owe by the April deadline to avoid interest + penalty.