Skip to main content
D
Deadwood Al
December 31, 2024
Question

Looking for a report that ...

  • December 31, 2024
  • 1 reply
  • 0 views

I would like to print a report that essentially looks like the Chart of Accounts (Account Listing) with the normal options for that, for the Income & Other Income, and then another for the Expense and Other Expense accounts for the year, but in the "Balance" column I would like it to print the total of the income or the total of the expense for the year. I know I could print the trial balance for the dollar totals, but I'd like some of the info from the GL Account detail.  Does such a report exist or can one easily (key word) be created?

 

Thanks in advance.

1 reply

D
Deadwood AlAuthor
December 31, 2024

Forgot to mention ... if the income / expense for the year was zero, I would still want the item to print to help identify accounts that may be no longer needed or could be inactivated.

JenoP
JenoP
January 1, 2025

QuickBooks Desktop does not have an existing report that displays an account listing with balances for a specified period, Deadwood Al. However, there's a workaround to obtain the information you need. Let me share it with you.

 

Start by generating the Account Listing report, which will provide you with all income and expense accounts along with their GL account details.

 

 

Next, export this report to Excel to filter out any unnecessary accounts or information. Just click Excel and choose Create New Worksheet.

 

 

For guidance on this process, refer to the article: Export reports as Excel workbooks in QuickBooks Desktop.

 

Then, access either the Trial Balance or Profit and Loss report to get the dollar amounts for the year. Here's how:

 

  1. Go to the Reports menu, look for Company and Financial, and then click Profit and Loss Standard.
  2. Go back to the Reports menu, hover your mouse to Accountant and Taxes, and then click Trial Balance.

 

 

After that, export them to Excel again and merge the data from the Account Listing with the Trial Balance or Profit and Loss report to obtain the necessary information.

 

To enhance your reporting skills in QuickBooks Desktop, we recommend checking out these additional resources:

 

 

As always, you can visit us anytime in the forum if you need more help with your chart of accounts as well as running reports. We're ready to provide personalized assistance and ensure you maximize QuickBooks Desktop's powerful reporting capabilities. 

D
Deadwood AlAuthor
January 1, 2025

Hmmmm .... not "easy"

 

I am not experienced in merging.  It would likely take a while to learn doing that. Bummer.

Terms & ConditionsAccessibility statement