Cashbook Manager with Reconciliation

Cashbook Manager & Bank Reconciliation

MSIDC Division, Nashik

Total Credit (Receipts)
₹0.00
Total Debit (Payments)
₹0.00
Book Balance
₹0.00
Add Cashbook Entry
Cash Breakdown (Optional)
Bank Reconciliation Statement (BRS)
Adjusted Bank Balance: ₹0.00
Cashbook Balance: ₹0.00
Status: Mismatch
Cashbook Records
Date Voucher Particulars Credit Debit Cash Breakdown Action

Cashbook & Bank Reconciliation System

Comprehensive User & Technical Guide

1. System Overview

This web application is a client-side Cashbook Ledger & Bank Reconciliation Statement (BRS) Manager tailored for divisional accounting structures (e.g., MSIDC Nashik Division). It operates entirely within the browser using local storage, offering complete privacy and offline usability.

🔒 Offline & Local Storage

Data is stored locally using IndexedDB (CashbookReconDB). No external database or active internet connection is required for operation.

📑 Dual Cash & Bank Ledger

Supports tracking both direct bank credits/debits and itemized cash outlay categories like Land Cost, Stamp Duty, and Registration Fees.

⚖️ Automated Reconciliation

Computes adjusted bank balances instantly against monthly cashbook closing balances to check for ledger variances.

📄 Print-Ready Reports

Generates official, multi-page landscape PDF reports complete with month-wise cashbook tables, BRS summaries, and official signature panels.

2. How to Use the Application

A. Entering Cashbook Transactions

Fill in the transaction form at the top of the interface. Depending on the input type, values are routed to credit (receipt) or debit (payment):

  • Credit (Receipts): Enter the amount received directly in the Credit field.
  • Bank Debit (Payments): Enter direct bank payments in the Debit field.
  • Cash Breakdown Payments: For property or administrative acquisition entries, enter component costs under Land Cost, Stamp Duty, and Registration Fee. The application automatically tallies these into cashTotal and adds them to the total debit calculation.

B. Performing Monthly Bank Reconciliation (BRS)

Select the desired month from the date selector to load or edit reconciliation records:

  1. Input the ending balance from your official Bank Statement.
  2. Enter any Unpresented Cheques / Uncleared Payments (cheques issued by you but not yet cleared by the bank).
  3. Enter any Uncredited Deposits / Direct Credits (receipts deposited but not yet reflected in bank records).
  4. The system live-computes the Adjusted Bank Balance using the standard BRS formula:
Adjusted Bank Balance = Bank Statement Balance + Unpresented Cheques - Uncredited Deposits

Status Indicators:

  • Reconciled (Matched): Displayed when the Adjusted Bank Balance matches the computed Cashbook Closing Balance exactly (variance < ₹0.01).
  • Variance: ₹X,XXX.XX: Displayed when there is a mismatch between the adjusted bank balance and cashbook records.

3. Data Schema Reference

Below is the data structural model stored inside IndexedDB:

Field ID Data Type Description
date String (YYYY-MM-DD) Transaction entry date.
voucherNo String Official receipt/payment voucher index number.
particular String Description or party name ("Received From" / "Paid To").
credit Number Receipts/credits into the bank or cash account.
debit Number Total Debit (Base Debit + Itemized Cash Total).
landCost / stampDuty / registrationFee Number Itemized cash component breakdown for asset purchases.
classificationCode String Accounting head or budget classification code.

4. Data Portability & Backup

Because data lives entirely inside the browser's storage, clearing browser cache can delete records. Use the data control functions routinely:

📤 Export JSON Data

Clicking Export JSON compiles all ledger entries and monthly reconciliation records into a structured .json file downloaded directly to your device.

📥 Import JSON Data

Allows restoring previously exported JSON files. Imported entries are sequentially merged into the active database without replacing untouched items.

🗑️ Clear All Data

Permanently empties both stores (entries and reconciliations). Use with caution!

5. PDF Report Generation

The application features a built-in printing engine using html2pdf.js configured specifically for standard accounting registers:

  • Page Layout: Legal Landscape mode (14" x 8.5") with custom narrow margins.
  • Month-by-Month Splitting: Automatically groups transactions by month, computes Opening Balance B/F, monthly receipt totals, monthly payment totals, and carries forward the Closing Balance C/F to consecutive months.
  • Embedded BRS Summary: Appends the formatted Bank Reconciliation Statement table directly under each month's ledger.
  • Verification Panel: Includes standard statutory certification statements alongside digital signature boxes for Preparer, Checker, and Verifier roles.
Note: Ensure popup blockers allow printing triggers and the html2pdf.js dependency is loaded in your page header for report downloads to function correctly.