Client Scenario: "Mookie the Beagle Coach" – A startup offering professional pet training services and retail inventory sales, operating as an LLC taxed as an S-Corp.
The Objective: To design and implement a scalable accounting system in QuickBooks Online to manage hybrid revenue streams and maintain compliance.
My Role: Full-Cycle Bookkeeper responsible for initial setup, operational accounting, and month-end closing procedures.
The business model required an accounting system that could handle distinct operational flows under one file:
1. Chart of Accounts Customization: Designed a custom Chart of Accounts tailored for S-Corps. Established unique parent/sub-account structures for shareholder equity, distributions, and multiple income streams to simplify tax reporting.
2. Sales Tax Center Configuration: Configured the QuickBooks Online Automated Sales Tax center. Integrated CDTFA rules to apply the correct California sales tax (9.0%) exclusively to retail transactions while keeping training services exempt.
3. Bank Feed Integration & Audit: Simulated bank feeds via CSV uploads. Matched external bank transactions to General Ledger entries to verify accuracy, executing bank reconciliations to bring variance to zero.
Delivered a fully reconciled Trial Balance, Profit & Loss, and Balance Sheet for the initial operating period.
Implemented a perpetual inventory sub-ledger that reconciled to the General Ledger.
Established a clean audit trail matching simulated bank statements to QuickBooks transactions.