# Export / Invoices

# ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) Getting started

In this article, you can learn about **export / invoices** functionality, which will allow you to export list of orders with their basic invoice and order information. In order to access this module you have to have **BOK supervisors**, **MC business admin,** **Administrator**, **Super administrator**, or **Root** group.

<span class="title">You can find the example export file under the URL:</span>

[https://knowledge.tauceti-digital.com/invoice\_report\_example.xlsx](http://knowledge.tauceti-digital.com/invoice_report_example.xlsx "http://knowledge.tauceti-digital.com/invoice_report_example.xlsx")

<table id="bkmrk-%C2%A0-visualization-of-t" style="margin-right: auto; margin-left: auto; height: auto; width: 731px;"><tbody><tr style="height: auto;"><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; height: auto; width: 719.233px;">[![POWERPNT_vZRn4iJb9Y.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/scaled-1680-/powerpnt-vzrn4ijb9y.png)](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/powerpnt-vzrn4ijb9y.png)</td></tr><tr style="height: 22px;"><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; height: 22px; width: 719.233px;"><span class="wysiwyg-font-size-medium"> </span><span class="wysiwyg-font-size-medium">*Visualization of the exported invoices list* </span></td></tr></tbody></table>

To open the invoices export view, in the admin panel, navigate to:  
***Import / export &gt; Export / Invoices***

<table id="bkmrk-%C2%A0-visualization-of-t-1" style="margin-right: auto; margin-left: auto; height: auto; width: 774px;"><tbody><tr style="height: auto;"><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; height: auto; width: 762.233px;">[![POWERPNT_taAYCaCENe.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/scaled-1680-/powerpnt-taaycacene.png)](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/powerpnt-taaycacene.png)</td></tr><tr style="height: 22px;"><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; height: 22px; width: 762.233px;"><span class="wysiwyg-font-size-medium"> </span><span class="wysiwyg-font-size-medium">*Visualization of the export / orders list module in the administrator panel*</span></td></tr></tbody></table>

Table of contents:

1. [Export / Invoices section](https://knowledge.tauceti-digital.com/link/97#bkmrk-export-%2F-orders-list)
2. [Exporting invoices to the xlsx](https://knowledge.tauceti-digital.com/link/97#bkmrk-exporting-orders-to-)

---

# ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png) <span class="title">Export / Invoices</span> section

The **Export / Invoices** section allows to filter the exported data. Below you will find a description of possible filters.

<table id="bkmrk-%C2%A0%C2%A0%C2%A0-%C2%A0-visualization-" style="margin-right: auto; margin-left: auto; width: 717px;"><tbody><tr><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; width: 705.233px;">[![POWERPNT_vzyosdwb6G.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/scaled-1680-/powerpnt-vzyosdwb6g.png)](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/powerpnt-vzyosdwb6g.png)</td></tr><tr><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; width: 705.233px;"><span class="wysiwyg-font-size-medium">  </span><span class="wysiwyg-font-size-medium"> </span><span class="wysiwyg-font-size-medium"> *Visualization of the export / orders list section* </span></td></tr></tbody></table>

- **Order dates** - A range of dates between which the orders should be exported.
- **Include orders** - A dropdown menu that defines what type of orders should be exported. There are three possible options: 
    - **With invoices** - Exports only orders that contain invoices
    - **Without invoices** - Exports only orders that do not have an invoice
    - **All** - Exports all orders
- **Anonymise personal data** - A switch that defines if the fields Receiver data and E-mail should be anonymised in the exported xlsx file.
- **Order and Invoices numbers only** - A switch that defines if only Order number and Invoice number should be exported.

With the desired options chosen, you can export the xlsx file using the **Apply filters and export** button.

---

# ![Screenshot_2020-04-29_at_19.12.41.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2024-11/ORWscreenshot-2020-04-29-at-19-12-41-png.png)<span class="title"> Exporting invoices to the xlsx  
</span>

<span class="title">By pressing the **Apply filters and export** button shown in the [Export / Invoices section](https://knowledge.tauceti-digital.com/link/97#bkmrk-export-%2F-orders-list) chapter you are able to export all the filtered orders to the xlsx file and download it.   
</span>

<span class="title">You can find the example export file under the URL:</span>

[https://knowledge.tauceti-digital.com/invoice\_report\_example.xlsx](https://knowledge.tauceti-digital.com/invoice_report_example.xlsx)

<table id="bkmrk-%C2%A0%C2%A0%C2%A0-%C2%A0-visualization--1" style="margin-right: auto; margin-left: auto; width: 725px;"><tbody><tr><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; width: 713.233px;">[![POWERPNT_vZRn4iJb9Y.png](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/scaled-1680-/powerpnt-vzrn4ijb9y.png)](https://knowledge.tauceti-digital.com/uploads/images/gallery/2025-05/powerpnt-vzrn4ijb9y.png)</td></tr><tr><td class="wysiwyg-text-align-center" style="text-align: center; vertical-align: middle; width: 713.233px;"><span class="wysiwyg-font-size-medium">  </span><span class="wysiwyg-font-size-medium"> </span><span class="wysiwyg-font-size-medium"> *Visualization of the exported orders=s* </span></td></tr></tbody></table>

Xlsx file contains the following fields:

- **Invoice number** - Number of the invoice (if exists)
- **Order number** - Order number of the exported row
- **Receiver data** - Customers personal information. This column contains its Name, Surname, Street number, building number, flat number, postal code and city name.
- **Emai**l - Customers e-mail address
- **Order date** - Date when the order was placed
- **Total price inc VAT** - Order value with VAT
- **VAT** - Percentage VAT rate
- **Price without VAT** - Order value without VAT
- **Order status** - Current status of the order
- **Payment Status** - Current status of the payment. In case of COD orders the COD value will be displayed
- **Delivery mode** - Type of delivery used
- **Payment mode** - Type of payment used.