The Automatch functionality will automatically locate and match transactions found in the Match Transactions screen of the same amount and within a selected date range that go in opposite directions.
In this article, we will teach you the following:
Navigate to Fund Level > Match Transactions > Automatch
How Automatch Works
Below is a matrix to show how the Automatch function works:
Automatch will match off Cash Transactions to Business Events, Cash Transactions to Cash Transactions (e.g. transfer between two bank accounts) and Business Events to another Business Events (e.g. personal contribution against fund expense).
- Click the Automatch button
- Select a day to narrow the match criteria or leave as default
Scenario | Automatch Result |
---|---|
The transactions occur on the same date and for the same amount |
Y |
The transactions occur within 7 days of each other & have a variance of +/- 50 cents |
Y |
The date range of the transactions exceeds 7 days |
N |
The amount of the transactions have a variance of greater than +/- 50 cents |
N |
Distributions from Managed Funds often fall out of the 7 day range as only the account date is provided not the payment date. If this occurs you will need to select the tick box next to the appropriate Cash Transaction and select the tick box next to the appropriate Business Transaction and click Match
Automatch Steps
- Click the Automatch button
- Select a day to narrow the match criteria or leave as default
Search Days Action Auto (Default) All matches within the 0-7 day date range will be displayed 0 All matches where the cash transaction and business event are on the same date will be displayed 1-7 All matches where the cash transaction and business event fall within the number of days selected will be displayed. e.g. if "1" then it will show those within one day of each other
- Click Run Automatch
- All suggested matches that can be found will then be displayed in the Confirm Automated Transactions screen.
- If you wish to proceed with the suggested matches then click Save Suggested Matches. If you do not want to proceed, click Cancel or untick the transactions you do not want to match.
What's Next?
Learn how to manually match by using the Match to New feature