How can i obtain an extract of the balance as of amounts within the bank reconciliation summary? I want to build a report that shows me the closing balance of an account for each day of a month.

AI generated answer (using internal Slack threads):

To obtain an extract of the balance as of amounts within the bank reconciliation summary, you can customize a Trial Balance report that uses date (instead of period) as a filter. Then just select your specific account and add the Date to that filter. This will give you the closing balance of the account for each day of the month. If you are dealing with a situation where you have migrated from another system and you want to exclude transactions made on a specific date, you could use the closing amounts from the previous day. If the previous day is not available, you could import the close of the previous system to the last day of the previous period. For performing a bank reconciliation for the bank account balance as of go-live date, you can create a one line bank statement with the balance as of the go-live date to clear out all of the journals posted for the historic balances. From this point, the bank reconciliation process should be handled normally with transactions in NetSuite to reconcile against. You can refer to SuiteAnswers ID 63909 for a step by step guide on how to reconcile open bank balance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******