Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do I exclude certain bank accounts (income and expense transactions) from a PnL statement?
I have tried this method but it doesn't work:
If I exclude the bank accounts, it still displays all details.
Thanks in advance.
Since the P&L does not use the bank accounts, it reports on the income and expense accounts
you can not exclude a transaction in a specific account.
Hello babam,
The report will still display the Profit and Loss components, including its details. The Distribution Account checkbox lets you see specific accounts that include income and expense accounts.
This article is also a good reference: https://quickbooks.intuit.com/features/reporting/profit-loss-statement/.
Please visit us anytime if you have other questions.
Hello:
I don't have a filter down arrow. How else can I exclude an account? Thanks!
Hello there, ljclay.
The Filter drop-down arrow in the Profit and Loss report is unavailable when subscribed to QuickBooks Simple Start. If you're currently using the said version, I'd recommend upgrading so you'll be able to exclude an account.
I've attached screenshots below to show you the first to fifth steps.
Once done, you can log out and log back in to make sure the update was implemented. Then, go to the Reports menu and pull up the Profit and Loss report. Select the Customize button to view the Filter drop-down arrow.
However, if you want to continue using your current subscription, you can export the Profit and Loss report to an Excel file and manually exclude the accounts from there.
If you wish to save the current customization settings of the report you've just pulled up, you can have QuickBooks to memorize it. You can refer to this article for the steps: Memorize reports. It also contains information on how you can send it by email on a recurring schedule.
Please let me know if you have other concerns. I'm just around to help.
Quickbooks (Plus) has the filters, but doesn't work to exclude transactions from a specific bank account
In addition you can use the class per transaction and the apply the filter on class
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here