Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowI currently use Quicken and have for 30+years. At the same time, I use QBO in a limited way meaning that I currently ONLY use it to generate invoices and get paid on those invoices from my customers. Needless to say, my bank account that's tied to those payments shows an amount equal to all those payments. Beginning in 2026 I'd like to stop using Quicken and begin using QBO instead. How do I reset the bank account to zero (or whatever the opening balance is on January 1, 2026)? Is the best thing for me to do is a mock reconcile to bring me to whatever opening balance I need it to be?
It's wonderful to hear about your plans to transition fully to QuickBooks Online (QBO) in 2026, Stephanie.
To reset your bank account balance or set a specific opening balance in QBO on January 1, 2026, creating a journal entry would help this situation. This method directly adjusts your account balances without requiring additional transactions or reconciliations.
To make sure your opening balance for 2026 is accurate, review your December 31, 2025, bank statement to confirm the actual ending balance. Once done, follow these steps to create a journal entry:
On the other hand, a mock reconciliation isn’t needed because reconciliation is used to match existing transactions in QBO to those on your actual bank statement. Since setting a new opening balance doesn’t involve any existing transactions, there’s nothing to match or reconcile.
If you’re unsure about which accounts to use in your journal entry or you need further assistance, I highly recommend consulting an accountant or QuickBooks ProAdvisor. They can guide you through this process and ensure your books are set up perfectly.
You're always welcome to visit this forum if you have other concerns about this process.
There's no need to start fresh. If you run a balance sheet right now, you should have a balance in your bank account and Accounts Receivable (A/R), assuming you have outstanding invoices. You should also have a corresponding amount divided between Net Income (equity) and Retained Earnings (equity), assuming you have been using QBO before 2025. On 1-1-26, run a balance sheet as of 12-31-25. Then, create a journal entry that reduces your bank account to the beginning balance on 1-1-26 and also reduces Retained Earnings by a corresponding amount. The journal entry will look like this:
| Debit | Credit | |
| Retained Earnings | XXX | |
| Bank Account | XXX |
After the journal entry, on your balance sheet, your bank balance should match your 12-31-25 ending balance (also your 1-1-2 beginning balance), your A/R should be unchanged, and Retained Earnings should be equal to the total of your bank balance and A/R.
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