---
title: "How to: Generate invoice XLS/CSV export"
description: ""
url: https://help.qargo.com/us/articles/211159-how-to-generate-invoice-xls-csv-export
locale: us
updated: 2024-10-24
---

# How to: Generate invoice XLS/CSV export

How to: Generate invoice XLS/CSV export

::embed{src="https://www.loom.com/embed/7aa8440d53744c2aadbd6b0b07cb3566"}

1.  Configure the Excel template and layout for the invoice:

    -   Navigate to **Configuration > Templates > File exports and downloads**.

        ![](https://help.qargo.com/media/1b2930630357-image.png)

    -   Create a default invoice XLS (charge export) and define the fields:\
        Define the columns to show in the export, e.g.:

        -   First column: Invoice name
        -   Second column: Order name
        -   Additional columns: Charge description, amount excluding tax, amount including tax, and tax separately.
        -   Save the template.

        ![](https://help.qargo.com/media/cf5a34ad0dee-image.png)

2.  Set up the task to generate the invoice XLS file:\
    ​

    -   Make sure the **invoice breakdown document type** is activated under **Configuration > Documents > Invoices**

        ![](https://help.qargo.com/media/b7c582e23bd7-image.png)

    -   Go to **Configuration > Tasks > Invoices**.
    -   Create a **Generate invoice XLS** task (generate document task).

        ![](https://help.qargo.com/media/f2456bc78814-image.png)

3.  Configure the XLS task:

    -   Select **Invoice breakdown** as the document type.
    -   Choose **Generate as CSV** and select the default invoice template created earlier.
    -   Save the task and test it by generating an invoice.

        ![](https://help.qargo.com/media/7693df174292-image.png)

4.  Attach the invoice XLS when sending the invoice:

    -   Go to **Tasks > Send invoice**.
    -   Replace or add the invoice PDF document type with the **Invoice breakdown document type**.
    -   Save and test sending the invoice with the attached Excel file.

![](https://help.qargo.com/media/5ecdc9634b1a-image.png)


## Related articles

- [Video - How to create orders in bulk via the customer portal?](https://help.qargo.com/us/articles/892733-video-how-to-create-orders-in-bulk-via-the-customer-portal.md)
- [Configuration: generate documents](https://help.qargo.com/us/articles/133826-configuration-generate-documents.md)
- [Customer portal — Excel and CSV order export — what, why and how.](https://help.qargo.com/us/articles/764910-customer-portal-excel-and-csv-order-export-what-why-and-how.md)
- [Customer portal: How to create orders in bulk from an Excel or CSV file](https://help.qargo.com/us/articles/879687-customer-portal-how-to-create-orders-in-bulk-from-an-excel-or-csv-file.md)
- [Tasks - Contact tasks: Viewing and sending documents](https://help.qargo.com/us/articles/596071-tasks-contact-tasks-viewing-and-sending-documents.md)
