Overview: Matching rules in Active Workpapers define how client accounting accounts are automatically mapped to a master chart of accounts, with the ability to assign account types, taxonomy links, risk priorities, and various codes for reporting purposes.
Please refer to the Glossary for definitions of key terms used in this article.
Watch the video
Customise matching rules
From the Admin Centre, click on Workpapers Admin under the Workpapers banner.
Click on Matching Rules under the Binders banner.
The Active Platform ships with a standard set of matching rules as below.
Add new matching rule
In this example, a matching rule will be created for a Stripe bank account to allocate this to a cash and bank balances account type.
Click Customise Set to enable editing.
Select + New Matching Rule.
Select whether you would like your rule to search by account name, code or type.
Tip: Account name is the most common way to match an account.
The following fields will be available for completion.
FIELD | DESCRIPTION | VALIDATION |
Match Field (dropdown menu) | This is to decipher the matching rule type.
| Required |
| MATCH CONDITIONS |
|
For the Classification (dropdown menu) | Allows a match for an account classification, such as assets or expenses. | Required |
Find | This is where you type the phrase for the system to find the account. | Required |
Case Sensitive (checkbox) | The find condition can be made case sensitive by clicking the 'Case Sensitive' box. Leave unticked for a more accurate match. | Optional |
Search Mode (dropdown menu) | Relates to where in the account name the system should search for your phrase. Anywhere will tell the system to find the phrase 'Anywhere' in the account name, whereas 'Begins With' will only recommend the worksheet against an account that begins with the phrase. | Required |
Apply to all accounts, including manually set ones (checkbox) | Will apply the rule to all accounts coming into Active Workpapers, including ones that have been manually set. Tick the box if you wish to override manually set account types with this rule to enforce consistency. | Optional |
| LINK TO |
|
Header (dropdown menu) | This is the header account you wish to link the matching rule to. | Optional |
Account Type (dropdown menu) | Where the account type you wish for the account to be allocated to in Active Workpapers is to be set. | Optional |
Link Taxonomy (checkbox) | Where the account can be linked to a taxonomy area for tax reporting. Link to the Cash and Bank Balances taxonomy. | Optional |
Primary Production (checkbox) | If the account you are creating a matching rule for is Primary Production related, tick this box. | Optional |
Non Taxable (checkbox) | If the account you are creating a matching rule for is non-taxable, tick this box. | Optional |
Risk Priority | Select the risk priority of the account from Low to Critical, and this will display within the worksheets for this account. For example, a legal expenses account may be deemed to be High Risk due to the varying tax treatments available. | Optional |
| FOR EXTERNAL REPORTING USERS ONLY (TURNED ON AT FIRM LEVEL) |
|
Benchmark Code | A customisable set of codes designed to correlate information across clients by industries or other business subsets and are used to tag accounts for reporting purposes. | Optional |
Mapping Code | This is the firm set of codes that are used to map accounts to the external reporting system. Unlike account types, it is customisable and can go to more levels of detail if required. | Optional |
Sub Code | An optional additional character or number which can be appended to the end of the mapping code in various in export scenarios. | Optional |
Once the above details have been completed, select Save.
The matching rule has now been created.
Add as many matching rules as your firm requires to increase standardisation and consistency of Workpaper binder preparation.
Revert to master matching rules set
To revert a matching rules set to the default, click Revert to Master Set.
By clicking Yes, I understand the consequences, this will delete all the rules manually created by the firm.
