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

Reconciliation discrepancy after voiding bill payment

We use bill pay online to pay our vendors. When we send a check the funds are immediately withdrawn from our account. The bill is marked as paid and the payment is reconciled on the bank account reconciliation. A check that we sent out was never cashed and it was past the 90 days of being able to be cashed so billpay automatically voided the payment and returned the funds to our bank account. But, voiding the bill payment has caused a reconciliation discrepancy because the already reconciled payment was deleted. How do I account for returned payments/voiding bill payments and not messing up my bank reconciliations?

 

Thanks! 

1 Comment 1
MaryLandT
Moderator

Reconciliation discrepancy after voiding bill payment

Hi there, stephredford,

 

I'm here to help get this moving in the right direction towards fixing the reconciliation discrepancy.

 

You can undo the previous reconciliation since you've already voided the bill payment. This is to help ensure your books are accurate.

 

Here's how:

  1. Go to the Gear icon at the right top.
  2. Select Reconcile under Tools.
    reconcileaccount.PNG
  3. On the Reconcile an account page, select History by account.
    historybyaccount.PNG
  4. Choose the reconciled Account and Report period to locate the account you want to undo.
  5. Choose Undo under the Action column.
    undoreconciliation1.PNG
  6. Click Yes.
    undoreconciliation2.PNG
  7. In the final confirmation window, pick Undo and OK.

If the Undo option isn't available, that means you don't have the accountant version of QuickBooks. You need to manually unreconcile those transactions. 

 

Let me show you how:

  1. Go back to the Gear icon.
  2. Pick Chart of Accounts under Your Company.
  3. Locate the appropriate account for the transaction and select View Register under Action.
    viewregister.PNG
  4. Identify the transaction to edit.
  5. In the reconcile status column (indicated by a check mark), repeatedly click the top line of the transaction to change the status. This shows the “R”  status.
    reconciledstatus.PNG
  6. Click Save.

After that, you can then start reconciling them again. Feel free to use this article for the detailed steps: How to Reconcile an Account in QuickBooks Online.

 

Upon sharing the solution above, I still suggest consulting with an accountant. He/She might have specific instructions on how to properly handle the discrepancies.

 

I've also added this link: Resolve reconciliation differences for the expert tips on how to get the difference to zero when reconciling an account in QuickBooks.

 

Let me know if you need any other help along the way, and I always have your back.

Need to get in touch?

Contact us