Bank Transaction Report with Bank Balances

Barbara Allen-Guthrie
Barbara Allen-Guthrie Member Posts: 268 Reckon Star Reckon Star
in Accounts Hosted

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.

Answers

  • Bruce
    Bruce Member Posts: 447 Professional Partner Professional Partner
    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
    Acctd4 Accredited Partner Posts: 4,216 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    @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 😊

    Shaz Hughes.png

    Email | Website | Google Reviews | Facebook Reviews

  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 268 Reckon Star Reckon Star

    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

Categories