fullmetrixDocs

Revenue

Read your revenue day by day, week by week or month by month, and see where it comes from by customer type, payment method and tax rate.

The Revenue report answers the question "how much did I sell, and how does that figure break down?". It repeats the store's four headline indicators, plots revenue day by day, then breaks it down by period, by customer type, by payment method and by tax rate.

Open it when you prepare a monthly review, when you want to understand a rise or a drop, or when your accountant asks for the tax collected per rate.

Before you start

You need a connected store whose historical import is finished. If that is not the case, read the E-commerce page to know what to do.

Open the report

Expand the E-commerce section

In the left sidebar, in the Data group, click E-commerce.

Choose Revenue

Click Revenue, the second entry in the list. The Revenue title appears at the top of the screen.

Wait for the figures

Cards, chart and tables first appear in grey while we compute them, then fill in.

Choose what the report includes

At the top right, three controls decide which figures you see. Check them before reading an amount.

The Filters button limits the report to part of your orders. For example, you can keep only orders shipped to Belgium, or orders containing a specific product. You can also load a saved segment. The whole report follows the filter, cards, chart and tables included. The full behavior is described in Filters and segments.

The All sources selector picks the stores added together when you have several. See Choosing stores.

The date picker sets the dates and the comparison. By default you see the last 30 days up to yesterday, compared with the same period last year. Choose Period in the Compare part to compare with the days just before instead. See Date range and comparison.

The four indicators

Four cards sum up the period. Each card shows the value, the percentage change against the comparison period and a small curve of the last 14 points. Hover the change to read the comparison period's value.

IndicatorDefinition
RevenueThe sum of the order totals of counted orders in the period, minus refunds granted during the period. Depending on your settings, we also remove taxes, shipping and order fees.
OrdersThe number of counted orders placed during the period.
Items soldThe sum of item quantities in those orders.
Average order valueRevenue divided by the number of Orders.

A counted order is an order placed during the period, whose status is not excluded, whose amount is greater than zero and whose customer is not ignored. The full rule is explained on the E-commerce page. You set it in Settings, Reports tab, and it applies to every report. See Report settings.

How revenue is calculated

We start from the total amount paid by the customer for each counted order, taxes and shipping included. Then we apply the deductions ticked in Settings, Reports tab, Net sales deductions section.

OptionEffect
Deduct refundsRemoves refunds granted during the period
Deduct taxesRemoves VAT and other taxes from each order
Deduct shippingRemoves the shipping charged
Deduct feesRemoves fees added to the order

The boxes ticked at the start can differ from one organization to another. Open the Reports tab to see which ones apply to your numbers. If only Deduct refunds is ticked, revenue is an amount including tax and shipping, with refunds deducted.

A refund is removed on the date it was granted, not on the order date. An order from March 28 refunded on April 3 lowers April's revenue. The number of orders and items does not change.

All amounts are in your organization's currency. If a store sells in another currency, we convert its amounts. See Currencies and time zones.

The revenue chart

Below the cards, the Revenue chart plots revenue for each day of the period. The comparison period appears as a lighter dotted line, aligned day for day. Hover a point to read the amount for that day and for the compared date.

Days are cut in your organization's time zone, set in Settings, General tab.

Two header buttons change the display. Show trends draws a straight line that sums up the overall direction of the curve, which helps when days vary a lot. Show annotations places your annotations on the chart, such as the launch of a promotion. The button only appears if you have created annotations. See Charts and TV mode and Annotations.

The revenue breakdown by period

The Revenue breakdown table repeats the figures row by row. Three buttons at the top right choose the grouping.

  • Day shows one row per day. This is the default.
  • Week shows one row per week. Weeks start on Monday and are labeled "Week" followed by the Monday's date.
  • Month shows one row per month.
ColumnContent
DateThe day, week or month of the row
OrdersThe number of counted orders placed in that interval
Items soldThe quantity of items in those orders
RevenueThe interval's revenue, minus the interval's refunds
Average order valueThe row's revenue divided by its orders

The Total row at the bottom stays visible while you scroll. It adds up every row. The table is sorted from the most recent date to the oldest. Click a column header to sort by that column, then click again to reverse the order. For example, sort by Revenue to find your best day of the month.

The first and last intervals may be incomplete. If your period starts on a Wednesday, the first week only contains five days. Keep that in mind before comparing two rows.

Revenue by customer type

The Revenue by customer type table splits revenue into three rows.

RowWho is in it
New customersOrders from customers whose first counted order falls within the chosen period
Returning customersOrders from customers who had already placed a counted order before the period started
Anonymous customerOrders without an email address, or whose address the store anonymized

We recognize a customer by their email address, across all selected stores. A customer who places a first order early in the period and comes back twice counts three orders in New customers, because their first order is in the period.

The columns are Customer type, Orders, Items sold, Revenue and Average order value, with a Total row. Refunds are attached to the type of the refunded customer.

This table answers questions such as "what share of my revenue comes from loyal customers?" or "do my new customers spend less on their first purchase?".

Revenue by payment method

The Revenue by payment method table groups orders by the payment method shown by your store, for example "Credit card", "PayPal" or "Bank transfer". We keep the name exactly as your store records it. Two different labels for the same method, such as "PayPal" and "PayPal Checkout", therefore give two rows. Orders with no payment method are grouped under "Unknown".

The columns are Payment method, Orders, Items sold, Revenue and Average order value. Refunds are removed from the payment method of the original order.

Use it to check the weight of a payment method before removing it, or to reconcile your takings with your payment provider's statements.

Tax by rate

The Tax by rate table lists the taxes collected, grouped by rate as your store names them (for example "VAT FR 20%" or "VAT 5.5%").

ColumnContent
Tax rateThe rate's name in your store
OrdersThe number of counted orders that contain this rate
Tax collectedThe tax collected on products at this rate
Shipping taxThe tax collected on shipping charges at this rate
Total taxThe sum of the two previous columns

An order that mixes two rates appears on two rows. The sum of the Orders column can therefore exceed the total number of orders. This table does not remove refunds.

Why a table doesn't appear

The three bottom tables only appear if they have at least one row. Tax by rate depends on the tax detail sent by your store. If your store doesn't provide that detail, or if no order in the period has tax, the table is not shown. Widen the period to check.

Example questions

  • What was my revenue for each month of the year? Choose This year, then Month in the table.
  • Which day last week sold best? Choose 7 days, then sort the table by Revenue.
  • Do my loyal customers weigh more than last year? Compare Revenue by customer type over two years with the date picker.
  • How much 20% VAT did I collect this quarter? Choose the quarter's dates and read Tax by rate.
  • Is revenue from my Belgian customers growing? Add a country filter with Filters.

Frequently asked questions

Going further

  • Orders to find the orders behind a figure.
  • Geography to see revenue by country.
  • Compare to put several order segments side by side.
  • Margin to go from revenue to profit.

On this page