Hi. How can we help?

Setting up Lightspeed Accounting 3.0

Lightspeed Accounting 3.0 is currently available in Australia and the United Kingdom. Some integrations may still be in beta testing and, as a result, not accessible to all users. If you're located in a different region, follow the steps in setting up Lightspeed Accounting 2.0 instead.

To get access to Lightspeed Accounting, contact your Sales Account Manager or Lightspeed Support.

Lightspeed Accounting 3.0 integrates with Xero, QuickBooks Online, and MYOB accounting software to help you reconcile your books so you can focus on running your business. Once the integration is set up, your Back Office sales categories, including tips, revenue, and gift cards, will automatically sync to your chosen software.

Preparing Back Office for Lightspeed Accounting

Before enabling Lightspeed Accounting, verify your Back Office is properly set up by reviewing your accounting groups and payment methods.

  1. Log in to the Back Office with your Lightspeed Restaurant account credentials.
  2. From the navigation menu, select Menu > Accounting groups.
  3. Confirm you’ve added your desired accounting groups, assigned items to their relevant groups, and selected the correct tax profile per group.
  4. From the navigation menu, select Payment > Payment methods.
  5. Confirm that you have added all payment methods accepted by your business to this section.

Enabling Lightspeed Accounting

Enable Lightspeed Accounting via Omniboost to start syncing Lightspeed sales data to your accounting software, such as Xero, QuickBooks Online, or MYOB.

  1. Contact your account manager to request setup for Lightspeed Accounting via Omniboost.
  2. Once your account manager has sent you the onboarding form, follow the instructions to complete the integration configuration.
  3. Wait for contact from Omniboost. Omniboost will generate a test journal for you to review and confirm data accuracy.
  4. If needed, correct any inaccurate data.
  5. Once Omniboost has enabled the automated daily transfer of data, provide Omniboost with your Codat company ID to delete the connection and secure your account.

Updating account mappings and settings

Proper account mapping ensures that your accounting software will accurately reflect the transactions processed on your POS. Lightspeed cannot provide accounting advice on how to map accounts. For guidance, we recommend consulting a certified accountant.

Update your account mappings or settings if your business needs change after initially setting up Lightspeed Accounting.

  1. Log in to the Back Office with your Lightspeed Restaurant account credentials.
  2. From the navigation menu, select Integration Hub > Accounting.
  3. Click the tile for your accounting software.
  4. Click Go to sync settings.Back Office Xero page with Go to sync settings highlighted
  5. In the new tab, make your desired changes to sync settings and account mappings.
  6. Toggle on Sync settings to enable data syncing from Lightspeed Restaurant to your accounting software.
  7. Navigate between the tabs to adjust their settings.
    • Sales: Map your sales accounts by filtering to show only accounts that would appear as income on the profit and loss statement. For gift cards, show liability accounts since a gift card sale does not count as income until it is used. Additionally, enable location tracking, which is useful for syncing multiple business locations to the same accounting software.
    • Fees: Map your fees by filtering to show only accounts that appear as expenses on the profit and loss statement. For taxes, the list of tax profiles is based on those set up for accounting groups, then duplicated according to the percentage. The mapping options are filtered to show only those where the tax is revenue-based and the percentage matches the Lightspeed tax percentage.
    • Payments: Map your payments accounts. For payment accounts, each accounting platform will vary in determining whether payments can be deposited to an account. Sync Flow filters the list using the required logic to present only valid options for depositing payments.
    • Sync schedule: Change the time zone where your business is located. Changing the timezone will affect when syncing takes place, which is midnight local time.
    • Sync history: Visit the Viewing sync history section to learn more.
  8. Click Save changes.

Viewing sync history and correcting sync errors

Check your sync history to see each time Lightspeed Accounting sent data to your accounting software and whether it was successful or generated an error.

  1. Log in to the Back Office with your Lightspeed Restaurant account credentials.
  2. From the navigation menu, select Integration Hub > Accounting.
  3. Click the tile for your accounting software.
  4. Click Go to sync settings.Back Office Xero page with Go to sync settings highlighted
  5. In the new tab, select Sync history.Sync history page with an example of a complete sync highlighted
  6. (Optional) Filter by Status and select a date range to customize which sync jobs will appear. Available statuses include Complete, In progress, and Error.

The Sync history table shows the ID, start time, completion time, and status of each sync job.

Correcting sync errors

Click Go to sync settings next to the sync error to verify your account mapping and update your sync settings. Depending on the error message you’ve received, there will be different troubleshooting steps to take.

  • To start your first sync, go to sync settings and complete the setup: You exited the setup process without finishing it. Click Go to sync settings to finish setting up the integration.
  • The following data aren't mapped to any account-if they're used in a sale, the next sync might fail: The sync was completed, but some accounts aren't mapped, which may impact future syncs. Click Go to sync settings to map your accounts and ensure an error-free sync.
  • Sync failed. Update your sync settings or contact Support: The sync failed for an unknown reason. You can click Go to sync settings to investigate the issue or contact Support for help.

Frequently asked questions

  • The integration currently supports Xero, QuickBooks Online, and MYOB. However, please note that some accounting software integrations may still be in beta testing and, as a result, not accessible to all users.

  • Yes, both grouped and consolidated tax rates are supported.

  • This integration only syncs sales data, such as product categories, transaction receipts, payment methods, and tax rates. On account sales and purchase orders currently do not sync to your accounting software.

  • Yes, you can back sync data up to 90 days in the past during the setup process.

  • You may be able to enter data from on account sales and purchase orders manually. For more information, contact your accounting software’s customer support.

  • Sales data will appear as a manual journal entry in your accounting software.

  • No, the integration only syncs your total sales for the day.

Was this article helpful?

0 out of 0 found this helpful