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

lim bank sync ba_01J8...

✅ 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

Journal Entries

Manage the entries matched to bank transactions.

Invoicing

Track receivables against bank deposits.

Getting Started

Guides

Concepts

Bank Reconciliation

Bank Reconciliation

Bank Account Setup

Import Transactions

View Unmatched Transactions

Matching Strategies

Manual Match

Create and Match

Auto-Match

Unmatch and Exclude

Reconciliation Report

Reconciliation Workflow

Next Steps

Journal Entries

Invoicing

​Bank Reconciliation

​Bank Account Setup

​Import Transactions

​View Unmatched Transactions

​Matching Strategies

​Manual Match

​Create and Match

​Auto-Match

​Unmatch and Exclude

​Reconciliation Report

​Reconciliation Workflow

​Next Steps

Journal Entries

Invoicing

Bank Reconciliation

Bank Account Setup

Import Transactions

View Unmatched Transactions

Matching Strategies

Manual Match

Create and Match

Auto-Match

Unmatch and Exclude

Reconciliation Report

Reconciliation Workflow

Next Steps