Skip to main content
J
JaeCee
December 3, 2022
Question

??? How do I remove the duplicate expense AND reconcile back to zero

  • December 3, 2022
  • 1 reply
  • 0 views

New to Quckbooks and know just enough to be dangerous!

 

So, we enter all of our payroll expenses under 2022 Payroll as a vendor....the health insurance expense in question was included within the payroll/vendor section but - and honestly I am not even sure where I went wrong after so many feable attempts to fix!!!! All AFTER RECONCILING! - I am not sure whether or not I justed clicked ADD when the transaction came in instead of match OR I also had entered the expenses under Anthem vendor instead of 2022 Payroll vendor. Regardless, after the "fix" I was off on my reconciliation for 10/31/22 by that amount...so in my infinite wisdom I added the duplicate expense back in and it is showing reconciled.

 

??? How do I remove the duplicate expense AND reconcile back to zero...thank you in advance for your guidance. Also, does anyone have best suggestions for my obtaining consulting for the next six months. I am going to access all of the free training but, when instances arise like this it would be nice to have someone to consult with.

1 reply

J
JonpriL
December 6, 2022

Hi there, @JaeCee.

 

Transactions already reconciled will show the reconciliation status under the Checkmark column, Will have to remove its status and delete the duplicate so you can reconcile them back to zero. I'll show you how to review and change it.

 

  1. Go to Accounting.
  2. Select Chart of Accounts.
  3. Find the bank account where you're working with the reconciliation.
  4. Under Action, select View register.
  5. Make the expense transaction where looking for is listed and remove R under the Checkmark column and replace it with C or leave it blank.
  6. Click Save.

 

Once done, you can go ahead and delete every duplicate already identified by clicking the Delete icon. One thing is also to make sure the date of the expense in question is on or before the statement ending date entered upon starting your current reconciliation session.

 

Kindly read this article to learn more about fixing problems of transactions before closing a reconciliation session: Fix Issues at the End of a Reconciliation in QuickBooks Online.

 

However, if you're still unsure of how to proceed with the reconciliation, I recommend contacting your accountant for guidance. They can also provide the best practices to follow to ensure the accuracy of your accounting books.

 

You can use whit link if you haven't found someone to work with: QuickBooks Certified ProAdvisor.

 

I'm adding this reference that'll guide you anytime you need help while doing or fixing a reconciliation: The Reconcile Workflow in QuickBooks. You may also review reports to get the data of your past reconciliations: How to View, Print, or Export Reconciliation Report?

 

If you've got questions other than working with your transaction reconciliation, please let me know in the comments. Use the Reply button below and include my name, @JonpriL, so that I can continue assisting you. Take care always!

    Terms & ConditionsAccessibility statement