QB beginning balance doesn't match bank statement

I kind of did something similar, but what I did was accidentally put in the wrong ending balance before reconciling. Now, the system won’t let me correct it and just assumes/Auto maintains that incorrect balance, making my reconciliation out of balance. I tried reversing all the reconciled transactions, but the starting point is still wrong and won’t let me change it. 

Hello there, @QL1.

You can go back to your bank register and manually reconcile your journal entry to correct your beginning balance.

Here's how:

1. Go to Lists, then Chart of Accounts.
2. Double-click the account in question, then open the journal entry.
3. Put a checkmark in the Reconcile column checkmark as reconciled.
4. Tick Yes when prompted. Make sure to see if you already have the correct ending or beginning balance.
5. Then, hit Record. 

Once done, you'll need to create mini-reconciliation to resolve the discrepancy by doing a correction.

1. Click the Banking menu then choose Reconcile.
2. Select the bank account with the transactions you need to reconcile.
3. Enter the date for an "off-cycle reconciliation in the Statement Date section. This date can be any date between your last reconciliation and the next scheduled one.
4. In the Ending Balance field, input the balance of your last successful reconciliation then hit Continue.
5. Check the transactions you wanted to correct and re-reconciling then make sure the difference field shows $0.00.
6. Once done, select Reconcile Now.

Also, if you need further assistance on how to make these corrections, I highly suggest consulting your accountant.

I've got these awesome articles you can use as your reference. 

• Fix issues when you're reconciling in QuickBooks Desktop.
• Fix beginning balance issues in QuickBooks Desktop.

I'll be here in case you have any additional questions about your reconciliation. I will keep an eye out for your response.​

Hello,

I've been banging my head trying to figure out a reconciliation problem.

My account was perfect, I entered January all the way up through present, but then I re-added two transactions trying to figure out a problem with another account, and now I receive the message:

"Your account isn't ready to reconcile yet. Your beginning balance is off by $1,369.20. We can help you fix it."

This amount of $1,369.20 is exactly equal to the two transactions I re-added.

I then looked in my Audit Log and saw these transactions twice, so I deleted one of each of them again.

Still the same message:

"Your account isn't ready to reconcile yet. Your beginning balance is off by $1,369.20. We can help you fix it."

Do you know how I can fix this?

It's nice to see you again, @w3developing.

I'm here to get you moving in the right direction towards reconciling your account. It seems like the product you're using is QuickBooks Online.

Based on the scenario you provided, you may have deleted a transaction that has already been cleared and reconciled. Once you void, modify or delete a previously reconciled transaction, this will create a discrepancy on your beginning balance. 

You'll need to review all the transactions thoroughly. If you accidentally deleted a reconciled transaction, you can manually change its status on the register.

Here's how:

1. Go to the Accounting menu. Then select Chart of Accounts.
2. Find the account and select View register. 
3. Select the transaction you want to reconcile.
4. Review the check column. Select the box and keep clicking it until the box shows R.
5. Select Save. Then close your register.

I'd also suggest reaching out to your accountant for advice to ensure you're on the right track. 

Should you need anything else in the meantime, please don't hesitate to leave a comment below. My door is always open to you. 

Hi Thank you for your feedback. I am looking at getting more accountant help, but in the meantime, just trying to understand things more.

(1) =====================================================

I have two accounts:

Bank

Credit Card

My Bank account is reconciled up to present time with no discrepancies.

The Credit Card account is the one with issues.

You mentioned "checking your banks statements," do you know what records I should check them against in Quickbooks Online? Should I check them all (from Jan 1 - present statement) against Credit Card register or should I check them against Banking records under the "Reviewed" tab? 

Thank you for any additional clarification on which records I should compare to statements.

(2) =====================================================

I pay my Credit Card bill with the Bank funds, both accounts are connected to Quickbooks Online. Each account does create a record, but I normally go into the Credit Card account under Banking, and assign the Transfer to the Bank account. But when I first started this, I might have made some errors.

Thanks for any additional data you can provide on how to best compare or review records to find the error.

Sincerely

Thanks for getting back to us, w3developing.

Since we're using the Banking page to bring your credit card transactions to your QuickBooks register, I'd recommend going to the Reviewed tab. Reviewing your January 1 to present transactions might be a great idea.

From there, you can compare your credit card statement to the ones that were added to your register. You can undo the transactions if necessary: Unmatch or move bank transactions after reviewing them.

After that, you can go to the credit card register, and compare the statement transactions again. You can click the Go to Register hyperlink in the Banking page. This is to ensure that there are no duplicates. In addition, doing this should also answer your second question.

Once you get to the bottom of this, you can already reconcile the account.

We'll be right here to guide you and keep everything aligned.