cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
info2069
Level 1

can i set up quickbooks online from my accountant previous trial balance?

i am new to quickbooks my accountant just gives me paper set of accounts and i want to start useing icloud accounts i need to put in opening balances please ?
1 Comment 1
CarlSJ
QuickBooks Team

can i set up quickbooks online from my accountant previous trial balance?

Yes, you can enter your accountant's previous trial balance in QuickBooks Online (QBO) as opening balances for your accounts, @info2069. This process is essential for aligning with your past accounting activities. I'd be happy to guide you through the process.

 

Instead of spending time manually entering each account into QBO, you can simplify the process by importing a spreadsheet that contains either your custom accounts or your existing accounts provided by your accountant. This feature allows you to quickly and efficiently upload all relevant account information in one go.

 

Before we import, let's ensure you have the appropriate columns in your spreadsheet:

  • Account Name
  • Type
  • Detail Type
  • Account Number (You can skip this if you don't use the account numbers)

 

Once your set of accounts is ready to import via Excel or CXV file format, we can now proceed with uploading your spreadsheet:

 

  1. Sign in to your QBO account.
  2. Go to the Settings icon, then select Import Data.

    Import-Data.png

  3. Select Chart of Accounts.

    COA-Button.png

  4. Click the Browse button and open the file where you save your set of accounts.
  5. Select Next.

 

When uploading the spreadsheet, take the time to carefully map each of your accounts to their corresponding fields. This step is crucial to ensure that all your data is imported accurately into QBO.

 

For the complete guide on how to import your chart of accounts to QBO, here's an article you can check out: Upload chart of accounts to QBO.

 

Once all your accounts are in QuickBooks, let's now enter the opening balances for these accounts:

 

  1. Go to the Settings icon and select Chart of Accounts.

    COA.png

  2. Find your accounts listed in the trial balance.
  3. Select the Action ▼ dropdown, then select Edit.
  4. In the Opening Balance field, add the balance reflecting from the trial balance. Note: Enter the appropriate balances according to whether they indicate a debit or credit.
  5. Select the date you wish to start tracking finances in the As of field.
  6. Once done, click Save and Close.

 

For more information about managing opening balances, here's an article you can refer: Enter opening balances in QBO.

 

Additionally, it's advisable to collaborate closely with your accountant. Their expertise will provide valuable insights and guidance to ensure a seamless and accurate transition during this setup.

 

As you continue to manage your finances, reconciling your accounts in QBO will be an important step to ensure accuracy and maintain clear records. This process helps confirm that your financial statements match your bank statements, providing a clear picture of your financial health.

 

Setting up QBO with your trial balance is important to keep your financial data accurate and to have a clear starting point for tracking and reporting. If you have questions about entering balances or anything else related to QuickBooks, please leave a comment below. I'm here to help you.