Automated categorization across 22 accounts, broke my flip cost tracking for nine months
Setup: I do 6 to 9 flips a year, thin margins, and I was drowning in bookkeeping labor. Last January I built out rules in my accounting software plus an AI categorization tool sitting on top of the bank feeds. 22 accounts across four entities, counting cards and a couple of hard money draw accounts.
It worked beautifully on the metric I was watching. Uncategorized transactions went from about 400 a month to under 30. My bookkeeper's hours dropped from 14 to 5 a month, saved me roughly $700 monthly. I told people about it.
What I didn't notice until September: every rehab cost was landing in an expense account instead of the work-in-progress asset account for the specific property. The rules matched on vendor. Lumber vendor, materials expense. Same vendor supplying three houses at once, all three houses' materials in one pot, none of it tied to a project.
So for nine months I had no per-deal cost. I was pricing exits off memory and a running note on my phone. On one house, a 1950s ranch I bought at $141k, I thought I was $58k into rehab. Actual, once we rebuilt it from invoices, was $71,300. I sold at a number that assumed the lower figure. Cleared about $6,800 on a deal I'd modeled at $19k.
Rebuilding nine months of project costs across 11 properties took my bookkeeper 38 hours at $65, so $2,470. Against $6,300 of savings. And my preparer had questions about how costs had been recorded for the two houses that hadn't sold at year end, which was its own conversation.
The mistake in one line: I automated the classification and deleted the human step that assigned things to a project, which was the only step that mattered for my business.
What I'd do differently: no rule that matches on vendor alone. Every construction invoice gets a project code entered by a person at the point of approval, before it ever hits the bank feed.