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
| Document | Layout ID | Inputs and requirements |
|---|---|---|
| Bank statement CSV | bank_csv.v1 | Recognised date, debit, credit and running-balance columns. Supply opening and currency when needed. |
| OFX / QFX | ofx.v1 | OFX content with currency and ledger balance. Supply the opening balance. |
| SWIFT MT940 | mt940.v1 | MT940 text, commonly .sta, .mt940 or .txt. Opening and closing come from balance records. |
| Bank statement PDF or scan | bank_statement_pdf.v1 | .pdf, .png, .jpg, .jpeg. Scans need OCR. |
| Stripe balance export | stripe_balance.v1 | Recognised Stripe balance table and payout evidence. |
| Razorpay settlement | razorpay_settlement.v1 | Recognised settlement table with settlement arithmetic. |
| PayPal activity | paypal_activity.v1 | Public export layout, exercised on synthetic examples. |
| Wise statement | wise_statement.v1 | Public export layout, exercised on synthetic examples. |
| Form 26AS | tds_26as.v1 | Recognised Part A TDS table and proof checks. |
| AIS | ais.v1 | Recognised statement layout. |
| FIRA | fira.v1 | Recognised remittance advice table. |
| Form 1099-B | form_1099b.v1 | Public export layout, exercised on synthetic examples. Other 1099 forms have no provider. |
| Trial balance | trial_balance.v1 | Recognised debit and credit ledger table. |
| Excel workpaper | The 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
dmyormdywhen 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/healthandGET /v1/formatswhen using the service.
Check a new export
- Match the document and provider to a row in the matrix. For example, start with a balance export for Stripe.
- Preserve the original headers, amounts, and totals. For Excel, check that the workbook contains one table that matches a supported layout.
- Run one representative file with verified context. Read
file.layout_versionon release. For a refusal, use the code and message to decide whether to change the export or the run options. - 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.
Use the browser workspace
Upload bank statements, tax documents and payment settlements, review the source checks, and export the verified JSON in Open Books.
Bank statements
Integrate bank statement extraction, supply verified opening balances and dates, and use running-balance assertions before posting transactions.