Skip to main content
Export invoice data as CSV or Excel files.

​
Single Invoice Export

​
Endpoint

GET /api/invoices/:id/export

​
Query Parameters

ParameterTypeDefaultDescription
formatstringcsvExport format: csv or xlsx
includeLineItemsbooleantrueInclude line item details

​
Example

# Export as CSV
curl -X GET "https://vatextract.com/api/invoices/inv_abc123/export?format=csv" \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -o invoice.csv

# Export as Excel
curl -X GET "https://vatextract.com/api/invoices/inv_abc123/export?format=xlsx" \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -o invoice.xlsx

​
Response

Returns the file as a download with appropriate headers: 
Content-Type: text/csv
Content-Disposition: attachment; filename="invoice-INV-2024-001.csv"

​
Bulk Export

Export multiple invoices at once.

​
Endpoint

GET /api/invoices/export

​
Query Parameters

ParameterTypeDefaultDescription
formatstringcsvExport format: csv or xlsx
idsstring-Comma-separated invoice IDs
supplierstring-Filter by supplier
dateFromstring-Invoice date range start
dateTostring-Invoice date range end

​
Example

# Export specific invoices
curl -X GET "https://vatextract.com/api/invoices/export?format=xlsx&ids=inv_abc,inv_def" \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -o invoices.xlsx

# Export all invoices from a date range
curl -X GET "https://vatextract.com/api/invoices/export?dateFrom=2024-01-01&dateTo=2024-01-31" \
  -H "Authorization: Bearer YOUR_TOKEN" \
  -o january-invoices.csv

​
Export Formats

​
CSV Format

  • One row per invoice (bulk) or per line item (single)
  • UTF-8 encoded with BOM for Excel compatibility
  • Comma-separated values

​
Excel Format (XLSX)

Single invoice:
  • Sheet 1: Invoice details
  • Sheet 2: Line items
Bulk export:
  • Single sheet with one row per invoice
  • No line items included

​
Exported Fields

FieldCSV ColumnExcel Column
Invoice Numberinvoice_numberInvoice Number
Invoice Dateinvoice_dateInvoice Date
Supplier Namesupplier_nameSupplier Name
Supplier VATsupplier_vatSupplier VAT
Net Amountnet_amountNet Amount
VAT Amountvat_amountVAT Amount
Total Amounttotal_amountTotal Amount
CurrencycurrencyCurrency
VAT Statusvat_statusVAT Status

​
Error Responses

StatusErrorDescription
400No invoices foundNo invoices match the criteria
401UnauthorizedInvalid/missing auth token