The minimum steps required for the proper function of your matching rules :
Step 1 : Create a matching rule to Create a Sales and/or Purchases general account
Step 2 : Create a matching rule to Create a Sales and/or Purchases journal
Step 3 : Sales and/or Purchases invoice lines details
Step 4 : Create a matching rule for Contacts
First of all, three prerequisites are necessary before creating a matching rule.
NB : It is necessary to have the rights in order to go to the Administration module.
Prerequisites :
- The accounting plan must be imported
- The accounting journals must be created
- The taxes plan must be defined
In order to achieve those 3 prerequisites, please go to the Administration module, then Accounting on the left :
Step 1 : Create a matching rule to Create a Sales and/or Purchases general account
Please go to the Administration module, then System and Matching on the left menu :
NB : The matching rule creation principle for Sales or Purchases remains the same, only the content will change.
Depending on your needs, choose the place where the rule should be created.
- Click on Accounting account on customers invoices to add a sales rule for instance.
-
Click on the “+” button to create a new rule
-
- Enter a title corresponding to the desired rule, as below for example.
- Click on the Account menu to list the menu and choose the account on which the rule should apply.
- Click on Active to make it active.
- If you want, you can Filter the results, if you don’t choose any filter, it means you apply it for everything.
-
If we take back an invoice where the rule we just created must apply, we will be able to see it as below in Accounting.
-
If you click on Edit
You access this window with two menus : Journal and Account
Those two menus correspond to what has been predefined for the rule.
When you expand the menus, choices appear : Redo matching and View details
If you change your selection, you can Redo the matching, and thus restart the calculation.
NB : You will only be able to redo the matching if the accounting synchronization has not been done.
The “View details” button enables you to check if the calculation was successful.
The button exists for the journal and the account.
If everything is correct the background will be green, if not, red.
The “debug” function is used for developers.
The Journal details :
The Account details :
Step 2 : Create a matching rule to Create a Sales and/or Purchases journal
The principle is the same as for the first step, you have to choose from the list : Accounting journal on customers invoices for example.
To create a new rule please click on the “+” button at the top left :
- Add a title related to your journal, in our example Sales.
- Add the Journal : Sales
- Choose Yes to make the rule active.
- Then choose in the scrolling menu what your rule should apply to in order to filter, if you don’t choose anything, the rule will apply everywhere.
-
Step 3 : Sales and/or Purchases invoice lines details
When the first two steps are completed, it’s possible to define management rules by Article for example.
- Click on the Administration module, on the left menu System then Matching below.
- On the right of the list, select accounting account on customer invoice lines.
-
Then click on the “+” button at the top left to add a new rule.
- Add the Title (Account name as in the example below).
- Add the Account Number by typing the first few digits.
-
- Click on Active to make your rule active.
- Click on Choose a value, in our example we make a rule on Article.
-
A filter appears after choosing Article.
In our case, it will be an Article of Labor nature.
We also add the Contract Family.
We want to indicate the location of France.
You have to add an additional value to the Article : Partner (invoiced company) for a new filter to appear and thus choose the location : France.
If you need to create a rule with another European country, you will have to choose in the Geographic Zone : Europe - Intra-community zone.
NB : For example, if you have two matching rules, one with France and the other one with Intra-community zone, a particular order is necessary.
It is important to put first France and then the Intra-community zone. Put first the most precise to the most general, otherwise your rule won’t be taken into account.
Step 4 : Create a matching rule for Contacts
A matching rule is also necessary if you invoice on Contacts. In this case, also use the Partner filter (invoiced company) :
See other tutorials about matching rules :