Ingestion

Reconify supports CSV, JSON, NDJSON, XLSX, and XLSM files.

Parser type

parser:
  type: auto

auto infers from file extension:

• .csv
• .json
• .ndjson
• .xlsx
• .xlsm

Legacy .xls files are not supported. Save them as .xlsx or .csv first.

CSV and XLSX headers

CSV and XLSX use the first row as headers. Column lookup is case-insensitive and trims whitespace.

parser:
  type: xlsx
  sheet: "Transactions"
  date_col: "Date"
  amount_col: "Amount"

If sheet is omitted for XLSX, Reconify reads the first sheet.

JSON and NDJSON

JSON supports top-level arrays. NDJSON supports one object per line.

Use the same parser column names for object keys:

parser:
  type: json
  date_col: "created_at"
  date_layout: "2006-01-02"
  amount_col: "amount_minor"
  multiplier: 1
  ref_col: "id"

Amount parsing

Configure decimal and thousands separators when source files use formatted amounts.

decimal: "."
thousands: ","
multiplier: 100

Parenthetical negatives are supported, for example (1,234.56).