Bank Transaction Report with Bank Balances

Barbara Allen-Guthrie

How do I create a report showing the daily transactions and the bank balance at the end, one that looks exactly like a Bank statement but I can run it for the whole year and export into Excel, as the accountant has requested?

I can run the report but when I select balance, it is only starting at the 1.7.2022 report and not the actual bank balance.

Hope this makes sense.

Bruce

1. create a balance sheet for the period being reviewed
2. click on the $value shown for the bank account being reviewed
3. remove any columns that are not required
4. export/email to recipients as required

Acctd4

@Barbara Allen-Guthrie You can also just generate a FastReport directly from the relevant bank account (right-click on it in your Chart of Accounts) & Modify ... that report accordingly 😊

Barbara Allen-Guthrie

Thank you so much Bruce and Acctd4, they are both exactly what I was searching for and work beautifully, appreciate your help so much😍

Barb