← Support Home

Import from Quickbooks

This help note explains the steps to migrating or converting your data from Quickbooks Online (QBO) to Saasu. For simplicity Saasu always recommends migrating from other systems at a changeover date rather than bringing in all your old data. If however you want to create a Saasu file that has everything in one place and allows you to forget your old system then you can bring in a lot of your historical transactions also.

Prior Preparation

  1. Make sure your old accounts are reconciled and up to date
  2. Get a Trial Balance from Quickbooks (as at your changeover date). In Quickbooks go to Reports > Accounting > run the Trial Balance

NOTE: If your Quicken/Intuit product doesn't provide CSV (spreadsheet) export files and data but instead provides their own QIF or IIF formats then you will need to find a converter online to change your data. Search Google for "QIF to CSV converters" or "IIF to CSV converters". If this is problematic we recommend not importing historical data and converting at an accounting period or year end instead.

Import Chart of Accounts

  1. In Quickbooks Online go to Reports > search Account Listing > click Excel.
  2. Go into your Saasu file and navigate to View > Import or Export. Click Accounts in the Import other Data section.
  3. Select Spreadsheet (CSV) from the first drop down.
  4. Click Choose File and browse for the Spreadsheet (CSV) file you wish to upload.
  5. Click the Import button.

When you complete importing the Chart of Accounts check that the Saasu list has every account you need by ticking it off against the Quickbooks Trial balance report list of accounts.

QBO has a detail type and this column can be ignored while importing.

For more information about importing the Chart of Accounts, see this help note.

Import Customers and Suppliers

Quickbooks has both a Customer Contact List and a Supplier Contact list. You will need to export both of these lists to have your customers and suppliers in the single Saasu Contact list. To export the Customer list go to:

  1. In the left panel, click Reports.
  2. Type Customer Contact List in the search box.
  3. Click the Customize button located in the upper right-hand corner.
  4. Under Rows/Columns, click the Change Columns link.
  5. Put a check mar in each of the fields that you want to export.
  6. Click Run Report.
  7. Click the Export icon next to print.

To export the Supplier/Vendor list go to:

  1. In the left panel, click Reports.
  2. Type Vendor Contact List in the search box.
  3. Click the Customize button located in the upper right-hand corner.
  4. Under Rows/Columns, click the Change Columns link.
  5. Put a check mar in each of the fields that you want to export.
  6. Click Run Report.
  7. Click the Export icon next to print.

Once you have the exported files from Quickbooks and are ready to import your conta, you can use these steps to import the data into Saasu.

  1. Open exported file in a spreadsheet program and rearrange the columns to match Saasu's format (including changing the header names). Learn more about Saasu's Contact CSV format.
  2. Go into your Saasu file and navigate to View > Import or Export. Click Contacts in the Import other Data section.
  3. Select Spreadsheet (CSV) from the first drop down.
  4. Click Choose File and browse for the Spreadsheet (CSV) file you wish to upload.
  5. Click the Import button.

Do the above steps for both the Customer Contact List and Vendor Contact List.

We always recommend doing a test import of 3-4 contacts prior to importing a large list. Also we recommend importing a maximum of 500 contacts at a time.

Duplicates handling

If you are importing a CSV that has a contact that already exists in your Saasu file, we will either 'Skip' importing that contact or 'Overwrite' that contact based on your selection.

Skip- if we find any matches on the below criteria we will stop importing that contact.

Overwrite- if we find any matches on the below criteria we will import the contact and overwrite the existing contact with any details in the import. Note, this will remove any details for a field if the import has a blank field!

De-duplication rules

The system will check for duplicate contacts based on the following fields:

Inventory Items

Note: Before this step, refer to Importing Items for hints on how to fill in some of the fields.

  1. In Quickbooks go to the gear icon in the top right of the page > click on product and services option > click on the export icon to export the CSV file > Save the file on your computer.
  2. Add the first 3 or 4 items from your Quickbooks CSV to Saasu manually via Items > Items > Add.
  3. Once these items have been added select Export on the Items page and save the template to your computer.
  4. The items you had added will assist in understanding how the remaining items need to be entered into your spreadsheet.
  5. Enter the remaining Inventory Items from your Quickbooks CSV into the relevant columns on the Saasu exported CSV.
  6. We recommend to first import only a few additional Items to ensure you are happy with the process. In Saasu select Items > Items > Import.
  7. Once happy, continue adding your remaining items and import the spreadsheet once complete.

Note that:

Open Transactions

Both sale and purchase invoices can be imported via spreadsheet or if you only have a few transactions you can key them in (just as they were keyed into your old system). Please note that we suggest to import only open (unpaid) transactions. We do not recommend bringing in historical paid transactions prior to your changeover date. This is because data from multiple financial years can be tricky to line up between systems, as well as the inability to mark invoices as ‘paid’ during importing. In case you do want to import historical paid transactions, we suggest you contact our Accounting Partners to assist you with this.

  1. In Quickbooks Export your Open Transactions.
  2. Create a dummy Sale (or Purchase depending on which you are working on) in Saasu by selecting Sales > Add. Once you have created and saved the Sale or Purchase select Export: Summary and Details (CSV) and save this template to your computer.
  3. Copy your transaction details from your Quickbooks export to the Saasu export, following the style set by your dummy transaction.
  4. Begin with importing just three or four transactions first by selecting View > Import or Export > Sales or Purchases. Once you have selected what it is you are importing you will need to map your information from your spreadsheet to the relevant fields within Saasu.
  5. Once you are happy with your mapping, save the mapping as something you will remember to be able to use next time so you do not have to setup this up again.
  6. Check the 3 or 4 transactions you have imported to ensure you are happy.
  7. If happy with these transaction continue to fill out your spreadsheet with all of your open transactions from Quickbooks and import these the same way.

Opening Balances

  1. Enter opening balances for Accounts via View > Accounts > Opening Balances. NOTE: Don't enter Accounts payable or accounts receivable balances if you imported or enter any unpaid Sales or Purchases from the old software in the previous step. Add manually any unreconciled items where payments have not yet appeared in your bank statement or credit cards as at the changeover date (you will need this to tick off during bank reconciliation later.
  2. Enter opening balances for Inventory via Items > Items > Opening Balances

Cross check your old reports to Saasu

Run the Trial Balance report in Saasu as at your changeover date and compare it to your old software Trial balances. Allowing for some account names differences, all the account balances should line up.