Jira code: BLL-146
Issue: We have a problem with the Reconcile bank Statement in Netsuite. Is there a way of creating a report to show every transaction and whether it has yet been reconciled or not?
Solution:
For transactions that are reconciled.
Standard Reconciliation Detail Report
There are standard reconciliation reports in the navigation
Reports > Banking/Budgeting > Reconciliation > Detail.
In this report, you can see the detailed list of the transaction which have been reconciled
The Reconciliation Detail report displays a list of the reconciled, both cleared and uncleared items for a
bank account for the statement period designated by the statement date.
Users can view this report only after you have reconciled the bank account in NetSuite. Transactions cleared on a register, but not reconciled, appear on Reconciliation Summary
reports under the appropriate heading. Netsuite recommends that you print your Reconciliation report before you reconcile another account because you cannot recapture the same information.
Standard Reconciliation History Report
The Reconciliation History report lists the completed reconciliations for a bank account in the date range
specified. Use this report to view statement balances, link to the detailed report for each reconciliation.
Go to Transactions > Bank > Reconcile Bank Statement.
2. On the Reconcile Bank Statement page, click History.
We have also created another report in the Production account called JJ Reconciliation Detail Report by customizing the transaction detail report which shows all the transactions that are reconciled along with its reconciled date and also there is a Date filter to filter the date of transaction.
For the unreconciled transactions list.
The user wants to export the Unreconciled bank transactions in NetSuite to Excel to compare with the list of transactions from the bank. This feature is not yet available in NetSuite. It is logged as an Enhancement 263845: Transactions > Bank > Reconcile Bank Statement > Ability to Export Unreconciled Bank transactions to Excel. Also, there is no field for the Reconciliation Date in the transaction record, we cannot add a column for this in saved search. In the saved search or in the report the option is to add the cleared field as the system usually considers Uncleared transactions are usually Unreconciled. But in case of some transactions such as journals or bank transfers, these transactions will be shown as multiple lines so the search or report created in this manner may result in duplication.
So as an alternate method, navigate to the ‘Chart of an account’ in Netsuite (Setup>Accounting> Chart of accounting, Then click on the bank account), which you want to know the pending transaction to be reconciled. In Netsuite, the reconciliation process is also done bank account wise. In the chart of account- (The account register of that account) we can see the transaction that are yet to be reconciled for that account. Use the filter uncleared as true to get the list of transactions that are yet to be cleared. The user can also download the result list in Excel.