Lightspeed does not integrate with Xero.
Be warned, Xero does not natively integrate with Lightspeed. Lightspeed use a third party called Shogo, rebranded as Lightspeed Accounting, to extract the data from their crappy API, and then Shogo "integrates" with Xero. "Integrates" is being kind. It "integrates" in about the same way north as North Korea integrates with South Korea. It's totally inadequate; feature poor, impressively difficult to set up, not customisable, then buggy and unreliable. All the things you want in your accounts, right? Certainly do not pay extra for it - the only reason we use it is because there is no way to extract invoice numbers from purchase orders in Lightspeed. Why would you want invoice numbers, a tax requirement in every country that has a tax system, easily searched?? (which you cannot in Lightspeed or "Lightspeed Accounting" aka Shogo).
Integration is bad
Lightspeed is good on its own, but the integration with Xero is garbage. It works just more than 50% of the time for us, and has not been fixed in YEARS. Lightspeed violates a few basic accounting principles in the way it keeps its data, so pulling data out of Lightspeed requires spreadsheet manipulation. It is the worst software integration I have to work with.
Hi Bryce, I am a bookkeeper and am helping a bicycle shop in QLD Brisbane set up with Lightspeed and Xero. Would you have five minutes to chat and get a general idea how you set up you categories especially with Bicycles and Frames with serial numbers? Many thanks Clare
I am experiencing the same issue with an 'Inventory' type account in Xero not showing up in Shogo/Lightspeed Accounting for mapping with Lighspeed categories. Is this something Xero needs to address from their end? The 'Current Asset' type account may be the workaround for now, but is this likely to get a fix in order to be able to use 'Inventory' type accounts? I am following the Shogo/LSA guide to post separate payment deposit invoices awaiting payment together with an itemized (or summary) invoice with total payments posting to the Xero 'Tracking Transfers' system account clearing a zero balance. Does the use of the 'Tracking Transfers' system account for this pose any potential problem, if Xero were to lock this account for posting in the future as it apparently does with 'Inventory' type accounts? I am still waiting on an answer to these questions from both Xero and Shogo/LSA before proceeding to activate posting to Xero from Shogo/LSA. Hope to hear back!
Hey Bryce are you working with Lightspeed to resolve these issues? Any ETA. Some are critical for a client I have that's considering it.
Update: 10/11/2016 Sally Dean! Shogo have updated exports to Xero to include ref/invoice numbers which make it through to Xero. I have been told that credits or stock returns will be functioning shortly. (these currently don'y come at all). We've been up and running a few weeks now with Lightspeed>Shogo.io> Xero. A few challenges to get the head around so far. 1) Currently a long delay for data to come through to Xero from L/S. 48hrs+ currently. 2) We are unable to post to the 'Inventory' account IN XERO so had to create a new inventory account code classed as a ' CURRENT ASSET' not as "INVENTORY". 3) GST on purchases is not calculated in lightspeed and is sent through to Xero as "other cost'. This is posted to the gst account in Xero and shows as an additional line on purchases In XERO (not in the GST Calculation box at the bottom ) 4) Invoices for goods received, have no way of showing invoice number come thru to Xero (via purchase orders) It is great to have everything cloud base and up and running. Hopefully this is further refined as currently a few holes in the process flow.