YonSuiteFinanceIntermediateContent quality · 94/100

YonSuite Bank Reconciliation: Build a Daily Open-Item Loop

Match bank statements and cash journals by date, amount, currency and reference to find missing or duplicate records early.

银行日记账与银行对账 / Bank Reconciliation18 minUpdated 2026-08-21
01

Learning objective

Complete daily matching, review, open-item tracking and ledger reconciliation.

Roles

Finance, process owners, key users, IT, consultants and internal audit

Prerequisites

  • Confirm entities, periods, currencies, masters and access.
  • Prepare approved normal and exception test data.
  • Define cut-off, interfaces, approvals and changes.

Completion checks

  • Results trace to source document and accountable role.
  • Quantity, amount, currency, period and status reconcile.
  • Exceptions retain cause, action, owner and closure evidence.

Common errors

  • Masking source errors with manual adjustment.
  • Not freezing versions, making results irreproducible.
  • Testing only normal flow.

Thailand project note

Thai implementations should confirm Thai/English masters, THB and foreign currencies, Asia/Bangkok time, segregation of duties, approvals and local retention. This covers ERP process controls only; VAT, WHT, BOI, customs and statutory-accounting conclusions require qualified Thai professional review.

Related modules

finance-controlmanagement-accountingbusiness-reconciliation

03

Steps

01Confirm bank account, currency, entity and opening balance.
02Import statements securely and record file, batch, count and control total.
03Set matching by reference priority, exact amount and controlled date tolerance.
04Handle one-to-one, one-to-many, fees and exchange differences separately.
05Record cause, owner, amount and due date for unmatched items.
06Reconcile bank balance, journal, in-transit items and ledger control.
  1. 01

    Confirm bank account, currency, entity and opening balance.

  2. 02

    Import statements securely and record file, batch, count and control total.

  3. 03

    Set matching by reference priority, exact amount and controlled date tolerance.

  4. 04

    Handle one-to-one, one-to-many, fees and exchange differences separately.

  5. 05

    Record cause, owner, amount and due date for unmatched items.

  6. 06

    Reconcile bank balance, journal, in-transit items and ledger control.

04

Implementation notes

  • Pilot one organisation and representative period.
  • Exceptions need source, owner, approval and closure evidence.
  • Menus and fields depend on current release and blueprint.
05

References