Describe how you would reconcile the total number of imported accounts (and their opening balances) against control totals using Saved Searches or reports

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To reconcile the total number of imported accounts and their opening balances against control totals using Saved Searches or reports in NetSuite, you can follow these steps: 1. Create a Saved Search: Go to Reports > Saved Searches > All Saved Searches > New. Select the type of record you want to search for, in this case, it would be 'Accounts'. 2. Define the Criteria: In the criteria section, you can specify the conditions that the records must meet to be included in the search results. For example, you can add 'Posting' = True to only include posting transactions. 3. Define the Results: In the results section, you can specify the fields that you want to display in the search results. You can add 'Account' (Group) and 'Opening Balance' (Sum) to get the total opening balance for each account. 4. Compare the Results with Control Totals: Once you have the search results, you can compare the total opening balance for each account with the control totals. If there are any discrepancies, you can drill down into the details of the transactions to identify the cause of the discrepancy. 5. Create a Running Balance: If you want to track the running balance of the accounts, you can create a formula field in the results section. The formula would be something like:

case when {account.number} = '(insert your account number)' then {openingbalance} else 0 end

. This will give you a running total of the opening balance for the specified account. Remember, the reconciliation process involves comparing the balances in your NetSuite accounts with the balances in your control totals. Any discrepancies need to be investigated and resolved to ensure the accuracy of your financial data.