Bank Reconciliation Applet

Purpose and Overview

The Bank Reconciliation Applet is the month-end and period-end control center that validates whether your cashbook-ledger transactions match your actual bank statement movements.

Master Your Month-End: The BigLedger Bank Reconciliation Applet - infographic showing challenges of manual reconciliation, key features, and who benefits — Master Your Month-End: The BigLedger Bank Reconciliation Applet — Infographic overview of manual reconciliation challenges, solution features, and key beneficiaries.

It is not a standalone process. Reconciliation quality depends on how well upstream applets are configured:

Cashbook Applet creates the cashbook accounts used by finance operations.
Settlement methods are linked to specific cashbooks.
Receipt Voucher (Internal) Applet and Payment Voucher (Internal) Applet post settlements through those methods.
POS General Applet cash and card settlements also flow into linked cashbooks.
Bank Reconciliation then compares all those ledger movements against imported bank statement lines.

Core Concept: If a settlement method points to a cashbook, that transaction eventually shows up in Bank Reconciliation for that cashbook and period.

Key Features Overview

Who Benefits from This Applet?

Finance Executives and Accountants:

Run period-by-period reconciliation with clear status and matching controls
Investigate variances quickly using manual and auto matching tools
Maintain traceable records for every reconcile and unreconcile decision

Finance Managers and Controllers:

Verify cashbook integrity before close
Monitor unresolved items across matched and unmatched sets
Strengthen close governance with standardized process steps

Auditors and Compliance Teams:

Review evidence-backed reconciliations with clear period boundaries
Inspect adjustment logic and report outputs for financial assurance
Confirm completeness of bank-to-ledger alignment

What Problems Does This Solve?

The Manual Reconciliation Problem:

Traditional bank reconciliation often relies on spreadsheets and ad hoc checks. Common issues include:

Cashbook balances that do not match bank balances at period close
Missing links between settlements and bank entries
Slow, error-prone manual matching with weak audit trails
Corrections that are hard to explain or reproduce

The Bank Reconciliation Applet Solution:

Structured recon session by cashbook and date range
Statement import workflow with bank format or default helper support
Manual matching controls (reconcile and unreconcile)
Auto matching for high-volume acceleration
Report suite (Report 1, Report 2, Report 3) for variance explanation and audit evidence

Key Features Overview

Recon Session Setup

Cashbook, period, and opening balances with guided hints

Statement Import

Upload bank statements and review cash statement lines

Manual Matching

Reconcile, unreconcile, and inspect statement lines

Auto Matching

Run automation and monitor processing status

Reporting and Audit

Report 1, 2, and 3 for close evidence

Cross-Applet Flow

Cashbook, vouchers, and POS into recon

Bank Reconciliation listing screen showing reconciliation sessions and status summary — Bank Reconciliation Overview: Central listing to manage recon sessions by cashbook and period.

Key Concepts

Understanding the Bank Reconciliation Framework

Every reconciliation process must align three perspectives. This applet keeps them explicit:

Aspect	Component	Practical Example
What are you reconciling?	Cashbook (ledger)	Operating account at Bank ABC
Against what?	Bank statement lines	CSV import for the same month
How do you close the gap?	Manual match, auto match, adjustments, reports	Match RCT lines to statement rows, then run Report 3

Real-World Example: Your settlement method for card sales points to Cashbook A. POS settlements for the month post to Cashbook A. You import the bank CSV for Cashbook A, match lines, then use Report 1 to show journal and statement alignment before sign-off.

How Bank Recon Connects to Cashbook, Vouchers, and POS

Bank reconciliation works best when upstream configuration is done in the right order:

Create the cashbook in the Cashbook Applet.
Link settlement methods to that cashbook (and branch where required).
Process transactions that use those methods in:
Confirmed movements appear on the cashbook transaction side for the period.
Bank Reconciliation compares those lines to imported bank statement lines.

If settlement methods are mapped to the wrong cashbook, variances appear in the wrong account and period. Fix master data before spending time on matching.

Reconciliation Lifecycle

Stage	What You Do	Why It Matters
Setup	Create recon session with cashbook, dates, opening balances	Defines reconciliation scope and controls
Ingest	Upload statement files (bank format or default helper)	Brings external bank data into the session
Match	Manual reconcile or unreconcile; run auto matching	Links ledger activity to bank lines
Review	Inspect unmatched lines and adjustments	Explains variances before close
Report	Generate Report 1, Report 2, or Report 3	Produces audit-ready documentation

Bank reconciliation listing grouped by cashbook for easier period review — Cashbook Grouping: Review recon sessions grouped by cashbook for operational clarity.

Core Data You Reconcile

Source	Typical Content
Cashbook transactions	Voucher settlements, POS settlements, cash transfers, adjustments
Bank statement lines	Imported debits, credits, descriptions, references
Recon header	Cashbook, period, opening and closing balances, status
Match links	Manual or automatic links between internal and bank-side lines

Quick Start Guide

Get up and running quickly with these essential workflows.

Report 3 overview of bank reconciliation outcomes and balances — At-a-Glance: Use reports together with matching to close the period with clear evidence.

For Admins: Prerequisite Setup

Goal: Ensure cashbooks and settlement paths are correct before users create recon sessions.

Complete cashbook setup in the Cashbook Applet (including GL link where required).
Define settlement methods and map them to the correct cashbook and branches (see POS General Applet for retail settlement linking).
Confirm Receipt Voucher (Internal) and Payment Voucher (Internal) settlement lines use those methods.
Optionally configure automatching weightage in Cashbook to improve auto-match quality.

Cashbook setup page showing weightage and reconciliation related settings — Cashbook Prerequisite: Configure cashbook and weightage-related settings used by reconciliation.

Cashbook applet automatching weightage configuration screen — Automatching Weightage: Tune matching behavior from Cashbook configuration.

Bank Reconciliation Applet Application Settings screen — Application Settings: Control field visibility (e.g., branch, delete button, cashbook balances) for the Bank Reconciliation applet. These settings help tailor the reconciliation interface to your internal control policies and user needs.

For Accountants: Run Your First Reconciliation

Goal: Complete one full reconciliation cycle for a cashbook period.

Open Bank Reconciliation from the sidebar and create a new session.
On Details, set Cashbook, Opening Date, Closing Date, Cash Book Transaction Opening Balance, and Cash Statement Opening Balance (use suggested hints where shown).
Save the session.
Open Upload Statement and import your bank file; review the Cash Statement tab listing.
Open Manual Matching:
- Reconcile tab to link cashbook and statement lines
- Unreconcile tab to reverse incorrect matches
- Bank Statement Lines tab to investigate outliers
Open Auto Matching, run the processor, and wait for status to refresh; review unmatched sets.
Open Report, generate Report 1, Report 2, and Report 3 as needed for sign-off.

Bank reconciliation details tab with required fields and balances — Details Tab: Define cashbook, period, and balances before statement work.

Upload statement screen in bank reconciliation applet — Statement Upload: Import bank statement files for the active session.

Cash statement tab under upload statement with imported file listing — Cash Statement Tab: Review uploaded files and parsed statement context.

For Controllers: Validate Before Close

Goal: Confirm the recon is defensible for period close.

Verify dates and opening balances match the prior period close and bank records.
After matching, review unmatched cashbook and statement lines.
Confirm material Receipt Voucher, Payment Voucher, and POS settlements appear on the expected cashbook for the period.
Retain Report 1 / 2 / 3 outputs with the recon session for audit file.

Report 1 output showing journal lines matched with bank statement lines — Report 1: Evidence of journal and bank statement alignment.

New to bank recon? Start in this order: Prerequisite Setup (cashbook and settlements) → Details session → Upload Statement → Manual Matching → Auto Matching → Report.

Sidebar Menu Reference

Menu Item	Description
Bank Reconciliation	Listing, create, and edit recon sessions. Tabs include Details, Upload Statement, Manual Matching, Auto Matching, and Report.
Imported External Cashbook	Manage imported external cashbook or GL movements that support reconciliation.
Settings	Application Settings and Default Selection for applet behavior and field visibility.
Personalization	Personal Default Selection for user-specific defaults.

Manual Matching

Manual matching gives exact control when references are non-standard or amounts need judgment.

Reconcile: Link selected cashbook transactions to bank statement lines.
Unreconcile: Reverse a prior match safely when you identify an error.
Bank Statement Lines: Inspect every imported line (date, description, references, amounts).

Use manual matching for partial matches, one-to-many relationships, and investigation before you rely on automation.

Manual matching reconcile tab with transaction matching options — Manual Matching - Reconcile: Select internal and bank lines to match.

Unreconcile tab for reversing previous match links — Manual Matching - Unreconcile: Undo incorrect matches while preserving history.

Bank statement lines tab used in manual matching — Bank Statement Lines: Browse and filter imported statement rows.

Detail view after selecting reconcile action — Reconcile Detail: Review match context before confirming.

Document pop-up page showing linked transaction context — Document Pop-up: Open linked document context from a line.

Manual reconciliation with selected bank statement lines and journal lines — Manual Line Selection: Align journal and bank statement lines explicitly.

Unmatched adjustment screen for reconciling residual differences — Unmatched Adjustment: Handle residual differences with controlled adjustments.

Detailed statement line view opened from bank statement lines listing — Statement Line Detail: Validate payor, references, and amounts.

Bank statement line matched to journal line detail — Line-Level Match: Confirm statement line to journal mapping.

Bank statement line with adjustment applied in matching workflow — Statement Line with Adjustment: Review adjustment impact on the line.

Auto Matching

Auto matching accelerates high-volume periods:

Run the Auto Matching processor from the Auto Matching tab.
The system updates matched and unmatched sets based on rules and configured weightage.
Processing status is polled; wait for completion before you sign off.
Always perform a manual review of unmatched lines after a run.

Auto matching processor page with run action and processing status — Auto Matching Processor: Execute automation and monitor processing status.

Reporting & Audit

The Report tab hosts three report views:

Report 1: Journal-oriented view with bank statement line alignment.
Report 2: Detailed schedule-style output for follow-up and evidence.
Report 3: High-level overview of reconciliation outcomes and balances.

Use these together as your month-end reconciliation pack for reviewers and auditors.

Report 2 output with statement lines and journal mapping details — Report 2: Detailed schedule for reconciliation evidence and follow-up.

Configuration & Settings

Application Settings control field visibility and behavior on recon screens (for example branch visibility and delete controls). Align these with your internal control policy.

Default Selection reduces repeated entry for users who perform reconciliation frequently.

For automatching weightage, configure the related options in the Cashbook applet (see Prerequisite Setup screenshots above).

Personalization

Use Personalization → Default Selection so each user can keep preferred defaults without changing tenant-wide configuration.

Audit

Bank reconciliation is audit-sensitive:

Reconcile and Unreconcile actions should be restricted by role.
Keep the final Report 1, Report 2, and Report 3 outputs with the recon session and bank file archive.
Document adjustment reasons when you use unmatched adjustment workflows.

FAQ

Q: Why do my cashbook lines not match the bank file?

A: Check that settlement methods point to the correct cashbook, that dates fall inside the recon period, and that upstream Receipt Voucher, Payment Voucher, and POS documents are posted.

Q: Auto matching ran but many lines remain unmatched.

A: Review weightage configuration in Cashbook, verify bank import format, then use Manual Matching for exceptions.

Q: Where do I start if I am new to the applet?

A: Follow Quick Start Guide in order: prerequisites, session Details, Upload Statement, matching, then Report.

Related Applets

Cashbook Applet: Cashbook accounts and automatching weightage
Receipt Voucher (Internal) Applet: Receipt settlement into cashbook
Payment Voucher (Internal) Applet: Payment settlement into cashbook
POS General Applet: POS settlement methods and branch mapping

Summary

The Bank Reconciliation Applet is the control layer that proves settlement-driven cashbook activity matches bank reality for a defined period. When cashbooks and settlement mappings are correct, reconciliation is faster, clearer, and easier to defend in audit.

Video Walkthrough

Watch this video to see the Bank Reconciliation flow in action:

If video playback is blocked by browser or network policy, open directly: Bank Reconciliation Walkthrough.

What the Video Demonstrates

Based on the walkthrough, the video typically covers:

Creating a recon session and entering opening balances on Details
Uploading a bank statement and reviewing the Cash Statement tab
Manual matching using Reconcile, Unreconcile, and Bank Statement Lines
Running auto matching and interpreting processing status
Generating reports (Report 1, Report 2, Report 3) for close evidence

Always reconcile unmatched and adjustment items to a clear resolution before you treat the period as closed. Unexplained variance should not roll forward silently.