u/Unhappy-Resolution71

My client's bookkeeper had been categorizing owner draws as business expenses for 3 years. Their CPA signed off on it every year. I caught it in the first 30 minutes.

Picked up a new QuickBooks cleanup client last month. Small business — around $800K annual revenue. They'd had the same bookkeeper for 3 years and the same CPA reviewing and filing taxes for all 3 of those years.

First thing I do is run a P&L and something jumps out immediately — there's a "miscellaneous expenses" line that's unusually large. I drill down into it and find hundreds of transactions categorized as business expenses that are clearly owner personal draws. Things like grocery runs, a Disney trip, spa appointments, kids' school fees. All neatly buried in "misc expenses."

I flag it immediately and tell the owner. He goes quiet. Then he says, "My CPA reviewed the books every year and never said anything."

I do a rough recalculation. If those draws had been properly categorized, their reported profit would have been significantly higher — meaning their tax filings for 3 years were potentially understating taxable income. We're talking a material discrepancy.

The owner is now in a tough spot. He genuinely didn't know — he trusted his bookkeeper and CPA completely. His CPA is now saying it's the bookkeeper's fault. The bookkeeper is saying no one told her the difference.

I've now been asked to clean everything up and prepare corrected financials. I also quietly suggested they speak to a tax attorney before amending anything.

Here's what I don't understand — how does a CPA sign off on 3 years of financials and not notice that a business owner with a family has zero personal draws recorded anywhere in the books? Isn't that a basic sanity check?

Has anyone else walked into a client's books and found something like this? What did you do?

reddit.com
u/Unhappy-Resolution71 — 7 days ago

my shopify to quickbooks sync is a complete mess and i don't know where to start fixing it

okay so i have been running my shopify store for about 14 months now and my books are honestly embarrassing at this point. i need some real advice from people who have actually figured this out.

here is what is happening:

every time shopify sends a payout to my bank it is always a different number than what my quickbooks shows as revenue for that period. i know shopify batches orders and deducts fees before depositing but i have no idea how to map that correctly in qbo. right now i have a mix of some transactions recorded as sales receipts and some as deposits and nothing matches anything.

the second problem is my products. i have about 200 skus and when i look at quickbooks the product names are either wrong or completely missing. so my cogs is basically useless. i cannot tell which products are actually profitable.

third thing. shopify payments fees, refunds, chargebacks. i have no idea where these are going in my chart of accounts. my accountant asked me about it last month and i just sent her a blank stare.

i tried using the native qbo shopify connector and it made things worse. it started creating duplicate entries and my bank reconciliation is now off by thousands of dollars.

i am not against paying for a proper integration tool. i just need to know what actually works for someone in my situation. does anyone have a workflow they use that actually keeps qbo clean and reconciles properly every month?

small store, around 400 orders a month, shopify payments, no amazon or other channels. just shopify to qbo.

reddit.com
u/Unhappy-Resolution71 — 8 days ago