How Do I Run Reports in Balance?

Balance users get automatic access to a suite of standard reports they can use to estimate distributions, monitor fund performance, reconcile investments, and for many other purposes.  Many reports are based on parameters that a user is prompted to enter before the report is generated. The most common parameter found is post date, but some reports can be run by fund name/GLID as well.

Accessing Reports in Balance

To view what standard reports are available in each Reports subfolder, please review this list with descriptions of each standard report: Standard Report Definitions

  1. Navigate to Reports on the left panel in your database. Reports are categorized by purpose and organized in folders. Clicking on each folder will allow you to view and access the reports in that folder.

     
  2. Click on the report you would like to run and enter parameters, if prompted to do so.
  3. If you want to bookmark this report as a Frequently Used Report, checking the box highlighted in the screenshot below will put the report in a separate folder for easy access. A Frequently Used folder will be automatically created to house the reports you select.

     
  4. Click on 'Run Report'. The report will open in a new browser tab.
  5. Once the report is open, use the top navigational bar to scroll through pages, refresh the report, change zoom, etc. Click the disk icon to export the report to Word, Excel, or PDF.

 

Drill Down

Reports with drill down capabilities will have blue hyperlinks to click on. Below is an example of our standard Estimated Spending Report (with Column Grouping and Drill Down).

 Once you click on a blue drill down hyperlink, this is an example of what data you'll see:

 

For information on how to set up a User-Defined Report, please see this article: User Defined Reporting Tool

Was this article helpful?

Reply

null

Content aside

  • 6 mths agoLast active
  • 78Views
  • 1 Following