United States United Kingdom Australia Canada (English) Canada (French) France Singapore South Africa Global Ireland
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ocamb
Level 1
posted
‎February 10, 2021 08:55 AM
last updated ‎February 10, 2021 8:55 AM

When exporting all transactions as in the journal report, produce an Excel file without blank lines and sub-totals

this Excel file is to be used with pivot tables which can't handle blank lines and sub-totals
Reply Join the conversation
1 Comment 1
MaryLurleenM
Moderator
Moderator
‎February 10, 2021 10:15 AM

When exporting all transactions as in the journal report, produce an Excel file without blank lines and sub-totals

Hello there, ocamb,

 

The report exported in Excel is working as designed. You can manually remove these blank lines once exported.

 

Check out these articles to learn more about reporting in QuickBooks:

If you have other questions, please know we're always here to help.

Reply Join the conversation
Featured
Quick Start with a Product Expert: Moving from Desktop to Online
Hi Community! Today our expert Mike Santos is sharing his top 3 tips on how...
Read more
Community Chatter Series: Episode 10 (Reconciliation within QuickBooks Online)
(view in My Videos) For topics mentioned in this episode, check out the fol...
Read more
Handling Quarterly 941 Forms
Hello QuickBooks Community! The quarterly 941 filing deadline is right arou...
Read more

Need to get in touch?

Contact us