The Balance Trend Report will show assets, liabilities, and net assets for a date or a date range. It includes daily, monthly, quarterly, and yearly reporting. This report is similar to running a Balance Report for each month to see ending balances.
Run Balance Trend Report
- Navigate to the Financials page and click Balance Trend in the left-side menu.
- Click a date.
- Alternatively, select a Static Start and End Date, and then click Show Date.
- Alternatively, select a Static Start and End Date, and then click Show Date.
The Balance Trend Report is displayed. To further refine the information in the report, use the options listed below.
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, Financial View, 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 [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.
- 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.
- Show/Ex Sub Fund becomes available when using Show Fund functionality.
- Click Show SubAcct in the left-side menu to view subaccounts.
- This will display the individual account balances, and the subaccounts will be indented.