Revenue Reports tour
Sales → Revenue Reports is where you see what the store has sold: revenue, order counts, average order value and new sign-ups for a period, broken down by day, product, customer, tax and referral source, with a CSV download for your accountant. This article walks through the page tab by tab and — more usefully — says exactly what each number counts, because a few of them do not mean what their labels suggest.
In one sentence: every figure on the page is the grand total of every order that is not Cancelled, Refunded or Failed, in the store’s own timezone; nothing is subtracted for partial refunds, nothing is scheduled or e-mailed, and the Tax tab is empty on every store today.
1. The page
Revenue Reports needs TitanCart Pro and an administrator login. It opens straight on a row of six tabs — Overview, Sales, Products, Customers, Tax and Referrals — with three controls on the right:
- Period — Today, Yesterday, This Week, Last Week, This Month (the default), Last Month, This Year or Custom, which reveals two date boxes.
- Daily / Weekly / Monthly — the grouping of the Sales tab’s rows. It appears on that tab only.
- ⬇ Export CSV — on every tab except Overview (see section 9).
Periods run from midnight to midnight in the timezone set under Settings → Appearance → Timezone (the WordPress timezone if that is empty). Weeks start on Monday. While a tab loads the page shows Loading…; a request that fails leaves the previous figures on screen with no message.
2. What counts — read this first
Which orders are in. One rule applies to every tab and to the Dashboard: an order is counted unless its status is Cancelled, Refunded or Failed. Everything else counts — Pending, On Hold, Processing, Completed and any status you created yourself. There is no “counts as revenue” switch on a status; the three excluded ones are recognised by what they are, so renaming or recolouring them changes nothing. If you keep dead orders in a custom status such as “Declined” they are inflating your revenue; move them to Cancelled or Failed instead (see Order Statuses).
What “Revenue” is. The order’s grand total as charged: items plus shipping, tax, any payment surcharge and any tip, after coupons and promotions, gift cards and loyalty points have been taken off. It is not a net-of-tax figure and not a net-of-shipping figure; the Sales tab breaks those parts out.
Refunds are never subtracted. A full refund moves the order to Refunded, so the whole order disappears from every figure. A partial refund changes nothing — the order stays in its status and still counts at its full original total. If you refund part of many orders, your reported revenue is higher than the money you kept; keep the gateway’s own statement for the real number. See Refunds and cancellations.
Unpaid orders count until they are cancelled. TitanCart writes the order as Pending before the customer pays. An abandoned card payment therefore sits in the figures until the automatic clean-up cancels it (24 hours after placement by default), so yesterday’s revenue can be lower when you look at it today.
One currency. Totals are added up as stored, whatever currency the order was placed in, and shown with the store’s currency symbol.
The comparison badge. The percentage next to each Overview card compares the period with the stretch of the same length immediately before it — on the 4th of the month, “This Month” is compared with the last four days of the previous month, not with the whole previous month. For a true month-on-month figure pick Last Month and note it down.
3. Overview
Four cards — Revenue, Orders, Avg. Order (revenue divided by orders) and New Customers — each with its comparison badge; a Revenue Overview bar chart of daily revenue for the period (No data for this period when there is none); Top Products, the five best sellers by units with their revenue; Recent Orders, the last ten orders placed; and Low Stock, products at or below the threshold set under Settings → Catalog (All products OK otherwise).
Three things to know about this tab:
- New Customers counts WordPress user accounts registered in the period — any account, including staff you add — and does not count shoppers who checked out as guests. It is a sign-up count, not a buyer count.
- Recent Orders is always the last ten orders regardless of the period and regardless of status, and shows them as #TC- followed by the order’s internal number rather than the order number you see on Sales → Orders. The status pill is grey for every status.
- The chart is always daily, whatever grouping is selected on the Sales tab.
4. Sales
One row per day, week or month (the Daily / Weekly / Monthly control) with Orders, Revenue, Discounts (coupons and promotions only — gift cards and points are not in this column), Shipping, Tax and Net Revenue, plus a Totals row. Weekly rows are labelled with the ISO week (for example 2026-W45).
Net Revenue is Revenue minus Discounts minus Tax. Because Revenue is already after coupons, the discount is taken off a second time here, and shipping, surcharges and tips stay in. Treat the column as a rough guide; for “sales excluding tax” use Revenue minus Tax yourself.
The table shows at most as many rows as Settings → Appearance → Admin elements per page (50 by default) and has no page controls, while the Totals row always covers the whole period. With Daily grouping and a long period (This Year, or a month when the setting is below 31) the rows stop early but the totals do not — switch to Weekly or Monthly, or export.
5. Products
One row per product sold in the period: Product (the name and product code as they were on the order), Units Sold, Revenue, Avg. Price and the current Stock (amber at or below the low-stock threshold). Click a column heading to sort.
- Revenue here is the line value before coupons and before tax (quantity times the unit price paid, including option surcharges). It will not add up to the Sales tab’s Revenue, which is the charged total.
- Rows are grouped by the product’s name and code at the time of the order, so a product you renamed mid-period appears twice. All variations of a product are added into one row. A product you have since deleted still appears, with Stock 0.
- Avg. Price is the plain average of the unit prices on the order lines, not weighted by quantity.
6. Customers
One row per buyer in the period: Customer (billing name over e-mail; (Guest) when the order carried no name), Orders, Total Spent, Avg. Order and Last Order. Guests and account holders are both listed; a customer whose billing name changed between orders gets two rows. The Last Order date is the UTC date, so an evening order can show the next day’s date in western timezones.
This tab recomputes from the orders, so it is the figure to trust. The Spent column on Customers → Customers is a running counter that only ever goes up and ignores cancellations and refunds; the two will differ once an order is refunded. See Managing customers.
7. Tax
The tab is laid out for a per-rate breakdown — Total Taxable Amount, Total Tax Collected, Tax Entries and a table by tax name and rate — but it reads a per-rate record that TitanCart does not write when an order is placed, so it shows $0.00 and an empty table on every store today. The tax your store collected is the Tax column on the Sales tab (one figure per period, all rates together), and the per-order amount is on each order. See Tax Rules.
8. Referrals
Answers to the optional “How did you hear about us?” question at checkout: Answered Orders, Revenue from Answered, Distinct Sources, then one row per source with its order count, share of answered orders and revenue. The question is off by default; the tab’s own empty state tells you where to switch it on: No referral answers in this period. Turn the field on under Settings → Checkout → Referral Source. Orders where the customer left the question blank are not counted at all.
9. Exporting
⬇ Export CSV builds a file and the button turns into ⬇ Download CSV. The format is CSV only (UTF-8 with a byte-order mark, so Excel opens it cleanly). Columns:
- Sales: Period, Orders, Gross Revenue (the Revenue column), Discounts, Shipping, Tax, Net Revenue, Avg. Order.
- Products: ID, Product, product code, Units Sold, Revenue, Avg. Price, Stock.
- Customers: ID, Name, Email, Orders, Total Spent, Avg. Order, First Order, Last Order.
- Tax: Tax Name, Rate (%), Taxable Amount, Tax Collected, Orders — empty, for the reason in section 7.
Three things to do before you click it:
- Set the period to Custom and fill in both dates. The export does not take the preset you chose on screen; with Today, This Month or any other preset selected it exports today only. Only the two Custom dates are sent.
- Expect the service’s default order, not the column you sorted by.
- On the Referrals tab the button does nothing — no file is built and no message appears. Copy the table instead.
The file lands in your uploads folder (wp-content/uploads/titancart/exports/) and the download link is a plain public address: anyone who has the link can open it, and the files are not cleaned up automatically. Delete old exports by FTP or your host’s file manager if the figures are sensitive. The export covers up to 9,999 rows.
10. The Dashboard and the reports
The admin Dashboard (tour) and the Overview tab read the same figures from the same place, with the same status rule, so they always agree — the Dashboard labels them Total Revenue, Total Orders, Avg Order Value and New Customers with a “vs prev period” badge. Both are cached for 60 seconds, so a new order can take up to a minute to show. Two Dashboard widgets are not period-based at all: Order Status (all-time counts per status) and Recent Orders (the last ten, with the real order numbers). The optional Revenue Breakdown widget, off by default in the Dashboard’s layout settings, shows the period’s Discounts Given, Shipping Collected and Tax Collected — the same three totals as the Sales tab. The Dashboard has no Custom period.
11. Scheduled and e-mailed reports
There are none. TitanCart does not send a daily, weekly or monthly sales summary, there is no report template under Settings → Notifications, and nothing can be scheduled from this page. The only automatic stock-related e-mail is the low-stock digest described in Inventory and stock control. If you need a regular figure, export with Custom dates or read it from the Dashboard.
12. TitanCart Lite and Pro
Revenue Reports is a Pro page: on Lite the Sales menu has no Revenue Reports entry and there is no locked placeholder; the Dashboard’s figures (section 10) are available on both editions. A Pro store whose licence has lapsed sees the entry with a Pro padlock. See TitanCart Lite.
Troubleshooting
- Revenue is higher than the money in my gateway account. Expected for three reasons: partial refunds are not subtracted, unpaid Pending orders count until they are auto-cancelled, and any custom status counts. Check Sales → Orders filtered by Pending and by your custom statuses.
- Yesterday’s figure went down overnight. Pending orders that were never paid were cancelled by the clean-up and dropped out.
- The Products tab does not add up to the Sales tab. Expected — product rows are pre-coupon, pre-tax line values (section 5).
- The same product is listed twice. It was renamed, or its product code changed, during the period.
- The Tax tab is empty. Expected on every store (section 7); use the Sales tab’s Tax column.
- My export only has today’s rows. Choose Custom and set both dates before exporting (section 9).
- Export does nothing on Referrals. Expected; the tab has no export.
- The Sales table stops before the end of the month. The row limit is Admin elements per page (section 4); switch to Weekly or Monthly, or raise the setting.
- New Customers is higher than the accounts I can see in Customers. It counts every WordPress account registered in the period, including staff.
- A new order is not on the Dashboard. Wait a minute; the figures are cached for 60 seconds.
See also
- Admin dashboard tour — the widgets that show the same figures.
- Order Statuses — which statuses are excluded from the figures and why custom ones count.
- Refunds and cancellations — full versus partial refunds and what each does to the reports.
- Managing orders — the Orders list the reports are built from.
- Managing customers — the Spent counter versus the Customers tab.
- Tax Rules — where the tax on an order comes from.
- Inventory and stock control — the low-stock threshold behind the Low Stock card.