Thanks for getting back to us, @jparker24.

We're unable to remove the line breaks for the subtotals on the Journal report. Though, we can run the Transaction Detail by Account report. This way, the line breaks will no longer appear in Excel.

Here's how:

1. From the Reports menu, select Accountant & Taxes.
2. Choose Transaction Detail by Account.
3. Click Customize Report.
4. On the Search Columns box, search Class and then place a checkmark beside it.
5. On the Search Columns box, search Account, then place a checkmark beside it.
6. Type in Trans # in the Search Columns box and put a checkmark beside it.
7. Once done, click on OK.

Then, we can now export the report to excel. I'll guide you how:

1. Click the Excel drop-down menu.
2. Choose Create New Worksheet.
3. Select the Advanced button.
4. Check or uncheck the boxes under Excel Options to remove or add those features.
5. Click OK, then Export.

I've included a reference below:

Here's a guide in exporting your reports to excel from QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop.

You may also want to consider memorizing reports. Doing so helps save the current customized settings for easy access in the future.

Stay in touch with us if you have other QuickBooks related concerns. We're always here to help you.