📅 Tuesday, 28 July 2026 | Latest Tally Prime & Tax Updates

How to Manage Outstanding Receivables and Payables in Tally Prime (2026)

28 Jun 2026 Tally Prime Guru 5 min read Updated: 28 Jun 2026

Knowing who owes you money, who you owe, and how overdue each amount is, is one of the most useful things Tally Prime does once it’s set up properly. The feature behind this is “bill-wise details,” which tracks every invoice individually instead of just a single running balance per party.

This guide covers enabling bill-wise tracking, recording it correctly on your invoices, and using the reports to actually chase what’s overdue.

What You Need Before You Start

  • Tally Prime installed, with your sales and purchase ledgers already set up — see our guide on how to record purchase and sales entries in Tally Prime
  • Customer and supplier ledgers created under Sundry Debtors and Sundry Creditors respectively

Step 1: Enable Bill-wise Details

  1. Gateway of Tally, then F11 (Features), then F1 (Accounting Features)
  2. Set Maintain Bill-wise Details to Yes
  3. If you want due dates and credit limits tracked too, also enable Activate Interest Calculation and Maintain Multiple Mailing Details, if relevant to your workflow
  4. Press Ctrl+A to save

Step 2: Enable Bill-wise Tracking on Party Ledgers

  1. Open each customer or supplier ledger under Sundry Debtors or Sundry Creditors
  2. Confirm Maintain Balances Bill-by-Bill is set to Yes
  3. Set a Default Credit Period if you extend standard payment terms, for example 30 days
  4. Save the ledger

Step 3: Record Invoices with Bill References

Once bill-wise tracking is enabled, Tally Prime prompts for a reference every time you save a sales or purchase invoice:

  1. After completing the invoice details and pressing Ctrl+A, Tally Prime asks how to allocate this amount against bills
  2. Choose New Ref for a new invoice (this becomes the bill reference others will be matched against later)
  3. Enter a Due Date or Credit Days for this specific bill, which can override the ledger’s default credit period if needed
  4. Save

For payments received or made later, you’ll select Agst Ref instead of New Ref, and match the payment against the specific outstanding bill it’s settling.

Step 4: Record Receipts and Payments Against Specific Bills

  1. Gateway of Tally, then Vouchers, then F6 (Receipt) for money coming in, or F5 (Payment) for money going out
  2. Select the party ledger
  3. When prompted for bill allocation, choose Agst Ref and select the specific invoice this receipt or payment is settling
  4. If the amount only partially settles the bill, Tally Prime keeps the remaining balance outstanding against that same reference
  5. Save

This step is what makes outstanding reports accurate — if you skip matching payments to specific bills (or always use New Ref instead of Agst Ref), your outstanding reports will show old, already-paid invoices as still due.

Step 5: View Outstanding Reports

  1. Gateway of Tally, then Display More Reports, then Receivables (for customers) or Payables (for suppliers)
  2. Review the Bill-wise Outstanding report, which lists every unpaid or partially paid invoice individually, along with how overdue each one is
  3. Use the Ageing Analysis view to group outstanding amounts into buckets — for example, 0-30 days, 31-60 days, 61-90 days, and above 90 days overdue
  4. Drill into any party or bill by pressing Enter for the full transaction history

Step 6: Set Up Credit Limits (Optional but Useful)

If you want Tally Prime to warn you before a customer exceeds their agreed credit:

  1. Open the customer’s ledger
  2. Set a Credit Limit amount
  3. Tally Prime will flag or restrict new invoices that would push the customer’s outstanding balance beyond this limit, depending on your configuration

Common Mistakes to Avoid

  • Always selecting New Ref instead of Agst Ref when recording receipts, which makes every old bill look permanently unpaid
  • Not enabling bill-wise details from the start, then trying to retrofit it onto months of existing transactions — this is far more work than enabling it on day one
  • Ignoring the ageing analysis until a payment is badly overdue, instead of reviewing it weekly or monthly as part of routine bookkeeping
  • Forgetting to set due dates or credit periods, so every invoice looks the same age in reports regardless of actual terms
  • Not reconciling outstanding balances with the actual party periodically — your books and their books can drift apart over time without anyone noticing until it’s a larger issue

FAQs

What’s the difference between a regular ledger balance and bill-wise outstanding? A regular ledger balance just shows the total amount owed or due, as one number. Bill-wise outstanding breaks that total down invoice by invoice, so you know exactly which bills are pending and how old each one is.

Can I enable bill-wise details after months of transactions without it? Yes, but you’ll need to go back and allocate existing outstanding balances against specific bills manually, which takes more effort than enabling it from the start.

Does Tally Prime send automatic payment reminders to customers? Tally Prime focuses on tracking and reporting outstanding amounts. Sending reminders is typically a manual step, though you can export the ageing report and use it as the basis for reminder emails or calls.

How do I handle a payment that covers parts of two different bills? When recording the receipt, select Agst Ref and allocate the payment amount across both bills individually rather than as one lump sum against a single reference.

Can I track outstanding for advance payments received before an invoice is raised? Yes, advances can be recorded and later adjusted against the invoice once it’s raised, using the bill allocation options on the relevant voucher.

Tally Prime Guru
About the Author

Tally Prime Guru

Tally Prime team — Providing trusted Tally Prime, GST, Income Tax and accounting news daily.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top