Magic Match automatically finds matching transactions or payments in Juan when you upload your bank statements.
A banner with this information will be displayed for each bank account with uploaded statements.
If there are no magic match suggestions, you can manually reconcile the statements. Refer: Different ways statements can be reconciled.
Juan uses specific criteria to match transactions with statement lines:
With Contact (Payer/Payee): Juan looks for transactions within 30 days before the statement line date where the contact and amount match.
Without Contact (Payer/Payee): Juan looks for transactions within 30 days before the statement line date where any contact and the amount match.
Payment (Cash-Out/Cash-In Entries): Juan also matches these entries against statement lines with the same bank account if the transaction date is within 3 days before the statement line date.
Juan shows potential matches with statement lines, but if one transaction is matched with multiple statement lines, reconciling will not allow both to reconcile with the same transaction. Instead, you will see a partial success banner and only the first statement line in the list will be reconciled.
The only reason a record with the same date and amount as the statement line is not matched is that the contacts do not match.
There is no limit to the number of matches that can be returned.
Juan matches all transactions that meet the following conditions:
Date
Amount
Contact
This includes transactions such as:
Invoices
Bills
Customer credit notes
Supplier credit notes
Journals
Invoice payments
Bill payments
Customer credit refunds
Supplier credit refunds
Cash-in
Cash-out
Cash transfer records
Yes, statement lines are always reconciled with payment records.
When using Magic Match, which recommends a transaction match, Juan creates a payment in the background and reconciles that payment instead of the transaction itself.
Yes, absolutely! You can manually reconcile each statement line. To know more refer: Reconciliations Overview
