Purchase Register, Reports & Outstanding Analysis in Tally Prime
Purchase Register, Reports & Outstanding Analysis in Tally Prime
Learn how to check purchase register, analyze supplier outstanding, generate bills payable, and perform aging analysis in Tally Prime. Complete guide.
Who is this for: Tally Automation
Evaluating purchase performance and tracking vendor outstanding liabilities are essential for keeping a business solvent and compliant. In Tally Prime, the **Purchase Register** serves as the central hub for reviewing all inbound invoices. When paired with tools like **Bills Payable** reports and **Aging Analysis**, it provides finance teams with control over cash outflows and working capital.
Table of Contents
1. How to View and Customize the Purchase Register
The Purchase Register provides a month-wise summary of all purchase vouchers recorded in Tally.
Navigation Pathway:
From the Gateway of Tally, press D > A > P. This opens the month-wise grid. Select any month and press Enter to drill down into the list of individual vouchers.
Key Customization Options:
- Detailed View (Alt+F5): Expands the grid to display individual inventory stock items, quantities, rates, and detailed GST tax splits.
- Columnar Report (F8): Adds columns for supplier invoice number, GSTIN, taxable value, CGST, SGST, IGST, and total invoice value. This is ideal for cross-verifying tax balances.
- Voucher Filter (Range - Alt+F12): Allows filtering transactions by specific parameters, such as showing only bills exceeding ₹50,000 or filtering by specific state codes.
2. Analyzing Bills Payable & Supplier Outstanding
Tracking what you owe to vendors is critical for cash management. Tally offers two reports for this purpose:
Bills Payable Report
Shows unpaid or partially paid supplier bills along with their references, due dates, and days overdue.
Go to: Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Bills Payable.
Ledger Outstandings
Provides a net balance summary for each vendor, consolidating invoices, credit notes, and advance payments.
Go to: Gateway of Tally > Display More Reports > Statements of Accounts > Outstandings > Ledger.
3. How to Perform Purchase Aging Analysis
Aging analysis categorizes outstanding bills based on the duration they have remained unpaid. This is essential for managing creditor priorities and complying with MSME payment deadlines (such as paying micro and small enterprises within 45 days under Section 43B(h) to avoid tax deduction blocks).
Step-by-Step Aging Setup:
- Open the Bills Payable report.
- Press F6 (Age-wise).
- Select the Aging Method: Aging by Bill Date or Aging by Due Date.
- Define the age intervals (e.g. 0-30, 30-45, 45-90, 90+ days).
- Press Enter. Tally will reorganize the supplier balances into these age brackets.
4. Exporting and Reporting in Microsoft Excel
While Tally provides robust on-screen summaries, complex audits or payment planning require spreadsheets:
- Press Ctrl+E when viewing the detailed Columnar Purchase Register.
- Select Excel (Spreadsheet) as the format.
- Toggle advanced settings: Set Show Stock Item Details to Yes and Show GST Details to Yes.
- Click Send. Tally will export the data, enabling you to build pivot tables or charts.
5. Automating Inbound Reports & Analytics
Manually exporting purchase registers and calculating outstanding balances in Excel is time-consuming. It can result in delayed payments to micro-suppliers or missed ITC reconciliation opportunities.
With **TrulyInvoice**, your purchase analytics are automatically compiled. The system extracts data from your Tally database in real-time and displays it on an interactive dashboard. You can track purchase trends, monitor supplier aging status, filter by MSME class, and review GST tax liability splits without manual spreadsheet work.
Automate Purchase Registry Analytics
Monitor supplier outstanding, track aging brackets, and automate MSME compliance tracking.
Get Started for FreeFrequently Asked Questions
How do I open the Purchase Register in Tally Prime?
Go to Gateway of Tally > Display More Reports > Account Books > Purchase Register. You can also press 'D' (Display), 'A' (Account Books), and 'P' (Purchase Register) in sequence from the Gateway.
What is Purchase Aging Analysis and why is it important?
Purchase Aging Analysis lists your outstanding supplier bills categorized by age brackets (e.g. 0-15 days, 15-30 days, 30-45 days). This is critical for managing cash flow and complying with MSME rules (like Section 43B(h) which requires paying micro/small suppliers within 45 days).
How do I export the Purchase Register from Tally to Excel?
Open the Purchase Register in Tally, drill down to the required month or detailed view, press Ctrl+E (Export), select File Format as Excel (Spreadsheet), specify the folder path, and click Send. Tally will export the data with item details, rates, and values.
What is the difference between Bills Payable and Supplier Outstanding reports?
Bills Payable displays individual unpaid invoices, their bill numbers, due dates, and pending amounts. Supplier Outstanding (Ledger Outstandings) aggregates the total net balance owed to each vendor across all invoices and adjustments.
Can TrulyInvoice automate purchase reporting?
Yes. TrulyInvoice integrates with Tally Prime and extracts purchase statistics, tax allocations, and outstanding balances. It displays this data on a modern, real-time analytics dashboard with automatic charts, month-wise trends, and MSME flags.
Chartered Accountant & Accounting Automation Specialist