File Import (CSV, OFX/QFX)

Import records from bank-exported files into an existing journal.

Supported formats

• CSV. Comma-separated values. Columns are mapped from the file’s headers and can be adjusted manually.
• OFX. Open Financial Exchange. Self-describing, no column mapping needed.
• QFX. Quicken variant of OFX. Treated the same as OFX.

CSV column map

Surebeans matches each field to a file column, guessing from the headers. Date, Payee, and an amount are required; Memo, Running Balance, and Category are optional.

• Date: The record date, read with the Date format you supply, such as yyyy-MM-dd or MM/dd/yyyy.
• Payee and Memo: Who the record is with, and a note.
• Amount: One signed column. Split inflow/outflow uses two separate columns instead.
• Running Balance: The account balance after each transaction.
• Category: The budget category.

CSV options

• Delimiter: Comma, semicolon, or tab.

Investments

This file contains investments maps three more columns for a CSV brokerage export:

• Symbol: The security ticker, such as AAPL.
• Quantity: Shares bought or sold.
• Price: Price per share.

Trades import as security postings, and cash rows import alongside them. The account’s type, not the Category column, decides where cash rows go: a Tracking account keeps them off your budget, while any other account includes them in it. A sale books its realized gain automatically when the cost basis is known. See Tracking Securities.

Options

These apply to both CSV and OFX.

• Account: Which account the records belong to.
• Invert amounts: Flips the sign, since some banks export expenses as positive.
• Currency: The currency of cash amounts. It defaults to your reporting currency; OFX pre-fills it from the file’s stated currency. Securities keep their own ticker. See Multi-Currency.

Import Review

After selecting a file, Import Review appears.