# Downloading reports and lists to Excel or PDF

Section: Reports. Address: https://vende.id/docs/laporan/ekspor-excel-dan-pdf?lang=en

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

1. Open the report, for example **Reports → Profit & Loss**.
2. Set the branch, the dates and any other filters until it shows what you want.
3. 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

1. Open the report and set its filters.
2. 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.

1. Open the list.
2. Set the search, the filters and the sorting. The export follows what you are using.
3. Press **Export to Excel**, then press **Export** in the window that appears.
4. The file is made in the background. When it is done, the **Export completed** notification appears in the bell.
5. 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](https://vende.id/docs/pengaturan/cadangan-data?lang=en).
