You created an inventory count with a specific filter, and the product doesn't qualify.You enabled the Track feature after starting your inventory count.You created a product after starting your inventory count.This is the monies put in the Other line in the Vendor Return.Your product could not show up in your inventory count for one of the following reasons: This is the monies put in the Shipping line in the Vendor Return. This is monies put in the Other field in the PO. This is monies put in the Shipping field line in the PO. If not, it will be a lump sum total for each PO. If Inventory is set to show Sub-Accounts, these funds will be separated by Category/Sub-Category. This bill is assigned to be paid to whatever vendor is associated with the PO in your Lightspeed Retail account. This exports PO data (just the items) as a bill to be paid off in QuickBooks, separated by individual PO. Be mindful of how this works for changing the Received date or when partially receiving orders as not understanding the distinction between when the PO is marked as Finished and when it is set as Received can lead to discrepancies in the your QuickBooks account. Keep in mind that this flags the PO for export, but the date it will export on is the PO's Received date. Marked As Finished is when you click the Finished button in the PO.

Ordered From Vendor is the day you click the Ordered button in the PO. Use this only if you're using First in/First Out accounting With this checked: Inventory will come over, with sub-accounts for each C ategory/Sub-Category for each day of the export. With this unchecked: Inventory will come over as one lump sum for each day of the export. With this checked: COGS will come over, with sub-accounts for each C ategory/Sub-Category for each day of the export. With this unchecked: COGS will come over as one lump sum for each day of the export. So it will increase when funds are added to a gift card, and decrease when a gift card is used in a sale. This is the account that shows the charging and payment of any gift card accounts in LightSpeed Retail.

With this checked: Taxes come over split up by each applicable Sales Tax rate per day (for example in relation to previous example- 1/1/16 State Sales Tax $2.50, 1/1/16 City Sales Tax $2.50, 1/2/16 State Sales Tax $9, 1/2/16 Online Sales Tax $1).Ĭredit account monies received (or refunded) for items, goods, deposits With this unchecked: Taxes come over as a lump total per day of the export. This agency must be labelled exactly as your QuickBooks settings. Contact your local tax agency for more information. For example, Washington would be WA-Department of Revenue. This would be the Department of Revenue in your state or province. If this box is unchecked, you will get a lump sum per day and one grand total lump sum for the exported dates instead of your Payment Types broken out individually. Undeposited funds are all of the payments types you collected during the day. With it checked, you will get sub-accounts broken down first by Tax Class, then by the appropriate item Category. Instead, you will get one lump sales entry per day and one lump grand total per the exported dates. With this unchecked, you will not get a breakdown per Category. Sub-accounts are used to show you which categories were sold. Unchecked, this information (and the tab) will not exist You can either set the account types to match in QuickBooks Settings & Options, or uncheck Export Account Info, regenerate data, and create a new export to get the data into the correct account. If you get an error message saying This file cannot be imported because the account types do not match. This exports the account type information for each account. This can be changed while creating your export but this will always default to. The rest of this article will be dedicated to the QuickBooks Settings & Options in Retail, what each section means and what will happen if they are toggled on or off.

If you haven't yet setup your Chart of Accounts in your company, you can allow the Lightspeed export to do it for you. Capitalized, lowercase and spaces need to be matched perfectly. Each field should be labeled exactly what it is in your QuickBooks company. You'll want to make sure this information is set up properly before exporting. The QuickBooks Settings & Options can be found in REPORTS under the Accounting Section. Options to export: Sales, Credit Accounts, COGs, Purchase Orders & Vendor Returns Can DoĮxport totals for sales (broken in categories/sub-categories) NOTE: What the export cannot do, you can find in one of the basic Reports in your Retail account. Here is a chart of what the export can and cannot do. These files are designed specifically for QuickBooks and information will be distributed as general ledger entries. Lightspeed has a very basic program that allows you to export QuickBooks files.

Lightspeed restaurant inventory export