Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
deycomin
Level 3

Reply to message

Hi @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.  

Need to get in touch?

Contact us