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

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

 
Solved
Best answer April 23, 2020

Best Answers
MirriamM
Moderator

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Hello again, @blindsey. Thanks for getting back to us and provided additional details. Let me clarify things out. 

 

When exporting reports in QuickBooks Online (QBO), there are limitations that the system can handle. 

 

Right now, the size limits when exporting a report to Excel are the following:

  • Maximum of 1024 columns displayed
  • Maximum 400k cells with data
  • Maximum 10MB worth of data

The above mentioned could be the reason why you're unable to export the report one at a time. As a workaround, you can export the report on you're preferred period as long as it still meets the requirement.

 

To know more about this, you can check this article: QuickBooks Online file size and feature limits.

 

Reach out back to me if you have other questions. I'm always here to help. Have a fantastic day!

View solution in original post

8 Comments 8
GlinetteC
Moderator

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Hi there, blindsey.

 

Let's sort this out. We can check if this isn't a browser-related issue. Excessive cache in your browser might be the reason why you're unable to export all your transactions. Please click F5 to refresh the page. If the same thing happens, we can access your account via an incognito window. Please use these keyboard shortcuts depending on the browser you're using:

  • Google Chrome: press Ctrl Shift N  
  • Mozilla Firefox: press Ctrl Shift P
  • Internet Explorer: press Ctrl Shift P
  • Safari: press Command Shift N

If you're able to export all your data, let's clear your browser's cache to start the system fresh. Also, switching to other supported browsers could help.

 

Keep me posted on how these steps work. I want to make sure everything is taken care of for you.

blindsey
Level 1

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

I've now tested this is QBO in Firefox and Chrome, after refreshing, clearing cache, and running in incognito mode. All with the same results. I know the transactions are there because I can just click the last tab.

 

I've also attempted this through the QBO app and I get the same results.

blindsey
Level 1

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

I've now tested this in Firefox, Chrome, and the QBO app with the same results. I clear cache, I refresh browser, I even ran them in incognito mode and still the file was incomplete. I know the transactions are there because I can click the last tab and see additional years of transactions.

JessT
QuickBooks Team

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Hi there, blindsey,

 

I'd like to add details about exporting entries to CSV.

 

I'd suggest exporting your transactions in batch since the export option limits to 1000 lines. You can export the list of transactions in 2019 first, then followed by 2018 transactions. Then, just combine them into one Excel sheet by copying and pasting them.

 

Let me know how this works for you. Have a good one!

 

 

Fiat Lux - ASIA
Level 15

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

@blindsey 

As additional option, utilize the trial period of this 3rd party exporter tool

https:// transactionpro.grsm.io/qbo

 

Hope it helps.

 

blindsey
Level 1

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Yes, I COULD do this, but that seems extremely cumbersome. I could additionally write a crawler script to scrape the data into a file if QB doesn't provide the basic functionality. BUT how is this the answer? Also, the max line size seems off because it exported ~2500 lines--but only two years--If this were true shouldn't I get a warning or notification that my export will be incomplete? I need transactions all the way from 2015.

 

 

MirriamM
Moderator

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

Hello again, @blindsey. Thanks for getting back to us and provided additional details. Let me clarify things out. 

 

When exporting reports in QuickBooks Online (QBO), there are limitations that the system can handle. 

 

Right now, the size limits when exporting a report to Excel are the following:

  • Maximum of 1024 columns displayed
  • Maximum 400k cells with data
  • Maximum 10MB worth of data

The above mentioned could be the reason why you're unable to export the report one at a time. As a workaround, you can export the report on you're preferred period as long as it still meets the requirement.

 

To know more about this, you can check this article: QuickBooks Online file size and feature limits.

 

Reach out back to me if you have other questions. I'm always here to help. Have a fantastic day!

View solution in original post

blindsey
Level 1

When I export an account register to csv (example exporting Accounts receivable register from the Chart of Accounts), I only get the last 2 years of transactions. What do

I think this is definitely it. Seems like some pretty conservative caps in the age of big data. But I get it--sounds like it's time to upgrade to Desktop.

 

Thanks for your help.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up