CASHBOOK - CBS Data Reconciliation Tool for SBCO V.1.07

This tool can be used to find discrepancies / non-accounted CBS figures in APT 2.0 cashbook. It is free to use and offered "as is", without warranty or promise of support of any kind. Use at your own risk.

Changelog

v.1.07.8

• Fixed mismatch error in single entry finacle reports
• Calendar date will resume from last active date instead of current date

v.1.07.7

• Multi region support enabled
• Fixed finacle report upload error for office names having hyphen (-)

v.1.07.6

• Fixed error in office template
• Added option for HOs having more than one offices with same office name
• Added Print option and data Sort option
• Office data settings modified to support HOs with similar named Branch Offices
• Fixed single entry apt report upload issue

Requirements

• MS Office 2007 or above (enable macros)
• Trusted location access may be required for higher versions (365/2024+)
• PC region should be "English (India)"

Required Reports

For A/c Code wise discrepancies

1. Finacle MIS → GL IT2.0 Transaction GL Wise Report (Incl HO, SO & BOs) - Consolidated - SET ID based (XLS format)
2. CashBook (XLS format)

For Office wise discrepancies

1. Finacle MIS → GL IT2.0 Transaction GL Wise Report - Consolidated (Previous Day) - SET ID based (XLS format)
2. Accounting Details Report: APT Treasury → Reports → Accounting Details → A/c Code, Date: 01/07/2026, Office: All, Generate (XLS format)

Office Configuration Template

OFFICE_NAME	OFFICE_ID	SOL_ID	SOL_ID_GROUP
MODEL OFFICE HO	12345600	58345610	58345610
MODEL OFFICE 1 SO	12345601	58345611	58345611
MODEL OFFICE 1.1 BO	12345602		58345611
MODEL OFFICE 1.2 BO	12345603		58345611
MODEL OFFICE 2 SO	12345604	58345612	58345612
MODEL OFFICE 2.1 BO	12345605		58345612
MODEL OFFICE 2.2 BO	12345606		58345612

Notes

• Office Name: Modify if multiple offices have same name under HO
• SOL ID: Leave blank for Branch Offices
• SOL ID Group: For Branch Offices, enter SOL ID of respective Sub Office; for others, enter their own SOL ID

How to Use

Upload the corresponding reports in Excel format. A/c Code wise discrepancy report will be displayed automatically. For Office wise discrepancy, click on Reconcile Data button, configure offices and upload required reports.

Additional Information

• Not standalone software – may crash occasionally
• Manual backup option provided
• Data saved automatically for each report upload

Developer Info

Developed by: Suraj Kumar, System Admin, Manipal HO – 576101

Queries / Suggestions: skudp20@gmail.com

Disclaimer : The Developer/ Pulisher is not responsible for any kind of losses. Use at your own risk.

Download Cashbook and CBS Reconcilation Tool