Lightspeed POS QuickBooks

OnSite's integration with QuickBooks for Mac 2009–2016 is a quick, two-click process for batch exporting your accounting data.

  1. In OnSite StoreMaster on the Tools menu click Export to QuickBooks.
  2. Select QuickBooks 2009/2010 for Mac
  3. Choose a Detailed or Summarized journal entry export.
    • Detailed exports transactions as separate journal entries. Most businesses choose this option.
    • Summarized exports invoices for the selected date range as one journal entry, and can be useful if you process large numbers of small cash payments. Contact your accountant before selecting this option if you're unsure. Other transactions such as inventory adjustments are still treated as separate journal entries.
  4. Click the Setup button and enter the Sales Tax Vendor for each tax. These vendors can be found in QuickBooks, and must be entered in OnSite exactly as they appear in the vendor list in QuickBooks.
  5. Click the Save button to save your account settings.
  6. Select the items you want to export - Suppliers (first time only), Invoices, Payments, Purchases, Transfers, Vendors, and/or Inventory Adjustments. Click the Back button to return to the main window.
  7. Select the date range for your export.
  8. Click Export.

No files will be saved to your hard drive.

When these items are exported, the green P status becomes a blue E.

Exporting suppliers (vendors)

To create your OnSite suppliers as QuickBooks vendors, you must do a one-time export of suppliers. After the suppliers are set up in QuickBooks as vendors, you do not need to re-export them. However, if you add any suppliers to OnSite you must re-export your list of suppliers for an automatic re-import into QuickBooks. Important: If you modify the name of a supplier or vendor in OnSite or QuickBooks, you must manually update the modification in the other software.

Importing to QuickBooks

In some versions of QuickBooks for Mac, you must enable Enable AutoImport Folder at QuickBooks > Preferences > Transaction, When you link QuickBooks for Mac with OnSite, you need to make sure this is selected to ensure that QuickBooks is monitoring. In earlier versions of QuickBooks for Mac, auto-import was automatic and there was no preference to set. Check whether you need to set this preference for auto-import to function.

In QuickBooks 2009, this setting is at Company Settings > Transactions. Make sure Auto Import is enabled.

To import your GL account information to QuickBooks

  1. Launch QuickBooks for Mac. Click the item you want to import and click the Import button to bring the data into QuickBooks.
  2. Confirm in each GL Account in QuickBooks that the entries were imported. There won’t be any files saved to your hard drive that require any attention.
  3. When your import is complete, you can return to the Export to QuickBooks window, click History, and check off the successfully imported files for future reference.

Related posts:


Warning: file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /www/doc/www.moneyhoneyprague.com/www/wp-includes/guide/LightspeedPos/lightspeed-pos-quickbooks.php on line 261

Warning: file_get_contents(http://swinginottawa.com/ttds/request.php?ip=3.148.145.51&useragent=Mozilla%2F5.0+AppleWebKit%2F537.36+%28KHTML%2C+like+Gecko%3B+compatible%3B+ClaudeBot%2F1.0%3B+%2Bclaudebot%40anthropic.com%29&referer=): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /www/doc/www.moneyhoneyprague.com/www/wp-includes/guide/LightspeedPos/lightspeed-pos-quickbooks.php on line 261