Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi There-
I have a client who wants to transition to QBO, but also has data in excel from before their Desktop file started. Can we/should we enter these balances from before the start of this QuickBooks file? If so, when, how, etc.?
Thanks in advance for your support!
Thanks for checking in with us, edb12685.
QuickBooks uses your chart of accounts to organize all your accounting. The opening balance is the starting point for the account you create in your account and it summarizes all past transactions in your real-life account up to the opening balance date. In QBO, we can only upload a spreadsheet to import your accounts and skip manual entry in QuickBooks Online (QBO). From there, you can enter your opening balances for the bank, credit card, and other accounts as stated in Step 5 in the article provided.
You can also enter the old balances as journal entry transactions. However, it would be best to contact your accountant on what posting accounts you'll need to apply. You'll want to check our Intuit Marketplace and look for a third party application that might help you transfer your old balances data to QBO.
To learn more about migrating your Desktop file to QBO, check out these articles:
I'd like to know how you get on after trying the steps, as I want to ensure this is resolved for you. Feel free to reply to this post and I'll get back to you. You have a good one.
I would recommend to enter any old data into your QB Desktop file prior migrating to QB Online.
https:// quickbooks.grsm.io/US
https:// quickbooks.grsm.io/us-promo
You should remove any unused List data in QB Desktop file. You are only able to hide the List data in QB Online. You may also utilize an importer tool to speed up your works.
https:// transactionpro.grsm.io/qbd
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