Docs
ERP Crystal
MFG
Finance
Reports
Cheque Register Report

Cheque Register Report

Cheque Register Report - User Guide

1. Introduction 📜

The Cheque Register Report is a dedicated auditing tool for the physical management of chequebooks. In a manufacturing environment where high-value payments are often made via physical instruments, tracking the status of every cheque leaf—whether issued, cancelled, or still unissued—is a critical security and compliance requirement.

ℹ️

Purpose of this Report:

  • Inventory Control: Identify how many cheques are remaining in a specific chequebook.
  • Payment Auditing: Link physical cheque numbers to specific transaction vouchers in the ERP.
  • Security Monitoring: Track “Cancelled” or “Stopped” cheques to prevent financial misuse.
  • Discrepancy Checks: Compare the written amount on a cheque with the amount recorded in the accounts books.

This report is essential for Accounts Executives, Store Keepers (managing instruments), and Internal Auditors.

2. Cheque Status Lifecycle 🔄

The system tracks every cheque leaf through the following statuses:

  • Issued (I): The cheque has been written and linked to a payment voucher.
  • Cancelled (C): The leaf was spoiled or made void (must be retained with the “Cancelled” stamp for audits).
  • Stopped (S): Instruction given to the bank to stop payment (e.g., due to loss or dispute).
  • Unissued (U): Fresh leaves still available in the chequebook.
  • Manual (M): Cheques written outside the system but later updated in the ERP.

3. Key Analysis Features 🛠️

  • Bank-Wise Segregation: Grouping of cheques by their issuing bank (e.g., HDFC, ICICI, SBI).
  • Payee Match-off:
    • Payee Name: The name physically written on the cheque leaf.
    • Ref Account Name: The actual Vendor or Ledger debited in the ERP.
    • Audit Use: Ensure that the person receiving the cheque matches the person being paid in the books.
  • Amount Verification: Lists both the Cheq Amount and Voucher Amount. These should always match unless a partial adjustment was made.

4. Understanding Data Columns 📊

  • Cheque No & Date: The unique serial number printed on the leaf and the date of issuance.
  • Voucher No: The internal ERP reference for the payment. Clicking this allows you to drill down into the full accounting entry.
  • Status Name: Provides the current system-level payment status (e.g., “Ready for Print,” “Signed,” “Dispatched”).
  • Division: Identifies which departement or factory unit issued the payment.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

  1. Cheque Master (Cheqmst): The physical inventory record of chequebooks.
  2. Voucher Module: The primary payment transaction record.
  3. Accounts Master: Standardized names for banks and vendors.

6. Best Practices / Tips 💡

  • The “Grey” Cheque Audit: Use the report to identify “Unissued” cheques. If a cheque number is missing from the “Issued” list but isn’t marked as “Cancelled,” it could signify a missing leaf that needs to be investigated.
  • Cancelled Cheque Log: For every “Cancelled” entry in the report, ensure the physical leaf is preserved in the accounts file with a clear “CANCELLED” marking.
  • Multi-Division Tracking: If you have multiple factory units using separate chequebooks from the same bank, use the Division Filter to isolate their usage patterns.
  • Reconciliation Prep: This report is a perfect companion to the Bank Reconciliation module, helping you identify exactly which cheque numbers are still “Uncleared.”
Journal Register ReportRTGS / NEFT Register Report