Detailed report of money out by chart of accounts account type

AKJohnC · ‎August 23, 2023

How do I create a detailed report of money out which will show the chart of accounts account type (expense, equity)?

Ethel_A · ‎August 23, 2023

Welcome to the Community, @AKJohnC.

I'll help you run a report for your accounts that shows their accounts type for money out.

You can run a Transaction Detail by Account report and filter it to the expense transactions.

Here's how:

From the left menu, go to Business Overview and choose Reports.
Click on the Find report by name search bar.
Enter Transaction Detail by Account.
Hit the Customize button.
Click the Filter dropdown.
Tick the checkbox for the Transaction Type and choose the expense transactions from the dropdown.
Hit Run Report.

For future reference, you can read this article to memorize the report: Memorize reports in QuickBooks Online. It contains the steps to save your customization of the report.

Let me know if you have questions about running reports in QuickBooks Online. I'm always here to help. Have a great day.

AKJohnC · ‎August 24, 2023

Hi Ethel,

Thanks for your reply, but I am not interested in transaction type. I want to see the account type from the chart of accounts.

DebSheenD · ‎August 24, 2023

Hello there. @AKJohnC.

Let me chime in and help you generate a report account type from the chart of accounts in QuickBooks Online.

Here's how:

Go to Reports.
Click the search engine to find the report you need.
Enter Account LIst.

With this, you can easily find the account type from the chart of accounts.

I'll include this helpful resource that you can read to get more information about the account and detail types in QBO: Learn about account types and detail types in QuickBooks Online.

I'm always here ready to lend a hand if you have any other concerns managing your accounts in QuickBooks. Have a good one and stay safe.

AKJohnC · ‎August 24, 2023

Thanks but all that looks like is a report of my chart of accounts.

AKJohnC · ‎August 24, 2023

Here is a sample of what I need

Date	Trans Type	Name	Account	Account Type	Amount
08/01/2023	Expense	Office Depot	Office Supplies	Expenses	$25.00
08/02/2023	Expense	Electric Co	Utilities	Expenses	$75.00
08/03/2023	Expense	Acme	Medical Equip	Fixed Assets	$100.00

Column 5, Account Type from the Chart of Accounts, is the data field I'm interested in seeing. Because if a transaction gets accidentally categorized as Account Type 'Fixed Assets' then it won't show on the Profit and Loss report and that's the report I use to get my monthly expenses.

Ethel_A · ‎August 24, 2023

Thank you for getting back to us, @AKJohnC.

In QuickBooks Online, there is no report that shows the chart of accounts and account types specific for money out.

I am aware of the advantages for businesses like yours. I want QuickBooks Online (QBO) to have this feature as much as you do.

However, I strongly urge you to share your thoughts with our software engineers. They carefully examine customer feedback, especially when determining how to improve QuickBooks.

Here's how:

Sign in to your QuickBooks Online account.
Go to the Gear icon and select Feedback.
Type in your suggestion and click Next.

As a workaround, you can export the Transaction List by Vendor report to Excel. From there, you can edit the report and add a column for the account types. Refer to your Chart of Accounts for the account types and add them manually to the Excel file.

Here is an article you can read for the detailed steps of exporting reports to Excel: Export reports, lists, and other data from QuickBooks Online.

Also, you can visit our blog site so you'll be able to get the latest news about QuickBooks and what our Product Care Team is working on.

Don't hesitate to comment below if you have questions about running reports in QuickBooks Online. I'm always here to help. Have a great day.

Topics

Training

Community

Resources

Detailed report of money out by chart of accounts account type