Bank Transaction Report with Bank Balances

Barbara Allen-Guthrie
Barbara Allen-Guthrie Member Posts: 114 ✭✭

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
    Bruce Member Posts: 436 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: 3,169 Reckon Accounts Hosted 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 Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner(AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Barbara Allen-Guthrie
    Barbara Allen-Guthrie Member Posts: 114 ✭✭

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