Turn a Norma 43 (Cuaderno 43) statement into a bank statement CSV that Xero or QuickBooks Online import.

target: xero (precoded statement: *Date, *Amount, Payee, Description, Reference) or quickbooks (3 columns: Date, Description, Amount). Amounts are signed (abono +, cargo -). date_style: mdy | dmy | iso (default mdy for QuickBooks, dmy for Xero). account: last digits of one bank account when the file holds several.

Turn a bank statement (Norma 43, the bank's Excel/CSV export, or a movements list) into journal entries.

One entry per movement: abono -> Debe bank / Haber counterpart; cargo -> Debe counterpart / Haber bank. The counterpart comes from the first matching rule; with no match it goes to suspense_account (default 555 'partidas pendientes de aplicación', padded to the bank account length) and the movement is listed in unmatched, so nothing is guessed.

Args: bank_account: The 572 subaccount of the bank, e.g. "57200001" (for QuickBooks/Xero: that program's bank account name or code, and suspense_account is then required). target_format: csv (default) | a3 | contaplus_csv | contaplus_ascii | contasol | quickbooks_iif | quickbooks_csv | xero_csv. content / content_base64: The .n43 file (base64 for CP850/Latin-1 bytes), or the bank's CSV export (Excel saved as CSV: a header row with fecha + importe, or cargo + abono, and concepto). movements: Instead of a file, [{"date": "2026-03-05", "amount": "-121.00", "text": "IBERDROLA"}] for statements read from Excel or PDF (+ money in, - money out). open_items: Pending invoices to settle FIRST, before rules: [{"account": "43000012", "amount": "1210.00", "reference": "F-2026-031", "name": "Talleres Ruiz", "date": "2026-02-28"}]. Signed as the bank sees it (+ cobro de cliente, - pago a proveedor). A movement is booked against the customer/supplier subaccount only on the same amount AND a unique reference or name in the bank text (or a unique amount within window_days). Ties are listed in open_items.ambiguous and never guessed. invoices_to_journal returns these items ready to pass here. rules: Ordered list, first match wins. Each: {"account": "62800000", "contains": ["IBERDROLA"] or "regex": "...", "common_concept": "03" (AEB concept, e.g. 03 recibos, 04 transferencias, 12 comisiones), "direction": "cargo"|"abono", "concept": optional fixed text}. Text matching is case-insensitive over the movement description (own concept + record-23 texts). bank_accounts: For files with several bank accounts: {IBAN or last digits: "57200002"}. use_value_date: Date entries by value date instead of operation date. account_digits / account_split: Resize every subaccount (see convert_journal). start_entry_number: First entry number (default 1).

Write journal entries you composed (e.g. from invoices or a payroll summary) as an import file.

entries: [{"date": "2026-03-31", "number": 1 (optional), "lines": [{"account": "64000000", "debit": "1500.00", "concept": "Nómina marzo"}, {"account": "47510000", "credit": "225.00"}, ...]}]. Entries must balance: an unbalanced entry is refused before any charge, with the difference. target_format accepts every format of convert_journal, including quickbooks_iif, quickbooks_csv and xero_csv (date_style / xero_tax_rate as there).

Convert a libro diario (journal) between Spanish accounting programs.

Formats: a3 (a3ASESOR/a3ECO/a3CON SUENLACE.DAT, apuntes tipo 0), contaplus_csv (Sage ContaPlus / Sage 50 Diario CSV, 142 fields), contaplus_ascii (XDiario.txt fixed width), contasol (ContaSol APU.ods, destination only: save content_base64 as APU.ods and import it in Utilidades > Importaciones), csv (spreadsheet with header: Holded, Excel, any ERP; columns auto-detected, override with column_map), quickbooks_iif (QuickBooks Desktop general journal), quickbooks_csv (QuickBooks Online journal import), xero_csv (Xero manual journal import). The source is auto-detected. QuickBooks/Xero accounts are names or codes, not PGC subaccounts: use account_map to translate them when converting to or from A3/ContaPlus.

Args: target_format: a3 | contaplus_csv | contaplus_ascii | contasol | csv | quickbooks_iif | quickbooks_csv | xero_csv. content: The file as text. content_base64: raw bytes as base64 (Latin-1/CP1252 files with Ñ). source_format: auto (default) or one of the formats. account_digits: Resize every subaccount to this length (ContaPlus uses a fixed length, e.g. 8); also expands '430.1' shorthand. 0 keeps them. account_split: Where zeros are inserted/removed when resizing (default 4: 4300001 -> 43000001). account_map: Exact account renames applied first, e.g. {"5720001": "57200005"}. start_entry_number: Renumber entries from this number (ContaPlus requires numbers; A3 does not use them). company_code: A3 company code (1-99999). a3_format: 5 (512-byte records, current) or 4 (256, old). column_map: For csv sources, e.g. {"debit": "Importe D", "account": "Cta"}. Keys: number, date, account, account_name, debit, credit, amount, dh, concept, document. csv_delimiter: For csv source/target; auto-detected on read, ';' on write. decimal_comma: csv output with decimal comma (Spanish Excel). fiscal_year: flag dates outside it. strict: Refuse to write a file with validation errors (default), so the target program never rejects it. date_style: Dates in QuickBooks/Xero files, read and write: mdy (US, QuickBooks default), dmy (UK/AU/NZ, Xero default) or iso. xero_tax_rate: TaxRate written on every Xero line, as named in that Xero organisation (UK "No VAT", AU "BAS Excluded", NZ "No GST", US "Tax Exempt").

Remaining credits on your KeyFlint license. Free.

Tell which accounting import format a file is (a3, contaplus_csv, contaplus_ascii, csv, quickbooks_iif, quickbooks_csv, xero_csv). Free.

Book issued and received invoices (facturas emitidas y recibidas) as journal entries with VAT split out.

Read each invoice (PDF, photo, Facturae, email) yourself and pass its figures; this tool does the bookkeeping deterministically. Per invoice: {"kind": "issued"|"received", "number": "F-2026-031", "date": "2026-02-28", "nif": "B12345678", "name": "Talleres Ruiz SL", "taxes": [{"base": "1000.00", "rate": "21", "vat": "210.00" (optional, checked), "recargo_rate": "5.2" (optional)}], "irpf_rate": "15" or "irpf_amount": "150.00" (optional), "total": "1060.00" (optional but recommended: checked), "account": "43000012" (optional), "counterpart_account": "62300000" (optional, default 700 / 600), "concept": optional}. Shortcut for one VAT rate: "base" + "vat_rate". Negative amounts = factura rectificativa (sides swap).

Issued: Debe 430 total (+ 473 IRPF retenido por el cliente) / Haber 700 base + 477 IVA. Received: Debe 600 base + 472 IVA / Haber 4751 IRPF + 400 total. Tax is recomputed (base x rate, half up); a 1-cent difference with the invoice total is absorbed in the largest tax line, more than that sends the invoice to review with the reason, unbooked. Duplicates (same kind + NIF + number) also go to review.

Args: accounts: Override default roots {customers 430, suppliers 400, sales 700, purchases 600, vat_output 477, vat_input 472, irpf_withheld 4751, irpf_suffered 473}. party_accounts: {NIF: subaccount}, e.g. {"B12345678": "43000012"}. Invoices with no account are booked to the generic 430/400 and listed in generic_party_account so the accountant assigns them. vat_accounts: {rate: subaccount}, e.g. {"21": "47700021", "10": "47700010", "re5.2": "47700052"}. target_format / account_digits / company_code / ...: as in build_journal.

Returns the import file, vat_summary (base and cuota per rate for the libro registro / modelo 303), vat_register (one row per invoice and rate), review and open_items to pass to bank_to_journal.

Read a digital bank statement PDF (Revolut, Wise, N26, CaixaBank, BBVA, Santander... downloaded from online banking, with selectable text) and turn it into journal entries or a Norma 43 file.

Deterministic: the movements table is located by its header (Fecha, Concepto, Cargo/Abono or Importe, Saldo) and each value is read from its column. No OCR and no AI: scanned PDFs are refused, not guessed. Every row is checked: previous balance + amount = printed balance, and opening + money in - money out = closing balance. Rows that do not add up are booked but listed in flagged_rows with status "mismatch"; rows whose sign (cargo/abono) cannot be proven go to status "review" and are NOT booked. Check balance_check.balanced.

Args: content_base64: The PDF file bytes in base64. target_format: contasol (APU.ods, default) | a3 | contaplus_csv | contaplus_ascii | csv | quickbooks_iif | quickbooks_csv | xero_csv | norma43 (a .n43 file to import in any program that reads Cuaderno 43). bank_account: The 572 subaccount of the bank (default 57200001). rules / suspense_account / open_items / window_days: As in bank_to_journal. strict_balance: true refuses to produce any file (and charges nothing) unless every row and the closing balance add up. account_ccc: For norma43 when the PDF has no Spanish IBAN: 20-digit CCC for record 11. holder: Account holder name for the Norma 43 header (optional).

Credit price of each tool and where to buy credits. Free.

Resize or expand a Spanish subaccount code. Free. '430.1' -> '43000001'; 4300001 (7) -> 43000001 (8).

Check a journal file the way A3/ContaPlus check it on import, before you send it.

Reports unbalanced entries (with the difference), lines with both or neither debit and credit, non-numeric accounts or accounts outside PGC groups 1-9, mixed subaccount lengths and dates outside fiscal_year. valid is false when any error is found. include_entries returns the first 50 entries parsed. QuickBooks/Xero files are checked against their own chart (any non-empty account), not the PGC.