Dunning / Mahnung / Warning Notice

Taking on this topic again:

How late payments are handled in Germany

Usually, the due date is 14 days after the invoice date. When the invoice is overdue, send a friendly reminder. Then, the fun, a dunning process, starts:

  1. Send the first warning notice (“1. Mahnung”)

    • Charge a warning fee
    • Set a new deadline, say 8 days

    In order for the debtor to be officially in delay of performance, the creditor generally must provide the debtor with a warning notice. […] Irrespective of a warning notice, the debtor is in delay of performance at the latest after 30 days following the payment due date and presentation of the invoice.

    • From now on we charge interest on the invoice total

    If the debtor is in delay of paying a money debt, then the creditor may claim the interest on arrears as so-called loss caused by delayed performance.

  2. Second deadline arrives, send next warning notice.

    • Charge a warning fee
    • Charge interest
    • Set a new deadline, say 5 days
  3. Third deadline arrives, send a final warning notice.

    • Charge a warning fee
    • Charge interest
    • Set a new deadline, say 3 days
  4. (Fourth deadline arrives, hand the case over to a lawyer.)

Each stage should result in a new PDF document that references the original invoice but with a different title (“Warning Notice 1”, “Warning Notice 2”, …), new due date, fees and interest.

So, first, the customer owes € 100.00, then € 103.00, then € 106.00, etc. The amount continues to grow until payment is made. However, there will be no additional GL Entries until payment.

If we get paid – finally! –, we book the following:

Account Debit Credit
1800 - Bank 106.00
1200 - Trade receivables 100.00
7100 - Other interest and similar income 006.00

(Taxes ignored, for simplicity)

The DocType could look like this:

It fetches all relevant details from the Sales Invoice.

Print:

1 Like

@lasalesi, I have seen something similar in your app. If we get this into the core, would Swiss and Austrian users be able to use it?

1 Like

Hi @rmeyer,

thanks for sharing! This looks very good.

We have some differences that we apply, which I think are important. The dunning is maintained as a separate payment reminder document. In this, we aggregate all unpaid invoices from one debtor. Same as you, we keep a payment reminder level on each sales invoice and raise this (typically up to 3) at each reminder sent. This will impact the text blocks used for the payment reminder. Your print format looks very nice! As for the charges, they should not be applied on the sales invoice; they have to be accounted for separately in accounting, we do this at the payment entry.

So to your question, I guess most of our customers would keep the current implementation (at least for now, I don’t see v12 productive too soon). However, your feature is absolutely relevant and should be considered for the core. If we can help to improve it, let me know.

2 Likes

Is your aggregate payment reminder somehow linked to the dunning?

Thanks, I would be happy to get your help. Currently, I have it in a custom app: GitHub - alyf-de/erpnext_dunning: Mahnungen schreiben mit ERPNext

@rmeyer thank you for doing this and for making it available, we just forked it and we will install it. If there is anything we can contribute we will PR it. It would be great to get this in CORE in a generic way.

2 Likes

Have you considered dunning for multiple invoices?

Thanks, I’ll appreciate your contribution.

Regarding a generic way, I didn’t get much feedback from other countries on how they handle this. So I would say, let’s integrate this and let other countries adapt it later.

One question would be: shall we add this to the payment reminder or keep it separate?

I think enabling multiple Invoices would be a nice. :+1:

This is an announcement that we are currently working on improving the dunning app that Raffael created with the goal of being able to merge it into the CORE of ERPNext under accounting.

You can track current status and issues that we are raising here Issues · elexess/erp-dunning · GitHub and please comment if we are missing something.

Let’s try to get this as close to done as possible before we try to PR against the core. Also it is very important that perspectives of other countries are added. We are currently doing this from a German perspective but maybe dunning is done differently elsewhere and we can easily incorporate that.

2 Likes

The described workflow is valid for other countries. Ideally any customer communication should reference specific transactions and accumulated totals.

The ability to not record late charges as income is key as this is a pressure tactic and many times they are wiped out in exchange for full payment of original invoice.

I believe our dunning app is close to being done. I have made an 8 minute video walk through for those who are interested. Watch it here on Youtube.

We don’t really want to maintain this as a separate app. My goal is to now clean this up and get it ready for contribution to the ERPNext core. It is probably a day worth of work to get it merged, is anybody willing to financially contribute so we can pay Frappe to get this in Core?

POLL: Is this useful to you and should we try to get this into ERPNext core?

  • This is very useful
  • This is NOT useful

0 voters

Here are some screenshots

You can find the app here:

8 Likes

Great work, thanks a lot! Do you still plan to enable multiple invoices per dunning?

I’m ready to make the PR to the core, once we’re ready. There would be still some work needed to better integrate it with Sales Invoice (“Create → Dunning”, dashboard entry, sales invoice status according to dunning type).

3 Likes

I really like the approach and the way to get some feedback via this poll. I think this is a great example on how to get a matter like this moving forward and not letting it rot(*) inside a Custom App.


(*) no negative vibes implied. Just lack of ability to find better wording

We currently are not planning on multiple invoices per dunning, that could be useful but we were focussing on getting what you created to the level we need it at with single invoices.

Thank you for that, we noticed some more small stuff with currency precision and we might notice more bugs during our productive use. I think you can take what we have created by the end of the week and then work on getting this contribution ready.

1 Like

I think it shlould be generic so that it works for a single or multiple invoices. Usually it achieved by a table containing a list of overdue invoices, with a subtotal and interest calculated per line. I think my supplier has sent me a few over the past 10 years (they are Swiss, no excuse even for a single day… :grinning:). I will post a scan here during tomorrow.

1 Like

We could just use the function we can find in Purchase Order where we can pull Items from Material Request via “Get Items from” button.

That sounds like a system-wide logic applied.

Here is the main part of the remind I got from my supplier a year ago (we had some disputes at that time), I think it is a good example how a dunning letter for several invoices should look like:

1 Like

Allowing multiple outstanding invoices with the possibility of each having its charge will be great.

I like the work done here. We actually use a slightly different process, which aggregates invoices by customer to reduce number of payment reminders (we actually don’t call it dunning): implementation is available in the ERPNextSwiss app:

@dominik Thanks for putting all this together. This is very valuable work. Would love to see that in core in the future. Is there anything the community can do to help you with this?

I will talk to Frappe to see how to get this smoothly into the core.

3 Likes