rledger extract

Import transactions from CSV and OFX bank statements.

Usage

rledger extract [OPTIONS] [FILE]

Arguments

Argument	Description
FILE	CSV or OFX file to import (required unless using --list-importers)

Options

Config-based Import

Option	Description
-i, --importer <NAME>	Use a named importer from config
--config <FILE>	Path to importers.toml configuration file
--list-importers	List available importers from config file and exit

Direct CLI Import

Option	Description
-a, --account <ACCOUNT>	Target account [default: Assets:Bank:Checking]
-c, --currency <CURRENCY>	Currency for amounts [default: USD]
--date-column <COL>	Date column name or index [default: Date]
--date-format <FMT>	Date format (strftime-style) [default: %Y-%m-%d]
--narration-column <COL>	Narration/description column [default: Description]
--payee-column <COL>	Payee column name (optional)
--amount-column <COL>	Amount column name or index [default: Amount]
--amount-locale <LOCALE>	Locale for parsing amounts (e.g., en_US)
--amount-format <FMT>	Custom format for parsing amounts
--debit-column <COL>	Debit column (for separate debit/credit)
--credit-column <COL>	Credit column (for separate debit/credit)
--delimiter <CHAR>	CSV delimiter [default: ,]
--skip-rows <N>	Number of header rows to skip [default: 0]
--invert-sign	Invert sign of amounts
--no-header	CSV has no header row

Output Options

Option	Description
-o, --output <FILE>	Write output to file instead of stdout
--existing <FILE>	Existing ledger file for duplicate detection
-P, --profile <PROFILE>	Use a profile from config

Examples

Basic CSV Import

rledger extract bank-statement.csv -a Assets:Bank:Checking

With Configuration

Create importers.toml:

[[importers]]
name = "chase"
account = "Assets:Bank:Chase"
date_column = 0
narration_column = 2
amount_column = 3
date_format = "%m/%d/%Y"
skip_header = true

[importers.mappings]
"AMAZON" = "Expenses:Shopping"
"WHOLE FOODS" = "Expenses:Food:Groceries"
"SHELL" = "Expenses:Transport:Gas"

rledger extract --importer chase chase-statement.csv

OFX Import

rledger extract statement.ofx -a Assets:Bank:Checking

Append to Ledger

rledger extract statement.csv -a Assets:Bank >> ledger.beancount

Duplicate Detection

# Skip transactions already in ledger
rledger extract statement.csv -a Assets:Bank --existing ledger.beancount

Importer Configuration

CSV Options

[[importers]]
name = "my_bank"
account = "Assets:Bank:MyBank"

# Column mapping (0-indexed)
date_column = 0
payee_column = 1
narration_column = 2
amount_column = 3

# Or use column names (if CSV has header)
date_column = "Date"
amount_column = "Amount"

# Date parsing
date_format = "%Y-%m-%d"  # or "%m/%d/%Y", "%d.%m.%Y"

# Skip header row
skip_header = true

# Invert amounts (for credit card statements)
invert_amounts = true

# Default expense account
default_expense = "Expenses:Unknown"

# Pattern-based account mapping
[importers.mappings]
"GROCERY" = "Expenses:Food:Groceries"
"GAS STATION" = "Expenses:Transport:Gas"
"PAYROLL" = "Income:Salary"

Multiple Importers

[[importers]]
name = "checking"
account = "Assets:Bank:Checking"
# ...

[[importers]]
name = "credit_card"
account = "Liabilities:CreditCard"
invert_amounts = true
# ...

Use with:

rledger extract --importer checking statement.csv

The importers.toml file is auto-discovered from the current directory or ~/.config/rledger/. To specify a custom path:

rledger extract --config path/to/importers.toml --importer checking statement.csv

List Available Importers

rledger extract --config importers.toml --list-importers

Direct CLI Import (No Config)

rledger extract statement.csv \
  -a Assets:Bank:Checking \
  --date-column "Transaction Date" \
  --date-format "%m/%d/%Y" \
  --amount-column "Amount" \
  --narration-column "Description" \
  --skip-rows 1 \
  --invert-sign

See Also

• Importing Guide - Detailed import tutorial