cancel
Showing results for 
Search instead for 
Did you mean: 
finance139
Level 2

Reconciliation issue

How do I resolve this? It concerns QuickBooks Online using the Banking feature and Pay Bills Online (Bill.com), then trying to Reconcile after a VOID:

(1) paid a $X bill from a vendor using Pay Bills Online

(2) at end of month I reconciled the checking, which included the $X bill payment because Bill.com takes the $X immediately even before a check is sent to the vendor.

(3) next month I voided the payment (so Bill.com then deposits $X back into the checking account)

(4) now I want to reconcile the next month, but QBO won't allow me to, saying that my beginning balance is off by $X.

(5) If I click on "We can help you fix it," the next window reports "There's a discrepancy because (the transaction) was changed after it was reconciled."  It is true that the original bill payment now shows VOIDED, but the payment IS NOT voided in the checking register, so indeed, the beginning balance is off, and I can't reconcile. 

(6) what do I do here?

4 Comments 4
AlcaeusF
Moderator

Reconciliation issue

Hello @finance139,

 

Thank you for adding a detailed response about the issue. I can help you resolve the reconciliation issue in QuickBooks Online.

 

Since there are changes to the transaction, you can undo the previous reconciliation and void it. Technically, the vendor didn't receive the payment you've processed via Online Bill Pay.

 

Before starting, I recommend creating a backup copy of your company file. This way, you can revert anytime you want to undo the process.

 

Here's how:

 

  1. In QuickBooks, go to the File menu and select Switch to Single-user Mode.
  2. Go to the File menu again and hover over Back up Company. Then select Create Local Backup.
  3. In the window, select Local Backup and then Next1.JPG
  4. In the Local Backup Only section, select Browse and select where you want to save your backup company file.
  5. Set the number of backups you want to keep. This is optional.
  6. This runs a test to make sure your backup file is in good shape before you save.
  7. When you're ready, select OK.
  8. Select Save it now and Next.

 

Once done, you can proceed with using the Undo reconciliation feature. Please follow these steps:

 

  1. Click the Banking tab at the top menu bar.
  2. Hover your cursor to Reconcile.
  3. Select Undo Last Reconciliation.

 

After following the steps above, you can now enter the refund. I suggest using Bank Deposit to enter it back into your bank account. Here's an article with the detailed instructions: Record and make bank deposits in QuickBooks Desktop.

 

For additional reference, you can use the following link to learn more about the reports you can run to show changes to the reconciliation in QuickBooks: Fix issues when you're reconciling in QuickBooks Desktop.

 

Hit me up if you have more questions about reconciling accounts in QBO. I'm always here to lend a hand. Take care always.

finance139
Level 2

Reconciliation issue

Useless reply. Your response is for QB Desktop. I use QB Online Plus. 

finance139
Level 2

Reconciliation issue

Useless reply. You have described a solution for Desktop. As indicated, I use Online (Plus)

Giovann_G
Moderator

Reconciliation issue

Thanks for providing clarification about your product, finance139.

 

I'm here to ensure you'll be able to reconcile your account.

 

In QuickBooks Online, you'll have the option to manually remove the voided transaction on your check register to fix the beginning balance. I'll show you how.

 

  1. Go to Accounting, select Chart of accounts.
  2. Choose the bank account, then click the View register under the Action column.
  3. Select the transaction to expand the view.
  4. In the checkmark column, click the box with the "R" until the box is blank. This removes the transaction from the reconciliation.
  5. Click Save.

 

I've also included this resource for more insights: Undo or remove transactions from reconciliations in QuickBooks Online.

 

For future reference, check out this article so you'll have a guide in reconciling your account: Reconcile an account in QuickBooks Online.

 

Don't hesitate to post your reply if you need further help with the reconciliation. We're always here to assist you.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us