cancel
Showing results for 
Search instead for 
Did you mean: 
mhallinan
Level 1

Exported Excel Version Sales By Ship to Report does NOT match on line version

Sale by Ship to report export total does not agree report on line.

Invoices are dropped and invoice lines duplicated.

Invoices dropped are dropped when whole months date range used, but can be exported as a single record.

Error reproduced in two different Quickbook companies, locations, computer systems.

Two different users.

On-line report version is correct.

Excel exported version corrupted.

Record count in both databases less than 3000 invoices in calendar month.

 

Any work arounds?

 

 

 

5 Comments 5
Tori B
QuickBooks Team

Exported Excel Version Sales By Ship to Report does NOT match on line version

Hey there, @mhallinan.

 

Thanks for reaching out to the Community for support and sharing your concerns. 

 

When you export reports from QBO to Excel, it's recommended to use 64-bit versions of Windows. This way, you can have more resources such as processing power and memory. You can check and update your info by selecting the File tab from the Excel ribbon. Then, choose the Account option and click About Excel. Please see the screenshot below for your reference.

 

If you continue to have issues, I recommend trying these workarounds:

 

  • Copy the broken report to a new workbook
  • Create a new Google Chrome user
  • Use alternate browser (i.e., Mozilla Firefox)

That should do it. Please let me know if you're continuing to have issues with your exported reports. 

 

Take care and have a wonderful day ahead! 

mhallinan
Level 1

Exported Excel Version Sales By Ship to Report does NOT match on line version

I did find the excel version is 32 bit. Therefore, will work with sysadm to upgrade. Thank you. 

mhallinan
Level 1

Exported Excel Version Sales By Ship to Report does NOT match on line version

I used a 64 bit version of excel and it did not help. For clarification the application is Enterprise 2020 product number 194-238

mhallinan
Level 1

Exported Excel Version Sales By Ship to Report does NOT match on line version

I used 64 bit and it did not change application is Enterprise 2020 Manufacturing and Wholesale Product number 194-238

SashaMC
Moderator

Exported Excel Version Sales By Ship to Report does NOT match on line version

Hey mhallinan,

 

Thank you for reaching back out to us. Since it didn't work change application, I recommend reaching out to our QuickBooks Support Team to investigate the matter further. Here's how to contact us:

 

  1. Go to the Help menu.
  2. Hit the Contact Us button
  3. Enter a brief description of the problem.
  4. Select "Let's Talk"
  5. Pick the "Get a call" or "Start a Chat" options to connect with us.

 

 

 

Please let me know how the interactions go and if you have any other questions, feel free to let us know below. I hope you have a wonderful day! 

Need to get in touch?

Contact us