Monthly KPI scorecard
The 5 to 10 numbers your team owns, target against actual, with an automatic on-track, watch or off-track status.
Pick your department, position, company type and market. We show the templates that fit you and the numbers worth watching. Excel files with the formulas built in and examples filled, and they open in Google Sheets too. Free, no sign-up.
The 5 to 10 numbers your team owns, target against actual, with an automatic on-track, watch or off-track status.
Money in and money out, week by week for a quarter, with the closing balance each week so a cash gap shows up early.
Each department’s yearly budget against what was really spent, with the gap in money and percent.
Every lead with its stage, value, chance of closing and next step. Weighted pipeline and overdue follow-ups calculate themselves.
Each rep’s target, achievement and commission, with a higher rate on everything above target.
Calls, meetings, follow-ups and deals per rep per day. The totals row shows the team’s week at a glance.
What goes out, where, in which format and who owns it, with a status for each post.
Budget, spend, leads and customers per campaign, with cost per lead and cost per customer worked out.
Every invoice with VAT, what is paid and what is still owed, days overdue and an aging bucket, ready for the weekly collections call.
Every expense with VAT split out, who paid and whether there is a receipt, totalled by the top row.
Gross salary, allowances and employer social insurance per person, with the monthly and yearly cost to the company.
One row per person: position, department, manager, start date, contract and years of service. The base for every other HR sheet.
What a new hire learns and delivers in week one, then at 30, 60 and 90 days, with owners and due dates. Managers fill it, new hires tick it.
Who is off, which type of leave, working days counted automatically, and approval status.
Goals and behaviours with weights, a self score and a manager score from 1 to 5, and a weighted overall score.
Every item with stock on hand, a reorder point that flags itself, and the value of what sits on the shelf.
Who does what by when, with priority and status. Overdue tasks flag themselves for the weekly team meeting.
Write a routine job down once, step by step, with owners and expected minutes, so anyone can run it the same way.
Every complaint or request with channel, category, owner and status. Hours to close and whether the target was met calculate themselves.
Every system and subscription the company pays for: owner, users, monthly cost, renewal date, two-step login and last tested backup.
Every unit with project, type, area, price, price per square metre and status, so sales and management read the same list.
Type the price, down payment, years and how often the client pays. Every due date and amount fills in for you to send the client.
One row a night: rooms sold, room revenue and the channel split. Occupancy, average rate and RevPAR calculate themselves.
Every booking with service, staff, fee, reminder sent and outcome. The top row shows the no-show rate and the revenue lost.
Every car in stock with cost, asking price, margin and days on the lot. Cars past 60 days flag themselves for a price review.
Once a team grows, the sheet turns into five copies that never match. We build your company a system that fills these numbers from the real work and shows them to each department. Send us the sheet you use and we will tell you where we would start.