Access Accounting Details

If you need to see accounting details for your account, click the dropdown with your Store name at the top, right corner of the page and select Account Summary.

Alternatively, you can click the Dashboard link at the top of the menu and then click the Account Balance card at the bottom left-hand corner of the Dashboard page. If you have more than one Store on the account, can click Account Balance from any of the Storefronts. Since this is account-level information, you'll see the same information in each Store. 

On the next page, click the hyperlinked balance in the Balance field. This takes you to the Account Transactions page. Here, you can access the accounting details, including Orders and Returns, Payments, and Adjustments.

Payment Breakdown

Generally, there is a two-week period between Orders and Returns and the corresponding Payment to you. To understand when you will be paid, first check the Payment Frequency found on the Account page.

 

Examples

Payment Frequency Payment Date Transactions Included
Two per Month 31st of March 1st of March through the 14th
Two per Month 15th of April 15th of March through the last day (the 31st)
Monthly 15th of April 1st through the 31st of March

 

Click on each Orders and Returns and Adjustment row to access accounting details that occurred during the payment period, as described in the table above.  To see all activity included on a given transaction, you may need to look into multiple Orders and Returns or Adjustment lines. 

For Orders and Returns with a Completed status, you will see the transaction dates included in that line item, plus a daily breakdown of net revenue.

To see a detailed export of each Orders and Returns line, click on the Order or Return, then select the Options menu at the top, right corner of the page. 

 

Clicking either of the first two options generates a new data export; it may take a few moments for the export to finish. Once the data export is complete, or if you click the Data Exports option from the menu, you can access the data exports for the current Orders and Returns line.

The three buttons in the Actions column allow you to download the export file, preview it on your screen, or delete it.

Product Summary Export

The Product Summary Export includes the following columns:

Since this is account-level information related to your disbursement, the Currency is always shown as your FastSpring disbursement currency. If you have products with the same product path in multiple Stores, there will be separate line items for the product for each Store. 

Affiliate commissions and affiliate processing fees are recorded as Adjustments in the Account Transactions page, thus they are not included in the Income of Amount columns of the export. 

Line Item Detail Export

The Line Item Detail Export includes the following columns:

Since this is account-level information related to your disbursement, the Currency is always shown as your FastSpring disbursement currency. If you have an order in which a consumer purchased multiple products, the Reference will appear more than once since there will be separate line items for each product in the order. Affiliate commissions and affiliate processing fees are recorded as Adjustments in the Account Transactions page, thus they are not included in the Income of Amount columns of the export. 

If you have an order that includes a split payment, there will be two separate line items, thus the Reference will appear twice. One line will show the Income, Expense and Amount excluding the split amount with a blank Split column, and a second line will have the split amount as a negative value in the Income and Amount columns and the Split column will reflect the split pay partner / payee.

Monthly Summary

For a summary of a particular month, access the accounting details and then click Create Data Export at the top right-hand corner of the Account Transactions page. Select a month and year, then click Create.

 

Your data export will begin to process and the page will update every 20 seconds until the report is complete. Once it has completed, the buttons in the Actions column allow you to download the export file, preview it on your screen, or delete it.

Account Summary Export

The Account Summary Export includes the following columns:

Since this is account-level information regarding your disbursement, the Currency is always shown as your FastSpring disbursement currency. Returns are aggregated by product as a separate line for each product. 

Income and Amount columns for product and return lines do not include split payments. Split payments are aggregated by the product as separate line items. The Income and Amount columns reflect the aggregate amount split out during the month for the specified product.

 Note About Exchange Rates

FastSpring converts amounts for subscription transactions processed in non-USD currencies to USD values at the time you run the reports, using current exchange/conversion rates. Because of variations in currency exchange rates, the amounts reported for a given period may vary somewhat from day to day.

For example, suppose you had non-USD subscription transactions during August. If you run one of the following reports for August on the 7th of September and then again on the 8th of September, you might see different values for the month of August each day:

Monthly Recurring Revenue (MRR): Expected monthly recurring gross volume based on currently active subscriptions.

"Monthly recurring revenue" is revenue that a company can reliably predict, is stable, and is expected to occur regularly.

Average MRR Per Subscription: Monthly recurring revenue divided by Active subscriptions

Lifetime Value: Average Monthly recurring revenue per subscription divided by customer churn

Annual Run Rate: Monthly recurring revenue multiplied by 12

"Annual run rate" is an estimate of future income if the current revenue trend continues.

Active Subscriptions: Currently active subscriptions

Customer Churn: For each date in the selected date range: (deactivated subscriptions in the past 30 days) / (active customers from the prior month), multiplied by 100.

For example, suppose you run the report for the 1st of March through the 2nd of March. The churn report would not only include deactivations that occurred on the 1st of March or the 2nd of March. Instead, the churn calculation would as follows:

On the 1st of March On the 2nd of March
(Deactivations during (March 1 minus 30 days) through March 1)
divided by
(Active subscriptions during (March 1 minus 60 days) through (March 1 minus 30 days))
times 100
(Deactivations during (March 2 minus 30 days) through March 2)
divided by
(Active subscriptions during (March 2 minus 60 days) through (March 2 minus 30 days))
times 100

New Subscriptions: Number of newly-created subscriptions (not including rebills) for the selected time frame.

Cancellations: Number of subscriptions that have been canceled during the selected time frame.

Upgrades: Number of subscription upgrades that have occurred during the selected time frame.

"Subscription upgrade" means a change to an existing subscription that results in a higher price. An upgrade can be a change to the subscribed product or a change to the quantity.

Downgrades: Number of subscription downgrades that have occurred during the selected time frame.

"Subscription downgrade" means a change to an existing subscription that results in a lower price. A downgrade can be a change to the subscribed product or a change to the quantity.

Net Revenue:  The Net Revenue is calculated by taking the gross sales and subtracting the refunds for the selected time frame.

Average Order Value: The Average Order Value is calculated by taking the gross sales and dividing it by the number of orders for the selected time frame.

Units: The Units report is calculated by looking at the number of units sold for the selected time frame. This report does not consider refunds. Additionally, selecting "relationship" in the breakdown menu allows you to view products sold via cross-sell, direct sale, or upsell.

Refunds: The Refunds report reflects orders that have been returned by or refunded to customers.

The Reports menu in the FastSpring App gives you access to Orders ReportsSubscription Reports, and Data Exports. When you select Reports from the menu on the left-hand side of the FastSpring App, the Orders tab is selected by default. You can select the Subscriptions tab to view subscription reports, select the Events tab to see recent events of all types, or select Data Exports to create data exports or access legacy/original reporting.

From the Reporting dashboard view, you can select which products you would like to see and specify the desired time frame.

After selecting a product or specifying a time frame, each type of report is updated. To see a more detailed view of each of the unique reports, click a report tile. For example, clicking the Net Revenue tile takes you to a more detailed view of the Net Revenue report.

In the detailed view of a report, you can select the desired products and time frame to report on, just as you did on the initial dashboard view. Additionally, the report can display multiple reporting periods (e.g., “same period last month”) for comparison. You can also break down the data further in the bottom sections of the report.

The Break Down options include product, product variation, relationship, coupon/product discount, coupon code, and country. Selecting “relationship” allows you to see a product breakdown, and for each product, an indicator as to whether it was sold directly or via a product offer.

You can also download the reports into a .CSV file format by selecting the download symbol in the upper right-hand corner.

Placing your mouse cursor over any point on the graph reveals the data associated with that point in time.

Clicking the information symbol at the top of a report displays a definition of each of the selected metrics. You can also click the drop-down next to the selected metric and choose additional metrics to appear on the same graph.

To exit a report or to go back to the reporting dashboard, click the “back” arrow at the top left-hand corner or select the Reports menu on the left-hand side of the page.

If you need to run a data export, click the Data Exports tab of the main Reports menu.

Additional reports are available based on the legacy reporting system from Classic Commerce. To access these legacy reports for your Contextual Store, click the Data Exports tab and then click Options -> Original Reporting.

Use Data Exports for information that is not available in Orders, Subscriptions, or Events reports.

Export Data

  1. In the FastSpring App, navigate to Reports > Data Exports.
  2. Click Create Data Export to open the Create Data Export page.
  3. In the Name field, enter a name to distinguish the export in the list of historical exports.
  4. In the Date and Number Formatting drop-down, select a country for your preferred formatting of dates and numbers.
  5. In the Site field, select the Store whose data you want to export.
  6. In the Date Range From and To drop-downs, select the time frame of activity to include. All dates in the FastSpring App are based on UTC/GMT – 0.
  7. In the Report Type drop-down, select the type of data that you want to export.

  8. Click Create.
  9. The page will refresh to the list of Available Data Exports with a message that your new export is processing. The page will automatically refresh every 20 seconds until your export is ready.

After your new export is ready, use the buttons in the Actions column to download, preview on your screen, or permanently delete any export in the list. You can also mouse over the i icon to the right of each export Description to see which user created the export and when the user created it.

Chargeback Ratio Report

Follow instructions to export data and select Order Item Export (CSV) in the Report Type drop-down.

The report includes granular details about Purchase events, Return events, and Return-Dispute events.
Chargebacks that have been completed in our system are listed as Return-Dispute events.

Custom Data Export

For advanced users, use New CSV Template or New Text Template to create a custom data export with more control over exactly which fields or columns appear in your export.

The following example applies to the New CSV Template option but the process is similar for both CSV and Text Templates.

  1. Follow instructions to export data and select New CSV Template in the Report Type drop-down.
  2. In the Custom Report CSV Columns field, enter a column heading for each data point you want to include in the export, separated by commas.
  3. In the text area labeled Custom Report Template, specify the object name of each data point to include in the export, separated by commas.
  4. To continue the example above, you would enter the following:
    Custom Report Template example
    	#{order.id},#{order.created},#{order.subTotal},#{order.subTotalUSD} 

    Remember to press ENTER at the end of your line of column variables to move your cursor down to the next line so the system knows the last column in the row has been reached.
  5. Click Create.

Exposed Parameters:

Below are lists of all parameters exposed to you for Order Items, Subscriptions, and Variables.

Order Items

Subscription Variables

Return Variables