Smart Matching

Print Friendly and PDF

Overview


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.

Known Unknown
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.

Navigation


From the Main Toolbar, go to Accounting.
Select Smart Matching.

Getting started


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:

www.sf360.com.au_s_banking__firm_trainingvic_uid_1454_mid_8a348b916996d57f016998951b8e005a_p_sfund__3_.png

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.

www.sf360.com.au_s_banking__firm_trainingvic_uid_1454_mid_8a348b916996d57f016998951b8e005a_p_sfund__4_.png

Confidence Level

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:

  • Description
  • Date
  • Amount

 

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.

www.sf360.com.au_s_banking__firm_trainingvic_uid_1454_mid_8a348b916996d57f016998951b8e005a_p_sfund__6_.png

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.

www.sf360.com.au_s_banking__firm_trainingvic_uid_1454_mid_8a348b916996d57f016998951b8e005a_p_sfund__5_.png

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 sub account 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

uat.sf360.com.au_s_banking__firm_sf360test_uid_7570_mid_8ad08af06023b949016023c923a20000_p_sfund__searchText_searchFund__searchSelectedIndex_0__searchType_searchFund.png

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.

Custom Rule

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:

www.sf360.com.au_s_banking__firm_trainingvic_uid_1454_mid_8a348b916996d57f016998951b8e005a_p_sfund__7_.png

The description for the selected transaction will be the basis on which the rule is created.

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.

Additional Features


Split

The split feature allows you to take a single unmatched bank transaction and match it to multiple chart accounts at once.

Example

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.

Search

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.

Example

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 fund uses the Corporate Actions screen to process this transaction from WHC.

The unmatched Corporate Actions transaction can also be seen in the Transaction List:

First, the unmatched Bank Transaction will be found in the Smart Matching list

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:

Notice that there is a shortfall of $60. The Split feature will be used to create the additional transaction. The Split Transaction tab is selected

An account is selected to allocate the Shortfall to and a description is recorded

Sortable Columns

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.

Filterable Columns

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

Clear Filters

To remove all active filters being applied to the Smart Matching transaction listing, click Clear Filters

Date selector

Select key dates quickly and effortlessly at the press of a button using Simple Fund 360's keyboard shortcuts.

Invest some time getting familiar with the shortcuts to save you time in the long run when selecting dates in Simple Fund 360.

Day 
Today T
Tomorrow +
Yesterday -
Week 
First day of the week W
Last day of the week K
Month
Next month Page Up
Prior month Page Down
First day of the month M
Last day of the month H
Year 
Next year Home
Prior year Home
First day of the year Y
Last day of the year R
Financial Year 
First day of the financial year F
Last day of the financial year E or L

 

Productivity Tip: Using the shortcut

1. Ensure there is a date in the date field

2. Click into the date field 

3. Press the shortcut

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:

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

  • synced-from-confluence