Report problems in General Ledger are often often due to missing accounts and changes to the Visual Chart Organizer or report filters.

Try each of the following to resolve your report totaling problem.

  1. Check your Visual Chart Organizer (VCO) Template
    1. Run your saved financial statement using a new default VCO template.  
      Note: The default template includes all accounts and categories that may have been omitted from the VCO template being used.
    2. If the financial statement is correct with the new default VCO template, run a chart validation on the original VCO template to check for missing or duplicate accounts.  
    3. If the financial statement is still incorrect, change the report VCO template back to the original.  

     

  2. Verify inactive accounts with activity are not excluded
    1. Run your saved financial statement with the Include inactive accounts checkbox marked.
    2. If the financial statement totals correctly, create a query of inactive accounts to find the missing inactive accounts and reactivate the accounts.
    3. If the financial statement is still incorrect, unmark the Include inactive accounts checkbox.

     

  3. Verify your report filters are not excluding relevant activity
    1. On the General Tab, mark the Include accounts with no activity checkbox, if available.
    2. On the Filters tab, ​remove all filters and do not include any Not Yet Posted Transactions. 
    3. If the financial statement totals correctly, add each applicable filter back one at a time to verify the report continues to balance.

     

  4. Verify column dates and filters are not excluding relevant activity
    1. On the Columns tab, open each column to verify the date ranges match and the filters are correct.
    2. If any changes were needed, rerun the saved report.

     

  5. Verify a fund balance account is defined for all funds
    A mock close is performed when running financial statements. If a fund balance account is not defined, the closing balance will not be included.
    1.  Check all funds to verify a fund balance account is defined.
    2. If a fund balance account was missing, rerun the saved report. 

     

  6. Verify all account segment combinations have been created
    If you close by segment, all possible account segment combinations must be created. If a closing account is missing, the closing balance will not be included. 
    1. Verify net asset or fund balance accounts.
    2. If a closing account was missing, rerun the saved report. 

     

  7. Verify optimized fiscal years do not have unposted activity
    Unposted transactions in optimized years are not reported.
    1. Unoptimize the fiscal year by opening the soft closed periods.
    2. Post General Ledger.
    3. Re-optimize the fiscal year.

     

  8. Verify accounts are not excluded based on permissions
    When using account-level security, only the allowed accounts will be included on reports.   
    1. Run the saved report logged in as a Supervisor or user with full account access. 

     

  9. Recreate the report using the same parameters