All tools
Accounting Tool

Bank Reconciliation Tool

Paste your bank statement and GL/cash book entries — automatically match transactions, identify outstanding items, generate a standard reconciliation statement, and get suggested adjusting journal entries.

Auto-match by amount + date (±3 days tolerance)|100% client-side — no data sent to server

Free Registration Required

Bank Reconciliation Tool

Enter your email to unlock advanced tools. No payment, no spam.

or
Add LINE Friend to Register

By registering you agree to receive occasional updates from WACC Service. Unsubscribe anytime.

How to use

  1. 1Paste your bank statement in the left box. Use tab, pipe (|), or comma as delimiter. Required columns: Date | Description | Withdrawal | Deposit | Balance
  2. 2Paste your GL/Cash Book entries in the right box. Required columns: Date | Description | Debit | Credit
  3. 3Enter opening balances for both bank and book (optional but recommended for balance verification). Set date tolerance — default ±3 days handles clearing delays.
  4. 4Click Reconcile. Review Section D (Reconciliation Statement) and post the suggested adjusting entries for bank-only items.

Supported date formats:

dd/mm/yyyydd-mm-yyyyyyyy-mm-dd(พ.ศ. years auto-converted)

Disclaimer: The matching algorithm uses exact amount and date proximity (±3 days by default). Transactions with identical amounts on the same date may match incorrectly — always review results before posting adjusting entries. For complex reconciliations or high-volume accounts, consult your CPA.

Need monthly bank reconciliation done for you?

WACC Service handles complete monthly bookkeeping including bank reconciliation, journal entries, and financial statements for Thai SMEs nationwide.

See Pricing Plans