Security Guard Company monthly financial report
A security company report should compare hours paid to hours billed. Any gap is margin leaking out as overtime or unbilled shifts.
The six numbers for a security guard company
| Number | How to work it out | What it warns you about |
|---|---|---|
| Hours billed against hours paid | Billed hours ÷ paid hours | Unbilled shifts and training time |
| Overtime, share of payroll | Overtime pay ÷ total guard pay | Open posts covered at time and a half |
| Days to collect | What clients owe ÷ monthly revenue × 30 | Slow payers stretching your payroll |
| Payroll, share of revenue | Guard and supervisor pay ÷ revenue | Bill rates falling behind wages |
| Largest client, share of revenue | Their billing ÷ revenue | Concentration risk |
| Weeks of payroll in the bank | Cash ÷ weekly payroll | How long you could carry a late client |
Use these six in place of the general ones on the template's Report tab.
What to watch in a security guard company
- Overtime rising to cover open posts
- A new contract that needs guards before it pays
- Property managers paying past 60 days
Not sure how much cash you should hold? Use the security guard company cash calculator.
Get this done for you every Monday
One Page CFO reads your QuickBooks, builds your 13-week cash forecast and your one-page report, and a CFO checks both. $500 a month.