Skip to main content
Qargo

How to: Generate invoice XLS/CSV export

How to: Generate invoice XLS/CSV export

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

    • Navigate to Configuration > Templates > File exports and downloads.

    • 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.

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

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

    • Go to Configuration > Tasks > Invoices.

    • Create a Generate invoice XLS task (generate document task).

  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.

  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.