## Before You Start

Make sure you have:

- Access to the Sales Report. If **Sales** is missing from your **Reports** menu, your account does not have it yet. See [Report Access for Staff](/docs/report-access-for-staff).
- A basic feel for choosing a period and filters. See [Report Periods and Filters](/docs/report-periods-and-filters).

---

## What the Sales Report Is

The Sales Report is your shop's sales book. It adds up every order your shop has sold and shows the money by day, month or year.

A sale is the value of the work you agreed to do for a customer. It is not the cash you collected. A customer who has not paid yet still counts as a sale. Cash collected lives in the Payments Report.

The Sales Report helps you decide things like:

- Which days need more staff at the counter.
- Whether this month is better or worse than last month.
- Which sales channel (a place where you take orders, such as your shop counter, your app or a mall outlet) brings in the most money.

Without it, you only see one order at a time. You would have to guess which days are busy and whether your discounts and returns are eating into your sales.

---

## Open the Sales Report

1. In the top menu, click <Badge> Reports </Badge>.
2. Click <Badge> Sales </Badge>.

![The Reports menu open in the top menu with Sales highlighted](https://cdn.easybizcloud.app/knowledge/f640f20c-34ea-43b4-9b78-7537e60ac7d8.png)

3. At the top right, choose how much time to look at: <Badge> Daily </Badge>, <Badge> Monthly </Badge>, <Badge> Yearly </Badge> or <Badge> Custom </Badge>.
4. Next to it, pick the day, month or year you want. In Custom, pick a start and end date, up to 366 days.

![The Sales Report in Monthly view with the Daily, Monthly, Yearly and Custom buttons and the month picker highlighted](https://cdn.easybizcloud.app/knowledge/3ef61db9-61a0-4156-ba5c-4d5e6d232c1b.png)

5. Below the title, use the filters to narrow the report:
   - **Market**: the country you are looking at, for example Singapore or Malaysia. Each market is shown in its own currency.
   - **Day**: only some days of the week, for example Saturdays. This appears in Monthly and Custom views.
   - **Sales channel**: one place where orders are taken.
   - **Location**: one physical shop.

![The Market, Day, Sales channel and Location filters below the Sales Report title](https://cdn.easybizcloud.app/knowledge/f4f8d014-0a3b-4aad-b6b8-d764eb7fea13.png)

---

## Read the Summary Cards

The top of the page has two cards.

The first card has four boxes:

- **Net Sales**: your sales after discounts.
- **Orders**: how many orders were sold.
- **Avg Order Value**: the average amount of one order.
- **Sales Returns**: how many returns were made.

Under each number is a small arrow that compares it with an earlier period. Green going up means better. Red going down means lower. The labels tell you what it is compared with:

| Label | Compared with |
| ----- | ----- |
| DoD | The day before (Daily view) |
| WoW | The same day last week (Daily view) |
| MoM | The month before (Monthly view) |
| YoY | The same month or year last year |

When you look at the current month, the report compares only the same number of days. So on the 10th, you see 1 to 10 this month against 1 to 10 last month. This keeps the comparison fair.

If your shop sells both services and retail products, each box also shows a **Services** and a **Retail** line.

![The summary cards showing Net Sales, Orders, Avg Order Value and Sales Returns with MoM and YoY changes and Services and Retail lines](https://cdn.easybizcloud.app/knowledge/832eaeec-b089-4a03-b96f-ad480d4b2e8b.png)

The second card is the **Sales Summary**. It shows how your sales add up:

- **Gross Sales**: sales before any discount.
- **Discounts**: money taken off with discounts and promotions.
- **Net Sales**: Gross Sales minus Discounts.
- **Tax**: GST or SST on the sales. It shows only when the period has tax. There's no separate SST or GST report. To get the tax for a period in a file, choose that period and [export the report](#export-this-report): the file's **Summary** sheet has a **Tax** row, and **Daily Sales** has a **Tax** column for each day.
- **Rounding**: small cash rounding adjustments.
- **Total**: what customers were charged in the end.

![The Sales Summary card showing Gross Sales, Discounts, Net Sales, Tax, Rounding and Total](https://cdn.easybizcloud.app/knowledge/df242f2d-1c78-4e52-a813-bc3c911e9087.png)

---

## Read the Trend Chart

Below the cards is a bar chart.

- In Monthly and Custom views, it is called **Daily Trend**. Each bar is one day.
- In Yearly view, it is called **Monthly Trend**. Each bar is one month.
- In Daily view, there is no chart, because there is only one day to show.

Taller bars mean more sales. Hover over a bar to see that day's exact amount.

![The Daily Trend chart with the tooltip for one Saturday showing that day's Net Sales and Orders](https://cdn.easybizcloud.app/knowledge/f50420e5-6976-4081-9c98-412aee770567.png)

---

## Read the Breakdown Tables

Scroll down to see where your sales came from. Most tables show Net Sales, Orders and a Share % of the total:

- **Discount Breakdown**: each discount or promotion, how many times it was used and how much it took off. A Refer-a-friend promotion shows two rows: **Referral — new customer discount** and **Referral — referrer rewards**. Click a row to see the orders that used it. When you export the report, its **Discount Orders** sheet lists the same orders with each order's discount and total, so you can see how much a promo code brought in.
- **Sales by Business**: sales for each sales channel.
- **Sales by Company**: shown only if you run more than one company.
- **Sales by Business Unit**: sales for each line of service, for example Laundry or Bag Repair. It shows only if you have more than one. Click a row to see that unit's orders for the same period and filters, for example **Orders in Laundry**. The newest days show first; click **Load more** for earlier days. Click an order number to open the order.
- **Sales by Lead Source**: where the customer came from, for example walk-in or WhatsApp.
- **Net Sales by Product**: your best-selling items, grouped into **Service Items** and **Retail Products**. If you see buttons above the table, such as **Product** and **Service Option**, click one to change how the table groups your sales. Any extra sales detail you set up, such as Brand, gets its own button. The table title follows your choice, for example **Net Sales by Service Option**.

A table with nothing to show is hidden.

![The Sales by Business and Sales by Business Unit tables showing Net Sales, Orders and Share %](https://cdn.easybizcloud.app/knowledge/1639e3b7-f360-44bf-a2fb-761e04597c66.png)

---

## Read the Sales Returns Table

A return is when you give money back or cancel part of an order after it was sold, for example a refund for a damaged shirt. Returns are listed in their own table called **Sales Returns**, with the number of returns in its title.

It shows the **Order #**, the **Date** of the return, the **Business** (sales channel), the **Amount** taken off and any **Note** your staff wrote.

A return is recorded on the day it was made. It does not change the original sale's day. So a return made in June for a May order lowers June's sales, not May's.

![The Sales Returns table with two returns showing Order #, Date, Business, Amount and Note](https://cdn.easybizcloud.app/knowledge/aba3ca0e-e86b-4da7-aa6a-0f47cb1ffe12.png)

---

## Read the Prior-Period Adjustments Table

When a month is closed, a late change to one of its sales is not added to that month. It is recorded in the first open month instead, such as a credit note for a September order issued in October. To learn how closing works, see [Closing a Sales Period](/docs/closing-a-sales-period).

The **Prior-period adjustments** table lists these late changes, so you can see where they came from:

- In **Monthly** view, it lists the changes recorded in the month you are looking at.
- In **Yearly** view, pick a month in **Posting month** to see that month's changes.

Each row shows the **Order #**, the **Adjustment type** (such as Credit note or Void), the **Kind** (Return, Cancellation or Correction), the **Posting date** it was recorded on, the **Original sale date**, the **Sales channel** and the **Amount**.

If there are none, the table says **No prior-period adjustments**.

---

## Check One Day's Orders

To see every order behind one day's number:

1. Click <Badge> Daily </Badge>.
2. Pick the day.
3. Scroll to the bottom to the **Order Entries** table.

![The Order Entries table in Daily view with Sale, Amendment and Credit Note lines](https://cdn.easybizcloud.app/knowledge/f0e166aa-6db0-436f-9d80-68af51c8c0a7.png)

The **Type** column tells you what each line is:

| Type | What it means |
| ----- | ----- |
| Sale | A new order sold |
| Amendment | A change to an order that was already sold, for example an item added |
| Credit Note | A return |
| Void | A cancelled order or a cancelled return |

For a longer period, [export the report](#export-this-report) with **Include entry-level details (Entries + Line Items sheets)** ticked. The **Entries** sheet lists every sale, change and return with its order number, business unit and sales channel.

---

## Export This Report

Export the Sales Report when someone needs your figures outside EasyBiz, for example your accountant at month end or your tax filing.

1. Set the report to the period and filters you want.
2. At the top right, click <Badge> Export </Badge>.

![The Sales Report page set to Monthly, with the Export button at the top right marked](https://cdn.easybizcloud.app/knowledge/5ad9898f-e81f-4464-8403-59c922c8f40e.png)

The **Export Sales Report** window opens.

3. Check the **Date range**. It starts with the period on the page: the day in Daily view, the whole month in Monthly, the whole year in Yearly, or your exact dates in Custom. Change it here if you need different dates.
4. Under **Sales Channels**, keep the sales channel you picked on the page, leave **All sales channels**, or pick one or more.
5. Tick **Include entry-level details (Entries + Line Items sheets)** if you need every order and every item, not only the totals.
6. Read the grey box under the options. It lists the sheets the file will have.
7. Click <Badge> Export </Badge>.

![The Export Sales Report window with a one-month Date range, All sales channels and the entry-level details box ticked](https://cdn.easybizcloud.app/knowledge/f2ab802c-6fdc-4a65-85e5-39801ffcb0fa.png)

When **Export ready** shows under the button, click <Badge> Download </Badge>. The file is also kept on your Downloads page. See [Exporting to Excel and Downloads](/docs/exporting-reports-and-downloads).

### What carries over from the page

| **Filter on the page** | **In the export** |
| ----- | ----- |
| Period (Daily, Monthly, Yearly or Custom) | Fills in the **Date range**. You can change it in the window |
| Sales channel | Fills in **Sales Channels**. You can change it in the window |
| Market | Used, but not shown in the window. The file covers that market only, in its currency |
| Location | Used, but not shown in the window. The file covers that location only |
| Day (for example, only Saturdays) | Not used. The file covers every day in the date range |

### What's in the file

The file has these sheets. A sheet with nothing to show is left out.

| **Sheet** | **What it shows** |
| ----- | ----- |
| Summary | The currency, the period, and the totals: Gross Sales, Discounts, Net Sales, Orders, Avg Order Value, Tax, Rounding and Total |
| Daily Sales | One row for each day, with its orders, sales, discounts, tax, rounding and total |
| By Sales Channel, By Market, By Location, By Company, By Business Unit | The totals for each one, with their tax, orders, sales returns and share of your sales |
| Product, Service Option and your own sales details, such as Brand | Net sales and quantity for each item or option, with its sales channel, location and business unit |
| By Source, Discount Promotion, Discount Orders | Where your customers came from, each discount or promotion used, and the orders behind each discount with that order's discount and total |

With **Include entry-level details (Entries + Line Items sheets)** ticked, the file also has an **Entries** sheet and a **Line Items** sheet. **Entries** lists every sale, change and return with its order number, business unit, sales channel and tax. **Line Items** lists every item on those orders with its quantity and amount.

You can export up to one year (366 days) at a time. With the tick box on, the limit is 92 days. The window shows a red message when your dates are too long.

<Callout type="tip" title="💡 Tip">
For your GST or SST filing, export the quarter without the tick box. The **Summary** sheet has the **Tax** total, and **Daily Sales** has the tax for each day.
</Callout>

---

## Example: PressRight Finds Its Busiest Day

PressRight Laundry has two staff at the counter every day. The owner wants to know if that makes sense.

1. She opens <Badge> Reports </Badge>, then <Badge> Sales </Badge>, and clicks <Badge> Monthly </Badge> for last month.
2. In the **Daily Trend** chart, the Saturday bars are clearly the tallest. Tuesday bars are the shortest.
3. In the **Day** filter, she picks **Sat**. The summary cards now show only Saturdays: S$4,860 Net Sales from 162 orders.

![The Sales Report for September with the Day filter set to Sat, showing Net Sales $4,860.00 and 162 orders](https://cdn.easybizcloud.app/knowledge/6895eee8-835d-4720-a58d-780882c2c840.png)

4. She changes the Day filter to **Tue**. Tuesdays show S$1,420 from 51 orders.

PressRight now knows Saturdays bring in more than three times Tuesday's sales. The owner adds a third staff member on Saturdays and moves one staff member to ironing on Tuesdays.

---

## FAQs

**Does a sale count when the order is created or confirmed?**
>When the price is confirmed. An order with a final price counts as soon as it is confirmed. An order created with the price "to be confirmed" (for example, a bag repair waiting for a quote) only counts once the price is set, and it counts on that day. Payment has nothing to do with it. Unpaid orders still count.

**Why does an order appear on a different date than expected?**
>There are three common reasons. The price was confirmed on a later day than the order was taken. The sales period for that day was already closed, so the sale was moved to the next open day. Or it is a return, which counts on the day of the return. Changes moved out of a closed month are listed in the **Prior-period adjustments** table, with their original sale date. See [Closing a Sales Period](/docs/closing-a-sales-period).

**Are B2B (agent) orders included?**
>Yes. Orders from agents, meaning business customers who order through their own agent account, are included. Unlike shop orders, they always count on the order date, even if the price is confirmed later. This keeps them in line with the agent's monthly bill.

**Why doesn't Net Sales match the cash in my Payments Report?**
>Sales counts work sold, and payments count money received. A customer who pays a deposit today and the rest next week shows up in different places in each report. See [Sales vs Payment Totals](/docs/sales-vs-payment-totals).

**Some of my orders are missing from the report. Why?**
>Sales channels marked as test channels are left out of the Sales Report. Also check the Market, Sales channel and Location filters. Each market is shown separately in its own currency.

**I see a yellow message about unresolved entries. What does it mean?**
>Some sales could not yet be placed in a market or currency, so they are not in the totals. Contact support with the date shown in the message, and they can fix it.

---

## What's Next

You can now read your sales by day, month and year, and find your busiest days. Next, learn why your sales and payment totals are different, and which one to trust for what, in [Sales vs Payment Totals](/docs/sales-vs-payment-totals).
