Rules

invoicing matching rules

 

How matching rules work

 

When automatically processing imported payments, the system goes through the payment matching rules and looks for an invoice or client that meets the criteria set out in the individual rules. A given payment will be matched with an invoice or added to a client’s credit on the basis of the first rule that finds a match. There are six system rules that help to maintain the functionality of this part of the system. They work in the same way that payment matching worked earlier. These rules cannot be deleted or edited. You can activate icon check ko / deactivate icon check ok a particular rule in the Active column.

 

 

You can add a new rule by clicking on . The form that you have to complete on this page consists of three parts:

 

Payment matching type

 

  • Match payments on the basis of the data given in: Client
    Payments will be matched on the basis of the data given in the Client card (Client number, Assigned VS)
  • Match payments on the basis of the data given in: Invoice
    Payments will be matched on the basis of the data given in invoices issued (Invoice number, Client number, Assigned VS).

 

Criteria

 

The criteria used to match payments At least one must be used. If there is more than one, all must be met for payment matching to succeed.

 

  • The VS of a payment has to be the same as: Invoice number, Client number, Assigned VS
  • The SS of a payment has to be the same as: Invoice number, Client number, Assigned VS
  • The payment note has to be the same as: Invoice number, Client number, Assigned VS
  • A client’s bank account number has to be the same as the the bank account number stated in the payment details: Yes, No
  • Payment Amount:
    • = Invoice – The payment amount has to be the same as the invoiced amount (Invoice settled).
    • < Invoice – The payment amount has to be less than the invoiced amount (Invoice partially settled).
    • > Invoice – The payment amount has to be greater than the invoiced amount (Invoice settled and the rest added to credit).

 

What happens when criteria are met

 

  • Action:
    • Match with the oldest invoice - Match a given payment with the oldest invoice of a given client.
    • Match with the newest invoice - Match a given payment with the newest invoice of a given client.
    • Add to credit - Match a given payment and add it to a given client’s credit .
  • Note: The note that will appear in a payment matched according to this rule

 

 

Having created and ordered rules, you can check whether they work correctly by clicking on Test rules for payment matching. A form appears into which you can enter payment details (Payment VS, Payment SS, Bank account number, Amount, Note). You can start the test itself by clicking on Test. Once the test is finished, a table appears in which you can see individual rules with lists of invoices or clients found. The rule according to which a given payment would have been matched is highlighted in green.

 

 

In the overview, you can find all the necessary attributes related to individual rules. You can order these rules (according to your needs) with the help of the arrows in the Priority column. When matching payments, the system goes through the rules in the order that you have set.

 

Priority The order in which individual rules will be employed to match payments
Match payments according to the data in Payment data are compared with invoice data / client data.
Payment VS (Variable symbol) has to equal to Invoice number / Client number / Assigned VS 
Payment SS (Specific symbol) has to equal to Invoice number / Client number / Assigned VS 
Payment note has to equal to Invoice number / Client number / Assigned VS
Account number A client’s bank account number is / is not the same as the bank account number stated in the payment details.
Payment amount The payment amount is equal to / greater than / less than the invoiced amount
Note The note that will appear in a matched payment 
Action What happens when there is a match between a payment and a rule 
Active Activate/deactivate a rule
Editing and deletion Your own rules can be edited or deleted. System rules can only be deactivated. Rules can be edited only when they are active.

Tips on how to use this documentation

 

Search

Searching required information is possible either via structured menu which is divided into sections, or via full-text search of the entire contents of this on-line documentation.
Breadcrumbs

This aid will make it possible for you to find out where exactly you are at the moment.

If, for example, the following appears beneath the main menu - ISPadmin Wiki / ENG / Client management / Menu - CLIENTS / Clients / Message Board / Groups - it means that you are:

 

  • in the Wiki documentation of the ISPadmin system
  • in its English localization
  • in the Client management section
  • in the Clients tab
  • in the Message board subtab
  • in the Groups sub-subtab

Changelog

It contains newly added functionalities and modifications of the system which are displayed by versions and issue date. Changelog articles are also displayed in individual sections / pages of the documentation which relate to new functionality or modification. 

Basic orientation

You will find a welcoming menu with basic instruction on trying / implementing / using below. 

FAQ

Frequently asked questions along with most important procedures and settings are listed in FAQ section. 

Colours

Items which refer to real system menu are highlighted in corresponding colour, including their graphical background. Eg. Invoicing Settings Templates Reminders. This is also a working reference to an article. 

CONTACT

NET service solution, s.r.o.
Žerotínova 3056/81a
787 01 Šumperk
Czech Republic