As I try to continue reconciling Q Classic Cda to Excel

Tealeaf3

Is there a way to see the breakdown by Account and Items of increases or losses overall per day.

My separate calculation shows a difference and even using Portfolio Value reports for the day does not show a figure that is produced by the program but matches my Excel??? calculations

Quicken Kristina

Hello @Tealeaf3,

Thank you for reaching out! If you're wanting to see the day gain/loss per account, you can do that in your Quicken in the Investing tab, Portfolio tab.

Select Accounts from the dropdown.

If Day Gain/Loss isn't already visible, click the Customize button and add that column.

You can use the Export option to export to your clipboard or Excel, if needed.

I hope this helps!

Tealeaf3

Well it helps but does not lead to any reconciliation.

The total of the separate accounts does not match the overall total by some, in this case, 386.55.

I had one transaction closing that day which bears no resemblance.

What kind of check can I run? Validation shows nothing.

I reinstated an old back up and then ran an update but it seems to only download quotes from the last week???!! so I have lost data for over 2 months. The prior file that I closed to get that old one disappeared unless you can tell me how to recover it. It shows in Quicken as recently used, but I cannot see the location on my PC, Yikes!! Using Q Cda 27.1.65.20 on Windows 11

Tealeaf3

Interesting or not, I found or should say I was able to download the latest file but it does not appear on my PC at C:\Users\"myName" as indicated by Quicken but at C:\Users\Downloads folder, so Quicken was not helpful that way.

Now back to solving my original problem

Quicken Kristina

Thank you for your replies,

Well it helps but does not lead to any reconciliation.

The total of the separate accounts does not match the overall total by some, in this case, 386.55.

I had one transaction closing that day which bears no resemblance.

What kind of check can I run? Validation shows nothing.

To clarify, individual account totals are not matching the overall total shown in Quicken? Is the total you're referring to on the account sidebar, in a report, or somewhere else?

One possible cause is if you have hidden accounts. Those would impact the total on reports, even though they're not visible on the account sidebar. For more information, see this article: https://info.quicken.com/win/about-hiding-separating-and-closing-accounts .

To check for hidden accounts, navigate to Tools>Manage Hidden Accounts.

The window that comes up will list all your accounts in alphabetical order. If an account is hidden, you will see a check in the applicable checkbox.

Thank you!