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: 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: 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: 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

​
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