Filters and options in the Vendor Payments report
A complete reference to all filters and settings you can use to customize the report.
Jul 11, 2026
The Vendor Payments report provides several filters and options to help you focus on the data you need. Below is a complete reference.
Report Filters
| Filter | Description | Values |
|---|---|---|
| Date Range | Select the start and end dates for the period you want to review. | Dates (e.g., 2026-01-01 to 2026-06-30) or preset ranges (Today, This Week, This Month, This Year). |
| Vendors | Filter by specific vendor(s). Leave blank to include all vendors. | Vendor names or IDs; use multi-select if available. |
| Payment Method | Filter by how the payment was made. | Bank Transfer, Cash, Check, or other payment methods enabled in your system. |
| Payment Status | Filter by the status of the payment. | Completed, Pending, Cancelled, or All. |
| Currency | Filter by payment currency (in multi-currency environments). | Select one or more currencies. Leave blank to show all. |
| Reference Number | Search for a specific payment by its reference or cheque number. | Free-text search or exact match. |
Display & Sorting Options
| Option | Description |
|---|---|
| Group By | Organize the report by Vendor, Payment Method, Date, or None (flat list). |
| Sort Order | Sort by Date (ascending/descending), Vendor Name, or Amount. |
| Columns Shown | Toggle visibility of optional columns such as Due Date, Invoice Reference, or Payment Note. |
Export & Print Options
| Option | Description |
|---|---|
| Export Format | Choose Excel (.xlsx), CSV (.csv), or PDF for download. |
| Include Totals | Include a summary row with total payments and count of transactions. |
| Print Template | Select a print layout (Detailed, Summary, or Custom). |
Tips for effective filtering
- Use date filters to focus: narrow the range to the month or quarter you want to analyze.
- Group by vendor: if you want to see total spending per vendor quickly, choose "Group By: Vendor."
- Filter by payment method: use this to verify that your business follows the intended payment policy (e.g., all large payments via bank, all small payments via cash).
- Search by reference: if you need to find a specific payment, use the Reference Number field instead of scrolling through a long list.
Was this helpful?