Build a receipt spreadsheet
build_receipt_spreadsheetTurn receipts you have read into an Excel (.xlsx), CSV, Xero or QuickBooks import file, with VAT split into one column per rate. Returns totals per currency and VAT rate, warnings where net + VAT doesn't match the total, and a download link valid for 24 hours. Up to 200 receipts per call.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | xlsx (Excel), csv, xero (bank statement CSV) or quickbooks (bank upload CSV) | xlsx |
| csvStyle | No | For csv only: standard = comma-separated with dot decimals; european = semicolons with comma decimals (Excel in most EU countries) | standard |
| receipts | Yes | The receipts you have read, one entry per receipt (1 to 200). Copy amounts as printed; never guess a VAT rate | |
| totalsCurrency | No | Also convert every total to this currency at the ECB rate of the receipt date, e.g. EUR | |
| includeLineItems | No | xlsx: add a Line items sheet; csv: one row per line item |