cancel
Showing results for 
Search instead for 
Did you mean: 
ShyMae
QuickBooks Team

Fixing uncleared transaction from 4 years ago

Hi there, fiveftclub.

To ensure I provide you with the most accurate information, I'd like to ask if you're using the QuickBooks Online or Desktop version.

Additionally, what steps did you follow, and if possible could you please provide me a screenshot? With the additional context, I'll be able to explore potential solutions to address your concerns.

Please let me know through the reply button. I'd be more than happy to assist you. I appreciate your cooperation. 

fiveftclub
Level 1

Fixing uncleared transaction from 4 years ago

I got an email asking for more information and it says to reply in email but when I did I got the mailer demon.  I was asked how I am accessing QB and what steps I took.  Here is the response.

 

Yes, QB Desktop it is older version (2012).  I followed this:
1.  Route to the Banking menu and select Reconcile.
2.  In your bank account select the transactions you want to reconcile.
3.  In the field Date of Statement, typed in the date for an "off-cycle reconciliation". The date is between your last reconciliation and the next scheduled one. (Did not state mini reconciliation).
4.  Typed in the balance of your last successful reconciliation in the Ending Balance field. Click Continue.
5.  Check off the transactions you are fixing ad re-reconciling in the Reconcile window.
6.  The Difference field must show $0.00. (the difference is not zero it's 156.88)
Rasa-LilaM
QuickBooks Team

Fixing uncleared transaction from 4 years ago

Thank you for returning to the Community, fiveftclub.

 

Maintaining accurate financial records for your transactions is essential for balancing your books and getting your business ready for the next year. Allow me to assist you in finding the right support to resolve the discrepancy in your account.

 

In cases like this one, we'll have to access your account and check for the following: 
 

  • Someone undid the last reconciliation.
  • Someone changed or deleted the reconciled transactions.
  • Cleared transactions were unchecked (uncleared) in the account register.
  • Funds were transferred from a previously reconciled bank account to a sub-account.
  • Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (US only).
  • The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.

 

Considering that there remains a discrepancy of $156.88 even after conducting a mini-reconciliation, I suggest reaching out to our Technical Support Team for a thorough investigation into this matter. They have the necessary tools to identify the root cause of the issue and will assist you in implementing a permanent solution.

 

Here's to get the contact details: 

 

  1. Open your QuickBooks and head to the Help menu at the top to select QuickBooks Desktop Help.
  2. This action will take you to the Have a question? window.
  3. Choose Contact Us and give a brief description of your issue.
  4. Click the Continue button and log in to your Intuit account.
  5. *If you don't already have an account, make sure to Create a new account.
  6. From there, select Continue and then Continue with my account.
  7. We'll email you a single-use code and input the number.
  8. *If you have more than one account, select the one you want to use and Continue.
  9. Press the Continue button and choose to chat with us or Have us call you.

I've gathered a few links that offer solutions to help you find discrepancies from your previous reconciliation and address any opening balance issues you may have. Browse through these articles for the complete details:

I understand the importance of staying on track with your year-end filings and tax form processing. That's why we have curated a series of articles to provide you with guidance and support throughout the entire process:

Should you have any additional concerns or questions about clearing the entries in your reconciliation or handling discrepancies, leave a comment below. I'm here to provide further assistance and will respond as soon as possible, fiveftclub. Wishing you a wonderful day! 

Karl ValleyMission
Level 1

Fixing uncleared transaction from 4 years ago

Did NOT work. The uncleared transactions, which have all been reconciled previously, are all expenses that go back to 2021!

The bank account balance we know is correct, but why do some of these random charges reappear? This happesn also in my other personal business account. Anytime I try to 'correct' it, it throws my reconciliation off.

PLEASE HELP!!!!

juliea9
Level 1

Fixing uncleared transaction from 4 years ago

I would ask your accountant for help - you will likely need to do journal entries to clear the old transactions. Thats what I had to do. 

ChristieAnn
QuickBooks Team

Fixing uncleared transaction from 4 years ago

Hello there, Karl.

 

I understand that things have been challenging for you with the random charges reappearing after they have been reconciled. I can also see how important it is to have accurate reconciliation data on your end. I've got steps to ensure you can view this correctly and route you to the right team to assist you further on this matter.

 

As mentioned above, there may be times when entries like expenses you already reconciled show up as unreconciled or reappear on the Reconciliation page. Below may be a few reasons for this:

 

  • Someone undid the last reconciliation.
  • Someone changed or deleted the reconciled transactions.
  • Cleared transactions were unchecked (uncleared) in the account register.
  • Funds were transferred from a previously reconciled bank account to a sub-account.
  • Company file conversions can cause issues (from QuickBooks for Mac to Windows or QuickBooks Online to Desktop) (US only).
  • The transactions were never reconciled in the company file. This might be because the file was restored from a backup, which can overwrite data and reconciliations.

 

To fix this, you can perform a special reconciliation, also sometimes called a "mini reconciliation". This method uses an "off-cycle" reconciliation date to make a correction. Beforehand, you have to run and customize a report so you can review your reconciliation data. This allows you to see which entries are shown unreconciled in the program.

 

Then, here's how to fix transactions in a bank account.

 

  1. Go to the Banking menu at the top and choose Reconcile.
  2. Select the bank account with the transactions you need to reconcile.
  3. From the Date of Statement field, enter the date for an "off-cycle reconciliation." This date can be any date between your last reconciliation and the next scheduled one.
  4. In the Ending Balance field, enter the balance of your last successful reconciliation. Then click Continue.
  5. From the Reconcile window, check off the entries you are fixing and re-reconciling.
  6. Make sure the Difference field shows $0.00. Then, select Reconcile Now when everything looks good.

 

For additional information, you can refer to this article: Reconcile previously deleted and re-entered checking or credit card transactions.

 

If the problem persists, I recommend clicking this article to see what else can be done to fix the issue: Fix issues when you're reconciling in QuickBooks Desktop.

 

In case the problem continues to occur, I suggest contacting our QuickBooks Desktop Support Team. They have the tools to pull up your account details in a secure environment and the best ones to talk to regarding the next steps you need to take to fix the issue.

 

Lastly, you can read this article if you need more guidelines to help you fix any reconciliation issues that you might encounter: Learn the reconcile workflow in QuickBooks.

 

Feel free to post here in the Community if you have any concerns about reconciling your accounts in QuickBooks. I want to make sure you're taken care of, and I'm here to help you anytime, Karl. Take care always.

fiveftclub
Level 1

Fixing uncleared transaction from 4 years ago

4 months later and no reply or update from Support?  The previously advised fixes does not work.  I still have transactions that were already cleared showing up as needing to be reconciled again.  While I can just ignore them have the long list of transactions hanging around is becoming a nuisance.

MsNorthPND18
QuickBooks Team

Fixing uncleared transaction from 4 years ago

I understand that it's been four months since you've gotten any updates from our QuickBooks Support team. @fiveftclub. With concerning your transactions.

 

Since it's been four months, I suggest contacting our Support Team to get updates from our QuickBooks Support Team. You will get an update through email once the resolution is rolled out.

 

 Our working hours are from Monday to Friday, 6 AM to 6 PM, and Saturdays from 6 AM to 3 PM PST. You can reach us all at once that suits you best. 

 

In addition, you can check this article to learn what to do if your accounts and how to fix the beginning balance issue in QuickBooks Desktop: 

 

 

If you have further inquiries about the updates of your transactions, just add comments below. I'll be here for you.

 

 

 

 

Cath Pearson
Level 1

Fixing uncleared transaction from 4 years ago

Hi 

Did you find a solution fiveftclub?

Like you I'm on QB online, have previously cleared transactions that were keep popping up in each reconciliation. I've also tried the solutions suggested in this thread with no success

 

Thanks!

jtjyogi
Level 2

Fixing uncleared transaction from 4 years ago

I hope this helps anyone experiencing issues with uncleared balances. This may also resolve discrepancies between the QuickBooks balance and the bank feed balance for your accounts. I discovered this fix in an unconventional way. Please bear with me as I explain the steps to my discovery.

After reconciling all my accounts, I noticed that the QuickBooks balance was significantly different from the bank balance. This was alarming, so I started searching online for answers. Unfortunately, there was no straightforward solution. I pieced together information from various sources and attempted to resolve the discrepancies, but it was a dead end. Finally, I considered the transactions themselves and how the automatic pairing and suggestions functionality worked.

In my case, there was a transfer between two accounts. QuickBooks Online pairs transactions based on similarities, such as date, amount, and type of transaction downloaded from the bank feeds. Like many users, I confirmed the transfer in one account and then confirmed the same transfer in the other account. This is where the trouble begins. Confirming in both accounts creates WHAT APPEARS TO BE duplicate transactions in each register. What actually happens is that the transaction in your registry will show two line items with the same dollar amount. The one with the “C” is the paired transfer, the one right underneath it that does not have a “C” is the expense that was created when you confirmed the transfer in the other account. Check this out. If you click on the transaction before confirming, you'll see a small print that says, "WHEN YOU CONFIRM, WE'LL RECORD THIS TRANSFER GOING IN AND OUT, SO YOU'LL SEE THE IMPACT IN BOTH BANK ACCOUNTS." This can cause issues if you confirm the transfer in both accounts.

Through trial and error, I found the solution:

  1. If you have transactions downloaded from your bank feed that are transfers between accounts and are paired by QuickBooks, confirm only one of the transfers. QuickBooks will automatically record it for the other account.
  2. Then, go to the other account and find the paired transfer. You'll see it categorized as an expense. If you click to confirm it, QuickBooks will record it as an expense, creating a duplicate entry. This discrepancy affects your QuickBooks balance.
  3. To prevent this, click on the transfer and select "Match." A new window will open, hopefully showing the other confirmed transfer. If it is not the right match in terms of date, amount, etc., click "Find another match" and select the correct transfer.
  4. Then go back to each accounts register that the transfer took place and manually mark the item from "C" to "R" if you have previously reconciled the transaction.  I would recommend not doing a bunch of these all at once because some have different dates. It would be best you do process these one at a time.

Refreshing your page helps QuickBooks update so that you can see any changes that took effect.

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

Need to get in touch?

Contact us