Purchase Analysis Report

Purchase Analysis Report - User Guide

1. Introduction 📊

The Purchase Analysis Report is a vital tool for Society Treasurers, Accountants, and Auditors. It provides a structured view of all society outflows, helping the committee track expenses, manage vendor relationships, and ensure accurate TDS/GST reporting.

This report helps societies maintain fiscal discipline by providing transparent data on where every rupee is spent.

---

2. Report Types & Analysis Use Cases 🚀

The module offers five specialized report types to support different administrative needs:

A. Purchase By Bill

• Purpose: A detailed list of individual bills received from vendors within a period.
• Best For: Verifying specific project costs or checking if a particular vendor’s bill was recorded.
• Key Data: Bill No, Date, Vendor Name, Basic Amount, Tax, and Total Bill Value.

B. TDS From Bill Register

• Purpose: Specifically filters bills where Tax Deducted at Source (TDS) was applied.
• Best For: Quarterly TDS Filings and ensuring the society has deducted the correct amounts for contractors/professional services.
• Key Data: Vendor PAN, Bill Amount, TDS Type, and TDS Amount Deducted.

C. Purchase Register

• Purpose: The master chronological log of all acquisitions made by the society.
• Best For: Annual Audits and a general “Purchase Register” requirement for society records.
• Key Data: Date-wise listing of all expenses, including both goods and services.

D. GST Bills Payment Details

• Purpose: Connects purchase bills with their corresponding GST payments/details.
• Best For: Reconciling GST Input Tax Credit (ITC) for the society.
• Key Data: Bill Reference, Vendor GSTIN, Tax components (CGST/SGST/IGST), and Payment status.

E. Month-Wise Summary

• Purpose: Aggregates all expenses into monthly buckets.
• Best For: Financial Trend Analysis and comparing seasonal variations (e.g., higher water tank cleaning costs in summers).
• Key Data: Month name, Total Volume, Total Amount, and Year-on-Year comparisons.

---

3. Data Visibility & Insights 🔍

Each report provides comprehensive data fields to support deep-dive analysis:

Data Category	Key Fields Visible
Vendor Info	Vendor Name, GSTIN, PAN No, Category (e.g., Electrical, Plumbing), and Contact City.
Billing Info	Bill Number, Invoice Date, Reference PO No, and Due Date.
Tax Details	Basic Value, GST Rate, HSN/SAC Code, CGST, SGST, IGST, and TDS Deducted.
Financials	Gross Amount, Discount (if any), Rounding, and Net Payable.
Accounting	Ledger Account head where the expense was debited (e.g., “Repairs & Maintenance”).

---

4. Source Transactions 🔄

The report derives its data from:

1. Purchase Bills: The primary document for recording vendor invoices.
2. Payment Vouchers: Linked to show payment status and tax deduction dates.
3. Journal Vouchers: For recording provisions or year-end expense adjustments.

---

5. Using the Report Interface 🛠️

Selection Filters

• Report Type: Choose one of the 5 specialized views described in Section 2.
• Date Range: Define the period for analysis. This defaults to the current financial year.

Generation Mode

• Print (Excel): Generates a high-quality Excel file holding all relevant columns. The system automatically formats headers and dates for immediate use in spreadsheets.

---

6. Best Practices / Tips 💡