Laundry Management System in Excel: Price List, Order Lines, Express Surcharge, Due Dates, Receipts and Dashboard

By Ravindra Bagale · Last updated: 17 October 2026

← All Excel dashboards

Download the template: laundry-management-system-template.xlsx: a 8-sheet system with example data and real formulas (Read me, Setup, Price list, Order lines, Orders, Report, Receipt, Dashboard). Yellow cells are inputs you can type over; green cells hold formulas; blue rows are headers and totals. Replace the example data with your own and every report and the dashboard recalculate.

Made-up data: every name, amount, business and date on this page is made up for practice. Cities are used only to make the examples feel real.

1. The business story

Ruhi Laundry, Nagpur, 1 to 17 October 2026 (made-up data). Three services: Wash and iron, Dry clean, Iron only. Standard 3 days; express 1 day with a 50% surcharge.

35 orders, 237 pieces and ₹17,836 of billing. 25 orders are already delivered.

2. Build it sheet by sheet

Step 1. Setup and Price list

1. Setup B4 express surcharge (50%), B5 standard days (3), B6 express days (1), and the services in D3:D5.
2. Price list: Item, Service, Rate. D5 joins the two into a key: =A5&"|"&B5 gives "Shirt|Dry clean" (joining text).

Step 2. Order lines: one row per item

1. Headers: Order no, Item, Service, Qty, Rate, Amount, Key. Item and service come from drop-downs.
2. E5 rate: =XLOOKUP(B5&"|"&C5,'Price list'!$D$5:$D$21,'Price list'!$C$5:$C$21,0). One lookup with two conditions.
3. F5 amount =D5*E5 and G5 key =A5&"-"&COUNTIF($A$5:A5,A5) for the receipt.

Step 3. Orders: totals, due date and status

1. E5 pieces =SUMIFS('Order lines'!$D$5:$D$3000,'Order lines'!$A$5:$A$3000,A5).
2. F5 amount: =ROUND(SUMIFS('Order lines'!$F$5:$F$3000,'Order lines'!$A$5:$A$3000,A5)*IF(D5="Yes",1+Setup!$B$4,1),0).
3. H5 balance =F5-G5, I5 due =B5+IF(D5="Yes",Setup!$B$6,Setup!$B$5).
4. K5: =IF(J5<>"","Delivered",IF(I5<Setup!$B$3,"Overdue",IF(I5=Setup!$B$3,"Due today","In process"))). Colour it with conditional formatting.

Step 4. Receipt

1. Type an order no in B4; D4 finds the customer, B5 the due date and C8 each line's service: =XLOOKUP($B$4&"-"&A8,'Order lines'!$G$5:$G$3000,'Order lines'!$C$5:$C$3000,"").
2. L-033 for Amir Sayyed: one trouser for dry clean, ₹90 with ₹45 balance, due 19 October. Set the print area to A1:E14.

Step 5. Report and Dashboard

1. Report B5 pieces and C5 amount per service with SUMIFS; rows 10 to 13 orders and balance by status; rows 16 to 22 orders in per day.
2. KPI cards: orders, pieces, billing, balance, overdue and express share. Charts: amount by service and orders in per day.

3. Formulas used

Every formula above is written in the template, so you can click a cell and see it in the formula bar. All values on this page were recalculated in LibreOffice with zero errors.

4. Common mistakes

1. Two lookups for two conditions. A key of item|service needs one XLOOKUP. Separate lookups on item and service can return the wrong row.
2. Surcharge on each line. Apply express once at order level, as in Orders F5, so the receipt and report agree.
3. Status with only Overdue and Delivered. Due today is the list to work from in the morning; it needs its own test.
4. Missing items in the price list. A line that does not match shows a rate of 0. Add the item and service before taking the order.
5. Typing the order total. SUMIFS adds the lines; typed totals go wrong when a piece is added.

5. More real examples

Example 1: Dry-cleaning only. Drop the other services and add a Stain treatment extra on Order lines.

Example 2: Hostel laundry. Bill per kg per resident each month with a monthly plan in the price list.

Example 3: Ironing stall. Use only Iron only and a same-day due date with standard days set to 0.

Quick revision cards

Englishमराठीहिंदी

Quick revision

Each card shows formulas from this page, each with an example and its answer from the template. Scan the QR code on a card to open this lesson. All names and numbers are made up for practice.

More cards: Ravi Sir's Cards.

6. Frequently asked questions

How do I look up a price with two conditions in Excel?

Join the two into a key on the price list (=A5&"|"&B5) and look up the same join: XLOOKUP(B5&"|"&C5,keys,rates,0).

How do I add an express surcharge?

Multiply the order amount by (1 + surcharge) when Express is Yes.

How do I show orders due today?

Compare the due date with the as-of date: equal is Due today, earlier is Overdue.

How do I print a receipt with several lines?

Give each line a key of order no and line number and XLOOKUP "L-033-1", "L-033-2" on the receipt.

Should I add GST?

That depends on your registration and turnover. The template shows charges as quoted; confirm with your accountant.

7. Quick quiz

Ten questions on this page. Sign in to save your score.