...

...

Introduction

...

Before diving into using them all simultaneously, be aware the following items:

• If all matching options are enabled, the processing of the matching algorithm will be slowed downWhat is

✔️ To resolve:

Make sure there is a unique identifier on the transaction (Open or Closed) that is also available in the statement file. ZoneReconciliation can handle high volumes if there is a 1:1 match between the NetSuite transaction and the Payment listed in the statement. If this condition is met, make sure to limit the Matching preferences only to:

• MATCH OPEN ON DOCUMENT NUMBER OR PARAMETERS or

• MATCH CLOSED ON DOCUMENT NUMBER/PARAMETERS

Keeping one of these matching preferences under the Bank account configuration, will speed up the matching algorithm.

• Handling a large window of transactions to match, can result into Execution time error

✔️ To resolve:

Think about the frame in which you would like to match transactions

...

against (30

...

days prior

...

Are you handling open, or closed transactions?

...

is

...

the recommended value (or less)). Limiting the timeframe can be reached through Setup > Company > General Preferences > Custom Preferences:

...

• Define matching requirements AND number of transactions to be matched on for that particular matching preference

• Investigate current matching success by creating the SS of Bank Statement Transaction:

  • criteria: matching reason is none of None

  • results:

    • matching reason - summary type: Group

    • internal ID - summary type: Count

  • sort by: internal ID with “Descending” marked

• Can you use one of scheduled matching/single value matching?

• Bank Rec can handle high volume if there is a 1:1 match between invoice and payment based on the unique identifier mentioned above

• Disable matching on import, enable single-value matching for the high volume bank accounts

• Limit the matching to 30 days in the past, or less if there are many open transactions in the system

• Create reminders to know which statements are fully matched and which statements have a few lines left (that likely have to be handled manually)

• Describe a step-by-step bank rec process for the user to follow

...