For teams that run on Lightspeed Restaurant
Lightspeed Restaurant sales report
The reports in Lightspeed Restaurant each answer one question, some only for a set period, and in Europe the deeper insights come with the Pro plan. Comparing Friday evenings across a season, or one dish across months, usually means exporting several reports and joining them in Excel.
How it goes today
- Run the report again for each period you want to compare.
- Export each one as a CSV or XLSX file.
- Paste them together and build a pivot table by hand.
- Start over the next week because the numbers have moved.
How it can go
Sales by hour, dish and server for the period you choose, next to last year.
One spreadsheet with net sales per day and hour, per dish and per server, for any stretch up to a year, next to the same weeks last year. It refreshes every morning from Lightspeed, so a question like which dishes sold most on Friday evenings this quarter has an answer without exporting anything.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. Lightspeed Restaurant works with a sign-in instead of a key, through an app that has to be approved first. That can take several business days; after that you sign in to Lightspeed Restaurant once, never in the chat.
With Hypamoon, every morning, take the sales from Lightspeed Restaurant with each receipt line, its time, dish, category and server. Keep one spreadsheet with net sales per day and hour, per dish and per server, for this year and last year side by side. Keep the columns the same each day so my own formulas keep working, and send me a short summary on Monday.
Access to the Lightspeed Restaurant API for your own business is a paid add-on that you request through your Lightspeed account manager. Lightspeed then sets up one access for your business, which can take up to 48 hours. It stays yours.
More for teams on Lightspeed Restaurant
- Tips go to whoever takes the payment, and I split them by hand each week.
- I can't pull a variance report, so I check the cash by hand every night.
- My accountant books the till by hand from the day reports.
- I run the same report for each restaurant and add them up myself.
- I want yesterday's numbers on my phone without logging in to the back office.
- I don't know my margin per dish, I work it out in Excel now and then.
- The stock module doesn't understand that I sell items in different portions.
- I would like to see wages next to the sales in the report.
- Everything for Lightspeed Restaurant