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

Opening Balance affected by account changes that didn't affect amounts.

I modified several reconciled entries just to change the account category that the money was assigned to.  I didn't change ANY AMOUNTS, or the reconciliation status.  The next time I tried to reconcile the account, the opening balance is off.  All of the changed accounts are listed and even though I didn't change any of the amounts or reconciliation status, it has deducted the amounts from the opening balance.  The only way to change them to get to the correct opening balance is to UNreconcile them.  I can't do that.  I can't just leave them unreconciled in the bank register.  WHY IS IT CHANGING THE OPENING BALANCE WHEN NONE OF THE AMOUNTS WERE CHANGED??

Solved
Best answer November 12, 2018

Best Answers
Rustler
Level 15

Opening Balance affected by account changes that didn't affect amounts.

I know it makes no sense, I said that in my response.  Its not my software.

 

Two Options to undo a recon in QBO:
1. open the register and double click on the R to remove it, one transaction at a time

2. if you have an accountant who signs in to your QBO account, have him log in and use the accountant tool, undo recon
or
invite yourself as the accountant, create the log in, and log in as the accountant so you can use the accountant tools (use a different email for the invite)

View solution in original post

9 Comments 9
Rustler
Level 15

Opening Balance affected by account changes that didn't affect amounts.

when you changed the transaction, you effectively told QB this is now a  different transaction - I know the amount did not change so that should not be true - but intuit programmers ....

 

so changing the transaction made it un-reconcilled, when it is unreconcilled the ending balance of the old recon changes, that is the same as the new starting balance for the next recon.

 

all you can do is undo the old recon, do it again, do the new one

rebgarn
Level 2

Opening Balance affected by account changes that didn't affect amounts.

But…the transactions are still reconciled in my account register.  I can’t just re-reconcile because they are already reconciled.  When I changed the transaction, it didn’t create a new one, and it didn’t UNreconcile my old one.  It did just what it was supposed to do EXCEPT that it took the amount out of prior reconciliation reports.  What you are saying is that now I need to go and unreconcile the transactions that I changed, and then do a new reconciliation with just those transactions on it.  What a pain.  And what a stupid glitch for a program like this to have!!

Rustler
Level 15

Opening Balance affected by account changes that didn't affect amounts.

I know it makes no sense, I said that in my response.  Its not my software.

 

Two Options to undo a recon in QBO:
1. open the register and double click on the R to remove it, one transaction at a time

2. if you have an accountant who signs in to your QBO account, have him log in and use the accountant tool, undo recon
or
invite yourself as the accountant, create the log in, and log in as the accountant so you can use the accountant tools (use a different email for the invite)

rebgarn
Level 2

Opening Balance affected by account changes that didn't affect amounts.

Thank you, I now have a hundred transactions to unreconcile and rereconcile from the past year.  What a pain.  Thank you for your help!!

JAberle
Level 1

Opening Balance affected by account changes that didn't affect amounts.

I'm having the same trouble, so I invited myself as accountant and undid all my reconciliations, and now my starting balance (from the beginning of the credit card account when it was opened March 2019), with no reconciles, is a negative amount, which is the amount it was saying my beginning balance was off.  The list of changed transactions (which QBO shows you to "Help")  all say that the the amount was changed, but the amounts were NOT changed, and those transactions did not add up to the amount it QB says my balance is off.  Any suggestions??

RenjolynC
QuickBooks Team

Opening Balance affected by account changes that didn't affect amounts.

Hello, JAberle.

 

I'd like to share some steps. Let's make sure to review the Change Type column because this will let you know what has changed.

 

If it shows Amount changed, this means that someone has edited a reconciled transaction or moved it to another account. You can fix it by following these steps:

 

  1. In the Reconciliation Discrepancy Report window, select the transaction to expand the view.
  2. Click the Edit button and adjust the total or change the account as needed.
  3. Click Save and close.

Otherwise, check the instructions for other the Change Type under Step 4: Review any discrepancy reports in this article: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

 

Please let me know if this helps you correct the beginning balance. I'll be around if you have any additional questions. Take care and stay safe.

JAberle1
Level 1

Opening Balance affected by account changes that didn't affect amounts.

QB listed Amount changed in the Change Type Column, but no amount was changed.  Categories were changed and or vendor names were changed or the total was split.  But none of the total amounts were changed.  I went through each transaction.  I tried re-saving some but it did not change the discrepancy.
 
Moreover, the total amount of the balance discrepancy, was not the total of all the transactions listed. But all of the transactions listed said the amount was changed.
 

The columns read across like this:

 
Original Amount       Changed Amount      Difference                Change Type
$50                              $50                                 $50                          Amount Changed
 
That makes no sense.  The difference should show zero.
 
Now that I have undone all of the reconciles for the account, it shows a negative balance - which is the amount of the opening balance discrepancy .
 
This is extremely frustrating.  Looks like I’m not the only one with similar issues.
Ashley H
QuickBooks Team

Opening Balance affected by account changes that didn't affect amounts.

Thanks for the joining this thread, @JAberle1.

 

I want to ensure your reconciliations are correct in QuickBooks Online.

 

Since you unreconciled the previous reports and you're still seeing a discrepancy, I recommend reaching out to the Online Support Team for further assistance. Rest assured, they have the tools to assess your account in a secure environment and get on a screen share with you while performing troubleshooting steps to see what's causing this behavior. Here's how to get in touch:

 

  1. Go to the (?) Help icon at the top-right of the page, then Contact Us.
  2. Type in your question or concern in the description Box then hit Let's Talk.
  3. Choose how you want to get contacted.

 

You'll hear from an agent shortly. Once you get the columns corrected for the discrepancy, then you're beginning balance will adjust so you can start your reconciliation. You can refer to this Community article to learn more about the process: Reconcile an account in QuickBooks Online.

 

I'll be here if you have any other questions or concerns. Take care!

rutapetras
Level 1

Opening Balance affected by account changes that didn't affect amounts.

It solved my problem. Thank you!

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

Need to get in touch?

Contact us