Data Files samples / Takeaway
Saffron Lane Pizza and Curry
Phone, walk-in and online orders, delivery zones and drivers, the menu with sizes, extras and meal deals, and the night's takings for a takeaway.
Queries
The questions this database answers, saved under a name. Open one to see its answer, or its design to see how it is built and change it.
- Tonight's orders
Every order due tonight, earliest first, with how it came in, where it goes, its status and its total. Keep it open through the evening.
From Orders. Shows Number, Due Time, Channel, Method, Postcode, Status, Payment, Total.
Calculated: Due Time is
Mid([Due], 12, 5).Only where
Nights Ago = 0.- Orders still to go out
Orders booked, cooking, ready or out, by the time they are due, with the minutes left; below nought means it is late. The orders booked ahead for later nights are on it too.
From Orders. Shows Due, Number, Method, Channel, Postcode, Status, Minutes Left, Total.
Calculated: Minutes Left is
DateDiff("d", Date(), Format([Due], "yyyy-mm-dd")) * 1440 + (Mid([Due], 12, 2) * 60 + Mid([Due], 15, 2)) - (Mid(Now(), 12, 2) * 60 + Mid(Now(), 15, 2)).Only where
Status In ("Booked", "Cooking", "Ready", "Out").- Tonight by the hour
Tonight's orders by the hour they are due: how many, deliveries and collections, and their takings. Look at the next hour's row to see what is coming, and call in another driver when it is heavy.
From Orders. Shows Hour, Orders, Deliveries, Collections, Takings, with totals.
Calculated: Hour is
Mid([Due], 12, 2); Deliveries isIIf([Method] = "Delivery", 1, 0); Collections isIIf([Method] = "Collection", 1, 0).Only where
Nights Ago = 0andStatus <> "Cancelled".- Delivery times by zone, last 28 days
For each zone, the deliveries in the last 28 nights, the average and the longest time from the order going in to the door, and how many took longer than the zone's target.
From Orders, Delivery Zones. Shows Zone, Target Minutes, Deliveries, Average Minutes, Longest, Over Target, with totals.
Calculated: Average Minutes is
(DateDiff("d", Format([Placed], "yyyy-mm-dd"), Format([Handed Over], "yyyy-mm-dd")) * 1440 + (Mid([Handed Over], 12, 2) * 60 + Mid([Handed Over], 15, 2)) - (Mid([Placed], 12, 2) * 60 + Mid([Placed], 15, 2))); Longest is(DateDiff("d", Format([Placed], "yyyy-mm-dd"), Format([Handed Over], "yyyy-mm-dd")) * 1440 + (Mid([Handed Over], 12, 2) * 60 + Mid([Handed Over], 15, 2)) - (Mid([Placed], 12, 2) * 60 + Mid([Placed], 15, 2))); Over Target isIIf((DateDiff("d", Format([Placed], "yyyy-mm-dd"), Format([Handed Over], "yyyy-mm-dd")) * 1440 + (Mid([Handed Over], 12, 2) * 60 + Mid([Handed Over], 15, 2)) - (Mid([Placed], 12, 2) * 60 + Mid([Placed], 15, 2))) > [Target Minutes], 1, 0).Only where
Nights Ago Between 1 And 28andStatus = Done.- Takings by channel, last 28 days
Orders, deliveries, takings, the average order and the delivery charges for phone, walk-in and online orders over the last 28 nights.
From Orders. Shows Channel, Orders, Deliveries, Takings, Average Order, Delivery Charges, with totals.
Calculated: Deliveries is
IIf([Method] = "Delivery", 1, 0).Only where
Nights Ago Between 1 And 28andStatus <> "Cancelled".- Takings by month
Each month's takings by channel from the night sheets, the VAT within them, the kitchen's wages and the drivers' pay, and what was left.
From Nights. Shows Month, Nights Open, Orders, Phone, Walk-in, Online, Takings, VAT, Kitchen Wages, Driver Pay, Left After VAT and Wages, with totals.
Calculated: Month is
Format([Date], "yyyy-mm"); Takings is[Phone Takings] + [Walk-in Takings] + [Online Takings]; Left After VAT and Wages isRound([Phone Takings] + [Walk-in Takings] + [Online Takings] - [VAT] - [Kitchen Wages] - [Driver Pay], 2).- Busy nights, last 12 weeks
The average night for each day of the week over the last twelve weeks: orders, deliveries and takings. For planning the rota and the drivers.
From Nights. Shows Day, Nights, Average Orders, Average Deliveries, Average Takings, with totals.
Calculated: Day is
IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 0, "Monday", IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 1, "Tuesday", IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 2, "Wednesday", IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 3, "Thursday", IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 4, "Friday", IIf(DateDiff("d", #2024-01-01#, [Date]) Mod 7 = 5, "Saturday", "Sunday")))))); Average Takings is[Phone Takings] + [Walk-in Takings] + [Online Takings].Only where
Days Ago Between 1 And 84.- Best sellers, last 28 days
How many of each item went out in the last 28 nights and what they took, the most first. Items in a meal deal are counted as sold at nought; the deal carries the money.
From Order Lines, Orders, Menu Items, Menu Categories. Shows Menu Item, Category, Sold, Takings, with totals.
Calculated: Takings is
Round([Quantity] * [Unit Price], 2).Only where
Nights Ago Between 0 And 28andStatus <> "Cancelled".- Pizza sizes sold, last 28 days
How many pizzas of each size went out in the last 28 nights, for the dough and the boxes.
From Order Lines, Orders, Sizes. Shows Size, Pizzas, with totals.
Only where
Nights Ago Between 0 And 28andStatus <> "Cancelled".- Drops by driver, last 28 days
Each driver's deliveries over the last 28 nights, their drop fees, their average delivery time and the cash they collected.
From Orders, Staff. Shows Driver, Drops, Drop Fees, Average Minutes, Cash Collected, with totals.
Calculated: Driver is
[First Name] & " " & [Last Name]; Average Minutes is(DateDiff("d", Format([Placed], "yyyy-mm-dd"), Format([Handed Over], "yyyy-mm-dd")) * 1440 + (Mid([Handed Over], 12, 2) * 60 + Mid([Handed Over], 15, 2)) - (Mid([Placed], 12, 2) * 60 + Mid([Placed], 15, 2))); Cash Collected isIIf([Payment] = "Cash", [Total], 0).Only where
Nights Ago Between 1 And 28andStatus = Done.- Driver pay by week
The pay sheets of the last eight weeks: each driver, their drops and their pay, the newest week first.
From Driver Pay, Staff. Shows Week Beginning, Number, Driver, Drops, Drop Pay, Pay Date.
Calculated: Driver is
[First Name] & " " & [Last Name].Only where
Days Ago Between 7 And 62.- Customers not ordered for 60 days
Customers who have agreed to offers and have not ordered for more than 60 days, the biggest spenders first, with how many orders they made and when the last was. The list for a come-back offer.
From Customers, Orders. Shows Customer, Phone, Postcode, Orders, Spent, Last Order, Days Since, with totals.
Calculated: Customer is
[First Name] & " " & [Last Name]; Last Order isFormat([Placed], "yyyy-mm-dd"); Days Since isDateDiff("d", Format([Placed], "yyyy-mm-dd"), Date()).Only where
Days Since > 60andOffers = YesandStatus <> "Cancelled".- Ingredient use, last 7 nights
How much of each ingredient the last seven nights' orders used, from the recipes and the pizza sizes, and what it cost, by supplier. Use it when ordering and to check against what was delivered.
From Order Lines, Orders, Menu Items, Recipe Lines, Ingredients. Shows Supplier, Ingredient, Unit, Bought As, Used, Cost, with totals.
Calculated: Used is
Round([Order Lines].[Quantity] * [Portion] * [Recipe Lines].[Quantity], 3); Cost isRound([Order Lines].[Quantity] * [Portion] * [Recipe Lines].[Quantity] * [Cost per Unit], 2).Only where
Nights Ago Between 1 And 7andStatus = Done.
Forms
Every table has a form of the same name: Start Here, Business, Delivery Zones, Customers, Staff, Sizes, Menu Categories, Menu Items, Ingredients, Recipe Lines, Driver Pay, Orders, Order Lines, Nights. A form shows one record at a time and adds new ones. A field that points at another table is a list of that table's records, and the records that point at this one are listed below it.
Reports
Pages to print or save as a PDF, laid out from a query or a table.
- Tonight's orders
Tonight's orders in two sections, deliveries and collections, with their totals and how many. To keep an eye on the night or hand to the drivers' desk.
From the query Tonight's orders, a group for each Method: Due Time, Number, Channel, Postcode, Status, Payment, Total, with the total of Total, count of Number.
- Orders to go out
The orders still to go out with the minutes left, earliest first.
From the query Orders still to go out: Due, Number, Method, Postcode, Status, Minutes Left, Total, with the total of Total.
- Delivery times
Delivery times for each zone over the last 28 nights against the target, with the total over target.
From the query Delivery times by zone, last 28 days: Zone, Target Minutes, Deliveries, Average Minutes, Longest, Over Target, with the total of Deliveries, total of Over Target.
- Monthly takings
Takings by channel, VAT, wages and drivers' pay month by month, with the totals. For the accountant and the VAT return.
From the query Takings by month: Month, Nights Open, Orders, Phone, Walk-in, Online, Takings, VAT, Kitchen Wages, Driver Pay, Left After VAT and Wages, with the total of Takings, total of VAT, total of Kitchen Wages, total of Driver Pay, total of Left After VAT and Wages.
- Best sellers
The last 28 nights' sales by section of the menu, the most sold first, with the totals.
From the query Best sellers, last 28 days, a group for each Category: Menu Item, Sold, Takings, with the total of Sold, total of Takings.
- Driver drops
Each driver's drops, fees, average time and cash collected over the last 28 nights.
From the query Drops by driver, last 28 days: Driver, Drops, Drop Fees, Average Minutes, Cash Collected, with the total of Drops, total of Drop Fees, total of Cash Collected.
- Come-back list
The customers to send a come-back offer to, with their phone, how much they have spent and how long since their last order.
From the query Customers not ordered for 60 days: Customer, Phone, Postcode, Orders, Spent, Last Order, Days Since, with the count of Customer.
- Ingredient use
The last seven nights' ingredient use, a section for each supplier, with its cost.
From the query Ingredient use, last 7 nights, a group for each Supplier: Ingredient, Unit, Used, Bought As, Cost, with the total of Cost.
- Menu
The menu by section with descriptions, diet and spice marks and prices, to check against the printed menu and the website.
From the query Menu, a group for each Category: Menu Item, Description, Diet, Spice, Price.
- Menu costing sheet
Each item by section with its price, price less VAT, food cost, food cost percentage and gross profit, and the averages. For setting prices.
From the query Menu costing, a group for each Category: Menu Item, Price, Price less VAT, Food Cost, Food Cost %, Gross Profit, with the average of Food Cost %, average of Gross Profit.
- Start here: the everyday tasks, step by step
The guide to this database printed: each everyday task and its steps, from the Start Here table.
From the table Start Here, a group for each Task: Step, What to do.
Print templates
What the business sends out, one for each record, with its own name, address and payment details at the head from the Business table. Print one from its form, or choose which to print under Print templates, or save them as a PDF. The words in braces are filled in from the record.
Customer receipt
Goes in the bag or to the customer at the counter, on an 80 mm roll: the order number, when it was ordered and is due, each item with its size, notes and price, the food and drink, the delivery charge, the total and the VAT within it, and how it was paid. Every order prints, so choose the one you want.
One for each record of Orders, on a till roll 80 mm wide paper.
Order {Number}
Ordered · Ordered by · Collection or delivery · Due · Name · Payment
A line for each record of Order Lines: Qty, Item, Size, Notes, Price
Food and drink · Delivery · Total · VAT included
Payment: {Payment}. VAT number {Business.Tax Number}.
{Business.Document Footer}
Kitchen ticket
Printed on the kitchen printer as the order is taken: the order number, the time due, collection or delivery, and each item with its size and notes, with no prices. Meal deals show what was chosen. Every order prints, so choose the new ones.
One for each record of Orders, on a till roll 80 mm wide paper.
Kitchen {Number}
Due · Collection or delivery · Taken · Came by
A line for each record of Order Lines: Qty, Item, Size, Notes
Items
Delivery slip
Taped to the bag for the driver: the customer's name, address, postcode, phone and delivery notes, the zone, the time due, what is in the bag, and whether it is paid or how much cash to collect. Collections print one too, with no address, so choose the deliveries.
One for each record of Orders, on a till roll 80 mm wide paper.
Delivery {Number}
Deliver to · Address · Postcode · Phone · Notes · Zone · Due by · Driver
A line for each record of Order Lines: Qty, Item, Size
Order total · Cash to collect
Payment: {Payment}. Card and online orders are paid already; for cash, collect the amount above and hand it in at the end of the night.
Driver pay sheet
Given to each driver with their pay each week: every drop they made with its zone and fee, the cash they collected and handed in, and the pay for the drops. Numbered DRV-2026-0042. Tax and deductions are left for the payroll.
One for each record of Driver Pay, on A4 paper.
Driver pay sheet {Number}
Driver · Week beginning · Phone · Week ending · Drops · Paid on
A line for each record of Orders: Order, Delivered, Zone, Postcode, Drop Fee, Cash Taken
Drops · Pay for the drops · Cash collected, handed in each night
Paid per drop at the zone's fee, which covers the driver's own fuel and car. Tax, National Insurance and any other deduction are worked out by the payroll, not on this sheet.
Signed: Driver, Manager
Back to the overview of Saffron Lane Pizza and Curry