Yoga studio bookkeeping from a bank CSV, and a Gusto misfile we found on the way

A worked November for yoga and Pilates studios: ClassPass, Momence and Walla payouts against lease, payroll and props, plus a fix for payroll filed as software.

Tools and projects · 1 min read · Source
ai-bookkeeperyogabookkeeping

The AI Bookkeeper now has a yoga and Pilates studio page. It uses a made-up November: $5,855.00 in from ClassPass, Momence and Walla payouts and a corporate Zelle, $4,464.54 of costs, $1,390.46 before a $1,200 owner draw.

Building the fixture turned up a real fault. A "GUSTO PAYROLL" debit was filed as software, because the generic Gusto rule meant for the monthly fee matched first. For a studio that pays instructors through Gusto, that moves the biggest cost after rent into the wrong account. Payroll debits now go to wages; a "GUSTO PAYROLL FEE" line still lands in software. A test pins both.

Thirteen of 14 lines get a suggestion; the warehouse-club run stays for review. The rules come from public company names and are tuned on this one fixture, so 13 of 14 shows the fixture passing, not an accuracy. A real studio's export would tell us more.

More in Tools and projects

All writing · All in this topic · All tools and research