How do I get the numbers in one of My Saved Reports to add up to the correct total?

DLCas

I have tripled checked the numbers my numbers with my calculator. I've been using Quicken very extensively for more than 15 years! I'm currently using the 2020 Quicken Premier.

Rocket J Squirrel

Looking at my post above, notice the difference between the incorrect and correct sums is $968.86. I searched for that amount and found it in that account.

Memory of this 2015 transaction has faded, but somehow this seems to have affected the report. I figured the RtrnCap transaction might have affected the report's cost basis, but setting the amount of that transaction to zero did not affect the report's incorrect sum. I don't own INTU any more because the call was exercised, and this theoretically should not show up in today's Portfolio Value report anyway. Theories, anyone?

DLCas

Thank you for you help, Rocket. I did a search in my IRA account that I was having trouble with and found a transaction that I had mistakenly entered in 2019. After I deleted that entry, the account showed the correct toal that match my brokerage statement. David

Ps56k2

Which report - and what seems to be the overall problem ?

I've personally stumbled over reports where I have missed including something....
- account, security, category, tag, etc....  

DLCas

In the drop down under "Reports" I created a "PortfolioValueByAccount" report that has two accounts: a regular brokerage account and an IRA account. This report shows the individual securities, # of shares, security price as of a certain date (that I change to the next quarter end each quarter), cost basis, gain/loss, & balance for each security & cash held in of the two accounts and it shows the total value of each account and the total value of the portfolio.

The IRA account has 23 individual holdings including cash. When I add up the individual holdings included in the Quicken report, the report shows a total account balance that is $22076 lower than the number that than the number that I get when I add up the total of the 23 individual holdings shown in the report, and I get a total that is $22076 lower than the total that I get when I use my calculator to add up the numbers shown in the report. Quicken is not adding up the numbers correctly in the report.

None of the holdings in the account equal $$22076. I have been reconciling both cash & account value in Quicken to my broker's statements each quarter for many years. For these many years Quicken has always added up the numbers in this report correctly each and every quarter. I have not changed any holdings in this account for a number of quarters, and Quicken has always produced the accurate total in this report.

Is there a solution to this problem?

Frankx

Hi @DLCas,

Are you adding up the numbers only in the far right column - i.e. the "Balance" column?  Or have you also tried adding up the other columns such as "Cost Basis" and "Gain/Loss" t see is they crossfoot?
Also, there shouldn't be, but are there any negative numbers in the column that you are "adding up"?

Frankx

Jim_Harman

A couple of things to check:
-- Does the balance for each of the securities in the report match the balance on your statement?

-- Have you done a File > File Operations > Validate file? This may resolve any inconsistencies in your data. 

-- Also since this is a saved report that you have been using and updating for many years, you might try re-creating the report from the standard Investing > Portfolio Value report and see if that fixes the problem.

Rocket J Squirrel

Quicken sometimes forgets 3rd grade arithmetic.

The easy way to check is to export your report to Excel. Then you can select cells and Excel will show you the sum at the bottom. I just created a new Portfolio Value report in a validated file and I can find a few places where the numbers don't add up. The bottom cell in the image is Q's sum. You can see Excel's correct sum below that.

Another view in Quicken of the same data (in the Account Overview) shows the correct sum:

Jim_Harman

There have been problems with this report related to split transactions. Similar problems with other reports were fixed a couple of years ago, but I'm not sure if Quicken ever got to this one...

Please see this discussion and see if it applies to your situation
https://community.quicken.com/discussion/7719827/account-balances-report-shows-negative-cash-when-there-are-withdrawals-with-splits

Rocket J Squirrel

Looking at my post above, notice the difference between the incorrect and correct sums is $968.86. I searched for that amount and found it in that account.

Memory of this 2015 transaction has faded, but somehow this seems to have affected the report. I figured the RtrnCap transaction might have affected the report's cost basis, but setting the amount of that transaction to zero did not affect the report's incorrect sum. I don't own INTU any more because the call was exercised, and this theoretically should not show up in today's Portfolio Value report anyway. Theories, anyone?

DLCas

Thank you for you help, Rocket. I did a search in my IRA account that I was having trouble with and found a transaction that I had mistakenly entered in 2019. After I deleted that entry, the account showed the correct toal that match my brokerage statement. David