Question

QuickBooks-Lightspeed Integration Support

Forum|Forum|5 years ago
March 3, 2021
1 reply
6 views

Hello everyone,

I am using Lightspeed POS since October 2020. I connected Lightspeed Accounting to QuickBooks international a few months ago with the free trial. The trial ended a while back and I finally got a QB subscription.

My questions are:

- How often is data from Lightspeed Accounting transferred over to QB?

- Can I ask QuickBooks to synchronize my data going back to when I first started using Lightspeed bacj in October 2020?

Kind rgds

NewUser2021

QuickBooks Online

MarsStephanieL

Level 6

Great to see you in the Community, @NewUser2021.

Of course! You can integrate your Lightspeed Accounting application to QuickBooks Online. However, you'll need an active subscription from the app so that we can synchronize the data with QuickBooks.

After you've resubscribed in Lightspeed Accounting, you can follow the steps below to successfully integrate the app:

Log in to QuickBooks Online.
Select the Apps menu and enter "Lightspeed Accounting" in the search box.
Click on the Learn more button, then follow the on-screen instruction to sync the data from Lightspeed Accounting to QuickBooks. I've included some screenshots for your additional reference:

You may consider checking this resource page to know more about the features you can use in QuickBooks Online: Get started with QuickBooks.

I'll be here if you have other questions. Feel free to let me know in the comment section. Enjoy the rest of your day!

N

NewUser2021-

Hi @MarsStephanieL,

Thank you for replying. I have a couple more questions for you.

1 - I have a multi-location Lightspeed account. The central warehouse transfers inventory to the other locations, which are standalone businesses. The warehouse then issues invoices to each location based on those inventory movements. QuickBooks Plus subscription says I can track inventory and support told me I can issue invoices based on inventory movements. How do I set this up? Is it possible to synchronize my product catalogue and inventory movements from Lightspeed POS to QuickBooks? How can I do this? So far, sales information is synchronized in QuickBooks but I don't see any inventory movement information.

2 - Can I synchronize client & supplier information from Lightspeed POS to QuickBooks or do I have to do all this manually via csv files?

3 - Lastly, when a new product is created in Lightspeed, does it get automatically added into QuickBooks? If a product's information is modified in Lightspeed, does that get automatically modified in QuickBooks?

Thank you for taking the time to read this message.

Kind regards

NewUser2021

C

CharleneMaeF

QuickBooks Team

@MarsStephanieL

Thank you for all this information.

Where in QuickBooks can I see inventory movements?

Thanks for getting back on this thread, NewUser2021-.

I'm here to help you see your inventory movements in QuickBooks Online.

To do this, let's run the Physical Inventory Worksheet report. Then, customize it to show the details of all the movements for one inventory item only.

Here's how:

Go to the Reports menu.
Type in Physical Inventory Worksheet in the search field, then click to open.
Click the Customize button.
Enter the correct report period.
Select the Filter arrow.
Choose the specific product under the Product/Service drop-down.
Click Run report.

For further guidance, please see this article: Customize Reports in QuickBooks Online.

Once done pulling up the report, you can memorize it. This way, you'll be able to save its current customized settings.

Additionally, learn how to see your best sellers, what’s on hand, the cost of goods, and more by checking this article: Use Reports To See your Sales and Inventory Status.

I'll be glad to help you again if you have more questions about inventory and running reports. I suggest tagging my name to get back to you as soon as possible.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded