How to import sales into QuickBooks online

How To

How do I import sales to QuickBooks Online?

Follow these steps

Step 1: Export the Quickbooks Sales Export.

  Heads up

If you're not sure which variation to choose, consult with your accountant or bookkeeper on the best import to use for your business.

1. Go to Reporting > Report List.
   
2. Select Special > QuickBooks Sales Export.
   
   

   

3. Enter the Date Range into the form.
   
    
4. Choose the Variation: 
   
   Sales - Importing sales may be appropriate when you use GlobalTill with accounts receivable and need visibility into due dates and manage payments within Quickbooks Online.
   
   Sales with Payment Types - Import sales from payments may be appropriate when you operate without A/R activity, or, manage most of your A/R activity within GlobalTill.
   
   
5. Download the QuickBooks Sales Export from GT Reporting.

Step 2: Import the Sales Export into Quickbooks.

  Heads up

This guide was last updated in November 2020 and is subject to change. For the most up to date reference, you should consult the QuickBooks help center here.

1. Login to your QuickBooks Online account.
2. Select the Gear icon in the top right-hand corner.
   
   

   
   
   

3. Select Import Data.
   

   

4. Attach the file you downloaded in Step 1.
5. Check Add New Contacts.
6. Check Add New Products/Services if it is applicable to your setup.
   

   

7. Follow the provided instructions to map your column headings.
   

   
   
   

8. The date format should be YYYY-M-D.
   
   

   
   
   

9. Because the QuickBooks export is without tax, you should select Exclusive of Tax.
   
   

   
   
   

10. Follow the provided instructions to map your tax codes.
    

    

11. Confirm the import details and select Start Import.
    

    

12. The import should start and you should see an importing screen.
    

    

13. Finally, you should see a success message from QuickBooks Online.