cancel
Showing results for 
Search instead for 
Did you mean: 
sam95
Level 1

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

 
5 Comments
Steve_C
QuickBooks Team

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

Hi sam95. Thanks for reaching out to the community. To only show transactions that have already cleared, just switch to a Cash accounting type on your profit and loss. To do so just follow these quick instructions:

  1. Click the Cash radial button at the top.
  2. Then press Run Report.

cash report.png

 

After that, only transactions which your customers have paid to you and cleared the bank will appear. If you want to learn more about cash vs accrual accounting check out these articles:

Let me know if you run into anything else, I'll be happy to help. Have a great day. 

sam95
Level 1

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

Steve,

 

I've tried doing cash but that doesn't match my transactions that cleared. For example, a check that we wrote at the end of June didn't clear until July, but when I run the P & L for July on cash basis that check from June still shows in June. What I am doing incorrectly? 

Steve_C
QuickBooks Team

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

Hi sam95. Unfortunately, it's not possible at the moment to run a profit/loss with a cleared only filter. If you would like to run a report showing only the cleared transactions, you could run a bank QuickReport. Here's an article on running a report of cleared checks. If you have any more questions I'll be here. Enjoy the rest of your day. 

sam95
Level 1

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

Steve,

 

I'm highly disappointed because your second statement is completely different than your first. Why would you tell me the P & L would only show cleared transactions and then retract it later? Very confused and highly disappointed.

 

Nonetheless, I ran a report with cleared transaction. Is there a way within that report to show which chart of accounts the transaction is matched to? I'm talking about if office supplies was account number 123, can I show that account number?

Steve_C
QuickBooks Team

Is there a way to run a profit and loss report that shows only the transaction that have cleared the bank?

Hi sam95. Thanks for the reply. I do apologize for the misunderstanding. To answer your question though, whichever account is selected whenever you run the report is the account all the checks being displayed are associated with. If you would like to see the category associated with the transactions, you can simply click on the transaction from within the report.

 

Unfortunately, there's no customization available at the moment to have the associated categories displayed on the report directly. I'm going to put some feedback to our developers though about your desire for such a feature. If there's anything else I can do just let me know. 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us