@nessmyers The Payments datasource picks up records only where a payment has been processed. In order to look for accounts that have invoices but no payments ever, you can download (excel) 2 reports: 1. Accounts with aging invoices (or all invoices posted) 2. Accounts which have had a payment at some point of time. You can then do a vlookup on account number/ID in report 1 to see which ones do not exist in report # 2.
... View more

One option could be to use the Bill To & Sold To contacts to create the report and then download the report and manipulate it if those fields are different from the account name. I have asked your Customer Account Executive to reach out to your relationship manager with Zuora so we may better understand your use case and assist you accordingly.
... View more

If you navigate to Reporting >> Create new report and select Datasource = Account, you can create a 'Detail' report and pull fields like account name, number, parent account name, number, etc - this should get you information on which accounts have a parent account tied to them and which do not.
... View more

TCV or Total Contracted Value is a projection of your booking revenue and is helpful when planning for a budget to grow your business. TCV is calculated over a certain period of time (e.g. 3 years) from the one-time (e.g. $1000) and recurring charges (e.g. $15,000 annually). TCV does not include usage charges. In this example, your TCV over three years would be $1000 + ($15,000 * 3) = $46,000. TCV may not match the total invoice amounts that are billed for charges over the subscription term.
In order to get the TCV from Zuora reporting, you can build a custom report as described on this community article. Read more on TCV.
With the launch of Zuora Order Metrics, a new metric for subscription businesses is TCB (Total Contracted Billing TCB). TCB gives you the amount that has been/will be invoiced over the subscription term of a customer. TCB is available when you enable Order Metrics in your tenant. Create a support ticket to enable Order Metrics after reviewing the known limitations this knowledge center article.
Once Order Metrics has been enabled in your tenant, you can quickly check by going to Reporting >> Data Sources and searching for Orders. You will see these additional data sources: Order, Order Action, Order MRR, Order Quantity, Order TCB, Order TCV. In order to create a TCB report, goto Reporting >> Create New Report >> Select Data Source: Order Tcb and run a detail report with the following selected fields:
... View more