Report Rounding Error

In running a Net Worth report I am finding that the total for Investments is off by $0.01which I assume is a rounding error. I did find a similar article that said to go to Edit -> Preferences, select Reports Only and change "Decimal place for prices and shares" to the desired precision (0-6). It had been set to 3, and I've tried setting it to 2 and 0, but the Net Worth report continues to be off by $0.01 as before. Exporting the report to Excel and using Excel to SUM values (which are all 2 decimals) confirms the error.
Can this be fixed? I am using Quicken Deluxe Version R33.24, Build 27.1.33.24 on Windows 10.
Thank you.

Answers

  • NotACPA
    NotACPA SuperUser, Windows Beta Beta
    Off by 1 penny compared to what?
    And note that my brokerage, Fidelity, truncates fractional pennies while Q uses traditional 5/4 rounding ... so if the pennies on a single position agree, it's a coincidence.
    Sometimes I'll be off by 4 or 5 cents in the account with 15 positions.  SO, just remember: "DON'T SWEAT THE SMALL STUFF"
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
  • JerryD
    JerryD Member
    I understand Banker's Rounding and all the other variants. That's not the issue. Even when exporting a Net Worth report to Excel, the math doesn't work. Kind of disconcerting when your bookkeeping app can't add!
  • NotACPA
    NotACPA SuperUser, Windows Beta Beta
    Try expanding the digits to 6.  And you never answered by "compared to what" question.
    If you could post a snapshot, from Q, of the issue it would be helpful.
    Q user since DOS version 5
    Now running Quicken Windows Subscription, Home & Business
    Retired "Certified Information Systems Auditor" & Bank Audit VP
Sign In or Register to comment.