Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am using the QuickBooks online test drive to try to export reports into a CSV file.
I do not see an option to export the Profit an Lost report into a CSV file. I am following these steps:
Step 2 - there is an option to export to Excel or PDF, not CSV. There is also not an option to create a worksheet. How can export a report into a CSV file/format?
I'm delighted to encounter you here, @TKrawford.
Let me share insights about exporting reports. The reason why it isn't possible to export a QBO report using the CSV file/format is that there are punctuation marks in the report that when exported to a CSV file, the meaning may be different there which might cause changing the format and details.
As a workaround, you can proceed with exporting it as an Excel file and then convert it to a CSV file/format. To avoid changing the layout and details.
Feel free to read this article for more info: Export your reports to Excel from QuickBooks Online.
To format the layout so the right data shows up in the right place, you can read this article: Customize reports in QuickBooks Online.
Know that I'm here anytime you need help, so stay in touch. Have a great day!
Hi there, TKrawford.
Thanks for getting back to us. I'm here to share information about exporting reports from QuickBooks Online (QBO) into comma-separated values (CSV) files.
The steps you've shared above are only applicable to QuickBooks Desktop (QBDT). This is the reason why you're unable to see this option.
Currently, the ability to export your Profit and Loss (P&L) report into a CSV file is unavailable in QBO. You can follow the workaround shared by my colleague Bryan_M above to export it as an Excel file first. Then, manually convert it to a CSV file format.
I can see how having this option would be helpful for you. We'd love to hear your input. I recommend leaving feedback to notify our engineers about the feature you need. This way, they can consider adding it in future updates. Here's how to submit feedback:
You can track feature requests through the QuickBooks Online Feature Requests website.
In case you need it, I'll add this article that tackles memorizing report in QBO for future reference: Memorize reports in QuickBooks Online.
Please leave a comment below if you have follow-up questions about this or anything else. I'm always here to help. Take care.
Can you recommend any third party apps that will export QBO reports into a CSV format?
Thanks for getting back here, @TKrawford.
While I cannot recommend an app, I'll share the steps where you can look for an application specific to your business needs in QuickBooks Online (QBO).
Follow these steps to proceed:
You can also visit the QuickBooks App Center website for a third-party application that best suits your business needs. You can go to the Categories section to filter the results.
Additionally, you can utilize these resources that you can check out to learn more about how you can personalize and memorize your reports in QBO seamlessly:
Keep me posted if you still have questions or concerns about managing your reports in QBO. I'll be here to lend a helping hand. Have a great day ahead!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here