Tally Outstanding Report: Track Receivables and Payables Efficiently

Tally outstanding reports display unpaid invoices and credit notes for customers and vendors. Access them via Gateway of Tally > Display > Statements of Accounts. Filter by date, party, and aging buckets to track receivables, payables, and overdue amounts for better cash flow management.

What is a Tally Outstanding Report?

A Tally outstanding report is a financial statement that lists all unpaid invoices, debit notes, and credit notes for a specific customer or vendor as of a given date. It shows the outstanding balance, invoice number, date, amount, and aging information. This report is critical for credit management, cash flow forecasting, and payment follow-up. Outstanding reports help you identify which customers owe money and which vendors you owe, making it easier to prioritize collection and payment activities.

Why Outstanding Reports Matter for Your Business

Outstanding reports provide visibility into your working capital. By tracking receivables, you know how much cash is tied up in unpaid sales. By tracking payables, you can plan payments strategically to manage cash outflow. Aging analysis within outstanding reports helps you spot slow-paying customers early, assess credit risk, and take corrective action before invoices become bad debts. For vendors, outstanding reports ensure you pay on time to maintain good relationships and avoid late fees.

How to Access Outstanding Reports in TallyPrime

In TallyPrime, outstanding reports are found under Statements of Accounts. Follow this menu path: Gateway of Tally > Display > Statements of Accounts > Receivables (for customers) or Payables (for vendors). You can also use Alt+G to open the Gateway and navigate directly. Once you select Receivables or Payables, choose the specific party and set your date range. The report will display all outstanding invoices and their aging status.

Generating a Receivables Outstanding Report

To generate a receivables report for a customer, go to Gateway of Tally > Display > Statements of Accounts > Receivables. Select the customer name from the list. You will see all invoices, credit notes, and payments. The report shows the invoice date, invoice number, amount, and outstanding balance. You can drill down into individual invoices to see payment history. This helps you understand exactly which invoices remain unpaid and when they are due.

Generating a Payables Outstanding Report

For vendor payables, navigate to Gateway of Tally > Display > Statements of Accounts > Payables. Select the vendor name. The report displays all purchase invoices, debit notes, and payments made to that vendor. You can see the outstanding amount you owe and when payment is due. This is essential for cash planning and ensuring you meet payment deadlines to avoid supplier penalties or relationship damage.

Understanding Aging Buckets in Outstanding Reports

Aging analysis divides outstanding amounts into time-based buckets. Typically, these are: Current (not yet due), 0-30 days overdue, 30-60 days overdue, 60-90 days overdue, and 90+ days overdue. Each bucket shows the total outstanding amount and number of invoices. This helps you prioritize collection efforts. Invoices in the 90+ bucket need immediate attention, while current invoices are lower priority. Aging analysis also helps you calculate bad debt provisions and assess customer creditworthiness.

Setting Date Parameters for Outstanding Reports

When generating an outstanding report, you specify the 'As On Date'. This is the date as of which you want to see outstanding balances. For example, if you set As On Date to 31 December 2025, the report shows all invoices unpaid as of that date. You can also set a 'From Date' to include only invoices issued after a certain date. This filtering helps you focus on recent transactions or specific periods and avoid cluttering the report with very old data.

Filtering Outstanding Reports by Party

TallyPrime allows you to filter outstanding reports by individual customers or vendors. You can generate a report for a single party or for all parties. Filtering by a single party is useful when you need to follow up with a specific customer or vendor. Filtering by all parties gives you a consolidated view of total receivables or payables. You can also filter by party group (e.g., all retail customers or all local vendors) to segment your analysis by business category.

Exporting Outstanding Reports

TallyPrime allows you to export outstanding reports to Excel, PDF, or HTML format. This is useful for sharing reports with management, accountants, or collection teams. To export, generate the report, then press Ctrl+E (or use the Export option in the menu). Choose your format and file location. Exported reports can be further analyzed in Excel, sorted, filtered, and used to create follow-up lists or aging summaries for distribution to stakeholders.

Reconciling Outstanding Reports with Ledger Accounts

To ensure accuracy, reconcile your outstanding report with the corresponding party ledger account. Open the ledger (Ctrl+A, then select the party). The ledger shows all transactions: invoices, payments, credit notes, and adjustments. The net balance in the ledger should match the total outstanding in the report. If there is a discrepancy, check for unmatched payments, reversed invoices, or data entry errors. Use Tally voucher customization to add tracking fields if needed for easier reconciliation.

Handling Partial Payments in Outstanding Reports

When a customer makes a partial payment against an invoice, TallyPrime adjusts the outstanding balance accordingly. For example, if an invoice is for Rs 10,000 and a payment of Rs 6,000 is received, the outstanding amount shown is Rs 4,000. The outstanding report reflects this partial payment automatically. If you use bill-wise tracking, you can see which portion of the invoice remains unpaid. This granularity helps you follow up precisely on the remaining amount.

Credit Notes and Debit Notes in Outstanding Reports

Credit notes (issued to customers for returns or adjustments) and debit notes (issued by vendors for similar reasons) appear in outstanding reports. A credit note reduces the customer's outstanding balance. A debit note increases the vendor's outstanding payable. TallyPrime groups these documents with related invoices if bill-wise matching is enabled. This ensures the net outstanding balance is accurate and reflects all adjustments. If a credit note is issued after an invoice, the outstanding report will show the reduced net amount.

Using Outstanding Reports for Cash Flow Forecasting

Outstanding reports are valuable for cash flow planning. By analyzing the aging of receivables, you can estimate when cash will be collected. For example, if 60% of receivables are current and 30% are 30-60 days overdue, you can forecast collection over the next two months. Similarly, by reviewing payables aging, you can plan cash outflows. This helps you maintain adequate liquidity, negotiate better payment terms with vendors, and avoid cash shortages.

Identifying Slow-Paying Customers

Outstanding reports help you identify customers who consistently pay late. If a customer has many invoices in the 60-90 or 90+ day buckets, they are a slow payer. You can then take corrective action: send reminder letters, reduce credit limits, require advance payment, or escalate to management. Identifying slow payers early helps you manage credit risk and reduce bad debt exposure. You can also use this information to negotiate better terms or require a deposit for future sales.

Chasing Overdue Invoices Systematically

Use outstanding reports to create a systematic follow-up process. Generate a report showing all invoices 30+ days overdue. Sort by customer and aging bucket. Create a follow-up list with customer names, invoice numbers, amounts, and due dates. Assign follow-up tasks to your collections team. Track which invoices have been contacted and the response received. Update the list weekly. This disciplined approach reduces bad debts and improves collection rates, directly boosting cash flow.

Customizing Outstanding Reports with Additional Columns

You can customize outstanding reports to include additional columns relevant to your business. For example, add Purchase Order (PO) numbers, due dates, salesperson names, or custom dimensions. Use Tally MIS report customization to modify report layouts. Go to Gateway of Tally > Alter > Report, select the outstanding report, and add or remove columns. Custom columns help you analyze outstanding data by different criteria and create more actionable reports for your team.

Worked Example: Analyzing a Receivables Outstanding Report

Suppose you run a wholesale business and generate a receivables outstanding report as of 31 December 2025. The report shows:

Customer Name	Invoice Number	Invoice Date	Invoice Amount (Rs)	Outstanding (Rs)	Days Overdue
ABC Retail Ltd	INV-001	01 Nov 2025	50,000	50,000	60
ABC Retail Ltd	INV-005	15 Dec 2025	30,000	30,000	16
XYZ Distributors	INV-002	10 Oct 2025	75,000	75,000	82
XYZ Distributors	INV-004	20 Dec 2025	40,000	40,000	11
PQR Enterprises	INV-003	05 Dec 2025	25,000	25,000	26

From this report, you can see that ABC Retail owes Rs 80,000 total, with Rs 50,000 overdue by 60 days. XYZ Distributors owes Rs 115,000, with Rs 75,000 overdue by 82 days. This is a serious concern and needs immediate follow-up. PQR Enterprises owes Rs 25,000, only 26 days overdue, so it is a lower priority. Your aging analysis shows: 51 days overdue (Rs 125,000), 11-50 days overdue (Rs 55,000), and current (Rs 40,000). You should prioritize collecting from XYZ Distributors immediately and send a reminder to ABC Retail.

Outstanding Reports and GST Compliance

In India, outstanding reports are important for GST compliance. When you enable GST in TallyPrime (F11 > Statutory and Taxation > GST), all invoices are tagged with GST rates. Outstanding reports will show GST-inclusive amounts. This is important for GSTR-1 and GSTR-3B filings, which require accurate invoice data. If an invoice is outstanding at the end of a tax period, it still appears in your GST return. Outstanding reports help you reconcile GSTR-1 (sales) and GSTR-2B (purchases) with your actual receivables and payables.

Handling Disputed or Contested Invoices

Sometimes a customer disputes an invoice or claims a quality issue. In such cases, the invoice may remain outstanding while the dispute is resolved. Outstanding reports will show this as outstanding. You can add notes or flags to the invoice (using Tally voucher customization) to indicate it is disputed. This prevents your collections team from aggressively chasing a contested amount. Once the dispute is resolved, you can adjust the invoice with a credit note or full payment.

Outstanding Reports for Multi-Location Businesses

If you operate multiple locations or branches, you can generate outstanding reports for each location separately. In TallyPrime, create separate cost centers or use the location dimension to tag invoices. Then filter outstanding reports by location. This helps each branch manager track their own receivables and payables. You can also consolidate reports across locations to see total company-wide outstanding amounts and identify which location has the highest collection issues.

Automating Outstanding Report Generation

TallyPrime allows you to schedule reports to be generated and emailed automatically. You can set up a daily or weekly outstanding report that is sent to your finance manager or collections team. This automation ensures stakeholders always have current data without manual effort. You can also use Tally approval workflow to route outstanding reports for review and sign-off before action is taken on follow-ups.

Comparing Outstanding Reports Across Periods

Generate outstanding reports for different dates (e.g., 31 December 2024 and 31 December 2025) and compare them. This shows which invoices have been collected, which remain outstanding, and which are new. If an invoice from 2024 is still outstanding in 2025, it is a serious red flag. Trend analysis of outstanding amounts helps you assess whether your collection efforts are improving or deteriorating and whether credit policies need tightening.

Outstanding Reports and Bad Debt Provisions

Accounting standards require you to make provisions for doubtful debts. Outstanding reports, especially the aging analysis, help you identify invoices that are unlikely to be collected. Invoices overdue by 180+ days are typically considered doubtful. You can use the outstanding report to calculate bad debt provisions: multiply the amount in each aging bucket by an estimated default percentage (e.g., 5% for 30-60 days, 20% for 60-90 days, 50% for 90+ days). This ensures your financial statements reflect realistic asset values.

Integration with Collection Management

Outstanding reports are the foundation of effective collection management. Export the report to your collections software or CRM to track follow-ups, record customer responses, and update payment status. When a payment is received, update the invoice in TallyPrime immediately so the outstanding report reflects the change. This real-time integration ensures your outstanding report is always accurate and your collections team has current information for their calls and emails.

Best Practices for Outstanding Report Management

Generate outstanding reports at least monthly, ideally weekly. Review aging analysis to identify trends. Follow up on invoices as soon as they become 15-20 days overdue, not waiting until they are 60+ days old. Maintain accurate customer contact information and payment terms in TallyPrime so reminders are timely and correct. Use Tally customization to add fields like credit limit, credit period, and preferred payment method to make follow-ups more effective. Reconcile outstanding reports with ledger accounts monthly to ensure data integrity.

Outstanding reports are essential for managing receivables and payables effectively. By understanding how to generate, analyze, and act on outstanding reports in TallyPrime, you gain control over cash flow and reduce financial risk. If you need help setting up outstanding reports, customizing them for your business, or integrating them with your collection process, contact Global IT Care, a Tally 3 Star Certified Partner in Purnea, Bihar, serving businesses since 2010. Reach out at +91 75469 00951 to discuss your outstanding report requirements and how we can optimize your financial reporting in TallyPrime.