1. Home
  2. Quicken Personal Finance
  3. Quicken Reports question

Quicken Reports question

I am new to Quicken as I have just recently moved from Money. I am trying to generate a report with the balance at the end of last month. The issue I have is that many accounts (CD's primarily) have a balance of zero. I would like to generate a report of all accounts that at the end of last month had a non-zero balance. Within Money I could select all accounts and then indicate on the setup screen to not include in the report any account which had a zero balance. I can not seem to find a way to do this in Quicken. I have been generating the report, exporting to Excel and then deleting the lines with zero prior to printing.

For example when a CD Matures I have been transferring the funds to the new account assigned by the FI, closing the express web connect, and hiding the account in the account bar. I have not hid the account in Quicken (lists, menus, reports) as want to export tax information and include it in Monthly account balances over the year. I also do not check the do not include in net worth total. Is this the correct way to handle it.

Art McClinton

Reply to
Art McClinton
Loading thread data ...

"Art McClinton" wrote in news:fa7pn.75939$ snipped-for-privacy@newsfe01.iad:

One thing you can do is customize the report, uncheck the accounts (on the Accounts tab in customize) that you know to have a zero balance.

Those unchecked Accounts will not be included in the report.

Reply to
CSM1

I have actually done that for the past six months but that means that every month I need to customize for that months report. I then need to also go through and add check marks to the new accounts added within the last month.

Reply to
Art McClinton

Afraid so. It looks as though that's what you have to do. Select the new accounts and uncheck the zero balance accounts each report.

Reply to
Tim Conway

"Tim Conway" wrote in news:ho38uo$fm3$ snipped-for-privacy@news.eternal-september.org:

You can maybe use the date range of monthly, Current Month, clear your zero accounts and save the report.

That should give you a report each month, just use the saved report.

Reply to
CSM1

When you say the funds are being transferred to 'the new account...'; are you rolling over the CD into a new CD at the same FI? Is this a new CD at the same account via a rollover to a new CD, albeit perhaps with a different CD number?

If so, you MIGHT consider simply reusing the same account; disconnect it from OSU, edit the account information (like the CD number perhaps), and re-connect it to OSU, and manually deleting any transfer balances so that the balance is what it now is in the new CD. This way you keep just one account active without having a slew of accounts all over the place. Comments can be used in the register if needed to keep track of the old and new numbers and the maturity date.

The allocation of any interest can still be credited to different Quicken categories to keep that straight since you probably receive a total of CD interest based by CD number. This works for me, but as always, YMMV.

Reply to
Andrew

Thanks, you are correct that if I change the period they assign a new account number. Your suggestion appears that it will work.

Reply to
Art McClinton

Probably not the most kosher way of dealing with this from an accounting point of view, but I hate having a slew of closed, hidden, accounts floating around; the older I get, the more laddering I do of CDs, so this is my way of dealing with it. Thank goodness one can still credit the interest using different catagories within the same account, however. If that wasn't the case, the whole thing would fall flat. Good luck!

Reply to
Andrew

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.