This report is for all companies. All companies have bank accounts, therefore, all companies need to know how much money is in the bank.

Every manager and business owner needs to see how much cash is in the bank. Usually, this person is not the one who is responsible for reconciling the bank accounts to the bank, so I would like to add the last reconciliation date (not the date it was actually reconciled, but the date it was reconciled through).

We realize there is a very nice Business Analyzer report that shows the cash position compared to previous periods. We really like this report, but it does not show us when the bank account was last reconciled, nor does it give us a breakdown of how much cash is in each bank account.

For this report, we choose to use SQL Report Builder 3.0, so we will...