Before You Start

  • You need access to the report or list you want to export. If a report is missing from your Reports menu, see Giving Your Staff Access to Reports.
  • Exports open in Microsoft Excel, Google Sheets or Apple Numbers. Any one of them is fine.
  • Know which dates you want. A report's export starts with the period the report is showing. To change it, see Choosing the Period and Filters.
  • If you used this guide before: it now covers every export, from reports and from lists. What each report's file contains is now explained in that report's own article.

What Exporting Means

To export is to save your figures as a spreadsheet file on your computer. EasyBiz makes the file for you in XLSX, the normal Excel format. Each file is one workbook, which is one Excel file with one or more tabs called sheets. You can export from five reports and from the order, payment, contact and job lists. Without exporting, you would copy numbers from the screen by hand, and one wrong figure goes straight into your accounts.


What You Can Export

There are two kinds of export. A report export gives you totals for a period, such as a month of sales. A list export gives you one row for each order, payment, contact or job on a list.

Reports

A report's Export button opens a window where you choose the dates again, and often the sales channels. A sales channel is any place you take orders, such as an outlet, your online store or your mobile app.

Report Where to find it What the export window asks Read more
Sales Reports › Sales Date range, sales channels, and whether to add every order and item Reading the Sales Report
Payments Reports › Payments Date range, sales channels, and whether to add every payment. The file covers one market only Reading the Payments Report
Contacts Reports › Contacts Date range, sales channels, services, and whether to add your full customer list Reading the Contacts Report
Credits Reports › Credits Activity in a period, or the balances held at the end of one day Reading the Credits Report
Deals Reports › Deals Date range only Reading the Deals Report
E-Invoice (Malaysia only) Reports › E-Invoice Company and month, for the MyInvois portal Exporting Malaysia e-Invoices for MyInvois

The Production, Notifications and Active Users reports have no Export button.

Lists

A list's Export button uses the filters you already set on that list, such as a status, a sales channel or a search. The window asks which dates you want.

List Where to find it Good to know Read more
Orders Sales › Orders Pick orders by order date or sale date. The file has the same columns as your Orders list Finding and Working on an Order
Payments Sales › Payments Up to 92 days and 5,000 payments at a time
Receivables Sales › Receivables The orders customers still owe you money on. Up to 92 days and 5,000 orders at a time Tracking Unpaid Bills in Receivables
Contacts Sales › Contacts Up to 5,000 contacts at a time Your Customer List: Find, Filter and Export Contacts
Jobs Logistic › Jobs Up to 92 days and 5,000 jobs at a time

The daily sales file for your shopping mall is not an export. EasyBiz sends it by itself every day, as shown in Sending Daily Sales to Your Mall.


Export a Report

Every report export works the same way. The Sales Report is the example here.

  1. In the menu bar at the top, click Reports .
  2. Click Sales .

The Reports menu open in the menu bar at the top, with Reports and Sales marked

  1. Choose the period you want, such as Monthly and the month.
  2. At the top right, click Export .

The Sales Report page set to Monthly, with the Export button at the top right marked

The Export Sales Report window opens. It says Generate an XLSX sales report. You can track progress on the Downloads page.

  1. Check the Date range. It starts with the period the report was showing. Change it here if you need different dates.
  2. Choose the options in the window. On the Sales Report, these are Sales Channels and the Include entry-level details (Entries + Line Items sheets) tick box. Each report's own article explains its options.
  3. Read the grey box under the options. It tells you which sheets the file will have.
  4. Click Export .

The Export Sales Report window open over the Sales Report, with a one-month Date range, All sales channels and the entry-level details box ticked

The window closes and EasyBiz starts making your file. The Export button now shows Exporting... or a count such as 1200 entries... while it works.

  1. When the file is ready, a small box opens under the button saying Export ready. Click Download .

The Export ready box under the Export button, with the Download button marked


Export a List

  1. Open the list, for example Sales › Orders.
  2. Set the filters you want on the list, for example one sales channel.
  3. Click Export .

Sales › Orders showing one sales channel, with the Sales channel filter and the Export button marked

  1. In the window, choose the dates. On the Orders list, first choose under Pick orders by: Order date (the day the order was made) or Sale date (the day it counts in your Sales Report and GST).
  2. Click Export .

The Export orders window in front of Sales › Orders, with the Pick orders by choice (Order date or Sale date) marked and a one-month Date range selected

The file arrives the same way as a report: Export ready under the button, and a new row on your Downloads page.


Where the File Goes in Downloads

You don't have to wait on the page. Every export you make is also kept on your Downloads page in EasyBiz. You can leave, serve a customer, and collect the file later.

  1. At the top right, click your profile picture or initials.
  2. Click Downloads .

The profile picture with your initials at the top right and the profile menu open, with the initials and Downloads marked

The page lists your exports, newest first. Each row shows:

  • Type: what you exported, such as Sales Report, Payment Report, Contact Report, Credit Report, Credit Balances, Deal Export, Order Export or Job Export.
  • Status: Pending while it waits to start, Processing while EasyBiz makes it, Ready when you can download it, or Failed if it couldn't be made.
  • Requested: the date and time you asked for it, and who asked.
  • Size: how big the file is.
  1. On a Ready row, click Download .

The Downloads page with a Ready Sales Report row marked, showing its requested time, file size and Download button

Your browser saves the file to your computer, usually in its own Downloads folder. That folder is on your computer and is a different place from the Downloads page in EasyBiz.


Open It in Excel

  1. Open your computer's Downloads folder.
  2. Double-click the file. Its name starts with what you exported and the dates, for example sales-Sep-2026-2026-09-30.xlsx.
  3. Excel opens the workbook on its first sheet.
  4. Click the tabs along the bottom to see the other sheets.

Most report files start with a Summary sheet of totals. A Deals file has one Deals sheet. A list file has one sheet, named after the list, such as Orders or Payments.

If Excel shows a yellow bar saying Protected View, click Enable Editing to sort or add your own notes. No Excel? Upload the file to Google Sheets, or open it in Numbers on a Mac.


Example: CleanFast Laundry Sends September to Its Accountant

CleanFast Laundry has POS shops in Tampines and Jurong and an Online Store. Each month, the owner sends her accountant the month's sales and the orders still unpaid.

  1. On 1 October, she clicks Reports , then Sales .
  2. She clicks Monthly and moves to September 2026.
  3. She clicks Export . The Date range already shows 1 to 30 September.
  4. She leaves All sales channels, so both shops and the Online Store are included.
  5. Her accountant wants every order, so she ticks Include entry-level details (Entries + Line Items sheets), then clicks Export .
  6. She opens Sales › Receivables, keeps the list as it is and clicks Export .
  7. She helps a customer at the counter. Later, she opens Downloads from her profile menu. Both rows say Ready. She downloads each one.
  8. She checks the Summary sheet matches the total she saw on screen, and emails both files to her accountant.

The whole task takes a few minutes. Nobody types a single number by hand.


FAQs

How long are my files kept?

Your Downloads page shows your 50 most recent exports. When you make more, the oldest ones drop off the list. If you need an old file again, export the same dates again. The figures come from your records, so you get the same report.

Why is my export still processing?

Big exports take longer. A full year, or a month with every order and item added, can take a few minutes. You can close the page while it works. The Downloads page updates by itself, so check back in a few minutes. If it says Failed, point at Error to see why, then export again.

How many days can I export at once?

A report covers up to one year at a time. When you add every order, payment or customer, the limit is about three months (92 days). The order, payment, receivables and job lists export up to 92 days at a time. The window shows a red message when your dates are too long, so export one quarter at a time instead.

Why can't my staff see the file I exported?

Each person's Downloads page only shows the exports they made themselves. This keeps your figures private. To share a file, download it and send it, or let the staff member export it with their own access.

Why doesn't my file match the screen exactly?

A report's file covers the dates and options you picked in the export window, which may differ from the screen. Some page filters also go into the file, such as the Sales Report's market and location. Each report's article lists what carries over. For why sales and payment totals differ, see Why Sales and Payment Totals Differ.

My Receivables file shows as Order Export. Is that right?

Yes. The Receivables list is made from your orders, so its file is listed as Order Export on the Downloads page. It contains only the orders on your Receivables list.

How do I export my orders with their notes?

Open Sales › Orders and click Export . Under Pick orders by, choose Order date or Sale date, then choose the Date range. You can export up to 92 days and 5,000 orders, or 366 days and 2,000 orders when the list shows one customer. The file has the same columns as your Orders list. To get each order's note, for example "Customer wants extra starch", add the Order Note column to your Orders list first. See Finding and Working on an Order.


What's Next

Now that you can take your figures out of EasyBiz, learn what they mean. Continue to Reading the Sales Report.