Whenever I export a report (Income/Expense or Balance Sheet) to Excel, I always have to adjust the outside margins in Excel after export. Is there a way to change the report format in Quickbooks so that it exports the way I want it to without having to reformat afterwards?
Exporting reports allows you to have a personal copy outside of QuickBooks. QuickBooks is geared towards giving you maximum flexibility when it comes to running reports and exporting them. I'll be glad to share information about exporting reports.
First, I'll list out the ways you can export reports in QuickBooks and here's how:
In QuickBooks, go to the Reports menu and select Reports Centre.
Find and open any report.
Select the Excel on the toolbar. You can also select Print or Email to save the report as a PDF.
To create a new Excel workbook, select Create New Worksheet. If you want to update an existing workbook with the data in the open report, select Update Existing Worksheet. Select Browse and then find the workbook on your computer. Keep in mind, this overwrites the existing workbook.
If you want to format the data a specific way, select Advanced. This is optional.
I encourage you to check out these helpful article with more info on customizing your templates so your reports can be exported the way you'd like for them to:
Thank you for your response, however everything you posted about exporting to Excel was information I already knew and use daily. It did not however answer my question about changing the format of the Quickbooks report margins so that they are correct when I export, rather than having to change the margins in Excel after I export.
Also, the links at the bottom of your response only talk about customizing templates, which also does not address my question about reports.
Glad to hear back from you. I see what you're saying. It's vital you get the support you need with this so you can view your reports in Excel properly. From here, I recommend contacting our support team as they can share your screen and help get to the bottom of this ASAP. You can reach out to our team using this link here or by dialing 1-833-317-2226 (Mon - Fri 9am - 8pm EST). Feel free to check the Intuit QuickBooks Desktop software support policies when you have a minute. Let me know if you have other questions.