# Order Wise Purchase Report
Lists purchases linked to each purchase order with financial totals, supplier details, and outstanding balances. Use it to track order fulfillment, audit procurement activity, and reconcile amounts against approved POs.
Overview
Go to Purchase → Order Reports → Order Wise Purchase.
What it shows. One row per purchase linked to a purchase order, including order number, dates, in-charge employee, supplier, tax registration, and full financial breakdown (amount, discount, tax, bill total, balance).
When to use it. Review how much has been invoiced against each PO, identify orders with pending balances, and monitor procurement activity by supplier or employee.
Use Cases
- Month-end PO reconciliation — Compare billed amounts and balances against open purchase orders before closing the period.
- Supplier spend review — Filter by supplier to see all order-linked purchases and outstanding balances for a vendor.
- Employee accountability — Filter by in-charge to review purchases processed by each procurement employee.
- Audit trail — Export the report to verify that invoices match approved purchase orders and tax details.
Filters
- Date Range — Limit purchases to a specific period.
- Order No. — View purchases for one or more purchase orders.
- Supplier — Restrict results to selected suppliers.
- InCharge — Filter by the employee responsible for the purchase.
Columns
| **Column** | **Description** |
|------------|-----------------|
| **#** | Serial number of the report entry. |
| **Date** | Date of the purchase transaction or invoice. |
| **Order No.** | Purchase order number linked to the purchase. |
| **Due Date** | Expected delivery or fulfillment date. |
| **InCharge** | Employee responsible for processing the purchase. |
| **Supplier** | Supplier associated with the order. |
| **Tax Reg.No** | Supplier tax registration number. |
| **Amount** | Purchase amount before discount and tax. |
| **Discount** | Total discount applied. |
| **Taxable Amount** | Amount subject to tax after discount. |
| **Tax Amount** | Tax on the taxable amount. |
| **Sub Total** | Amount including discount and tax before rounding. |
| **Bill Total** | Final bill total including all charges. |
| **Balance** | Remaining balance pending against the purchase order. |
Actions
- View Details — Open the full purchase invoice linked to the order.
- Export — Download to Excel or PDF for accounting or audit.
- Filter & Sort — Refine by order, date, supplier, or in-charge.
FAQ
Why does a purchase order show a balance?
A balance appears when the invoiced amount is less than the order total, or when partial billing leaves an outstanding amount on the PO.
Can I see purchases for a single PO?
Yes. Use the Order No. filter to restrict the report to that purchase order.
Does this report include purchase returns?
It focuses on purchase invoices linked to orders. Use purchase return reports for return-specific analysis.
How is bill total different from sub total?
Sub total is the pre-rounding total; bill total is the final payable amount after rounding and any additional charges on the invoice.
Which order and invoice statuses are included?
Typically Approved and Closed purchase orders and their linked invoices. Draft and Cancelled documents are excluded unless your filter includes them.
Why is my report empty?
No purchase orders or linked invoices match the date range and filters — for example supplier, branch, or order number.
Why does an order show without an invoice?
The PO may be approved but not yet invoiced, or only partially invoiced. Check order status and use Received and Not Invoiced for receipt-only orders.