Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Dear Quickbooks community,
I am in the painstaking process of recreating the last 4 years of my company's records.
Since the bank records where too old to download electronically, a lot of it had to be input manually by creating cvs. Files.
I have finally finished inputting 3 different bank accounts for the last 4 years.
It is time to reconcile and I don’t know how to do it. All my accounts say my beginning balance is $0.00.
Also, do I reconcile month by month, or can I do it by year?
I would really appreciate any help and a step by step on how to do it.
Thank you.
I've got your back, Newproject.
Reconciling accounts in QuickBooks Online is my specialty, so let me help you determine how to handle this and ensure your records are up to date.
I'm happy to know that you've already added the transactions and I appreciate your effort in doing so. The next move you need to do is to reconcile them on a month-by-month basis, starting from the oldest bank statement.
Doing this will ensure that your balance, both opening and ending, for each month will be accurate. However, since your accounts are saying that your beginning balance is zero ($0.00), we can recreate it via a Journal Entry using the correct date and amount you want to see.
To recreate the opening balance:
To set up the reconciliation:
To reconcile the account:
For additional information about the best practices when doing a year-end reconciliation and the steps on how to do it, I'd recommend following these articles:
I also recommend getting in touch with an accounting professional for more expert advice. Every organization is unique and they can make suggestions on how to handle this. Our Intuit Find-A-ProAdvisor site allows you to find certified professionals in your area that have the answers you're looking for.
With this information, you'll be a reconciliation master before you know it! Please know I'm always available here for all of your questions and concerns. Thanks for reaching out, wishing you and your business continued success.
If you've never reconciled bank account in QuickBooks, for the 1st bank reconciliation, the "Beginning Balance" should show zero. That's how it works. Just enter the bank statement "Ending balance" and "Ending date", and start reconciling. Select all cleared transactions, the difference amount should be zero. Click "Finish Now" button once you see zero $ difference.
To make it easier to reconcile, you can do month by month (or for the full fiscal year if not many transactions).
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here