Purchase Analysis Report
Purchase Analysis Report - User Guide
1. Introduction đ
The Purchase Analysis Report is the primary financial and analytical module for managing the organization’s procurement expenditure. It provides a multi-dimensional view of liabilities, tax compliance, and material costs.
âšī¸
Purpose of this Report:
- Financial Reconciliation: Match purchase bills with taxes (GST/TDS/TCS) and net outstandings.
- Cost Analysis: Breakdown procurement spend by product, item group, and vendor.
- Tax Compliance: Generate schedules for TDS and TCS payments.
- Trend Monitoring: Analyze monthly procurement peaks and valleys to manage cash flow.
This module is essential for Purchase Managers, Finance Controllers, and Tax Auditors.
2. Report Options & Analytical Insights đ
The Purchase Analysis option screen provides 8 specialized report modes (A through H):
Option A: Purchase By Bill
- Purpose: A comprehensive invoice-level audit of all purchase documents.
- Components: Aggregates Purchase Bills, Purchase Debit/Credit Notes (DNCN), and verifies eligible Input Tax Credit (ITC).
- Best For: Reconciling the Accounts Payable (AP) ledger for monthly closures.
Option B: Purchase By Product
- Purpose: Item-level breakdown of procurement spending across materials, parts, and consumables.
- Analysis Sheets:
- Product Details: Transaction-by-transaction log of every item billed.
- Summaries: Ranked views showing Top Items, Top Item Groups, and Top Vendors by total expenditure.
- Best For: Negotiating volume-discount contracts and identifying cost drivers.
Option C: TDS Payable
- Purpose: Dedicated statutory compliance schedule for Tax Deducted at Source (TDS).
- Key Fields: Vendor PAN Number, Section Code, Taxable Value, TDS Rate, and Tax Deducted.
- Best For: Filing quarterly TDS returns (Form 26Q) and monthly deposit challans.
Option D: Month-Wise Summary
- Purpose: Strategic monthly trend analysis of procurement spend across the fiscal year.
- Best For: Cash flow forecasting and annual budgeting comparisons.
Option E: TCS Payable / Receivable
- Purpose: Tracks Tax Collected at Source (TCS) levied by suppliers on high-value transactions.
- Best For: Ensuring accurate credit matching in income tax filings.
Option F: GST Bills Payment Details
- Purpose: Tracks payment status and bank release dates for GST-compliant vendor invoices to ensure compliance with the statutory 180-day vendor payment window.
Option G: Bill-Wise QA Analysis
- Purpose: Cross-references financial purchase bills against Quality Assurance inspection reports (Accepted vs. Rejected quantities).
- Best For: Ensuring finance does not authorize full payments for consignments with disputed quality.
Option H: DPR Machine Maintenance
- Purpose: (Conditionally enabled when machine maintenance tracking is configured) Tracks purchase expenses specifically allocated to machine maintenance, breakdown spares, and daily production maintenance logs.
3. Data Visibility & Audit Fields đ
| Data Category | Key Fields Visible |
|---|---|
| Document Details | Bill No, Bill Date, Supplier Bill No, Supplier Date, Unit, and Doc Sub-No. |
| Taxation Audit | Taxable Value, CGST, SGST, IGST, TCS, TDS, and HSN/SAC Codes. |
| Financial Values | Amount (Before Tax), Net Value (Post Tax), Discount, Freight, and Round Off. |
| Product Attributes | Item Short Name, Item Group, Qty, Rate, and Non-Standard Notes. |
4. Source Transactions đ
The reporting engine aggregates data from:
- Purchase Bill Module: The core source for booked liabilities, item costs, and taxes.
- Debit / Credit Notes: Adjustments for material returns and commercial rate differences.
- Taxation Masters: Integrated GST rates, TDS tax slabs, and statutory classifications.
- Accounting Ledgers: Links vendor transactions to General Ledger expense heads and cost centers.
5. Report Options & Filters đ ī¸
- Option Selection: Choose from Options A through H based on the analytical requirement.
- Unit Filter: Run for a single manufacturing facility or consolidate all locations across the company.
- Filter Criteria: Filter by Vendor (Party), Party Group, Item Group, or individual Item.
- Accounts Particulars: For maintenance-specific reports, filter by specific General Ledger accounts.
6. Best Practices / Tips đĄ
- Identify Over-Spending: Use the Purchase By Product summary. Sort by “Amount DESC” to immediately see which raw materials are consuming the most capital.
- Prevent Tax Penalties: Run the TDS Payable report at the end of every week to ensure taxes are provisioned before payments are released to vendors.
- QA Integration: Always review the Bill-Wise QA Analysis before authorizing high-value payments. Avoid paying for batches that have high rejection rates in the QA module.
- Bill Error Audit: Check the IsError column in the Purchase By Bill report. It flags cases where the Total Bill Amount in the system does not match the Supplier Bill Amount, indicating a manual entry error.