# Payment Report
Supplier payment activity for a period, including payment vouchers against bills and a separate view of collected PDC and open cheques.
Overview
Go to Purchase → Reports → Payment Report.
Report title in ERP: Payment Report
What it shows. Two sections: Payment Details lists payments made against supplier bills with voucher, cheque, and adjustment amounts; Collected PDC & Open Cheques lists post-dated and open cheques with clearance status.
When to use it. Use to reconcile supplier payments, track cheque clearances, and review discounts or adjustments applied during payment.
Screenshot pending — Payment Report view.
Use Cases
- Accounts payable — Which supplier bills were paid this week and through which cash account? Run after posting payment vouchers.
- Treasury team — Which PDC cheques are still open or pending clearance? Run daily or weekly for cheque follow-up.
- Finance manager — How much was paid to suppliers net of adjustments and discounts? Run at month-end for cash-outflow analysis.
- Auditor — Can every payment be traced to a bill, voucher, and cheque reference? Run during accounts payable audit.
Filters
Date, Supplier, Cash Account. Advanced Filter: Branch, Center, Payment Mode, Cheque Status.
Columns
Payment Details
| **Column** | **Description** |
|------------|-----------------|
| Date | Payment date. |
| Bill No | Supplier bill or invoice paid. |
| Bill Date | Original bill date. |
| Bill Value | Total value of the supplier bill. |
| Supplier Name | Supplier receiving the payment. |
| Cash Account | Cash or bank account used. |
| Cash Purchase | Indicates a direct cash purchase settlement. |
| Payment Voucher | Linked payment voucher number. |
| Cheque | Cheque details when payment was by cheque. |
| Adjustments / Discounts (-) | Adjustments or discounts applied on payment. |
| Total Collection | Net amount paid after adjustments. |
Collected PDC & Open Cheques
| **Column** | **Description** |
|------------|-----------------|
| Issued Date | Date the cheque was issued. |
| Cheque Date | Date on the cheque. |
| Supplier | Supplier linked to the cheque. |
| Payment Voucher | Payment voucher reference. |
| Cheque No. | Cheque number. |
| PDC | Whether the cheque is post-dated. |
| Open | Whether the cheque is still open. |
| Status | Cheque status (Cleared, Pending, Bounced, Cancelled). |
Actions
- Generate — run the report for the selected filters
- Export — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
What is the difference between the two sections?
Payment Details shows completed payment transactions. Collected PDC & Open Cheques tracks cheques not yet fully cleared or still outstanding.
Why is Adjustments / Discounts shown as negative?
It represents amounts reduced from the bill at payment time, such as settlement discounts or debit adjustments.
Can I filter payments by bank account?
Yes. Use Cash Account on the main filter bar.
Where do I record new supplier payments?
Create them in Accounts → Payment Voucher and link to purchase bills from the voucher screen.
Which payment voucher types appear?
Payments linked to purchase invoices, orders, debit notes, purchase expenses, and other purchase payables in the selected period.
Why is my report empty?
No payment vouchers match the date range, cash account, or branch filters.
Are draft payment vouchers included?
No. Only approved or cleared payment transactions appear in payment details.