Michael Cohen
← All Work

Accounting infrastructure rebuilt at a critical inflection point

Read the full case study →

Detailed write-up · Methods · Full outcome narrative

Tools & Methods

QuickBooks OnlinePower QueryExcelSharePoint

Bank reconciliations were running in external Excel files, bypassing QuickBooks entirely. Fixed assets were tracked on inconsistent schedules. Deferred revenue had no systematic recognition process. A covenant compliance issue had delayed the financial review 30 days and triggered a refinancing need.

Rebuilt the financial infrastructure alongside the incoming fractional CFO: corrected fixed asset register with proper useful lives, systematic deferred revenue schedule, balance sheet reconciliation framework for three historically unreliable accounts, and a live reporting package connected directly to QuickBooks.

$40,000 accumulated depreciation error identified and corrected · Three balance sheet accounts now have independent schedules and monthly journal entries · Bank reconciliations moved inside QuickBooks — two sets of books eliminated

Working on something similar?

Every engagement starts with a conversation about where your finance or data function is breaking down. No intake forms, no pitch.

← Back to work