Step 1 - Open a working copy
Download your purchased XLSX, save a copy, open it in Microsoft Excel, and read START HERE.
Before you start
- Keep the original workbook as a master.
- Replace the fictional sample records.
- Edit input columns and keep formulas.
- Follow the worksheet names shown here.
This browser guide demonstrates one worked example. Practice entries stay in this guide. Enter and save real records in the matching Excel worksheets.
Step 2 - Settings and month
Set your business details in Settings. Choose the reporting month on Dashboard, cell CU17.
Step 3 - Service Menu
Set your selling price and standard material cost before recording transactions.
Margin before other costs:
Step 4 - Purchases and stock
Use Inventory, Purchases and Supplies Used. Keep supply names and units consistent.
Available stock:
Opening stock + received purchases - usage. Keep units and item names consistent.
Step 5 - Sales
Enter the date, menu item, quantity and discount. Keep calculated columns intact.
Recognized example revenue:
Revenue = quantity × price - discount. Standard material costs come from Service Menu.
Step 6 - Expenses and operations
Record each operating expense once in Expenses. Set commissions in Staff and bay hours in Operations.
Commissions are calculated separately. Purchases replenish stock; do not count their cost twice.
Step 7 - Dashboard, Reports and Profit & Loss
Review the selected reporting month. These figures summarize this one practice example.
Revenue
Material cost
Operating expense
Net profit
Net profit includes the example staff commission. Your Excel Dashboard reflects all entered records, rather than only this example.
Step 8 - Save and back up
Return to Excel and save your working XLSX. Keep a dated backup.
Practice notes are separate from your Excel workbook.