Syntha Lab RU

Customer credit limit and wholesale receivables aging

Shows for each wholesale customer how much has been shipped on credit, how much of the limit is used, how much debt is overdue and what doubtful-debt reserve to create by age group. The reserve rates are editable.

Wholesale terms and credit For whom: Finance directors, credit managers and heads of a brand’s wholesale.

Calculate on your data →

At a glance

What question does it answer?
Which wholesale customers we ship to on credit beyond the limit, how much debt is overdue and what doubtful-debt reserve is needed.
What data is needed?
For each customer: the limit and the debt by age (not overdue, under 45 days, 45–90, over 90).
How to read the result?
On the example of four customers receivables are 5.75m, of which 2.15m (37.4%) are overdue and 0.9m are over 90 days. The reserve at rates of 0%, 0%, 50% and 100% is 1.125m, which is 19.6% of debt and below the 10% cap of revenue (12m). One customer has exceeded the limit: 1.1m against a limit of 1m, that is 110%. The default rates correspond to art. 266, para. 4 of the Tax Code for tax accounting (a guide as of 13.11.2026, check against the act text); check with an accountant. Example on the default values: Wholesale receivables: RUB 5.75 million; Of which overdue: RUB 2.15 million · 37.4%; Debt over 90 days: RUB 900,000; Doubtful-debt reserve at the rates: RUB 1.13 million. The figures are illustrative: enter your own to see your result.

Why and how to reason

A wholesale shipment is credit to the customer: you handed over goods but the money has not arrived. A limit keeps that credit from growing beyond what you are willing to lose. The calculation does three things. First, for each customer it adds debt across four groups (not due, up to 45 days, 45–90, over 90) and divides by the limit, showing who has hit the ceiling. Second, it multiplies each group by a reserve rate, because the older the debt the lower the chance of collecting it: 0%, 0%, 50%, 100% in the example. Third, it caps the reserve at a maximum share of revenue, since tax accounting does not recognize a reserve above the cap. Example: four customers owe 5.75 million, of which 2.15 million is overdue; the 45–90 group gives 450 thousand × 50% = 225 thousand, over 90 days gives 900 thousand × 100% = 900 thousand, a reserve of 1.125 million (19.6% of debt). “Leto Boutique” owes 1.1 million against a limit of 1 million: it is over the limit.

When to use it

Use it with several wholesale customers on credit terms, before a new shipment and at period close. It does not replace checking a customer before the first shipment or credit insurance. For one large customer calculate separately: its weight in revenue matters more than the average. Assumptions: default reserve rates come from tax accounting while the accounting policy may differ; amounts exclude VAT. The limit guide is monthly shipments × credit term ÷ 30.

How to read the result

Go top to bottom. First customers above the limit: each needs a decision on whether to stop shipments until payment. Then debt over 90 days: this is almost lost money, time for a claim and a talk about terms. The overdue share of debt shows the general health of wholesale: if it grows period to period, tighten credit terms. Compare the reserve as a share of debt with the maximum share of revenue: an excess means part of the reserve is not recognized in tax accounting. For the next shipment look at limit use: above 80% is a reason to revisit the limit rather than ship out of habit.

Common mistakes

Do not mix “debt” and “overdue debt”: debt not yet due is no threat but it uses up the limit. Do not leave reserve rates at zero for the old groups. Do not enter amounts with VAT in one group and without VAT in another: the total will be wrong. And do not set a limit once and for all: revisit it after every delay and when the customer’s turnover grows.

What data is needed?

  • For each customer: the limit and the debt by age (not overdue, under 45 days, 45–90, over 90).
  • Optional: monthly shipments and the credit term, annual revenue.

Inputs

FieldUnitValue in the exampleMeaning
Debt not overdue%0A reserve is normally not made for debt that is not overdue.
Debt under 45 days%0Tax Code of the Russian Federation, art. 266, para. 4 (a guide as of 13.11.2026, check against the act text): in tax accounting no reserve is made for doubtful debt under 45 days, 50% is included for 45–90 days and 100% over 90 days; the whole reserve is capped at 10% of revenue. Check with an accountant; in financial accounting the procedure is set by your accounting policy.
Debt of 45 to 90 days%50Tax Code of the Russian Federation, art. 266, para. 4 (a guide as of 13.11.2026, check against the act text): in tax accounting no reserve is made for doubtful debt under 45 days, 50% is included for 45–90 days and 100% over 90 days; the whole reserve is capped at 10% of revenue. Check with an accountant; in financial accounting the procedure is set by your accounting policy.
Debt over 90 days%100Tax Code of the Russian Federation, art. 266, para. 4 (a guide as of 13.11.2026, check against the act text): in tax accounting no reserve is made for doubtful debt under 45 days, 50% is included for 45–90 days and 100% over 90 days; the whole reserve is capped at 10% of revenue. Check with an accountant; in financial accounting the procedure is set by your accounting policy.
Annual revenue excl. VAT₽120,000,000Needed for the reserve cap check. Amount excl. VAT: the general rate is 22% from 01.01.2026. The rate follows the shipment date; confirm your regime and rate with an accountant.
Reserve cap% of revenue10In tax accounting the cap is 10% of revenue (art. 266 of the Tax Code, a guide as of 13.11.2026, check against the act text); check with an accountant.
Credit term under the contractdays30Optional. Used for the limit guide: monthly shipments × term ÷ 30.

How it is calculated

StepFormula
Customer debtnot overdue + under 45 + 45–90 + over 90
Limit useddebt ÷ limit
ReserveΣ (debt of the group × rate of the group), then no more than the cap × revenue
Limit guidemonthly shipments × credit term ÷ 30

Worked numbers

Default values from the app; in the interactive version you enter your own.

Wholesale receivables
5.75 m ₽
Of which overdue
2.15 m ₽ · 37.4 %
Debt over 90 days
900,000 ₽
Doubtful-debt reserve at the rates
1.13 m ₽
Reserve after the revenue cap
1.13 m ₽Not above the set share of revenue.
Customers above the limit
1
Reserve as a share of debt
19.6 %

By customer

CustomerDebtLimit usedOverdueReserveLimit guide
Chain “North”2.1 m ₽70 %14 %0 ₽1.5 m ₽
Store “Fashion House”1.55 m ₽78 %42 %125,000 ₽800,000 ₽
Sole trader Orlova1 m ₽67 %70 %600,000 ₽400,000 ₽
Boutique “Summer”1.1 m ₽110 %45 %400,000 ₽300,000 ₽

“Boutique “Summer””: debt 1.1 m ₽ is above the limit 1 m ₽ (110 %). Decide whether to stop shipments until payment.

“Sole trader Orlova”: there is debt over 90 days (500,000 ₽). Think of a claim and of the terms of the next shipment.

“Boutique “Summer””: there is debt over 90 days (400,000 ₽). Think of a claim and of the terms of the next shipment.

The default reserve rates come from art. 266 of the Tax Code for tax accounting; in financial accounting the procedure and percentages are set by the accounting policy. A reserve does not replace checking a customer before shipment. Check with an accountant.

Nuances and limits

  • A reserve does not replace checking the customer: a limit is needed before shipment, not after the delay.
  • The tax reserve rates and the revenue cap do not necessarily match the accounting policy for financial statements.
  • Count the age of debt by the contract and the inventory rules; clarify with an accountant.

Terms used

Calculate on your data →