Statements Format Management

Every per-exchange raw-statement quirk (G/L account routing, which tabs to read, sheet-to-direction mapping, OTC Comment priority, extra column names, asset code renames) lives here now - add a new exchange or change one without any code change. Any admin can edit this.

Exchange	Expected Raw Columns	G/L Account No.	Addressless	Allowed Sheets	Sheet → Payment Type	Doc. No. from REFID	OTC Comment Priority	Notes	Actions

Add Exchange Format

Basics

Exchange Code

G/L Account No. (leave blank for normal Bank Account posting)

Addressless (no wallet address column - e.g. Scrypt)

Raw File Layout

Documentation only - shown in the table so anyone (including a new owner of this project) can see exactly what this exchange's export looks like without reading code. Doesn't affect parsing itself; that's driven by the fields below.

Expected Raw Columns (one line per sheet: "sheetname: col1, col2, ..." - or just a plain comma list if there's only one sheet)

Sheet Handling

Leave both blank if this exchange's file is a single sheet with no direction-per-tab convention (e.g. Kraken).

Allowed Sheets (comma-separated, others in the same file are ignored - e.g. HTX)

Sheet → Payment Type (one per line: sheetname=DEP or WD)

Matching Behavior

Document No. from REFID (instead of EXCHANGE WD/DEP MMYY)

OTC Comment Priority for Deposits (Comment overrides address; blank/NA resolves address from tx hash via Etherscan/TronGrid)

Extra Column Synonyms (comma-separated header names this exchange uses instead of the usual ones)

Chain / Network column (e.g. Kraken's CURRENCY_NAME)

Address column

Comments/WKEY column

Asset Code Renames / Drops (e.g. Kraken's X-/Z- prefixed codes)

Renames (one per line: FROM=TO)

Drop entirely (comma-separated - these rows are removed on import)

Notes

Fiat bank formats

Teach a bank's plain xlsx/csv statement without code. Applies when an uploaded fiat statement's chosen account is at this bank. Column boxes take one header per line (or comma-separated); matching ignores case and punctuation. Rows marked built-in are the formats implemented in code (shown here for reference, edited only via code); adding a format here for one of those banks overrides the built-in column mapping.

Bank	Date	Description	Amount	Currency	Row rules	Actions

Add Bank Format

Bank name (matches Bank Accounts)

Date order (final upload is always DD.MM.YYYY)

Date column header(s)

Description column header(s) — joined in order

Amount mode

Debit column header(s)

Credit column header(s)

Currency column header(s) — optional (else from account)

Skip rows equal to these phrases — optional

Skip zero-amount rows

Status column header — optional

Import only rows whose Status equals

Notes — optional

Bron accounts

Vault accounts of the Bron custody exchange (exchange code BRON). Each vault is matched by the export's own Account Name column, belongs to one legal entity (uploads under another entity are rejected), sets the Document No. prefix (BRON / BRON OTC / BRON BLIK) and maps every asset+network pair it holds to its Dynamics bank account B-code. A combination missing here leaves Account No. empty on export — Check File and the upload result both list what's missing.

Account (as in export)	Legal entity	Doc prefix	B-codes	Notes	Actions

Add Bron Account

Account Name (exactly as in the Bron export)

Legal entity

Document No. prefix

B-codes (one per line: SYMBOL/NETWORK = code, e.g. "USDT/TRX = B-03-010")

Notes — optional