Skip to main content

Generating Reports: Analyzing Your Data Effectively

S
Written by Sam E.

The Reports page turns your Acenda order data into downloadable files for sales, tax and fulfillment analysis. Pick a report type, a date range and a file format, and Acenda builds the file for you in a minute or two.

Prefer to ask instead of download? Connect the Acenda MCP server to your AI assistant and get reporting answers in chat: sales by marketplace, top products, returns trends, and more. Access is read-only and uses your existing Acenda permissions.

Ask your AI assistant for reports (Acenda MCP)

Alongside the downloadable reports on this page, you can use the Acenda MCP server (Model Context Protocol) to query the same kind of reporting data from a compatible AI assistant.

Once connected, try prompts like:

  • “What were my sales by marketplace last month?”

  • “What are my top 10 products by revenue this quarter?”

  • “How do returns compare across marketplaces this quarter?”

Setup takes a few minutes and does not require API keys. See Connect Your AI Assistant to Acenda for the connection URL, OAuth sign-in steps, and troubleshooting.


How to generate a report

  1. In the sidebar, under REPORTING, click Reports.

  2. In the Generate report box, choose a report from the Type dropdown. See Report types below.

  3. Choose a Format: CSV works best for imports and other systems; XLSX opens neatly in Excel.

  4. Under Range, choose Exact dates, then set the From and To dates. Both dates are included in full.

  5. Click Request. You'll see a “Report created” message, and the report appears in the list below.

  6. Wait for the Status to change to done. The list refreshes on its own every few seconds.

  7. Click the download icon (☁️) at the right of the row to save the file.

Important: check the dates in the file name before you use the report. Each file is named with the date range it covers and the time zone used, for example yourcompany_daily_sales_report_2026-09-01-2026-09-30_america_new_york.csv. Choosing Exact dates makes sure you get exactly the period you want.

All reports are based on the date each order was placed, not the date it shipped, and they use your organization's time zone.


Report types

Report type

What's in it

Best for

Daily sales

One row per day: orders, units sold, gross sales, item and shipping discounts, returns, net sales, tax and shipping.

Tracking daily revenue trends.

Item sold

One row per product: Product ID, SKU, name, brand, vendor, UPC/EAN/ISBN, group, total orders, units sold and total price.

Finding your best sellers and how fast each SKU moves.

Order item

One row per order line: order number, PO, sales channel, status, SKU, prices, tax, discounts, quantities fulfilled/cancelled/routed and expected ship/delivery dates.

Detailed order audits and reconciliations.

Sales by channel

One row per sales channel: orders, gross sales, discounts, net sales, tax and shipping.

Comparing performance across marketplaces.

Sales tax

Order totals and tax, grouped by billing country, state and county, order status and date. Only orders with tax are included.

Tax filing and compliance.

Sales tax detail

One row per order: order and tax amounts plus the ship-to city, state, postal code and country.

Checking tax order by order, or by ship-to location.

Ship advice

One row per ship advice (the shipping request sent to your warehouse or 3PL): status, sales channel, warehouse, shipping method and code, and requested ship/delivery dates.

Reviewing fulfillment and shipping performance.

Ship advice unshipped

Same columns as Ship advice, but only ship advices that are still Pending, Routed, Partially routed or Partially shipped.

Watching your fulfillment backlog.

Ship advice item (beta)

One row per item on each ship advice: warehouse name, SKU, prices, quantities and tracking numbers.

SKU-level fulfillment and tracking checks.

Tip: to see what still needs to ship, run Ship advice unshipped with a wide date range, such as the last 30–60 days. It only lists orders placed in the range you choose, so older stuck orders won't show up with a short range.


Looking for other data?


Troubleshooting

  • The report covers the wrong dates: check the dates in the file name. Request it again with Range set to Exact dates and the From and To dates you need.

  • “End date must be after start date”: the To date is earlier than the From date. Swap them and click Request again.

  • “Report failed! - rate limit exceeded”: you can request up to 10 reports a minute. Wait a minute, then try again.

  • No download icon: the report is still being built. Wait for the status to change to done. Large date ranges take longer.

  • Status says failed, with a red (!) icon: click the icon to see the error. Try a shorter date range. If it fails again, contact Acenda Support with the report type, dates and error.

  • The file has headers but no rows: no orders were placed in that range, or none match the report. For example, Sales tax skips orders with no tax, and Ship advice unshipped skips orders that have shipped.

  • Totals don't match a marketplace statement: reports use the order placed date in your time zone. Marketplaces often use the ship or payout date. Check the date range and time zone first.


Related articles

Still stuck? Contact Acenda Support and tell us the report type, the date range and what you saw.

Did this answer your question?