Reconciliation Detail Report
The Reconciliation Detail report lists reconciled (cleared and uncleared) items for a bank account for the chosen statement period.
You can customize the report to remove columns you don’t want to see in print. Removing columns helps if your report looks crowded.
For the statement period, the report organizes and lists transactions by type, date, number, entity, memo, and balance, using data from the reconciliation page.
-
Reconciled – Lists all the cleared and reconciled transactions, grouped into subcategories (Deposits and Other Credits, Checks and Payments), along with category totals.
-
No Previous Reconciled Balance – Only appears if there is no previous reconciled balance for the selected account and statement date, instead of Last Reconciled Balance, and displays a zero balance total.
-
Last Reconciled Statement Balance - <date> – Balance of the last reconciled statement for this account. This field is only available if this is not your first reconciled statement.
-
Current Reconciled Balance – Difference between Last Reconciled Statement Balance and Total - Reconciled.
-
Reconcile Statement Balance - <date> – Closing balance for the statement.
-
Difference – Difference between Current Reconciled Balance and Reconcile Statement Balance.
-
Unreconciled – List of all transactions that are in the system but are not reconciled or reflected in your statement.
You can see this report only after you've reconciled that bank account in NetSuite with either the redesigned or original reconciliation pages. For details on using the redesigned reconciliation pages, see Reconciling Bank and Credit Card Statements. For details on using the original reconciliation pages, see Reconciling Bank Statements and Reconciling Credit Card Statements.
This report is critical for companies that need a paper trail to show data is accurate and complete.
For details on reconciling, see Reconciling Bank Statements.
Transactions cleared but not yet reconciled appear on Reconciliation Detail reports under the appropriate heading.
Print your Reconciliation report before reconciling another account because you can't recapture the same information.
To print the report, click the print icon at the bottom of the page. For details on exporting, see Exporting Reports, Searches, and Lists.
To see a Reconciliation Detail report:
-
Go to Reports > Banking/Budgeting > Reconciliation > Detail.
-
From the Account dropdown list, select the account for which you want to see a report.
-
From the Statement Date dropdown list, select the statement date for which you want to see a report.
-
Click Refresh.
NetSuite loads and displays your report.
This report does not support reporting by period even when the Report by Period preference is set to All Reports. The Report by Period preference can be configured at Home > Set Preferences, the Analytics subtab.