Expense Bill - Cheque Bounce
📄 Expense Bill – Cheque Bounce Report
The Expense Bill – Cheque Bounce Report tracks all expense payments made via cheque that were returned or dishonored by the bank. This report ensures that the finance team can quickly identify failed payments to vendors, take corrective action, and maintain accurate expense and liability records.
🎯 Purpose of the Report
-
To monitor dishonored cheque payments related to expenses.
-
To assist in reconciliation between accounts payable and bank statements.
-
To help ensure vendor payment issues are resolved promptly.
-
To maintain a clear audit trail of bounced cheque incidents.
📌 Key Data Fields
| Field Name | Description |
|---|---|
| Bill No. / Expense Reference | Original expense bill linked to the bounced cheque. |
| Vendor Name | The payee/vendor to whom the cheque was issued. |
| Cheque Number | Unique cheque number that bounced. |
| Bank Name | Bank from which the cheque was issued. |
| Cheque Date | Date mentioned on the cheque. |
| Bounce Date | Date the bank returned the cheque. |
| Bounce Reason | Reason given by the bank (e.g., Insufficient Funds, Account Closed, Signature Mismatch). |
| Cheque Amount | Amount of the bounced cheque. |
| Status | Current resolution status (Pending, Resolved, Reissued). |
| Remarks | Additional notes from finance or accounts team. |
🔍 Filter & Search Options
-
Date range (based on cheque issue or bounce date).
-
Vendor name.
-
Bank name.
-
Bounce reason.
-
Payment status (Pending, Resolved).
📊 Insights Provided
-
Total bounced cheque value within a period.
-
Frequent bounce vendors for risk assessment.
-
Common bounce reasons for policy improvement.
-
Outstanding payments needing follow-up.
📤 Export & Integration
-
Exportable in Excel, PDF, CSV formats.
-
Can link with Expense Payments Report to reissue payments.
-
Integrates with Accounts Payable Aging to update outstanding balances.
📈 Example Layout
| Bill No. | Vendor Name | Cheque No. | Bank Name | Cheque Date | Bounce Date | Reason | Amount | Status |
|---|---|---|---|---|---|---|---|---|
| EB-2025-01 | ABC Supplies | 102345 | HDFC Bank | 05-Jan-2025 | 09-Jan-2025 | Insufficient Funds | 15,000.00 | Pending |
| EB-2025-04 | XYZ Printers | 102678 | ICICI Bank | 10-Jan-2025 | 13-Jan-2025 | Signature Mismatch | 7,500.00 | Resolved |
✅ Benefits
-
Prevents missed follow-ups on failed payments.
-
Maintains vendor trust by enabling timely resolution.
-
Supports audit readiness with a clear bounce record trail.
-
Helps detect patterns of cheque bounces for vendor risk evaluation.