Reconciliation (消込)

What Is Reconciliation?

Reconciliation matches your documents (receipts, invoices) with actual bank transactions to confirm that money has moved as expected. Once reconciled, the document is marked reconciliation_status: reconciled and the bank transaction is marked status: matched.

Importing Bank Statements

1. Navigate to Data → Bank Import
2. Upload your bank statement (CSV or PDF). The supported CSV columns are auto-detected; PDFs are parsed via Butler's PDF reader
3. Review the parsed transactions
4. Click Import All

You can also import on a per-line basis if some rows need manual adjustment.

Reconciling Receipts (Outflow)

Use Reconciliation → Outflow Reconciliation for outgoing money:

1. Select an unreconciled bank transaction in the left panel
2. Butler suggests matching documents in the right panel, scored by:
   • Amount proximity — exact match or within tolerance
   • Date proximity — issue date vs. transaction date
   • Counterparty match — vendor / payee name vs. transaction description, with rule-driven normalization
3. Select a single document or several documents that sum to the transaction amount
4. Click Reconcile to confirm

If amounts differ within a small tolerance (default ¥1,000), the difference is auto-treated as payment fee (支払手数料). Larger differences require explicit categorization (transfer fee / partial payment / lump-sum / offset).

Reconciling Invoices (Inflow)

Use Reconciliation → Inflow Reconciliation for incoming money (payment for issued invoices). The flow is identical except the candidates are issued invoices instead of receipts.

Auto-Matching

Butler periodically runs auto-matching that considers bank_display_names patterns and matching rules to apply high-confidence matches without user action. View the history at Reconciliation → Auto-match History.

Payment Due Dates

Each client can have:

• closing_day — the day of the month invoices are cut off
• payment_months — months after the closing day until payment is due

These are used to compute an expected payment date for each invoice. For example, with closing_day=31 and payment_months=1:

• An invoice issued on 2025-01-15 has expected payment by 2025-02-28 (end of the month one month after January)

The expected date drives reconciliation date scoring and due_soon / overdue alerts.

Undoing a Reconciliation

Open the matched item in the Matched tab and click Undo Reconciliation. This deletes the match record, reverts the transaction to unmatched, and reverts the document(s) to unreconciled. The action is recorded in audit_logs.

Cash Reconciliation

For cash transactions, Reconciliation → Cash Reconciliation lets you match documents against entries in the cash ledger (Master → Cash Ledger).

Processing Without a Document (書類なしで処理)

Some bank movements have no counterpart document — loan drawdowns and repayments, interest, deposits/guarantees, tax direct-debits. On the reconciliation page, select only the transaction(s) (no document) and use 書類なしで処理: pick an account, an optional tax division and a memo. A draft journal entry is created in the Journal (帳簿・決算), keeping these movements connected to the books like everything else. Fees, interest and social-insurance debits recognized at import time by the auto-expense rules are journalized automatically the same way.