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

Edit Payee After Reconciliation

I'm helping my dad with his QB Online. I was catching up on reconciliations and noticed some of the payee names are incorrect. How do I edit these without messing up the entire reconciliation?

7 Comments 7
Mark_R
QuickBooks Team

Edit Payee After Reconciliation

I'm here to ensure you can edit a payee without messing up the entire reconciliation, @shelbs9109.

 

You can edit the Payee in the register even after it's reconciled. Although it'll give you a warning that it could affect the balance of the account for future reconciliation, you'll want to make sure the transaction keeps an R in the checkbox of the registry to ensure it's still reconciled.

 

Here's how you can proceed with changing a payee to a reconciled transaction:

 

  1. Click Accounting from the left menu, then select Chart of Accounts.
  2. Select the appropriate bank account that was reconciled.
  3. Under the Action column, click View register.1.PNG
  4. Find the transaction and click on it.
  5. Choose the correct Payee from the drop-down.
  6. Hit Save, then click Yes when the reconcile message appears.2.PNG
  7. Make sure that the transaction keeps an R to ensure it's still reconciled.

Most importantly, I recommend checking with your accountant for more guidance. They may add suggestions based on what's more suitable for your business and to your books.

 

Please know that you can visit our Community forum again if you have other questions with QuickBooks Online. I'm always here to help. Have a wonderful day.

shelbs9109
Level 1

Edit Payee After Reconciliation

Thank you so much! So after I do this will I be able to print a new report with the updated payees?

Mark_R
QuickBooks Team

Edit Payee After Reconciliation

Thanks for getting back to us, @shelbs9109.

 

Yes. Once you've made changes to any transactions in QuickBooks, it'll update the reporting data as well. However, if you're trying to run the Reconciliation report, the updated payees won't show since it is a locked report. With that being said, all the data that was reconciled won't change whenever you run the report.

 

You'll want to run a Transaction Detail by Account or any vendor transaction report to see the changes. Here's how:

 

  1. Click Reports from the left menu.
  2. Search for Transactions Detail by Account report.
  3. Choose the Report period from the drop-down.
  4. In the Group by drop-down, select Vendor.
  5. Click Run report.
  6. Then, review the changes and click the Print icon to print the report.1.PNG

I'm adding this article for more details: Run reports in QuickBooks Online.

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day!

hmurri
Level 1

Edit Payee After Reconciliation

QB won't let me edit the payee or choose a new one from a drop down - it is grayed out.

Rose-A
Moderator

Edit Payee After Reconciliation

Hey there, hmurri.

 

If you're attempting to edit the payee through your bank register, make sure to click the Edit button so that we can modify the payee.

 

 

 

Once the transaction is open, edit the payee from there. See the sample screenshot below:

 

Here's an article to know more about what else you can do with your reconciliation report: How do I view, print, or export a reconciliation report?

 

In case you need help customizing your other QuickBooks reports, you visit this article: Customize reports in QuickBooks Online. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use. 

 

You're always welcome to post any concerns you have in this space. I'll be here if you need assistance with QuickBooks or have follow-up questions about reconciliation reports. Have a great day!

luispal
Level 1

Edit Payee After Reconciliation

How do I delete a duplicate entry for a payee after reconciliation? 

JanbonN
QuickBooks Team

Edit Payee After Reconciliation

Thanks for joining the thread, @luispal. I can help you delete a duplicate entry after reconciliation. 

 

Here are the steps:

 

  1. Go to the Gear icon, then choose Chart of accounts.
  2. Find the account that has the reconciled transaction. Then select View register.
  3. Find and click the duplicate transaction to expand the view.
  4. In the checkmark ✔ column, click the box with the until the box is blank. This removes the transaction from the reconciliation.
  5. Select the Delete button.
  6. A warning message will show, click Yes.

 

For more information on resolving and adjusting a reconciliation in QuickBooks, you can check out this comprehensive guide: Learn the reconciliation workflow in QuickBooks.

 

Additionally, you can run a reconciliation report to get a summary of that session.

 

If you need further assistance with deleting duplicate transactions in QBO, feel free to ask in the Community. We're always here to help.

Need to get in touch?

Contact us