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

electronic checks and reconciliation

I have an electronic check (bill pay) issued from my bank to a vendor.  It was on my bank statement and reconciled.  The vendor never received the e-check.  I issued a paper check and the bank returned the funds.  However, I cannot delete the bill pay since it was reconciled already  and the new check has also been reconciled and now the vendor shows a credit balance.  How to I resolve this in my books?

 

3 Comments 3
Tori B
QuickBooks Team

electronic checks and reconciliation

Hey there, @Ime20.

 

Thank you for reaching out to the Community. 

 

I recommend deleting the check from the register and undoing the last reconciliation. Then going back and re-reconcile the account. Before completing the steps listed below, I also recommend reaching out to your accountant to ensure this is the best way to resolve your books. 

 

To delete the check:

 

1. Open the Check register for that account. 

2. Locate the check, and right-click it. 

3. Choose Delete check from the list. Then hit OK on the message. 

 

To undo the last reconciliation: 

 

1. Open the Banking menu. 

2. Choose Reconcile.

3. Click Undo Last Reconciliation

 

 

4. Select Continue on the next screen, then OK.

 

Please let me know if you have further questions. I'll be here to help you every step of the way. You can always reach back out to the Community or me for help.  Have a good one. 

 

lme20
Level 1

electronic checks and reconciliation

I wanted to avoid doing this since the first bill pay was in August. We wrote a check when the vendor contacted us regarding payment in Nov. and the bank returned the funds in Dec..  I do not want to undo reconciliations that far.

any other possible solutions?

 

MirriamM
Moderator

electronic checks and reconciliation

Welcome back, lme20. Thanks for the additional details. I want to ensure this gets resolve for you. 

 

To isolate the issue, I recommend checking the account used when creating the check payment. It should be under Accounts Payable (AP/) since the credit offsets the payment made.

 

However, if the period of the books is closed, I recommend consulting an accountant on how to handle this. This is to maintain the accuracy of the record of your account. 

 

Additionally, I'm adding some articles below about reconciliation, which you may find helpful:

You can always get back to me if you have any other questions, just leave a comment below. I'd be happy to further assist you. Have a great day. 

Need to get in touch?

Contact us