cancel
Showing results for 
Search instead for 
Did you mean: 
babam
Level 1

How to exclude certain bank accounts from PnL

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:

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

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

 

Thanks in advance.

6 Comments 6
Rustler
Level 15

How to exclude certain bank accounts from PnL

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.

ShiellaGraceA
QuickBooks Team

How to exclude certain bank accounts from PnL

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.

ljclay
Level 1

How to exclude certain bank accounts from PnL

Hello:

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

Rea_M
Moderator

How to exclude certain bank accounts from PnL

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.

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

I've attached screenshots below to show you the first to fifth steps.

2 Upgrade QBO.PNG3.PNG4.PNG

 

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.

  1. Go to the Reports menu.
  2. Type Profit in the search box, then select Profit and Loss.
  3. Set the Report period, then click the Run report button.
  4. 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.

plus_version_user
Level 1

How to exclude certain bank accounts from PnL

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

plus_version_user
Level 1

How to exclude certain bank accounts from PnL

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

Need to get in touch?

Contact us