Trial Balance Report

This financial report will display the total amounts by account. Debits and credits that make up the totals are available.

Run a Trial Balance

1. Navigate to the Financials page and click Trial Balance in the left-side menu.
2. Click a date.
   • Alternatively, select a Static Date, and then click Show Date.
     
     
     

The Trial Balance Report is displayed. To further refine the information in the report, use the options listed below.

• The report will show the balance for the date chosen for all the line items in the chart of accounts. It will list the account number, the account name, the ending debits, credits, and the totals.
  
  
  
  

Additional Information

• Click Edit Date in the left-side menu to change the date. Click Save to save changes.
  
  
  
• Click Edit Options in the left-side menu to select a Column Option or other selections. Click Save to save changes.
  • If Include Closed Accounts is checked, then also check Include Zero Balances. 
  • When Default is selected for Round, no rounding occurs. 
    • Rounding follows the standard rounding rule of rounding up if five or more, and rounding down if less than five.
    • When using rounding, totals in reports may become imbalanced due to rounding differences across individual items.
      
      
      
• Click Load Saved in the left-side menu to use a saved filter.
  • Click [delete] to remove saved filters.
    
    
    
• Click Save Report in the left-side menu to name a report. Click Save to save changes.
  
  
  
• Click Print in the left-side menu to customize report columns and titles. Click Print again to display the report.
  • Click the Show checkbox to show columns or uncheck the box to hide columns.
  • The printed report will have a white background, contain text from Financials Content, and display without lines.
    
    
    
• Click Add Filter in the left-side menu to Add Financial Filter.
• Click Export in the left-side menu to download an Excel spreadsheet containing currently displayed information.
• Click Raw Export in the left-side menu to download an Excel spreadsheet containing currently displayed information that has each cell of each line of the spreadsheet filled.
  • This can be useful when using Excel functions. 
  • Fund attributes are included in the spreadsheet.
• Click Show Fund in the left-side menu to view each fund and its balance.
  • Show/Ex Sub Fund becomes available when using Show Fund functionality.
    • This option shows subfunds.
• Click Show SubAcct in the left-side menu to view subaccounts.
  • This will display the individual account balances, and the subaccounts will be indented.