Reporting (Advanced): Building custom reports

Build your own reports with a powerful report designer. In this article, you will learn how to turn any data into a report, which keywords to use, and how to work with the reports you generate.

Covered here:

Report designer, explained

To create your own detailed reports, utilize the Report Designer, which incorporates data from your firm's Invoices, Time Entries, Jobs, Tasks and Pipelines.

The Report designer operates based on the keywords you input. Each keyword corresponds to a report column and filters data from the selected source. Once you've configured all the settings and entered the necessary keywords for the desired data, the report will be generated.

Generated reports are fully customizable. You can adjust the visualization type, modify the keywords used and apply filters. Once your report is ready, save it for future use and pin it to a Dashboard.

tip

Tip! For quick report generation, utilize AI search, a user-friendly tool designed to comprehend natural language.

Analyzing data

To build a report based on the data you need, follow these steps:

1. Go to Reporting > Report designer from the left menu bar. You will see the search field along with the Data menu bar on the left.

2. Click on the  wrench icon in the Data menu bar and select one or both data sources, depending on data you will need:

  • Time and Billing (your firm's Invoices, Time Entries)
  • Workflow (your firm's Jobs, Tasks and Pipelines)

By default, the source you last used is selected.

3. Enter your keywords in the search field, for example, Amount Overdue 90+ days monthly 2023, and click Go. You can go here to learn more about keywords and data sources.

You will see a generated report as a search result.

Results customization

Once you've a report is generated, you can customize it to your needs, save it for future use, pin it to a Dashboard and more:

1. Search field: Shows keywords used to generate the report. Edit them and click Go go to try again. Use the backward and forward arrows on the right to undo or redo your query.

2. Sources: Edit the data source you have used. See all available data names here.

3. Formulas: Employ logical, mathematical, and other functions for comprehensive data analysis.

4. Parameters: Use parameters, such as Integers, Booleans, Strings and so on, to filter your data.

5. Report name and description: Edit the report title or add additional info.

6. Filter: Click to edit the applied filter or hover over and click X to the right to delete it.

7. Chart/Table: Click to switch between chart and table visualization types.

8. Three dots Report menu: Opens a menu with options to Save, Show underlying data and Download the report.

9. Pin: Click to pin the report to a Dashboard.

10. Visualization: Choose a visualization type, such as Bar, Donut, Funnel and more. 

11. Chart/Table configuration: Edit chart/table settings, such as axes, lines, gridlines, labels, columns, text wrapping and other details.

12. Query details: Displays additional information on the computed data, combined attributes and filters.

13. Report: The generated report. Click on axis names for sorting, view data details by hovering over the lines and work with columns in the case of the table view. For details, go to the article on exploring reports.

Creating a formula

TaxDome Reporting offers a set of data types you can use to customize a report. However, if you are interested in more specific details – e.g., you want to use comparison in your reports or filter out irrelevant information – you can create formulas.

Formulas allow you applying various operators, such as logical (if, then, else), math, date and text string functions to your data.

While building a report, click + or Create formula to open the Formula Editor.

As you start entering the formula, our system will automatically validate it and suggest options for auto-completing. You can navigate through suggestions using the arrow keys on the keyboard and accept suggestions using Tab or Enter. The best practice is to follow suggestions carefully to ensure your formula syntax is valid.

In the formula input field, you can use either functions or data names:

  • Data names: for all available data names, please see the data reference guide. 
  • Formula functions: to the right of the formula input field, you can find the list of all formula functions. This list is there to help you understand which functions you can use, how they work and what their syntax is. Browse through categories and click function names to see their description, usage examples and syntax.

Custom formula and report ideas

Task completion efficiency:

  • Formula: (count(Task Completed Date <= Task Due Date ) / count(Task Status = "completed")) * 100
  • Description: Evaluates the efficiency of task completion by comparing the number of tasks completed on time to the total number of tasks completed.
  • Report: Task efficiency report can provide insights into the percentage of tasks completed on time each month.

Overdue invoices percentage:

  • Formula: (count(Invoice Status = 'overdue') / count(Invoice Status)) * 100
  • Description: Determines the percentage of overdue invoices out of the total number of invoices.
  • Report: Overdue invoices report shows the percentage of overdue invoices monthly and helps you track payment collection issues.

Payment reliability:

  • Formula: average ( diff_days ( Invoice Posted Date , Invoice Paid Date ) )
  • Description: Calculates the average payment duration.
  • Report: The client payment reliability report highlights clients by their average payment duration, identifying reliable and delayed payers. 

Delayed payment impact:

  • Formula: sum_if ( Invoice Status = 'overdue', Invoice Amount )
  • Description: Calculates the amount of all overdue payments
  • Report: The delayed payment impact report highlights the financial impact of overdue invoices.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.