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:Open your P&L report.Click Customise.Click on the Filter down-down arrow.Select the Distribution Account checkbox. In the drop-down menu, select the account or accounts you'd like to filter.Click Run report.If I exclude the bank accounts, it still displays all details. Thanks in advance.

B

babam

Question

How to exclude certain bank accounts from PnL

Forum|Forum|7 years ago
January 18, 2019
6 replies
153 views

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:

Open your P&L report.
Click Customise.
Click on the Filter down-down arrow.
Select the Distribution Account checkbox. In the drop-down menu, select the account or accounts you'd like to filter.
Click Run report.

If I exclude the bank accounts, it still displays all details.

Thanks in advance.

QuickBooks Online

Rustler

Level 15

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.

P

plus_version_user

Quickbooks (Plus) has the filters, but doesn't work to exclude transactions from a specific bank account

S

ShiellaGraceA

Level 9

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.

L

ljclay

Hello:

I don't have a filter down arrow. How else can I exclude an account? Thanks!

R

Rea_M

Level 10

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.

Go to the Gear icon.
Select Account and Settings.
Choose Billing & Subscription.
In the QuickBooks Online section, select the Upgrade or Upgrade your plan hyperlink.
Choose the plan you want, and select Upgrade.
Confirm your payment information.
Click Save.

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.

Go to the Reports menu.
Type Profit in the search box, then select Profit and Loss.
Set the Report period, then click the Run report button.
Select the Export icon above the report.

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.

P

plus_version_user

In addition you can use the class per transaction and the apply the filter on class

Sign up

Login with SSO

Let's get you signed in

Login with SSO