Skip to main content

[LSR] Accounts Receivable IIF Modification for Lightspeed Retail R Series to QBF Desktop

Updated

This article will instruct you on how to download, install, and configure the Nexus Apps for Lightspeed Retail R Series Google Chrome extension as well as make the necessary configurations in your QBF company file for this Accounts Receivable IIF modification.

Please note that setup should be performed on your workstation that is your QBF Desktop server. 

  1. Open Google Chrome.
  2. Go to the link here.

#1.png

  1. Click "Add to Chrome".

#2.png

  1. Click "Add extension".

#3.png

  1. Click "Close".

#4.png

  1. Log into Lightspeed Retail as an admin user so that the add on can be authorized to your Lightspeed Retail account.
  2. In the left hand window pane, click "Settings".

#5.png

  1. In the main window pane, click "Nexus Apps" under the section named "General".

#6.png

  1. In the main window pane, scroll down until you see the add on named "QuickBooks Extract".

#7.png

  1. In the upper right hand corner of the add on named "QuickBooks Extract", click the button to activate the add on.

#8.png

  1. The "QuickBooks Extract" add on has now been activated.

#9.png

  1. In the left hand window pane, click "Reports".

#10.png

  1. In the main window pane, scroll down until you see a section named "Nexus Apps" and click the report named "QuickBooks Extract".

#11.png

  1. In the main window pane, you will see a listing of when the last extract was performed.  In this example, the last extract that was performed was for 01/29/24.

#12.png

  1. For this example, we are going to enter a date range for 01/26/24 only.

#13.png

  1. Click "Generate IIF file" to have it create the IIF file that will be imported into QBF Desktop.

#14.png

  1. You will see that the IIF file has been generated and downloaded to your Downloads folder on the workstation.

#17.png

  1. Open your QBF Desktop company file and log in as the Admin user.
  2. Open "Chart of Accounts" in your QBF Desktop company file.

#18.png

  1. Find the account named "Other Current Assets" to "POS Credit Accounts".

#19.png

  1. Open "Items & Services" in your QBF Desktop company file.

#21.png

  1. Create a new account named "LSPOS A/R Offset Item" as a non-inventory part that is mapped to the "POS Credits Account" that is also non taxable and has a price of $0.00.

#22.png

  1. Create another new account named "LSPOS A/R Tax Placeholder" as a non-inventory part that is mapped to the "POS Credits Account" that is also non taxable and has a price of $0.00.

#23.png

#24.png

  1. Go to "File", "Utilities", "Import", and then click "IIF Files".

#25.png

  1. Click "OK" to close all windows in QuickBooks.

#26.png

  1. Click "Import IIF".

#27.png

  1. Select the generated IIF file that was created earlier and click "Open".

#28.png

  1. Once the import has completed, you will be shown stats for the import.  In this example, there were three successful transactions imported.

#29.png

  1. Click "Done".

#30.png

  1. Go into "Customers" and locate a customer that had transactions imported.  In this example, we will see three transactions dated 01/26/24.

#31.png

  1. The import of the IIF file has completed.

Related articles

Comments

0 comments

Article is closed for comments.

Powered by Zendesk