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.
| Indicator | Definition |
|---|---|
| Revenue | The 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. |
| Orders | The number of counted orders placed during the period. |
| Items sold | The sum of item quantities in those orders. |
| Average order value | Revenue 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.
| Option | Effect |
|---|---|
| Deduct refunds | Removes refunds granted during the period |
| Deduct taxes | Removes VAT and other taxes from each order |
| Deduct shipping | Removes the shipping charged |
| Deduct fees | Removes 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.
| Column | Content |
|---|---|
| Date | The day, week or month of the row |
| Orders | The number of counted orders placed in that interval |
| Items sold | The quantity of items in those orders |
| Revenue | The interval's revenue, minus the interval's refunds |
| Average order value | The 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.
| Row | Who is in it |
|---|---|
| New customers | Orders from customers whose first counted order falls within the chosen period |
| Returning customers | Orders from customers who had already placed a counted order before the period started |
| Anonymous customer | Orders 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%").
| Column | Content |
|---|---|
| Tax rate | The rate's name in your store |
| Orders | The number of counted orders that contain this rate |
| Tax collected | The tax collected on products at this rate |
| Shipping tax | The tax collected on shipping charges at this rate |
| Total tax | The 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.