Order vs Bill
Compare visit orders, billed quantity and stock movementHow statuses are decided
Match Ordered, billed and movement quantities agree within the tolerance set above.
Short Billed Billed quantity is less than the order.
Excess Billed Billed quantity is more than the order.
Not Billed Order taken but nothing billed.
Product Mismatch Billed product differs from the ordered product.
Stock Variance Physical stock is higher than the books (movement below zero).
Reconciliation List
7 Records
| # | Visit | Medical Store | Product | Order Qty | Billed Qty | Movement | Difference | Billed Value (₹) | Movement Value (₹) | Variance (₹) | Status | Verification | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | #101 | City Medical Store | Paracip 500 Tab | 60 | 60 | 30 | 0 | 2,550.00 | 1,275.00 | 1,275.00 | Match | Verified | |
| 2 | #101 | City Medical Store | Amoxy-CV 625 | 50 | 30 | 45 | -20 | 3,540.00 | 5,310.00 | -1,770.00 | Short Billed | Pending Review | |
| 3 | #102 | Health Plus Pharmacy | Calcibone Plus | 20 | 35 | 10 | +15 | 3,360.00 | 960.00 | 2,400.00 | Excess Billed | Pending Review | |
| 4 | #103 | Jeevan Medicos | Cetzin 10 | 30 | 0 | 20 | -30 | 0.00 | 360.00 | -360.00 | Not Billed | Variance | |
| 5 | #103 | Jeevan Medicos | Azithro 500 | 40 | 40 | -5 | 0 | 2,980.00 | -372.50 | 3,352.50 | Stock Variance | Variance | |
| 6 | #104 | Royal Medical Hall | Zeroflam SP | 40 | 25 | 25 | -15 | 1,625.00 | 1,625.00 | 0.00 | Partial | Pending Review | |
| 7 | #105 | City Medical Store | Pantocid DSR | 40 | 40 | 40 | 0 | 3,840.00 | 3,840.00 | 0.00 | Match | Verified |