Can you run P&L report for only one bank account?

Greetings paulajc,

You can customize your Profit and Loss (P&L) report, then filter it by Distribution Account. Currently, there isn't an option for us to filter it by bank accounts.

However, you can open a bank account quick report. Let me show you how:

1. Click Accounting.
2. Go to the Chart of Accounts tab.
3. Click the View register drop-down arrow, then choose Run report.

You can check this article on how to customize the P&L report: Customize your Profit and Loss report.

I'm still here if you have other concerns though, just leave a comment below.

This must be for QB Online.

Hey everyone! I've been reading through this thread and would like to share a solution you can use to filter the Profit and Loss report.  Just to clarify, @Kristine Mae is correct. QuickBooks Online does not have a way to filter your Profit and Loss report by bank account directly. That report is driven by income and expense accounts, not by Balance Sheet accounts (which bank accounts fall under).

However, you can use the Location tracking feature to provide essentially the same information. To do so, you must first have Location tracking turned on.

Once this is enabled, you can set up a location for each bank account, and assign one of the location/bank accounts to each transaction you enter, then filter your Profit and Loss report by the location assigned to each bank account.

How to enable Location Tracking:

Before you can set up locations for your bank accounts, you must turn on the Location tracking feature.

Note: The Location tracking feature is available only in QuickBooks Online Plus.

To turn on Location tracking:

1. Select Settings ⚙️.
2. Select Account and Settings.
3. Select Advanced Search.
4. In the Categories section, select Edit ✎ to open the fields.
5. Select the Track Locations checkbox.
6. Select Save.
7. Select Done.

Once Location tracking is turned on, you can set up a location for each of your bank accounts.

Set up locations for bank accounts

1. Select Settings ⚙️.
2. Under Lists, choose All Lists.
3. On the Lists screen, select Locations.
4. Select New.
5. In the Location Information dialog, enter the bank account name in the Name field.
6. Select Save and close.

The location is saved with the bank account name. Repeat these steps for each of the bank accounts you want to track.

Assign bank accounts when entering transactions

Once your banks are set up as locations, each time you open an Income or Expense transaction, the Location field appears on the screen, and you can select the appropriate bank account from the field's drop-down list.

While you can assign most transactions to locations, you can’t for payments. Payments are automatically assigned to the location you entered on the invoice when you created it.

In addition, you should edit any existing transactions to assign a bank account in the Location field so that your Profit and Loss by Location report is accurate.

Note: You can't specify locations for transfers.

Run a Profit and Loss by Location report

When you have set up your bank accounts as locations, and assigned a bank account to each of your transactions, you can add a Location column to your Profit and Loss report to create a report that lists each bank account separately.

To run a Profit and Loss by Location report:

1. Go to Reports.
2. Locate and select the Profit and Loss report.
3. In the open Profit and Loss report, select Customize.
4. In the Customize report panel, select the Rows/Columns item to open the section.
5. From the Columns drop-down list, select Locations.
6. Select Run report.

Your Profit and Loss report is now separated by the bank accounts identified with each location.

Let me know if you have additional questions on this! If you would like to submit feedback to our Development team on additional filters for the Profit & Loss report, here's how.  Have a great rest of your day!

Are you still not able to run a P&L in online QB for each bank account?

This is DUMB!  You could always do this with the desktop version!!!  This should be fixed IMMEDIATELY!!!  

Hello there, snipers1968.

We don't want you to have this kind of experience.

Running a profit and loss report for each bank account seems like it would be simpler. That said, I'd recommend sharing feedback with our developers' team. 

Here's how you can send a feature request:

1. Click the Gear icon.
2. Under PROFILE, select Feedback.
3. Enter a description of your feedback.
4. Click Next.

You can track feature requests through the QuickBooks Online Feature Requests website.

As a workaround, you can use the location tracking feature. From there, you can filter the profit and loss report for each bank accounts.

I'll be around whenever you have questions about running reports.

Kumquat isn't an allowed word in Quickbooks... just testing.