BitMed Logo
Setup & ManagementOwner

Supplier outstanding & payment reconciliation

On this page

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

Steps — Supplier Outstanding

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

  2. Read the top cards. Four cards show: Total Due, Overdue, number of Suppliers, and how much is Due in 7 days.

  3. 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.

  4. 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.

  5. Pay the ones due, and record the payment (→ PUR-06).

  6. Export. Use Export CSV or Export Excel at the top — this exports every supplier matching your current filters, not just the page on screen.

Steps — Payment Reconciliation

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

  2. 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.

  3. 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.

  4. Export. Click Export CSV at the top right.

Good to know

  • 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.
BitMed AI