InvoiceDelivery

Export invoices to a spreadsheet

Exports invoices to an XLSX file.

  • Deprecated: use POST /v1/companies/{company_id}/invoices/exports, which produces the same file.
  • Difference: the selection criteria are grouped there under filters instead of being top-level fields.
  • Selection: the invoices named in invoice_ids, or, when that list is absent, the ones matching the filters.
  • Format: SUMMARY gives one row per invoice with aggregated totals, ITEMS one row per invoice line.

Retires on 9 December 2026. See the migration guide for what moved where and what changes when you switch.

post/v1/invoices/export/excel

Request

  • Base URL: https://app.beel.es/api
  • URL: https://app.beel.es/api/v1/invoices/export/excel
  • Auth: HTTP bearer

Request body

invoice_idsUUID[]

List of specific invoice IDs to export. If provided, filters are ignored.

format'SUMMARY' | 'ITEMS'

Export format.

  • SUMMARY: One row per invoice with totals (default)
  • ITEMS: One row per invoice line item
status'SCHEDULED' | 'DRAFT' | 'ISSUED' | 'SENT' | 'PAID' | 'OVERDUE' | 'RECTIFIED' | 'VOIDED' | 'CONVERTED' | 'ACTIVE' | 'EXPIRED'
  • SCHEDULED: Scheduled invoice to be issued automatically on a future date
  • DRAFT: Draft invoice not sent yet (modifiable)
  • ISSUED: Finalized invoice with definitive number but not sent
  • SENT: Invoice sent to customer
  • PAID: Invoice paid
  • OVERDUE: Unpaid invoice in ISSUED or SENT status, with a total above zero, whose due_date is earlier than the current day in Europe/Madrid. A periodic process sets it, so it can lag behind the due date. It changes to PAID when the invoice is paid.
  • RECTIFIED: Partially corrected invoice (one or more PARTIAL corrective invoices)
  • VOIDED: Cancelled invoice. Reached either through a direct void request or through a TOTAL corrective invoice; void_cause tells the two apart.
  • CONVERTED: Proforma converted into an invoice (terminal; the proforma survives as the record of the accepted quote, linked to the created invoice)
  • ACTIVE: Active proforma. The single working state of a proforma (non-fiscal document): born numbered (PRO-...) and editable, never reaching the fiscal statuses. It transitions to CONVERTED when turned into an invoice, or to VOIDED when the offer is rejected/withdrawn (POST /v1/invoices/{invoice_id}/void).
  • EXPIRED: Proforma whose offer validity (valid_until) has passed. Derived on read and never stored; the proforma stays convertible and editable.
type'STANDARD' | 'CORRECTIVE' | 'SIMPLIFIED' | 'PROFORMA'
  • STANDARD: Standard invoice
  • CORRECTIVE: Corrects or cancels a previous invoice
  • SIMPLIFIED: Simplified invoice (ticket), for a recipient that is not identified. BeeL. requires a STANDARD invoice when the recipient is identified, at any amount: a SIMPLIFIED invoice whose recipient carries an nif or alternative_id is rejected with SIMPLIFIED_INVOICE_FORBIDS_IDENTIFIED_RECIPIENT. The only amount BeeL enforces is a cap of 3,000€ VAT included (SIMPLIFIED_INVOICE_EXCEEDS_LEGAL_LIMIT). The general limit of RD 1619/2012 is 400€ (art. 4.1.a); up to 3,000€ applies only to the activities listed in art. 4.2. BeeL does not check which activity the issuer carries out.
  • PROFORMA: Commercial document (formal quote) with no fiscal validity. Never enters VeriFactu (no QR, no AEAT submission): verifactu.enabled is always false, whatever the company's regime. Requires full recipient data, like STANDARD. Cannot be corrective nor reference a rectified invoice.
date_fromstring date

Issue date from (YYYY-MM-DD)

date_tostring date

Issue date to (YYYY-MM-DD)

customer_idstring uuid

Universally Unique Identifier (UUID v4)

recipient_namestring

Filter by recipient name (partial match)

recipient_nifstring

Filter by recipient NIF (partial match)

series_codestring

Filter by series code

Example request

{
  "invoice_ids": [
    "550e8400-e29b-41d4-a716-446655440000"
  ],
  "customer_id": "550e8400-e29b-41d4-a716-446655440000"
}

Response

Excel file generated successfully

Changes

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