ZoneReconcile FAQ — Frequently Asked Questions

This article answers the most frequently asked questions about ZoneReconcile, covering matching, configuration, reconciliation workflows, file imports, and troubleshooting. Use it as a first stop before raising a support case.

Matching and auto-matching

Why is a transaction not automatically matched?

There are several reasons a transaction may not be automatically matched:

1. The matching string contains only alphabetic characters — the system requires at least 1 number in the matching string.
2. The matching string is fewer than 4 characters long.
3. The matching string contains only a year, for example 2025 (4 characters) or 12342025 (8 characters).
4. The transaction is already paid in full or already reconciled with another bank statement.
5. The matching preference is not enabled in the related Bank Account Configuration record.
6. Matching parameters are missing — refer to the Setup Bank Statement Matching Parameter article.
7. There are typos or partial references in the payment description. The payment reference must exactly match the matching string in the NetSuite transaction. Contains logic is not supported.
8. Additional Delimiters are incorrectly set in the related Bank Account Configuration record (most common). The full Description field is split into matching strings using the characters defined in this field.

Why is the system picking the wrong matching rule?

Check the incorrectly selected matching rule and confirm that If Description / If Counterparty is empty when Value (Description) / Value (Counterparty) is also empty. Another common cause is that the matching values are too generic or too short.

Why are transactions matched instead of custom matching rules being applied?

By default, matching of open and closed transactions based on parameters or amount takes precedence over custom matching rules. To change this:

1. Navigate to Setup > Company > General Preferences > Custom Preferences subtab.
2. Enable Show Customize Order Matching Fields.
3. In the related Bank Account Configuration record, select the Change Matching Order Algorithm (or Customize Order) checkbox.
4. Drag custom matching rules above the matching preference you want them to take priority over.
5. Select Apply Order, then save the Bank Account Configuration record.

Important: To remove a custom matching order, select the checkbox again, select Cancel Custom Order, and save the Bank Account Configuration record.

Is it possible to prioritise matching rules over other matching preferences?

Yes. Enable Show Customize Order Matching Fields in Setup > Company > General Preferences > Custom Preferences subtab. A Change Matching Order Algorithm (or Customize Order) checkbox will appear in the related Bank Account Configuration record. Select it, drag matching rules to the desired position, select Apply Order, and save the record.

Why did matching suggest an incorrect entity?

If the Matching Reason column shows Counterparty Matched, check the related entity record and review the Name as on Bank Statement field — it will most likely match the value in the Counterparty column of the bank statement. When counterparty matching is enabled, the system compares this field to the counterparty value and updates it when an entity is selected. If many statement lines share the same counterparty (for example, your company name) but relate to different vendors or customers, this can result in incorrect matches on future statements.

Why are additionally populated fields (CAMT, CSV) not taken into consideration in matching rules?

In version 5.10.x and below, only values stored in the standard Description field are considered in matching rules. From version 5.11.0 onwards, additional field values are also considered in matching.

Why is a matching rule not working for Description?

In version 5.10.x and below, additionally populated fields are not considered in matching rules. It is therefore possible that the value in Description is sourced from additional fields. From version 5.11.0 onwards, additional fields are considered in matching as well.

What is the Run Match button used for?

Because matching occurs on import, Run Match is only useful when a large number of statement lines can be matched against a custom matching rule or transactions that did not exist at the time of import. Otherwise, triggering Run Match will not improve the matching ratio, as all matching already occurred on import.

Important: Additional controls applied during import prevent matching against short descriptions. For example, a vendor bill with document number 2 will not be matched on import when the description contains 2, but triggering Run Match will match it. Use this button with this behaviour in mind.

Why were direct debit reversals not matched?

When the related customer payment is not yet reconciled:

• Enable Match Closed on Document Numbers/Parameters AND Create Direct Debit Reversal When Auto-Matching on Customer Payment in the related Bank Account Configuration record.
• Confirm that the saved search BS TR C AC (or its customisation set in General Preferences) returns the related customer payment — additional criteria such as record type and date may exclude it.

When the related customer payment is already reconciled:

• Enable Match Closed on Document Numbers/Parameters AND Match Direct Debit Reversals on Document Number in the related Bank Account Configuration record.
• Confirm that the customer payment's date falls within the range defined by Auto-match closed: days offset prior and Auto-match closed: days offset after in Setup > Company > General Preferences.

Other causes include missing matching parameters, missing payment references in Description, or incorrectly set Additional Delimiters in the related Bank Account Configuration record.

Why can I not see a customer payment in the popup for Direct Debit Reversals?

By default, results are limited by the Direct Debit Reversal: Days Prior Today setting in Setup > Company > General Preferences > Custom Preferences subtab. This value filters transactions by date. When in the popup, enter a payment reference or customer name and select Filter to search beyond the default range.

Why is the exchange rate not recalculated in the popup after selecting a transaction?

Whether the exchange rate is recalculated in the popup is controlled by the Foreign Currency Tolerance % preference in the related Bank Account Configuration record. If the difference exceeds this threshold, change the value in this preference or recalculate the exchange rate manually. If this preference is not present in your account, the default threshold is 5%.

Why is there a small variance after selecting multiple transactions in foreign currency?

When selecting multiple transactions in foreign currency in the popup, the system calculates the exchange rate as closely as possible. A small variance of 0.01 or more may remain. If adjusting the last decimals in the calculated exchange rate does not resolve it, there are 2 options:

1. Split the line into 2 — one for the payment and one for the small difference.
2. Create a payment outside of ZoneReconcile and reconcile it as a closed transaction in the popup.

Important: Selecting a payment difference reason for foreign currency transactions is not currently supported.

My customers pay using a quote number referenced on the bank statement. Can I use an additional matching parameter for this?

Yes. ZoneReconcile supports matching transactions based on additional fields. Refer to the Adding a Custom Matching Parameter article for instructions.

Can ZoneReconcile create a deposit to a sales order if the sales order is in unapproved status?

Yes. ZoneReconcile can match sales orders with a status of Pending Approval or Pending Fulfilment. When the statement is saved, a deposit will be generated.

Can we match existing journal entries that have a reference number?

Yes. Matching journal entries is a supported scenario. However, ZoneReconcile can only match journal entries based on document numbers — matching by amount or counterparty is not supported.

Will ZoneReconcile include an option to automatically apply payments from oldest to newest?

When auto-matching open transactions, a saved search is used to load the transactions. This saved search can be customised to prioritise matching by internal ID or date — oldest to newest, or vice versa — depending on your preference.

Auto-match preferences

What are the Auto-match closed: days offset prior and Auto-match closed: days offset after preferences used for?

These preferences control how many transactions are considered in the following matching scenarios:

• Match open on exact match of amount within date range
• Match closed on exact match of amount within date range
• Match direct debit reversals on document number

They are also applied in the popup when it is opened without an entity selected.

What is the Auto-match closed: Saved Search Id preference used for?

By customising the saved search BS TR C AC (used for matching closed transactions based on parameters and amount) and entering its internal ID in this field, you can limit the results considered in matching. This can improve overall matching speed and prevent timeouts.

Custom fields and additional fields

Can I populate a custom field on a bank reconciliation or credit card import record based on custom matching rules?

Yes, this scenario is supported. Follow the instructions in the Create Custom Matching Rules article, specifically the Extending Fields section.

Can I populate a custom field on a journal entry using both a custom matching rule and manually?

Yes. Create 2 additional fields and mappings as follows:

• First additional field (where Store Value = True): used for manual selection.
• Second additional field (where Store Value = False): used for the custom matching rule.

Mappings for both can be set to target the same field on the journal entry.

Why can I not see additional columns that were created for bank statements?

There are 2 possible reasons:

1. Store Value is set to False in the additional field settings. This field will only be visible in View mode of the bank statement (standard NetSuite behaviour). This setting is required when copying values dynamically from custom matching rules, bank account configurations, or formula-based columns.
2. Show in List is set to False in the additional field settings.

How can I achieve that all journal lines have Name populated?

Create an additional field following the instructions in the Additional Field to Populate Custom Field to the Transaction article (section 3), using the following values:

• Bank Statement Transaction Field: Name
• Bank Statement Transaction Field ID: CUSTRECORD_BST_CUSTOMER_VENDOR
• NetSuite Field: Name
• NetSuite Field ID: NAME

Can I populate custom categories configured on journal entries based on ZoneReconcile custom matching rules?

Yes, this scenario is supported. Follow the instructions in the Create Custom Matching Rules article.

Can I customise the popup to add custom fields sourced from the customer invoice?

Yes. Follow the instructions in the Extend the Popup with Additional Columns article.

Can I add custom fields to the Bank Account Configuration record and have them copied to the bank statement?

Yes. Follow these steps:

1. Navigate to Customisation > Lists, Records & Fields > Record Types.
2. Open the Bank Account Configuration record type and select New Field.
3. Populate Label and Type as required, and set Store Value = True. Save.
4. Return to Record Types and open the Bank Statement Transaction record type.
5. Select New Field, populate Label and Type (must match step 3), and set Store Value = False and Show in List = True.
6. Navigate to the Sourcing & Filtering subtab, set Source List to F-M, and set Source From to the field created in step 3. Save.
7. To copy the value from the bank statement to created transactions, create a mapping in the related Bank Account Configuration record following the Additional Field to Populate Custom Field to the Transaction article (section 3).

Bank statement processing and timeouts

Why is there a timeout when importing a bank statement?

Timeouts can be caused by 1 or more of the following:

• The statement contains a large number of lines — a maximum of 300 lines per statement is recommended.
• Too many matching preferences are enabled. Review matching rates and matching reasons to identify preferences that are not contributing, and disable them. Counterparty-based matching is particularly slow, as it uses 2 saved searches in the background.
• Too many custom matching parameters are configured in the Bank Account Configuration record.
• A large volume of open invoices, vendor bills, or unreconciled payments is being considered in matching. If closed transaction matching is enabled, customise saved search BS TR C AC (for example, add a date filter or exclude certain record types) and enter its internal ID in Setup > Company > General Preferences > Custom Preferences > Auto-match closed: Saved Search Id.

What is the recommended number of lines per bank statement?

A maximum of 300 lines per statement is recommended. However, depending on the combination of enabled matching preferences, data volume, and description complexity, larger statements can also be processed successfully.

Why is a statement stuck in processing?

Larger statements may take longer to process, and if the queue for scheduled or map/reduce scripts is busy, the script may be delayed. If a statement has been stuck in processing for more than an hour, unlock it manually via Transactions > ZoneReconcile > Unlock Statement.

After unlocking, edit and save the statement. If an error appears immediately, there may be a mismatch between the bank account in the statement and the bank account in the related Bank Account Configuration record. To investigate, switch to View mode of the bank statement, scroll right within the lines, and locate the F-M (File Mapping) column to retrieve the internal ID of the configuration used. If the accounts differ, temporarily change the account in the configuration back to the original, then reprocess.

How can I unlock a statement that is stuck in processing?

By default, this is only available to Administrators via Transactions > ZoneReconcile > Unlock Statement. To allow custom roles to unlock statements as well, refer to the Roles and Permissions article, specifically the Unlock Statements Permission section.

When triggering Run Match, why is the statement stuck in matching?

Matching should typically take no longer than 1–2 minutes. If it is stuck, there is an error visible in the browser console. Open the console, refresh the statement, and trigger Run Match again. If an error appears, take a screenshot and submit a support case.

Why is my statement locked for a few minutes?

Larger statements may be processed by a scheduled script that enters the queue for scheduled and map/reduce scripts. If the queue is busy, processing can be delayed by minutes or, occasionally, hours. Additionally, when a statement contains a line reconciled against an EFT batch, it is automatically locked until the BS MR Processing EFT script runs. By default, this script is scheduled to run every 15 minutes.

Why do multiple bank statements have the same Bank Start Balance?

This can happen when multiple Bank Statements to Process records for the same account are opened simultaneously. All loaded statements will carry the same Bank Start Balance, sourced from the Bank End Balance of the most recently saved statement. Always open and save bank statements sequentially, one at a time.

Why are there duplicated statements?

There are several possible causes:

1. A user submits the same statement twice by double-selecting Save and ignoring the warning that the form has already been submitted.
2. 2 users work on the same Bank Statement to Process record simultaneously. The record only disappears from the list once the statement is created, leaving a window for duplication.
3. When auto-processing is in place, the script may also pick up manually imported Bank Statements to Process records that should not be auto-processed. Enable the relevant preference in BS SC Import / ZR File Processing to instruct the script to ignore manually imported statements.
4. If statements are brought into NetSuite automatically via SFTP Connector or another integration, the bank may have provided the same file twice, with an identical or slightly different filename.

Why is there a difference in a bank statement?

The most common reasons are described in the Top 7 Causes for Incorrect Bank Balance article. Additionally, a non-zero value in the Difference field that appears suddenly can indicate:

1. Statements are no longer imported in sequence — for example, a statement for 15 May was imported after one for 20 May.
2. A statement is missing for a specific date, causing the calculated Bank End Balance to no longer match the Enter Statement Balance field.
3. Duplicate statements exist for the same date.

Why are custom scripts and workflows not triggered on created transactions?

Custom scripts and workflows are only triggered when the bank statement is processed in scheduled context. To enforce this, enable Process Bank Statement Scheduled in the related Bank Account Configuration record. After enabling, smaller statements (ordinarily processed with Suitelet) will also be processed using the scheduled script.

Why is there no Payment Number populated even though a transaction was created?

This can be caused by:

1. A user action — for example, prematurely unlocking a statement that is being processed and reprocessing it — that results in a UI change to the Payment Number field, visible in System Information.
2. When the statement is processed in scheduled context, other custom scripts and workflows also run on transactions. If one returns an error in the after-submit phase, the ZoneReconcile script may not complete the final step of linking the transaction to the Bank Statement Transaction record.

In both cases, payments will need to be linked via the browser console using nlapiSetFieldValue or nlapiSubmitField commands. Contact support if you need assistance.

Why is there no journal created even though a custom matching rule was applied correctly?

Review the related Custom Matching Rule and confirm that Set Select is checked. If a line is selected for processing (Select = Yes) but no journal is created, check for errors on the bank statement line itself or in the script execution logs for BS UE Transaction or BS SC Controller (if processed in scheduled context).

Why is there no transaction created when the Select column shows Yes?

There are several possible causes:

1. A payment difference reason is being used for a transaction in foreign currency — this scenario is not currently supported. Separate the line into 2: one for the payment, and one for the difference booked against a GL account.
2. Mandatory segmentation is missing (Class, Location, or Department).
3. The same invoice or vendor bill was selected multiple times within one statement. The system creates a payment for the first line; when processing the second line, no open AP/AR balance remains. Select a different transaction for the second line, or process it as a Deposit, Journal Entry, or Customer Deposit.
4. If the statement is processed in scheduled context, another custom script or workflow may be returning an error that prevents the ZoneReconcile processing script from creating a transaction.

Why were the statements created and processed later than usual?

If files were provided later than usual, check with your bank whether there was a temporary issue. Statements may also be created and processed later if the queue for scheduled and map/reduce scripts is busy. If this occurs regularly, consider raising the priority of ZoneReconcile auto-processing scripts.

Importing bank statements

What is the difference between the old and new import screens?

The new import screen, Instant Upload, provides a more modern look with the ability to drag and drop multiple files at once. It uses updated parsing libraries written in SuiteScript 2.1. The outcome is the same as the old import screen.

Why are the statements no longer automatically imported?

There are several possible causes:

1. Files are no longer arriving in the Unprocessed folder: Check with your provider whether there is an issue on their side. If you use the ZoneReconcile SFTP Connector, confirm that the connection and download configuration are still active. If the connection stopped working suddenly, check whether the NetSuite IP address has changed — NetSuite does not provide a static IP address, and a new IP may need to be whitelisted by your bank.
2. Files are stuck in the Unprocessed folder: Check whether there are matching rules in the Bank Statement File Processing Rule record (Setup > ZoneReconcile Setup > Bank Statement File Processing Rule). If the naming convention of provided files has changed, they may no longer match those rules.
3. Files were moved to the Processed folder but statements were not created: Navigate to the list of Bank Auto Import records and confirm whether Processed is set to Yes. If it is No, possible causes include: more than 1,000 unprocessed records in the queue (the script processes only the oldest 1,000 — inactivate old records to free the queue), or an incorrect file format or mismatch between the selected Multiple Statement Import Config and the file format.
4. The Bank Auto Import record is processed but the statement is failing on import: Open the related Bank Statement to Process record manually to check for a timeout or error. Timeouts can be caused by a large number of lines combined with many matching preferences being enabled. Try importing in smaller parts or temporarily disabling certain matching preferences such as counterparty matching.

Why are there no lines when importing a CAMT053 file?

You may be importing the CAMT053 file as a single import (selecting a specific Bank Account Configuration record directly). If so, amend the related Bank Account Configuration record, set the Multiple Statement Record field to CAMT053, populate Multiple Statement - Identifier (IBAN, BBAN), and reimport using the Multiple Statement configuration.

Why are there no lines when importing a CSV file?

There may be a mismatch between the CSV delimiter set in the related Bank Account Configuration record and the delimiter used in the CSV file itself. Confirm both match.

Why are there missing lines when importing a CSV file?

In the related Bank Account Configuration record, review the Number of Header Rows and Number of Trailing Rows settings. These control how many lines at the beginning and end of the file are ignored during import.

Why are there missing lines when importing an MT940 file?

Missing lines may be related to the Counterparty Mandatory (MT940) preference in the related Bank Account Configuration record. When this is enabled, the system ignores all transaction lines :61: that do not contain a related :86: line.

Why is there a getDate error when importing a CSV file?

There are several possible causes:

1. Date Column is incorrectly set in the related Bank Account Configuration record. 0 represents the 1st column, 1 represents the 2nd column, and so on.
2. Date Format is incorrectly set in the configuration.
3. The CSV file contains empty lines at the end. Open the file in Notepad or TextEdit to check, and remove any trailing empty lines by pressing Backspace.

Why do lines have incorrect dates when importing a CAMT053 file?

CAMT files typically contain 2 dates: Value Date and Booking Date. To import booking dates instead, enable Use Booking/Entry Date Instead of Value Date (CAMT/CODA/PAIN files) in the related Bank Account Configuration record.

Why do I get undefined Bank Statements to Process when importing a multiple statement file?

This means the system identified a bank statement to process for which there is no matching Bank Account Configuration record based on the Multiple Statement Identifier. Select the undefined hyperlink — the identifier is shown at the beginning of the Name field, ending with an underscore. Create a new configuration or amend an existing one to include this identifier.

How can I split larger statements into smaller ones?

This is possible when importing a statement as a Multiple Statement record. In the related Multiple Statement Config record, set the Transactions Per Statement parameter to split the original statement by the defined number of lines. This functionality is available for CSV, CAMT053, CAMT053 Extended, and CAMT054.

Which format of bank statement should I choose?

If your bank provides one of the CAMT formats (053, 053E, 054), this is recommended as it allows you to extract more data by creating additional fields and mappings. This is also possible for CSV. Otherwise, select one of the supported formats listed in the Supported File Formats article.

What does Multiple Statement Identifier — Currency field mean?

This field is used for CAMT053 configurations where multiple Bank Account Configuration records share the same Multiple Statement Identifier (IBAN or BBAN) and a further split by currency is required.

What is the difference between BS SC Import and ZR AutoImport scripts?

ZR AutoImport is part of the newer auto-processing functionality written in SuiteScript 2.1 and runs in a single flow. It does not consider unprocessed Bank Statements to Process records that were imported before the script started. BS SC Import goes over all Bank Statements to Process records every time it is triggered. Additionally, ZR AutoImport is a map/reduce script, which can result in faster creation and processing of bank statements when more processors are available in the account.

Does ZoneReconcile support intraday reporting?

Yes, ZoneReconcile supports intraday reporting and can reconcile intraday bank statements. However, it is your responsibility to identify and manage duplicate statement files, as ZoneReconcile does not automatically distinguish between them.

Can ZoneReconcile work with the NetSuite native bank feed solution?

No, ZoneReconcile is not compatible with the NetSuite native bank feed solution.

When creating a bank account configuration for CSV, how do I map columns?

Enter numerical values in the column mapping fields based on which column of the CSV file should be imported. 0 represents the 1st column, 1 represents the 2nd column, and so on. Refer to the Setup a Bank Statement Configuration Record article for full instructions.

Transactions and reconciliation workflows

Can I load a remittance advice from a customer and reconcile payments that way?

Bulk remittance handling is not natively supported, but a practical workaround is available:

1. Set up a virtual bank account: Create a new Bank Account Configuration record in ZoneReconcile using a virtual bank account. Also create the corresponding virtual bank GL account under your Chart of Accounts.
2. Upload and match invoices: Upload a CSV file containing the remittance detail (this can also be exported from NetSuite). The file should include unique identifiers that can be matched to invoice document numbers in NetSuite. ZoneReconcile will use this data to match payments to the correct invoices.
3. Create customer payments: Once invoices are matched and the bank statement is saved, customer payments will be created against the virtual bank account.
4. Offset the virtual account: Include the virtual bank account on the summary line of the actual operating bank account to offset the virtual account's balance and reflect it correctly in financial reports.

What is the best practice when a payment on the bank statement does not have a matching vendor bill or customer invoice in NetSuite yet?

The recommended approach depends on the transaction type:

• Customer-related transactions: ZoneReconcile can create a Deposit, a standalone Customer Payment, or a Journal Entry to reflect the incoming funds.
• Vendor-related transactions: Create a standalone Journal Entry to represent the outgoing payment.

Important: Vendor prepayments are not currently supported.

How can I handle customer refunds with ZoneReconcile?

There are 2 ways to handle customer refunds:

• When a credit memo exists: ZoneReconcile can match the bank statement line to the credit memo and generate a Customer Refund transaction against it.
• When there is no related transaction: ZoneReconcile can create a Journal Entry using the customer's name to indicate who the refund was issued to.

Can ZoneReconcile support reconciliation of vendor account statements?

No. ZoneReconcile is specifically designed for bank account reconciliation and does not support reconciliation of vendor or customer account statements. If a vendor sends a monthly statement listing issued invoices, ZoneReconcile cannot be used directly to reconcile that data.

Why is there no transaction created when reconciling a bill credit for an intercompany entity?

In this case, the system creates a journal entry (as there is no specific refund transaction for vendors) that impacts an intercompany AP. Because elimination is not currently supported, create this journal manually (Debit: Bank Account, Credit: IC/AP) outside of ZoneReconcile, then reconcile it as a closed transaction in the bank statement popup.

Why is there no transaction created when reconciling a bill credit and a vendor bill?

This can occur in 2 scenarios:

• Credit line (refund from vendor): Apply the vendor bill against the bill credit outside of ZoneReconcile first, then reconcile only the remaining open amount of the bill credit.
• Debit line (refund to customer): Apply the customer invoice against the credit memo outside of ZoneReconcile first, then reconcile only the remaining open amount of the credit memo.

Can I reconcile a journal entry across multiple statements?

Only if the journal was created outside of ZoneReconcile, impacts AP/AR (to be reconciled as an open transaction), and is not yet linked to any bank statement. Once a journal is linked to a bank statement, it will no longer be available for reconciliation in other statements.

Why is a journal not visible in the popup?

The journal is most likely already reconciled with another bank statement. Journals created from a bank statement hold values in the Bank Statement and Bank Statement Transaction fields, which are used as filters in the popup. If a journal was created manually outside of ZoneReconcile and is still not visible, check whether it was created as a copy of an already-reconciled journal — copying carries over all custom field values, including those fields. Consider creating a simple workflow that clears these values when a journal is copied.

Can I select multiple entities on one bank statement line?

No. Only 1 entity can be selected per bank statement line. Reconciliation of multiple entities on a single line is not supported.

Can Salt Edge or NetSuite native bank feeds be used alongside ZoneReconcile?

You can use other providers for certain accounts and ZoneReconcile for others, as long as there is no overlap in the bank statement data being imported or reconciled. However, ZoneReconcile is not compatible with the NetSuite native bank feed solution.

Why can I not select a bank account in a bank statement line?

To select a bank account in the Select Account column, enable Allow Posting to Other Bank Account in Setup > Company > General Preferences > Custom Preferences subtab.

Bank statement configuration

How is the licence calculated?

Licences are calculated based on the number of active Bank Account Configuration records. To add configurations without purchasing an additional licence, inactivate configurations that are no longer in use.

Can I create multiple configurations for one bank account?

Yes. If you need multiple configurations for the same bank account — for example, to import statements in different formats — this is supported. Statements will be linked to different Bank Account Configuration records, but the sourcing of Bank Start Balance and the calculation of Bank NetSuite Balance will behave as usual.

Can I create manual bank statements for an account not normally reconciled in ZoneReconcile?

This is not recommended. Processing logic relies on accurate input data, and a Bank Account Configuration record must exist for processing to succeed. If statements are very small and infrequent, manual creation is possible, but the related Bank Account Configuration record must still be created first.

Can I update the bundle from my end?

As ZoneReconcile is a managed bundle, Zone & Co performs updates in Production. In Sandbox, you can update the bundle yourself.

Why can I not see standard segmentation (Class, Location, Department) in a bank statement?

Check the related Bank Account Configuration record and confirm that Show Class, Show Location, and Show Department are all enabled. If you have multiple configurations for the same bank account, enable these preferences in each one.

Why are Locations no longer available in the list after an upgrade?

By default, Locations are filtered by subsidiary — only Locations for the bank account's subsidiary are shown. When the Multi-Location feature is not enabled, Locations can be used across multiple subsidiaries, which causes this filtering to break (standard NetSuite behaviour). To restore Location availability:

1. Navigate to Customisation > Lists, Records & Fields > Record Types.
2. Open the Bank Statement Transaction record type.
3. Open the Location field.
4. Navigate to the Sourcing & Filtering subtab.
5. Remove the filter related to Subsidiary.
6. Save.

Important: This filter is reinstated after each upgrade and will need to be removed again each time.

Why can a user with a restricted subsidiary role view all bank statements to process?

The Bank Statement to Process record does not have a field with Apply Role Restrictions enabled by default. To apply subsidiary-based filtering:

1. Navigate to Customisation > Lists, Records & Fields > Record Types and open the Bank Account Configuration record type.
2. Select New Field. Label it Bank Subsidiary, set Type = List/Record, List/Record = Subsidiary, Store Value = True, Show in List = True, and Apply Role Restrictions = True. Save.
3. Edit all Bank Account Configuration records and populate the Bank Subsidiary field with the subsidiary to which each bank account belongs.
4. Return to Record Types and open the Bank Statement to Process record type.
5. Select New Field using the same parameters as step 2.
6. In the Sourcing & Filtering subtab, set Source List to Config Record and Source From to the field created in step 2. Save.

Once a statement is imported with restricted subsidiary access, the Bank Statement to Process record will carry the subsidiary value from the related Bank Account Configuration record.

Why are created transactions locked from editing?

By default, the workflow Lock Transactions Bank Statement is deployed on all transactions created from ZoneReconcile. This workflow does not run for Administrators. To allow custom roles to edit these records, refer to the Locked Transactions Created from the Bank Statement article.

Errors and error messages

I get the error "An nlobjSearchFilter contains invalid search criteria: custrecord_bs_ep_bankstatement" when uploading a bank statement. What does this mean?

This error typically occurs in accounts where the ZoneReconcile SuiteApp has been recently installed. Add a field as described in the NetSuite Electronic Payment Batch (Additional Field) article.

What does the error "Script Error: TypeError: Cannot read property 'shouldProcessScheduled' from null" mean?

This error is typically caused by a mismatch between the bank account in the statement header and the bank account linked to the related Bank Account Configuration record. To investigate, switch to View mode of the bank statement, scroll right within the lines, and locate the F-M column to retrieve the configuration's internal ID. If the accounts differ, temporarily change the account in the configuration back to the original, then reprocess. You can also unlock the statement via Transactions > ZoneReconcile > Unlock Statement.

Deleting records

Is it possible to delete multiple statements at once from the Statement List?

No. Mass deletion of bank statements is not supported. Contact the support team for more information.

Why can I not delete a Bank Statement to Process record?

This is most likely due to dependent records linked to the record you want to delete — usually an existing bank statement linked via the To Process Record field. This can happen when 2 statements were created from the same Bank Statement to Process record (by double-saving and ignoring the duplicate submission warning). Once the duplicated statement is deleted, the Processed With field may become empty, making the record available for processing again. Instead of deleting, link the record to the existing bank statement by populating its internal ID in the Processed With field via the browser console using nlapiSetFieldValue or nlapiSubmitField. Contact support if you need assistance.

When selecting Delete Payment Transactions, why is the transaction not deleted?

The transaction may have dependent records (for example, it is linked to another transaction) that prevent deletion. Another cause is insufficient permissions — to delete a transaction, the custom role requires Full level of delete permission for that record type.

When selecting Delete Payment Transactions, why does nothing happen?

There is most likely a background error preventing deletion. Open the browser console before selecting the button to capture the error, then submit a support case with the details.