Finance Report

What is the Finance Report?

The Finance Report provides monthly totals of your Total Billed, Payments, and Expected Payments. The report also breaks down Total Billed into Sales, Discounts, Taxes, and Credits.

Sales are listed in the month the invoice is issued, whether or not payment has been received. Payments are also matched up with the month the invoice is issued, not the month they are received.

This way, you can measure your monthly performance in terms of total sales and track how much you have received and how much you are still waiting to receive.

Products that have recurring intervals of more than 1 month (i.e. annual products) will display the full amount in the month the sale hits instead of being spread out over several months. Spreading out the revenue into subsequent months is usually referred to as “Revenue Recognition” - we have a separate report built for this information, our Revenue Recognition suite.

Report Layout and Definitions

Total Billed

Total Billed = Sales - Discounts + Taxes - Credits/Voids

If you do not collect Taxes, your Total Billed will be the same as your Total Billed less Taxes.

Sales

Sales are split into the below categories for better granularity:

Recurring Plans: Sales from subscriptions
One Time: Sales from one-time components
On/Off: Sales from on/off components
Quantity-Based: Sales from quantity-based components
Metered: Sales from metered usage components
Prepaid Usage: Sales from prepaid usage components
Event-Based: Sales from event-based components
Setup Fees: Sales from setup/initial fees
Trial Fees: Sales from paid trials

Discounts

These are discounts or deductions applied to sales according to Advanced Billing coupon/discount logic.

Discounts are further broken down into the following categories:

Single-Use Coupons: Discounts from coupons that are only applied once
Multi-Use Coupons: Discounts from coupons that are applied to several billings but eventually fall off automatically
Recurring Coupons: Discounts from coupons that are applied at every billing (until they are manually removed)
Other Coupons: Discounts from coupons whose lifetime/limits cannot be determined
Referrals: Discounts from refer-a-friend discounts

Credits/Voids

Credits are divided into the following categories:

Service Credits: Reductions to sales from service credits
Proration: Reductions to sales from migration credits
Refund Credits: Reductions to sales from refunds which were credited to the invoices
Voids: Reductions to sales from partial and fully voided invoices
Other: Reductions to sales from other credits (e.g. credits which were granted as a result of moving from statement to invoicing architecture)

Payments and Collections

Payments amounts are received against the Total Billed. These includes actual payments (from credit cards, checks, ACH, etc.) as well as deferred payments from Prepayments.

Automated Payments: Payments received from automatic billing by Advanced Billing, which is usually either from credit cards or ACH
Check/Invoice Payments: Payments recorded manually in Advanced Billing, such as check payments for invoices
Amortized Prepayments: The amount applied to this period’s billings from Prepayments (i.e. a large up front check payment that is amortized and split among each period’s billings)

We calculate Total Collections as your gross payments before Refunds, and we calculate Net Payments by subtracting Refunds.

The report also lists Expected Payments which accounts for payments not yet received but that are still expected to arrive. These fall into three categories:

In Dunning: The amount under active Dunning managed by Advanced Billing. Moves to Uncollected if Dunning ends without capturing payment.
Unpaid Invoices: The amount due on open invoices. (i.e. non-automated billing collection methods).
In Collection: The amount pertaining to subscriptions that have failed Dunning but have open invoices.

From your Total Billed, Payments, and Expected Payments, we derive the Uncollected amount which is calculated as your Total Billed minus your Payments and Expected Payments. In other words, this is the amount that you billed but have not received nor expect to receive via Dunning or open invoice.

Differences for Statement Architecture

The original release of the Finance Report predates Relationship Invoicing. Because of this, some elements of the report look different for merchants that have not migrated.

Sales are broken down into Recurring Plans, One Time, Add Ons, Usage, Setup Fees, Trial Fees, and Other.
Credits are broken down into Proration and Balance Adjustments.
Refunds are factored into Net Revenue
Expected Payments breaks down into In Dunning and Uncollected

Currency Format

The values displayed in this report follow a financial-style formatting:

Only the subtotal and total rows include the currency symbol:
- A regular data row displays $10.00 as 10.00
- A subtotal or total rows displays $10.00 as $10.00
Negative amounts are wrapped in parentheses: -$10.00 would be shown as (10.00) or ($10.00)

Multicurrency

The Finance Report supports multicurrency sites. You can see your Finance Report segmented by one currency at a time.

CSV Exports

You can export the data displayed in your Finance Report as a CSV by clicking on the “Summary” option in the Export menu. A complete listing of the data contained in this CSV can be found in our export documentation.

Similar to other exports, the CSV file will appear shortly in your list of Downloads.

You can also export a more detailed Finance Report CSV by month. Simply click on the Export button and then choose the month you wish to export:

This CSV follows a format that is slightly different than what is shown in the web-based Finance Report. It contains all of the data needed to recreate the web-based report, plus extra data that allows you even more insight. When imported into a spreadsheet application (such as Google Sheets), it will look like this:

The Finance Report CSV downloaded for a particular month.

For a complete listing of the data contained in this CSV, please view the Finance Report section here in our Exports documentation.

You can download exports that date back to the date your account was created within the system. However, the UI version of the report is limited to the last 12 months.

Understanding the CSV Export

The CSV contains all of the data you need to analyze your performance in a way that works best for your business. This does mean that some data is repeated from row-to-row, so you may need to use filters or sorting in some cases to avoid double-counting.

The columns that have repeated data and context-sensitive meaning are the following (note: a full list of columns and their descriptions follows in the next section):

`discount_amount`

For lines in the “Sales” category, this field gives the amount of discount that was applied to just that line.

For lines in the “Discounts” category, this field gives the total discount attributed to a particular coupon that may have been spread across multiple sales lines.

This way, you can filter out Discount lines to see just how much each of your Sales lines was discounted, or you can include Discount lines to see how much discount is attributed to each coupon.

`tax_amount`

For lines in the “Sales” category, this field gives the amount of tax that was applied to just that line.

For lines in the “Taxes” category, this field gives the total tax attributed to a particular tax configuration that may have been applied across multiple sales lines.

This way, you can filter out Tax lines to see just how much each of your Sales lines was taxed, or you can include Tax lines to see how much tax was charged by each tax “rule”.

`credit_amount`

For lines in the “Sales” category, this field gives the amount of credit (i.e. non-cash adjustment that reduced the amount billed, such as a service credit) applied to just that line.

For lines in the “Credits” category, this field gives the total credit amount from a particular Adjustment transaction that may have been spread across several Sales lines.

You may filter out Credit lines to see just how your individual sales were affected by credits, or you can include Credit lines to see why (via the memo) credits were being applied in the first place.

`payment_amount`

For lines in the “Sales” category, this field gives the amount that has been paid on that particular line. For example, an amount between 0% and 100% of billed_amount indicates a partial payment for the line.

For lines in the “Payments” category, this field gives the total payment amount from a particular Payment transaction that may have been spread across several Sales lines.

You may filter out Payment lines to see just how your individual sales have been paid, or you can include Payment lines to see which payments have been received.

An Example

The following spreadsheet shows some of these concepts in action:

In the blue box, you can see that a $29.90 discount (#1) was applied to the Pro Plan Recurring Plan line, and $3.26 discount (#2) was applied to the Widgets Add On line. In all, this amounted to a discount of $33.16 (#3) on this sale, which came from the coupon with ID 40276 and the name “10% off the lifetime of your subscription”.

In the green box, you can see that the total billed amount of $269.10 has been paid (#4) on the Pro Plan Recurring Plan line. Also, the total billed of $29.34 has been paid (#5) on the Widgets Add On. This was captured in a single payment of $298.44 (#6) with transaction ID 238742.

You can download our example CSV file to take a look!

Caveats

Sale Rows and Rounding

Values in rows with Sales category e.g. tax_amount, billed_amount, payment_amount are calculated as fractional parts of these values for the whole Invoice and then rounded. This action may lead to discrepancy when we sum all values of the sales and then compare them to the Tax, Billed or Payment amount for the whole Invoice, because the rounded sum of all elements is not always equal to the sum of rounded elements.

The following spreadsheet shows an example:

In the red box we have two sales $2.99 and $4.99 (#1). The tax for this invoice is equal to 8.5%, therefore in the green box we have approximated tax (#2) for both sale items: $4.99 * 8.5% = $0,42415 ~= $0.42 and $2.99 * 8.5% = $0,25415 ~= $0.25. But for the whole invoice the tax is calculated (#3) as follows: ($4.99 + $2.99) * 8.5% = $0,6783 ~= $0.68. As we can see: $0.42 + $0.25 != $0.68, so in order to keep the correct calculations the tax_amount from the whole invoice (#3) should be used.

Billed amount for each sales is calculated as follows billed_amount = sale_amount - discount_amount + tax_amount -credit_amount therefore the discrepancy from the (#2) tax_amount column for sales is propagated to the billed_amount column (#4). In order to calculate billed_amount for whole invoice the tax_amount from the whole invoice (#3) should be used.

Payment amount for sale item is calculated as follows: paid fraction of invoice * billed_amount. When the whole invoice is paid then the billed_amount is equal to payment_amount. As you see in the (#5) the payment amount for the sale item is approximated as well and the total amount of payment_amount for the invoice will be different by $0.01 (#6).

End of Period Balance Export

Introduction

The “End of Period” Balance Export will give you an end of period balance for your subscriptions, up to the end of the selected month, or today’s date when the current month is selected.

How to Access

You can access the export by navigating to Insights and the Finance Report and selecting “End of Period Balance Export”

What is the “End of Period” Balance Export?

The End of Period Balance Export provides you with an ending month balance. The following transactions will be taken into account to calculate the balance:

Sale Amount + Discount Amount (discounts are negative) + tax_amount - credit_amount (credits are not negative) - payment_amount + refunds

Both active and inactive Subscriptions will be included, however Subscriptions with a $0 balance will be excluded.

When to use this export

The “End of Period Balance” Export will allow your accountants to more easily close your books at the end of an accounting period. It will:

Help determine the details of an A/R balance
Help customer facing teams to know what subscriptions require payment follow-up and attention
Help support and accounting make decisions around bad debt

Export Details

For more information on the data included in this export, see: Exporting Data.