Skip to Content
Open Books for developers

Supported formats and layouts

Find supported CSV, OFX, MT940, PDF, OCR and Excel formats, with layout identifiers and the requirements for each financial document.

An extension describes the container, such as .csv or .xlsx. A layout describes the document inside it, such as a bank statement or a Stripe balance report. Open Books uses file contents and extension rules to detect the layout. Check file.layout_version on a release when routing documents in your application.

Format matrix

DocumentLayout IDInputs and requirements
Bank statement CSVbank_csv.v1Recognised date, debit, credit and running-balance columns. Supply opening and currency when needed.
OFX / QFXofx.v1OFX content with currency and ledger balance. Supply the opening balance.
SWIFT MT940mt940.v1MT940 text, commonly .sta, .mt940 or .txt. Opening and closing come from balance records.
Bank statement PDF or scanbank_statement_pdf.v1.pdf, .png, .jpg, .jpeg. Scans need OCR.
Stripe balance exportstripe_balance.v1Recognised Stripe balance table and payout evidence.
Razorpay settlementrazorpay_settlement.v1Recognised settlement table with settlement arithmetic.
PayPal activitypaypal_activity.v1Public export layout, exercised on synthetic examples.
Wise statementwise_statement.v1Public export layout, exercised on synthetic examples.
Form 26AStds_26as.v1Recognised Part A TDS table and proof checks.
AISais.v1Recognised statement layout.
FIRAfira.v1Recognised remittance advice table.
Form 1099-Bform_1099b.v1Public export layout, exercised on synthetic examples. Other 1099 forms have no provider.
Trial balancetrial_balance.v1Recognised debit and credit ledger table.
Excel workpaperThe matching table's layout ID.xlsx with exactly one matching sheet. Formula-only evidence is insufficient.

Input limits

  • Maximum file size is 20 MiB in the engine. A hosting proxy may impose a smaller request limit.
  • Keep one supported source document per file. A workbook with multiple matching sheets is ambiguous.
  • Supply dmy or mdy when date order is known but the dates are ambiguous. The bank CSV parser defaults to day-first where it cannot infer order. PayPal and Form 1099-B can require an explicit order.
  • Inspect live engine capabilities through GET /v1/health and GET /v1/formats when using the service.

Check a new export

  1. Match the document and provider to a row in the matrix. For example, start with a balance export for Stripe.
  2. Preserve the original headers, amounts, and totals. For Excel, check that the workbook contains one table that matches a supported layout.
  3. Run one representative file with verified context. Read file.layout_version on release. For a refusal, use the code and message to decide whether to change the export or the run options.
  4. Test a range of statement periods and layout variations before scheduling a recurring import, especially for layouts exercised only on synthetic data.

UNKNOWN_LAYOUT indicates that no available provider recognized the input. PARSE_ERROR can occur after a layout is recognized if required fields are missing or ambiguous. See refusal handling for recovery.

View this page as Markdown