Historical payroll had been processed in a thirdparty application whose exported data structure could not align directly with QBO’s payroll module, creating massive tracking gaps and unmatched ledger entries.

The employer was not issuing standard paper checks or direct deposits through a formal payroll channel. Instead, net wages were being sent via Venmo, frequently combined with informal payroll advances throughout pay periods.

Distinguishing between actual net payroll, advance repayments, personal draws, and job material reimbursements within raw Venmo transfers created severe liability categorization issues.

Audited raw third-party payroll summaries alongside Venmo transaction logs to rebuild accurate, employee-by-employee wage and tax liability histories for the target period.

Designed a custom clearing account structure in QBO to properly track advance payouts, netting them out against final gross pay without distorting Cost of Goods Sold (COGS) or payroll liabilities.

Re-mapped the payroll setup in QBO, ensuring historical wage data, tax withholdings, and net distributions matched the actual movement of cash to the penny.