Hi, I'm new to QBO since January 2021. I'm trying to reconcile my Cheque Bank Account. My opening balance has been downloaded from my bank feeds. My deposit and payment amounts match my bank statement but my balance is wrong. My bank account is an overdraft amount but doesn't show up as a negative amount. I've checked all the transactions against my bank statement and they are correct so I think the error may lay with the opening balance.
As an example let's say my overdraft is $60 and I have used $40 of the overdraft leaving me with -$20 as opening balance on bank statement but it shows $40 as opening balance in quickbooks. The difference in reconciling is $38. Like I said before my deposits and withdrawals are all correct.
Hope that makes sense
Solved! Go to Solution.
Thank you for choosing QuickBooks as your partner in growing your business, REN9.
I'll make sure that you can reconcile your accounts.
If you connect your bank and credit card accounts, the program will automatically download your past transactions up to a certain date. Then, totals them up and enters the opening balance and date for you.
Since your opening balance in QuickBooks didn't match your bank statement, you can open your bank register and correct the amount. I'll show you how:
Once done, you can now start reconciling your accounts again. Additionally, here are some articles that you can read to help resolve common reconciliation errors and mistakes:
Drop me a comment below if you need more help in handling your bank accounts and transactions. The Community is always here to back you up.
Thanks for getting back to this thread, @REN9.
Changing the amount in the Opening Balance Equity account to negative isn't allowed in the program. This is the reason why you're getting an error message "You must specify a transaction amount that is 0 or greater."
For more details, please check out this article: How the beginning balance is calculated.
Additionally, you can reach out to your accountant for further guidance on tracing the discrepancy in your account. If you don't have one, you can click this link here to find a pro advisor:https://quickbooks.intuit.com/find-an-accountant/
Let me know how else I can help you with QuickBooks by adding a comment below. I'm more than happy to lend a helping hand. Keep safe!
Thanks for the quick response, @REN9.
I'm here to help you confirm your opening balance in your QuickBooks Online (QBO).
Yes, your opening balance is correct. And there's no need to worry about your balances in QBO because you're in the right track. For more details, check out this article: Fix issues the first time you reconcile an account in QuickBooks Online. Directly go to Step 2.
Since your QBO balance matches your real-life bank balances, then you're good to go in reconciling the account.
After that, I'd suggest running the Reconciliation Report to review the beginning, ending balances, and other data.
You can also print and export the report, so you can it outside QBO. For more information, visit this article: How do I view, print, or export a reconciliation report?
For your forthcoming guidance, please hit these pages below about the adding account number on your chart of accounts and other related topics.
The Community and I will be around to help if you need anything else. Keep safe.