browse
The description did not hold any kind of transaction number
When there isn’t any reference provided by the customer or payee then the match on document number will not be able to find any positive matches. At this point, a potential step forward could be to match on the amount. For match on the amount the ZoneReconcile SuiteApp does provide 2 options
Match open/closed on exact match of amount within date range
Match open/closed on entity name and match open/closed transactions for that entity
We recommend using the second option when possible. This option does require that the bank does provide a counterparty name, if this is not present the system can not use this matching option. The match on an entity does bring a self-learning algorithm that understands automatically that a specific name from the bank could be different inside your NetSuite account, so this means that when enabled the system will become better over time in matching.
The first option should only be used if you are certain that amounts a pretty unique otherwise this rule could lead to incorrect or unexpected matches. With this option, the system only looks at the amount and does not take the entity into consideration.
Transaction not within the date range
The ZoneReconcile SuiteApp uses a global setting for the date range in which it is allowed to search in your NetSuite system. This setting could lead potentially to no matches if not set wide enough. For example, if the transaction in NetSuite is 40 days in the past but the system is only allowed to match till 30 days in the past the transaction will not be taken into consideration. This date range can be set really wide, but this is not the recommended setting. When setting this date range too wide it could lead to slower import performance or even the situation that the import will fail due to a time-out error. We recommend setting this to a standard value that equals your most common payment term. If this would be 30 we recommend setting the threshold to 35 days in the past to allow some overhead but not too much. An unmatched transaction can still be reconciled manually.
To check or alter these settings you must be an administrator. Navigate to Setup > Company > General Preferences > subtab “CUSTOM PREFERENCES”. On this page, the following settings are responsible for the allowed date range.