Skip to main content
The three revenue and tax reports in 247CloudHub Analyse cover the question “what did we sell, what came back, and what tax do we owe on it.” Each is filtered by date range and exportable to CSV. None of them are a replacement for your accounting system, but together they are the operational view of the revenue line that runs across Amazon, eBay, and your direct webstore in one place.

​
Sales report

Path: Home, Analyse, Sales. The Sales report shows every order line that completed in the chosen date window, with one row per SKU sold per order. The columns are tuned for ops and trade review rather than finance:
ColumnWhat it means
SKUThe internal SKU as held in CloudHub. For multichannel sellers this is the master SKU, not the channel-listing ID.
Product NameFree-text product name as configured in the Common Inventory.
Order NumberThe internal CloudHub order number. For Amazon this is also linked back to the Amazon order ID.
Order SourceThe marketplace and account that placed the order, for example eBay - eBayUK or The Monogram - DryKids (the webstore label).
Order DateMarketplace timestamp in dd MMM yy hh:mm:ss tt format.
Order QuantityUnits in this line.
Product CostUnit price excluding shipping.
Shipping CostShipping charged on the line.
Total (Inc. VAT)Line total inclusive of VAT.
Total (Ex. VAT)Line total excluding VAT.
The summary header shows three rolling totals across the filter window: Total product Cost, Total Shipping Cost, and Total VAT. A Total Products counter underneath the date pickers shows the row count (for example, 372 records over a 30-day window). Use cases:
  1. Trade review. Filter to last 7 days, sort by Order Quantity descending, see the volume movers across all channels in one list.
  2. Reconcile to a settlement report. Filter to a single calendar month, export, then reconcile against the Amazon settlement report or the eBay seller statement.
  3. Investigate a single order. Search by Order Number, see every line that was on it.
Common gotcha: the Sales report counts orders that completed inside the window. An order created on the last day of one month and dispatched on the first day of the next will show in the dispatch month, not the order month, depending on how your channel reports timestamp it. Always cross-check with the Customer Services search by Order Date if the boundary day matters.

​
Returns report

Path: Home, Analyse, Returns. The Returns report lists every refund or return processed in the date window, with the refund context: who returned it, why, and what was refunded. Empty by design until a return is processed, with the columns:
ColumnWhat it means
Order noThe originating order number.
Order dateWhen the original order was placed.
Order SourceThe marketplace and account.
SKUThe returned SKU.
Product titleProduct name.
ActionRefund only, or refund and resend, depending on the workflow.
Returns reasonBuyer-supplied reason or marketplace-supplied reason code.
Refund dateWhen the refund was issued.
Ordered quantityUnits originally ordered.
Actioned quantityUnits actually refunded or returned.
Refunded product priceRefund value on the goods.
Refunded shipping priceRefund value on shipping, if any.
Resent dateIf the workflow resent rather than refunded, the resend date.
Processed byThe CloudHub user who processed the refund.
Use cases:
  1. Refund-rate trend. Compare a 30-day window this month against the same window last month. A creeping refund rate on a SKU is a quality, sizing, or description signal.
  2. Returns-reason analysis. Aggregate by Returns reason to see whether returns are concentrated in “wrong size”, “not as described”, or “damaged in transit”. Each cause routes to a different fix.
  3. User audit. Processed by lets a manager see who is processing returns, which is useful when a customer complains that a refund was not actioned.
Common gotcha: marketplace return windows differ. Amazon refund windows on FBA orders close at 30 days. eBay buyer protection runs longer. The Returns report shows whatever has actually been processed; a return that is still inside the buyer’s window may not appear yet.

​
VAT report

Path: Home, Analyse, VAT. The VAT report rolls the Sales line items up by sale date and shows the VAT liability per day across all channels in one grid. The header shows three running totals across the window: Total With VAT, Total Without VAT, and Total VAT. The body has one row per sale day with:
ColumnWhat it means
Sale DateCalendar day, dd MMM yy hh:mm:ss tt.
Total Sales Including VATGross sales on that day.
Total Shipping Including VATShipping charged that day inclusive of VAT.
Total Sales Excluding VATNet sales on that day.
Total Shipping Excluding VATNet shipping.
Total VATVAT liability on the day.
Use cases:
  1. Quarterly VAT return. Filter to the VAT quarter, export, hand the CSV to your accountant or your bookkeeping software import.
  2. Channel mix check. Spot a day where Total VAT is unusually high and drill into the Sales report for that day to see which channel concentrated the volume.
  3. Zero-VAT day audit. A row with 0.00 in the Total VAT column means every line that day was either zero-rated, exempt, or the channel did not pass VAT through to CloudHub. Worth confirming by sampling.
Common gotcha: Amazon UK passes VAT through to CloudHub on most orders, but Amazon EU programme orders, B2B orders flagged as VAT-exempt, and Marketplace Facilitator orders (where the marketplace is the deemed supplier for VAT purposes) can show as zero-VAT. The report shows what the channels gave us; finance reconciles the VAT-collection-by-marketplace separately.

​
How these three pair with the rest of the AI OS

NeedWhere to go
Live revenue card on the dashboardNerve Centre, the connector card for that channel
”Why did revenue drop 18 percent yesterday?”Vortex Mind, Daily Revenue Leakage report
”Show me my Amazon UK refunds in April 2026”Ask Viq, plain-English query
”Open a fix to investigate the spike in ‘wrong size’ returns on SKU DK001B”Actions Kanban, create a card from the Vortex Mind report

​
Common questions

Is the Sales report inclusive of cancelled orders? No. Cancelled orders do not appear. Cancelled stage is tracked in the Order Stages report instead. Why does Total VAT show 0.00 on the summary even though my line items have VAT? The summary header Total VAT reflects the configured VAT registration of the account. If the workspace is set up as zero-rated or VAT-not-applicable in Organisation Settings, the rolled-up Total VAT in the header reads 0.00 even when individual lines carry VAT data passed in by the channel. Check Organisation Settings if this looks wrong. Can I filter Sales by single channel? Not on the report itself. Use the Customer Services marketplace filter to scope a view down to one channel, or export the Sales CSV and pivot by Order Source. Can I refund directly from the Returns report? No. Refunds are processed via the Customer Services console. The Returns report is the historical view.

​
Next steps