Open Forum

Expand all | Collapse all

Trial Balance Report does not match excel download

  • 1.  Trial Balance Report does not match excel download

    Posted Aug 24, 2020 12:36 AM
    I went to Financial>Reports> Trial Balance to generate the Summary Trial Balance report. For the Destination, I selected Screen so I can convert the report to pdf and File to download to excel. On the print to screen report, the Debits and Credits match. However, on the excel download, the Debit and Credit totals do not match; the Credit total is greater by only $1.13. Have you ever encountered this situation? Any ideas you can share?

    Thank you very much!  #Accounting,#GeneralLedger,#Finance

    Summary Trial Balance downloaded to excel



    ​​​​​​

    ------------------------------
    Cindy Hui
    Silicon Valley Clean Water
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Trial Balance Report does not match excel download

    TOP CONTRIBUTOR
    Posted Aug 24, 2020 09:51 AM
    Hi Cindy,

    Maybe... there might be a formatting issue?

    In the example below, the sum (B5) is supposed to be 606... but due to the formatting, only 101 and 303 are being recognized as numbers...




    ------------------------------
    Ryan Galang
    BTP Technologies LLC
    CHANTILLY VA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Trial Balance Report does not match excel download

    Posted Aug 24, 2020 11:03 AM
    Hi Ryan,
    Thank you for sharing but unfortunately it's not a formatting issue; I only wish it were! I checked a few times and I also ran the Detailed Trial Balance and downloaded to excel, coming up with the same result. The debits and credits match for the report, but the excel download for the debits and credits is off by the $1.13.

    ------------------------------
    Cindy Hui
    Silicon Valley Clean Water
    Redwood City CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Trial Balance Report does not match excel download

    SILVER CONTRIBUTOR
    Posted Aug 25, 2020 04:12 PM
    Hi Cindy,

    Could it be because you selected Unit accounts?  When I have unit account transactions, it is a one sided transaction, so it throws it off when we calculate in Excel if we include the unit accounts.  Just thought that might be one area as to why the debits and credits don't equal.

    Thanks,

    ------------------------------
    Margo Call
    Great Plains Administrator
    Nueterra Holdings, LLC
    Leawood KS
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Trial Balance Report does not match excel download

    GPUG ALL STAR
    Posted Aug 25, 2020 04:42 PM
    Edited by Jo deRuiter Aug 25, 2020 04:42 PM
    Hi All!

    The issue ended up being a rounding difference.

    The Screen-Print was rounding the final net change total to zero, but upon export to CSV the CSV file did not do the rounding.   When a formula to round was entered as the total on the CSV file it worked.  Conversely when we exported the PDF of the screen-print to an Excel file and totaled the screen print there we found the same -$1.13  total.

    I did recommend to Cindy that she use an SSRS report as opposed to trying to export from GP to a CSV file.  I would also recommend that to others!

    ------------------------------

    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Trial Balance Report does not match excel download

    Posted Aug 25, 2020 04:53 PM
    Thanks to Ryan and Margo for sharing your ideas! Special thanks to @Jo deRuiter for reviewing it and finding the issue!  Lesson learned - if you can help it, make sure your entries are limited to 2 decimal places! ​We're still waiting for our SSRS report access, so I'm very anxious to try it to see if it will result in the same -1.13 difference!

    ------------------------------
    Cindy Hui
    Silicon Valley Clean Water
    Redwood City CA
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role