Data Onboarding - Trial Balance Requirements for Disclosure Studio Implementation

For your Trial Balances, we ask that you export a few reports. 

Export your Trial Balance directly from your ERP system for the following years:

• Current Year (CY) Trial Balance
  • Your preliminary trial balance
• Prior Year (PY) Trial Balance
  • The year that was used for ACFR preparation 

A report that lists all accounts and their balances at a specific point in time, including: 

• Assets and Deferred Outflows (DOR)
• Liabilities and Deferred Inflows (DIR) 
• Fund Balances / Net Position 
• Revenues 
• Expenses 

Required Columns in your Trial Balance should include:

• Period
  • For example, fiscal year or date
• Chart of Accounts
  • This can be either:
    • Full account string in one column
    • Separate columns for each segment (Fund, Department, Object, etc.) 
• Ending Balance 
• Segment descriptions/names
  • For example, Fund Name or Department Name
  • This is optional but recommended

For any questions regarding exporting your Trial Balance, please reach out to your Implementation Manager.

Need additional information on the General Data Requirements for implementing Disclosure Studio? See this Resource.