While this report can be created in QuickBooks, the bank needed it in Excel format. Start with a Transaction Detail by Account report. On the Display tab of the Customize Report window, it is possible to select the columns wanted.
http://www.quickbooks-training.net/add-power-excel-quickbooks-reports/
In QuickBooks 2014 R5, you are unable to export reports to Excel (such as a transaction journal or A/R aging report) or emailing reports as an Excel document. When clicking the export button (or email- Send Report as Excel), you will not see the export to Excel option appear like it will for other reports.
http://qbpros.net/2014/03/2132/
Add the power of Excel to your QuickBooks Reports. Marrying the abilities of Excel and the data of QuickBooks can sometimes solve problems QuickBooks alone cannot. One example is when QuickBooks does not possess the capability to create certain reports, like including a calculated column or a customized chart.
http://www.quickbooks-training.net/add-power-excel-quickbooks-reports/
Cannot Export Reports to Excel with QB 14. We recently upgraded to QB 14 from 12. I rely entirely on the ability to export inventory/sales data to Excel to manipulate it. With the new QB, when I click export to Excel - nothing happens. No error message, no report created, no dialog box, nothing.
https://community.intuit.com/questions/880223-cannot-export-reports-to-excel-with-qb-14
What you can try now. Unable to export a Transaction Journal report to Excel, export via the Customer Center: 1  Open the Customer Center and find the transaction in the Transactions pane. 2  Right-click on the transaction you want to see a Transaction Journal on.  Choose Transaction Journal.
http://qbpros.net/2014/03/2132/
Can't export the report to excel. I am using QuickBooks Premier Edition 2012, Windows 7 Professional and Microsoft Office 2013. Previously when I run Report Center and export the data to excel, everything is fine. Just recently I couldn't export to excel. It will show up saying that 'Excel could not open the data file'.
https://community.intuit.com/questions/782834-can-t-export-the-report-to-excel
People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines: Keep it conversational. When answering questions, write like you speak.
https://community.intuit.com/questions/880223-cannot-export-reports-to-excel-with-qb-14
Right-click in the now highlighted column A. From the menu that pops up, choose Hide. Save the Excel worksheet. The next time this report needs to be run, create the memorized QuickBooks report. Export the report to Excel, making this one change in the way we did this earlier. Choose Update Existing Worksheet rather than Create new Worksheet.
http://www.quickbooks-training.net/add-power-excel-quickbooks-reports/
Unable to export a Transaction Journal report to Excel, export via the Customer Center: 1  Open the Customer Center and find the transaction in the Transactions pane. 2  Right-click on the transaction you want to see a Transaction Journal on. 3  Choose Transaction Journal.  Click the Excel button and choose Create New Worksheet to export your report to Excel.
http://qbpros.net/2014/03/2132/
What you can try now. Unable to export a Transaction Journal report to Excel, export via the Customer Center: 1  Open the Customer Center and find the transaction in the Transactions pane.  Right-click on the transaction you want to see a Transaction Journal on.
http://qbpros.net/2014/03/2132/
what report in quickbooks cannot be exported to excel
A Transaction Journal report is a report in quick books which cannot be exported to excel. A Transaction Journal report in QuickBooks cannot be exported to Excel.