Lightspeed integration (POS)
Book the daily revenue from your Lightspeed POS (K-Series) automatically in your Blond accounting.
You'll find the integrations in your company's dropdown menu (top of the sidebar) under Integrations, or directly at https://app.blond.swiss/organization/integrations.
Note
The integration requires accounting to be enabled and supports Lightspeed Restaurant (K-Series).
How the import works
After the end of day, Lightspeed automatically sends a daily report by email to a secret Blond address. Blond books it as one collective entry per day and location:
| From the daily report | Booked to |
|---|---|
| Payment methods | Cash and transit accounts (debit) |
| Product groups (revenue) | Revenue accounts (credit) |
| Tips | Tips account (credit) |
Blond calculates VAT itself from the sales tax rates in your accounting — each product group and rate gets its own entry line.
Create a location
Open the Lightspeed card on the integrations page and click Set up integration. Give your location a name and click Add location. Blond creates a dedicated email address for reports.
Warning
The email address is the key to your accounting — every CSV file sent to it gets processed. Don't share it. If you delete the location, the address becomes invalid.
TIP
Running several locations? Create a separate entry for each. Every location gets its own address and account mapping, and you'll see the revenues separated in the journal.
Set up the report automation in Lightspeed
- In Lightspeed, open Reports → Report automation.
- Click Add report and choose Geschäftsbericht Export (Buchhalterisch) (accounting business report export).
- Set the period to End of day.
- Choose CSV as the format.
- Enter your location's email address as the recipient and save the automation.
Warning
Only exactly this report in CSV format works. Other reports or formats (e.g. PDF or Excel) are rejected — you'll get a notification explaining what to adjust.
You can leave the Accounting ID and Accounting reference fields in Lightspeed empty — the mapping happens in Blond.
Map the accounts
After the first import, your product groups and payment methods appear automatically in the location's Account mapping. Assign each name an account once:
Product groups: The revenue account the group's revenue flows to (e.g. 3400 service revenue).
Payment methods: The account where the money arrives — the cash register for cash, a transit account per card provider (e.g. Lightspeed Payments, TWINT), a liability account for sold gift cards.
TIP
Missing mappings never block the import: Blond books unmapped items to fallback accounts (by default 3400 for revenue and 1099 for payments) and flags the import for review. Once you've mapped the accounts, future imports come out right automatically — if needed, re-upload already booked days to correct them.
Under Advanced settings you can also adjust the tips account and the two fallback accounts.
Warning
Keep separate product groups for on-premise (8.1%) and takeaway (2.6%) so VAT is booked correctly. In Lightspeed this is usually already the case via the tax profiles.
Import log
Every received file appears in the location's Import log — with its status and a link to the created booking:
| Status | Meaning |
|---|---|
| Booked | Daily revenue fully booked |
| Fallback account used | Booked, but some items had no mapping — review the account mapping |
| Failed | Not booked — the error message in the log explains why |
| No revenue | Empty daily report, no booking needed |
| Replaced | Replaced by a newer import of the same day |
If an import fails, Blond notifies you by email and in the app. The original files are not stored for privacy reasons.
Corrections and backfilling
Correct a day: Export the report again in Lightspeed and upload it — Blond automatically replaces the day's existing booking. If the day falls into a closed fiscal year, the old booking stays and the import fails.
Backfill past days: Via Upload CSV in the location (or in the journal under New entry → Lightspeed (K-Series)) you can upload several files at once, e.g. for a whole month. The business day is read from the filename — if it's missing, Blond asks for the date.