×

Warning

JUser: :_load: Unable to load user with ID: 43

JUser: :_load: Unable to load user with ID: 40

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.

Creating a standalone invoice

Read more ... (index.php?option=com_content&view=article&id=1159&...

Removing records from ISPadmin

Delete client Deleted client is not deleted from the system, instead its rec...

Add new / Edit existing Service

If you have added a new client, it just a contact which is not linked to any ac...

System Variables

Read more ... (index.php?option=com_content&view=article&id=1380&...

Accepting Cash Payment

overpayments (index.php?option=com_content view=article id=1088:overpaymen...

Edit invoice

Modify an invoice changing the following: Title Item description ...

No permission for adding overpayment into client´s credit

If you are trying to add overpayment, and see Permission denied message you h...

Limited data consumed / Traffic graphs are high

If you experience one/both of the following problems Limited data gets consum...

Suspension of service

The function of suspending a client serves to temporarily block the service with...

How to display client portal login credentials on an invoice

In Invoicing Settings Invoice Groups, while adding a new group (+ Add new group)...

Creation of client number

While adding a new contact to the system, you will be offered first unused clien...

Add New Contact

a requested service in Client card (index.php?option=com_content view=article...

Return of overpayment

Bulk order (index.php?option=com_content view=article id=628:returned catid=488:...

Send invoices by email

Invoices get sent in PDF automatically upon their issuing. Sending via both, reg...

Entering an address

You have the following options to enter address: Fill in respective fields: S...

More than 1 item in email or phone number fields

You will be able to add more items in every field in the system designed for ema...

PING to client does not work

PING to client function is off by default. It is to reduce network load which in...

Charging clients for tariff changes

You might want to charge clients, for example, when they decide to change to ...

One-time invoice for a service provided in a certain time period

If you want to issue a one-time invoice for a certain service that is provide...

How to give a discount

Options for discount of regular service rate are as follows: Tariff rate dis...

VAT missing on a cash receipt

If the client pays for the invoice in cash, VAT tax is not stated on the cash re...

How to send a client an email containing all of their unpaid invoices

If you want to send a particular client an email containing all of their unpaid ...

How to issue an expenditure cash slip

The system issues an expenditure cash slip when overpayments are refunded in ...

How to assign an IP address pool to a client

When editing/adding the Internet service (index.php?option=com_content view=arti...

Filtering clients base on their invoicing

Invoicing is related to services, not clients. A client can have e.g. 2 active s...

Displaced invoice margin

If invoice margins are printed incorrectly you have to check print settings of P...

Use of IP address

To find out, which client used a certain IP address in specified time, go to ...

Lookup by phone number

You can use http://ISPadmindomain.com/new/www/find-client-by-phone-number/?numbe...

How to increase internet speed in off-peak hours

If you want to increase a client&rsquo;s Internet speed in off-peak hours...

Is it possible to set an installation fee discount anywhere in the system?

No, it is not. You cannot enter such a discount to the system at the moment. ...

How to add a NAT IP address

A NAT IP address can be added in the Client card. When you are editing the In...

Suspension of the internet service at the client's request

If your client contacts you and wants you to temporarily suspend the Internet...

Is it possible to set a specific speed for IPTV service?

No, it is not possible. You cannot set up special speed profiles for the IPTV...

How to add supplementary information to contact emails and phone numbers

If you need to add supplementary information to a client's email address and ...

Is it possible to export/print out all the contracts of a client at once?

No, it is not possible. Each contract is unique. It is a single file and it i...

«
»

CONTACT

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