BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
Jovychris_A
Moderator

Reply to message

I appreciate that you've been looking for ways on how to export transactions out of QBO, @harpercreates-ma.

 

Currently, we're unable to export a CSV file from QBO. However, you can move transactions out of QBO to an Excel file. From there, you can change the file format to a CSV file.

 

Let me show you how:

  1. Go to the Gear icon and then select Export data under Tools.
  2. Go to the Reports tab and then switch on to export the following reports to Excel (these reports contain QuickBooks transactions).
  3. Switch off the lists from the Lists tab.
  4. Select Export to Excel.
  5. Hit OK.

Once done, open the zip file and run the a Excel file that contains a specific report. Click Enable Editing. Then follow these steps below to convert the Excel file to CSV:

 

  1. Click File and then choose Save As.
  2. Select Documents folder.
  3. In the Save as type drop-down, select CSV (Comma Delimited).
  4. Click Save and Yes to confirm.
     

That should point you in the right direction. I've also attached an article to check other options for exporting QBO data: Export Data out of QuickBooks Online.

 

Also, if you wanted to backup your data there apps in the QuickBooks App store that provide continuous backup.

 

Let me know if there's anything that I can help with exporting transactions or data out of QuickBooks. I'm always here to assist. Stay safe and have a wonderful day!

Need to get in touch?

Contact us