Transaction Matching Deprecated
Please note that the old Transaction Matching screen will be deprecated in the next release. Save time with Simple Fund 360's new and improved Smart Matching.
Spend less time processing a fund, and more time creating value for your clients with Simple Fund 360's revolutionary new Smart Matching AI.
Harness the power of the millions of transactions that power Simple Fund 360's Deep Learning algorithm to make manual journals a thing of the past. Simple Fund 360's Smart Matching AI is your personal processing assistant that uses its experience of millions of other transactions to assist you in deciding where to match a transaction.
Keep reading to discover how Simple Fund 360's Smart Matching works behind the scenes, and learn recommended practices for getting the most out of Smart Matching.
What transactions does Simple Fund 360 know automatically?
To understand why Smart Matching is needed, an understanding of what transactions Simple Fund 360 knows and does not know is required.
|Transaction type||Source||Transaction type|
|Bank transactions||Bank Feed, CSV Upload, etc.||Pension payments|
|Security buy and sells||Contract Notes Service, wraps, broker file upload||Accounting fees, audit fees|
|Income (dividends and distributions)||ASX data feed, wraps, Registry Data Service||Property income|
|Corporate actions||ASX data feed, wraps||etc...|
Simple Fund 360's smart matching will allow you to minimise the amount of time spent matching unknown, or unmatched transactions.
|From the Main Toolbar, go to Accounting.|
|Select Smart Matching.|
All unmatched bank transactions will appear in the Smart Matching list under the ALL tab.
Transaction matches existing rule
Unmatched transactions that match a pre-existing rule will have their rule displayed next to them in green:
The displayed rule can be applied to the transaction by clicking on Match
Productivity Tip: Bulk processing
Click the Recognised tab to view all transactions that match a pre-existing rule.
To apply a rule to its matched transaction in bulk, select all transactions in the Recognised tab
Then select Multiple Match
Transaction does not match existing rule
Unmatched transactions that do not match an existing rule will be displayed with their predicted chart account next to them.
These transactions will have a confidence level displayed next to them indicating the certainty Simple Fund 360 feels in allocating the transaction to the predicted account.
Gain insight into the inner workings of Simple Fund 360's Deep Learning algorithm by viewing the confidence Simple Fund 360 feels in allocating an unmatched transaction to its predicted account.
Simple Fund 360 compares the unmatched transaction to the millions of similar transactions it has seen previously to build a confidence level in matching the transaction.
The features of the transaction analysed include:
Simple Fund 360 does not require more information
If Simple Fund 360 is confident that it has enough information to match the transaction to the correct chart account, there will be a Match button next to the unmatched transaction. Click Match to code the transaction to the displayed account.
For example, Simple Fund 360 has correctly identified the above interest transaction (Credit Interest 12448) as needing to be coded to the Interest Income account for the associated bank account. As it does not require further information to match, clicking Match will code the transaction to the predicted account.
Simple Fund 360 requires more information
If Simple Fund 360 requires more information from you to match the transaction to the correct chart account, there will be a Review button next to the unmatched transaction. Click Review to record the additional information needed to match the transaction.
For example, Simple Fund 360 has correctly identified that the above dividend transaction (Direct Credit 396297 BHP DIVIDEND MAR16/00822938) as being a dividend, but it is not sure which sub-account or security this dividend belongs to.
Once the subaccount has been selected, the transaction may now be matched by clicking Match.
Note that any future transactions with the exact same narration will be coded to the indicated account in the future.
Predicted account incorrect
If the predicted account is incorrect, please feel free to change this to the correct account.
Transaction more details
When matching a transaction, Simple Fund 360 allows you to enter additional information relevant to the particular transaction being matched.
For example, when matching an investment disposal you are able to enter the contract and settlement dates, or if matching a dividend payment, the franking credits attached to the dividend may be edited.
Numerical expression support
All numerical input fields support numerical expressions. These can be identified by the green border surrounding the input field.
Have your calculations displayed in front of you while Simple Fund 360 calculates the final result.
Leave it uncategorised
Tick the Leave it uncategorised option to do a once off match when matching a transaction.
Simple Fund 360 will not remember this transaction's description in the future. Any future transactions that have the exact same narration will still need to be matched.
This feature is ideal for matching transactions containing a common description that you would like Simple Find 360 not to remember.
For transactions that do not have a pre-existing rule to match against, you are able to create a rule from the Smart Matching screen.
When reviewing the unmatched transaction, select Create Custom Rule to use the current transaction as a template for creating a custom rule:
The description for the selected transaction will be the basis on which the rule is created.
Additional conditions can be added that will be used in determining which rule a given transaction will match. These additional conditions include:
A matched transaction can be split between multiple chart accounts when creating a rule. This is especially useful for transactions which include amounts that should be included in multiple chart accounts e.g. pension payments, joint accounting and audit fees, etc.
The transactions can be split by either a percentage or a fixed amount.
For contributions, change the Account Type to Contribution, this will make allocating the contribution type amounts easier as all members will be displayed at once in the screen.
Example - Splitting a transaction
A pension payment of $23,000 has been made for two members of a fund; John Jones and Mary Jones. Each member was paid a pension of $11,500.
|Bank Data Clearing Account||$23,000|
Creating the rule
The condition will only look at the description of the unmatched transaction and check that it contains the text "Pension payment - John and Mary Jones":
For this transaction, the payment amounts will be split evenly between both members. This will be achieved by setting the Allocation Type to % and setting the percentage to 50% for each member.
This rule can be modified if needed to allow it to match more transactions.
For more information on creating custom rules please refer to: Custom Rules.
The split feature allows you to take a single unmatched bank transaction and match it to multiple chart accounts at once.
In this example,there is $2,500 that has left the bank account and requires to be matched.
As this bank transaction represents the payment of both an accounting fee of $2,000 and an audit fee of $500, this amount will need to be split to the respective chart accounts.
Expand the transaction by clicking on it, and select Split.
Change the amount allocated to the first account to be less than the full amount of the unmatched bank transaction. This will automatically create an additional field to record the other account to allocate the outstanding amount to.
Simple Fund 360 now supports the ability to enter arithmetic calculations in all Debit and Credit fields.
See, Arithmetic Calculations
The search feature allows you to take a single unmatched bank transaction and search for all other non-bank transactions to match it to.
Non bank transactions here include:
- Income transactions from the ASX Data Feed and wraps
- Security buy and sell transactions from the Contract Notes Service, or a Broker File Upload
- Corporate Actions transactions
Why is this needed?
Ideally the above transactions would automatically match with the unmatched bank transactions.
However, different data providers providing transaction information that sometimes fall outside Simple Fund 360's strict matching requirements may result in the transactions not being automatically matched and may require to be searched then matched.
Simple Fund 360 will intelligently locate all transactions that sum to the selected transaction's amount and suggest these to be matched.
A fund has imported a broker file of security buy and sells which has not auto-matched to their respective bank transaction:
The bank transaction (ETRADE: BUY SHARES) has not automatically matched with the three share purchase transactions below it.
To use the Search feature to automatically locate the transactions to be matched, select the unmatched bank transaction in the Smart Matching screen.
The Search button will indicate the number of found transactions that can be matched with the selected unmatched bank transaction:
Productivity Tip: Simultaneous Search and Split
Smart Matching's Search and Split features can be used together to save you time in processing common transactions in Simple Fund 360.
Example: Return of capital and Dividend
A fund holds shares in Whitehaven Coal (ASX:WHC) which has recently paid out an amount to shareholders comprising of both a return of capital and dividend.
The fund has received $200 in its bank account. Of this amount, $140 is the dividend and $60 is the return of capital.
The unmatched bank transaction is can be seen in the Transaction List:
The unmatched Corporate Actions transaction can also be seen in the Transaction List:The fund uses the Corporate Actions screen to process this transaction from WHC.
Next, the Transaction will be selected. After this, the unmatched Corporate Actions transaction will be searched for.
The unmatched Corporate Actions transaction has automatically been found to match against the unmatched Bank Transaction. This transaction is selected:
An account is selected to allocate the Shortfall to and a description is recorded notice that there is a shortfall of $60. The Split feature will be used to create an additional transaction. The Split Transaction tab is selected
Sort any column in the Smart Matching screen by clicking the column header.
Simple Fund 360 will remember your preferences and keep all transactions sorted by the selected column next time you log in.
Filter any column by typing into the text fields underneath the header of each column to only show transactions that match the entered criteria:
Filter by numeric value
You are also able to filter any column that contains a numeric value by entering a number and an optional operator including:
- >: values greater than
- < values less than
- -: values between a range
To remove all active filters being applied to the Smart Matching transaction listing, click Clear Filters
Delete transactions in bulk
To remove multiple transactions at once, select the transactions to delete by checking the box next to the transaction:
Next to Multiple Match, select the drop down arrow then click Delete Transactions: