> ## Documentation Index
> Fetch the complete documentation index at: https://docs.uselim.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bank Reconciliation

> Import bank transactions, match them to journal entries, and reconcile.

# Bank Reconciliation

lim imports bank transactions and matches them against journal entries — manually, by rule, or automatically.

## Bank Account Setup

```bash theme={null}
# 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

<CodeGroup>
  ```bash CSV import theme={null}
  lim bank import ba_01J8... --file mufg-march.csv --format mufg
  ```

  ```bash API sync (when available) theme={null}
  lim bank sync ba_01J8...
  ```
</CodeGroup>

```
✅ Imported 45 transactions (2026-03-01 ~ 2026-03-31)
   Auto-matched: 38
   Pending:       7
```

<Tip>
  lim supports CSV formats from major Japanese banks: MUFG, SMBC, Mizuho, Rakuten, and more. Use
  `--format` to specify your bank.
</Tip>

## View Unmatched Transactions

```bash theme={null}
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:

```bash theme={null}
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:

```bash theme={null}
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:

```bash theme={null}
lim bank auto-match ba_01J8...
```

```
Auto-match results:
  ✅ Matched:   38 transactions
  🤔 Suggested:  4 transactions (review required)
  ❌ Unmatched:  3 transactions
```

<Warning>
  Review auto-match suggestions before confirming. lim uses amount, date, and description similarity
  but may occasionally suggest incorrect matches.
</Warning>

## Unmatch and Exclude

```bash theme={null}
# 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

```bash theme={null}
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

<Steps>
  <Step title="Import bank transactions">Import CSV or sync via API.</Step>
  <Step title="Auto-match">Run `lim bank auto-match` to handle known patterns.</Step>
  <Step title="Review suggestions">Confirm or reject suggested matches.</Step>
  <Step title="Handle remaining items">Manually match, create new entries, or exclude.</Step>

  <Step title="Verify reconciliation">
    Run `lim bank reconciliation` to confirm the balance matches.
  </Step>
</Steps>

## Next Steps

<CardGroup cols={2}>
  <Card title="Journal Entries" icon="book" href="/guides/journal-entries">
    Manage the entries matched to bank transactions.
  </Card>

  <Card title="Invoicing" icon="file-invoice-dollar" href="/guides/invoicing">
    Track receivables against bank deposits.
  </Card>
</CardGroup>