Receipts

Export receipt data as Excel (XLSX)

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.

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

Request body

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

issuerstring

Issuer / merchant name

recipientstring

Recipient name (if present on the document)

datestring

Document date (ISO format)

timestring

Document time (HH:mm or HH:mm:ss)

totalAmountnumber

Total amount (gross)

netAmountnumber

Net amount (before VAT, if stated)

currencystring

Currency code (ISO 4217)

paymentMethod'cash' | 'card' | 'debit_card' | 'credit_card' | 'contactless' | 'online' | 'invoice' | 'other'

Payment method

referenceNumberstring

Reference number (receipt number, ticket number, booking reference, etc.)

tipAmountnumber

Tip amount (e.g. restaurant)

taxNumberstring

Tax number of the issuer (Steuernummer)

vatIdstring

VAT ID of the issuer (USt-IdNr.)

issuerAddressstring

Issuer address (if present)

metadataobject

Additional type-specific metadata (e.g. departure, arrival, seat, parking duration)

languagestring

Detected document language (ISO 639-1)

countrystring

Detected country of origin (ISO 3166-1 alpha-2)

skr03Accountstring

Suggested SKR03 account number for bookkeeping

skr03Descriptionstring

SKR03 account description

skr04Accountstring

Suggested SKR04 account number for bookkeeping

skr04Descriptionstring

SKR04 account description

expenseCategory'travel' | 'transportation' | 'meals_entertainment' | 'office_supplies' | 'fuel' | 'accommodation' | 'parking' | 'communication' | 'other'

General expense category

Example request

[
  {
    "receiptType": "restaurant_bill",
    "issuer": "Deutsche Bahn AG",
    "recipient": "Max Mustermann",
    "date": "2026-04-12",
    "time": "14:35",
    "totalAmount": 50.58,
    "netAmount": 42.5,
    "currency": "EUR",
    "vat": [
      {
        "rate": 19,
        "netAmount": 42.5,
        "vatAmount": 8.08,
        "grossAmount": 50.58
      }
    ],
    "items": [
      {
        "description": "Cappuccino",
        "quantity": 2,
        "unitPrice": 3.5,
        "totalPrice": 7,
        "vatRate": 19
      }
    ],
    "paymentMethod": "card",
    "referenceNumber": "BNR-2026-04-12-001",
    "tipAmount": 5,
    "taxNumber": "27/123/12345",
    "vatId": "DE123456789",
    "issuerAddress": "Musterstraße 1, 12345 Berlin",
    "metadata": {
      "departure": "Berlin Hbf",
      "arrival": "München Hbf",
      "class": "2"
    },
    "language": "de",
    "country": "DE",
    "skr03Description": "Laufende Kfz-Betriebskosten",
    "skr04Description": "Laufende Kfz-Betriebskosten",
    "expenseCategory": "travel"
  }
]

Response

XLSX file

Changes

No recorded changes to this operation across all 1 revision of this API.