Supplier outstanding & payment reconciliation

When to use this: the weekly payment run — who to pay, how much, and whether the books match.

Steps — Supplier Outstanding

Open Reports → Supplier Outstanding. Click Reports in the left menu, then click Supplier Outstanding from the list.

On this image: 1 shows the four summary cards; 2 is the filter row; 3 shows supplier balances by aging bracket and the row expand controls; and 4 exports the filtered report.
Read the top cards. Four cards show: Total Due, Overdue, number of Suppliers, and how much is Due in 7 days.
Narrow it down. Use the filter row: Store (all stores, or one store), Category, Aging bracket (Overdue, 0–30, 31–60, 61–90, 90+ days), and a Min balance amount. Click Apply after typing a min balance.
Look at one supplier's invoices. Click a supplier's row to expand it and see every open invoice: invoice date, due date, age in days, invoice amount, credits applied, and what's still outstanding.

On this image: 1 is an expanded supplier row; 2 lists its open invoices, dates, credits, and outstanding amounts; and 3 shows another supplier expanded with its own invoice details.
Pay the ones due, and record the payment (→ PUR-06).
Export. Use Export CSV, Export Excel, or Export PDF at the top — this exports every supplier matching your current filters, not just the page on screen.

Open Reports → Payment Reconciliation. Click Reports in the left menu, then click Payment Reconciliation. It defaults to today.

On this image: 1 sets the date range; 2 shows captured collections and their total; 3 lists payments that were not captured; and 4 exports the report.
Read Captured Collections. This totals what actually came in, by payment method (Cash, UPI, Card, Credit). UPI is broken down further by how it was collected (manual entry, dynamic QR, static QR) when there's more than one source.
Check Not Captured. This lists payments that are pending, failed, or expired — shown separately so they're never counted in your total. Nothing here means everything is captured. Follow up on anything listed.
Export. Click Export CSV, Export Excel, or Export PDF at the top right.

Review open claims in the same sitting (→ PUR-08) — offset them against payments where the supplier agrees.
When you pick a single store on Supplier Outstanding, a note explains that supplier payments and credit notes are recorded org-wide and get applied to the oldest invoices first — so a store's figure may look different from what you'd expect. Picking All Stores always gives the exact total.