Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Quick Books Desktop Profit Loss Customization

Is there a way to run a profit and loss report but not include transactions from a particular bank account?

 

Client has multiple bank account for different functions and would like a report to either include or exclude specific ones.

 

Any help is greatly appreciated.

 

Thanks

 

3 Comments
Moderator

Quick Books Desktop Profit Loss Customization

Glad to have you here in the Community, garyocfp.

 

Helping you customize your Profit & Loss report in QuickBooks Desktop is my priority. Let's get started.

 

You can customize and filter it to which accounts you want to show on your report. Below are the steps to complete the process.

 

  1. On the Profit & Loss report screen, click Customize Report.
  2. Go the Filters tab and select Account.
  3. Click the drop-down arrow and choose Multiple accounts...
  4. Select the necessary accounts to show on the report and hit OK.
  5. Click OK again.
  6. This will refresh the report showing only the accounts selected.

For your reference in customizing a report in the future, you can go through this article: Customize reports in QuickBooks Desktop.

 

If there's anything else I can help you with, please let me know. I'll zip right back to help you out. Keep safe and have a good one!

Level 1

Quick Books Desktop Profit Loss Customization

I have done this and it still includes transactions for an expense that was paid out of a non-selected bank account.

????

 

Example:

 

Checking 1 paid an advertising expense.

Checking 2 paid an advertising expense.

 

When I filter to only use Checking1, the profit/loss report STILL includes all transactions for "advertising expense"  

and I can't un-select "advertising expense", because then I won't get either of the transactions.

 

Still need help.

Thanks

 

QuickBooks Team

Quick Books Desktop Profit Loss Customization

Thanks for going through the steps above, @garyocfp.

 

You'll want to select the particular bank account and transaction type to show in your Profit and Loss report. This way, only the transactions for that account will be generated in the report. Let me show you how.

 

In your QuickBooks Desktop (QBDT)

  1. Go to the Reports menu.
  2. Select Company & Financial.
  3. And choose Profit and Loss Detail report.
  4. Click Customize Report.
  5. Go the Filters tab and select Account, click the drop-down arrow and choose the necessary account.
  6. Then, select Transaction Type from the Filter tab, click the drop-down arrow and select the specific transaction.
  7. Then simply click OK.

You can also refer to this article for more detailed steps: Customize reports in QuickBooks Desktop

 

It's also a great idea to memorize the report to save its current settings.

 

I'm always here if you need more help. Have a great day! 

Need to get in touch?

Contact us