Offer ends in
2020-03-31 09:58:00getting-startedEnglishImport Trial Balance in QuickBooks: “Import data” feature enables you to bring your previous trial balances easily in QuickBooks. to Import Trial Balance in QuickBooks?

How to Import Trial Balance in QuickBooks?

1 min read

Are you struggling to bring your previous financial records in QuickBooks? Are you worrying that your previous trial balances will be lost while switching or migrating to QuickBooks? No, not at all. QuickBooks “Import data” feature enables you to bring your previous trial balances easily in QuickBooks. Learn in this blog how to do it:

  • Log in to QuickBooks
  • Select the “Gear icon” on top right and select “Import data” (see below screenshot) under “Tools”

import trial balance in quickbooks

  • Select ‘Trial Balance’ from the Import data screen. (see screenshot below)

import in quickbooks

  • ‘Import Trial Balances’ window opens up. Go through the checklist and read the instructions first before you import. ‘Download a sample file’ to get an idea on what data can be imported so that you can prepare your previous trial balances data using the same format.quickbooks import
  • The downloaded sample trial balances data looks like this:

import excel in quickbooks

  • Seeing the sample file format and data fields, prepare your previous trial balances data in the same format. Once it is ready, save the file. Click ‘Choose File’ to upload. You will see the file has been uploaded – see the screenshot below. (note: to upload, the file format should be .xls or .csv and it shouldn’t have more than 1000 rows or shouldn’t be more than 2MB).  Click ‘Continue’.quickbooks import
  • ‘Match data fields’ window appears where you match your data field with QuickBooks online data fields. QuickBooks maps the data automatically – fields appear with green tick box next to it shows the mapping is successful. Click continue.

import data in quickbooks

  • In the review data window, mapped data fields are reviewed and error shows in case of the mismatch. See the below screenshot


  • Click on ‘Error’ and you will find the mismatch issue.


  • Now click the dropdown next to ‘Marketing Consultancy services’ and select Expenses -> Advertising / Promotional


  • Now no more error pops up. Click ‘Import 5 records’. A message box will appear if we would like to import 5 records, click Ok.


  • Import is successful and can be seen in the ‘Import summary’ step.


So, why waiting? Import your previous trial balances data today in QuickBooks!

Information may be abridged and therefore incomplete. This document/information does not constitute, and should not be considered a substitute for, legal or financial advice. Each financial situation is different, the advice provided is intended to be general. Please contact your financial or legal advisors for information specific to your situation.

Related Articles

Create Your Chart of Accounts with QuickBooks

The Chart of Accounts is a list representing all the accounts and…

Read more