TB Rollforward Check

Roll forward prior year trial balance balances using current year GL activity and compare expected balances to the client's current year trial balance to identify missing or incorrect accounts. Use the audited prior year trial balance where applicable.

Planning Phase

01 Upload Source Files

Important for accurate rollforward results:

Please include an Account Type column in BOTH:
- Prior Year Trial Balance (PY TB)
- Current Year Trial Balance (CY TB)
Account Type values:
- BS = Balance Sheet
- IS = Income Statement
Income statement accounts reset each year, so their beginning balance is treated as 0
GL file does NOT require Account Type
If Account Type is not provided, the system will attempt automatic classification based on account number, but results may require review

Prior Year TB

📋

Drop file or browse

Account # · Account Name · Ending Balance

Map Columns — Prior Year TB

GL Format Auto Detect Detected automatically after upload

Current Year GL

📒

Drop file or browse

Transaction Detail or Ledger by Account

Map Columns — Current Year GL

Movement columns

✓ GL Parsed

Client CY TB

📊

Drop file or browse

Account # · Account Name · CY Balance

Map Columns — Client CY TB

02 Settings

Difference threshold $ Flag differences > $1 Accounts with |difference| above this are flagged

Retained Earnings Treatment

Upload and confirm all three files to run