Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
August 5, 2025
Question

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

  • August 5, 2025
  • 1 reply
  • 31 views

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 reply

JoesemM
QuickBooks Team
August 5, 2025

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.