Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
Sharon-Shandor
Level 1

Has anyone had a problem with QBO limiting the lines of data when exporting to Excel? I only get 2505 rows no matter how I filter it

I am in the Asset register for a specific account. If I filter by dates, or no dates at all I only get 2505 rows of data. Is there a setting or something I need to change?

1 Comment 1
JoesemM
Moderator

Has anyone had a problem with QBO limiting the lines of data when exporting to Excel? I only get 2505 rows no matter how I filter it

You can run an Account Quick Report and export the bank register into an Excel file, Sharon.

 

To export your bank register into Excel without hitting the row limit, you can opt to run an Account Quick Report instead of exporting directly from the Asset account register. This alternative method allows you to bypass the 2,500-row limit often encountered during direct exports.

 

Here's how:

 

  1. Open the Asset account register.
  2. Click on the drop-down arrow next to View Register.
  3. Select Run Report.
  4. Filter the date range and customize the necessary details.
  5. Click the Export to Excel option.

 

Once done, review the transactions shown in the Excel file. For more details on how to get your reports outside QuickBooks, see this link: Export your reports to Excel from QuickBooks Online.

 

On top of that, utilizing QuickBooks Live Expert Assisted can significantly enhance your accounting practices by ensuring the accuracy of your financial records and providing access to professional support.

 

If you have any further questions or need assistance with exporting your reports, feel free to ask. I'm here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us