Reading and interpreting the Vendor Balance (Summary & Detail) report

What it is

The Vendor Balance report is a financial statement that lists each vendor and their current balance—the amount you owe them (positive balance) or the credit available from them (negative or prepaid balance).

Why it matters

Knowing your vendor balances helps you:

• Identify vendors with amounts due, so you can prioritize payments and manage cash flow.
• Spot vendors from whom you have credits or prepayments, which can reduce future payments.
• Understand your overall Accounts Payable position (the money you owe).
• Ensure you are paying vendors on time to maintain good relationships and avoid late payment penalties.

How it works in Usystems

The report is generated from your Accounts Payable (AP) ledger, which tracks all bills, payments, credit notes, and adjustments for each vendor.

In Summary view, you see:

• Vendor name (or code): The vendor's identifier.
• Balance: The net amount you owe (bills minus payments and credits you've applied).
• Currency: The invoice currency (if you use multiple currencies).

In Detail view, you also see:

• Transaction date: When each bill, payment, or adjustment occurred.
• Transaction type: e.g., Bill, Payment, Credit Note, or Adjustment.
• Amount: How much that transaction added to or reduced your payable balance.
• Running balance: The cumulative balance after each transaction.

Where you see it

Access the Vendor Balance report at Reports → Receivables & Payables Reports → Vendor Balance (Summary & Detail).

You can also access AP detail ledgers for a single vendor by opening the vendor's page and viewing their transaction history (if your system has that feature enabled).

Common balance scenarios

Positive balance (amount owed): You have unpaid bills from the vendor. Example: You owe a vendor 50,000 AFN.

Negative balance (credit/prepayment): You have paid the vendor in advance, or they issued a credit note. Example: You have a 5,000 AFN credit available from the vendor.

Zero balance: You have no outstanding transactions with the vendor (all bills paid or settled).