My work speaks for itself.
Case Study 1:
Entity Consolidation & Book Merger
A client operating two separate legal entities required a consolidation of their financial records. The goal was to merge the books of the two entities into one company within QuickBooks Online.
Chart Of Accounts Mapping:
Exported the COA from both entities into Excel.
Created a mapping schema to align the subsidiary's accounts with the parent company's structure (e.g., mapping "Office Exp" in Company A to "G&A Expense" in Company B).
Data Migration:
Utilized CSV import tools to migrate vendor lists, customer lists, and transaction history into the primary QBO file.
Carefully validated the "Opening Balance Equity" to ensure the subsidiary's trial balance matched the final trial balance from the old system exactly.
Inter-Company Reconciliation:
Audited all transfers between the two entities.
Eliminated "Inter-company Income" against "Inter-company Expense" to ensure the consolidated P&L reflected true external revenue only.
Validation & Review:
Ran a "Balance Sheet by Class" report to allow the client to see the financial health of the merged division separately from the main company.
Inconsistent Data Structures:
The two companies utilized vastly different Charts of Accounts (COA), making a direct import impossible without standardization.
Inter-Company Conflicts:
There were frequent transfers of funds between the two entities that had been recorded inconsistently, risking double-counting of revenue or expenses.
Historical Preservation:
The client needed to retain full historical data for the subsidiary for the current fiscal year while ensuring the opening balances matched the previous tax returns.
The Results
Efficiency:
The client eliminated the cost of a second QBO subscription and reduced monthly bookkeeping review time by 40%.
Unified Reporting:
The business owner can now view a single "Total Profitability" report instantly, rather than manually combining reports from two different logins.
Accuracy:
The consolidated books balanced to the penny against the original separate records