Report problem 2006p

For a number of years I have had a report that I run on an annual basis to obtain cash value of 3 insurance policies. This has been accomplished with an asset acc't & income/expense categorized to non-cash categories & subtotalled by payee. When the annual report from the insurance co. arrives it show total cash value so I only have to subtract prior balance from new balance.

Now the subtotals all show the total. For example if each policy has a cash value of $20,000, instead of the subtotal equalling $20,000 with a total of $60,000, all subtotals are $60,000. The total is still $60,000, not $180,000. I'm willing to take the time to make this work if it will save time in the future so am open to ideas. BTW the only problem I have had w/06p is in the report area & these have been a royal pain.

Reply to
PSJ
Loading thread data ...

What happens if you create a totally new report intended to produce the correct results?

Reply to
John Pollard

The same thing -- the register report can be subtotalled by payee & gives the same result. Tried this with checking acc't & get correct result. Don't know why 1 doesn't work & the other does.

Reply to
PSJ

Are all of your transactions totally contained within the Asset account? Could any of the transactions in your report come from investment account transactions with split categories?

Reply to
John Pollard

All transactions are in asset acc't, none from investment. I had initially had 3 opening balances, 1 for each payee -- insurance co. (this worked from

1995 v5 thru version 2006) so changed that to income from the non cash acc't to see if that mattered -- still get same bad results.
Reply to
PSJ

Finally found a solution to this bizarre report problem; I went to accounts/manage/change group & changed this asset acc't to the savings area. It is still characterized by q p 06 as an asset but is now in the cash flow center. The report now subtotals the payee. There are major problems in the reports of 06, this is 1 & the IRA distribution/transfer is another. I depend on accurate info from quicken & I am not thrilled w/the idea that some reports are not accurate.

Reply to
PSJ

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.