---
title: "Lightspeed Restaurant food cost · Hypamoon"
description: "Working out the margin per dish from Lightspeed Restaurant in a spreadsheet? Get food cost and margin per dish each week, from what you sold."
url: https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/food-cost
---

1.  [Connect to](https://hypamoon.com/connect-to)
2.  [Lightspeed Restaurant](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series)
3.  Food cost

For teams that run on Lightspeed Restaurant

# Lightspeed Restaurant food cost

Lightspeed Restaurant keeps a cost price per item, and recipes and stock come with the inventory add-on. Seeing which dishes earn the most after cost, and which ones slipped when a supplier raised prices, usually means a spreadsheet next to the sales report.

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=lightspeed-restaurant-k-series/food-cost)

## How it goes today

1.  Export the item list with the cost prices.
2.  Export the sales per item for the same weeks.
3.  Join both in a spreadsheet and work out the margin per dish.
4.  Change the cost prices by hand when a supplier changes theirs.

## How it can go

**Food cost and margin per dish each week, from what you actually sold.**

Every Monday a list of your dishes with how many were sold, the sales price after discounts, the cost price from Lightspeed and the margin, next to the four weeks before. Dishes whose margin dropped, or that have no cost price yet, are at the top, so you know where to look first.

## 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.

Your request

> With Hypamoon, every Monday, take last week's sales lines from Lightspeed Restaurant with quantity, sales price after discounts and cost price per dish, plus the cost prices in our item list. Make a list per location with sold quantity, revenue, food cost and margin per dish, next to the four weeks before. Put dishes whose margin dropped or that have no cost price at the top, and email it to me and the head chef.

[Build this in your chat](https://hypamoon.com/connect?via=connect-to~lightspeed-restaurant-k-series/food-cost&say=a%20weekly%20food%20cost%20and%20margin%20list%20per%20dish%20from%20Lightspeed%20Restaurant%2C%20with%20the%20dishes%20whose%20margin%20dropped%20at%20the%20top.)

[Start free](https://app.hypamoon.com/?mode=signup&utm_source=connect-to&utm_campaign=lightspeed-restaurant-k-series/food-cost)

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.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/tip-pooling)
-   [**I can't pull a variance report, so I check the cash by hand every night.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/cash-variance)
-   [**My accountant books the till by hand from the day reports.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/bookkeeping)
-   [**The reports are plain Excel lists, so I export them and do my own analysis.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/sales-report)
-   [**I run the same report for each restaurant and add them up myself.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/multi-location)
-   [**I want yesterday's numbers on my phone without logging in to the back office.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/daily-sales)
-   [**The stock module doesn't understand that I sell items in different portions.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/stock-check)
-   [**I would like to see wages next to the sales in the report.**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series/labour-cost)
-   [**Everything for Lightspeed Restaurant**](https://hypamoon.com/connect-to/lightspeed-restaurant-k-series)
