Skip to main content
March 5, 2024
Question

Can I create a profit and loss report on 1 bank account?

  • March 5, 2024
  • 2 replies
  • 0 views
Can I create a profit and loss report on 1 bank account?

2 replies

Rainflurry
March 5, 2024

@Danewell 

 

Presumably you're asking because you have multiple bank accounts.  If you're on accrual basis then, no, you can't.  There is no direct correlation between your bank account and your P&L because items of income and expense post to accounts other than your bank account. 

 

If you're on cash basis with multiple bank accounts, there's no report or filter in QBO that I'm aware of that would allow you to do this and, if there was, I'd be leery of it's accuracy.  You need a way to filter by a bank account and only include entries that hit income and expense accounts.  You could try running a 'Transaction Detail by Account' report, click 'Switch to classic view', click 'Customize', and then try filter by bank account and use 'Transaction Type' to include transactions that hit income and expense accounts but, again, I wouldn't have a lot of confidence that it's accurate.      

March 5, 2024

Hello there, Danewell. 

 

Let me share details on how we can pull up the report you require in your QuickBooks Online (QBO) account.

 

First, know that QBO doesn't have a way to filter the Profit and Loss reports by bank account directly. That report is driven by income and expense accounts, not by Balance sheet accounts (which bank accounts fall under).

 

Next, we can create a P&L report in a specific bank account by turning on the location tracking feature. It provides essentially the same information that you need. Once enabled, you can set up a location for each bank account and assign one of the locations or bank accounts to each transaction you enter.

 

Know that, turning on the location account is only available on QuickBooks Online Advanced and QuickBooks Online Plus subscription. If you're subscribed to either of them, here's how you can turn on the location tracking feature:

 

  1. Go to the Gear icon, then select Account and Settings.
  2. Choose Advanced, then click on Categories to edit.
  3. Toggle the button beside Track Location to turn it on.
  4. Use the options in the Location label dropdown list to specify a name for the field in which you select a location.
  5. Once done, select Save.

 

Once you've set up your bank, you can choose which location to allocate the transaction each time you open an Income or Expense transaction. However, payment transactions are automatically assigned to the location provided in the invoice and can't be manually assigned a location.

 

After setting up your bank accounts as locations and assigning your transactions to one, you can run a Profit and Loss by Location report. It'll provide a summary of the income and expenses for the specific bank you want to see. 

 

For further guidance regarding generating the report you need, kindly read this article: Run a Profit and Loss Report by bank account in QuickBooks Online.

 

In addition, you can read this article if you want to know more about personalizing your reports in QBO: Customize reports in QuickBooks Online.

 

I'll be here if you have other concerns with more inquiries in generating a report in QBO. Just leave a comment below, and I'll be sure to answer them any time! Have a great day ahead!

Rainflurry
March 5, 2024

@Irene R @Danewell 

 

"You can create a P&L report and filter it out from the Distribution Account to the specific bank account you want."

 

That doesn't work.  Try it.