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

Move your Data into QuickBooks Online Singapore

Screenshot 2021-12-07 144800.png

Moving to QuickBooks Online

Changing the way you manage your business can seem like a big step. By importing your data from Excel, Xero, MYOB and Reckon into QuickBooks in bulk, you can get up and running faster.

 

Review this guide to learn how to import your data into QuickBooks, so that you can find the freedom and flexibility you need to run your business anytime, anywhere.

 

There are two main ways to import your data: 

 

  1. Import your data using a 3rd party

There are several Intuit-approved Apps that will convert your data into QuickBooks Online. This is a great option if you’ve got a lot of data to import and would like it done for you. To find a list of available Apps, more, visit https://app.qbo.intuit.com/app/appcenter/findapps

 

There may be a fee for using a 3rd party App to migrate your data. Many Apps offer free trial periods so you can explore whether they’re right for you.

 

  1. Import your data using Excel CSV files

Video: How to Import Data Using Excel

 

Overview

Importing your data using Excel CSV spreadsheets is a simple way to bulk import your Chart of Accounts, Customers, Suppliers, Products and services, Invoices and Bills into QuickBooks. If you’re moving from another accounting software, first you’ll need to export your lists into Excel. Once your data is in Excel, you’ll need to make sure it’s formatted so that it uploads correctly into QuickBooks. Once your data is formatted, you’re ready to import. This process takes a few minutes per file. Once imported, check that everything looks okay and you’re ready to start using QuickBooks.

You can get instant answers to your questions at any time by clicking the Help icon at the top right corner of your QuickBooks account.

 

But firstly, you might be asking, what is a CSV file? A CSV file is a common file format used for text files that contain tabular data. In CSV files, each field of  text is separated by a comma, semi-colon, or other special character.

XLS/XLSX file: XLS is the file format of  Microsoft Excel 1997-2003. Microsoft Excel 2007 and newer use the XLSX file format. Excel can also handle data in CSV format.

 

Step 1. Export your lists from your current software into Excel. 

In order to move your data into QuickBooks Online, you will first need to export your data from your current software (QuickBooks Desktop, Xero, MYOB etc) into Excel. For detailed instructions on how to do this, visit Move your lists to QuickBooks Online

 

Step 2. Ensure your data is formatted so that it uploads correctly into QuickBooks. 

Once your lists are in Excel, the data needs to be formatted so that it imports correctly into QuickBooks. 

Review these for more background:

  1. Which contact fields are imported from Excel?
  2. Common questions about importing data to QuickBooks 

 

To see how your Excel files should look, download and open these sample Excel files:

 

Step 3. Import your data into QuickBooks.

After you export and save your lists into the correct format in Excel, you’re ready to import them to QuickBooks Online. Go to https://app.qbo.intuit.com/app/importdata to begin. 

To make sure your data imports correctly, import each CSV file in this order. Click on each item for detailed instructions:

  1. Chart of Accounts
  2. Customers
  3. Suppliers
  4. Products and services
  5. Invoices 
  6. Bills 

 

Importing Bank Transactions into QuickBooks Online

Connect your bank to QuickBooks to import your transactions automatically.

If you're unable to connect your bank directly to QuickBooks, you can also import your bank transactions using CSV files

If you receive an error message during this process, this guide may be helpful: Common errors for importing bank transactions using CSV

 

What to do if you get an error message when uploading your data 

Once your data is imported into QuickBooks, you will be able to review it to check that everything looks okay. If you receive an error message, or something doesn’t look right, it’s likely because you have not formatted your Excel CSV file correctly. The following articles may help you: 

 

Some other common errors include: 

 

Errors on items that are already in your company

You may get errors on items that are already in your company. For example, the "Hours" and "Services" items that are created by default. The best thing to do is not to import these items. The rest of your items should still get imported.

 

Errors for non-existent accounts

If importing Products/Services, cancel the import, make sure that those accounts exist, and then try again. To avoid this error, either import your Chart of Accounts first before your Products and Services list. Or if you have just one or two missing accounts, you may want to create them manually after the import.

 

If you’d like more support with migrating your data into QuickBooks, you can get instant answers to your questions, or access instant chat support at any time by clicking the Help icon at the top right corner of your QuickBooks account. 

3 Comments 3
BSL_Ling
Level 3

Move your Data into QuickBooks Online Singapore

Hi,

 

I am starting in QBO as at 1/1/22.  However, I will need to migrate my 31/12/21 balances as follows into QBO.  Is there a detailed guide on how to do this.  Coz not everyone starts new in QBO.

 

1. Opening trial balance as at 31/12/21 

2. Detailed SGD and non SGD AR invoices that have not been paid.  These AR invoices may date prior to 1/1/21

3. Detailed SGD and non SGD AP invoices that have not been paid.  These AP invoices may date prior to 1/1/21

4. Closing bank reconciliation with unpresented deposits/chqs as at 31/12/21

5. Closing inventory balances as at 31/12/21

Rasa-LilaM
QuickBooks Team

Move your Data into QuickBooks Online Singapore

Thank you for joining this thread, BSL_Ling.


It’s my priority that you’ll be able to migrate the data mentioned above into QuickBooks Online (QBO). This is to ensure that all your bank transactions, invoices, bills, and inventory balances are tracked correctly in your company.


The Import function can help you bring data from other software to the online program. Let me share some information on what you can and cannot bring into QuickBooks. 

 

  • You can’t add discounts, credit notes, and negative amounts in general.
  • You can import a maximum of 100 invoices at a time and 1,000 row limit per spreadsheet.
  • You can import invoices with single or multiple line items.
  • You can also import a large volume of customers and suppliers or products and services.


Before importing your invoices, prepare first your spreadsheet and make sure to fill in the following columns:

 

  • Invoice number
  • Customer
  • Invoice date
  • Due date
  • Item amount
  • Item tax code


In case the invoices have multiple line items, make sure each line entry has an invoice number, customer, invoice date, etc. just like in the sample spreadsheet. If you collect taxes, add the tax rate to your invoices in the spreadsheet. When importing, map the tax codes you created into QuickBooks tax codes.


Also, map each of your column headings to the invoice fields during the import. Click here to view our sample file. Then continue performing Steps 2 up to 5 in this article: Import multiple invoices at once.


For your bills, and bank reconciliations, import them via CSV file. While you'll have to use a spreadsheet to bring your products and services.


If you want the complete details for the transactions mentioned to show in your account, utilize a third-party application. All you have to do is go to the Apps menu on the left panel of your company to open the Find Apps screen. Enter a keyword in the search field to speed up the process. From the list of suggested apps, look for the one that meets your needs.


For additional resources, the following article contains answers to frequently asked questions about the import process: Common questions about importing data to QuickBooks Online.

 

Also, this guide will walk you through the steps on how to set up a customer or supplier’s opening balance. You’ll also learn about the accounts impacted when recording the entries: How to enter outstanding balances for customers and suppliers.


Click the Reply button @ BSL_Ling if you have additional concerns recording open balances for your other transactions. Know that I’m always ready to assist further. Have a great weekend.

Fiat Lux - ASIA
Level 15

Move your Data into QuickBooks Online Singapore

@BSL_Ling 

You can utilize an importer tool to migrate any outstanding transactions from 2021.

https://transactionpro.grsm.io/qbo

 

Another option, purchase a 3rd party service to do so.