There is no direct way to filter your Profit and Loss report by bank account in QuickBooks Online. However, you can get virtually the same information by using location monitoring. Accounts on the balance sheet are referred to as bank accounts. Income and cost accounts guide the Profit and Loss report, but Balance Sheet accounts have no impact. You can create a location for each bank account if location tracking is allowed. 

Each transaction you enter should be assigned to one of those locations/bank accounts. To see each bank account’s profit and loss, filter the Profit and Loss report by region. Each of these measures is demonstrated.

Step 1: Turn on location tracking. 

You must enable the Location tracking function before you can set up locations for your bank accounts. To allow location tracking, follow these steps:

  • Activate the Settings option.
  • Account and Settings should be selected.
  • Choose Advanced.
  • Select Edit to open the fields in the Categories section.
  • Check the box next to Track Locations.
  • Then pick Save, then Done.

Step 2: Create bank account positions

You can assign a location to your bank accounts for tracking purposes once Location tracking is activated.

  • Activate the Settings option.
  • Select All Lists from the Lists menu.
  • Select Locations from the Lists screen.
  • Make a new selection.
  • In the Name field of the Location Information dialogue, type the bank account name.
  • Select the Save option.

Step 3: Assign transactions to their appropriate locations:  When you open an Income or Expense transaction now that your banks are set up, you’ll see a Location field drop-down list. From the list, select the desired spot.

While most transactions can be assigned to a venue, payments cannot. Payments are automatically assigned to the billing address you specified when you made the invoice. Transfer locations cannot be determined.

Step 4: Run a profit and loss report by location: You can add a Location column to your Profit and Loss report to build a report that lists each bank account separately after you’ve set up your bank accounts as locations and allocated a bank account to each of your transactions: 

  • Navigate to Reports.
  • Pick the Profit and Loss report from the drop-down menu.
  • Pick Customise from the transparent Profit and Loss report.
  • Select the Rows/Columns item in the Customize report panel to open the section.
  • Select Locations from the Columns drop-down menu. Pick the mark you added to the field if you used one.
  • Select the option to run the study.

How to run a profit and loss report by a customer in QuickBooks

Without using the Class or Location Tracking functions, you can monitor Profit and Loss by Customer. Only QuickBooks Online Plus users have access to this feature. To begin, go to Account and Settings: Track expenses and items by customer and switch on Track expenses and items.

  • Choose the Gear icon, then Account and Settings, then the Expenses tab.
  • Tick this box if you want to keep track of costs and products by customer.
  • Save and close the window.

Make sure you pick the customer’s name in the transaction when you report the transactions (invoices and expenses). The Customer column is found under Account information for Expense transactions. You may choose the customer’s name from the drop-down arrow at the top of the invoice.

After you’ve completed the transaction recording as mentioned above, you can run the report by following the steps below:

  • The report is the option to choose from.
  • Type Profit and Loss by Customer into the search box.
  • Select Customise, then Filter if you want to select a particular customer.
  • Click the drop-down arrow in the Filter column and select the customer you want to track.
  • Select the option to run the study.

How do I run a profit and loss report t in QuickBooks

Financial reports provide you with a snapshot of your company’s results. There are hundreds of reports available that provide information on various aspects of your market. Some look at revenue, while others look at the expenditures, and still, others look at parts of both. Here’s a quick rundown on how to create simple reports. You can also configure reports to concentrate on particular accounts or filter for specific items if you need more information.

Create simple financial reports

  • Go to the Reports section of the menu.
  • To find reports by name, use the Find report by the name search bar. You can also only look at the list.
  • To open the report, select it.

Note: To apply any changes to the report’s dates or filters, select Run report.


To conclude, QuickBooks Desktop software helps you manage the finances of a particular organisation. This blog is created to understand the role of profit and loss report in QuickBooks Desktop software. After reading this blog about everything related to the profit and loss report in QuickBooks Desktop software, I hope that you do not doubt after reading this blog. 

Share this Link:
Call for Help & Support