I suggest you ...

export reports to excel

when exporting some reports to excel we get numbers in the amount and balance columns that come over as "number stored as text" this didnt happen up until last friday. it doesnt happen on all reports and no troubleshooting we have done fixes this. I cant apply formulas to the reports that show up like this so it is a real hindrance for me to have them like this.

35 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Susan Reynolds commented  ·   ·  Flag as inappropriate

        Hope this gets completed soon. Wasted several hours on multiple reports changing the "numbers stored as text" just so I could add a few more formulas to the report!

        By the way, is there a reason for not totaling the Gross Margin column on the sales reports or extending the margin percentage calculations?

      • CCC commented  ·   ·  Flag as inappropriate

        Please fix this. It's very inconvenient to keep converting text to numbers all the time.

      QuickBooks Online Feature Requests: Reports

      Feedback and Knowledge Base