Creating and Running a Custom Report

Follow

Certify's Custom Report Builder feature enables users to personalize analytic reports with custom columns and static fields. They can also filter the displayed data and more columns to better suit their accounting needs. Users will be able to export these Custom Reports into their accounting systems and analyze the data in the exact way they need to review it.

This article shows you, a Certify Accountant, how to create and run a Custom Report within Certify. 

Please Note: Custom Reporting is not available for Certify Invoice Classic at this time.

Step 1: On your Certify homepage, click Analytics. Once the Analytics page opens, view any reports Shared With or Created By you in the Custom Reports section.

mceclip0.png

Step 2: Click New Report to start creating your Custom Report.

mceclip1.png

Step 3: Once the New Report Page opens, configure your Custom Report.

Report Details

Enter information under Report Details:

  • Report Name: Name the custom report.
  • Description: Enter a description about what this report is about.
  • Visibility: Choose a visibility level for the report.
  • Export Type: Choose if you want the report to be exported as XLSXCSV, or TXT. If you choose TXT, the Delimiter field appears that allows you to choose a comma, tab, pipe, semi-colon, or caret as your delimiter.

mceclip3.png

Report Data

First, choose between the two data types:

  • Expenses: a granular, line by line report of all expenses.
  • Expense Report: a general summary of expense reports submitted within a designated period.

mceclip4.png

Next, click Add Column.

mceclip5.png

There are two field types to choose from:

  • Certify Field: Standard fields within Certify
  • Static Field: A field that populates a constant value in each line, rather than pulling a field within Certify.

After adding a column, the Edit Column sidebar will open.

mceclip6.png

Under Column Data, search for the data field needed to complete your report.

mceclip7.png

After you select the Certify Field, specific fields asking for additional information such as the Date FormatAmount Format, or Boolean Format will appear.

mceclip8.png

Once you've selected your Column Data, Certify will populate your column name under the Column Header. Click Finish when complete.

mceclip9.png

Please Note: If you are entering a Static Field, you will only have to type in the Data Field, name the Column Header, then click Finish.

Data Filtering

Once you've entered the necessary columns, enable and configure various options for data population and filtering. 

  • Preferences are settings that control how the data populates into the report and are not configurable at runtime.

mceclip10.png

  • Runtime Filters are what the Report Runner can use to filter the report at runtime.

mceclip11.png

Step 4: Now that the report is created, run the report by clicking the Analytics tab. Then, select the report you wish to run.

mceclip12.png

Please Note: Once you've created the report, you have the actions available to Edit, Clone, or Delete the Custom Report. If you are running a Shared Report, you only have the action to clone it.

Step 5: On the Custom Reports Page, the Report Runner selects how to filter the report.

mceclip13.png

Step 6: Click Submit when complete.

mceclip14.png

Step 7: The report will run, and the Report Data will populate.

mceclip15.png

Step 8: Click the Export As button to download a copy of your Custom Report.

mceclip16.png

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request