Exporting Sales Invoices
You can export sales invoices from the invoices list to an Excel, CSV, or XML file, whether all invoices, the invoices of a specific client, a specific period, or a specific cashier session. This guide explains the export steps, its types, setting up the file data, and the export limit.
Table of Contents
Steps to Export Invoices
- From the main menu, click Sales.
- Click Manage Invoices.
- To export the invoices of a specific client, a specific period, or a specific cashier session, click Advanced Search and select the client or the date, or type the session number in the Pos Shift field, then click Search.
- Click the arrow next to the checkbox at the top of the list and select All Filtered(All Pages) to select all matching invoices, or All (Current Page) to select the invoices of the visible page only.
- Click Actions at the top of the page.
- Select Export.
🛈
Note: The invoices list shows 20 invoices per page, and this number cannot be changed. To export all matching invoices, select All Filtered(All Pages).
Choosing the Export Type
| Export Type | What Is Exported |
|---|---|
| Invoices | Summary data and the total of each invoice. |
| Items | Invoice data with the item details (products and services) of each invoice. |
🛈
Note: When you select Items, you can select the item data to export from the Invoice Fields list.
Setting Up the Export File Data
- Select the columns to export from the Invoice Fields list.
- Select how the data is sorted from the Order By list.
- Select the file type: Excel, CSV, or XML.
- Click Export.
🛈
Warning: The export limit is 5,000 invoices at a time. If the message You can’t export more than 5000 record, Please change filters to match limit. appears, narrow the filters (such as the date range) and export in several batches. To print invoices as PDF files, use Print PDF from Actions, with a limit of 200 invoices at a time; see .
FAQs
Can I export all invoices of a specific client?
Yes; from Advanced Search, select the client and click Search, then select All Filtered(All Pages), and from Actions select Export.
How do I export the invoices of a specific cashier session to Excel?
From Advanced Search, type the session number in the Pos Shift field and click Search, then select All Filtered(All Pages) from the arrow next to the checkbox, and from Actions select Export and set the file type to Excel. You can find the session number in the POS Sessions list.
Why doesn’t the export option appear in the invoices tab inside the session page?
The invoices tab inside the session page is for viewing only, and does not allow selection or bulk actions. To export the session invoices, use the Pos Shift filter in Manage Invoices as in the previous question.
Why are only 20 invoices exported?
Because you selected All (Current Page), and the list shows 20 invoices per page. Select All Filtered(All Pages) to export all matching invoices.
Can I change the number of invoices shown per page?
No, the list shows 20 invoices per page and this number cannot be changed, and it is not needed for export; select All Filtered(All Pages).
I want the invoices as PDF files, not Excel; what do I do?
Export produces Excel, CSV, or XML files only. For PDF, select the invoices then select Print PDF from Actions, with a limit of 200 invoices at a time; if there are more, split them using the date filter.