Skip to main content

Exporting your data as a CSV file

Export Dext items as CSV from the Costs/Sales inbox or Archive. Choose your CSV format, use Export all, and fix the “Please set total amount” error quickly.

Updated yesterday

You can export documents from Dext as a CSV (or PDF/ZIP) to share, analyse, or upload to your accounting software.


Before you export

  • Use advanced search and filters to refine your selection.

  • You can export from the Costs or Sales inbox and from the Archive.


Where you can export items

From the Costs or Sales inbox

  • Export selected items: Use the checkboxes, then go to Tools > Export.

Costs inbox showing selected items, with the Tools menu open and the Export option highlighted.
  • Export everything in the inbox: Leave all items unselected, open Tools, and choose Export all.

Costs inbox with no items selected, showing the Tools menu open and the Export all option available.

From the Archive

  • Export selected items: Select the documents and click Export.

Archive tab in the Costs inbox with items selected and the Export button visible at the top of the list.
  • Export everything in the Archive: Click Export all.

Archive tab in the Costs inbox with no items selected and the Export all button enabled.

How to export items as a CSV

You can start a CSV export from either the inbox or the Archive. Once the export window is open, follow these steps:

  1. Select the CSV tab.

  2. Choose your CSV format from the dropdown.

Tip: Admin users can create a custom CSV format in Business settings > Exports and then select it in the export window. Learn more here.

3. Choose whether to move exported items to the Archive.

Export items window with the CSV tab selected, showing the CSV format dropdown and the option to archive items after export.

4. Click Export, then click Download when the file is ready.

CSV file download screen showing the exported file name and a Download button after the export is complete.

Troubleshooting CSV exports

Error: “Please set total amount for each of the items in the export”

This means there’s at least one item in your selection with no total amount (not even 0).

Export items window displaying an error message prompting the user to set a total amount for each item in the export.

To fix it:

  1. Go to Costs > Inbox or Costs > Archive.

  2. Click the Total column to sort by descending total amount.

Archive tab in the Costs inbox sorted by the Total column to help identify items with missing amounts.

3. Find the item with no total, open it, and enter a value (0 is allowed).

Item details page showing the Total amount field highlighted with a message prompting the user to complete the field.

4. Click outside the field to save the change.

5. Re‑run your CSV export.

Did this answer your question?