Skip to main content

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

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

1

Import bank transactions

Import CSV or sync via API.
2

Auto-match

Run lim bank auto-match to handle known patterns.
3

Review suggestions

Confirm or reject suggested matches.
4

Handle remaining items

Manually match, create new entries, or exclude.
5

Verify reconciliation

Run lim bank reconciliation to confirm the balance matches.

Next Steps