Unable to Reconcile more than 10,000 Transactions at a Time

NetSuite only shows a maximum of 10,000 items to be reconciled in a bank reconciliation. If users have more than 10,000 transactions in a given period, NetSuite recommends:

 

• Reconciliation in batches
• Shorten the time period and do smaller reconciliations

To verify the total number of transactions for the period of a specific account:

 

• Navigate to Lists > Accounting > Accounts
• Click on the account to display the register
• Set Date to the period of the reconciliation
• Click Refresh
• Export to excel to determine the number of transactions