Magic Match automatically pairs your bank statement lines with corresponding records in Juan. It simplifies the reconciliation process, making it faster and more accurate regardless of your accounting experience.
You will see a notification banner whenever Magic Match finds potential pairings. If Juan doesn't find a match, you can manually reconcile the entry.
Juan uses Magic Match which aims to save you time in reconciliations. It looks beyond dates and amounts, using layered search logic to suggest the most accurate records for your reconcilation:
Payment Recognition: Magic Match detects internal records, such as bill payments, customer refunds, or manual journal entries, that correspond to your bank activity.
Multidimensional Matching: Magic Match goes beyond amounts and includes contact names, reference numbers, and descriptions in order to find transactions to match a statement line with high confidence.
Date Windows: Magic Match identifies your typical payment patterns to suggest matches that occurred within a logical timeframe of your statement line.
Currency Conversion: For cross-currency matching, Magic Match identifies transactions even when the currency of your invoice is different from the currency of your bank account.
Group Matching: If a single bank entry represents multiple invoices or bills (such as a bulk deposit), Juan can identify and suggest the specific combination of records that add up to that total.
Note: Although Magic Match provides you with high confidence of reconciliation, always make sure to double check.
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
