Open navigation

Integrations | Lightspeed to Xero Configuration

Below the mapping table for how Lightspeed & Pooltrackr transactions post to Xero accounts. 


SettingSelectionComments
Register Closure SettingsSummary by Account Code
Sales Tax
GST (10%)GST on Income
No Tax (0%)GST Free Income
Accounts for Products
Default sales account4000-000 - SalesAccount type: Revenue
On Account Sales
Invoices payment dateNone - Due immediately
Expenses
Send invoices asApproved
Record inventory purchases asAsset
On-hand inventory1400-001 - InventoryAccount Type: Current Asset, Enable payments to this account
COGS5000-100 - Cost of Goods SoldAccount Type: Direct Costs
Payment Types
Default payment account1004-001 - Undeposited FundsAccount Type: Current Asset, Enable payments to this account
Map individual payment typesYes
Cash
1003-001 - Cash On Hand per location
Account Type: Current Asset, Enable payments to this account
Windcave1004-001 - Undeposited FundsAccount Type: Current Asset, Enable payments to this account
Refunds1500-006 - Refunds PayableAccount Type: Current Asset, Enable payments to this account
Discounts4000-400 - Discounts GivenAccount Type: Revenue
Till payment discrepancies6010-203 - Cash Shortages and DifferencesAccount Type: Expense
Rounding6900-008 - Rounding Gain/LossAccount Type: Expense
Loyalty
Liabilities2500-009 - Lightspeed Loyalty LIAAccount Type: Current Liability, Enable payments to this account
Expense6210-007 - Lightspeed Loyalty EXPAccount Type: Expense, Enable payments to this account
Store Credit
Liabilities2500-008 - Lightspeed Store Credit LIAAccount Type: Current Liability, Enable payments to this account
Expense6210-006 - Lightspeed Store Credit EXPAccount Type: Expense, Enable payments to this account
Accounts for Cash Management
Petty cash6220-007 - Petty Cash EXPNeed an expense account
Cash in/out1300-200 - Cash FloatAccount Type: Current Asset, Enable payments to this account
Cash float1300-200 - Cash FloatAccount Type: Current Asset
Tracking Categories
Enable Tracking CategoriesYes

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.