Back to blog

credit limits and credit days in TallyPrime for distributors selling to retailers on credit

Credit Limit in Tally Prime: Why Over-Limit Orders Still Ship

Cybiqon Team
13 min read
credit limitTallyPrimecredit controldistributorsdealer order app
Credit Limit in Tally Prime: Why Over-Limit Orders Still Ship

Credit Limit in Tally Prime: Why Over-Limit Orders Still Ship

Atradius's 2025 payment practices survey for India found that 63% of B2B sales made on credit were hit by overdue invoices, and bad debts averaged 7% of B2B invoices. That covers Indian B2B as a whole, not only distributors. Still, if you are a distributor giving credit to 200 retailers, the numbers will sound familiar.

Most distributors on TallyPrime have already done the sensible thing. They set a credit limit in Tally Prime for every retailer ledger, switched on credit days, and expected the software to stop bad orders. Then a salesman books an order for a retailer who is already over the limit. The godown picks it and loads it, and Tally only complains when the invoice is being saved. By then the truck is waiting outside.

This guide covers:

  • how to set a credit limit and credit days in the current TallyPrime, one ledger at a time or many at once
  • what Tally actually blocks, what it only warns about, and what it lets through (TallyHelp's own answer surprises most people)
  • your options for moving the credit check to the moment the order is taken
  • a credit limit review checklist to finish before Navratri on 11 Oct 2026

How to set a credit limit in Tally Prime for one customer

On TallyPrime, the credit limit lives on the party ledger. For a single retailer:

  1. Go to Gateway of Tally > Alter > Ledger and select the party.
  2. Press F12 (Configure) and set Provide Credit Limits to Yes.
  3. A credit limit field now appears on the ledger. Enter the amount, for example ₹1,50,000, and save.

A lot of ranking pages still tell you to go to F11 > Set Credit Limits. That was the Tally.ERP 9 path. In TallyPrime, the setting is in the ledger configuration described above. Field labels also shift a little between releases, so if a label doesn't match exactly, look for the closest one on the same screen.

Before you start, check that the ledger has Maintain balances bill-by-bill set to Yes. Without bill-wise details, Tally can compare the total outstanding against the limit, but it can't tell you which bills are overdue. That matters in the next section.

Setting a customer credit limit takes two minutes per ledger. Choosing the figure is harder; more on that below.

Setting credit days and credit limits for multiple ledgers at once

Most distributors have far more than a handful of retailers. If you have 200 or more, altering ledgers one by one wastes an afternoon. TallyPrime has a bulk screen for this:

  1. Go to Gateway of Tally > Alter > Credit Limits.
  2. Select the group, usually Sundry Debtors (or a sub-group such as "Retailers – Ludhiana Route").
  3. The Multi Ledger Limit Alteration screen lists every ledger in that group with a credit limit column you can edit in one pass.

This is the quickest way to set credit limits for multiple ledgers in Tally Prime, and a good reason to group retailers by route so you can review one beat at a time.

Credit days in Tally Prime are set separately:

  • On the ledger, keep Maintain balances bill-by-bill = Yes and fill in Default credit period. You can enter days, or use weeks, months or years (e.g. 30 days, 2 W).
  • In the company features, set Check for credit days during voucher entry = Yes.

TallyHelp describes what that second setting does: "Set it to Yes to get warned about exceeding credit period or pending outstanding bills for a party during transactions." The key word is warned, and the next section explains why.

What happens when the credit limit is exceeded in Tally Prime

This is what the set-up tutorials leave out. Based on TallyHelp's own documentation, here is what happens when a party is over its limit or has overdue bills:

Situation What TallyPrime does Source
Sales invoice would take the party over its credit limit Blocks the save with an error TallyHelp, Manage Outstanding Receivables
Sales order for a party already over its limit Lets it through. "You can record a sales order even if you exceed the credit limit set for a party." TallyHelp, Sales FAQ
Any voucher that doesn't affect the books Lets it through. "Transactions like sales order, which do not affect your book of accounts can be passed." TallyHelp, Manage Outstanding Receivables (updated 16 Jan 2026)
Party has bills past the credit period Warns only (if credit-days checking is on). The voucher can still be saved. TallyHelp, credit days setting
Invoice over the limit, backed by a post-dated receipt Allowed if "Override credit limit using post-dated transactions" is on TallyHelp
Delivery Note over the limit Unverified. Test it in your release before relying on it. —

In short, Tally checks the credit limit on the sales invoice, not on the sales order, so a sales order goes through over the limit. Overdue credit days only produce a warning. At least one popular Tally tutorial site says the default set-up blocks sales orders. According to Tally's own help pages, it doesn't.

There is also no built-in approval flow. Tally has no per-user override and no "send this to the owner" step. The invoice either saves or it doesn't, and the only built-in exception is the post-dated transaction override.

TallyPrime 7.0 (19 Dec 2025) and the 7.1 beta (20 May 2026) changed none of this, though 7.0's JSON import/export makes it easier for outside apps to read Tally data.

Why the check fires too late for a distributor

Here is how that plays out. This is an illustrative example, not a real client. Say a Ludhiana FMCG distributor bills from TallyPrime with credit limits and credit days set on every retailer.

  • Six salesmen take orders on their beats, some in person and some on WhatsApp.
  • In the evening, the office enters each order into Tally as a sales order. Tally accepts it even when the retailer is over the limit.
  • Next morning, the godown picks and loads against those orders.
  • At invoicing, Tally refuses the bill for an over-limit retailer, or shows a warning for one with a 60-day-old unpaid bill.
  • The accounts head calls the owner. The owner either raises the limit on the spot, which makes the limit meaningless, or has the goods unloaded, which upsets a retailer who is stocking for the festival.

Credit is decided at the order, but Tally checks it at the invoice. By then you have spent a salesman's visit, an office entry and a godown pick.

TallyPrime's browser reports don't solve this either. The Reports in Browsers FAQ says "currently you can only view and download vouchers in a browser". The feature needs an active TSS subscription, a Tally.NET user, and the office PC running TallyPrime online. A salesman can't book an order through it, and many never get access in the first place.

Credit limit vs credit period, and how much dealer credit limit to give

The two settings control different risks:

  • Credit limit caps how much a retailer can owe in total, e.g. ₹1,50,000.
  • Credit period (credit days) caps how long any single bill can stay unpaid, e.g. 21 days.

A retailer can be well under the limit and still have a bill that is 75 days old. That is usually the one to worry about, and on default settings Tally only warns you about it.

How much dealer credit limit should you give a retailer? There is no published benchmark for Indian distributors, and no sourced bad-debt rate for the sector either, so be wary of any article that quotes one. As a rough indication, Hindustan Coca-Cola Beverages' blog puts typical FMCG trade credit at 7–30 days. That is one company's view, not an industry standard. A practical start: look at each retailer's average fortnightly billing, how they paid over the last six months, and whether a post-dated cheque is on file, then set a limit where one missed payment isn't a crisis.

A legal note that many owners get wrong. The MSMED Act's 45-day payment rule, and the tax disallowance under Sec 43B(h) (now Sec 37(2)(g) of the Income-tax Act, 2025, from 1 Apr 2026), do not protect a distributor or wholesaler whose Udyam registration is for trading only. Under the government OM of 2 Jul 2021, traders get priority-sector lending benefits, not the delayed-payment protection. Don't rely on it to recover money from retailers. If you already have overdue bills, our guide on chasing payments that are already late covers the tools that do work.

Your options: a TDL add-on or an order screen before picking

There are two honest ways to fix this, and they suit different problems.

Option 1: a TDL add-on inside Tally. Plug-ins such as the Tallyplanet Credit Control Module or the Tally TDL Store's credit limit and credit days control cost roughly ₹3,600–₹5,400. They can block sales orders over the limit or with overdue bills. One approval add-on saves an over-limit sales voucher as Optional until someone approves it. If all orders are entered by one person in the office, this is the right answer: a credit limit approval TDL is cheap and quick.

Option 2: an order screen that sits before Tally. If orders come from salesmen on beats or from retailers on WhatsApp, a TDL add-on still only fires when someone types the order into Tally, and that happens after the order has been promised. The fix is to move the check to where the order is taken:

  • The salesman or retailer books the order on a phone screen that shows that retailer's live outstanding, credit limit and oldest overdue bill, read from your existing Tally data.
  • Orders that are over the limit or overdue are held before anything is picked and sent to the owner with the numbers attached.
  • The owner approves or rejects with one tap, and the reason is logged.
  • Only approved orders go into Tally as sales orders. Tally stays your books.

This is the same idea behind an ordering app for your retailers. The difference is that the credit rule is enforced at the order, not just displayed. Once payments start coming in, matching each payment to its invoice in Tally keeps the outstanding figures the screen reads accurate. If they drift, the salesman stops trusting them.

A credit limit review checklist before Navratri 2026

Navratri runs 11–19 Oct 2026, Dussehra is 20 Oct, and Diwali falls on Sunday 8 Nov 2026, later than last year's late-October Diwali. The festive season is big. CAIT put Diwali 2025 sales at ₹6.05 lakh crore, up 25% on 2024, with about 85% going through traditional non-corporate markets. That is the channel your retailers work in. Before stocking orders start arriving, go through this list:

  1. Export Bills Receivable (Pending Amount, Due Date, Overdue By Days). Sort by overdue days, not by amount.
  2. Check the 45–90 and 90–180 day buckets in Tally's default ageing. Retailers there need a conversation before the festival, not a bigger limit.
  3. Re-set limits in bulk through Alter > Credit Limits for each route sub-group. Base them on each retailer's recent billing, not on last year's figures.
  4. Confirm credit-days checking is on, and tell the office that a warning still means "call the owner".
  5. Test your own release. Enter a sales order and a delivery note for an over-limit test party and write down what Tally allows.
  6. Write down who can approve an over-limit order, and what counts as a valid reason (a PDC, a part-payment, a festive one-off).
  7. Tell salesmen the rule before the season, not at the truck.

FAQs

How do I set a credit limit for a customer in TallyPrime?

Go to Gateway of Tally > Alter > Ledger, select the party, press F12 (Configure) and set "Provide Credit Limits" to Yes. Enter the limit on the ledger and save. For many retailers at once, use Alter > Credit Limits, pick the Sundry Debtors group, and edit them all in the Multi Ledger Limit Alteration screen.

Does TallyPrime stop a sales order if the credit limit is exceeded?

No. TallyHelp states: "You can record a sales order even if you exceed the credit limit set for a party." The limit is enforced when a voucher that hits the books, such as a sales invoice, is saved. To block or hold orders earlier, you need a TDL add-on or an order screen outside Tally.

How do I block billing for customers with overdue bills in Tally?

Out of the box, you can't fully block it. With "Check for credit days during voucher entry" set to Yes, Tally only warns about overdue bills. Blocking needs a credit-days TDL add-on (roughly ₹3,600–₹5,400) or a separate order system that holds overdue accounts for approval.

What is the difference between credit limit and credit period?

The credit limit caps the total amount a customer can owe. The credit period caps how many days a single bill can stay unpaid. You need both, because a retailer can be under the limit while still holding a long-overdue bill.

Can salesmen check a retailer's outstanding on mobile in Tally?

Only partly. TallyPrime's browser reports let an authorised Tally.NET user view and download data. That needs an active TSS subscription and the office PC online, and it can't be used to book orders. For salesmen, a separate order screen that reads outstanding from Tally is the practical route.

What Cybiqon would build for this

If your credit problem starts in the field rather than at the office keyboard, this is what Cybiqon would build: an order screen for your salesmen and retailers that reads each retailer's outstanding, credit limit and overdue bills from your Tally data. It holds over-limit and overdue orders before they reach the godown and sends them to you for one-tap approval with a logged reason. Only approved orders go into Tally, which stays your books. The screen is written for your routes, your approval rules and your salesmen, not configured from a template, and you own every line of the code. The founders build it. See how we approach admin panels and order desks. If you want to talk through your version before Navratri, book a 30-minute call, call +91 9250711473, or write to [email protected].

Conclusion

Setting a credit limit in Tally Prime is easy. The problem is that Tally enforces it at the invoice, after the order has been promised and the goods picked, and it only warns about overdue credit days. If all your orders are entered in the office, a ₹3,600–₹5,400 TDL add-on fixes that. If they come from salesmen and WhatsApp, move the check to where the order is taken and let the owner approve exceptions before picking. Do the limit review before 11 Oct 2026. If you want the order screen built and owned by you, Cybiqon is a call away.

Want this set up for your business?

Book a free call — no tech jargon, no sales pressure. Just honest answers.

WhatsApp us
Chat with us!