> ## Documentation Index
> Fetch the complete documentation index at: https://help.eaglecart.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Orders Report and Sales Tax Export in Eaglecart

> Read the Eaglecart Orders report: every order including cancelled and returned ones, open and delivered orders, cash on delivery, orders by source and status, and the Export Sales Tax file.

[Help Center](https://help.eaglecart.com/introduction.md)

[Reports and analytics](https://help.eaglecart.com/reports.md)

Orders report

# Orders report

The **Orders** report is about order flow rather than revenue: how many orders came in, where they're sitting and how many you lost. Open it from **Orders** > **Orders** in the report list.

**This is the one report that counts every order**, including those later cancelled or returned. That's why its totals don't match the Overview report.

## How orders are grouped

| Group | What goes in it |
| - | - |
| **Cancelled or Returned** | Orders that are **Cancelled**, **Return to Origin** or **Missing**. |
| **Live** | Every other order. |
| **Delivered** | Live orders marked **Delivered** or **Fulfilled**. |
| **Open** | Live orders not delivered yet. |

Return to Origin and missing parcels count as lost, not live. See [Return to origin and partial fulfillment](https://help.eaglecart.com/orders/return-to-origin-and-partial-fulfillment.md) and [Order statuses explained](https://help.eaglecart.com/orders/order-statuses.md).

## Cards

| Card | What it shows |
| - | - |
| **Total Orders** | Every order placed, including ones later cancelled or returned. Carries the comparison badge. |
| **Order Value** | What the live orders are worth, paid or not, tax and shipping included. |
| **Average Order** | Order value divided by the number of live orders. |
| **Open Orders** | Live orders not yet marked **Delivered** or **Fulfilled**. |
| **Delivered** | Orders that reached the customer. The note shows their share of live orders. |
| **Cancelled or Returned** | Cancelled, Return to Origin or Missing orders. The note shows what they were worth. |
| **Cash on Delivery** | Orders the customer pays on delivery. The note shows their share. |
| **Unfulfilled Value** | Money in orders that haven't arrived yet. The note shows how many. |

Cancelled, Return to Origin and Missing orders are left out of **Order Value**, **Average Order** and the **Cash on Delivery** count.

## Charts

* **Orders trend:** how many orders came in over the period, with the earlier period dotted behind. **Chart** / **Table** toggle.
* **Orders by source:** a share gauge splitting the **number** of orders by sales channel, such as **Point of Sale (POS)**, **Online store** and **Workshop**. The Overview report's channel gauge splits money instead.

## Orders by status table

Where your orders are sitting right now.

| Column | What it shows |
| - | - |
| **Status** | The order status. |
| **Orders** | How many orders have it. |
| **Total inc. Tax** | What they're worth, including tax. |
| **Share** | Their share of all orders. |

Every status is listed even when it's empty, so you can see which ones are clear.

## Export Sales Tax

This report has a second export button next to **Export**: **Export Sales Tax**.

| Export | What you get |
| - | - |
| **Export** | This report's cards, charts and tables as a CSV. |
| **Export Sales Tax** | One row per order, for tax work. |

The **Export Sales Tax** file has these columns:

| Column | What's in it |
| - | - |
| **Order ID** | The order. |
| **Items** | What was on it. |
| **Quantity** | How many items. |
| **Total Excl. Tax** | The order before tax. |
| **VAT 5%** | The tax on it. |
| **Total Incl. Tax** | What the customer paid. |

It uses the period on the toolbar, like everything else on the page. Use it to give your accountant the orders behind your tax totals. The [Tax Report](https://help.eaglecart.com/reports/tax-report.md) gives the totals, this file gives the orders.

> [!WARNING]
>
> Two things to check against your own setup:
>
> * **The tax column header always says VAT 5%.** If you sell at another rate, or in a region with a different rate, the header doesn't change. The amounts are the tax actually charged.
> * **It reports at order level.** An order mixing standard-rated and zero-rated items shows one combined tax figure, not one per rate.

This file helps you prepare figures. It isn't a certified tax return. See [How tax works in Eaglecart](https://help.eaglecart.com/finance/how-tax-works.md).

## Why this report differs from Sales Overview

| Orders report | Sales reports |
| - | - |
| Counts every order, including cancelled and returned | Leave out cancelled, unpaid, failed and refunded orders |
| **Order Value** includes unpaid live orders | **Total Sales** counts orders that aren't unpaid or failed |
| Counts orders | Counts money |

## Common questions

**Why is Total Orders higher than the orders in Sales Overview?** Total Orders includes cancelled and returned orders.

**Are Return to Origin orders counted as sales?** No. They're in **Cancelled or Returned**.

**Why does Orders by source differ from Sales by Sales Channel?** One counts orders, the other splits money.

## Keep reading

* **Next:** [Checkout report](https://help.eaglecart.com/reports/checkout-report.md): checkouts started, completed and abandoned.
* [Tax Report](https://help.eaglecart.com/reports/tax-report.md): tax totals.
* [View and manage orders](https://help.eaglecart.com/orders/view-and-manage-orders.md): the orders list.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.