---
title: "Export receipt data as Excel (XLSX)"
method: POST
path: "/api/receipts/export/xlsx"
tags: ["Receipts"]
---

# Export receipt data as Excel (XLSX)

`POST /api/receipts/export/xlsx`

## Request

- Base URL: `https://api.dokmatiq.com`
- URL: `https://api.dokmatiq.com/api/receipts/export/xlsx`
- Auth: API key in header `X-API-Key`

Accepts a list of extracted ReceiptData objects and returns an XLSX file with formatted columns, auto-filter, and summary row.

Suitable for import into DATEV, Lexware, or other bookkeeping software.

## Request body

- ReceiptData[]
  - `receiptType` 'cash_receipt' | 'restaurant_bill' | 'parking_ticket' | 'train_ticket' | 'flight_ticket' | 'bus_ticket' | 'taxi_receipt' | 'hotel_invoice' | 'fuel_receipt' | 'invoice' | 'other': Type of receipt/document
  - `issuer` string: Issuer / merchant name
  - `recipient` string: Recipient name (if present on the document)
  - `date` string: Document date (ISO format)
  - `time` string: Document time (HH:mm or HH:mm:ss)
  - `totalAmount` number: Total amount (gross)
  - `netAmount` number: Net amount (before VAT, if stated)
  - `currency` string: Currency code (ISO 4217)
  - `vat` VatBreakdown[]: VAT breakdown by rate
    - `rate` number: VAT rate in percent
    - `netAmount` number: Net amount at this rate
    - `vatAmount` number: VAT amount at this rate
    - `grossAmount` number: Gross amount at this rate
  - `items` LineItem[]: Individual line items (if present)
    - `description` string: Item description
    - `quantity` number: Quantity
    - `unitPrice` number: Unit price
    - `totalPrice` number: Total price for this item
    - `vatRate` number: VAT rate in percent (if stated per item)
  - `paymentMethod` 'cash' | 'card' | 'debit_card' | 'credit_card' | 'contactless' | 'online' | 'invoice' | 'other': Payment method
  - `referenceNumber` string: Reference number (receipt number, ticket number, booking reference, etc.)
  - `tipAmount` number: Tip amount (e.g. restaurant)
  - `taxNumber` string: Tax number of the issuer (Steuernummer)
  - `vatId` string: VAT ID of the issuer (USt-IdNr.)
  - `issuerAddress` string: Issuer address (if present)
  - `metadata` object: Additional type-specific metadata (e.g. departure, arrival, seat, parking duration)
  - `language` string: Detected document language (ISO 639-1)
  - `country` string: Detected country of origin (ISO 3166-1 alpha-2)
  - `skr03Account` string: Suggested SKR03 account number for bookkeeping
  - `skr03Description` string: SKR03 account description
  - `skr04Account` string: Suggested SKR04 account number for bookkeeping
  - `skr04Description` string: SKR04 account description
  - `expenseCategory` 'travel' | 'transportation' | 'meals_entertainment' | 'office_supplies' | 'fuel' | 'accommodation' | 'parking' | 'communication' | 'other': General expense category

## Response `200`

XLSX file

## Other responses

- `400`: No data provided

---

[API](https://skmtc.dev/dokmatiq/apis/docgen-api.md) · [All operations](https://skmtc.dev/dokmatiq/apis/docgen-api/llms.txt) · [OpenAPI document](https://skmtc.dev/dokmatiq/apis/docgen-api/revisions/3fa1a922764d?raw)