Transaction Detail By Account - Can't filter by desired account because it doesn't appear in list

KJIsaacson · ‎August 10, 2021

Using QBO Plus. I'm having trouble running a desired Transaction Detail by Account report.

I want a report to show all transactions posted to a particular account (i.e., category of expense), but the desired account does not appear in the dropdown list when I go to filter the report by account.

For example, I post certain withdrawals to "CC Fee" (for credit card transaction fees). I do this in the following way: My bank account updates automatically, because it's linked to QB. I go to the register, and in the Account field, I choose CC Fee. I have confirmed that CC Fee appears in my Chart of Accounts.

However, when I go to customize my report, as I said, the dropdown list of accounts does not show CC Fee. Indeed, it shows only a very short, not-at-all inclusive list of accounts.

On the other hand, if I do NOT customize/filter the report (so it shows ALL accounts), I can find the transactions posted to CC Fee.

Any ideas what I'm doing wrong?

Thanks.

MirriamM · ‎August 10, 2021

You've reached the right place for help, @KJIsaacson.

I'll walk you through running the Transaction Detail by Account report that'll reflect your desired account.

To customize the accounts you want to display on your report, the filter of the desired account should be Distribution Account and not Account.

To run the report, here's how:

In the left menu, click Reports.
In the search field, type in Transaction Detail by Account.
Once the report is open, click the Customize button.
Go to the Filter section, then select the desired account/s under Distribution Account.
Click on the Run report button to refresh the page.

For more information about running and customizing reports, check out this article: Run reports in QuickBooks Online.

In case you want to save the current settings of your report, you can memorize them. For the detailed instructions, see this link: Memorize reports in QuickBooks Online.

Keep me posted on how things go, and you can visit us anytime if you have more questions. I'll be here to help you out.

KJIsaacson · ‎August 10, 2021

Before I accept your reply as a solution (because it IS the solution), can you explain to me the difference between a Distribution Account and a garden variety Account?

Thanks.

Catherine_B · ‎August 10, 2021

Hello KJIsaacson,

I can share info on what these accounts are in QuickBooks.

A distribution account in QuickBooks refers to a particular account that you used to track the amount or transaction. Let's say an expense, the distribution will be the Expense account. To know more about our Chart of Accounts and how it works, you can click this link: Learn about the Chart of Accounts in QuickBooks.

For your reports, you can also use this article on how to customize reports in QuickBooks Online.

Let me know if you have other questions so I can help you with them. Take care!

Topics

Training

Community

Resources

Transaction Detail By Account - Can't filter by desired account because it doesn't appear in list