Account Status Report

Michael Wacey

I would like a report that has information for all of my accounts. Each line would have columns such as: the bank name, account name, open date, close date, date of last transaction, date of last reconciled transaction, interest rate, current balance. I am mainly interested in the bank name, account name, interest rate, current balance, and date of last reconciled transaction. Having this would help me manage my accounts and make sure that I am reconciling every account. I realize that not every account has all these columns but they can be left blank.

Jim_Harman

The closest account listing that is available is at Tools > Account list. You can control which columns are displayed by clicking on Options. You can get additional details on each account by clicking on Edit next to each account name.

Michael Wacey

That is in the right direction. I did not remember that it was there. It does not have the account interest rate. Also it seems to just support printing. I would rather that it was a Report and so I cold export it to excel.

Jim_Harman

Actually if you click on the printer icon, you can select Export to: and select CSV file, which you can import to Excel.

Michael Wacey

Thanks so much. This is almost exactly what I need. I notice that if I click on the additional information when printed, the interest rate is included. I can create a macro to reformat it into columns. I really appreciate the help. Interestingly, when I went to save it in my output folder, I saw a run of this I did in 2013. So, I knew about it once but then forgot about it. I would still like to see it added as a report but I think I can work with this.