How to Track Outstanding Invoices in TallyPrime | UAE Guide

Tally Solutions Dubai

Tally Software Solutions

Tally Prime 9 & Tally Prime

Tally Online Dubai & Tally UAE

Tally Support Dubai & Tally Customization
Tally Company Dubai & Tally Dubai

To track outstanding invoices in TallyPrime, turn on bill-wise tracking, record every invoice with a due date, and open the Bills Receivable report each week. Use the Overdue Receivables report to see late invoices, check ageing to find slow payers, and send reminder letters from the Outstandings reports.

This guide is for business owners, accountants, and credit controllers in the UAE who use TallyPrime. It shows the exact reports and shortcuts, how to set up your ledgers, and a simple weekly routine that keeps unpaid invoices small.

In Short

  • Turn on bill-wise tracking first. Without it, TallyPrime cannot list invoices one by one.
  • Use Bills Receivable to see what is owed, and Overdue Receivables to see what is late.
  • Set ageing periods to match your credit terms, so slow payers stand out.
  • Send reminders from the Outstandings reports by e-mail, WhatsApp, or print.
  • Link every receipt to the invoice it pays, or your reports will not match.

What Is the Difference Between Outstanding and Overdue Invoices?

An outstanding invoice is one that is not fully paid. An overdue invoice is an outstanding invoice that is past its due date. A part payment does not close an invoice. It stays outstanding until the balance is cleared. TallyPrime shows both, so you can tell what is owed and what is late.

Why does this matter for a UAE business? Late payment ties up cash that you need for rent, salaries, and suppliers. Tally's UAE guide also notes that VAT-registered suppliers generally account for output VAT in the period of supply, whether or not the customer has paid. Ask your tax adviser how this applies to you.

What Do You Set Up Before TallyPrime Can Track Outstanding Invoices?

Before TallyPrime can track outstanding invoices, press F11 and set Enable Bill-wise entry to Yes. Then open each customer ledger, set Maintain balances bill-by-bill to Yes, and enter a Default Credit Period. After this, each sales invoice asks for a bill reference, and TallyPrime calculates the due date.

Follow these steps:

  1. From the Gateway of Tally, press F11 (Features). Confirm Maintain Accounts is Yes, and set Enable Bill-wise entry to Yes. Press Ctrl+A to save.
  2. Open each customer ledger. Set Maintain balances bill-by-bill to Yes.
  3. Enter the Default Credit Period. The default unit is days. You can also type w, m, or y for weeks, months, or years.
  4. Turn on Check for credit days during voucher entry if you want to see a customer's outstanding while you create a new voucher.
  5. Save the ledger with Ctrl+A.
  6. Record a test sales invoice. TallyPrime should ask for a bill reference in the Bill-wise Details screen.

If you recorded invoices before you turned this on, add bill references to them. Until then, they will not appear in the outstanding reports.

A note on receipts. When you record a receipt, link it to the invoice it pays. A receipt recorded "On Account" is not tied to any bill, and your bill-wise reports can then differ from the ledger balance.

How to See All Outstanding Invoices in TallyPrime (Bills Receivable)

To see all outstanding invoices in TallyPrime, go to Gateway of Tally, then Display More Reports, Statements of Accounts, Outstandings, and Receivables. The report lists each invoice with its date, reference number, party name, pending amount, and due date. Only customers with bill-by-bill tracking turned on appear.

Here is what each column means:

  • Date: the invoice's effective date. TallyPrime counts the credit period from this date.
  • Reference Number: the bill reference you entered in Bill-wise Details.
  • Party's Name: the customer.
  • Pending Amount: what is still unpaid on that invoice.
  • Due On: the due date, set when you entered the voucher.

These keys save time inside the report:

  • F1 (Detailed): shows the date, voucher type, voucher number, and amount for each voucher.
  • F2 (Period): changes the period.
  • F6 (Age-wise): opens the ageing view.
  • F7 (Bill-Party wise): shows totals by customer.
  • F12 (Configure): adds columns such as Due On, Overdue days or Age of Bill, Opening Amount, and post-dated amounts. It can also show bills in foreign currency.
  • Alt+F12 (Range): filters bills by date, amount, ledger, or reference number.
  • Shift+Enter on a Pending Amount: shows how that amount is made up.

If your customers pay with post-dated cheques, turn on the post-dated option in F12. The final balance is then the pending amount minus the post-dated amount.

How to Find Overdue Invoices in TallyPrime

To find overdue invoices in TallyPrime, press Alt+G and choose Overdue Receivables. The report shows each late invoice with its pending amount, due date, and the number of days overdue. By default, days overdue are counted from the due date. You can switch to count from the bill date in the F12 settings.

You can also reach overdue bills from the Receivables report. Press F12, then under Basis of Values choose Type of Bills, and select Overdue Bills.

In the Overdue Receivables report, F12 gives you three useful settings:

  • Include Post-Dated Transactions: counts post-dated cheques in the balance.
  • Show Opening Amount: shows the total bill amount due for each party.
  • Show overdue using Bill Date: counts age from the bill date instead of the due date.

Press F4 to switch between receivable and payable bills. Press F6 to see the report by age.

How to Read Receivables Ageing in TallyPrime

Receivables ageing groups unpaid invoices by how old they are. In TallyPrime, press F6 in the Receivables report to choose ageing by bill date or by due date and to set the ageing periods. Set the periods to match your credit terms, so late invoices stand out.

Two tips make ageing more useful:

  • Match the periods to your terms. If most customers pay in 30 days, use periods such as 0 to 30, 31 to 60, and 61 to 90 days.
  • Know which date you are using. Ageing from the bill date and ageing from the due date give different numbers. Pick one and keep to it, so one month can be compared with the next.

Tally's Ageing Analysis report also helps with a harder question. It points out amounts that have been due for a long time, so you can decide whether to provide for them or write them off as bad debt. Ask your accountant or tax adviser before you write off any VAT-registered sale.

Which Invoices Should You Chase First?

Start where the cash risk is highest. Look at four things together: the amount, the age, how the customer usually pays, and how important the customer is to your business.

For example, an invoice of AED 40,000 that is 70 days late comes before an invoice of AED 1,500 that is 10 days late. These figures are only an illustration. Keep disputed invoices on a separate list, so a query is not mixed up with a payment delay.

How to Send Payment Reminders in TallyPrime

To send payment reminders in TallyPrime, open Group Outstandings for Sundry Debtors, press Ctrl+Space to select customers, and choose Reminder Letter or Ledger Outstanding. Check the details, pick the ageing interval, then send by e-mail with Alt+M, or by WhatsApp from the same menu. You can also export or print.

Send Reminders to Many Customers

  1. Go to Gateway of Tally, Display More Reports, Statements of Accounts, Outstandings, and Group.
  2. Select Sundry Debtors.
  3. Press Ctrl+Space to pick the customers or subgroups.
  4. Choose Reminder Letter or Ledger Outstanding.
  5. Check the details and select the ageing interval.
  6. Share the letters:
    • E-mail: Alt+M (Share), then E-mail.
    • WhatsApp: Alt+M (Share), then WhatsApp.
    • Export: Alt+E.
    • Print: Alt+P.

Send a Reminder to One Customer

Open Outstandings, then Ledger, and select the customer. Use F6 for ageing and F12 to set what the report shows. Press Enter on a line to expand it. Press Enter again on a detail line to open the voucher.

Before You Send

  • Check contact details. Make sure each customer's e-mail and WhatsApp number are correct in the ledger master.
  • Use the official WhatsApp Business API. Tally says to use it, not a personal WhatsApp app, for sending invoices, ledgers, and reminder letters.
  • Name the invoice. Quote the invoice number and the exact balance in every reminder.

A Simple Reminder Rhythm

This is our suggestion, not a Tally rule or a legal rule. Change it to suit your customers.

  • A few days before the due date: a friendly reminder.
  • On the due date: a short message with the invoice number and amount.
  • About a week after: a reminder letter from TallyPrime.
  • If there is no reply: a phone call.
  • For long-overdue invoices: a message to a senior contact at the customer.

How to Reduce Overdue Invoices With Credit Periods and Limits

To reduce overdue invoices, set a credit period and credit limit on each customer ledger. In TallyPrime, enter the Default Credit Period in the ledger. For a limit, turn on Provide Credit Limits in F12, then enter the amount in Specify Credit Limit. Changes apply to future transactions only.

You can also:

  • Change terms for repeat late payers. Open the ledger, shorten the credit period or lower the limit, and save.
  • Calculate interest on overdue balances. TallyPrime has an interest calculation feature that you turn on in F11 and in the ledger. Whether you can charge interest depends on your agreement with the customer, so check your contract first.

A Weekly Routine for Outstanding Invoices

A weekly review keeps overdue invoices from growing. Match new receipts to invoices first, then open the Bills Receivable report, check Overdue Receivables, review ageing, and send reminders. Note every promise to pay. Review monthly for the bigger picture, and daily if you have many invoices or tight cash.

Use this checklist:

  1. Match receipts. Link every bank receipt to the right invoice.
  2. Open Bills Receivable. Scan the pending amounts.
  3. Open Overdue Receivables. Note which invoices passed their due date.
  4. Check ageing. Look at the older bands first.
  5. Send reminders. Use the Outstandings reports.
  6. Record promises. Write the date a customer says they will pay, and check it on that date.

Common Mistakes That Make Outstanding Reports Wrong

  • Recording receipts "On Account." The bill stays open, and the customer looks like they owe money they have paid.
  • Leaving bill-wise tracking off for some customers. Those customers do not appear in the report.
  • Entering old invoices as one lump sum. You lose each invoice's date and due date. Enter open invoices one by one with their original dates.
  • Mixing up ageing dates. Ageing from the bill date and from the due date are not the same.
  • Sending reminders without the invoice number. Customers cannot match the message to a bill.

Keep Customer Data Clean for E-Invoicing

Clean customer data makes invoice tracking easier and prepares you for e-invoicing. Check each customer's legal name, address, and TRN in the ledger. Keep invoice numbers in order, with no duplicates. Remove test and duplicate records. TallyPrime holds back e-invoices with missing details, so clean masters also mean fewer held-back invoices.

To learn more, read our e-invoicing page.

What TallyPrime Cannot Do for You

TallyPrime shows who owes you, how late each invoice is, and helps you send reminders. It cannot collect the payment. The reports are only as accurate as your entries. If a receipt is not recorded, the invoice will still look unpaid.

Legal steps for a customer who will not pay, and VAT treatment of bad debts, depend on your case. Ask your tax adviser or a legal adviser before you act.

How Tally Solutions UAE Can Help

Tally Solutions UAE is run by Wahat Al Bustan Computer TR. LLC, an authorised Tally partner in Sharjah. We help UAE businesses set up TallyPrime, work on VAT and e-invoicing, and train their teams.

For outstanding invoices, our team can check your customer ledgers, turn on bill-wise tracking, set ageing periods and credit terms, and show your staff the weekly routine above. Compare TallyPrime Silver and TallyPrime Gold, and keep your Tally Software Services active for the latest release.

Frequently Asked Questions

How do I track outstanding invoices in TallyPrime?

To track outstanding invoices in TallyPrime, turn on bill-wise tracking, record every invoice with a due date, and open the Bills Receivable report each week. Use the Overdue Receivables report to see late invoices, check ageing to find slow payers, and send reminder letters from the Outstandings reports.

What is the difference between outstanding and overdue invoices?

An outstanding invoice is not fully paid. An overdue invoice is an outstanding invoice that is past its due date. A part payment keeps an invoice outstanding until the balance is cleared. TallyPrime shows both, so you can see what is owed and what is late.

Where is the Bills Receivable report in TallyPrime?

Go to Gateway of Tally, then Display More Reports, Statements of Accounts, Outstandings, and Receivables. The report lists each invoice with its date, reference number, party name, pending amount, and due date. Only customers with bill-by-bill tracking turned on appear.

How do I see overdue invoices in TallyPrime?

To find overdue invoices in TallyPrime, press Alt+G and choose Overdue Receivables. The report shows each late invoice with its pending amount, due date, and the number of days overdue. By default, days overdue are counted from the due date. You can switch to count from the bill date in the F12 settings.

Why are some invoices missing from the Bills Receivable report?

The report shows only customers whose ledgers have Maintain balances bill-by-bill set to Yes. Invoices recorded before you turned bill-wise tracking on do not appear until you add bill references to them. Also check the report period with F2.

How do I set ageing periods in TallyPrime?

Open the Receivables report and press F6 for Ageing Method. Choose ageing by bill date or by due date, and set the ageing periods. Match the periods to your credit terms, such as 30, 60, and 90 days. Confirm which date is used before you compare one period with another.

Can I send payment reminders from TallyPrime?

Yes. In Group Outstandings for Sundry Debtors, select the customers and choose Reminder Letter or Ledger Outstanding. Then share by e-mail or WhatsApp with Alt+M, export with Alt+E, or print with Alt+P. WhatsApp sharing needs the official WhatsApp Business API, according to Tally.

Why do receipts recorded On Account cause problems?

A receipt recorded On Account is not linked to a bill, so bill-wise reports and ledger balances can differ. The customer may look like they still owe an invoice they have already paid. Link each receipt to the invoice it pays in the Bill-wise Details screen whenever you can.

How do I see one customer's outstanding invoices?

Go to Display More Reports, Statements of Accounts, Outstandings, and Ledger, then pick the customer ledger. Press F6 for ageing and F12 to set what the report shows. Press Enter on a line to expand it, and Enter again on a detail line to open the voucher.

How do I set a credit limit and credit period in TallyPrime?

Open the customer ledger and enter the Default Credit Period. For a credit limit, turn on Provide Credit Limits in F12, then enter the amount in Specify Credit Limit and save. Changes apply to future transactions only.

How often should I review outstanding invoices?

Tally's collection checklist suggests a weekly review with the Bills Receivable report. Add a fuller review at month-end. If you issue many invoices or run on tight cash, check more often. Frequent checks stop small delays from becoming long ones.

Does TallyPrime collect payments for me?

No. TallyPrime shows who owes you, how late each invoice is, and helps you send reminders. It cannot collect the payment. The reports are only as accurate as your entries, so record invoices and receipts on time and link each receipt to its invoice.

Know Who Owes You, Every Week

Tracking outstanding invoices in TallyPrime comes down to a few habits. Turn on bill-wise tracking, link every receipt to its invoice, review overdue invoices each week, and send reminders with the invoice number and balance.

Our team in Sharjah can set this up with you and show your staff how to read the reports.

Book a Free Tally Consultation Explore TallyPrime Silver

Recent Post
Author

Divya ShivaKrishnan

A content strategist with an engineering background and over five years of experience producing SEO optimized content across diverse industries.

CHAT NOW
Chat with us