The Meat Shop Sales Data Entry System in Excel is a macro-enabled workbook with a 7-field entry form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding 26 values – 12 meat cuts, 8 payment methods and 6 order statuses. Every saved sale gets an automatic Record ID in the MSS-0001 series and an Entry TimeStamp, and the records table has formatted, dropdown-ready rows for 200 sales.
Plenty of butcher shops still keep sales in a counter notebook. It works until someone asks how much was written up last week, or which phone order is still unpaid, and the answer means flicking through pages of handwriting. This walkthrough covers every sheet, exactly what each stat card counts, and the limits worth knowing before you set it up for your own meat counter.
What the Meat Shop Sales Data Entry System in Excel Does
It is an .xlsm workbook with four sheets. You type a sale into a form, click Add, and the sale drops into a records table with its Record ID and timestamp. There is nothing to install, nothing to sign into and no subscription. Four cards beside the form recount themselves as records are added, updated or deleted.
It is deliberately small. It is not a point-of-sale till, not a billing or invoicing tool, not connected to a weighing scale, not stock or inventory control and not accounting software. The six sample customers, cuts and figures are fictional, and the workbook makes no halal, organic, food-safety or hygiene claim.
Key Features
- Seven-field form: Sale Date, Customer Name, Meat Cut, Weight (kg), Total Price, Payment Method and Status.
- Four VBA buttons: Add, Update, Delete (with a confirmation that shows the Record ID) and Reset.
- Stable Record IDs: the next ID is one more than the highest in the table, so a deleted number is never reused.
- Double-click to edit: the row loads into the form and the macro remembers its ID, so Update finds it wherever it sits.
- Dropdowns in two places: on the form and on table rows 15-214, all reading the Setting sheet.
- Linked-picture stat cards: the cards on Data Entry are pictures of formula cards on Setting, so restyling one restyles both.
- Unlocked: no sheet protection and no VBA password.
Sheets Explanation
Data Entry sheet
The form, the four buttons and the four stat cards sit across the top. Below them the table holds S.No., Record ID, Sale Date, Customer Name, Meat Cut, Weight (kg), Total Price, Payment Method, Status and Entry TimeStamp. With the samples loaded the cards read 6 sales, $214 revenue, 3 paid orders and 1 pending order.
Setting sheet
Three lists drive every dropdown: Meat Cut List (Beef Ribeye, Beef Sirloin, Beef Mince, Chicken Breast, Chicken Thigh, Whole Chicken, Lamb Chops, Lamb Leg, Pork Belly, Pork Sausages, Goat Curry Cut, Turkey Breast), Payment Method List (Cash, Credit Card, Debit Card, Mobile Wallet, Bank Transfer, Store Credit, Gift Card, Cheque) and Status List (Paid, Pending, Delivered, Refunded, Cancelled, On Hold). The four formula cards live here too.
How To Use sheet
Short instructions for entering, updating and deleting records, how the stat cards update, how to edit the lists and how to enable the macros on first open.
What the Four Stat Cards Count
These are the real formulas on the Setting sheet, read from the workbook itself:
| Card | Formula | What it means |
|---|---|---|
| Total Sales | COUNTA('Data Entry'!$C$15:$C$1048576) | Counts the Sale Date column. Add refuses a blank Sale Date, so this matches the sales added through the form. |
| Total Revenue | SUM('Data Entry'!$G$15:$G$1048576) | Every Total Price whatever the Status – Pending, Delivered, Refunded, Cancelled and On Hold included. |
| Paid Orders | COUNTIF('Data Entry'!$I$15:$I$1048576,"Paid") | Rows whose status is exactly Paid. |
| Pending Orders | COUNTIF('Data Entry'!$I$15:$I$1048576,"Pending") | Rows whose status is exactly Pending. |
Total Revenue is written up, not collected. The samples total $214.30 (the card shows $214), but only $135.50 comes from Paid rows; the pending lamb chops order ($45.00), the delivered chicken breast order ($21.00) and the refunded whole chicken ($12.80) make up the rest. For paid revenue only, replace Setting!I13 with this SUMIFS formula:
=SUMIFS('Data Entry'!$G$15:$G$1048576,'Data Entry'!$I$15:$I$1048576,"Paid")Paid plus Pending will not equal the sales count. Only two of the six statuses have a card, so on the samples 3 + 1 falls short of 6. Add =COUNTIF('Data Entry'!$I$15:$I$1048576,"Refunded") as a fifth card if refunds matter to you.
Total Price is typed. There is no price-per-kg column, and the macro copies the Total Price box straight into column G. Work out kilograms x price per kg before you type it, or add a price input named in_Price_per_kg and change the Total Price line in Module1 to sh.Range("G" & r).Value = sh.Range("in_Weight_kg").Value * sh.Range("in_Price_per_kg").Value.
The lists do not grow on their own. How To Use says every dropdown updates when you add rows, but the named ranges are fixed – Meat_CutList is Setting!$A$3:$A$14, Payment_MethodList $C$3:$C$10, StatusList $E$3:$E$8 – and all three are full. Insert a row inside a list to add a value, or redefine the name as =OFFSET(Setting!$A$3,0,0,COUNTA(Setting!$A$3:$A$100),1).
Excel Workbook vs. Google Sheets Log vs. Butcher Shop POS Software – Feature Comparison
| Feature | Meat Shop Sales workbook (Excel) | Home-made Google Sheets log | Butcher / meat shop POS software |
|---|---|---|---|
| Cost | $6.99 one-time (regular $11.99) | Free, but you build it | Recurring monthly subscription |
| Platform | Excel for Windows desktop | Any browser | Vendor app, till or browser |
| Setup time | About 10 minutes | Hours of design work | Days of onboarding |
| Entry form with Add / Update / Delete | Yes, VBA | No | Yes |
| Real-time team collaboration | No | Yes | Yes |
| Mobile access | No | Yes | Usually |
| Customizable lists and fields | Fully unlocked | Yes | Vendor settings only |
| Scale link, stock control, invoices | No | No | Usually |
| Year-1 cost at 5 users | One purchase per user, no renewal | Free | Subscription x 12 months |
For a small butcher shop that wants a searchable sales register without paying for a POS it will not fully use, this workbook sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Butcher shops, halal and poultry counters recording each sale, the cut, the weight and whether it has been paid
- Small meat sellers taking phone or delivery orders who need to see which are still pending
- Owners comfortable in Excel who want a file they fully control
Not a fit if:
- You need a till, barcode or scale connection, stock levels, or tax invoices
- You need accounting, cold-chain, traceability or food-safety records
- Your team works on Mac, in a browser or in Google Sheets, or needs several people editing at once
Real-World Use Cases
Imran runs a family butcher shop. He logs each phone order with the cut and kilograms, leaves it Pending until the customer collects and pays, and checks the Pending Orders card every evening before closing.
Claire sells free-range poultry from a farm shop. She keeps her poultry cuts at the top of the Meat Cut list and filters the table by cut at month end to see what sold best by weight.
A small meat delivery business uses Delivered and Paid as separate statuses, adds a Refunded card and switches Total Revenue to the Paid-only formula so the top of the sheet matches the cash received.
Advantages
- One purchase, no subscription and no per-user fee.
- Ten minutes from download to first real sale.
- Update and Delete work by Record ID, so sorting or filtering the table does not break them.
- Everything is visible and editable – formulas, lists and macro.
Opportunities for Improvement
- A price-per-kg column with Total Price calculated as Weight x price per kg.
- A paid-only revenue card, and cards for Delivered and Refunded.
- Self-extending dropdown lists to match what How To Use promises.
- Optional protection for the Customer Name column, since the workbook itself is unprotected.
Best Practices
- Always add sales through the form so every row gets a Record ID; rows typed straight into the table cannot be updated or deleted by the buttons.
- Rewrite the Meat Cut and Payment Method lists before you enter real sales, inserting rows inside each block.
- Weight is labelled kg – convert pieces or packs, or rename the column.
- Keep a dated backup copy and store it on a secured PC, because it holds customer names; the in-table dropdowns cover rows 15-214 and Delete removes the whole worksheet row.
Macros and Compatibility
Macros must be enabled and Windows desktop Excel is required. On first open click Enable Content; Microsoft’s guide to enabling macros in Microsoft 365 files covers the security bar, and its note on macros from the internet being blocked explains the Unblock checkbox.
Explore Relevant Templates
If you like this format, the Bakery Sales Register Data Entry System in Excel and the Optical Shop Sales Data Entry System in Excel apply the same form-and-cards build to other counters, and the Mobile Accessory Sales walkthrough covers a fast-moving retail counter. For the shopping side, see the Grocery Shopping List Data Entry System in Excel.
In the store, the Grocery Delivery Services KPI Dashboard in Excel and Hypermarkets KPI Dashboard in Excel suit food businesses that have outgrown a simple register.
Frequently Asked Questions
What does the Meat Shop Sales Data Entry System in Excel record?
One row per meat sale: Sale Date, Customer Name, Meat Cut, Weight in kilograms, Total Price, Payment Method and Status, plus an automatic Record ID and Entry TimeStamp. Four cards show total sales, total revenue, paid orders and pending orders.
How long does setup take?
About ten minutes. Enable macros, replace the sample meat cuts and payment methods on the Setting sheet, delete the six sample rows and start adding sales. Nothing needs installing.
Do I need to know VBA?
No. The Add, Update, Delete and Reset buttons are already wired. VBA only matters if you want to change what a button writes, such as calculating Total Price from a price per kilogram.
Why is Total Revenue higher than the cash I collected?
The card adds every Total Price whatever the Status. On the samples it shows $214 against $135.50 from Paid rows. Swap in the SUMIFS formula above to count Paid sales only.
Can it print invoices or connect to a scale?
No. It is a sales register only – no invoices, tax, barcode, scale or stock features. Use POS or billing software for those and this workbook for a simple, searchable record.
How does it compare to butcher shop POS software?
POS software runs tills, scales and stock for a monthly fee. This is a one-time $6.99 Excel file that records what was sold, to whom, for how much and whether it was paid.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
This workbook turns a butcher counter notebook into a table you can sort and filter, with four numbers on top that keep themselves current. Know what those numbers count – written-up rather than collected revenue, a typed Total Price and two statuses out of six – and it will not surprise you.
Click here to Purchase the Meat Shop Sales Data Entry System in Excel – $11.99, currently $6.99.
✅ Instant download · One-time payment · No subscription
Last updated: September 2026
Watch more Excel tutorials at Youtube.com/@PKAnExcelExpert
