Trial Balance Compare

Verify GENUS Trial Balance vs QuickBooks

Upload a QB Trial Balance for a specific date, then we diff it against the GENUS GL balance at that same as-of date (computed as SUM(gltrans.amount) WHERE trandate <= as-of). Non-zero diffs surface immediately — useful for verifying the opening-balance commit, or for reconciling AR/AP/inventory after those steps load.

Target Database

As-of date

Show only non-zero diffs

Map Columns

The tool couldn't auto-detect this trial-balance file's layout. Pick which column is Account Code, Debit, and Credit (all required). If your code column also contains the account name (like "11100 · BANK - OPERATING ACCT"), just pick that column for Account Code — the parser will split out the code automatically.

Sheet

Header row

Account Code column *

Account Name column (optional)

Debit column *

Credit column *

File preview (first 30 rows)

Comparison Result

ok match · diff balance differs · missing in GENUS on TB but no GL · missing in QB has GL but not on TB · no chartmaster account doesn't exist

Trial Balance Compare

Verify GENUS Trial Balance vs QuickBooks

Map Columns

File preview (first 30 rows)

Comparison Result ⬇ Export to Excel

Comparison Result