Zencore

Bank Reconciliation

Automating bank reconciliation and financial settlement with data-driven insight

A single system for reconciling card and switch transactions with the bank's records. It combines file processing, settlement calculations, transaction matching, exception review and supporting documents in one workflow.

One workflow

Upload source files, run the reconciliation and get the voucher and report in one process.

Match transactions

VISA, Mastercard, NPSB and Q-Cash / ITCL matched against bank records.

Review exceptions

Missing, duplicate and mismatched records are identified separately.

Insight on demand

Dashboard and analytics across all channels, without separate spreadsheets.

How it works

From the morning plan to the end-of-day report, in five steps.

  1. Collect

    Obtain reports from card networks, switches and bank systems.

  2. Import

    Upload Excel files and apply the relevant template.

  3. Reconcile

    Match transactions and calculate differences.

  4. Review

    Examine unmatched items and exceptions.

  5. Report

    Produce the voucher and reconciliation report.

Complete feature list

Everything Bank Reconciliation does, from importing source files to the final voucher and report.

Why this software

  • One process, not many sheets

    Manual reconciliation often relies on multiple Excel sheets for comparing records, calculating differences and preparing vouchers. Here, users upload the source files, run the reconciliation and generate the related voucher and report in one process.

  • Less repetitive work

    Reduces repetitive effort while making results easier to verify and trace.

  • Wide source coverage

    Reconcile settlement from VISA, Mastercard, settlement reports, NPSB, Q-Cash or ITCL switch reports, bank statements, core banking and general ledger exports.

Reconciliation Workflow

  • Collect

    Obtain reports from card networks, switches, bank systems and more.

  • Import

    Upload Excel files and apply the relevant template.

  • Reconcile

    Match transactions and calculate differences.

  • Review

    Examine unmatched items and exceptions.

  • Report

    Produce reconciliation reports and vouchers.

Payment Channels Covered

  • VISA Card

    Matches individual VISA transactions with bank entries using references, dates and amounts. Missing, duplicate and mismatched records are identified separately.

  • Mastercard

    Compares Mastercard clearing and settlement data with bank records, including transaction totals, settlement amounts and outstanding differences.

  • NPSB

    Reconciles National Payment Switch Bangladesh activity against bank-side records, showing matched, unmatched and settlement positions.

  • Q-Cash / ITCL

    Checks Q-Cash / ITCL switch activity and settlement figures against related bank entries to identify and explain differences.

Daily Operations & Oversight

  • Dashboard

    Shows reconciliation activity across all payment channels, including processed runs, matched and pending items, and differences needing attention. Users can open the underlying records from the overview.

  • Business analytics

    Summarizes channel activity, recurring differences, pending-item trends and settlement performance for operational and management review.

  • No spreadsheet rebuilds

    Teams can review completed processing and outstanding items without rebuilding the figures in separate spreadsheets.

Vouchers & Reports

  • Accounting voucher

    Once a reconciliation run is processed, the system generates its accounting voucher from the calculated results.

  • Reconciliation report

    Generated from the same results, and tied to the relevant channel, processing period and supporting transaction data.

Core Functions

  • Configuration templates

    Define source-file formats, field mappings and channel-specific calculation settings.

  • Reconciliation runs

    Process uploaded records by channel and period, retaining inputs and calculated results together.

  • Bank system reconciliation

    Compare network or switch positions with the bank's transactions and balances.

  • Review and evidence

    Track unmatched records, differences and the supporting reconciliation information.

Results for Each Cycle

  • Matched

    Transactions and amounts that agree under the reconciliation rules.

  • Difference

    Records or amounts that require investigation or adjustment.

  • Pending

    Items awaiting resolution or a later settlement check.

Ready to see Bank Reconciliation in action?

Book a free session with our team. We'll walk you through Bank Reconciliation and show how it fits the way you work.

  • No obligation
  • Free consultation
  • Odoo experts
Ali Hayder Mohin

Ali Hayder Mohin

Business Development Manager