How to correct opening balance: 9/19/22 bank transfer from savings to new account (unmatched). Owner added new account with opening balance @ 10/30/22 (amounts differ).

Thanks for dropping by the Community, @JJCDC. I've got the steps to help you fix the discrepancy in your opening balance in QuickBooks Online (QBO).

Since the owner already recorded an opening balance for the new account, we can locate and make edits to match the amount transferred from the business savings. 

Here's how:

1. Go to Settings ⚙ and select Chart of accounts.
2. Locate the account and select View register.
   
3. Find and select the opening balance entry.
4. Make the necessary changes to the date and then the amount. If you cannot edit the amount directly on this screen, you can edit it by clicking the Edit button.
   
5. Select Save. 

For more details about this process, visit this article: Enter and manage opening balances in QuickBooks Online.

If you're good with your transactions, you can now proceed to reconcile an account in QBO. If everything matches, you know your accounts are balanced and accurate. We recommend reconciling your checking, savings, and credit card accounts every month.

Please keep us updated on how it goes, or if you have other questions about editing the opening balance, don't hesitate to reach back out. I'll be here to lend a hand. Keep safe!

Thank you Kevin for the quick response and information. I understand now how to correct the date and amount in the new bank account register.

There is still an unmatched "record transfer" transaction in the business savings account, which is the money that funded the new bank account register. So, I wasn't sure what to do with this since I still need to reflect this transaction.

Thanks again for your help.

Great to know that my colleague’s suggestions above helped you, @JJCDC. I’d be glad to help you match the bank transfer and share additional information about correcting your opening balance.

If you’re still on the For review page, you can exclude the transaction and follow the steps outlined by @Kevin_C above. This way, you won’t have duplicate or double amount recorded on your balance.

However, we can edit the opening balance amount to zero (0) if you want to add the bank transfer to the new account. From there, you can adjust the amount to match them.

You can refer to this article to learn more about the importance of opening balance: Enter and manage opening balances in QuickBooks Online.

I’ve included this reference that will guide you with keeping your financial records accurate effectively: Reconcile an account in QuickBooks Online. This will help you review and ensure that QuickBooks entries matches with your bank account statement.

I'm ready to help you out again if you'd like me to clarify other things regarding the reconciliation process. If you happen to come across any difficulties while recording your entries, let me know and I'll gladly assist you.

Thanks JamaicaA. My apologies, but I'm still a bit confused. If I change the date and amount in the new account bank register, and then exclude the transaction in the other account that funded the new account, the amount transferred won't deduct from the account and the balance is wrong. So I'm not sure if I should unreconcile the entry in the new account and delete it, and then add/match the transfer transaction, which notes account transferred to vs. "Open Balance Equity"? I added a screen shot of each item. Thank you.

Thank you for getting back on this thread and sharing additional details with your concern, @JJCDC. I'll chime in and ensure you'll be able to sort this out.

As my peer suggested above, we can edit the opening balance manually. You won't need to record the transfer to the original bank. Thus, this will cause duplicates in your transactions.

To reflect the transfer to the original bank, you'll want to create an expense transaction without a Payee to have a record of the transfer from one account to the other. This way, you won't need to unreconcile the entry and delete it. I'd be glad to guide you on how:

1. Click + New and choose Expense.
2. From the Payee field, leave this field empty.
3. In the Payment account field, select the account you used to pay for the expense.
4. From the Payment date field, enter the date for the expense.
5. In the Payment method field, select how you paid for the expense.
6. In the Tags field, enter the preferred label to categorize your money.
7. Go to the Category details section and enter the expense info. In the Category dropdown, select the expense account you use to track expense transactions. Then enter a description.
8. Enter the Amount and Tax.
9. Once done, select Save and close.

You can also read this article for more information on the procedure: Enter and manage expenses in QuickBooks Online.

Also, here's a handy resource to help you if you want to record billable expenses in the future: Enter billable expenses.

Please let me know if you have further questions about your banking transactions. Please let me know. I'd be delighted to work with you again. Keep safe!