Tag: Business Operations

  • How to Build a Cash Flow Tracker in Google Sheets

    Build a cash flow tracker as a 13-week grid with one column per week, Monday through Sunday. Each column holds beginning cash, cash coming in, cash going out, net cash flow, and ending cash, and each week’s ending cash becomes the next week’s beginning cash. Start from a real bank balance, enter when you expect money to arrive and leave, and the sheet estimates your balance week by week for the next quarter. It shows which week looks tight while you still have time to act.

    Why a Profitable Month Can Still Leave You Short of Cash

    If your books use accrual accounting, your profit and loss statement records revenue when you earn it, and your bank account changes only when money moves. (Cash-basis books record revenue when it arrives, but cash timing still drives the balance.) The gap between profit and cash is where most cash problems start:

    • A customer invoice counts as revenue when you earn it and may not be paid for 30, 45, or 60 days.
    • Inventory and materials can leave your account before the cost shows up in your books, depending on how your books treat inventory.
    • Loan principal payments and owner draws reduce your cash, and neither is an operating expense on the P&L.
    • Payroll, payroll taxes, and other business tax payments go out on fixed dates that have nothing to do with when customers pay. They need dated entries in the tracker; however, your books record them.

    Accounting software tells you what already happened. A cash flow tracker looks forward and estimates your balance from the timing you enter.

    It also makes collections visible. The most reliable fix for slow payers is contact before an invoice is late: set up receivables so reminders go out, or someone talks to the customer, so you know what will lag and aim to keep invoices from drifting past 60 days. The tracker shows what’s left after you’ve done that.

    Why 13 Weeks

    Thirteen weeks is roughly one quarter, and it’s a common horizon in professional cash forecasting. It’s far enough out to see a problem while you can still act on it. The nearer weeks are easier to estimate and easier to correct each week; the further ones are rougher, which is why you refresh the sheet every week. Weekly columns match how cash moves: payroll, rent, and vendor payments land on specific days within specific weeks.

    Set Up the Sheet

    If you’d rather start from a finished version, copy the template, which has the layout, formulas, and color rules already built with made-up example numbers. To build it yourself, open a blank Google Sheet. Put labels in column A and the 13 weeks in columns B through N. Each column covers one week from Monday through Sunday. Enter every amount as a positive number; the formulas do the subtracting. Use these rows:

    RowColumn A labelWhat goes in each week
    1Week startingThe Monday date
    2Beginning cashLast week’s ending cash
    3Customer paymentsInvoices you expect to be paid that week
    4Card and online salesDeposits you expect from your processor
    5Other cash inAnything else that lands in the bank
    6Total cash inSum of rows 3 to 5
    7Payroll and payroll taxesWages, taxes, and benefits
    8Rent and utilities
    9Vendors and inventoryBills you plan to pay that week
    10Loan and tax paymentsPrincipal, interest, and business tax payments due
    11Owner draws and discretionary purchasesMoney you can choose to move
    12Total cash outSum of rows 7 to 11
    13Net cash flowCash in minus cash out
    14Ending cashBeginning cash plus net cash flow

    Then enter these formulas:

    1. B1: type the date of this week’s Monday. In C1 enter =B1+7 and copy it across to N1.
    2. B2: type your bank balance as of the start of that Monday, meaning the balance after Sunday’s transactions have cleared. In C2 enter =B14 and copy it across to N2. That link carries each week’s ending cash into the next week.
    3. B6: =SUM(B3:B5)
    4. B12: =SUM(B7:B11)
    5. B13: =B6-B12
    6. B14: =B2+B13
    7. Copy B6 and B12 through B14 across to column N.

    Type your minimum cash level in cell A17, with the label “Minimum cash” in A16. The next section explains it.

    If you start in the middle of a week, use your current bank balance in B2 and enter only the money that moves after that moment in the first column. Counting a transaction that has already cleared would count it twice.

    Fill In Cash In by When the Money Lands

    Enter each receipt in the week the money reaches your bank, not the week you send the invoice. If a customer on 30-day terms usually pays on day 45, put the payment in the week that contains day 45. Use how each customer actually pays; their terms only show when they’re supposed to.

    For card and online sales, look at the last eight to thirteen weeks of deposits in your bank export and use a typical week, adjusted for anything you know is coming. The business data you already have includes those exports. For retainers and recurring billing, use the billing date plus however long the money takes to settle.

    When you’re unsure about a payment, put it a week later. An early payment costs you nothing, while an assumed one that doesn’t show up can hide a shortfall.

    Fill In Cash Out by When It Leaves

    List each payment in the week it will leave the account. Include the items that don’t appear as operating expenses on the P&L: loan principal and owner draws. Those are the ones that make a profitable business feel short. Business tax payments and payroll taxes belong in the grid on their due dates, however your books record them.

    Rows 10 and 11 keep two kinds of payments apart. Row 10 holds payments you owe on a schedule: loan payments and tax payments. Payroll and payroll taxes in row 7 and rent in row 8 are also fixed. You generally can’t move any of these on your own. A vendor bill in row 9 moves only if the vendor agrees. Row 11 holds the money you can choose to delay, such as an owner draw or a purchase you can postpone. When a week turns red, row 11 is the first place to look.

    Set a Minimum Cash Level and Let Color Warn You

    Pick a floor: the lowest balance you’re comfortable seeing. One starting point is enough to cover two payroll runs. Set yours by how quickly you could collect or borrow if you needed to. Enter the number in A17.

    Then add two color rules to the Ending cash row:

    1. Select B14:N14 and open Format > Conditional formatting.
    2. Choose “Custom formula is” and enter =B14<$A$17. Set the fill to red.
    3. Add another rule with =AND(B14>=$A$17, B14<1.5*$A$17). Set the fill to yellow.

    Red means projected cash at the end of the week is below your floor. Yellow means it’s within 50% above it.

    What the Colors Can’t See

    These rules check each week’s ending balance only. A week can end above your floor and still dip below it in between. Say a week starts at $34,000 and your floor is $30,000. Payroll takes $15,000 out on Tuesday, and an $18,000 customer payment arrives on Friday. The Tuesday balance is $19,000, which is $11,000 under the floor, but the week ends at $37,000 and shows yellow rather than red. The weekly color does not reveal how low cash fell on Tuesday.

    For any yellow week, and any week with a large payment before a large receipt, list the dated payments and receipts for that week on a separate tab, or build a day-by-day view, before you schedule payments. The weekly grid shows you where to look.

    A Worked Example

    The numbers below are made up. A business starts week 1 with $42,000 in the bank and sets its minimum at $30,000. It pays $15,000 in payroll and taxes every other week, and rent of $8,000 comes out in weeks 1 and 5.

    Wk 1Wk 2Wk 3Wk 4Wk 5Wk 6
    Beginning cash$42,000$34,000$43,000$34,000$39,000$24,000
    Total cash in$18,000$15,000$13,000$14,000$12,000$11,000
    Total cash out$26,000$6,000$22,000$9,000$27,000$5,000
    Net cash flow-$8,000$9,000-$9,000$5,000-$15,000$6,000
    Ending cash$34,000$43,000$34,000$39,000$24,000$30,000

    Week 5 turns red. Payroll and rent land in the same week while cash in is the lowest it’s been, and the balance ends $6,000 under the minimum. Standing in week 1, that’s four weeks of notice. Weeks 1 through 4 and week 6 are yellow, and week 6 sits exactly on the floor.

    Four weeks is enough to do something, and the sheet shows what each change does. Asking a vendor to move a $4,000 bill from week 5 to week 6 lifts week 5 to $28,000, which is still $2,000 short. Week 6 falls to the same $30,000 as before, because the bill was delayed, not removed. Pairing the delay with a $2,000 customer payment that you pull in from week 6 to week 5 brings week 5 to exactly $30,000. Nothing in the P&L would have flagged this.

    Update It Every Week

    Pick Monday morning. It takes about 15 minutes, and Monday is when last week is over, and your opening balance is clear.

    1. Duplicate the tab and rename the copy with the date. You’ll use the copies later to compare what you forecast with what happened.
    2. In the live tab, delete the column for the week that just ended (right-click column B, then Delete column). The dates, beginning cash, and ending cash rows will show #REF! across the sheet until you finish the next step.
    3. Type this week’s Monday date in B1 and the bank balance at the start of that Monday in B2. The errors clear, and every week recalculates.
    4. Copy the last column into the next one to add a new week 13. The color rules come along with the pasted column. Then update its amounts.
    5. Revise the next four to eight weeks with whatever you’ve learned: paid invoices, new bills, changed plans.
    6. Look at the colors. If a week is red or yellow, pick one action and a date to take it.

    If you update midweek, don’t delete the current week. Change the amounts you now know and leave the structure alone.

    Mistakes That Make a Cash Flow Tracker Useless

    • Using invoice dates instead of payment dates. This is the most common one. It makes the forecast look healthier than your bank account will.
    • Leaving out cash that never touches the P&L. Loan principal and owner draws are the usual ones.
    • Counting a transaction twice. If you start from today’s bank balance, leave out the money that has already moved.
    • Not updating it. A tracker you refresh every week is worth more than a detailed one you rebuilt once.
    • Treating the forecast as exact. Round to the nearest hundred. The goal is to see which week gets tight, not to predict the penny.

    How Long to Stay in a Spreadsheet

    Stay in Google Sheets until it stops being enough. A sheet like this handles a small business well, and Google Sheets supports several people editing the same file, so shared access alone is no reason to leave. Look at other tools when you hit a specific problem the sheet doesn’t solve, such as pulling bank and accounting transactions in automatically across many accounts or entities, or meeting review and control requirements that a shared spreadsheet can’t. Until then, a disciplined sheet you update every week will do more than software you don’t use.

    Color alone won’t email you. If you want a message when a week goes red, that’s a separate setup. It needs Google’s conditional notifications, which are available only on certain work or school accounts, or a short Apps Script, and both have limits.

    Frequently Asked Questions

    Does a cash flow tracker replace my accounting software?

    No. Accounting software records what happened and produces your P&L and balance sheet. The tracker looks forward at cash timing. You use your accounting records to fill it in.

    How accurate does the forecast need to be?

    Accurate enough to tell you which weeks are tight. Round amounts, put uncertain receipts later, and update weekly. The weeks closest to today will be the most reliable.

    Do I need a template?

    No. The layout above takes about 45 minutes to build, and building it yourself means you know what every row does. If you’d rather not, copy the template and replace the example numbers with yours.

  • Revenue Per Available Parking Space, Explained

    Revenue per available space (RevPAS) is a facility’s parking revenue for a stated period divided by its available capacity over that same period. It is analogous to the hotel industry’s revenue per available room. RevPAS normalizes revenue for facility size and helps you investigate changes in pricing and use; it does not by itself prove why revenue changed. It needs revenue records; occupancy counts alone can’t produce it.

    What RevPAS Measures

    A parking space works like a hotel room or an airline seat: if it sits empty during a period, the revenue it could have earned in that period is gone. RevPAS measures how well each space earns, whatever the facility’s size.

    Facility A earns $100,000 a month from 1,000 spaces: $100 per space. Facility B earns $50,000 from 250 spaces: $200 per space. A brings in twice the total revenue, but B earns twice as much from each space. If you’re deciding where to invest in better equipment or where to test a new rate, that difference matters more than the totals.

    Two things must always accompany a RevPAS figure:

    • The period. Per day and per month give very different numbers, and neither is comparable to the other.
    • The capacity over that period. Use spaces that were actually available, not the painted total. If a level closes for half the month, count its spaces for the half when they were open. A single month-end count would misstate the denominator.

    Without both, two RevPAS figures can’t be compared.

    How to Calculate RevPAS

    Before the step-by-step math, here is the whole idea in one picture. RevPAS breaks into two parts: how much of your capacity gets used, and how much each hour of use earns.

    Occupancy rateoccupied space-hours ÷ available space-hours
    ×
    Revenue per occupied space-hourrevenue ÷ occupied space-hours
    =
    RevPAS per space-hourrevenue ÷ available space-hours
    × hours open in the period → RevPAS per day or per month
    Use (occupancy) times yield (revenue per hour of use) gives revenue per available space.

    The basic calculation

    Constant capacity
    RevPAS = Revenue for the period ÷ Available spaces

    Take a 300-space lot open 10 hours a day, every day (300 operating hours in a 30-day month). That schedule matters later: many municipal and commercial garages run 24 hours, so check your own facility’s hours before reusing these numbers. In the month, the lot takes in $45,000 from all sources: hourly parkers, monthly permits, and validations.

    • Monthly RevPAS = $45,000 ÷ 300 = $150 per space per month
    • Daily RevPAS = $150 ÷ 30 = $5.00 per space per day

    That’s all a facility with unchanged capacity and operating hours needs for monthly reporting. When capacity changes, calculate available space-hours instead: sum the spaces open in each hour of the period.

    When capacity changes
    Revenue per available space-hour = Revenue ÷ Available space-hours
    Effective available spaces = Available space-hours ÷ Scheduled open hours
    RevPAS for the period = Revenue ÷ Effective available spaces

    Multiplying revenue per available space-hour by the scheduled open hours gives the same per-space figure as dividing by effective available spaces. For example, if 100 of 300 spaces close for half of a 300-hour month, available space-hours are (300 × 150) + (200 × 150) = 75,000, or 250 effective spaces. Revenue of $45,000 would be $0.60 per available space-hour, or $180 per effective space for the month. Report the closure and denominator alongside the figure.

    Splitting RevPAS into revenue per occupied hour and utilization

    When RevPAS changes, the next question is what moved: use of available capacity, revenue earned per occupied hour, or both. The trick is to measure both in the same unit: the space-hour, meaning one space for one hour. The second component reflects rates, permit mix, discounts, and payment capture together; it is not a pure price measure.

    Return to the constant-capacity example: 300 spaces, open 10 hours a day throughout the month. In general form, the split is:

    The split
    Occupancy rate = Occupied space-hours ÷ Available space-hours
    Revenue per occupied space-hour = Revenue ÷ Occupied space-hours
    RevPAS per space-hour = Occupancy rate × Revenue per occupied space-hour

    Plugging in the numbers:

    1. Available space-hours = spaces × hours open. 300 × 10 hours × 30 days = 90,000.
    2. Occupied space-hours = the total hours cars were parked, from counts or entry and exit records. Say 45,000.
    3. Occupancy rate = occupied ÷ available space-hours = 45,000 ÷ 90,000 = 50%.
    4. Revenue per occupied space-hour = revenue ÷ occupied space-hours = $45,000 ÷ 45,000 = $1.00. This is realized revenue per hour of use, after the effects of permits, discounts, validations, and the rate mix.

    Multiply the two and you get revenue per available space-hour: 50% × $1.00 = $0.50. Multiply by the hours open to get back to the period figures:

    • Per day: $0.50 × 10 hours = $5.00
    • Per month: $0.50 × 300 hours = $150

    These match the basic calculation, which is the check that the split is right. Now a change in RevPAS can be traced: if next month’s RevPAS rises, you can see whether occupancy rose, revenue per occupied hour rose, or both.

    The mistake to avoid

    A tempting shortcut is occupancy × average ticket. It does not account for how long each car stays or how many times each space turns over.

    For a separate example, take a 300-space lot open 10 hours a day, with all revenue coming from parking tickets. It sells 600 tickets at an average of $2.50, earning $1,500 a day. If each car stays an average of 2.5 hours, occupied space-hours are 600 × 2.5 = 1,500 out of 3,000 available space-hours: 50% occupancy. Occupancy × average ticket gives 50% × $2.50 = $1.25, but actual daily RevPAS is $1,500 ÷ 300 = $5.00 per space. The shortcut mixes a proportion of available space-hours (occupancy) with a price per visit (ticket). It leaves out the two parking sessions per available space per day.

    Hotels can use occupancy × average daily rate because a room is usually sold once per night. A parking space can be sold several times a day, which is why the calculation has to go through space-hours.

    What Data You Need

    • For RevPAS itself: revenue by period from every channel (hourly, monthly permits, validations, events), assigned to the right facility and period; plus available spaces and operating hours over that period, including partial closures.
    • For the revenue-and-utilization split: occupied space-hours, from sufficiently frequent counts or from entry and exit records. Sparse snapshots cannot establish total occupied hours.
    • A caveat for ticketless systems: with license plate recognition (LPR) or mobile pay-by-plate, occupancy and payment come from different records, and they can drift apart. If you measure occupied hours from paid sessions, vehicles that park without paying or registering are invisible, so occupancy looks lower and revenue per occupied hour looks higher than it is. If you measure from camera reads, those vehicles are counted but missed or misread plates add noise to dwell times. Either way, the gap between vehicles seen and vehicles paid is the payment-capture issue covered under What Moves RevPAS.

    Occupancy data alone won’t get you there. In my analytics project on Istanbul’s municipal parking network, the city’s feed reports capacity and empty spaces for each facility, which supports occupancy. It has no revenue at all. So the project doesn’t calculate RevPAS or make any revenue claims, even though it would be easy to make up a plausible-looking number. The rule applies to any operator: don’t publish a metric your data can’t support.

    Price vs. Occupancy: The Trade-Off

    One reason to track RevPAS is to see the combined revenue effect when price and use both change. A higher rate can come with lower occupancy, but the response varies by facility and period. RevPAS shows the net revenue per available capacity; compare other conditions before attributing the change to price.

    For this simplified example, assume each occupied space serves one paying car for the full operating day, with no turnover, permits, discounts, or unpaid parking. A 200-space lot charges $8 a day at 95% occupancy: 190 cars generate $1,520 a day, or $7.60 per available space. It raises the rate to $14. If occupancy falls to 70% under the same assumptions, 140 cars generate $1,960 a day, and daily RevPAS becomes $9.80 per space: 29% higher, even with about a quarter fewer cars. With shorter stays or turnover, use the space-hour calculation instead.

    The 70% in that example is an assumption, and that’s the point to take from it. You won’t know how drivers respond until after the change. Some move to a nearby lot, some shift their arrival times, some pay. So:

    • Compare RevPAS for several weeks before and after, against the facility’s own normal range and similar days or seasons. A change inside the range the facility usually varies over the past six to twelve months may be noise.
    • Split the change into utilization and revenue per occupied hour, as above; then investigate what moved each component.
    • If you run nearby facilities, watch whether demand simply moved next door.

    What Moves RevPAS

    • Pricing by time of day. Charging more during the hours a facility runs near capacity and less when it’s quiet. Set those hours from the facility’s own occupancy history rather than a fixed trigger.
    • Event pricing. A flat rate during events, when demand is predictable and high.
    • Reserved spaces. A named reserved space sits empty whenever its holder is away. Moving to unassigned permits lets others use it.
    • Permit mix. How many spaces go to monthly permits and whether permit arrivals overlap with peak transient demand. Any decision to sell more permits than allocated spaces needs its own history and stress test.
    • Payment capture. If 80% of parked vehicles pay and that rises to 95%, revenue from those vehicles rises 18.75% (95 ÷ 80 = 1.1875), assuming the number of parkers and the average payment per paying vehicle stay unchanged. That average depends on rates, length of stay, and discounts; the percentage is not guaranteed if any of those change or drivers leave because enforcement tightened. Measuring the change needs vehicle counts matched to payments.

    A Property-Value Sensitivity Illustration

    For owners, sustained revenue changes may affect net operating income (NOI), which is one input to property valuation. The following calculation shows sensitivity to assumptions; it does not estimate a realizable sale price.

    A 400-space garage raises monthly RevPAS by $25, from $125 to $150. That’s $10,000 a month, or $120,000 a year. Assume 85% of the added revenue reaches NOI after added costs: $102,000. At an assumed 7% capitalization rate, $102,000 ÷ 0.07 is about $1,457,000 of added value.

    That’s arithmetic, not an appraisal or evidence that a buyer would pay $1.457 million more. Actual value depends on the lease or management structure, costs, market, appraisal method, and whether the higher RevPAS is expected to last.

    A Monthly RevPAS Check

    1. Calculate RevPAS for each facility for the month. State the period and the space count.
    2. Compare it with that facility’s last six to twelve months. Judge the change against how much it normally varies.
    3. If it’s off track, split it. Did occupancy move, or revenue per occupied hour?
    4. Assign one action, with an owner and a date.

    How to build a monthly KPI scorecard shows a spreadsheet layout for tracking RevPAS alongside targets and variance.

    Frequently Asked Questions

    What is a good RevPAS?

    There’s no general figure. RevPAS depends on location, facility type, pricing, and demand. Compare each facility with its own history and with your other facilities.

    What’s the difference between RevPAS and average ticket?

    Average ticket is revenue per parking session. RevPAS is revenue per available space. A higher average ticket can come with lower RevPAS if fewer cars park.

    Should RevPAS include monthly permit revenue?

    Yes. Include all parking revenue for the facility. Tracking the hourly and permit shares separately helps explain changes.

    Can I calculate RevPAS from occupancy data?

    No. RevPAS needs revenue. Occupancy data tells you how much of the capacity was used, not what it earned.

  • How to Measure Parking Facility Occupancy

    Parking occupancy is the number of occupied spaces divided by the number of usable spaces at a specific moment, times 100. The formula is the easy part. Before you trust the result, confirm what your capacity and available-space numbers mean, record when each reading was taken, reject invalid records, and collect readings over time. One reading describes one moment; it cannot establish the busiest time of a day or week. Manual counts, gate and payment records, and sensor or feed data can all help if you check their scope and limitations.

    Three Different Numbers People Call “Occupancy”

    When someone says a lot is “at 60%,” they could mean one of three things:

    • Occupancy at a moment: occupied spaces ÷ usable spaces at one time. “At 10:15 Tuesday, 180 of 200 spaces were taken: 90%.”
    • Observed peak occupancy: the highest reading in your sample across a defined period, such as a day or a week. Report the count times and number of readings; sparse sampling can miss the true peak.
    • Average utilization: the share of available space-hours that were used over a period. A 100-space lot open 10 hours has 1,000 space-hours available. If cars occupied 600 of them, utilization is 60%.

    These answer different questions. Utilization tells you how much of your capacity earns its keep over the day. Peak tells you whether you ran out of room.

    Mixing them up is the most common occupancy mistake. A garage reports 45% occupancy to its owner, a 24-hour average. It was effectively full from 11:30 to 1:30 every weekday, turning drivers away. Both statements are true. Only one of them helps anyone decide whether to add permits, change prices, or send overflow elsewhere.

    The Formulas

    Occupancy % = occupied spaces ÷ usable spaces × 100, measured at a stated time.

    Three details decide whether that number is right.

    Use a capacity denominator that matches the spaces being counted. Design capacity is every striped space. Usable capacity excludes spaces closed for repairs or blocked by construction or snow. If you report general-access parking separately, also exclude reserved, accessible, or loading spaces from both the numerator and denominator for that specific pool; do not drop them from a total-facility occupancy figure. A 200-space garage with a closed level of 40 spaces that fills its remaining 160 is 100% full, not 80%. State which capacity you used.

    Deriving “occupied” from “available” works only if both describe the same spaces at the same time. Many systems report empty spaces rather than occupied ones. Occupied = capacity − available is correct only when the capacity and the available count cover the same set of spaces and were recorded at the same moment.

    For gate or entry/exit systems, count the accumulation. Occupancy at a given time = the starting count + entries − exits. If 40 cars are inside at 6:00 AM, 180 enter and 95 leave by 10:00 AM, accumulation is 125 cars inside at 10:00. Divide that by usable capacity to get the occupancy rate. Accumulation drifts over time (more on that below), so it needs a regular reset against a physical count.

    Before You Calculate: Check What Your Data Means

    I’m building an analytics project on Istanbul’s municipal parking network, which publishes a live feed of its facilities with capacity and empty-space counts. Before calculating a single occupancy figure, I audited what the feed actually returns. The arithmetic turned out to be the least of it.

    Here’s a real reading from one snapshot on 2026-08-22. Facility 3068, an enclosed garage listed as open 24 hours, reported a capacity of 1,029 and 589 empty spaces at 02:31 Istanbul time. That’s 1,029 − 589 = 440 occupied, or 42.8%.

    The calculation took one line. The audit found five things that would have made numbers like that wrong without anyone noticing:

    1. Invalid requests return a normal-looking record. Asking for a facility ID that doesn’t exist returns a record with a capacity of 1 and 1 empty space instead of an error. Included in a calculation, it looks like a tiny, empty lot. Lesson: define what a valid record looks like and reject the rest before you calculate.
    2. The facility list has no timestamp. The list doesn’t say when each reading was taken. Lesson: if the source doesn’t timestamp a reading, record the time you retrieved it. A reading you can’t place in time can’t be part of a peak.
    3. A status field has no documentation. The isOpen field is 0 for most facilities, including facility 3068, which lists 24-hour operation. Lesson: don’t guess what an undocumented field means. Leave it out until you can confirm it.
    4. A time field has no timezone. The detail record’s update time doesn’t say which timezone it’s in. Lesson: confirm timezones before comparing readings from different sources.
    5. There’s no history. The feed shows only the current state. Lesson: covered in its own section below.

    Your data will have different quirks, but the questions carry over to any lot, garage, or system:

    • What exactly does “capacity” include? Does it change when spaces close?
    • What does “available” or “empty” mean, and does it cover the same spaces?
    • Where does each reading’s timestamp come from, and in what timezone?
    • What does an invalid, closed, or offline record look like?
    • Does the source keep history, or only the current state?

    The project’s code and evidence are public at github.com/johnserra/istanbul-parking-analytics. These figures come from a single audit snapshot. They aren’t a finding about how full Istanbul’s garages are.

    Istanbul parking data source: Istanbul Metropolitan Municipality (IBB) Open Data Portal, 2026-08-22 audit snapshot. The IBB Open Data License v1.0 requires this attribution: “Contains public sector information licensed under the Attribution 4.0 International (CC BY 4.0).”

    Three Ways to Collect Occupancy Data

    Manual counts

    Someone walks the facility on a schedule and counts occupied spaces. It costs staff time and nothing else, and it’s the most direct measurement there is.

    Choose count times from how the facility is used. An office garage, a retail lot, a hospital, and an event venue peak at different times, and a single universal schedule will miss some of them. Count at the times you expect to be busiest, plus a quiet period for comparison, on the days that matter (weekdays, weekends, or both). Record each count with its date and time on a simple sheet.

    Gate, ticket, and payment records

    If your facility has gates, ticketing, or pay-by-plate, you can reconstruct occupancy from entries and exits, usually in 15- or 30-minute intervals. The data already exists, so this is often the best place to start before buying anything new.

    The catch is drift. Tailgating, unreadable tickets, gate arms left up, and cars that exit without being recorded all push the running count off over time. Reset it against a physical count at a known quiet point on a regular schedule, and compare the two to see how far it drifted.

    Sensors, cameras, and live feeds

    Per-space sensors, entry counters, camera counts, and live data feeds give you frequent readings without anyone walking the lot. They’re worth it when a decision needs real-time information, such as guidance signs showing available spaces or prices that change by time of day.

    Automation doesn’t skip the checks above. A sensor feed has its own capacity definition, its own offline states, and its own timestamps, and all of them need confirming. For planning questions that do not need a live feed, start by testing whether counts and existing records answer the question before paying for hardware.

    One Reading Isn’t a Peak: Build Your Own History

    The Istanbul feed only reports the current state, so my project stores a snapshot each time it reads the feed. Without that, there’s no history. The same is true of most live feeds and many gate-system dashboards: they show you now, and “now” disappears.

    Two rules from the project carry over:

    • Keep the raw readings, not only the calculated percentage. If you later find that a capacity figure was wrong or an invalid record slipped through, you can recalculate.
    • Match the claim to the history you have. My project won’t forecast occupancy or trigger capacity alerts for a facility until it has 26 weeks of readings with at least 90% coverage. That’s a high bar for forecasting. For simple peak reporting, the practical version is to say what the peak is based on: “Peak of 96% at 10:30 on Tuesdays, from 18 weekday readings over three weeks” is an honest statement. “Peaks at 96%” from one busy morning isn’t.

    What Counts as “Full”?

    You may see 85% cited as a parking occupancy target. That number comes from a point-in-time curbside-parking context, not a universal goal for lots or garages. For example, SFMTA’s SFpark policy describes a commonly cited 85% curbside threshold at a single moment while using a 60–80% average occupancy target across a longer period to keep spaces available on each block. Those are different measurements and settings; neither gives your facility its own “full” threshold. Practitioners have also questioned relying on any occupancy target alone: in a May 2026 Parking Today piece, Cole Jaillet argues that occupancy is a snapshot rather than a behavior, and that two blocks at the same percentage can serve very different numbers of vehicles depending on how long each stays.

    For a specific facility, set two thresholds from its own history: a “busy” level where drivers start having trouble finding a space, and a “full” level where the facility is effectively out of room. Look at the readings from times you know were difficult (complaints, turned-away drivers, staff reports) and see where occupancy stood. Then report how long the facility stayed above each threshold, not only whether it crossed.

    A Two-Week Occupancy Audit

    If you’re starting from nothing, this gives you a defensible baseline:

    1. Set usable capacity and write down exactly what you counted and excluded.
    2. Choose count times from the facility’s use pattern. Cover weekdays and weekends if both matter.
    3. Record every count or snapshot with its timestamp in one sheet. Keep the raw numbers.
    4. Reconcile counts with transaction and permit records for the same times. Account for vehicles already present, exits, permits, validations, and unpaid sessions before treating a gap as a counting or payment problem.
    5. Report peak, time near capacity, and how many readings each is based on. End with one follow-up action, an owner, and a date.

    Once occupancy is reliable, it can support revenue analysis when you also have revenue records for the same facility and period. Occupancy data alone cannot show what a space earned. A full lot of monthly permit holders and a lot turning over transient drivers can look identical on an occupancy chart while producing very different revenue, which is why revenue per space needs its own treatment.

    Frequently Asked Questions

    What is the formula for parking occupancy rate?

    Occupied spaces ÷ usable spaces × 100, measured at a stated time. Use the spaces actually available at that moment, not the design total.

    How often should parking occupancy be measured?

    Often enough to sample the periods when your facility is likely busiest. For manual counts, that may mean several readings across the expected peak. Automated intervals should match the decision you need to make and the feed’s actual update frequency. State how many days and readings your observed peak covers.

    Is 100% occupancy good?

    Not usually. A lot at 100% is turning drivers away and has no room for permit holders who arrive late. How far below full a facility should run depends on its layout and its customers.

    Can I measure occupancy without sensors?

    Yes. Manual counts and gate or payment records answer most planning questions. Sensors earn their cost when a decision needs real-time data.

  • The KPIs Every Parking Lot Operator Should Track

    Track six metrics: peak occupancy, hours near capacity, revenue per available space (RevPAS), the split between hourly and monthly revenue, operating cost per space, and payment capture rate. Most KPI lists skip a practical point: each metric needs specific data. Occupancy counts support only the first two. RevPAS and the revenue split need revenue records, cost per space needs expenses by facility, and payment capture needs vehicle counts matched to payments. Start with the metrics your data supports.

    This guide covers what each metric tells you, what data it takes, and how to review them without adding reports nobody reads.

    Why Total Deposits Hide What’s Happening

    Many lots are run from one number: how much was deposited this month. It’s the number that matters most in the end, and on its own it explains almost nothing.

    A deposit total can’t tell you whether revenue rose because rates went up or because more cars parked. It can’t separate hourly parkers from monthly permit holders. And it can’t show the Tuesday mornings when the lot was full, and drivers went somewhere else. An empty space during a busy hour is revenue that can’t be recovered later, and a full lot turning drivers away is revenue you never see at all.

    The fix isn’t a long list of metrics. Keep the scorecard to four to seven numbers, depending on the business, and cut any metric that doesn’t move the needle. For parking, each metric should lead to a decision about staffing, pricing, permit allocation, or enforcement. If nobody would change anything when a number moves, it doesn’t belong. How many KPIs a small business should track makes the general case.

    Start With the Data You Have

    Before choosing metrics, check what your data can support. I learned this building an analytics project on Istanbul’s municipal parking data. The city’s parking API reports capacity and empty spaces for about 250 facilities, which is enough to calculate occupancy. It has no revenue, no payments, and no record of when individual cars arrive or leave. So the project leaves out revenue per space, payment compliance, and how long cars stay. Those metrics could be calculated from other data, but not from that feed, and a number the data can’t support is worse than no number: it looks precise and is wrong.

    The same test applies to any lot. Here’s the scorecard with the data each metric needs:

    MetricHow to calculate itData it needsDecision it drives
    Peak occupancyHighest occupied spaces ÷ usable spaces in a periodTimestamped counts or sensor readingsPermit allocation, whether to add or share space
    Hours near capacityHours at or above your “full” thresholdThe same counts, taken at regular intervalsPricing by time of day, overflow plans
    RevPASRevenue ÷ available spaces, for a stated periodRevenue by period; count of spaces actually usablePricing, allocation, comparing facilities
    Hourly vs. monthly mixShare of revenue (and of peak spaces) from each type of parkerRevenue by channel; permit list; ideally counts by parker typePermit limits, pricing
    Operating cost per spaceOperating expenses ÷ spaces, per periodExpenses recorded by facilityStaffing, automation, contract terms
    Payment capture ratePaid vehicles ÷ parked vehicles in spot checksVehicle counts matched to active payments at the same momentEnforcement, signs, fixing payment problems

    Go down the “data it needs” column and mark each row: have it, could get it, or don’t have it. That gives you your starting scorecard, and a short list of what to start collecting.

    Istanbul parking data source: Istanbul Metropolitan Municipality (IBB) Open Data Portal, 2026-08-22 audit snapshot. The IBB Open Data License v1.0 requires this attribution: “Contains public sector information licensed under the Attribution 4.0 International (CC BY 4.0).”

    Metrics 1 and 2: Peak Occupancy and Hours Near Capacity

    Occupancy is the share of usable spaces that are occupied at a given moment. Averaged over a day, it hides the pressure that matters. A lot averaging 55% can be completely full from 9 to 11 every weekday morning, and those two hours are when drivers get turned away and permit holders complain.

    So report two numbers instead of an average:

    • Peak occupancy: the highest reading in each day or week.
    • Hours near capacity: how many hours the lot stayed at or above your “effectively full” level.

    Peak tells you whether you ran out of room. Hours near capacity tells you how long, which is what pricing and permit decisions depend on. One tight hour on Fridays is a different problem from four tight hours every weekday.

    Getting these right depends on counting properly: using usable capacity rather than the number on the sign, timestamping every reading, and building enough history to describe an observed peak and its sampling limits.

    Metric 3: Revenue per Available Space (RevPAS)

    RevPAS is revenue divided by available spaces for a stated period, such as a day or a month. It does two things occupancy and revenue can’t do alone.

    First, it makes facilities of different sizes comparable. A 40-space lot and a 400-space garage can be judged on the same scale.

    Second, it normalizes revenue across available capacity. A lot raises its hourly rate from $5 to $10, and occupancy during those hours falls from 80% to 30%. Measured per space-hour, which is RevPASH (revenue per available space-hour, or occupancy × rate), revenue falls from $4.00 (0.80 × $5) to $3.00 (0.30 × $10). Total revenue over equal hours and capacity would show the decline too; the normalized measure helps compare different facilities or periods. RevPAS is the same idea over a longer period, such as a day or a month. The before-and-after comparison alone does not prove the rate change caused the decline. Before blaming the price, check for events, weather, and day-of-week patterns in the same hours, and for nearby lots’ occupancy if you can get it.

    RevPAS needs revenue by period and capacity over that same period. If spaces open or close during the period, use available space-hours before converting the result into a per-space figure; a single end-of-month space count would distort the comparison.

    Metric 4: The Mix Between Hourly and Monthly Parkers

    Most lots serve two kinds of customers, and they pay differently.

    • Monthly permit holders bring predictable revenue that arrives on schedule. The trade-off is a lower rate per hour of use, and they hold spaces during the busiest hours.
    • Hourly (transient) parkers usually pay more per hour, but demand swings with weather, events, and the day of the week.

    The mix is a decision, not an accident. Track the share of revenue from each, and, if you can, the share of peak-hour spaces each uses.

    Overselling permits

    Permit holders may not all park at the same time. Some work from home, travel, or leave early. An operator may consider selling more permits than the spaces set aside for them, but that decision needs counts and a plan for days when more holders arrive than expected.

    Set the oversell level from your own counts, not from a ratio you read somewhere. Count how many permit holders are present at the busiest time, over several weeks, and use the highest share you see.

    Here is how it works for a 400-space garage that sets aside 250 spaces for monthly permits:

    • Observed peak: over six weeks of counts, the highest simultaneous presence was 75% of permit holders.
    • Buffer: the operator chooses a 10% space buffer, so modeled peak permit parking stays at or below 225 spaces.
    • Permit cap: 225 ÷ 0.75 = 300 permits, or 120% of the 250 spaces.
    • Left for hourly parkers: the other 150 spaces.

    A future day can exceed the observed rate, so this calculation is a scenario to stress-test against unusual days and contractual obligations, not a guarantee of space.

    Recheck the counts regularly. If more permit holders start coming in every day, the safe number of permits drops.

    Metric 5: Operating Cost per Space

    Add up what it costs to run each facility: labor, payment processing, equipment and software, utilities, insurance, sweeping, snow removal, and repairs. Divide by the number of spaces for the period.

    Cost per space lets you compare facilities and spot drift. If one garage costs noticeably more per space than your others, or more than it did last year, find out why before the next contract renewal. The comparison that matters is against your own history and your own other facilities, since a generic industry ratio won’t reflect your labor market, climate, or contract terms.

    This needs expenses recorded by facility, not lumped together. If your books combine several lots, splitting them is the first job.

    Metric 6: Payment Capture Rate

    Payment capture rate is the share of parked vehicles that have paid or been validated. Unpaid parking is lost revenue, and it hides inside an occupancy count, because an unpaid car and a paid car take up the same space.

    Measure it with spot checks: count the vehicles in the lot, then match them against active payments, permits, and validations at the same moment. Paid ÷ parked is the rate. Repeat at different times and days, since compliance often varies.

    This metric needs matched payment data. Occupancy counts alone can’t show it, which is exactly the kind of metric to leave off until you can support it. There’s no universal target. Set one from your own baseline, and when it drops, check signs, payment machines, and apps before assuming drivers are avoiding payment.

    The spot-check rate measures compliance at that moment. If you also issue notices or invoices to non-payers, track separately what share of them is eventually paid. A lot with a low capture rate and a high recovery rate has a different problem from one that is low on both. Whether and how you can pursue unpaid sessions depends on local law and regulation, so treat recovery as its own measure and don’t fold it into the capture rate. Lots that do not use a modern tech stack have no session records to match, so for them the spot check is the only measure available.

    A Weekly Review in Four Steps

    Once the scorecard is set up, a short weekly review keeps it useful:

    1. Occupancy: peak and hours near capacity by facility. Any lot running full for longer than usual?
    2. RevPAS: compared against each facility’s own trailing baseline. Set how much movement counts as normal based on how much the number has actually varied over the past several months.
    3. Mix and capture: permit share, any oversell pressure, and the latest spot check.
    4. Actions: for each facility that’s off track, one action, one owner, and a date.

    The last step is what turns the review into management. How to build a monthly KPI scorecard shows a spreadsheet layout with targets, variances, and status colors that works for a set of lots as well as for a whole business.

    Parking KPI Checklist

    • I know which of the six metrics my current data supports.
    • I report peak occupancy and hours near capacity, not just averages.
    • I calculate RevPAS using spaces that were actually available.
    • I track revenue from hourly and monthly parkers separately.
    • My permit oversell level comes from my own counts.
    • Expenses are recorded by facility.
    • I run payment spot checks at different times.
    • Each weekly review ends with named actions and dates.

    Frequently Asked Questions

    What is the most important KPI for a parking lot?

    It depends on what you’re deciding. For pricing and comparing facilities, RevPAS, because it combines price and use. For capacity decisions, peak occupancy and hours near capacity.

    What is a good occupancy rate for a parking lot?

    It depends on the facility and on what “full” means for it. Set the threshold from its own layout, operating history, and instances when drivers struggled to find a space.

    How often should parking KPIs be reviewed?

    Weekly for occupancy, mix, and capture, since they change quickly and the fixes are operational. Monthly for RevPAS and cost per space, once revenue and expenses are closed for the month.

    What about turnover?

    If you have entry and exit data, turnover (parking sessions per space per day) shows how intensively spaces are used, and it’s useful for lots that serve short visits. It needs session data that many lots don’t collect, so it’s an optional seventh metric.

  • Data Analytics for Property Management Companies

    Data analytics for a property management company means tracking a handful of operating numbers that can affect net operating income (NOI), rather than reading the monthly accounting package after the fact. Five starting measures are physical occupancy alongside rent collected against potential rent, work-order resolution, days vacant between tenants, rent more than 30 days late, and controllable operating expenses per square foot. Choose the ones that fit your portfolio and data; some inputs may already be in your property management software.

    Accounting Reports Tell You What Happened. Operating Metrics Tell You What's Coming.

    Most property management systems produce a thorough monthly package: rent roll, income statement, general ledger, aged receivables. It's accurate, and it's backward-looking. By the time a slow repair or a rising utility bill shows up on the income statement, the tenant is already frustrated or the money is already spent.

    Operating metrics are the leading indicators behind those accounting results. Repair times, turn times, and late balances move weeks or months before NOI does, which gives you time to act.

    The test for including any metric is simple: does it help the property earn more revenue, run more efficiently, or cost less to operate? If it doesn't, leave it off. Keep the scorecard to four to seven numbers so someone actually acts on each one; how many KPIs a small business should track explains why that range holds.

    1. Physical Occupancy and Rent Collected Against Potential Rent

    Physical occupancy is the share of leasable space that has a tenant in it. For this scorecard, use a cash-collection ratio to show the share of potential rent actually collected. Some property reports call a related measure economic occupancy, but definitions vary, so keep the numerator and denominator visible:

    Cash-collection ratio = rent collected for the period ÷ gross potential rent for the same period × 100

    Here, gross potential rent is what the property would bring in if every leasable space were occupied at the documented market-rent assumption for that space and every tenant paid in full. Document that rent basis and use it consistently; scheduled rent in existing leases, billed rent, concessions, and cash collected are different amounts.

    The two numbers can diverge because of vacancy, free-rent concessions, discounts, and unpaid balances. The gap is not all collectible debt: some of it reflects deliberate lease terms or empty space.

    A building is 95% physically occupied. After two months of free rent on a new lease, one tenant well behind on payments, and a discounted renewal, it collects 84% of gross potential rent. The 11-point gap calls for a breakdown of vacancy, concessions, discounts, and overdue rent. The late balance is the part collections can pursue without changing lease terms.

    2. Work Order Resolution Time

    How quickly a routine repair gets fixed is something every tenant experiences, every month, long before the renewal conversation. Track three numbers:

    • Time to first response: hours from the request to someone acknowledging it or being assigned.
    • Time to complete: days from request to closed work order, for routine requests.
    • Open requests past the property's service target: the backlog that needs someone's attention. Set that target by request type and urgency rather than using one cutoff for every repair.

    Watch the trend rather than the average alone. A property whose completion time creeps up quarter after quarter has a staffing, vendor, or parts problem building, even if no single request looks bad. Slow repairs can also weigh on whether a tenant renews, so watch the renewal rate next to these numbers; it connects service back to NOI.

    3. Days Vacant Between Tenants

    Rent lost while a space sits empty doesn't come back. Measure the total days from move-out to the new tenant's lease start, and split it into three stages:

    1. Move-out inspection and scoping: from the keys being returned to a defined list of work.
    2. Make-ready: repairs, paint, flooring, cleaning.
    3. Leasing: from rent-ready to a signed lease and move-in date.

    The split tells you where time goes. If make-ready is the long stage, the question is vendor scheduling. If spaces sit rent-ready for weeks, it's a leasing or pricing question. A shared board listing every vacant space with its current stage and days in that stage is often enough to show the bottleneck.

    4. Rent More Than 30 Days Late

    A late balance is much easier to collect while it's young. The metric is the over-30-day late rate:

    Over-30-day late rate = rent balances more than 30 days past due ÷ rent billed for the month × 100

    Don't wait for the month-end aging report to find it. Send reminders and talk to tenants before balances become overdue. Use the over-30-day bucket as a review trigger; a balance approaching 60 days calls for a more direct follow-up under the lease and collection process. What counts as a normal level depends on the property type and tenant mix, so compare each property against its own history rather than a generic benchmark.

    5. Controllable Operating Expenses per Square Foot

    Some operating costs, like property taxes and insurance, are set outside day-to-day management. Others, like janitorial, landscaping, repairs, and utilities, are controllable. Track those separately and divide by rentable square feet so you can compare properties of different sizes and each property against its own past months.

    Unexplained changes are the trigger. Water cost per square foot at one building runs 40% above the same month last year with no change in occupancy. That's a reason to walk the building before the next bill: a running toilet, an irrigation zone stuck on, or a meter reading that needs checking. The metric doesn't diagnose the cause. It tells you where to look.

    How to Start Without Buying New Software

    You probably have all five metrics' raw data already.

    1. Export what you have. Rent roll, aged receivables, work order history, and the general ledger by property are standard exports from most property management systems. Put them into one spreadsheet, one tab per export.
    2. Build one screen. Five metrics, one row per property, each with a target, the current value, and a green, yellow, or red status. How to build a monthly KPI scorecard shows the layout.
    3. Review it weekly or monthly with the people who can act. The review is a short conversation about what the numbers mean, who will act on them, and by when. How to get your team to actually use your reports covers running that meeting.

    Stay in the spreadsheet while it gives the team a reliable, timely view. If recurring exports and reconciliation consume more staff time than a reporting tool would save, or multiple systems make errors hard to catch, evaluate an upgrade against those actual costs.

    If your portfolio includes parking, its operating metrics need their own scorecard. The KPIs every parking lot operator should track covers capacity, utilization by hour, revenue per space, and payment capture, which may matter there alongside property-level measures.

  • Which Website Metrics Matter for a Small Business

    It depends on what the website is for. If it exists to bring in inquiries, track six measures: inquiries, conversion rate by traffic source, the landing pages that lead to inquiries, engaged visits to commercial pages, cost per inquiry, and page speed. If people use your product on the site, swap the inquiry-specific measures for activation, drop-off, and return rates. Pageviews, impressions, and site-wide time on page can leave the monthly review.

    Six isn’t a magic number. My rule for any business scorecard is four to seven metrics, depending on the business, and no vanity metrics: each one has to move the needle. Website analytics is where that rule gets broken most often, because the tools show you everything by default.

    Why Most Default Analytics Reports Don’t Help

    Analytics tools are built to serve every kind of website, from a local accounting firm to a national retailer with a marketing department. So they show everything they can collect: users, sessions, pageviews, events, devices, cities, browsers, screen resolutions. None of it is wrong. Most of it doesn’t help a small business decide anything.

    The useful distinction is between two kinds of numbers:

    • Vanity metrics look good in a report and require no action. Pageviews went up 12%. Great. What do you do differently on Monday?
    • Commercial metrics track inquiries, customers, and the cost of getting them. When one moves, someone has a reason to act.

    The cost of watching the wrong numbers is quiet. A business can spend months redesigning pages to raise time on site while inquiries slide, and nobody notices because the report everyone looks at went up. The test I use on any metric is whether it helps the business make more revenue, run more efficiently, or cut costs. If it does none of those, it comes off the scorecard.

    If you haven’t looked at what your site already records, start there. Contact form submissions, booking confirmations, and phone logs usually exist before anyone opens an analytics tool. The business data you already have covers how to find them.

    What I Track on My Own Two Sites

    I run two sites that do different jobs, and I’ve only just started measuring both. What follows are the metrics I’m setting up, not results.

    johnserra.com is meant to generate inquiries. It uses GA4. I’m tracking two things: the share of visitors who complete a high-intent action (an assessment or the contact form), and where qualified visitors come from, split by referral and search and broken down by page.

    CareerTalkLab is a product. It’s a community whose members learn from and teach each other to advance in data and software careers, and I measure it with Umami. I’m tracking the share of visitors who start a lesson, completion and drop-off by module, and how many new learners come back on Day 7 and Day 30.

    Both sites get one technical metric: how long the slowest page loads and server responses take, measured at the 95th percentile.

    Those are target measures across two sites, not a combined scorecard or a claim that I already have results. The lists differ because the sites do different jobs. An inquiry site succeeds when a stranger reaches out. A product site succeeds when someone starts using it and comes back. Start with what your site is for, then pick four to seven measures for that site; a generic list of “top website KPIs” skips that step.

    The Five Metrics for a Site That Brings in Inquiries

    1. Key Conversion Actions

    A conversion is an action that moves a stranger into your sales pipeline. Count those, not visits. What counts depends on the business:

    • Professional services and consulting: completed contact forms, booked discovery calls, clicks on your email address.
    • Local trades and service businesses: click-to-call taps, quote requests, requests for directions.
    • Online stores and software: purchases, checkout starts, free trial signups.

    In GA4, you mark these actions as key events (Google’s current name for what it used to call conversions). Other tools call them goals or conversions. If you track nothing else on your website, track the total number of these actions each month and compare it with a target.

    2. Conversion Rate by Traffic Source

    Your overall conversion rate blends every source together and hides where buyers come from. Split it by channel:

    • Organic search: people who found you on Google or Bing, often while describing a specific problem.
    • Direct: visits with no identifiable source. This can include typed addresses and bookmarks, but also links from apps or messages that pass no referrer.
    • Referral: visitors from other websites, such as directories, associations, and partners.
    • Social: visitors from platforms like X or LinkedIn. These often bring attention more than inquiries.
    • Paid: ad clicks, if you run ads. These need the tightest tracking because you pay for every visit.

    Then compare. Here is an example with made-up numbers. A source that sends 500 visits at a 4% conversion rate produces 20 inquiries. A source that sends 5,000 visits at 0.1% produces 5. The smaller source is worth four times as much, and it’s the one a traffic report makes look minor.

    Source data from analytics tools is incomplete. Ad blockers, consent choices, and people who switch devices can break the trail. A “How did you hear about us?” field on your contact form fills some gaps, and tagging campaign links you control with UTM parameters helps identify those visits.

    3. Top Converting Landing Pages

    Visitors can arrive through your homepage, a service page, an article, or a guide. Your landing pages are the entry points; find which ones actually lead to inquiries rather than assuming the homepage does all the work.

    Check two things each month:

    • Which pages bring in the visitors who go on to convert?
    • Does each high-traffic page give visitors a clear next step: a form, a phone number, or a link to the relevant service?

    The common problem is a popular article with no conversions. It brings in the right readers and gives them nowhere to go. The fix is usually a clear next step near the top and bottom of the page, or a link to the service it relates to.

    4. Engaged Visits to Commercial Pages

    Raw traffic mixes useful visits with accidental clicks and visits that end quickly. Engagement is a helpful filter, but it cannot tell you by itself whether a visitor was a qualified buyer or even rule out automated traffic.

    GA4 counts a session as engaged if it lasts longer than 10 seconds, includes a key event, or includes two or more page views. Engagement rate is the share of sessions that meet that bar. Privacy-first tools like Umami don’t use the same definition, so there the practical measure is unique visitors to your commercial pages: services, pricing, about, and contact.

    A large traffic spike with almost no engagement is worth investigating. Check its sources and conversions before calling it a marketing win or deciding what caused it.

    5. Cost per Inquiry

    A website costs money and time. Measure what each inquiry costs you:

    Cost per inquiry = (monthly spend on the site and its marketing + hours spent × your hourly rate) ÷ inquiries that month

    Here’s an example with made-up numbers: a firm spends $200 a month on hosting, tools, and a small ad budget, and someone spends 6 hours a month on content at $50 an hour. That’s $500. With 20 inquiries, each costs $25. If the same firm spent $500 and got 2 inquiries, each would cost $250, and that’s a reason to look at whether the time would go further on direct outreach.

    Count inquiries, not every form submission. Spam and job applicants through the contact form will make the site look cheaper than it is.

    If Your Website Is the Product

    For software, online courses, memberships, and tools, an inquiry isn’t usually the goal. Someone using the product is. Keep two measures from the inquiry scorecard—valuable conversion actions and traffic source—then replace the landing-page, engagement, and cost-per-inquiry measures with:

    • Activation rate: the share of new visitors who take the first real product action, such as starting a lesson, creating a project, or running a first report.
    • Drop-off by step: where people stop in a sequence, whether that’s a course module, an onboarding step, or a checkout page.
    • Cohort return rate: of the people who signed up in a given week, the share who come back on Day 7 and Day 30.

    With speed, that is a six-measure product-site starting scorecard. These are the kinds of measures I’m setting up for CareerTalkLab. They answer the question a product site actually has to answer: do people who arrive start using it, and do they keep using it?

    The Metric Every Site Needs: Speed

    A slow page loses visitors before any other metric has a chance to count them. Measure the slow end, not the average. The 95th percentile (P95) is the time within which 95% of page loads finish. An average of 1.5 seconds can hide a meaningful share of visitors waiting six.

    You don’t need paid tools to start. Google’s PageSpeed Insights and the Core Web Vitals report in Search Console are free and show real-user field measurements when a page or site has enough data. Google reports those values at the 75th percentile, not P95, but for most small business sites that is a good enough place to start. If speed turns out to be a real problem, a real-user monitoring tool can report P95 directly.

    The Cut List: Metrics to Stop Reviewing Every Month

    These don’t need to be deleted from your analytics tool. They just don’t belong on the scorecard you review.

    1. Raw pageviews. Refreshes, back-button clicks, and multi-page wandering inflate them. More pageviews don’t mean more business.
    2. Bounce rate, by itself. Under the old Google Analytics definition, a visitor who read a whole page, found your phone number, and called still counted as a bounce. GA4 now defines bounce rate as the share of sessions that weren’t engaged, which is better, but engagement rate and conversions tell you the same thing more directly.
    3. Site-wide average time on site. Tabs left open and one long visit can skew it, and a longer visit isn’t better if the visitor couldn’t find what they needed.
    4. Social impressions. How many people saw a post on another platform says little about whether they visited your site, let alone contacted you.
    5. Keyword rankings in isolation. Ranking first for a phrase nobody searches, or one that attracts people who will never buy, produces nothing. Rankings matter only when they bring engaged visitors to pages that convert.

    A 15-Minute Monthly Website Review

    Once a month, with your scorecard open:

    1. Record conversions for the prior month against your target.
    2. Check conversion rate for your top three traffic sources. Note any that changed sharply.
    3. Find the top converting landing page and the page with the most engaged visits but the fewest conversions.
    4. Check speed on your two or three most important pages.
    5. Write down one action, with a name and a date. “Add a consultation link to the top article, Sam, by the 15th.” “Fix the phone link that doesn’t work on mobile.”

    The last step is the one that makes the review worth doing. A monthly number nobody acts on is just another report. How to get your team to actually use your reports covers how to run that conversation so the action happens.

    If you use GA4, its Traffic acquisition, Landing page, and event reports can help with this review. Check that the actions you count as inquiries are actually recorded.

    Website Metrics Checklist

    • I know what my website is for: inquiries, sales, or product use.
    • I track the actions that matter as conversions or key events.
    • I can see conversion rate by traffic source, not just overall.
    • I know which landing pages bring in converting visitors.
    • I review engaged visits, not raw traffic.
    • I know roughly what each inquiry costs me.
    • If the site is a product, I track activation, drop-off, and return rate.
    • I check page speed at the slow end.
    • My scorecard has four to seven metrics, and I review it monthly.

    Frequently Asked Questions

    How many website metrics should a small business track?

    Four to seven for each site’s scorecard. An inquiry site can start with the five measures above plus speed. A product site can keep conversions and traffic source, replace the inquiry-specific measures with activation, drop-off, and return, and also watch speed. Cut or combine measures when they don’t lead to a decision. How many KPIs should a small business track explains the wider business-scorecard principle.

    Is bounce rate still important?

    Less than it used to be. GA4 redefined it as the opposite of engagement rate, so looking at both is redundant. Engagement rate and conversions tell you more.

    Do I need Google Analytics?

    No. GA4 is free and detailed, but it’s also complicated. Privacy-first tools like Umami or Plausible are simpler and cover page, referral, and event tracking. What matters is that you can see conversions, sources, and landing pages in whatever tool you use.

    How often should I check website analytics?

    Monthly for the scorecard. More often only when you’re testing something specific, such as a new landing page or a campaign, and you know in advance what number you’re waiting to see.

    What’s a good conversion rate for a small business website?

    It depends on the industry, the offer, and where the traffic comes from, so a generic benchmark won’t tell you much. Your own trailing three-month average is the more useful baseline. Improve against that.

    If you want a second pair of eyes on your scorecard, or help deciding what belongs on it, get in touch.

  • A Monthly Reporting Pack Template for Small Business

    A monthly reporting pack for a small business fits in five pages: (1) a summary with your core metrics and what’s off track, (2) financial results against budget, (3) operations and team capacity, (4) sales pipeline and customers, and (5) risks and the decisions leadership needs to make. Keep the layout identical every month so the pack takes hours to produce rather than days, and put supporting detail in an appendix.

    Below is a copyable five-page outline, followed by the layout choices and a monthly production routine. Each page has one job. Fill in the placeholders with your own numbers and remove lines your business does not use. For what belongs on each page, in detail, see What to Include in a Monthly Business Report.

    Why Five Pages

    A monthly pack exists to help people decide what to do next. That means reporting what happened briefly, explaining the variances that matter, and giving the most attention to the choices ahead.

    Five pages is enough for that and short enough to be read before the meeting. Long packs get skimmed or skipped, and the page nobody reads is usually the one that mattered. The limit also forces a useful discipline: when something new wants in, something old has to come out.

    The other rule is sameness. The same pages, in the same order, with the same charts in the same places, every month. Readers learn where to look, and the person producing it copies last month’s file instead of starting over.

    Copy This Five-Page Template

    Each page below is shown as a fillable table. Use the same layout in a document or slide deck: start a new page or slide at each page heading, and keep the bracketed prompts until you have real numbers and decisions to replace them. The five pages are the main pack; supporting detail goes in the appendix.

    Prefer a ready-made file? Copy the template as a Google Doc — File > Make a copy, then fill in your own numbers.

    PAGE 1 — SUMMARY AND CORE METRICS

    Reporting month: [month/year]  |  Books closed: [date]  |  Cash at month end: [amount]

    Core metricActualTargetLast monthOn track / Watch / Off track
    [Metric 1]
    [Metric 2]
    [Add only the metrics needed, up to seven]
    Went wellOff track
    [two or three short results][miss, reason, and owner for each item]

    Main decision: [one sentence; see page 5]

    PAGE 2 — FINANCIAL RESULTS

    LineActualBudgetVariance ($)Variance (%)
    Revenue
    Direct costs
    Gross profit ($)
    Operating expenses
    Operating profit
    Gross marginactual [ ]%; budget [ ]%; variance [ ] percentage points
    Cashopening [ ]; in [ ]; out [ ]; closing [ ]
    Receivablestotal [ ]; past due over 60 days [ ]

    Largest variances: [what changed, why, and whether action is needed]

    PAGE 3 — OPERATIONS AND TEAM

    Output this month / last month / target[ ] / [ ] / [ ]
    Backlog this month / last month[ ] / [ ]
    Current bottleneck and response[ ]
    Quality or rework measure[ ]
    Team workload and capacity risk[ ]
    Headcount changes and open roles[ ]

    PAGE 4 — PIPELINE AND CUSTOMERS

    StageOpportunity countValueExpected timing
    Qualified
    Proposal out
    Won this month
    Pipeline for next quarter / revenue target[ ] / [ ]
    Win rate this month / trailing three months[ ] / [ ]
    Customers gained / lost / active, or repeat purchase rate[ ]

    PAGE 5 — RISKS AND DECISIONS

    Quarterly priorityStatusWhat changedOwner
    [Priority]On track / At risk / Delayed
    Risk or blockerImpactOwnerNext check date
    [Risk]
    DecisionContext and company-specific costRecommendationDecision makerDue date
    [Decision]

    Use the same metric definitions and reporting periods each month. Before sending the pack, check that a figure repeated on two pages matches and that every requested decision has a named decision maker and date.

    Page 1: Summary and Core Metrics

    If someone reads only one page, this is it. It should tell them whether the business is on track and what needs their attention.

    Layout, top to bottom:

    • Header line: the month, the date the books closed, cash at month end.
    • Scorecard table: your four to seven core metrics. One row each, with columns for actual, target, last month, and status. My rule is four to seven, depending on the business, with no vanity metrics.
    • Two short lists side by side: “Went well” and “Off track,” two or three bullets each, one line per bullet.
    • One box at the bottom: the most important decision this month, in one sentence, with a pointer to page 5.

    Here’s what that scorecard might look like for a small services firm, with made-up numbers:

    MetricActualTargetLast monthStatus
    Revenue$168,000$180,000$174,000Off track
    Gross margin41%40%39%On track
    Billable utilization72%75%74%Watch
    Receivables over 60 days$9,500Under $10,000$14,000On track
    Qualified pipeline$410,000$450,000$395,000Watch

    Use words, not only colors, for status. Red and green are hard to tell apart for some readers, and printed packs often end up in black and white.

    The sample statuses are illustrative. Set your own watch and off-track thresholds before using the template, and keep their definitions in the appendix.

    If you keep a monthly scorecard in a spreadsheet, this table is a copy of it. How to build a monthly KPI scorecard shows how to set that up so the numbers carry over each month without retyping.

    Page 2: Financial Results Against Budget

    Every financial number sits next to what you expected.

    Layout:

    • Summary income statement, four numeric columns: actual, budget, variance in dollars, variance in percent. Rows: revenue (split by main business line if you have more than one), direct costs, gross profit, operating expenses, operating profit. Show gross margin as a separate percentage and its variance in percentage points.
    • Cash block: starting cash, cash in, cash out, ending cash. If cash is falling, estimate months of cash remaining at the recent average monthly net cash outflow.
    • Receivables line: total owed, and how much is more than 60 days late.
    • Variance notes: two or three bullets, each explaining one of the largest differences from budget in a sentence.

    One chart, at most: revenue by month for the past twelve months against budget. Twelve months shows seasonality, which a single month hides.

    Keep this page to summary lines. The full income statement, balance sheet, and ledger detail go in the appendix, where anyone who wants them can find them.

    Page 3: Operations and Team

    This page shows whether the business can deliver the work it’s selling. It combines two sections that are often split: operations and team capacity. In a small business they’re usually the same question, since the team is the capacity.

    Layout:

    • Output trend: one chart showing your main measure of delivered work (jobs completed, orders shipped, hours billed) over twelve months.
    • Backlog: committed work not yet delivered, with last month’s figure for comparison.
    • Bottleneck: one sentence naming what’s currently limiting delivery, and what’s being done about it.
    • Quality: one or two measures of rework, errors, or complaints.
    • Team: workload (utilization, overtime, or open work per person), people who joined or left, open roles, and any capacity risk worth naming.

    This page varies most between businesses. A manufacturer tracks throughput and scrap; a consultancy tracks utilization and project backlog; a service company tracks jobs per crew and callbacks. Pick the few measures that tell you whether operations can support next quarter’s plan, and keep them the same from month to month.

    Page 4: Pipeline and Customers

    In a business with a longer sales cycle, this month’s revenue often reflects work sold earlier. This page shows what may be coming next, alongside the timing and size of future revenue targets.

    Layout:

    • Pipeline by stage, as a short table or a simple bar chart: inquiries, qualified opportunities, proposals out, won this month. Show counts and values.
    • Pipeline against target: qualified or weighted pipeline value next to next quarter’s revenue target.
    • Win rate: proposals won as a share of proposals decided, this month and over the trailing three months (monthly win rates swing a lot when the numbers are small).
    • Customers: new, lost, and total active; or, for businesses that depend on repeat purchases, the share of customers who bought again.

    Avoid funnel graphics that look impressive but hide the numbers. A four-row table is easier to read and compare month to month.

    Page 5: Risks and Decisions

    The pack ends with what needs to happen next.

    Layout:

    • Priorities status: the three to five things the business committed to this quarter, each marked on track, at risk, or delayed, with a line of explanation for anything not on track.
    • Risks and blockers: a short list, each with a named owner.
    • Decisions table:
    DecisionContext and costRecommendationWho decidesBy when
    Hire a second project managerBacklog grew for three months; the current manager handles 14 projects against the team’s agreed capacity of 10. Cost: [company estimate]/monthApprove; post the role this monthOwnerOct 15

    Put the recommendation in the table. A decision presented without one tends to get deferred.

    This page sets up the meeting. What makes a reporting conversation useful is an action-oriented discussion about what the numbers mean, who will act on them, and by when. Every row here should leave the meeting with a decision or a date for one.

    The Appendix

    Everything that supports the five pages but doesn’t need to be read by everyone:

    • Full financial statements
    • Detailed receivables aging
    • Department or location breakdowns
    • Project or customer lists
    • Definitions of each metric and where its data comes from

    The definitions page is worth writing once. When someone asks why this month’s utilization differs from another report’s, the answer is already there.

    How to Produce It Each Month

    The goal is to produce the pack in a few hours rather than a few days. That comes from setting up once and repeating the same steps.

    Set up once:

    1. Build the five pages as a template, with every table and chart in place.
    2. Write down where each number comes from: which report, which system, which filter.
    3. Link the scorecard and charts to a spreadsheet where possible, so updating the data updates the pages.
    4. Assign an owner for each page’s numbers and notes.

    Each month:

    1. Close: the books close and the source reports are exported.
    2. Update: paste or refresh the data. The scorecard and charts update from it.
    3. Explain: each page owner writes the variance notes for their page. Keep it to a sentence or two per variance.
    4. Review: one person reads the whole pack for consistency, such as matching numbers on pages 1 and 2 and clear decisions on page 5.
    5. Send: distribute it at least a day before the meeting.

    Save each month’s pack as a separate, dated file. The history is useful, and nobody has to wonder whether the numbers they’re looking at have changed since the meeting.

    Slides or a Document?

    Either works. Choose by how the pack is used.

    • Slides (Google Slides, PowerPoint) suit a pack that’s presented in a meeting and read on a screen. Each page becomes one widescreen slide. The constraint is space: if a page doesn’t fit on one slide, it has too much on it.
    • A document (Google Docs, Word, a PDF) suits a pack that’s read in advance, printed, or sent to a lender or investor. It holds variance notes and tables more comfortably.

    Whichever you choose, send it in advance and expect people to have read it. The meeting then spends its time on the off-track items and the decisions rather than on reading. How to get your team to actually use your reports covers the meeting itself, including a short note each owner of an off-track metric brings.

    Monthly Reporting Pack Checklist

    • Five pages, in the same order every month
    • Page 1: header, four to seven metrics with target and status, went well / off track, main decision
    • Page 2: summary income statement against budget, cash, receivables, variance notes
    • Page 3: output, backlog, bottleneck, quality, team
    • Page 4: pipeline by stage, pipeline against target, win rate, customers
    • Page 5: priorities status, risks with owners, decisions table with recommendations
    • Appendix: statements, detail, and metric definitions
    • Sent at least a day before the meeting

    Frequently Asked Questions

    What’s the difference between a reporting pack and a dashboard?

    A dashboard is live and checked whenever someone wants to. A reporting pack is a fixed monthly snapshot with explanations and decisions. Many businesses use both: the dashboard for day-to-day checks, the pack for the monthly review.

    Can a very small business use a shorter version?

    Yes. A business with a handful of people can often fit pages 1 and 5 on one page and pages 2 through 4 on another. Keep the same order and the same sections.

    Should lenders or investors get the same pack?

    Usually a shorter version: pages 1, 2, and 5, with the appendix available on request. Internal operating detail rarely helps them and can raise questions without context.

    How long should the pack take to produce?

    Once the template and data sources are set up, much of the work is updating numbers and writing short notes. The first few months take longer while you settle the definitions.

  • What to Include in a Monthly Business Report

    A monthly business report should cover six things: a summary with your four to seven core metrics, financial results against budget, operations and capacity, sales pipeline and customers, team capacity, and the decisions leadership needs to make. Each number needs a target or a comparison, and each off-track number needs a short explanation. Everything else, including detailed ledgers and metrics nobody acts on, belongs in an appendix or nowhere.

    The checklist below goes section by section. At the end is a cut list: what to take out.

    What a Monthly Report Is For

    A monthly report answers three questions for the people running the business:

    1. Did we hit our targets?
    2. If not, why not?
    3. What do we need to decide or do next?

    Anything that doesn’t help answer one of those three is a candidate for cutting. Length is a design decision, not a sign of thoroughness. A 30-page pack gets skimmed, and the one number that needed attention gets lost among the ones that didn’t.

    The report also isn’t your accounting package. Financial statements tell you what happened. A useful monthly report adds what’s coming: the pipeline, the capacity, and the choices that need to be made while there’s still time to make them.

    1. The Summary and Core Metrics

    The first page should tell the whole story of the month. If someone reads only this page, they should know whether the business is on track and what needs their attention.

    Include:

    • The period and the basics. Which month, when the books closed, and your cash balance at month end.
    • Your core metrics. My rule is four to seven, depending on the business, and no vanity metrics: each one has to move the needle. Show each with its actual value, its target, and a status (on track, watch, or off track). How many KPIs a small business should track covers choosing them.
    • What went well. Two or three results worth knowing about, stated plainly.
    • What’s off track. The metrics that missed, with a one-line reason for each. Be as direct about misses as about wins; a summary that only reports good news stops being trusted.
    • The main decision. The single most important choice leadership faces this month, if there is one.

    If you already keep a monthly scorecard, this page is mostly a copy of it. How to build a monthly KPI scorecard shows how to set one up in a spreadsheet.

    2. Financial Results Against Budget

    A financial number on its own doesn’t tell you much. $180,000 in revenue is good or bad depending on what you expected. Show every financial line next to a target and a comparison.

    Include:

    • Revenue: actual, budget, and the difference, split by your main lines of business if you have more than one.
    • Gross margin: revenue minus the direct cost of delivering it, as dollars and as a percentage. For a service business, direct costs are mostly the labor that does the work.
    • Operating expenses: the overhead, with any line that moved noticeably called out.
    • Operating profit (or net income, if that’s what your books report).
    • Cash: cash in, cash out, and the ending balance. If cash is falling, estimate how many months the current balance would last at the recent average monthly net cash outflow.
    • Receivables: how much customers owe you, and how much of it is late. Revenue that hasn’t been collected isn’t cash yet.

    Add one or two sentences explaining the biggest variance. “Revenue was $12,000 under budget because two projects slipped into next month” is more useful than another table.

    Here’s what that might look like, with made-up numbers:

    LineActualBudgetVariance
    Revenue$168,000$180,000−$12,000 (−6.7%)
    Gross margin41%40%+1 point
    Operating expenses$52,000$50,000+$2,000 (+4.0%)

    Percentages and percentage points are different things. Revenue that falls 6.7% below budget is a percentage; a margin that goes from 40% to 41% has moved one percentage point. Label them so nobody confuses the two.

    3. Operations and Capacity

    Financials show the result. Operating metrics show how well the business is producing it, and they usually move first.

    Include what fits your business:

    • Output: the main measure of work delivered, such as jobs completed, orders shipped, hours billed, or tickets closed.
    • The bottleneck: the one step, team, or resource currently limiting how much you can deliver. Name it. If the answer changed since last month, say so.
    • Backlog: committed work that hasn’t been delivered yet, and whether it’s growing or shrinking.
    • Quality: rework, errors, returns, or complaints. Whatever you track that shows work having to be done twice.

    Keep it to the few measures that tell you whether operations can support the revenue you’re planning. A manufacturer, a consultancy, and a cleaning company will fill this section very differently, and they should.

    4. Sales Pipeline and Customers

    In businesses with longer sales cycles, this month’s revenue often reflects work sold earlier. The pipeline shows what may be coming next; compare it with the timing and size of future revenue targets.

    Include:

    • Qualified opportunities: how many, and their total value. If you estimate the chance of winning each, show the weighted value too.
    • Win rate: of the proposals decided this month, how many you won.
    • Sales cycle: roughly how long it takes from first contact to a signed agreement, if you track it.
    • New and lost customers: how many started and how many left, or, for repeat businesses, the share of customers who bought again.

    A pipeline that looks thin next to next quarter’s revenue target is the kind of early warning a monthly report exists to give.

    5. Team Capacity

    For most small businesses, people are the highest cost and the main limit on growth.

    Include:

    • Workload: whether the team is running at a sustainable level. For a service business, that’s often utilization (billable hours as a share of available hours). For others, it may be overtime, open work per person, or a simple manager’s assessment.
    • Headcount changes: people who joined or left, and open roles.
    • Capacity risks: a key person leaving, a team stretched thin before a busy season, a skill only one person has.

    This section is often left out, and it’s where hiring decisions should start. A team running over capacity for three months is a decision waiting to be made.

    6. Risks, Blockers, and Decisions

    End the report with what needs to happen next. A report that closes on numbers leaves the next step to chance.

    Include:

    • Risks: a large contract up for renewal, a supplier problem, a regulatory change, a customer that accounts for too much revenue.
    • Blockers: anything internal that’s stopping progress, such as a system problem, a missing approval, or two teams waiting on each other.
    • Decisions needed: a short table. Each row is one decision, the options, a recommendation, who decides, and by when.

    When I think about what makes a reporting conversation useful, it’s an action-oriented discussion about what the numbers mean, who will act on them, and by when. This section is where the report sets that conversation up. How to get your team to actually use your reports covers running the meeting, including a short off-track note each metric owner brings.

    What to Leave Out

    A good report is defined as much by what isn’t in it. When deciding whether a metric earns a place, I check whether it helps the business make more revenue, run more efficiently, or cut costs. If the honest answer is no, it goes.

    Take out:

    • Detailed ledgers and trial balances. Your accountant needs them. The leadership team needs the summary. Put them in an appendix if someone asks.
    • Vanity metrics. Social followers, impressions, and website traffic with no link to inquiries. They go up and down without anyone needing to act.
    • Numbers without context. A metric with no target, no prior period, and no trend can’t tell anyone whether to worry.
    • Every metric you can produce. If a number has sat on the report for six months without anyone acting on it, remove it and see whether anyone notices.
    • Unsettled arguments. Work out disagreements about what a number means before the report goes out, not in the margins of it.
    • Long narrative. One or two sentences per variance. If the explanation needs a page, it needs a separate conversation.

    Removing things is harder than adding them, because everything on the report was once someone’s good idea. Review the contents every quarter and cut anything that hasn’t earned its place.

    Monthly Business Report Checklist

    • A one-page summary with four to seven core metrics, each with a target and status
    • Wins and misses, stated plainly
    • Revenue, gross margin, operating expenses, and profit against budget
    • Cash position and receivables
    • A sentence or two on the largest variance
    • Output, bottleneck, backlog, and quality
    • Pipeline, win rate, and customers gained and lost
    • Team workload, headcount changes, and capacity risks
    • Risks, blockers, and a decisions table with owners and dates
    • Nothing without a target or comparison; no vanity metrics

    Frequently Asked Questions

    How long should a monthly business report be?

    Short enough that people read it before the meeting. A five-page starting point is a summary, financials, operations and team capacity together, pipeline and customers, then risks and decisions. Add detail only where the reader needs it to make a decision.

    Who should get the monthly report?

    The people who make decisions from it: owners, partners, and department leads. Lenders and investors often need a shorter version focused on financial results, cash, and risks.

    When should the monthly report go out?

    As soon after month end as the numbers are reliable. The later it arrives, the less time there is to act on it. If closing the books takes weeks, send the operating and pipeline sections early and follow with the financials.

    Should the report include forecasts?

    A short outlook helps: expected revenue for the next month or quarter, based on the pipeline and backlog. Label it as an estimate and compare it with what actually happened the following month.

    What’s the difference between a monthly report and a dashboard?

    A dashboard is something people check whenever they want. A monthly report is a fixed snapshot with explanations, sent at a set time, so decisions are made from the same numbers.

  • How Many Charts Should a Dashboard Have?

    There is no fixed number. The practical limit is the screen: a dashboard should fit on one laptop screen without scrolling and tell someone within a few seconds whether the business is on track. That usually means a row of number cards for your core metrics across the top, a few charts beneath them showing the trends behind those numbers, and a small breakdown or two at the bottom. Anything that doesn’t fit belongs on a second page.

    The better question is what each chart is for. A chart earns its place when someone looks at it regularly to make a decision and needs the shape of the data, not just the number. Start from those questions and the count takes care of itself.


    Why Does a Dashboard Need a Limit at All?

    A dashboard exists to be read quickly. Stephen Few, whose Information Dashboard Design is widely cited on the subject, defines a dashboard as the most important information needed to meet one or more objectives, arranged on a single screen so it can be monitored at a glance. Both parts of that definition limit the chart count: “most important” and “at a glance.”

    Every chart you add competes with the others for the reader’s attention. With three charts, a line that turns sharply down stands out. With fifteen, it looks like one more shape among many, and the reader has to search for it. The screen also runs out of room. Charts shrunk to fit lose their labels and axes, and a chart nobody can read hasn’t been included in any useful sense.

    Scrolling is the clearest warning sign. Once the dashboard runs below the fold, the reader can no longer see the headline numbers and the charts behind them at the same time. Anything below the fold is easy to miss.


    How Do You Decide How Many Charts You Need?

    Count Cards and Charts Separately

    A card shows one number: this month’s revenue, cash on hand, jobs completed. Add the target and last period’s value beside it, and a card answers “are we on track?” in a single glance.

    A chart shows a shape: how a number moved over time, or how it splits across categories. It answers “since when?” or “where is it concentrated?” A chart can show when a change started and which part of the business it sits in. Working out why it happened still takes someone who knows the business.

    Most of the confusion about chart count comes from treating these as the same thing. The cards carry your core metrics. My rule of thumb, depending on the business, is four to seven metrics, and no vanity metrics; each one has to move the needle. How Many KPIs Should a Small Business Track? covers how to choose them. Charts are a separate decision, and there should usually be fewer of them than cards.

    Give Each Chart a Question

    For every chart you’re considering, write the question it answers and who asks it. For example:

    • Is revenue running ahead of or behind last year, month by month?
    • Is weekly capacity keeping up with booked work?
    • Which customers owe us money, and how overdue is it?
    • Where are deals stalling in the pipeline?

    If you can’t write the question, the chart probably doesn’t belong on the main screen. If two charts answer the same question, keep the clearer one. If the answer is fully captured by a single number, use a card instead.

    Let the Screen Set the Ceiling

    Once you have a list of charts with real questions behind them, lay them out on the actual screen your team uses. On a typical laptop, a row of cards plus two rows of two or three charts at a readable size is often about as much as fits. Treat that as a starting estimate, not a rule. The real capacity depends on the viewport and browser zoom, how much room filters and labels take, and how complex each chart is. A simple line chart needs less room than a labeled breakdown. A larger monitor in a shared office fits more; a phone fits much less. Check on the screen your team actually uses.

    If the charts don’t fit, don’t shrink them. Move the lower-priority ones to a second page.


    What Should Go Where on the Screen?

    A simple three-part layout works for most business dashboards. Put the most important information at the top, where it is visible the moment the page opens.

    Top: The Headline Numbers

    A single row of cards across the top of the screen. Each card shows the current value, the target, and the change from the last period. This row should answer the main question, whether the business is on track, before the reader looks at anything else.

    Keep the cards in a consistent order, such as money first, then operations, then customers. If a card is out of range, color can flag it, but keep the rest of the screen in neutral tones so the color means something.

    Middle: The Trends

    The largest area goes to the charts that show how the headline numbers have moved over time. A typical small-business set might include:

    • A line chart of revenue or cash over the last twelve months, against target or last year.
    • A bar chart of weekly throughput: jobs completed, hours billed, or orders shipped.

    Each trend chart should connect to a card above it. If a trend chart doesn’t relate to any headline number, ask whether it belongs on this page.

    Bottom: The Breakdowns

    The bottom holds charts that split a number into parts, so the reader can see which part of the business a change sits in. Examples include receivables by age, sales by product line, or deals by pipeline stage. These are usually the first candidates for a second page if space runs short.


    Which Chart Types Work Best?

    A small set of chart types handles most everyday business questions. Using the same few types across the dashboard also makes it faster to read, because nobody has to work out how each chart works.

    Line Charts for Change Over Time

    Use a line chart when the question is about direction: up, down, flat, seasonal. Months or weeks run left to right. Two lines, such as this year and last year, are easy to compare. Each line you add after that makes the chart harder to read.

    Column Charts for Comparing Periods or Groups

    Vertical bars work well for comparing a small number of periods or categories, such as sales by month or jobs by team. Start the value axis at zero, because bar length is what the reader compares.

    Horizontal Bar Charts for Rankings

    When the categories have long names, or you want them ranked, turn the bars sideways. Top customers by revenue, overdue invoices by client, and product lines by margin all read well this way. Sort from largest to smallest.

    Sparklines Inside Cards

    A sparkline is a small, word-sized line chart without axes, a term introduced by Edward Tufte. Placed inside a card, it shows the recent direction of a number without taking up a chart’s worth of space. Sparklines are one of the easiest ways to show more trend information without adding charts.

    Tables, Sparingly

    A short table works for a specific list someone needs to act on, such as the five most overdue invoices. A long table of raw data belongs elsewhere. 7 Dashboard Mistakes Small Businesses Make covers raw tables on the main screen along with other common layout problems.


    Which Charts Should You Avoid?

    Some chart types take up a lot of space or make comparisons harder than they need to be.

    • Gauges and speedometer dials. A dial uses a large area to show one value. A card with the value, target, and prior period shows more in less room.
    • Pie charts with many slices. Comparing angles is harder than comparing lengths. A pie with two or three slices can work; beyond that, a sorted horizontal bar chart is easier to read.
    • 3D effects. Perspective distorts the size of bars and slices, so the chart misrepresents the numbers it shows.
    • Decoration. Heavy gridlines, background images, shadows, and gradient fills add nothing to the data. Tufte called this kind of non-data ink “chartjunk.” Remove it, and the numbers get easier to see.
    • Novel chart types for their own sake. Radar charts, bubble charts, and other less familiar types have legitimate uses, but on a dashboard for a general business audience, they usually take longer to read than a bar or line chart showing the same thing.

    A chart doesn’t need to look impressive. It needs to be understood quickly by the person who uses it.


    When Should a Dashboard Have More Than One Page?

    When the charts that pass the question test don’t fit on one screen, split the dashboard by audience or purpose instead of cramming everything in.

    A common structure for a small business:

    1. Overview. The headline cards and the few trend charts the owner or leadership team reviews. This page answers “are we on track?”
    2. Operations. Capacity, throughput, scheduling, and quality detail for the people running daily work.
    3. Finance. Receivables, cash timing, margin by product or service line, and the detail behind the money cards.

    Each page follows the same layout: cards at the top, trends in the middle, breakdowns at the bottom. Link the overview cards to the page with their detail, if your tool supports it. Looker Studio, Power BI, and Tableau all let you build more than one page or dashboard, and a spreadsheet can use separate tabs.

    The overview should stay stable. When someone asks for a new chart, the default home is a detail page. It moves to the overview only if it answers a question leadership asks regularly, and then something else should come off.


    How Do You Cut a Cluttered Dashboard Down?

    If you’re starting with a screen that already has fifteen charts:

    1. List every chart and card. Write the question each one answers and who uses it.
    2. Mark each one. Keep on the overview, move to a detail page, or delete. Duplicates and charts with no clear question are the first to go.
    3. Turn single numbers into cards. A chart whose only purpose is showing the current value can become a card, often with a sparkline.
    4. Rebuild the overview using the three-part layout, and check that it fits without scrolling on the screen your team actually uses.
    5. Ask the people who use it. Show the new version to two or three regular readers and ask what they’d look for first. If they can’t find it quickly, adjust.

    For a full renovation process that also covers data accuracy and ownership, see How to Improve a Business Dashboard You Already Have.


    Dashboard Chart Checklist

    • The overview fits on one screen without scrolling.
    • The top row holds four to seven cards, each with a target and prior-period comparison.
    • Every chart answers a written question that someone asks regularly.
    • No two charts answer the same question.
    • Trend charts relate to headline numbers.
    • Lines, columns, horizontal bars, sparklines, and short tables do most of the work; any other chart type is there for a reason.
    • No gauges, 3D effects, or decoration.
    • Anything that doesn’t fit lives on a clearly labeled detail page.

    Frequently Asked Questions

    Is there a standard maximum number of charts?
    No. Any fixed number would ignore the screen size, the audience, and how often the dashboard is used. The one-screen test and the question test are more reliable than a count.

    Should a spreadsheet scorecard have charts?
    Not necessarily. A monthly scorecard in rows and columns, with a status color for each metric, can do the job without any charts. How to Build a Monthly KPI Scorecard shows how to build one. Add a trend chart only if the team keeps asking how a number has moved.

    What about mobile?
    A phone screen fits far less, so don’t just shrink the desktop layout. If people will check the dashboard on their phones, build a mobile layout: the cards first, stacked vertically, then the one or two charts that matter most. On a phone, scrolling down is expected. Order the view so the most important items come first. Power BI and Tableau both let you design a separate phone layout.

    Does the tool matter?
    Less than the layout. Google Sheets, Excel, Looker Studio, Power BI, and Tableau can all produce a clean one-screen dashboard. A cluttered dashboard stays cluttered in any tool.

  • Why Your Business Numbers Don’t Match Across Systems

    Your payment processor, your bank, and your accounting software each record a different moment in the life of a sale. The processor records the charge when the customer pays. The bank records a deposit days later, after fees and refunds come out and several sales are batched together. Your accounting software records revenue according to your accounting method, which may be when the revenue is earned rather than when the cash arrives. In most cases, three different numbers mean three different measurements, and a short monthly reconciliation shows how they connect.

    I’ve seen this plenty in operating businesses. An owner compares last month’s sales across two or three systems, gets different totals, and starts wondering whether the bookkeeper made a mistake or whether money is missing. Usually the numbers are fine. Nobody has written down how they relate to each other.


    Why Does Each System Show a Different Number?

    Each system sits at a different step of the same transaction. Follow one sale through all of them, and the differences stop looking mysterious.

    A Sample Scenario: A client pays a $1,000 invoice by card on a Friday.

    1. Accounting software. The invoice was entered when the work was billed, perhaps the previous month. Entering the invoice is not what created the revenue. Under accrual accounting, the $1,000 counted as revenue when it was earned, typically when the work was completed, under the business’s accounting policy. That can fall in a different month from both the invoice and the payment.
    2. Payment processor. The charge is approved on Friday and shows $1,000 in gross sales.
    3. Processor balance. The processor takes its fee. At Stripe’s standard US price for domestic cards, 2.9% plus 30 cents per successful charge, that is $29.30, leaving $970.70 in the processor balance.
    4. Bank account. The money is not available the moment the card is approved. On Stripe’s standard two-business-day timing for US accounts, Friday’s sale becomes available for payout the following Tuesday. When it actually lands in the bank is a separate question, set by your payout schedule and your bank’s own processing, and it arrives batched with other sales in a single payout.
    5. Back in accounting. Someone matches that combined deposit to the invoices it paid and records the $29.30 as a processing expense.

    The same $1,000 now appears as revenue in one month, a $1,000 charge on a Friday, and part of a larger bank deposit some days later. All three are correct.

    The Business Data You Already Have describes what each of these records can tell you on its own. This article covers how to connect them.


    What Are the Four Reasons the Numbers Disagree?

    1. Timing

    Cash lags sales. Funds are not available for payout until the processor’s settlement timing has run; payouts then follow whatever schedule the account is on, and weekend or holiday payouts move to the next business day. Stripe says a new account’s first payout typically takes 7 to 14 days, and later payouts follow a schedule the business can set to daily, weekly, or monthly.

    The lag matters most at month end. Sales on the last two days of March may be in the processor’s March report but in the bank’s April statement. Sales from the end of February land in March deposits. The two months never contain exactly the same transactions.

    2. Fees, Refunds, and Disputes

    Processors usually pay out the net amount. Fees, refunds, and chargebacks come out of the balance before the money moves, so the deposit is smaller than the sales that produced it.

    The problem gets worse when the books record only the deposit. If $970.70 is booked as revenue, sales look lower than they were and the $29.30 processing cost disappears from the expense lines. The usual setup is to record the full sale and the fee separately. Confirm how your bookkeeper handles it.

    3. Cash Versus Accrual

    Under cash accounting, income counts when it is actually or constructively received. Under accrual accounting, it generally counts when it is earned, typically when the work is done or the goods are delivered, regardless of when the customer pays. A business on accrual accounting can show strong March revenue with little March cash, because the invoices are still open.

    Multi-month contracts, deposits, retainers, and milestone billing make this more complicated. Revenue recognition rules for those arrangements are a question for your CPA. Confirm your policy with them before you decide which revenue number a dashboard should show.

    4. Different Definitions

    The same word can mean different things to different teams. Take a signed two-year service contract. Sales may report the whole contract value as a win. Finance may record most of it as deferred revenue, to be recognized month by month. Operations may call the remaining work backlog. Each number is legitimate. They answer different questions, and a report that uses one without saying which will contradict a report that uses another.


    What Does a Monthly Reconciliation Look Like?

    A service business reviews March and finds three totals:

    SystemMarch totalWhat it measures
    Accounting software$52,700.00Revenue recognized in March: $48,200 paid by card plus $4,500 invoiced and still unpaid
    Payment processor$48,200.00Gross card charges in March
    Bank account$45,441.80Processor payouts that reached the bank in March

    The gap between accounting and the processor is the $4,500 in open invoices. It will turn into cash when those clients pay.

    The gap between the processor and the bank takes a few more lines:

    Bridge lineAmount
    Gross card charges$48,200.00
    Less refunds−$600.00
    Less processing fees−$1,697.80
    Net processor activity$45,902.20
    Plus balance not yet paid out on March 1 (late-February sales)+$2,950.00
    Less balance not yet paid out on March 31 (late-March sales)−$3,410.40
    Other balance activity (disputes, reserves, adjustments)$0.00
    Expected bank deposits$45,441.80

    The expected figure matches the bank total, so the month ties out. If the bank had shown $44,900, the unexplained $541.80 would be the thing to investigate.

    The bridge works because it follows the processor’s balance: what was waiting to be paid out at the start, plus the month’s net activity, less what was still waiting at the end, equals what was paid out. This example is deliberately simplified, which is why the “other balance activity” line is zero. A real month can also carry disputes and dispute fees, reserves or holds on the balance, failed or reversed payouts, taxes withheld, and account adjustments, and any of those changes what reaches the bank. Processors such as Stripe provide balance and payout reports that show these items, and each one earns its own line in the bridge.


    How Do You Stop Arguing About Which Number Is Right?

    Decide in advance which system answers which question, and write it down.

    QuestionSystem of record
    How much cash do we have?Bank
    How much revenue did we earn?Accounting software, under the policy your CPA confirmed
    How much did customers pay us, and how?Payment processor or POS
    How much work have we sold?CRM, booking system, or sales tracker

    Once each metric has a home, a dashboard can label the source beside every number: “Revenue (accounting, accrual)” or “Cash (bank, as of the 5th).” People stop comparing numbers that were never meant to match.

    This matters beyond the finance office. When two managers bring different revenue figures to the same meeting, the meeting turns into an argument about the data. After a few of those, people stop trusting the dashboard and go back to their own spreadsheets. Why Nobody Looks at Your Dashboard covers that problem in more detail.


    How Do You Reconcile the Systems Each Month?

    Step 1: Assign a System of Record to Each Metric

    Use the table above as a starting point. Keep the list short and share it with anyone who builds or reads reports.

    Step 2: Record Sales and Fees Separately

    Ask your bookkeeper whether card sales are recorded at the gross amount with fees, refunds, and chargebacks in their own accounts. If the books record only net deposits, you cannot see what processing costs you, and revenue is unlikely to tie to the processor’s report.

    Step 3: Reconcile on a Fixed Schedule

    Pick a day each month, after the books close, to match processor payouts to bank deposits. Use the processor’s payout report, which lists which transactions went into each deposit. Reconcile the same way every month so differences are easy to spot.

    Step 4: Keep a Simple Bridge

    Build the bridge from the March example in a spreadsheet: gross sales, refunds, fees, any other balance activity, the unpaid balance at the start and end of the month, and the bank deposits. Anything left over after those lines is what needs investigating. Once the monthly numbers tie out, they can feed a scorecard; How to Build a Monthly KPI Scorecard shows how to set one up.


    Is It a Timing Difference or a Real Problem?

    Work through these checks before assuming anything is wrong:

    • Does the gap match the balance waiting to be paid out? Compare it with the processor’s pending or in-transit amount at month-end.
    • Does the gap match fees? Divide last month’s total fees by gross charges to get your own fee rate, then see whether the difference is close to that share of sales.
    • Are refunds or disputes involved? Check the processor for refunds, chargebacks, and any reserve or hold on your balance.
    • Are both reports covering the same dates? Confirm the start and end dates, and whether each system uses the same time zone for its cutoff.
    • Is anything counted in one report and not the other? Look for open invoices, cash or check payments, sales tax, tips, or deposits for future work.

    If a difference remains after these checks, it deserves a closer look. Duplicate entries, a payout that never arrived, a sale recorded in the wrong period, and a missing connection between systems are all possible causes. Bring the bridge to your bookkeeper or accountant. It shows exactly how much is unexplained, which makes the conversation much shorter.


    Frequently Asked Questions

    Why doesn’t my Stripe total match my bank deposit?
    Stripe pays out your balance after fees and refunds come out, and it groups transactions into payouts on a schedule. A single deposit usually covers several days of sales, and the amount is net of costs.

    Should my systems match every day?
    No. Daily totals will almost always differ because of settlement timing. Monthly totals should tie out once you account for fees, refunds, and the balance still waiting to be paid out.

    Do I need an accountant to do this?
    You can build and review the bridge yourself. Questions about how revenue should be recognized, especially for contracts, deposits, or milestone billing, belong with your CPA.

    Can software do the reconciliation for me?
    Accounting tools such as QuickBooks and Xero can import bank transactions and suggest matches. Someone still needs to review exceptions and decide which system answers which question.


    Where to Start

    List every system that records money coming in, who has access, and what each one exports. The Small Business Data Audit Checklist walks through that inventory. With the list in hand, pick last month, pull the three totals, and build the bridge once. After the first month, the process gets much faster.