Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Image Removed

NOTE: Prime Billing App required

Content

FeatureStateDetailsStart here..

Requirements

Dependencies

Recent Updates

DateShort description

Additional info

Description

This module contains This module contains the overview of all overdue payments - here called: debt - of the customers.

With this module it's possible to upload a SWIFT/MT940.sta bank transaction file. On parsing the file and it's transactions return debit notes and customer transfers are assigned as debts to the appropriate customers.

In the near future this module will contain the functionality It's able to create dunning letters for customers having overdue payments/debts.

NOTE: Prime Billing App required


Image Added

Package name: overduedebts

Github

Forum: General

Content

FeatureStateDetailsStart here..
Overview Dashboard(//)Obtain an overview of all overdue debts.




Allocation(//)Allocate corresponding transactions as liabilities.




Dunning Letters(//)Create automated dunning letters for customers having overdue payments.




Requirements

Recent Updates

DateShort description



Additional info

Explanations


Debt management options

You can configure your NMSPrime instance to manage overdue debts / outstanding customer payments by one of the following 2 ways by editing /etc/nmsprime/env/overduedebts.env in your NMSPrime VM.

Note: If you already use your financial accounting software to create dunning letters and you import the bank transaction file to that software you would have the same work of assigning transactions with bad transfer reason to your customers. In this case option 2 does better suit for you.

Parse bank transaction file



Code Block
languagebash
title/etc/nmsprime/env/overduedebts.env
DEBT_MGMT_TYPE=sta

This way the settlement run will create a debt for every customer. It automatically closes the created debt by another debt if the customer has a valid SEPA mandate.

On uploading the bank transaction file of the format MT940/Swift NMSPrime tries to clear open debts or creates new ones if the direct debit failed. A logging tab shows all infos, errors and warnings of the assigned or not assigned transactions - e.g. if the reason of transfer didn't contain the invoice number.

NOTE: all manually done customer transactions need to have the invoice number in its reason of transfer.

(Refer to the internal page Dunning Design Decisions for the reasons of this design decision)

Upload resulting debt list from financial accounting software


Code Block
languagebash
title/etc/nmsprime/env/overduedebts.env
DEBT_MGMT_TYPE=csv


The CSV to upload must contain the infos in the following format:

column nr0123456789101112
general headline/datacustomer nr


voucher nrdate
amount
missing amountdescriptiondunning date

dunning indicator

EuroFiBuKundennummer(Kürzel)(Anrede)(Name)BelegnummerBelegdatum(Skontodatum)Betrag(Skonto)AusstandTextMahndatumMahnkennung
DATEV exportKontonummer(Kurzbezeichnung)(Anrede)(Name)Rechnungs-NrRechnungsdatum(Fälligkeit)Betrag Soll(Skonto in Prozent)SaldoBuchungstextMahndatumMahnstufe


Color meanings
column must contain data
column can be empty - data could be used in future



...