Trial balance report for Balance sheet accounts

To effectively customize the Standard Trial Balance Report to include balance sheet accounts, users can follow these steps:

  1. Navigate to Reports > Financial Trial Balance
  2. Click Customize
  3. Click Filters
  4. Expand Trial Balance folder
  5. Click Account Type subfolder
  6. Pull out Is Balance Sheet filter
    Note: Use this instead of the filter found on the Account by Type folder
  7. Set Equal = T
  8. Click Preview/Save

Using the Is Balance Sheet filter found on the Account by Type folder would result to a discrepancy on the total Debit and Credit of the report. Suggested Account Type filter includes Net Income related accounts and the Cumulative Translation Adjustment account, hence, it brings user default Balance Sheet Account Total Amounts to match accordingly.

Leave a comment

Your email address will not be published. Required fields are marked *