The Audit Balances Report shows quarter ending balances based on bank and investment accounts for a specified time period. This report has options for balances on total fund balances, principal, and spendable balances displayed by month, quarter, or year and can use fund filters.
Run Audit Balances Report
- Navigate to the Financials page and click Audit Balances 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 Audit Balances 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, Group Funds By, or other selection. Click Save to save changes.
- 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.
- When Default is selected for Round, no rounding occurs.
- 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.
- Fund attributes are included in the spreadsheet.
- Click Show/Ex SubFund in the left-side menu to view subfunds.
- Click Rollup SubFund in the left-side menu to remove subfunds from the view.
- Click Show Account Detail in the left-side menu to show account details.
- Each column will have the corresponding account number listed in the column header.