Estimated reading time: 28 minutes
Identify critical, financially weak customers long before bankruptcy or before they close their doors. Without Microsoft’s AI, 100% Business Central or Navision integrated, super fast, no additional effort. Prevent bad debts almost at the same time. And even better: Optimize your payment transactions from the ground! No more manually sorting into a folder with bills to pay. No paper Bills you touch over and over again, shuffle from left to right, and then misplace at some point.
You will also find more tips on this exciting topic of avoiding bad debts, regardless of whether you use Business Central or Navision or a completely different accounting system, e.g. Diamand, SAP Sage KHK, HS AS400 or whatever.
Does this require artificial intelligence? Nope.
Microsoft would like to sell its AI (Artificial Intelligence ... Either it is not artificial, like Amazon, or it is not intelligent) to Business Central & Navision in order to determine “whether an invoice is paid on time”. Or not. Wow.
That is very little for a receivables management / risk management / risk minimization against bad debts due to bankruptcies or other reasons for a default.
Continuous monitoring of receivables easy as a side task
Does the information “money comes on time” or “money doesn't come on time” really help you? Of course not. A real warning about customers who go “broke” soon . And this directly and easily integrated into your (almost) daily Business Central and Navision work. Easier than any receivables management, quasi "on-the-fly". Avoiding bad debts has never been easier and cheaper. Grab a coffee or tea, sit back, and take your receivables management to the next level with this article.
Of course there are exceptions and surprises, as no computer algorithm can protect you from them. But in the mass (and rule) one can observe the following:
- Customers whose liquidity is falling are increasingly using their payment terms.
- "Healthy" customers usually pay within the allowance period.
- "Ailing customers" then switch to the due date (ie pay at the net payment target) instead of the allowance due date (earlier payment with discount deduction).
- And when it gets even tighter, the due date is already a bit overdrawn ... and then a little more ... and so on.
If you wait too long, the only thing that will help you is a credit default insurance... but these providers don't do that for God's sake either 🙂 You will find some examples of how much invoicing service providers ("factoring") will cost you below... and how you can determine if it is worth it for you.
At the end of this article you will find even more warning signs of bad debt, impending insolvency and non-payment. You can use these even if you don't have Navision & Business Central... but it's more elegant with Navision. 🙂
There are considerably more warning lamps (indicators) of bad debt / payment defaults (see at the bottom), but the increase in payment duration (the time until the settlement of open invoices / items) is one of the simplest and safest indicators (signs) of impending insolvency.
That's why I've “slightly” expanded the “Debitor items due” (Report 106) list for you... Note: The number of overdue months with a red progress bar is more of a gimmick, but it does have an interesting background: the native, “old” Navision can also do gimmicks like this! Under the RTC or BC365 AL Extensions, something like this is already more elegant and easier... But your Navision up to 2009R2 is not an old thing either; you can teach it a few tricks that dealers like to say: If it doesn't work, buy a new Microsoft Business Central BC365.
An increase in the order value with a simultaneous extension of the payment term is more of a confirmation of the impending insolvency than a growth indicator ... Take care to avoid payment defaults.
React in good time so as not to be left with your debts due to insolvency / insolvency of your customers. And thereby perhaps becoming a case for the insolvency administrator himself.
Navision or Business Central will help you very easily!
This technology is of course also suitable, for example, to have customers automatically adjust payment terms and credit limits by the system. Talk to me about this, if you would like to expand your receivables management / risk management in this regard.
Examples of an on-the-fly evaluation of impending bad debts / bankruptcies
What is the easiest way to protect yourself against impending insolvency / bankruptcy / bad debt of your customers with Navision or Business Central?
Quite simply: You observe the payment behavior, quite incidentally, without any additional work worth mentioning.
And that practically without adjustment in standard Navision or Business Central. Only the report (Report) 106 Customer Detailed Aging (Debtor - Due Items) has a small extension: The history of the previous payment periods / overdrafts!
We simply show the payment duration of the last n payments in the top right (or wherever you want). Examples:
Example Recognize payment rhythm
Payments often fluctuate by a few days around the due date. This can also be recognized very quickly here and thus gives an all-clear, if it's sometimes paid a few days later.
The customer in this example sometimes pays after 12 days, sometimes only after 16 days... But if you look at the details, you immediately recognize: The customer simply makes his payment run on Fridays! The detected deviations are therefore no real deviations in payment behavior, but only an example of rational accounting, a functioning receivables management.
Example of a healthy, punctual payer, no risk of non-payment
Annelise is obviously very liquid: she always pays within the discount period (Ø after only 4 days), and the current invoice has only been open for 7 days. The cycle 4 4 4 4 7 4 rather indicates an invoice that was once paid 3 days later because of a weekend. See first example.
Ernst takes a little more time: He prefers to pay within the due date, but very reliably. And the current bill is still right in the middle of it with 14 days. Business Central or Navision gives you a reassuring message here: No need to panic.
Example of punctual payer, no or low probability of bad debt loss
With one receipt and 64 days overdue (21 21 28 20 32 64 32 41 34) there was probably a lack of clarity, but otherwise no cause for concern. All others were settled (paid) after about 20-30 days. By the way, the payment days are sorted by date: The last payment (the last settlement) is on the right, so you can see the development very well.
Example fluctuating, irregular payment method
Here it is easier to see that this customer "pays according to availability". This is not critical, but it can lead to a bad debt. He obviously pays his bills when he has enough money available again. A single overdue customer for him can very easily become your problem!
Although the payment terms themselves were never particularly noticeably exceeded, the jumping between yes / no cash discount clearly shows that this customer now and then has financing problems.
You don't have to worry about small amounts, but if sales suddenly rise, then your alarm bells should ring: He may want to quickly restock his inventory at your expense.
By the way, if this is a known problem for you (customers quickly replenish their own warehouse at your own expense shortly before their insolvency), then we can also very easily issue the respective amounts here, which makes such a tendency much clearer.
But then it takes a little longer to skim through it. In Navision & Business Central RTC (RDLC), you could highlight individual days visually/by color. Unfortunately, this is not easily possible in Navision up to version 2009R2. But it is possible! Take another look at the example at the beginning of this article!
Example of creeping insolvency with a good outcome
It got a lot more exciting here. This customer used to pay quite well (after 18 19 20 14 8 days). Then it got a little more difficult. Corona? The payment duration went up to 82 days. Then the situation relaxed again: The payment duration clearly went down from 82 to 66, 52, 38 days to discount payment (7/8 days).
Example (almost) certainly the following shortfall of accounts receivable
Here we have a perfect example for a red flag. He always paid in time in the beginning (0,2), then within the discount period (8 days), then he already used his net payment period22 days), was then overdued (69 and 81 days). The current receivables are now already 53, 66, 81, 197 Days overdue: This trend was already apparent a long time ago! Countermeasures should be urgently considered here, e.g. advance payment, payments on account, personal discussions with the management. Also, make sure you have the correct retention of ownership on all your documents. If your Navision/Business Central does not yet print this important sentence on your documents, feel free to contact me regarding this.
And: You just do it on the side. At least I know it that the due item list (Report 106 in Business Central or Navision) is a popular tool to quickly check the open customer items shortly before the (hopefully automated?) Dunning run. And that with real intelligence, not with artificial intelligence.
And so that you can quickly resolve the issue with the customer, the e-mail address and telephone number are also provided. Minimal adjustments to make life easier: That's how Navision and Business Central work. You don't need AI for that.
Automatic liquidity planning with Navision & Business Central
There is so much more that can be generated from this data! E.g. Navision can automatically determine the due dates in the accounts receivable items of Business Central and Navision from the last 3 payment cycles. This way your own liquidity planning -without any additional manual work- is much more accurate than you can ever do by hand. Statistics don't lie, at least not your own.
Further warning signals of shortfall of accounts receivable / bankruptcies
First order with new customers
First order? Maybe. even with a noticeably high value of goods, or unusual product combinations? If you don't know the customer at all, this is always associated with a certain risk.
Rating agencies such as Creditreform or Euler Hermes Rating help with a credit check. In Shopware even automatically via plug-in! Take a look at the commercial register, which can be viewed free of charge.
Also watch out for address clusters and prominent names. Pay attention to whether you receive different orders with different or even the same names, often with names of celebrities from the same addresses. Since the target addresses for order fraud usually contain the same and, above all, meticulously correct addresses, a very simple address comparison is already a cost-effective but high hurdle. In Navision Financials Dynamics & Microsoft Business Central BC 365, this security, this preliminary check against order fraud, is also very easy to automate. Just contact meif you don't already have something like this. Simply compare the postcode, city and street of new customers with addresses already stored by you. If you find the same address, evaluate the order balance and the invoice balance, as well as the turnover in the previous month and year. Sudden increase in the order volume, no earlier, but now a large turnover, no earlier orders, but now many orders in quick succession: all this is done with the least amount of work even with a large number of orders/order volume “on the fly”, as it were, on the side, and is already a magic trick against the usually very simple order fraud.
Checking of insolvencies
You don't even need any service provider for that! Insolvencies are announced transparently, free of charge and publicly! Research your customers here for free if, for example, one of the indications shown here occurs.
High priced products
Also pay attention to whether, for example, there are very high-priced products in your range that are cheaper elsewhere, or just products that are easy to resell, such as cameras, laptops, notebooks... Fraudsters don't compare prices. If you don't pay for it anyway, the purchase price is not that important. Selling the products at random discounts, e.g. via (formerly eBay) classifieds, is anything but a losing deal when they can be obtained for free.
Different addresses
If the delivery address in the first order differs , you should also be alert, as you should for deliveries to packing stations. Perhaps a hijacked account with a high reputation (trust) is being used to commit order fraud (credit fraud). Here, too, Navision Dynamics or Business Central BC365 can help: When a new delivery address is entered for an order, you can easily see how many delivery addresses this customer has had so far and in the previous year. If the customer has had no or only one delivery address in the past, then a phone call or an automatically generated email might cost you 2 minutes of work.
Also pay attention to the name mail address. A Rüdiger Müller with the email address Ralf.mayer@web.de or a Ralf3245532@web.de should put you in alert.
Mail addresses with many digits or random letter combinations are often created automatically (e.g. by a bot). Or even by a person who does not care about the statement of a mail address. And if the order arrives in the deep hours of the night... better make a phone call afterwards. After all, that can be customer service 🙂
Change in payment duration (& punctuality)
In the case of existing customers, the notes on the extension of the payment term (as described above) and and fictitious complaints are an indicator. Whereas the last point is automatically expressed in the above-mentioned exaggerated payment lines - very convenient! Bogus complaints work like complaints, only that they are unjustified. They are only to hide payment delays.
Previously unusual partial payments or changes to bank details are another indication that should be kept in mind.
Deterioration in customer communication, employee information
Obviously, but to be treated manually are the clear warning signs such as inaccessibility of the management, competitors who only deliver to their customers against prepayment or cash payment, name changes, relocation of business fields abroad, discount battles (just like at the "Praktiker Baumarkt")evasive responses from employees about the operating situation, employee turnover, often changing contact persons…
Also make sure that your contact person drops a comment like "Since Mr. or Mrs. xxx has left, nothing works anymore" or something like that. In average companies there are usually only average employees. These companies are carried by the market.
It is more exciting with above-average companies! Often the brilliance of the company only depends on one or very few employees. A really good salesman, an excellent programmer, a super skilled buyer. In this case, the departure of a single person can jeopardize the market leadership of an entire company.
And even this process itself can be an indicator: Good employees are usually the first to leave a fluctuating company, which then increases the fluctuations.
If you hear any warning signs, a quick, free look at the commercial register can't hurt either. Here you will also find, for example, the opening of insolvency proceedings. In this case, contact the insolvency administrator listed there immediately and ask about the next steps, e.g. further deliveries to your customer. Otherwise, you risk continuing to deliver, and yet you will be left with a notice (!) on your claims.
Securing accounts receivable through factoring
There are numerous service providers who take care of your receivables management. And also offers "from 1% fee", e.g. at AXA, which quickly make you think about getting rid of this whole tiresome subject of receivables monitoring.
But please be as smart as your factoring provider! Simply take the accounts receivable reclassified as "non-recoverable receivables" in the previous year and taken as a secure payment default. And put these defaults in relation to their total sales. This percentage is their statistically expected bad debt loss. If this percentage is higher than the fee for your factoring service provider, you are getting good business dealings with factoring. If this percentage, however, is the same or even less than the fee for your factoring service provider, you are doing bad business selling your accounts receivable. Apart from the fact that you may also burden your customer relationship with it.
Calculation example: You posted 2,768 euros as uncollectible receivables in the previous year, with sales of 568,234 euros in the previous year. Your bad debt loss is therefore 2,768 / 568,234 * 100 = 0.49%. If you now pay 1% of your turnover as bad debt insurance or collection fee, you will double your costs. In Navision / Business Central you can also calculate/display this important key figure fully automatically in the account scheme!
The same also applies to bad debt insurance. Of course, these companies also make a calculation of the risk of default and have you pay for it. And assume that: The really already known lazy customers do not take these bad debt insurances and the factoring providers neither.
Impending insolvency as customer loyalty
Something that at first sounds like a contradiction can also be an opportunity!
Of course, this requires an enormous amount of sensitivity on the part of everyone involved. First and foremost, you need to be able to get an idea of whether a critical customer has a chance of surviving in the market. Should you come to the realization that this opportunity is definitely given, you can possibly use this opportunity to bind a very loyal, loyal customer to you for the future! Be sure: If you don't simply sacrifice your customers, refrain from “throwing them into bankruptcy” (deliberately bringing them into bankruptcy), you will win a loyal customer for the future. And here, possibly, laying the seeds for a mutually very fruitful cooperation.
This is not true for every customer, and it is certainly not true for every country. If you know your customer as a classic Hanseatic business partner, a dealer with honor and conscience, you should definitely go down this path of dialog! You may be able to offer your customer a helping hand with interest-free installments.
If you tend to do business with, let's say, “southern” or oriental-oriented customers & countries, it could well be that you should switch more quickly to judicial dunning procedures or “Russian debt collection”, i.e. external receivables management. There is no general rule here; your gut feeling and experience are required. Navision / Business Central can certainly support you here with your impending bad debt losses via the posting history (debtor items) – but it cannot take your decision away from you.
Anticipatory receivables management
Review & Manage Invoices
Post all incoming payments regularly and promptly. This is the only way to have a reliable view of your receivables, your liquidity (cash flow) and, above all, the payment behavior of your customers.
Remind customers of outstanding or overdue invoices
If you, e.g. with the above mentioned open items list, promptly discover your overdue invoices and thus critical customers, it is time to remind them - even before the first reminder - to settle the claim. In many cases, you can use this to get open receivables paid ("collect") before a default occurs. For example, you can simply forget or not properly delivered invoices without much hassle to get paid. Especially with my invoice per mail feature you have the comfort that you can directly attach an electronic copy of your invoice in PDF format to the friendly reminder email. This streamlines your time spent on receivables management, and also makes it easier for your customer to clarify and pay. So you avoid unnecessary hassle with little work.
Send reminders
With Navision in particular, dunning is as easy and flexible as with hardly any other financial accounting system! Unlimited foreign languages (e.g. German, English, Dutch and French), unlimited reminder methods (e.g. "Friendly" and "Demanding"), unlimited reminder levels (e.g. in reminder level 5 instead of a reminder immediately the finished letter to the collection service). Use this option to send an urgent reminder to your late paying customer with little effort on your part. With my invoice per mail feature you can even attach the overdue invoices to the reminder right away if you wish. Why should you waste time discussing "Oh, we didn't get those"? If you have gotten into the habit of sending reminders shortly after a delay in payment has occurred, then the first reminder may or should contain the word "reminder". If you are afraid of the effort for the reminders, the first reminder should still carry the friendlier title "reminder".
Write a due date on your invoices! This automatically puts the customer in delay after the expiration of this period. With the reminder, however, he is put in delay in any case. According to the law, this entitles you to interest on arrears and compensation for damages. This also applies to attorney's fees or collection costs.
Seek conversation
What to do if the customer still does not respond? That depends on the amount of the bill and the customer relationship. See also above.
Higher sum and long-term customer? Seek the conversation with the customer and work out a joint solution. Goodwill can even strengthen customer loyalty. See above.
If the customer can't pay for a short period of time, a deferral could be a solution for smaller amounts, for example. "Deferral" means: the postponement of a due payment for a longer period of time (deadline), for example for one to three months. Ask your customer for a realistic forecast of when he will be able to pay the bill!
A deferral of payment suspends the statute of limitations, i.e. interrupts it. If the debtor acknowledges the claim, the limitation period even starts from the beginning. A longer statute of limitations is advantageous for you because you have longer time to collect the claim before it expires (forfeiture).
How to prevent your open invoices from becoming time-barred
Also consider charging interest on the deferral. A deferral can have a confidence-building effect and help retain the customer over the longer term.
In the case of larger amounts, it may also make sense to pay in installments. This restarts the statute of limitations. Navision and Business Central offer you great opportunities for easy management of this through unlimited partial payments on receivables.
If all this remains unsuccessful, you have no choice but to collect the debt via a lawyer, a debt collection agency, a court order or a lawsuit in order to avoid a complete loss of receivables.
Involve debt collection agency or lawyer
Collection agencies should always be your last choice, bringing in a third party can (and will) irreparably damage customer loyalty.
Many debt collection providers are organized here: List of association members.
There are three main debt collection models:
- Purchase of receivables: In this case, the collection agency buys the outstanding debt from the creditor for around 20 to 30 percent of the invoice value - you are left with the loss.
- Silent Assignment: In this case, your collection agency collects the debt in its own name, but the debt remains with the creditor. The creditor receives his money -minus commission- only in case of success.
- Collection as a service: In this case, the debt collection provider collects the invoice on behalf of the customer and invoices the debtor for his services. He also receives a commission in the event of success.
You should always try to reach an agreement without involving third parties first. If you can't get solve it without court, you can also initiate legal dunning proceedings yourself. This is simple, fast and saves a lot of costs and administration.
Initiate legal dunning proceedings
Usually, by means of a judicial dunning procedure, you will receive an enforcement order (enforcement notice) without having to file a lawsuit. This procedure is faster and less expensive than a lawsuit.
You can submit a reminder request online or in written form at the competent district court: mahngerichte.de.
If the application is filled in correctly and completely, the court will issue it without delay. Thereby it's not checked whether the claim is justified.
If the debtor doesn't object to the reminder within two weeks, a corresponding enforcement notice will be issued.
With the enforcement order, you have a ready title in hand and can instruct a court bailiff or initiate other enforcement measures.
You can calculate the fee for the judicial dunning procedure here online..
With the issuing of the reminder notice, you will receive a cost calculation, which you can charge to the customer.
Proactive prevention
It is not always intentional that customers pay late! According to a 2017 study by the Consulting Agency Plum , about 2/5 of late payments are simply due to “forgetting”, but just under 2/5 of late payments are due to intentional delay in order to squeeze out a few more days of credit. However, both of these factors require an enormous amount of work on the customer side and increase commercial administrative costs quite considerably. Depending on the salary costs of the person involved, a completely manual invoice from receipt to payment can cost between 15 and 60 euros. That's not a fixed cost! Here you will find a calculatorto estimate how much an incoming invoice actually costs. If that's not an argument for using an electronic invoice receipt ...
Clear payment targets
Do not formulate your payment terms with wishy-washy phrases like “Please pay on time”. This may ensure a legally regulated payment term of 30 days, but who knows? Write on your invoices: “Final amount of 500 euros payable by 31.12.2023, discounted payment (payment amount = 480 €) by 1
Don't you know how to do this in Navision Financials Dynamics Attain or Microsoft Business Central BC365? Contact me!
Correct invoices
Probably not an issue for you if you use Financials Dynamics or BC365, because their ingenious merchandise management and financial accounting does everything right on its own... if you give it a chance! Use more discounts than special prices. You have to correct special prices regularly, but discounts rarely. Use real items and real customers. Do not use various customers & supplierswhere you have to repeatedly enter address data by hand. “Manually” means ‘including typos’. Maybe not always. But more and more often. With electronic invoicing (whether EDI or xRechnung or ZUGFeRD), this will be mandatory anyway, so various customers and suppliers will no longer be an issue. Do not use various items. Errors in prices and discounts are not only possible here, but inevitable. With poorly organized customers (hopefully you are not one of them), faulty invoices are often not recognized until the day of payment – and only then do you complain. For you as a supplier, this results in an even longer payment period.
Prepayment
The last resort in Germany. But if your customer is based in other countries, they may be used to paying in advance! Use this payment behavior. You may be able to simplify this for your customers so much that it no longer feels like prepayment by using PayPal and automated emails with ready-made PayPal payment instructions. Not sure how to implement something like this in your Navision or Microsoft Business Central BC365? Contact me regarding this!
Dropshipping, FBA
Do you supply certain customer groups, such as end customers, with, for example, Amazon or ebay? Here, customers are also accustomed to prepayment without long discussions.
Fast invoicing
Don't wait too long to issue your invoice. For example, you could invoice every evening or every Friday. If your slow customer always waits until after 45 days to pay because they think they are saving money, and you only invoice at the end of the month, in the worst case you have 30 days (delivery of goods on the 1st of the month, invoicing on the 30th of the month) + 45 days (payment period for the customer) = 75 days delay between goods issue (you have to buy again!) and payment issue.
Simply write your invoices every evening! This way, you can reduce the customer's late payment from 75 days to 45 days, a whopping 60%, without any unpleasant conversation or any other obstacle, and every Friday at 6 p.m., another 50%. With your Navision and email invoices (whether PDF or edifact or xRechnung), this can be even fully automatic, without anyone in the office even having to press a button! And thanks to email, postage and envelopes are also saved.
Direct debit
Offer your defaulting customers (or all of them!) direct debit as a payment method. You can also make this appealing to them:
* Never again reminders
* Never lose a discount again.
* Less work for your customer
You can also automate this almost completely with your Navision / BC365. Thanks to automatic open item clearing, this involves much less work for you than posting incoming payments!
Quick payment reminders/dunning letters
Thanks to the integrated dunning process in Navision, ideally combined with reminders via email, you can create friendly payment reminders or sharp reminders at the push of a button – without a lot of work in your company.
English 
Deutsch 
Español