ProSite Library – 60 Free Excel Templates for Retail Stores
ProSite Library
60 professional Excel templates for clothing stores, perfume shops and supermarkets – built by the ProSite team from real work inside stores in Iraq. Accounting, Operations, IT, Visual Merchandising and HR. Free to download, ready to use today.
What’s inside every template
Accounting
Cash, suppliers, payroll, pricing and profit – the numbers that keep a store alive.
Daily Cash Drawer Reconciliation
Match what the POS says you sold against what is actually in the drawer – every shift, every branch. The sheet calculates expected cash (float + sales – card – returns), shows the variance and flags shortages automatically, with a dashboard of sales and shortages per branch.
Petty Cash Book
A running petty-cash book for each store: top-ups and expenses with voucher numbers, category, receipt check and approver. The balance updates by itself and the dashboard shows where the money goes by category.
Supplier Payables & Aging
Track every supplier invoice from receipt to payment. Due dates, outstanding balances, days overdue and aging buckets (1-30, 31-60, 61-90, 90+) are calculated automatically – ideal for clothing, perfume and grocery suppliers.
Monthly Payroll & Sales Commission
A retail payroll sheet that handles basic salary, allowances, sales commission %, overtime, absence deductions and advances, and gives you the net pay per employee and per branch. Built for clothing, perfume and supermarket teams.
Branch Budget vs Actual (P&L)
Plan monthly revenue and expenses per branch (rent, salaries, generator, marketing…), enter actuals, and get favourable / unfavourable variance in IQD and % plus actual net profit on the dashboard.
Product Pricing & Margin Calculator
Turn supplier cost into a smart shelf price: adds shipping & customs %, applies your target margin, rounds to a clean IQD price (250 / 500 / 1,000), shows markup and the margin left after any discount – so sales campaigns never eat your profit.
Customer Credit (Ajel) & Collections
Every shop has customers who buy on credit. Record each credit sale with phone number and promised date; the sheet tracks what is collected, what is still owed, how many days late, and when you last called the customer.
Branch Break-Even & New Store Feasibility
Enter each branch's (or planned store's) fixed monthly costs – rent, salaries, generator & electricity, other – and its gross margin %. The sheet calculates the monthly and DAILY sales needed to break even, compares it with actual sales and shows your safety margin.
Daily Sales by Payment Method
Split each day's sales by payment method – cash, card, Zain Cash, Qi Card, other wallets and credit – subtract returns, compare with the POS Z-report and see the share of digital payments growing branch by branch.
Operating Expenses Register
Record every operating expense – rent, salaries, national power, generator, internet, marketing, maintenance and fees – with branch, payee, invoice and payment method. The dashboard totals this month, recurring costs and spending by category and branch.
Weekly Cash Flow Forecast
Plan money in and money out week by week – sales receipts, credit collections, supplier payments, rent, salaries and generator bills. Enter the forecast, update with actuals, and the running cash balance warns you of any week where cash goes negative.
Purchase Orders & 3-Way Match
Track each purchase order from order to delivery to invoice. The sheet compares quantity ordered vs. received and the invoice amount vs. the received value, so short deliveries and over-billing are caught before you pay the supplier.
Promotion & Discount ROI Calculator
Measure every promotion properly: compare sales during the offer with your normal daily sales, calculate the uplift, the extra gross profit and subtract the campaign costs. You get a clear verdict – worth repeating or rethink – for every offer and branch.
Fixed Assets & Depreciation Register
List every store asset – fixtures, lighting, ACs, generator, POS and fit-out works – with cost, useful life and salvage value. Monthly depreciation, accumulated depreciation and current book value are calculated automatically (straight-line).
Operations
Daily checklists, attendance, rosters, stock, expiry dates, KPIs and new-store openings.
Daily Store Opening & Closing Checklist
Ten essential checks every manager should tick at opening and closing – lights, cash float, POS, cleanliness, fitting rooms or perfume testers, full shelves, price tags, CCTV, staff and alarm. Each check gets a score and the dashboard ranks branches.
Monthly Staff Attendance Register
A colour-coded monthly attendance grid for all branches: Present, Absent, Late, Leave and Day off. Totals and attendance % per employee are calculated automatically and feed straight into the payroll template (ACC-04).
Weekly Staff Shift Roster
Plan the week (Saturday to Friday) for every employee with drop-down shifts. The sheet totals weekly hours, counts days off and warns you when someone has no day off or works over 60 hours. Dashboard shows hours by role.
Stock Count & Shrinkage Variance
A full or cycle stock count sheet with system quantity, first count, recount, final quantity, variance in units, %, and IQD value. The dashboard shows shrinkage value, count accuracy and which categories are losing stock.
Expiry Date Tracker (Supermarkets, Perfume & Cosmetics)
Track every batch by expiry date. The sheet counts the days left, colours items Expired / Sell now (≤30 days) / Watch (≤90 days) / OK, and calculates the money at risk so you can discount, move to the front or return to the supplier in time.
Reorder Point & Purchase Planner
Tell the sheet your average daily sales, supplier lead time and safety days – it calculates the reorder point, the maximum stock, how many days of stock you have, flags what to ORDER now and suggests the quantity and purchase value.
Store Daily KPI Tracker
The five retail KPIs every owner should watch daily: target achievement, conversion rate (buyers ÷ visitors), average transaction value, units per transaction and sales per staff – per branch, with a dashboard that compares branches.
Customer Complaints, Returns & Exchanges
Log every return, exchange, complaint and suggestion with the reason, refund amount and how fast it was closed. The dashboard reveals the top reasons (size, defects, prices, service) so you fix the root cause, not the symptom.
Inter-Branch Stock Transfer Log
Record every transfer between branches and the warehouse: what was sent, what was received and any difference. The status updates itself (In transit / Received / Discrepancy) so nothing gets lost on the road.
New Store Opening Plan & Countdown
The complete opening roadmap for a new clothing, perfume or supermarket branch: lease and permits, fit-out, IT/POS/CCTV, stock and VM, staff training, marketing and opening day. Each task gets an end date, days left and an automatic overdue alert, and the dashboard shows progress by phase.
Goods Receiving & Delivery Inspection
Inspect every delivery before you sign: cartons expected vs. received, damaged units, temperature of chilled goods and expiry dates. Any shortage, damage or warm chilled delivery is flagged so you can claim from the supplier immediately.
Fridge & Freezer Temperature Log (Supermarkets)
Record chiller and freezer temperatures twice a day. Safe limits (chillers 0–5 °C, freezers –25 to –15 °C) are applied automatically, out-of-range readings turn red, and the dashboard shows compliance per unit – ideal for food-safety inspections and protecting stock during power cuts.
Dead Stock & Aging Inventory Analysis
Find the products that stopped selling. The sheet counts days since the last sale (or since receiving), classifies stock as Fresh, Slow, Aging or Dead, shows how much money is tied up in each band and the value you recover with a markdown.
Shrinkage & Loss Incident Log
Log every loss event – shoplifting, internal theft, damage, pricing errors, supplier shortages and expired goods – with value lost, value recovered and how it was detected. The dashboard shows where shrinkage really comes from so you invest in the right fix (CCTV, tags, training or process).
Monthly Sales Target – Daily Split & Tracking
Split each branch's monthly target into daily targets using day weights (weekends, paydays and Eid count more). Enter daily actual sales and follow day and month-to-date achievement – the team always knows exactly what today needs.
IT
POS, printers, network, CCTV, licences and user access – documented and under control.
IT Asset Register (POS, Printers, Network, CCTV)
One register for every IT device across your stores – POS terminals, receipt and label printers, scanners, routers, NVRs, cameras, UPS. Warranty end dates and days left are calculated automatically, and faulty or expiring items are highlighted.
IT Helpdesk Ticket Log & SLA
Log every IT issue from the stores – POS, printers, internet, CCTV – with priority, who fixed it and how long it took. Resolution hours and SLA (Critical 4h, High 8h, Medium 24h, Low 72h) are calculated automatically.
CCTV Camera & Recorder Register
Map every camera in every store – view, NVR channel, IP, resolution and how many days of footage it keeps vs. what you need. Monthly checks are scheduled automatically and offline or short-recording cameras are flagged before you need the footage.
Store Network & IP Address Plan
Document every networked device per store: IP, subnet, gateway, VLAN, MAC, switch port and DHCP/static. Duplicate IP addresses are detected automatically – essential when you open new branches or add cameras.
Software Licenses & Subscriptions Tracker
All your recurring IT costs in one place – POS licences, accounting software, antivirus, Microsoft 365, hosting, internet lines. The sheet converts everything to monthly and yearly cost and warns you 30 days before each renewal.
User Accounts & Access Control
List every login on every system – POS, accounting, email, CCTV, Wi-Fi, social media – with its role and owner. When an employee leaves and the account is still active the sheet shouts 'DISABLE NOW', and access reviews are scheduled every 90 days.
Daily IT Health Check & Backup Log
Seven quick checks every branch does before opening: internet, POS online, data backup, printers, CCTV time and recording, UPS battery and Wi-Fi separation. Each day gets a score, failed checks turn red and the dashboard compares branches.
Price Change & Shelf Label Update Log
Control every price change in three steps: updated in the POS, new shelf label printed, verified on the shelf. The sheet shows the % change, keeps the reason and flags any change not completed – so shelf and cashier prices always match.
Internet & Power Outage Log
Record every internet, power, generator or POS outage with start and end time. Downtime minutes are calculated automatically, together with estimated lost sales – the evidence you need to negotiate with your ISP or generator provider, or to justify a backup line or UPS.
Visual Merchandising
Audits, windows, space productivity, planograms, props and size runs – merchandising that sells.
Visual Merchandising Store Audit Scorecard
A weighted VM audit for clothing, perfume and supermarket stores: windows, entrance hot zone, mannequins, wall bays, tables, fitting rooms, cash wrap, signage, lighting and housekeeping. Score each criterion 0–5 with a weight, assign actions and get the store's VM score %.
Window & Promotion Calendar
A year-round VM calendar for every branch: campaign, zone, install and removal dates, props, budget vs. actual cost and approval photos. It shows what is live today, how many days are left to install and keeps spending under control.
Space Productivity – Sales per m² & per Fixture
Compare each zone/category's share of sales with its share of floor space. The space index tells you which categories deserve more space (index ≥ 1.2) and which should shrink or move (< 0.8) – the core of every successful store layout.
Planogram & Shelf Space Allocation (Supermarkets & Perfume)
Plan each shelf by SKU: facings, product width and shelf width. The sheet checks if the shelf is over-filled, compares each SKU's share of space with its share of sales within the unit, and tells you where to add or cut facings. Works for gondolas, perfume walls and fridges.
VM Props & Mannequin Inventory
Count and value every VM asset – mannequins, busts, tables, risers, lightboxes, perfume tester stands and seasonal props – by branch, location and condition, so you reuse props across campaigns instead of buying again.
Signage & Promo Material Tracker
Track every sign and printed promo – price tags, posters, banners, window vinyls, shelf talkers – with offer, size, cost, install and end date. Expired promotions still on display are flagged in red so the shelf price always matches the cashier.
VM Weekly Store Visit & Action Log
For VM managers visiting several branches: record the visit score, each issue found, the action, owner and deadline. Days open and overdue actions are tracked automatically, and the dashboard ranks branches by average VM score.
Size Run & Broken-Size Floor Check (Clothing)
A daily floor check for fashion stores: count units per size (XS–XXL) for each displayed style. The sheet flags 'broken' size runs (missing S, M or L), counts missing sizes and tells staff what to refill from the stockroom – a quick win for conversion.
Store Lighting & Lamp Audit
Audit lighting zone by zone: number of fittings, failed lamps, colour temperature consistency and spot aiming. Working % is calculated automatically and every zone needing a fix is flagged – lighting is the cheapest VM upgrade there is.
Seasonal Floor Set & Allocation Plan
Plan where each collection goes before the stock arrives: zone, category, number of styles, units planned vs. received and fixtures needed vs. available. Each zone shows Ready or Not ready, so the floor set happens on schedule.
Human Resources
Staff files, hiring, leave, onboarding, training, appraisals, warnings and exits.
Employee Master File & Contract Tracker
The central staff database for multi-branch retail: contact details, branch, role, department, hire date, automatic years of service, contract type and end date, salary and status. Contracts ending within 30 days are flagged so you renew or replace on time.
Recruitment Pipeline Tracker
Track every applicant from CV to first day: position, branch, source (walk-in, Facebook, referral…), stage, interview score and expected salary. The dashboard shows which sources bring hires and how many candidates are stuck in each stage.
Annual Leave & Sick Leave Balance
Keep each employee's yearly leave entitlement, carried-over days, annual, sick and unpaid leave taken – and the remaining balance. Employees running low or over the limit are flagged, which helps you plan cover before Eid and the summer season.
New Retail Staff Onboarding Checklist
Ten onboarding steps every new salesperson or cashier must complete – from contract and uniform to POS login, product knowledge, VM standards, cash handling and the 30-day review – with a completion % and buddy trainer for each new hire.
Staff Training & Certification Tracker
Record every training session per employee – course, trainer, hours and test score. Pass/retake is automatic, and refresher dates (e.g. fire safety every 12 months) are scheduled so certifications never lapse. Dashboard shows hours and average scores per course.
Retail Staff Performance Appraisal (KPI Score)
A balanced 100-point score for sales staff: target achievement (30), attendance (20), customer service (20), VM & store standards (15) and teamwork (15). The rating (Excellent → Poor) is automatic and the dashboard compares branches – perfect for bonuses and promotions.
Disciplinary Actions & Warnings Log
Document every warning in a fair, consistent way: issue type, warning level (verbal → final), description, who issued it, employee signature and review date. The sheet counts each employee's warnings to date so escalation follows your policy.
Staff Exit & Turnover Analysis
Log every leaver with exit type, real reason, tenure and exit-interview notes, plus the handover checklist (settlement paid, uniform and keys returned, system logins disabled). The dashboard reveals the top reasons and how many people leave in their first 3 months.
Overtime Requests & Approval Log
Every overtime request with reason, hours, hourly rate and approval status. Approved hours and cost are totalled by branch and month, so overtime is planned, controlled and paid correctly through payroll (ACC-04).
Uniform, Keys & Equipment Issue Register
Record every item handed to staff – uniforms, name badges, shop and locker keys, POS cards, radios and scanners – with size, value, issue and return dates. Unreturned items and their value are shown instantly, which is essential when someone leaves or a key goes missing.
Staff Salary Advances & Loans
Track salary advances and staff loans: amount, number of monthly instalments, the deduction to take each payroll, what has been repaid and what remains. Active balances and this month's total deductions appear on the dashboard, ready for the payroll sheet.
Staff Incentives & Employee of the Month
A transparent monthly points system: sales achievement, attendance, customer compliments and VM/standards score add points, warnings subtract them. Each employee's rank inside their branch is calculated automatically and the winner of every branch is highlighted.
How to use the templates
- Download the Arabic or English file (or the full .zip) and open it in Excel, Google Sheets or WPS.
- Read the Guide sheet first – it explains every column.
- Type only in the light-green cells. Grey cells are formulas – don’t type in them.
- Delete or overwrite the example rows, then add your own data.
- Check the Dashboard sheet for totals, alerts and the chart. Save a copy each month or for each branch.
Questions
Are the templates really free?
Yes. Download, use and share them freely – we only ask you to keep the ProSite credit and link to prositeiq.com when sharing.
Which programs open them?
Microsoft Excel 2010 or newer (Windows and Mac), Excel mobile, Google Sheets and WPS Office.
Can I change them?
Of course – rename columns, add branches, change drop-down lists. The guide sheet tells you which formulas to edit.
Can ProSite build a template or system for my store?
Yes. Our operations, VM and IT teams build custom trackers and train your managers to use them. Contact us below.
Need more than a template?
ProSite opens, fits out and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Tell us about your store and we will help.
Call / WhatsApp +964 780 930 9998



