> ## 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.

# Eaglecart Reports Overview: Filters, Exports and Key Figures

> How Eaglecart Reports work: the report list, period, comparison and currency filters, refresh and settings, charts, tables and CSV exports, the Overview report and what every money figure means.

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

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

Reports overview

# Reports overview

Reports show what your store sold, what it cost you, what you're owed and how orders, quotations, invoices and workshop jobs are moving. This guide explains how the Reports screen works, the **Overview** report, and what every money figure means across all reports.

## Open Reports

In your admin, open **Analytics** and choose **Reports**. Reports is one screen with a list of reports on the left. Click a report and the main area changes, while the list and your filters stay where they are.

## The report list

The reports are grouped into sections:

| Section | Reports |
| - | - |
| **Overview** | **Overview** |
| **Sales** | **Sales Overview**, **Sales by Product**, **Sales by Collection**, **Sales by Category**, **Sales by Customer** |
| **Orders** | **Orders**, **Checkout** |
| **Operation** | **Quotations**, **Invoices**, **Car Jobs / Workshop** |
| **Finance** | **Profit & Margin**, **Outstanding / Receivables**, **Tax Report** |
| **Custom Reports** | **Build Report** |

* **Search** above the list filters it as you type.
* The toggle at the top folds the list down to icons, and it stays folded next time.
* On a phone, the list becomes a dropdown.

## How every report page is laid out

Top to bottom:

1. The report name, how old the figures are, and **Settings**.
2. The filter bar: period, comparison, currency and **Export**.
3. Cards with the headline figures.
4. Charts.
5. Tables.

Not every report has every part. Some have no chart or no table, and a few hide filters that wouldn't mean anything there. Figures load separately from the page, so changing a filter refreshes the numbers without reloading the screen. While they load, cards and tables shimmer instead of showing old numbers.

## Period

Choose one of nine presets or a custom range:

**Today**, **Yesterday**, **Last 7 Days**, **Last 30 Days**, **Last 90 Days**, **This Month**, **Last Month**, **This Year**, **Last Year**, **Custom Range**.

* The "Last N Days" presets include today. **Last 7 Days** is the previous six days plus today.
* Every period uses your **store's time zone**, not the server's. A sale counts on the day it happened where you are.
* **Custom Range** opens two date pickers. Future dates can't be picked. Once both dates are filled, the range applies without pressing anything.
* A custom range isn't remembered. Open another report and it goes back to your last preset.

## Comparison

Choose **No comparison**, **Previous period** or **Previous year**.

* **Previous period** is the same length of time just before the one you're viewing. For **Last 30 Days**, it's the 30 days before that.
* **Previous year** is the same dates one year earlier.

Turning comparison on adds:

* A dotted line on the charts that support it.
* A green or red change badge on one headline card per report, for example "2024.4% more than last period".
* A change figure on the total row of some tables.

When the earlier period had nothing, the badge says **New** instead of a percentage, because a rise from zero isn't a percentage. When nothing has changed, it says so. With comparison off, that card says "No comparison".

## Currency

The currency picker changes the currency every figure is shown in. It doesn't change which sales are counted.

* Pick a currency and every card, chart, table **and export** on every report shows it until you change it.
* Past orders are converted at the rate that applied **on their own date**, so last year's report doesn't shift when rates move.
* If you changed your store's own currency in the past, older orders are converted from the currency they were taken in.
* Quotations, invoices and workshop jobs carry their own currency and are converted from it, at their own date.
* **Stock is the exception.** Stock on hand isn't a dated sale, so stock value uses **today's** rate.
* The list is searchable by currency code, name or country. Typing "pakistan" finds PKR.

Orders keep the value they had in your store's currency on the day they were placed. Nothing is recalculated later.

## How current the figures are

Next to the report name is a pulsing dot and a stamp such as "Updated now", "12 min ago" or "2 days ago". It tells you **how old the figures are**, not how long the page has been open.

* Report figures are saved so pages open instantly. Switching reports or changing the period doesn't reset the stamp, because the figures really are that old.
* Click the stamp, or the arrow beside it, to refresh. It spins, then everything is rebuilt from live data and the stamp resets.
* A refresh rebuilds **every** report for the store, so the next report you open is fresh too.

## Settings

**Settings** opens a small window.

**Appearance**

* **Chart colour:** eight colours. Your pick colours the pulsing dot and the main line on every chart. A second line never uses the same shade.
* **Short figures:** shows large numbers as 1.15k, 2.4M or 1.2B. It applies to cards, charts and tables together. Exports always stay exact.

**While the page is open**

* **Auto refresh:** every minute, 5, 15 or 30 minutes. It only runs while the tab is in front of you. In a background tab it waits, then catches up when you come back.

**Reset** puts every setting back to default. **Save** applies your changes and reloads the page.

### What's remembered

* Period, comparison, currency and the folded list are saved the moment you change them.
* Chart colour, short figures and auto refresh need **Save**.
* Everything is remembered per store, in that browser. On another computer you start from the defaults.

## Cards

Each card has a label, the figure and usually a line underneath with context, such as a margin, a share of the total or the change from last period.

* Hover a card's label for help explaining exactly what it includes and leaves out. Several cards look alike but count different things.
* **Top Product**, **Top Customer** and **Top Collection** open the record they name.

## Charts

* **Trend lines:** a figure over time.
* **Bars:** a figure across categories, or stacked bands that add up to a whole.
* **Share gauges:** a half circle split into slices, with a row per slice below showing its value and percentage.

Hover any point for a tooltip. With comparison on, it also shows the earlier figure and the change.

Most trend charts have a **Chart** / **Table** toggle. **Table** shows the same figures as rows, easier to read exactly.

Time is grouped by the length of the period: a day or two by hour, up to about four months by day, anything longer by month. Days with no sales show as zero, not a gap.

## Tables

* Click a column heading to sort, and again to reverse. Sorting is off when there's only one row.
* Tables with a search box search the name column. The **total row stays on the period's real total** even while a search narrows the rows.
* An empty cell shows a dash, never a blank.
* Product rows have a thumbnail, and variants show their options as small badges.
* Click a row's name to open the product, customer or order.

## Export

**Export** downloads the report you're viewing as a **CSV** file, for the period and currency on screen. Every report has it except **Build Report**. The file opens in Excel with Arabic text intact.

The file contains, in order:

1. The report name.
2. The period, and the comparison period if one is on.
3. When the file was generated.
4. **Summary:** every card, name and value, in the order they appear.
5. Each chart as its own table, with its total.
6. Each table, with its columns, rows and total row.

Figures are formatted, for example AED 1,234.00, so the file matches the screen. Short figures are ignored, so exports are always exact. Product and customer cells export the name only. Exporting a report you've just looked at is instant, because it uses the same figures.

The **Orders** report has a second export, **Export Sales Tax**. See [Orders report](https://help.eaglecart.com/reports/orders-report.md).

## The Overview report

The first report in the list: where the money came from and what was left of it, on one screen.

### Cards

| Card | What it shows |
| - | - |
| **Total Sales** | Everything customers paid. Carries the comparison badge. |
| **Tax Collected** | Tax charged on the products sold. The note shows the net sales it was charged on, for example "Output Tax on AED 644,877 net sales". |
| **Net Sales** | What the products earned after discounts, without tax: "Sales with Tax and shipping taken out". |
| **Discount Given** | "Money given away in discounts" on the items sold. |
| **Cost of Goods** | "What the goods you sold cost you", for products with a cost entered. |
| **Gross Profit** | Net sales minus cost. The note shows the margin and how many products have no cost, for example "-48.7% margin · 10 products with no cost". |
| **Units Sold** | Every item sold: "Total items across all sales". |
| **Average Sale** | "Average order value", tax and shipping included. |

### Charts

* **Sales Trend:** total sales over the period, with the earlier period dotted behind. Has a **Chart** / **Table** toggle.
* **Sales by Sales Channel:** a share gauge splitting **total sales** by where the order came from, such as **Point of Sale (POS)**, **Online store** and **Workshop**, with each channel's value and percentage. It splits money, not order count. Channels with no sales still appear at zero, so you can see which aren't working.

### Top 50 Products

Your fifty biggest earners, by sales after discounts, without tax. Columns: **Product**, **Units sold**, **Revenue**. Variants are ranked separately, so two sizes of the same dress each have their own row.

> [!NOTE]
>
> Tax Collected isn't income. You hold it for the government, which is why it sits outside Gross Profit.

## What the money figures mean

These words appear across several reports and aren't interchangeable.

| Figure | What it is | Includes | Leaves out |
| - | - | - | - |
| **Total Sales** | Everything customers paid | Products, tax, shipping, fees | Cancelled, unpaid, failed and refunded orders |
| **Net Sales** | What the products sold for after discounts | Product lines only | Tax, shipping, fees |
| **Tax Collected** | Tax charged on the products sold | Product tax | Tax on invoices and workshop jobs |
| **Discount Given** | Discount given on the items sold | Line discounts | Nothing else |
| **Cost of Goods** | What those products cost you | Products with a cost entered | Products with no cost, shipping, fees |
| **Gross Profit** | Net sales minus cost | Products with a cost entered | Products with no cost |
| **Margin** | Gross profit as a share of net sales | Products with a cost entered | Rent, wages, ads and other overheads |
| **Units Sold** | Every item sold | All items | Nothing |
| **Taxable Sales** | Sales that were charged tax, before the tax | Taxed products | Zero-rated and exempt products, shipping, fees |

### Total Sales and Net Sales are different on purpose

Total Sales is what landed in your account. Net Sales is what the products earned, with tax taken back out. Profit is always measured from Net Sales, never Total Sales, because the tax isn't yours.

When no shipping or fees are recorded separately, Net Sales plus Tax Collected equals Total Sales. A gap between them means an order whose total and line items disagree, not a reporting fault.

### Discount is already taken off

**Discount Given** shows how much you gave away. It isn't subtracted again anywhere: it has already come out of Net Sales and Total Sales, because the customer paid that much less.

### Products with no cost are skipped, not counted as free

A product with no cost entered would look like pure profit and push your margin up. So cost, profit and margin are worked out **only over products that have a cost**. The **Gross Profit** note tells you how many products are missing a cost, which tells you how much of the period is really being judged. In tables, those rows show a dash for profit and margin. Add costs in [Pricing, costs and discounts](https://help.eaglecart.com/products/pricing-costs-and-discounts.md).

Gross profit isn't your business profit. Rent, salaries, advertising and other overheads aren't taken off anywhere in Reports.

### Inclusive and exclusive tax

Both work. Tax is stored separately from the price on every line, so whichever way your store prices, reports read it the same way. See [How tax works in Eaglecart](https://help.eaglecart.com/finance/how-tax-works.md).

## Which orders count

Every order has three statuses: order, payment and fulfillment. Different reports look at different ones. See [Order statuses explained](https://help.eaglecart.com/orders/order-statuses.md) and [Payment statuses explained](https://help.eaglecart.com/orders/payment-statuses.md).

**On every sales report** (Overview, Sales Overview and all the Sales by reports), an order is counted unless it's:

* **Cancelled**.
* **Unpaid** or **Failed** payment.
* **Refunded**. Refunded orders are left out of every sales figure, because the money went back.

Of the orders that count, those marked **Paid** count as collected, and anything else counts as still owed. A **part-paid order counts as owed for its whole value**, because the deposit isn't recorded anywhere reports can see. Check the orders themselves before using owed figures for cash planning.

The **Orders** report deliberately counts every order, including lost ones, and **Outstanding / Receivables** is narrower still. See [Orders report](https://help.eaglecart.com/reports/orders-report.md) and [Outstanding / Receivables report](https://help.eaglecart.com/reports/outstanding-receivables.md).

## Why don't these numbers match?

| You compare | Why they differ |
| - | - |
| Overview and **Orders** | Orders counts every order, including cancelled and returned ones. Sales reports leave those out. |
| Overview and **Sales by Category** | Products with no category are left out of Sales by Category. |
| Collection rows and the collection total | A product in several collections counts in each row, but once in the total. |
| **Tax Collected** and **Tax Invoiced** | Tax Collected is tax on products sold. Tax Invoiced is tax on invoices raised. |
| **Invoices** and sales reports | Invoices counts drafts too, and invoices made from orders also appear in sales. |
| **Net Sales** and **Taxable Sales** | Taxable Sales leaves out products that weren't taxed. |
| Stock value today and last month | Stock cards always show today's stock at today's rate. |

## Keep reading

* **Next:** [Sales Overview report](https://help.eaglecart.com/reports/sales-overview.md): the money ladder with your trading pattern.
* [Profit & Margin report](https://help.eaglecart.com/reports/profit-and-margin.md): profit and cost in detail.
* [Tax Report](https://help.eaglecart.com/reports/tax-report.md): tax collected and exports.


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