Daily Collection Report
Daily Collection Report - User Guide
1. Introduction 📊
The Daily Collection Report is an operational audit tool used by Site Managers and Society Treasurers. It provides a real-time view of all liquidity entering the society’s accounts—whether via cash, cheque, or electronic transfer.
ℹ️
Purpose of this Report:
- Cash Reconciliation: Match the “Cash in Hand” against the physical cash box at the end of every day.
- Cheque Tracking: Ensure all received cheques are recorded and ready for bank deposit.
- Online Verification: Cross-verify NEFT/IMPS transfers recorded in the system against bank statements.
- Staff Accountability: Tracking which staff member received which payment.
2. Analysis Use Cases 🚀
The report is primarily used for daily financial control:
A. End-of-Day Balancing
- Process: Accountants generate this report to see the total number of collections for the day.
- Verification: The total “Cash” amount on the report must match the actual physical cash received at the site office.
B. Cheque Deposit Register
- Process: Use the report to prepare bank deposit slips.
- Verification: The report lists specific Cheque Numbers and Dates, ensuring no cheques are missed during the deposit process.
C. Collection Performance
- Process: Management uses the report to track collection spikes (usually in the first 10 days of the month after invoices are issued).
3. Data Visibility & Insights 🔍
Each report provides comprehensive data fields to support deep-dive analysis:
| Data Category | Key Fields Visible |
|---|---|
| Payer Info | Member Name, Flat Number, and Building Name. |
| Voucher Info | Voucher Number, Voucher Date, and Mode of Payment (Cash/Bank). |
| Payment Details | Cheque/Ref Number, Bank Name, and Instrument Date. |
| Financials | Amount Received, Discount (if any), and Net Cleared Amount. |
| Metadata | Date and Time of Entry, and the User ID of the operator who recorded the receipt. |
4. Source Transactions 🔄
The report derives its data from:
- Voucher Receipts: The core transaction where member payments are recorded.
- Daily Activity Log: Complements the collection report with staff shift details.
5. Using the Report Interface 🛠️
Selection Filters
- Date Range: Typically select “Today” for daily balancing or a 7-day range for weekly deposit reviews.
Generation Mode
- Print (Excel): Generates a high-fidelity Excel file (
.xlsx). It includes subtotals by payment mode (Total Cash vs. Total Bank) to make banking easier.
6. Best Practices / Tips 💡
- The Golden Rule: Never leave the office without matching the Daily Collection Report to your physical cash box and cheque pile.
- Audit NEFT: For online transfers, use the report to mark off items as “Cleared” once they appear on the society’s e-statement.
- Operator Tracking: Use the “Staff Name” column to identify which office member handled specific cash transactions in case of discrepancies.
- Deposit Validation: Attach a copy of this report to your bank deposit pay-in slips for an airtight audit trail.