is there a way to pull a list of outstanding checks OR bill payments against a bank account as of a specific date in the past?

AI generated answer (using internal Slack threads):

Yes, there is a way to pull a list of outstanding checks or bill payments against a bank account as of a specific date in the past in NetSuite. You can do this by customizing 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. For seeing when a bill payment actually cleared the bank, you can do a bank reconciliation or can have a positive pay if you have electronic bank payment module(free) installed. For forecasting Bank Balance based on due dates for Accounts Pay and Rec., you can summarize the due payments and the receivables for the dates and see the net cash flow. However, it might not be straightforward to take the current bank balance and see how it will change with future net cash flows using a saved search as you need to add sums from one row to the other and carry it over the future dates. But there is a way to do running totals. Please refer to this link for more details: https://blog.prolecto.com/2015/05/26/solving-the-netsuite-cumulative-saved-search-tally-challenge/ ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******