Why Can't I See a Transaction when I Click Find Match?
If you want to match a bank statement line to a particular transaction in Migration Manager and you click Find Match, there might be times when you can't find the transaction you want to match to. There are 8 possible reasons for this:
1. The Transaction has Already been Matched to Another Bank Statement Line
One of the most common reasons for not being able to find a transaction in the Find Match window is because it's already been matched to a different bank statement line. To check this, click on the Transaction Tab of the Bank Reconciliation Form. Select a From Date that is on or before the transaction date for the transaction you're looking for and a To Date that is on or after the transaction date. Click the Refresh button.
If the transaction has already been reconciled, the status will show as Reconciled
2. The Transaction was Entered in MM After the Bank Reconciliation Period
The Find Match form shows transactions that were entered in MM during the reconciliation period. If your transaction has a transaction date that's within the reconciliation period but wasn't entered into MM until after the reconciliation period, it will need to be added as an adjustment. To add the transaction as an adjustment, click Find Match.
On the Find Match form, click Add Adjustment
Your transaction should appear in the Add Adjustment form. Select the transaction, enter a reason for the adjustment and click Save & Close.
If this bank statement line matches to multiple MM transactions, select any other bank statement lines it matches to. Then click Match.
3. The Transaction has the Wrong Transaction Date
If you accidentally entered the transaction in MM with the wrong transaction date and that date is after end of the reconciliation period, you won't be able to match to the transaction. This can be resolved by reversing the transaction and recreating it with the correct transaction date.
4. The Transaction was Recorded Against the Wrong Bank Account
The reconciliation is specific to a particular client bank account. If you accidentally recorded a transaction against the wrong bank account, you won't see it in the Find Match form. You will need to reverse the transaction and re-create it against the correct bank account.
5. You want to Match a Bank Statement Receipt to an MM Payment or a Bank Statement Payment to an MM Receipt
There will be times when you want to match a bank statement receipt to multiple transactions including an MM payment or vice versa. eg if your bank combines all POS transactions for a single day into one bank statement line, you might want to match the POS bank statement entry for a particular day to several different receipts plus a refund. By default the Find Match form will only show receipts if the bank statement line is a receipt and will only show payments if the bank statement line is a payment. In the example above, it will only show receipts. If you're matching a receipt bank statement line, you can show the payments by ticking Show Payments. If you're matching a payment bank statement line, you can show the receipts by ticking Show Receipts.
6. The Transaction has been Excluded from the Reconciliations
To check if the transaction has been excluded from the reconciliation, click on the Transaction Tab of the Bank Reconciliation Form. Select a From Date that is on or before the transaction date for the transaction you're looking for and a To Date that is on or after the transaction date. Click the Refresh button.
If the transaction has been excluded, the status will show as Excluded.
7. You're Looking for a Cheque or Cash Receipt
Cheque receipts and cash receipts can't be matched to because they don't affect the bank statement. Instead, you should match to the bank deposit that includes the receipt you're looking for. If you can't find the bank deposit in the Find Match form, make sure the bank deposit has been recorded in MM and check points 1 to 6 for the bank deposit.
8. You're Looking for an Office Account Transaction
Migration Manager allows you to reconcile the client/trust bank account. However because it doesn't have a full list of office bank account transactions, it can't be used to do office bank account reconciliations. Office account transactions won't show in the Find Match window.