Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
posted
I appreciate you sharing this in the Community forum, @sconsltd. To successfully import your chart of accounts with opening balances into QuickBooks Online, make sure your Excel file includes an opening balance column and that the dates are precisely formatted as YYYY-MM-DD to avoid import errors.
- In your Excel file, right-click on the column where you want to add the opening balance, select Insert column to the left, and name this column Opening Balance.
- Next, right-click on the created column, choose Format Format, then click the More Format tab. Enter the date format as yyyy-mm-dd.
- Click OK.
Regarding your concern about step 4, the process outlined suggests that after completing the import of the chart of accounts, you will need to manually enter the opening balances within QuickBooks Online. However, if you have already included the opening balance amounts along with the corresponding dates directly in your Excel spreadsheet before importing, there is actually no need to enter those balances manually afterward. The system should recognize and import the opening balances from your properly formatted Excel file, making the additional manual entry unnecessary and saving you significant time, especially if you are working with a large number of accounts.
Remember, setting up your accounting system correctly from the start is crucial for accurate reporting and smooth day-to-day operations. I’m here to provide whatever support you need. Please reach out anytime if you have questions or need further guidance. Take care!
