Build and edit a Balance history report

Run a balance history report to get an overview of your finances and what your balance is. Keep track of your spending and where you allocate that spending.

Note: Reports are only stored for 90 days. Download the report locally to keep it.

Building your report can take more than an hour depending on its size. The report continues to build if you leave the page or log out of CertCentral. You receive an email notification once it’s available.

Build a Balance history report

  1. In your CertCentral account’s sidebar menu, click Reports > Build a report.
  2. Select Balance history from the reports category list and click Next.
  3. From the Specify date range dropdown, select the time frame you want your report to cover.
    Note: When choosing the Custom date option, use the arrows to navigate the months and years you want to include. Then select the days you want included.
  4. In the Choose sources section, you can also choose what subaccounts to include or exclude. Click Next.
  5. Choose the columns to include in your report. For a Balance history report, there are three categories of information: Order and account information, Transaction information, and Subaccount information.
    1. Order and account information includes details such as the division or container name, account ID, order ID, and others.
    2. Transaction information includes details such as the transaction type, account currency, balance expiration date, and others.
    3. Subaccount information includes subaccounts’ account ID, division or container ID, and others.
  6. To add or remove columns from your report, toggle each check box for the information you want to include. Otherwise, click Select all to include all categories.
  7. Set column order shows the order that the columns will be listed in your report. If you want to reorder your columns, drag and drop them to your preferred placement. You can also click Order alphabetically to alphabetize them.
  8. Once you have selected your report criteria, click Next.
  9. Now schedule how you want to run your report:
    1. By default, Once is selected. This does not set a schedule, but you can manually run it again when you need to do so, from the main Report library page.
    2. To set a schedule, choose a Weekly or Monthly schedule. Set the day of the week and when you want the last report to run. With this setting, your report does not run immediately, only on the day selected.
  10. In Notify additional users, add other administrators you want to notify when the report is ready for download.
  11. Choose your report's file format, then enter a Report name.
  12. When you are finished, click Build report.
  13. Once your report is available, its status changes from Generating to Ready.
  14. Click Download on any ready report to download it.

Edit a Balance history report

  1. Click the report name. In the Report details window, click Edit report.
  2. Click Next.
    Note: You cannot deselect the category of your report.
  3. From the Specify date range dropdown, select the time frame you want your report to cover.
    Note: When choosing the Custom date option, use the arrows to navigate the months and years you want to include. Then select the days you want included.
  4. In the Choose sources section, you can also choose the subaccounts to include or exclude. Click Next.
  5. Add or remove any categories from your report. You can also drag and drop the columns you want to reorder. Click Next.
  6. On the Schedule Report page, you can change your report’s schedule and format.
  7. You can select Save as new report (optional) with a new report name. This creates a duplicate with your changes.
  8. Once you are finished, click Build report.
  9. Once the report-building is complete, its status changes from Generating to Ready.
  10. Click Download.

Another way you can edit or build off from a pre-existing report is to click the arrow on the blue Download > Build a new report from this template before you follow the steps above.