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

Reconciliation

I use paper checks so don't use the write checks option.  My issue is, during each month, I have a vendor that I write multiple checks to.  When paying the bills QB puts those checks together for that vendor and then when I go to reconcile, they are all together as well, but, not all of the checks are cleared.  How do I get these separated so I can clear the ones that need to be and leave the others that haven't cleared the bank yet?

4 Comments 4
BettyJaneB
QuickBooks Team

Reconciliation

Hi there, @Samagee.

 

Let me share some insights regarding reconciling your accounts in QuickBooks Desktop.

 

When reconciling accounts in QuickBooks Desktop, make sure you enter all transactions for the bank statement period you plan to reconcile. If there are transactions that haven't cleared your bank yet and aren't on your statement, you'll need to wait for them to be entered.

 

That said, you may proceed with the reconciliation once it has been cleared since we're unable to separate them. 

 

To give you more details about the reconciliation process in QuickBooks Desktop, together with fixing its common issues, please see these resources:

In addition, you may consider ensuring that the date of the checks that you'll be going to create on your future transactions be cleared before the reconciliation date.

 

Let me know in the comments below if you have other concerns about managing your vendors' transactions or with QuickBooks. I'm just around to help. Take care always.

Samagee
Level 1

Reconciliation

Thank you for your response. So, how I  understanding this, or how I see it would work on my end, is leaving the uncleared checks "unpaid" so they don't show up in my reconciliation list, but, then they will not show up as uncleared checks on my monthly report, which is not ideal either.

RCV
QuickBooks Team
QuickBooks Team

Reconciliation

Thanks for coming back, Samagee.

 

We'll need to wait for them to be entered if there are transactions that haven't cleared on your bank yet and with your statement. The paid and unpaid checks will show in the Checks and Payments section when reconciling. With that said, we can proceed with the reconciliation once it has been cleared since we're unable to separate them. 

 

If you need to see the uncleared checks on your monthly report, we can run the Transaction List by Vendor report. Then, customize the report to show the paid status of the transaction. Here's how:

  1. Click Reports on the top menu.
  2. Choose Vendors and Payables.
  3. Select Transaction List by Vendor
  4. Tick Customize Report.
  5. Tap Filters.
  6. Enter Paid Status n the search Filter field. Then, choose Either, Closed or Open.
  7. Enter Transaction Type in the Search field. Select Checks and Payments by clicking the Multiple Transaction Types option. 
  8. Press OK.

To learn more about customizing reports, see the Customize reports in the QuickBooks Desktop article. Feel free to visit our Reconciliation page for more insights about reconciling your bank account with QuickBooks.

 

Please update us on the result of this troubleshooting in the comment below. I'd like to ensure this is resolved for you. You have a good one.

btks
Level 5

Reconciliation

Are you using the "enter bills" function?

Need to get in touch?

Contact us