On this page, we explain how to use and configure the scheduled matching for bank statements

Setup schedule matching

When using scheduled matching, existing bank statements are re-matched using the settings on the Bank Account Configuration (Setup>Bank Reconciliation Setup> Bank Account Configuration) record.

The result is the same as matching on import, but it can handle more data.

Steps to setup:

1. On the configuration record, check “Disable Automatic Matching on Import”

2. On the configuration record, check “Enable re-matching of existing statements”

3. Go to the scheduled script ‘BS Scheduled Matching’. On the deployment record, set the status to “Scheduled”, set an appropriate schedule (f.i. every hour) and mark the check “No end date”

Now all statements, that are not fully matched or reconciled, will be automatically evaluated for re-matching by the scheduled script. Also on the statement record a button appears to run the matching in the background.

Customise the scheduled matching

Fast Four Bank Reconciliation tool allows to customise the scheduled matching setup to run it for only selected records. This can be done by customising the default saved search named “Not Matched Bank Statement Transactions for Scheduled Matching“. This saved search is included by default in the bundle.

By default, the Bank Reconciliation SuiteApp will try to load all unmatched bank statement transaction lines. A custom search can be set in this field to limit the number of results to a specific bank account configuration or to a specific date range. It is recommended to use this if scheduled matching is only needed for a specific bank account configuration or when time-outs occur.

Under the Parameters subtab of the deployment record, enter the internal ID of a search of bank statement transactions that should be matched by this script.