# Purchase Report
Bill-wise purchase summary for a selected period. Lists each purchase invoice with supplier, payment mode, tax, discount, and balance so you can review procurement spend and outstanding payables.
Overview
Go to Purchase → Reports → Purchase Report.
Report title in ERP: Bill Wise Purchase
What it shows. One row per purchase invoice with supplier details, payment mode split (Cash, Bank, Credit), tax and discount amounts, and the remaining balance. Click an invoice number to open the full purchase invoice.
When to use it. Use for daily purchase review, month-end payables reconciliation, and supplier payment follow-up.
Screenshot pending — Bill Wise Purchase report list view.
Use Cases
- Accounts payable team — Which supplier invoices are still unpaid, and how much is outstanding by payment mode? Run at month-end or before payment runs.
- Purchase manager — How much did we buy from each supplier this month, including discounts and tax? Run weekly or monthly for spend review.
- Finance auditor — Do recorded purchase bills match supplier invoices and tax registration details? Run during VAT/GST reconciliation or internal audits.
- Branch in-charge — What purchases were booked at my center in a given period? Run when reviewing branch-level procurement.
Filters
Date, PayMode (All, Credit, Cash, Bank, Prepaid, Digital Wallet), Employee. Advanced Filter: Supplier, Supplier Group, Branch, Center, Project, Item, Item Group, Form Type.
Columns
| **Column** | **Description** |
|------------|-----------------|
| Date | Purchase invoice date. |
| Inv No. | System purchase invoice number. Click to open the invoice. |
| Supp. Inv | Supplier invoice or bill reference number. |
| PayMode | Payment mode for the bill (Cash, Bank, Credit, etc.). |
| Center | Billing or business center. |
| InCharge | Employee in charge of the purchase. |
| Supplier | Supplier name. |
| Tax Reg. No | Supplier tax registration number. |
| Amount | Gross amount before discount and tax. |
| Discount | Discount applied on the invoice. |
| Amount w/o Tax | Net amount before tax. |
| Sub Total | Subtotal after discount, before final tax total. |
| Bill Total | Final invoice total including tax. |
| Cash | Amount settled through cash. |
| Bank | Amount settled through bank or cheque. |
| Credit | Unpaid or credit portion. |
| Balance | Outstanding balance on the invoice. |
Actions
- Generate — run the report for the selected filters
- Export — export to Excel
- Print — print the report
- Advanced Filter — open additional filter fields
- clear — reset active advanced filters
FAQ
How do I open a purchase invoice from this report?
Click the Inv No. link on any row to open the full purchase invoice.
Why does one bill show amounts in Cash, Bank, and Credit?
The report splits how the bill was paid or remains due. The Balance column shows what is still payable.
Can I filter only credit purchases?
Yes. Set PayMode to Credit before generating the report.
What is the difference between this report and Purchase Report Adv?
This report is bill-level only. Purchase Report Adv includes item and batch detail on each line.
Which invoice statuses are included?
Approved and Closed purchase invoices only. Draft and Cancelled invoices are excluded.
Why is my report empty?
No approved or closed invoices match the date range and filters. Widen the date range or clear advanced filters such as supplier group or branch.
Does supplier group filter include sub-groups?
Yes. Selecting a parent supplier group typically includes suppliers in child groups as well.