cancel
Showing results for 
Search instead for 
Did you mean: 
business30509-gm
Level 1

Is there a way to run a p&l per bank account? I have different properties that each have a bank account. QB online combines all the data for the report vs each property

I have 6 properties and some have different partners.  I would need to be able to run a P&L for each one.
1 Comment 1
Kevin_C
QuickBooks Team

Is there a way to run a p&l per bank account? I have different properties that each have a bank account. QB online combines all the data for the report vs each property

I appreciate you for sharing the details of your concern here in the Community space, @business30509. I understand how important it is to view the data of your profit and loss report by bank account. I'm here to share some information.

 

In QuickBooks Online (QBO), the Profit and Loss report is driven by income and expense accounts, so bank account data will be reflected on the Balance Sheet reports. That said, filtering your Profit and Loss report by bank account is currently unavailable.

 

However, you can use the Track locations feature to create a report that lists each account. This way, you'll be able to allocate each transaction you make to one of those locations/bank accounts.

 

Please know that this functionality is available in the QBO Plus and Advanced versions. To turn it on, go to your company's Accounts and Settings. Choose the Advanced tab, then click the Categories section to select the Track locations checkbox.P&L1.PNG

 

After that, set up a location for your bank account.

 

  1. Go to the Gear icon.
  2. Choose All Lists under the Lists column.
  3. On the Lists screen, select Locations.
  4. Select New.
  5. Enter the bank account name in the Name field.
  6. Select Save.
    P&L2.PNG

 

Once done, you'll have to manually update/edit your transactions and choose the location/bank account from the Location field's drop-down list. P&L3.PNG

 

When completed, you can add a Location column to your Profit and Loss report to view the lists of transactions for your bank account.

 

  1. Go to the Reports menu.
  2. Search the Profit and Loss report in the search box.
  3. Select Customize.
  4. In the Customize report panel, select the Filter drop-down.
  5. Click the box before Location, then select the bank account in the drop-down arrow.
  6. Click Run report.
    P&L4.PNG

 

Please keep in mind that QBO is not designed for multiple books. That's why all of the income and expenses will be combined on the Profit and Loss report.

 

You can also track them by class, refer to this article to learn more about utilizing the class tracking feature: Turn on class tracking in QuickBooks Online.

 

Just in case you want to memorize the report you've customized, feel free to check out this article for the detailed steps and information: Memorize Reports in QuickBooks Online.

 

Let me know if you still have questions or concerns about managing your reports in QBO. We’re always here to help. Have a great day, business30509!

Need to get in touch?

Contact us