Downloading reports and lists to Excel or PDF
Download reports as PDFs to print or send, and export reports or lists to Excel to work with them yourself.
Every report can be downloaded as a PDF. Reports and lists can also be exported to Excel when the extra Excel export feature is on for your shop. If the Export to Excel button is missing, contact the Vende team to switch it on.
Reports to PDF
- Open the report, for example Reports → Profit & Loss.
- Set the branch, the dates and any other filters until it shows what you want.
- Press Download PDF.
The PDF is A4 and holds the shop name, the branch, the period and the print time. It holds the same as the screen, following the filters. A long report is split into pages on screen, but the PDF holds all its rows.
Reports to Excel
- Open the report and set its filters.
- Press Export to Excel.
The file downloads at once. This button only appears on reports that support Excel.
Very large reports
Some reports, namely Profit by Item, Stock Movement Summary, Reorder Suggestion and Cost of Goods Sold Proof, can cover a great deal of data. When that happens, the screen shows the message This report is too large to show here instead of the report.
- Press Download PDF or Export to Excel. The file is prepared in the background, then its download link is sent to the bell.
- To see it on screen, narrow the period, the warehouse or other filters.
The PDF of such a large report holds at most 2.000 rows. For a longer report, use Export to Excel.
Lists to Excel
Almost every list has an Export to Excel button, for example the Sales, Expenses, Products and Customers lists.
- Open the list.
- Set the search, the filters and the sorting. The export follows what you are using.
- Press Export to Excel, then press Export in the window that appears.
- The file is made in the background. When it is done, the Export completed notification appears in the bell.
- Press Download .xlsx in that notification.
To export only some rows, filter the list first.
Important: List export files are kept for 7 days, then deleted automatically. Download and save the file before then.
Backing up all data
To keep a copy of all of the shop's data, use Settings → Backup, not one export after another. See Making a data backup.
Supporting reading
Articles on the background and the arithmetic.