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 CategoryKey Fields Visible
Document DetailsBill No, Bill Date, Supplier Bill No, Supplier Date, Unit, and Doc Sub-No.
Taxation AuditTaxable Value, CGST, SGST, IGST, TCS, TDS, and HSN/SAC Codes.
Financial ValuesAmount (Before Tax), Net Value (Post Tax), Discount, Freight, and Round Off.
Product AttributesItem Short Name, Item Group, Qty, Rate, and Non-Standard Notes.

4. Source Transactions 🔄

The reporting engine aggregates data from:

  1. Purchase Bill Module: The core source for booked liabilities, item costs, and taxes.
  2. Debit / Credit Notes: Adjustments for material returns and commercial rate differences.
  3. Taxation Masters: Integrated GST rates, TDS tax slabs, and statutory classifications.
  4. 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.