Help! Freelance Client Mixed Business & Personal for 2 Years—How to Forensically Separate in Beancount?

bookkeeper_bob · March 22, 2026, 10:42am

Help! Freelance Client Mixed Business & Personal for 2 Years—How to Forensically Separate in Beancount?

Hey everyone, bookkeeper Bob here with a challenge I need community wisdom on.

The Situation

I just took on a new client—freelance graphic designer who formed an LLC 2 years ago. Here’s the problem: She’s been using a single checking account for EVERYTHING. Business expenses, personal expenses, mortgage payments, client payments, groceries, software subscriptions… all flowing through one account.

The Wake-Up Call

Her lawyer just told her this co-mingling is a serious problem. If she gets sued by a client, the court could pierce her corporate veil because she’s treating the LLC like her personal piggybank. According to her lawyer, this could expose her personal assets—house, savings, everything—to business liabilities.

I’ve read that courts frequently pierce the corporate veil when owners commingle funds, treating the business as an “alter ego” rather than a separate entity (source).

What I’m Facing

24 months of mixed transactions:

Business expenses: Client lunches, Adobe Creative Cloud, office supplies, contractor payments
Personal expenses: Mortgage, groceries, vacation charges, kids’ school stuff, Target runs
Some gray-area purchases: Costco trips with mix of business supplies and personal items

The client needs:

Clean business-only financial statements for bank loan application
Audit-defensible records in case IRS comes knocking
Documentation showing business expenses are legitimate (not personal lifestyle)

My Initial Approach

I’m planning to:

Import 2 years of bank statements into Beancount
Tag each transaction to separate business from personal
Reconstruct what the books SHOULD look like if she’d had separate accounts from the start

But I have questions:

Account Structure Questions

Should I create virtual accounts like:

Assets:Checking:Actual (the real mixed account)
Assets:Checking:Business (business subset)
Assets:Checking:Personal (personal subset)

Or is there a better structure?

Metadata Tagging

Should I tag transactions with something like:

@purpose:business vs @purpose:personal?
What about gray-area purchases? @purpose:mixed?

Shareholder Flows

When the business account paid her personal mortgage, is that:

Equity:Shareholder:Distributions?
Or some other account?

When she deposited personal money to cover a business expense, is that:

Equity:Shareholder:Contributions?

The Gray Areas

What about purchases where we genuinely can’t tell 18 months later if it was business or personal?

Amazon order for “office supplies” (don’t remember what specifically)
Costco receipt for $287 (paper towels, printer paper, snacks, La Croix, gas)

Why This Matters

I’ve done bookkeeping cleanups before, but never one where there are legal liability implications. The corporate veil protection literally depends on proving the business was operated as a separate entity.

Plus, if she gets audited, the IRS could disallow ALL deductions if the records are too messy to support business purposes (source).

What I Need from Community

Account structure recommendations for forensic reconstruction
Metadata tagging strategies that will hold up to scrutiny
How to handle gray-area transactions when memory is fuzzy
Tools or scripts others have used for similar cleanups
War stories from those who’ve done this before

The client is motivated (the lawyer scared her straight), willing to invest time to help identify transactions, and committed to opening separate accounts going forward.

But first, we need to clean up this 2-year mess.

Any advice, examples, or cautionary tales appreciated! I want to get this right—both for my client’s legal protection and for my professional reputation.

— Bob

Martinez Bookkeeping Services | Austin, TX

accountant_alice · March 22, 2026, 10:43am

Bob, this is exactly why we tell clients NEVER to commingle—but you’re not alone. I see this situation at least once a quarter in my CPA practice.

The Legal Reality

Your client’s lawyer is absolutely right to be concerned. Courts look for what’s called the “alter ego” theory—essentially, if the owner treats the business as their personal piggybank, the court will treat the business liabilities as the owner’s personal liabilities. The separate legal entity status evaporates.

Recommended Beancount Structure

For your forensic reconstruction, here’s the approach I use:

; Real Account
Assets:Checking:Actual          ; The actual bank account

; Virtual Account (for business-only view)
; Don't create these—use metadata instead

; Equity accounts for capital flows
Equity:Shareholder:Contributions  ; Personal money going INTO business
Equity:Shareholder:Distributions  ; Business money going TO owner

; Business expenses
Expenses:Office:Supplies
Expenses:Marketing:Advertising
Expenses:Professional:Contractors

Key principle: Keep Assets:Checking:Actual as the single account matching the bank, then use metadata tagging to classify each transaction.

Metadata Strategy

Use these tags on EVERY transaction:

@purpose:business - Legitimate business expense
@purpose:personal - Owner’s personal expense (record as distribution)

For the mortgage payment example:

2024-08-15 * "Mortgage payment (owner personal)" @purpose:personal
  Assets:Checking:Actual          -2500.00
  Equity:Shareholder:Distributions 2500.00

For business supplies:

2024-08-15 * "Office Depot" "Printer paper and toner" @purpose:business
  Assets:Checking:Actual     -127.43
  Expenses:Office:Supplies    127.43

Mixed Transactions

For Costco-type purchases where you have some business and some personal, split the transaction:

2024-09-10 * "Costco" "Mixed purchase" 
  Assets:Checking:Actual          -287.43
  Expenses:Office:Supplies         150.00  @purpose:business @note:"Paper towels, printer paper"
  Expenses:Business:Gas             50.00  @purpose:business @note:"Fuel"
  Equity:Shareholder:Distributions  87.43  @purpose:personal @note:"Personal groceries"

Critical Documentation

For EVERY business expense, add a note explaining the business purpose:

@note:"Client meeting with ABC Corp to discuss logo redesign"
@note:"Adobe Creative Cloud subscription for client work"

This is your audit defense. If IRS questions it, you have contemporaneous documentation of business purpose.

Gray Area Transactions

When you genuinely can’t determine if something was business or personal:

Conservative approach: Classify as personal
Reasoning: Better to miss some deductions than claim inappropriate ones
Reality: A few hundred dollars of missed deductions < risk of audit penalties

For the Amazon “office supplies” from 18 months ago with no details? I’d classify as personal unless you have OTHER evidence (email, calendar, project records) showing it was business.

Warning: Get Legal Review

Since this involves corporate veil protection (not just taxes), I strongly recommend:

Complete the Beancount reconstruction using the methodology above
Have the client’s lawyer review the final classification
Document the decision-making process in writing

The lawyer needs to sign off that the reconstruction demonstrates proper separation, even if the actual accounts were co-mingled.

Going Forward

After cleanup:

Open separate business checking account IMMEDIATELY
Get separate business credit card
Never make mixed purchases again

Prevention is 1000x easier than forensic cleanup.

Feel free to DM if you want to discuss specific transaction types. This is fixable, but it takes methodical work.

— Alice

Thompson & Associates CPA | Chicago, IL

tax_tina · March 22, 2026, 10:43am

Coming at this from the IRS Enrolled Agent perspective—Bob, this co-mingling situation is an audit red flag waiting to happen.

IRS Audit Reality

When I was an IRS auditor, commingled accounts were our favorite targets. Why? Because the IRS approach during audits is straightforward:

If you can’t clearly separate business from personal, we disallow ALL the deductions.

I’ve seen cases where business owners lost $20K-30K in legitimate deductions simply because their records were too messy to defend. The burden of proof is on the taxpayer, not the IRS.

Defense Strategy

Your Beancount reconstruction IS your audit defense. Here’s what you need:

1. Contemporaneous Documentation

For each business expense, you need THREE things:

Date (transaction date)
Amount (exact dollars)
Business purpose (why this expense was necessary for the business)

Use Beancount metadata for this:

2024-07-20 * "Restaurant - Chipotle" @receipt:yes
  Assets:Checking:Actual           -45.67
  Expenses:Meals:Business           45.67
    @note:"Lunch meeting with client Sarah Johnson to review website mockups"
    @category:meals_entertainment

2. Receipt Documentation

Tag every transaction:

@receipt:yes - You have the actual receipt
@receipt:no - Receipt missing but have bank statement

For @receipt:no transactions, add extra documentation:

2024-08-03 * "Adobe" @receipt:no
  Assets:Checking:Actual           -52.99
  Expenses:Software:Subscriptions   52.99
    @note:"Adobe Creative Cloud monthly subscription for client design work"
    @supporting_doc:"Bank statement + Adobe subscription email confirmation"

Gray Area Guidance

You asked about transactions where you can’t remember the purpose:

Conservative Approach (My Recommendation)

When in doubt, classify as personal.

Why?

Claiming inappropriate deductions = penalties + interest + potential fraud investigation
Missing some deductions = you pay slightly more tax

The risk-reward math is clear.

The Costco Example

For your Costco receipt with mixed items:

Option A: Line-item review (best if receipt is detailed)

Review itemized receipt
Allocate each line: business vs personal
Document allocation method

Option B: Percentage allocation (acceptable if no detail)

Historical pattern: “Usually 70% business”
Apply ratio: $287 × 70% = $201 business, $86 personal
Tag: @allocation:70 @method:historical_pattern

Statute of Limitations

Critical point: IRS can go back 3 years (6 years if substantial understatement > 25%).

Focus your forensic effort on the most recent 3 years. Earlier years are lower audit risk.

IRS Schedule C Categories

For your metadata tags, align with IRS Schedule C line items:

@category:advertising
@category:car_truck_expenses
@category:legal_professional
@category:office_expense
@category:supplies
@category:travel
@category:meals_entertainment  ; Remember: only 50% deductible!

This makes tax prep seamless—run BQL query by category = instant Schedule C draft.

Going Forward: Written Policy

After cleanup, client needs written expense policy:

Separate accounts mandatory (business checking, business credit card)
No personal expenses from business accounts (zero tolerance)
If emergency: Record as distribution, reimburse business within 30 days
Mixed purchases: Get separate transactions at checkout
Monthly review: Catch mistakes immediately, correct same month

Audit Defense Package

When cleanup is done, create “audit defense package”:

Summary of reconstruction methodology
Documentation of allocation decisions
Client affidavit: “I reviewed these classifications and affirm business purposes”
Lawyer letter: “Reconstruction demonstrates proper separation”

Store this with tax return. If audited, you have contemporaneous proof of good faith effort.

Real Talk

Your client is lucky she’s doing this BEFORE an audit. I’ve seen cases where business owners only start cleanup AFTER the audit notice arrives—way harder to defend.

The fact you’re systematically reconstructing with documented methodology = evidence of good faith = IRS is more likely to accept your allocations.

Just be conservative on gray areas. Don’t get greedy. Defensible > optimal.

— Tina

Washington Tax Services | Phoenix, AZ | IRS Enrolled Agent

helpful_veteran · March 22, 2026, 10:44am

Oh man, Bob—I did this exact thing when I first started my side business. Learned the hard way!

My Story

Four years ago, I started doing freelance consulting while keeping my day job. Used my personal checking account for everything. Figured “I’ll sort it out later.”

Fast forward 18 months: My CPA said “You need to fix this or you’re exposed—both for IRS audit and legal liability.”

So I did exactly what you’re planning: Beancount forensic reconstruction.

My Reconstruction Process

Here’s how I tackled it (might help you):

Week 1: Data Import

Imported all bank/credit card transactions (used CSV from online banking)
Didn’t categorize yet—just got all data INTO Beancount
Created basic account structure

Week 2: Chronological Tagging

Started with oldest transactions, worked forward
Tagged each one: @purpose:business or @purpose:personal
This part was TEDIOUS but necessary
Used calendar, emails, and memory to determine purpose

Week 3: Equity Account Setup

Created Equity:Shareholder:Contributions and Equity:Shareholder:Distributions
Reclassified personal expenses as distributions
Reclassified personal deposits as contributions
This showed money flow between me and the business

Week 4: Report Generation

Generated clean business-only P&L
Showed it to CPA for review
Made adjustments based on feedback
Final result: Clean books showing business as separate entity

Decision Framework for Gray Areas

You asked about transactions where memory is fuzzy. Here’s my framework:

Question 1: Was this purchase primarily for business?

Yes → Business expense
No → Next question

Question 2: Would I have bought this without the business?

No → Business expense (you only bought it FOR the business)
Yes → Personal (you’d buy it anyway)

Question 3: Mixed benefit (like home office, phone)?

Calculate reasonable allocation percentage
Document how you calculated it
Use consistently

Examples from My Cleanup:

Amazon “Office Supplies” ($43) — No details, 14 months old

Could have been pens, could have been books for kids
Decision: Classified as personal (couldn’t prove business)
Lost deduction: $43 (acceptable trade-off for peace of mind)

Costco Trip ($215) — Mixed purchase

Found itemized receipt!
Identified: $140 paper products (business), $75 groceries (personal)
Decision: Split transaction with documentation
Tag: @note:"Itemized allocation from receipt review"

iPhone Bill ($95/month) — Mixed use

Analyzed call log: ~60% business calls
Decision: 60% business, 40% personal allocation
Tag: @allocation:60 @method:"Call log analysis"

Tools That Helped

Fava’s query interface was invaluable:

Filter by @purpose:business → See all business transactions
Filter by date range → Review specific months
Generate reports → Business-only financial statements

Google Calendar helped establish context:

Transaction on July 15? Check calendar: Was I meeting a client that day?
Restaurant charge = probably business lunch
Travel expense = match to client visit on calendar

Lesson Learned

Start with separate accounts from Day 1—way easier than cleanup!

After my reconstruction, I immediately:

Opened business checking account
Got business credit card
Set rule: NEVER mix again

Now my monthly bookkeeping takes 30 minutes instead of the 40+ hours I spent on forensic cleanup.

Encouragement

Bob, this is totally doable. It’s just time-consuming.

Tips:

Take it one month at a time (don’t try to do 24 months in one weekend)
Be conservative on gray areas (sleep better at night)
Document your reasoning (future-you will thank you)
Learn from this (client will appreciate the lesson too!)

You’ve got good guidance from Alice and Tina above. Trust the process, be methodical, and you’ll get through it.

And hey—after this cleanup, your client will NEVER commingle again. Sometimes experiencing the pain is the best teacher!

— Mike

San Francisco, CA | Using Beancount for 4+ years

finance_fred · March 22, 2026, 10:44am

Business owner perspective here—I went through this exact cleanup when applying for a business loan. Let me share what I learned.

The Bank Loan Trigger

My bank required 2 years of clean financial statements showing business performance before they’d approve a loan.

Problem: My records were co-mingled. Business income and expenses mixed with personal spending. Impossible to show the bank true business profitability.

The loan officer literally said: “I can’t tell if your business makes money or if you’re subsidizing it with personal funds.”

Beancount Saved the Day

Spent 4 weekends doing forensic reconstruction:

Tagged everything @purpose:business or @purpose:personal
Created proper expense categories
Separated shareholder contributions/distributions
Generated clean P&L showing ACTUAL business income/expenses

Bank accepted the reconstructed statements. Loan approved.

The Real Value: Business Understanding

But here’s what surprised me—the cleanup taught me about my own business.

Before Cleanup (Co-Mingled):

“Am I profitable?” → No idea
“Where does money go?” → Can’t tell
“Can I afford to hire?” → Pure guesswork

After Cleanup (Separated):

Actual profit margin: 23% (not the 40% I thought!)
Top expense: Contractor fees (38% of revenue)
Seasonal pattern: Q4 is 50% of annual revenue
Cash flow gap: Need $15K runway for slow months

This information changed how I run my business.

Key Insights from Cleanup

1. I was subsidizing my business

Shareholder contributions: $18,000 over 2 years
Shareholder distributions: $12,000 over 2 years
Net: I put $6,000 of personal money INTO business

I thought business was breaking even. Actually, I was propping it up with personal funds.

2. “Business expenses” were sometimes personal

Found several charges I’d mentally categorized as “business” but were really personal:

Netflix subscription (not business, I was kidding myself)
Gym membership (not deductible even though “staying healthy helps business”)
$80 restaurant meal with no client meeting (oops, that was date night)

Conservative reclassification = fewer audit risks.

3. True business performance

Once I removed personal expenses and shareholder flows, I could see:

Actual revenue trend (growing 15% annually)
Real expense structure (contracts > software > marketing)
Genuine profitability (positive but lower than I thought)

Going Forward

After cleanup, I immediately:

1. Opened separate business checking (local credit union, free)

2. Got business credit card (2% cash back on purchases)

3. Set up regular owner draws

Every Friday: Transfer $600 business → personal
Recorded as Equity:Shareholder:Distributions
Covers personal bills + estimated taxes

4. If business needs cash:

Transfer personal → business (rare now)
Record as Equity:Shareholder:Contributions
Document WHY (equipment purchase, cash flow gap)

The Discipline Benefit

Separate accounts created bright-line rule:

Business card = business only (no exceptions)
Personal card = personal only (no exceptions)
No more “was this business or personal?” decisions

Monthly bookkeeping now takes 1 hour instead of 6 hours.

Real Questions Answered

Your cleanup will answer questions like:

Is the business actually profitable?

Or are you subsidizing it with personal funds?
Can it survive without your cash injections?

Where does money really go?

Top 3 expense categories?
Any waste to eliminate?

Should you hire help?

Can business afford payroll?
Revenue trend support it?

What’s your cash runway?

How many months can business operate if revenue stops?

My Recommendation

Bob, this cleanup is a gift to your client (even if it doesn’t feel like it now).

She’ll learn:

True business performance
Where money goes
Whether business model is sustainable
How to properly separate going forward

Yes, it’s expensive ($3,500 for your services).
Yes, it’s time-consuming (dozens of hours).

But it’s cheaper than:

Losing business loan opportunity
Defending IRS audit with messy records
Having personal assets exposed when corporate veil is pierced

Bottom Line

Prevention > cure, but since cure is needed: Do it thoroughly, document everything, be conservative on gray areas.

After cleanup, separate accounts forever. Never go back.

Your client will look back in 5 years and say: “Best decision I made was cleaning up that co-mingling mess.”

— Fred

Small Business Owner | Using Beancount for 3 years