Hi. How can we help?

Manually exporting Retail POS (R-Series) data into QuickBooks

Lightspeed Accounting offers an automated and seamless integration of your Retail POS data with the below accounting system:

  • QuickBooks Online
  • QuickBooks Desktop (2014 or later)
  • Xero
  • Exact Online
  • Sage Cloud Accounting

Alternatively, you can manually export your Retail POS data and import it into QuickBooks if you're using a compatible version of QuickBooks Desktop (QuickBooks Desktop 2014-2018 for Windows, QuickBooks Desktop 2013-2018 for Mac).

Due to changes in the file format used in QuickBooks Desktop 2019, a workaround is required to successfully import the iif files Lightspeed exports. Lightspeed Accounting is compatible with QuickBooks Desktop 2019.

QuickBooks 2013 and later for Mac require a workaround to import data correctly. In Retail POS, go to Reports > QuickBooks Settings & Options and set the Extra field under Sales Tax to "N/A", then Save.

Exporting data from Retail POS

  1. In Retail POS, go to Reports > QuickBooks Settings & Options.
  2. Select the data Retail POS exports to your accounting software by going to Retail POS settings for manual exports into QuickBooks.
  3. If you have a QuickBooks account, check that the accounts match. This prevents a new account from being created in your QuickBooks when you import your file.
  4. At the top of the screen, click the Exports button.
  5. If this is your first time exporting, on the top right, click the green New QuickBooks Export button.
  6. From the Dates section in the Start Export On, End Import On, and Shop fields, select your date range and shop.
  7. Click the Generate All Export Data button.
  8. From the menu on the left, review the data included in each section.
  9. If data is included in the Errors section, contact Support for assistance.
  10. From the Export section, select the Export Verified checkbox.
  11. Click Export QuickBooks Data and save the .iif file to your desktop or downloads folder.
  12. Import your .iif file into your QuickBooks.

Importing into QuickBooks Desktop 2019

Due to changes made to the file format used, importing your .iif file into QuickBooks Desktop 2019 will require additional steps.

When you attempt to import the .iif, you will encounter the following pop-up:

Select Import it for me. I'll fix it later. Depending on the data contained in the .iif file, you may then get a warning for each General Journal Entry in the file.

Click Yes for each warning displayed.

Once all of the General Journal Entries have been approved, QuickBooks Desktop 2019 will import the data.

Was this article helpful?

1 out of 1 found this helpful