RTGS / NEFT Register Report

RTGS / NEFT Register Report - User Guide

1. Introduction 💸

The RTGS / NEFT Register is a critical tool for modern finance departments. In an era where physical cheques are increasingly replaced by digital transfers, this module automates the generation of bank-ready payment instructions. It ensures that vendor bank details are correctly mapped and that payments once instructed are securely “Locked” to prevent accidental alteration.

ℹ️

Purpose of this Report:

Bank Upload Preparation: Generate Excel-based master sheets for bulk uploads to corporate banking portals (HDFC, ICICI, etc.).
Payment Advisory: Create formal payment advice for vendors including bill-wise breakup.
Security & Locking: Prevent the modification of accounting vouchers after the bank instruction is issued.
Compliance: Maintain a permanent NEFT Pay Log of all electronic transfers for audit verification.

This report is essential for Treasury Managers, Accounts Payable Teams, and CFOs.

2. Key Modules 🚀

A. RTGS / NEFT Register (Bank Instruction)

The Master Sheet: A flattened report containing all vendor bank details (Account No, IFSC, Branch) and the net amount to be paid.
Automatic Type Selection: The system identifies whether a transaction should follow RTGS (typically for amounts above ₹2 Lakhs) or NEFT (for smaller amounts) based on regulatory requirements.

B. Payment Register

The Internal Log: A chronological list of all electronic payments made from a specific bank account, used for internal matching with the bank statement.

3. Advanced Features & Controls 🛡️

Voucher Locking: When you generate a final bank instruction, selecting “Yes” for Lock RTGS / NEFT Vouchers will freeze those transactions. No one can change the amount, payee, or ledger in the ERP once the bank process has started.
Global Ref Update: You can enter a single batch ID (e.g., “NEFT-APR-26”) and the system will automatically update the “Cheque No” field for all selected vouchers in one click.
Invalid Party Warning: The report proactively identifies vendors who have a pending payment but missing bank details in the RTGS Master. This prevents “Failed Transfers” during the bank upload.
Payment Details (Bill Breakup): The report packs Bill Numbers and Narrations into the “Payment Details” column (up to 7 bills per transfer), ensuring your vendors know exactly which invoices you are paying.

4. Understanding Data Columns 📊

Beneficiary Name: The legal name as per the vendor’s bank records (used for verification against the ERP party name).
IFSC Code: The branch identifier for the recipient bank.
Amount: The final net amount to be transferred.
Customer Ref No: A unique internal tracking number sent to the bank.

5. Source Transactions 🔄

The reporting engine synthesizes data from:

Payment Vouchers: Transactions marked with Electronic Payment system codes (System Cheque 5/6).
RTGS Master (RtgsMst): The secure repository of vendor bank account numbers and IFSC codes.
NEFT Pay Log: The historical audit log of all locked transfers.

6. Best Practices / Tips 💡

The “Lock” Rule: Only select “Lock Voucher” when you are 100% sure the payment will be authorized. Once locked, the voucher becomes “Read Only” to maintain the audit trail integrity.
Data Verification First: Always run the report with “Lock: No” first. Check for any “INVALID DATA” markers in the Bank Account or IFSC columns. Fix these in the RTGS Master before doing the final locked run.
Bank Scheduler Integration: If your organization uses the ERP’s Automated Scheduler, ensure the “Lock” flag is checked. The scheduler only picks up “Posted” (Locked) vouchers for transmission to the bank.
The 2 Lakh Benchmarking: Keep an eye on the Trn Type column. If a high-priority payment is incorrectly listed as NEFT, check if the amount is exactly ₹2 Lakh—RTGS is usually required above this threshold for same-day clearance.

Cheque Register Report Budget & Cost Center Report