Skip to main content

Building Reports

Overview

ChargeOver offers many built-in standard reports, but you can also build and save your own reports too.

Building your own reports can be helpful for things like:

  • Reporting on revenue per sales rep, product, or any other custom field in ChargeOver
  • Finding subscriptions which match some custom criteria
  • Monitoring for problems (schedule a custom report to alert you when an undesirable situations arrives)

Building Custom Reports

To build a custom report, you can start with an existing report. Then, filter the columns you want to show the records you're looking for.

Click the Save... button.

Enter a name and description for your new report, review the main filters and any subtotal filters you have chosen, and then click the Save button.

tip

Other people on your team may view this report, so make sure the name and description are something that will be helpful to them.

Your report will be saved, and anyone with access to the Report Center in ChargeOver can use the report.

Another way you can build a report is by going to your Report Center and clicking the Build report button. If you build a report this way, it gives you pre-determined report base that you can use to your advantage.

The available report bases are as follows:

  • Customers
  • Contacts
  • Invoices
  • Subscriptions
  • Invoice line items
  • Subscription line items
  • Payments
  • Refunds
  • Credits
  • Write-offs
  • All transactions (payments, refunds, credits)
  • All transactions applied to invoices
  • Quotes
  • Products
  • Discounts

Once you click Continue it will create the report for you, with pre-determined filters that are meant to help lessen the work for you to create a custom report from scratch.

In the example above, I chose the base 'all transactions applied to invoices.' These are the results the report pulled for me once I created the report.

You can play around with the report bases as much as you would like and also add additional columns and filters to your reports after they are created as well.

note

If you have any feedback on our reporting and how it works, please email support@chargeover.com. We would love to hear your thoughts on how reporting for you is going. We love feedback!

Filters

Filters you saved are pre-applied to your report when you view it.

For example, if you the report you saved was filtered by a date range of Dec 1, 2023 to March 15, 2024, then the report will only show records that fall in that date range. Anyone who uses the report will be able to apply additional filters on top of that, but the report will never show anything outside of the date range you saved it with.

Subtotals

Subtotals are another way to filter your report to produce more refined results. It allows you to filter your report down or group by a certain column you have enabled.

For example, if you wanted to filter all of your customers by Brand, you could filter your All Customers report and make sure you have the Brand column enabled. Then make sure your other columns are filtered the way you want them and click Save as. You will see a subtotals dropdown that you will click. Select Brand and then save your custom report after you re-name it.

Your final result will look something like this.

Columns

You can toggle individual columns on or off on your report, just like you can on other reports in ChargeOver.

The columns available to you will be the same columns available on the report you started building from.

Group By and Subtotals

When you build the report, you can optionally group or subtotal the report by one or two columns. Grouping the report will break the report into sections by the values in the column you choose, and subtotal any numeric fields.

For example, if you report on invoices, and chose to group by the Bill State/Province field, you'll see headings for each state or province at the top of each group, and subtotals for each state or province at the bottom of each group.

Viewing Custom Reports

All saved reports can be found in the Report Center within ChargeOver.

When you view a saved report, you can use the Build tab to see how the report is structured.

Updating a Report

Once a saved report is created, it cannot be edited/changed. (We hope to improve this in the future!)

You can always delete the report and build a new one.

Delete a Report

Use the Delete button to delete a custom report you have previously created.

Can You Build Me a Custom Report?

We'd be happy to build a custom report for you!

Often, the fastest way to provide these details to us is for you to mock-up your report in Excel or a Google spreadsheet.

If that's easy for you to do, please send that to us.

Info We Need

To build you a custom report, we need to know a few different things, at a minimum.

  • What this report should be called/named
  • The specific fields/columns you want on the report
  • Any totals/averages/etc. you want included
  • If there is any filtering you need done (e.g. only show active subscriptions, or only paid invoices) please specify those
  • Please be specific as to exactly which fields you're looking for (e.g. don't just put "Date" as a column, because I won't know if you mean the invoice date, or the payment date, or the subscription create date, or etc. etc. etc.)

What You Need to Know

  • The custom report will be available to view at any time via the Report Center
  • You will be able to schedule the report to be sent to you via email like any other report, using the Schedule button
  • You will be able to export the report to CSV/Excel at any time via the Report Center
  • You will be able to ask for any adjustments or changes that need to be made to your report at anytime

Please contact us to get the custom report process started.

tip
  • Typical turn-around time for custom reports is 2 to 3 weeks. If you have a deadline, please let us know!
  • The more detail you give us, the better. The more we understand what you need, the quicker we can get the report built!