Reading and interpreting the Vendor Payments report

The Vendor Payments report is a table that lists every payment your business made to vendors during a selected period. Understanding how to read this report helps you verify payment history, spot unusual patterns, and manage vendor relationships effectively.

What the report shows

The Vendor Payments report displays one row per payment transaction. Each row contains:

• Vendor Name: the name of the vendor who received the payment.
• Payment Date: the date the payment was made (when the money left your account).
• Amount: the payment amount in your selected currency.
• Payment Method: how the payment was made (e.g., Bank Transfer, Cash, Check).
• Reference/Cheque Number: a unique identifier for the payment if applicable.
• Status: whether the payment is completed, pending, or cancelled.

How it works in Usystems

When you record a payment to a vendor in Usystems, the system:

1. Records the transaction in the accounting journal.
2. Debits the Accounts Payable account (liability decreases).
3. Credits the payment method account (e.g., Bank Account, Cash Box).
4. Tags the transaction with the vendor name and payment date.

The Vendor Payments report pulls all these tagged transactions and sorts them by date, vendor, or payment method depending on your filter choices.

What to look for

• Total payments per vendor: look at the sum of amounts for each vendor to understand which vendors you rely on most and how much you spend with them.
• Payment frequency: check if payments are regular (e.g., monthly) or irregular, which may indicate supply patterns or cash flow challenges.
• Payment method distribution: if most payments are cash but your policy is bank transfers, you may need to tighten payment controls.
• Overdue payments: if a vendor has no recent payments but you receive regular invoices, you may have an unpaid balance (check the accounts payable aging report).

Where you see it in Usystems

Access the Vendor Payments report at Reports → Vendor Payments Report. Open in Usystems

You can also drill down into individual payments by clicking a payment row (if available) to see the original bill or invoice that triggered the payment.