Transaction summary by account

Hi there, @TerryM74. 

Thank you for reaching out to the Community. We can customize the Transaction Detail report to the specific filter you want to show in data. However, showing all the accounts in chart of account, the only way we can do as a workaround is import  Customer, Vendor, Items, and Chart of Accounts from an Excel spreadsheet. 

There are several options available when importing Excel files from QuickBooks. This article will help you to determine the different type of option to import Excel file: Import or export MS Excel files. 

To import Chart of Accounts here's how: 

1. Go to the Lists menu, then press Chart of Accounts.
2. Select the Account drop-down at the bottom, then choose Import from Excel.
3. Tap Browse to select the Excel file you want to import.
4. Choose the file, then hit Open.
5. Click the Excel Sheet where the data you want to import is on.
6. Map your accounts.

   Mapping your accounts tell QuickBooks how to import the data from your Excel sheet. The column headings in QuickBooks may be different from your Excel, so you’d need to match them.

   • Type in a mapping name.
   • Select Account as Import type.
   • Match the information under QuickBooks with the column headings in your Excel sheet.
   • Select Save.
7. Press Import. If it's your first time to import, select Yes to confirm the process. 

Note: Before importing, we recommend that you create a backup of your company file.

You can also check out this link about the various list and transaction type you can import and export: Import and export data in QuickBooks Desktop.  

That's it. If you need anything about reports just click the Reply button. I'll be here to lend you a hand. Have a great day!

You have me backwards.  I am NOT trying to import data into QuickBooks, I am trying to generate a report for EXPORT from QB to Excel or a CSV file to send 'upstairs' to the parent/franchisor.  I am currently using a modified version of the transaction detail report which shows every debit and every credit to each account each reporting period (month).  What the parent wants is a summary report that shows a net total of all debits and credits to each account for the period.

Hi there, TerryM74.

For now, we're unable to run a transaction summary report by account with a Debit and Credit column to it. You can continue exporting the data to Excel where you can remove or modify some data from it. 

You'll also want to keep these articles in case you might need them in the future. 

• Customize reports in QuickBooks Desktop
• Create, access and modify memorized reports

Add another reply below if you need them in the future. 

I don't need a report with separate debit and credit columns.  I need a report similar to my custom detail transaction report showing a summary total of all transactions for that account.

My current custom report shows the transaction date, the GL account number, and the debit (+) or credit (-) amount for every leg of every transaction in three columns.  What they would like to see is the month-end date, the GL account number, and the net of all transactions for the month in three columns. 

From your response above, I will tell them that the report they want is not directly available in QB and needs to be constructed in Excel from a QB export of our current report, and the desired report will require either considerable work each month by every one of the 1800+/- affiliates or a custom macro-driven sheet that they need to provide to each affiliate.

Thanks for your assistance!

Hello TerryM74,

The Custom Transaction Detail Report shows all transactions of all the accounts. It doesn't have an option to add a summary total of all transactions of the account. You still need to filter the report by Account and export it to Excel to see the total.

1. Open the Custom Transaction Detail Report.
2. Click the Customize Report button and go to the Filters tab.
3. Look for Account and filter it to the account you want.
4. Hit OK and click the Excel button.
5. Select Create New Worksheet or Update Existing Worksheet.
6. Click Export.

Supporting articles about customizing the reports are already provided by JenoP.

Another report that I think might help you is the Transaction Detail by Account report. It has the list of all transactions of all the accounts. Also, the total summary is already added at bottom of each account.

1. Click Reports at the top menu.
2. Select Accountant & Taxes and click Transaction Detail by Account.
3. Change the Date range and click Refresh.
4. You can click the Customize Report button if necessary.
5. Then, you can can export it to Excel.

We'll be right here if you need additional help in customizing the reports to get the data you need. Have a great day!