First week of the month
The account manager has eight client contracts. Each expects a monthly service report: hours delivered against contracted hours, patrols completed, incidents and how they were handled, training and inductions, staff changes on site, and any issues raised. Some contracts set out the measures the report must show.
To build each one, she exports hours from the rota system, downloads patrol summaries, searches her inbox for incident reports, checks the training spreadsheet, and asks supervisors for anything else. Then she pastes figures into last month's slide deck and updates the charts. Eight clients, most of the first week. And one client always asks why the numbers do not match their own records.
Then there are the quarterly reviews, where the same client wants three months of trends in a different layout, and the contract renewal, where the procurement team asks for a year of performance against every measure in the specification. Each of those is another assembly job from the same scattered sources, done under pressure because the review date was set months ago.
Why the report is so manual
The data exists, but it lives in several systems, none of which knows what each client's contract says the report should contain. Every report is a custom assembly job, and every figure is copied by hand.
| Report section | Where the data lives | Typical effort |
|---|---|---|
| Hours delivered | Rota or time and attendance system | Export, filter by site, total |
| Patrols completed | Patrol system | Download, count, compare with schedule |
| Incidents | Emails and Word reports | Search, summarise |
| Training and inductions | Spreadsheet | Filter by site |
| Staff changes | Memory and the rota | Work out who was new |
What it costs to do by hand
Account managers should be spending their time with clients, spotting issues and finding opportunities, not building slides. Manual reports have copying errors that undermine trust when a client spots them. Reports go out late in the month, so any problem they show is already old. And reports vary in quality between account managers, which clients notice when they compare notes.
Client reports that assemble themselves
- Each client's report template is set up with the sections their contract calls for and the measures they care about.
- Hours delivered and contracted are read from your rota or time and attendance system.
- Patrols scheduled and completed are read from your patrol system.
- Incidents are pulled from your incident reporting, with type, date and a one-line summary of each.
- Inductions and training for guards on the client's sites are read from your records.
- The report is produced as a PDF in your branding, or as a live dashboard the client can log into, or both.
- The account manager reviews the figures and writes the commentary: what went well, issues, actions. An AI model can draft commentary from the data for her to rewrite, if she wants.
- Figures are consistent across clients because they are calculated the same way.
- Any figure can be traced back to its source records if a client queries it.
- Reports can be produced on the first working day of the month.
The first week of the month, now
On the first working day, eight draft reports are waiting. The account manager checks each, notes an incident that needs more context, writes commentary and sends them out. When a client queries a figure, she can show the underlying shifts or patrols. The rest of the week goes on client visits and the contract renewal that is coming up.
Some clients prefer a live dashboard to a monthly PDF. Both can come from the same data.
Quarterly reviews and renewals get easier in the same way. Because the figures are stored month by month, a trend over a quarter or a year is a different view of data you already hold, not a fresh exercise. When a guard's hours are corrected in the rota after the report has gone out, the change is visible, so the account manager can decide whether to reissue rather than finding out when the client compares totals.
Do your client reports look like this?
- Monthly reports are built in slide decks by hand.
- Data is exported from several systems each month.
- Clients query figures and they take time to check.
- Reports go out well into the month.
- Each account manager's reports look different.