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 nowHi @RenjolynC
Thank you so much for the response. I realize now that my explanation was not clear and I apologize for that. Where I said:
" As such, I downloaded a CSV file from my bank and used CSV2QBO software to convert it. Where i went wrong was I did not enter the opening balance in the software and uploaded the qbo file to my Quickbooks Online account. Now, My "In Quickbooks" balance is correct and spot on with my actual bank balance however my "Bank Balance" in Quickbooks online is incorrect with a difference of the opening balance."
I forgot to advise that I was a QB Desktop user. I subscribed to QB Online and imported my customers (and their balances), Products, Suppliers and Chart of Accounts manually. As such, the Bank account was imported with the chart of accounts with the Opening Balance Equity of $928.05 which is correct. i could not connect my bank at the time as my bank is not listed with Intuit QB Online. This is now where my quote above comes into play. When connecting the bank manually, the CSV I downloaded from my bank got an "Invalid File Format" error. I used software called CSV2QBO to convert the CSV to QBO format which was accepted however, in the conversion to QBO, I forgot to enter the starting Balance of 928.05. Therefore, balances were imported from the QBO file into QB Online without it. Now, my ACTUAL bank account, my "In Quickbooks" and Chart Of Account balance are identical at $1,369.76 which is correct but because there was no opening balance in the import, the Bank Balance in Quickbooks is showing $441.71 which is a difference of $928.05, the opening balance. How do I adjust the Bank Balance to correct the $441.71?
Whew, a bit long but I hope you can help.