# Supplier Wise Payment
Supplier-consolidated payments for a period — cash purchases, payment vouchers, cleared cheques, discounts, and other payments in one row per supplier.
Overview
Go to Purchase → Reports → Supplier Wise Payment.
Report title in ERP: Supplier Wise Payment Report
What it shows. The same payment sources as the Payment Report, summed by supplier: cash purchases, payment vouchers, cleared cheques, adjustments/discounts, other payments, and total payment. Cash Account is not shown — one supplier can be paid from several cash or bank accounts.
When to use it. Use for monthly or period payment review by supplier, and click a supplier to open the bill-level detail in the Payment Report.
How amounts are calculated. Same payment sources as the Payment Report (approved/closed cash purchases, payment vouchers against purchase invoices, cleared cheques, and custom payment vouchers to a supplier), summed by supplier. Click a supplier for the bill-level breakdown.
Use Cases
- Accounts payable — How much did we pay each supplier this month? Run for the month and sort by Total Payment.
- Accounts team — How much of the period went out as payment vouchers vs cheques vs cash purchases? Compare the column totals.
- Finance manager — What are other payments (custom payment vouchers) by supplier? Use the Other Payments column.
- Purchase manager — Drill from a supplier total into the individual bills and vouchers. Click the supplier name.
Filters
Date, Employee, PayMode (how the payment was made: All, Cash, Bank, Digital Wallet). Advanced Filter: Supplier (one or more), Supplier Group, FormType (purchase type on the invoice), Branch.
The date range is limited to 6 months.
Columns
| **Column** | **Description** |
|------------|-----------------|
| SL No | Row number. |
| Supplier Code | Supplier code. Click to open the Payment Report for that supplier. |
| Supplier Name | Supplier name. Click to open the Payment Report for that supplier. |
| Cash Purchase | Cash, bank, or wallet purchase invoices. |
| Payment Voucher | Supplier payments applied to purchase invoices (not cheque or post-dated cheque). |
| Cheque | Issued cheques cleared in the period (by cleared date). |
| Adjustments/ Discounts(-) | Cash discounts and adjustments on payments. |
| Other Payments | Custom payment vouchers to the supplier, not tied to a purchase invoice. |
| Total Payment | Cash Purchase + Payment Voucher + Cheque − Discounts + Other Payments. |
Issued PDC & Open Cheques
Cheques issued in the period that are not yet cleared, including post-dated cheques (PDC). Grouped by supplier with separate PDC and Open amounts. These amounts are not in Total Payment.
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
- Click supplier code or name — open the Payment Report filtered to that supplier for the same dates
FAQ
Why is there no Cash Account column?
A supplier can be paid from more than one cash or bank account. The Payment Report still shows Cash Account on each row.
How is this different from the Payment Report?
This report is one row per supplier. The Payment Report is one row per bill or voucher. Totals for the same dates and filters match, except that a Supplier Group filter here also applies to cheques.
Are open or PDC cheques in Total Payment?
No. They appear only in the Issued PDC & Open Cheques section. Cleared cheques use the cleared date and go in the Cheque column.
What are Other Payments?
Custom payment vouchers to a supplier that are not allocated to a purchase invoice. On the Payment Report they appear under Other Payment Vouchers.
What is the "Others" row?
Payments or cheques that could not be linked to a supplier. It is hidden when a Supplier or Supplier Group filter is applied.