Note: Prior to using the Bank Transaction Import function some configurations need to set first. Click here to view Banking Configurations
After reading the file, the program will perform the following matching logic:
- Will check all unmatched Bank File Transactions based on Date/Amount, and see if there is the exact same number of unmatched Cashbook records with the same Date/Amount. If so, it will auto match all of these without performing Customer/Invoice match checks.
- Attempt to match all unmatched Bank File Transaction deposits to any unmatched Cashbook record. This match will be performed in the following order:
- Invoice Number and Amount match (If configured on). If the amounts match, it will search for the Invoice Number on the Cashbook record within the Bank File Transactions Details.
- Customer Number and Amount match (If there is only one Debtor for the Cashbook record, and the length of the Customer Number is greater than or equal to the configuration ‘Minimum length Customer No to match’). If the amounts match, it will search for the Customer Number on the Cashbook record within the Bank File Transactions Details.
- Bank Feed Description and Amount match (If there is only one Debtor for the Cashbook record). If the amounts match, it will see if the Bank File Transactions Details was one of the last 3 details matched to the Customer from a previous batch.
- Attempt to match all unmatched Bank File Transaction deposits to auto create a Cash Receipt if a Customer can be found. This match will be performed in the following order:
- Invoice Number and Amount match (If configured on). It will search for all numbers inside the Bank File Transaction Details, for an Invoice Number with the same Amount. If only one is found, it will use the Customer on that Invoice.
- Customer Number match. It will search for all numbers inside the Bank File Transactions Details for an exact match on Customer Number. It will only do this if the length of the number is greater than or equal to the configuration ‘Minimum length Customer No to match’
- Bank Feed Description match. It will check if the Bank File Transactions Details was previously used to match a Customer