Lightspeed-QBO COGS & PO Mapping
Budget: $250 – $750 USD
I need a clean, reliable bridge between Lightspeed Retail POS and QuickBooks Online that carries two specific data streams:
• Cost of Goods Sold, itemized for every single sales transaction
• Purchase Orders, itemized by vendor
Whether the connection is built with Lightspeed’s and QBO’s open APIs or through a proven third-party connector (e.g., Lightspeed Accounting, OneSaas, Zapier, etc.) is up to you; the end result just has to post accurately, on schedule (instant), and without manual intervention on my side.
What matters most is rock-solid mapping. A transaction in Lightspeed should create an equivalent, properly coded COGS entry in QBO, and every PO we raise in Lightspeed must land in QBO under the correct vendor with product detail intact. After the link is in place, I’ll need a short hand-off call or document showing me how to monitor sync status and troubleshoot the usual hiccups.
Deliverables
1. Functional, automated sync between Lightspeed POS and QuickBooks Online that meets the itemization requirements above
2. Initial backfill of historical data (if technically feasible) and confirmation of data integrity through sample reconciliations
3. Clear run-book or video walkthrough covering setup, schedules, and error resolution
If you have already solved this for another retailer, tell me how you approached duplicate handling, tax mapping, and timing delays—that experience will weigh heavily in my selection.
We currently use Webgility, and it maps all of the other items correctly with these two exceptions. Ideally, we would like one 3rd party to handle it all.
• Cost of Goods Sold, itemized for every single sales transaction
• Purchase Orders, itemized by vendor
Whether the connection is built with Lightspeed’s and QBO’s open APIs or through a proven third-party connector (e.g., Lightspeed Accounting, OneSaas, Zapier, etc.) is up to you; the end result just has to post accurately, on schedule (instant), and without manual intervention on my side.
What matters most is rock-solid mapping. A transaction in Lightspeed should create an equivalent, properly coded COGS entry in QBO, and every PO we raise in Lightspeed must land in QBO under the correct vendor with product detail intact. After the link is in place, I’ll need a short hand-off call or document showing me how to monitor sync status and troubleshoot the usual hiccups.
Deliverables
1. Functional, automated sync between Lightspeed POS and QuickBooks Online that meets the itemization requirements above
2. Initial backfill of historical data (if technically feasible) and confirmation of data integrity through sample reconciliations
3. Clear run-book or video walkthrough covering setup, schedules, and error resolution
If you have already solved this for another retailer, tell me how you approached duplicate handling, tax mapping, and timing delays—that experience will weigh heavily in my selection.
We currently use Webgility, and it maps all of the other items correctly with these two exceptions. Ideally, we would like one 3rd party to handle it all.