Bank Reconciliation
lim imports bank transactions and matches them against journal entries — manually, by rule, or automatically.
Bank Account Setup
# Add a bank account
lim bank add --name "MUFG Main" --number "1234567" --bank-code 0005
# List bank accounts
lim bank list
ID Name Bank Account Balance Unmatched
ba_01J8... MUFG Main MUFG 1234567 2,400,000 12
ba_01J9... SMBC Ops SMBC 7654321 800,000 3
Import Transactions
CSV import
API sync (when available)
lim bank import ba_01J8... --file mufg-march.csv --format mufg
✅ Imported 45 transactions (2026-03-01 ~ 2026-03-31)
Auto-matched: 38
Pending: 7
lim supports CSV formats from major Japanese banks: MUFG, SMBC, Mizuho, Rakuten, and more. Use --format to specify your bank.
View Unmatched Transactions
lim bank unmatched ba_01J8...
Date Description Amount Direction
2026-03-05 アマゾン ウェブ サービス -11,000 withdrawal
2026-03-10 カ)ヤマダ デンキ -33,000 withdrawal
2026-03-15 フリコミ エービーシー 550,000 deposit
...
Matching Strategies
Manual Match
Link a bank transaction to an existing journal entry:
lim bank match bt_01K1... --entry je_01K3...
✅ Matched: bt_01K1... ↔ je_01K3... (AWS monthly ¥11,000)
Create and Match
When no journal entry exists yet, create one from the bank transaction:
lim bank match bt_01K2... --create "office equipment purchase"
✅ Created je_01K8... and matched to bt_01K2...
Equipment 30,000 / Checking Account 33,000
Input VAT 3,000
Auto-Match
Let lim match transactions automatically using rules, amount matching, and date proximity:
lim bank auto-match ba_01J8...
Auto-match results:
✅ Matched: 38 transactions
🤔 Suggested: 4 transactions (review required)
❌ Unmatched: 3 transactions
Review auto-match suggestions before confirming. lim uses amount, date, and description similarity but may occasionally suggest incorrect matches.
Unmatch and Exclude
# Unmatch a previously matched transaction
lim bank unmatch bt_01K1...
# Exclude a transaction from reconciliation (e.g., internal transfer)
lim bank exclude bt_01K5... --reason "Internal transfer between accounts"
Reconciliation Report
lim bank reconciliation ba_01J8... --date 2026-03-31
Bank Reconciliation: MUFG Main (as of 2026-03-31)
────────────────────────────────────────────────
Bank statement balance: 2,400,000
+ Deposits in transit: 50,000
- Outstanding checks: -120,000
──────────
Adjusted bank balance: 2,330,000
Book balance (account 1200): 2,330,000
──────────
Difference: 0 ✓
Reconciliation Workflow
Import bank transactions
Import CSV or sync via API.
Auto-match
Run lim bank auto-match to handle known patterns.
Review suggestions
Confirm or reject suggested matches.
Handle remaining items
Manually match, create new entries, or exclude.
Verify reconciliation
Run lim bank reconciliation to confirm the balance matches.
Next Steps