cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Kbarb44
Level 1

Old check showing open balance

When I go to vendor report it shows me that an old check has an open balance. It was paid and written through QB and shows in the check register. However I did a bill payment today for the same amount through enter bills and then pay bills and assigned it to the bank. (The only reason I did it this way was bc it’s a memorized transaction) The issue with the current “check”(it’s ach) is that it’s not showing up in the check register. I attempted to go fix in unapplied vendor pmts and nothing pops up for the vendor. So my question is : is QB mistaken the old transaction as open instead of the current one? Do I void the bill pmt of the “check” and just enter it directly into the check register bc it’s an ACH and put it to the vendor? I’m going absolutely insane thinking about it I haven’t stopped.

1 REPLY 1
Clark_B
QuickBooks Team

Old check showing open balance

I appreciate all your efforts in dealing with this, @Kbarb44.

 

Let me help you record your old check that shows an open balance in QuickBooks Desktop (QBDT).

 

To properly record your old check, you'll have to delete your created bill payment first. To do so, follow the steps below:

 

  1. Go to the Reports menu and select Vendors & Payables.
  2. Select the Vendor Balance Summary.
  3. Locate the vendor of your created Bill Payment and double-click the amount of the bill payment.
  4. Select the Delete menu.

 

Afterward, you'll have to connect the previous check to the bill payment. This involves using the check as a payment method by modifying the check and recording it in the Accounts Payable account, while also associating it with the correct vendor.

 

To edit the check, here's how:

 

  1. Go to the Vendor Balance Summary report and locate your old check.
  2. Double-click the transaction and enter Accounts Payable in the Account section.
  3. In the Customer: Job section, select the correct vendor.
  4. Review it and select Save and Close.

 

After that, redo the process of creating the bill payment and select the Set Credits so that the check will be used as payment. To do this, follow the steps below:

 

  1. Go to the Vendors menu and select Enter Bills.
  2. Enter the appropriate amount and select the correct vendor.
  3. Fill in the other necessary information.
  4. Review it and select Save and Close.

 

Then, pay the bills by setting the check as payment. Here's how:

 

  1. Go to the Vendors menu and select Pay Bills.
  2. Locate the open check and the newly created Bill.
  3. Check mark the two transactions and select Set Credits.
  4. Check the Credits and click Done.
  5. Select Pay Selected Bills.

 

Once done, review your Vendor Balance Summary report to ensure that the old check does not display an open balance.

 

I'll add this article to guide you to customize any report that you generate: Customize reports

 

If you have any concerns about resolving the old check that shows an open balance, please tag me in the comment section, @Kbarb44. I'll assist you in any way possible.

Need to get in touch?

Contact us