I have a need for an ongoing Quickbooks report for a client, and I would like to automate the process. Following is what this report must show:
1 First, the report must list all the outstanding bills from the Vendor Detail Report, and the total amount of bills.
2 Secondly, The report must show the accurate balance in the checking account(s). My client uses one, two, sometimes three checking accounts to pay bills. For each checking account, I need to show its cleared balance, then a listing of each outstanding check written in that particular account, its payee, date written and amount and the total of the outstanding checks every day, followed by the true amount of cash available in that account.