Happy Business Starts Here

Highlighted
Zuora Support Moderator

What types of finance reports are available?

Question: As someone who works in finance, what kind of reports are available out of the box?



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 ACCEPTED SOLUTION

Accepted Solutions
Zuora Support Moderator

Re: What types of finance reports are available?

Zuora has reports in various place and for those working in finance, this article should highlight some of the key reports that will hopefully make your month-end process cleaner, as well as point you to some standard reports you can build on top of to get more details.


To look at the individual month's numbers, go into your desired accounting period.

 

To get the AR transactions in one consolidated report:

  • Accounting Periods > Select your accounting period
  • Change to the Balances Tab
  • In the Accounts Receivable section, download the Detail Report
  • This report will give you all transactions within the time frame.
  • You can use Column E (Transaction Type) to filter by invoices, payments, etc.
  • Knowledge Center: Accounts Receivable Balances 

For Revenue:

  • Accounting Periods > Select your accounting period
  • On the landing page for the summary view, select the Download Revenue Detail
  • This report will give you the revenue booked for the actual month.
  • Knowledge Center: Download Revenue Detail

For Invoice Aging for that month:

  • Accounting Periods > Select your accounting period
  • Change to the Balances Tab
  • In the Accounts Receivable Aging section, download the Aging Detail
  • This report will give you unpaid invoices.
  • Knowledge Center: Accounts Receivable Aging

 

To look at overall numbers, we have some standard reports available in the Reporting area as well. Take a look at the following standard reports. The great part about these is that you can save a copy and customize it by adding in additional fields and details that are relevant to your business. The standard report acts as a foundation to build and below we cover several relevant ones.

 

Reporting > Cash folder > Drivers Folder > Invoice aging
Running this as a summary report will give you the total for all current invoices grouped in a specific interval for aging: 1-30, 31-60, 61-90, or more than 90 days.

 

Reporting > Revenue Folder > Outcomes Folder > Deferred Revenue Report
This will give the total deferred revenue as of today (time you run it).

 

Reporting > Revenue Folder > Outcomes Folder > Recognized Revenue
This will provide the recognized revenue during the current and last 3 accounting periods. You can change the default filter to any period you wish.

 

Under the Drivers Folder, there are variations of the deferred revenue and recognized revenue reports sliced in different ways for a particular view. Since there so many, I'll list them out below:

 

Reporting > Revenue Folder > Drivers Folder >

  • Deferred revenue by accounting code - The total billed deferred revenue by deferred revenue accounting code as of today.
  • Deferred revenue by charge type - The total billed deferred revenue by type of charge (one-time, recurring, or usage) as of today.
  • Deferred revenue by customer account - The total billed deferred revenue by customer billing account as of today.
  • Deferred revenue by product - The total billed deferred revenue by product as of today.
  • Recognized revenue by accounting code over time - The total revenue recognized for each recognized revenue accounting code.
  • Recognized revenue by charge type over time - The total revenue recognized for each charge type (one-time, recurring, or usage) over time.
  • Recognized revenue by customer account over time - The total revenue recognized by customer billing account name over time.
  • Recognized revenue by product over time (Summary Report) - The total revenue recognized for each product in each accounting period.

Reporting > Revenue Folder > Actions Folder > Current Accounting Period Revenue Detail
This is based on the Revenue Schedule Item and provides the details of the revenue being recognized in the current accounting period

 

Reporting > Revenue Folder > Actions Folder > Undistributed unrecognized revenue
This will be a report is based on the Revenue Schedule Item and will provide information on the schedules that have undistributed, unrecognized revenue.

 

Other useful articles/links:



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post

1 REPLY 1
Zuora Support Moderator

Re: What types of finance reports are available?

Zuora has reports in various place and for those working in finance, this article should highlight some of the key reports that will hopefully make your month-end process cleaner, as well as point you to some standard reports you can build on top of to get more details.


To look at the individual month's numbers, go into your desired accounting period.

 

To get the AR transactions in one consolidated report:

  • Accounting Periods > Select your accounting period
  • Change to the Balances Tab
  • In the Accounts Receivable section, download the Detail Report
  • This report will give you all transactions within the time frame.
  • You can use Column E (Transaction Type) to filter by invoices, payments, etc.
  • Knowledge Center: Accounts Receivable Balances 

For Revenue:

  • Accounting Periods > Select your accounting period
  • On the landing page for the summary view, select the Download Revenue Detail
  • This report will give you the revenue booked for the actual month.
  • Knowledge Center: Download Revenue Detail

For Invoice Aging for that month:

  • Accounting Periods > Select your accounting period
  • Change to the Balances Tab
  • In the Accounts Receivable Aging section, download the Aging Detail
  • This report will give you unpaid invoices.
  • Knowledge Center: Accounts Receivable Aging

 

To look at overall numbers, we have some standard reports available in the Reporting area as well. Take a look at the following standard reports. The great part about these is that you can save a copy and customize it by adding in additional fields and details that are relevant to your business. The standard report acts as a foundation to build and below we cover several relevant ones.

 

Reporting > Cash folder > Drivers Folder > Invoice aging
Running this as a summary report will give you the total for all current invoices grouped in a specific interval for aging: 1-30, 31-60, 61-90, or more than 90 days.

 

Reporting > Revenue Folder > Outcomes Folder > Deferred Revenue Report
This will give the total deferred revenue as of today (time you run it).

 

Reporting > Revenue Folder > Outcomes Folder > Recognized Revenue
This will provide the recognized revenue during the current and last 3 accounting periods. You can change the default filter to any period you wish.

 

Under the Drivers Folder, there are variations of the deferred revenue and recognized revenue reports sliced in different ways for a particular view. Since there so many, I'll list them out below:

 

Reporting > Revenue Folder > Drivers Folder >

  • Deferred revenue by accounting code - The total billed deferred revenue by deferred revenue accounting code as of today.
  • Deferred revenue by charge type - The total billed deferred revenue by type of charge (one-time, recurring, or usage) as of today.
  • Deferred revenue by customer account - The total billed deferred revenue by customer billing account as of today.
  • Deferred revenue by product - The total billed deferred revenue by product as of today.
  • Recognized revenue by accounting code over time - The total revenue recognized for each recognized revenue accounting code.
  • Recognized revenue by charge type over time - The total revenue recognized for each charge type (one-time, recurring, or usage) over time.
  • Recognized revenue by customer account over time - The total revenue recognized by customer billing account name over time.
  • Recognized revenue by product over time (Summary Report) - The total revenue recognized for each product in each accounting period.

Reporting > Revenue Folder > Actions Folder > Current Accounting Period Revenue Detail
This is based on the Revenue Schedule Item and provides the details of the revenue being recognized in the current accounting period

 

Reporting > Revenue Folder > Actions Folder > Undistributed unrecognized revenue
This will be a report is based on the Revenue Schedule Item and will provide information on the schedules that have undistributed, unrecognized revenue.

 

Other useful articles/links:



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

View solution in original post