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

QB beginning balance doesn't match bank statement

I'm a QB newbie :) I deleted a cleared deposit from September.  I realized what I did and entered the deposit again.  Now that I'm ready to reconcile this month, my beginning balance is off that exact amount and doesn't match my bank statement. I looked up how to "fix the discrepancy", it says to go in and re-enter any transactions that were deleted, changed, etc.  Well, I did that right away on the same day I deleted the transaction.  Please help!

Solved
Best answer December 10, 2018

Best Answers
Highlighted
Anonymous
Not applicable

QB beginning balance doesn't match bank statement

Your beginning balance is the sum of your cleared transactions.  If you delete one, then it changes.

That's OK, though, as long as you enter the correct ending balance and then check off the replacement transaction as you reconcile.  Then the ending reconciled balance will be correct, assuming all other things on the statement match.

View solution in original post

10 Comments 10
Highlighted
Anonymous
Not applicable

QB beginning balance doesn't match bank statement

Your beginning balance is the sum of your cleared transactions.  If you delete one, then it changes.

That's OK, though, as long as you enter the correct ending balance and then check off the replacement transaction as you reconcile.  Then the ending reconciled balance will be correct, assuming all other things on the statement match.

View solution in original post

Highlighted
Level 1

QB beginning balance doesn't match bank statement

That worked!  Thank you for your help!!
Highlighted
Level 1

QB beginning balance doesn't match bank statement

Will my beginning balance next month be correct or will I always have to change it?
Highlighted
Anonymous
Not applicable

QB beginning balance doesn't match bank statement

The only reason you should ever have to change it is if you reconcile and then you edit or change any reconciled transactions.  If you don't so that, then the ending balance this reconcile will always be the beginning balance on the next reconcile.
Highlighted
Level 1

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. 

Highlighted
QuickBooks Team

QB beginning balance doesn't match bank statement

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. 

 

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

Highlighted
Level 2

QB beginning balance doesn't match bank statement

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?

Highlighted
Moderator

QB beginning balance doesn't match bank statement

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. 

Highlighted
Level 2

QB beginning balance doesn't match bank statement

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

Highlighted
Moderator

QB beginning balance doesn't match bank statement

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. 

Need to get in touch?

Contact us