HaloPSA reporting for MSPsGet the pack

Neuu / HaloPSA reporting

HaloPSA reporting, without the guesswork.

Free, tested SQL reports and schema notes for MSPs running HaloPSA. Paste into a Custom SQL Query and go. Runs inside your own Halo, so no third party ever sees your data.

Download all 7 free

Guide

Setting Up HaloPSA with ChatGPT or Claude: the Questions to Answer First

How to use ChatGPT or Claude to configure HaloPSA: the setup order, the business questions to answer first, a copy-paste prompt and rules for AI browser agents.

Read

Free SQL

HaloPSA Unbilled Time Report: Find Billable Work That Was Never Invoiced

Free HaloPSA SQL report: closed tickets with billable time logged but no invoice, last 90 days. Find billing leakage fast.

Read

Free SQL

HaloPSA QBR Report: Ticket Volume by Client and Type

Free HaloPSA SQL report for QBRs: ticket volume per client, per ticket type, per month for the last 6 months.

Read

Guide

Using ChatGPT or Claude to Write HaloPSA SQL Reports

How to get ChatGPT or Claude to write working HaloPSA custom SQL reports: the schema context and Halo parser rules to paste in first.

Read

Guide

HaloPSA SQL Schema: the tables and columns that matter

A practical map of HaloPSA's database for custom SQL reports: FAULTS, ACTIONS, AREA, UNAME and the joins between them.

Read

Guide

HaloPSA Custom SQL Report Errors

Fixes for HaloPSA custom SQL report errors: Invalid SQL Statement, ORDER BY clause is invalid, Operand data type bit is invalid.

Read

Free SQL

HaloPSA Stale Tickets Report

Free HaloPSA SQL report: open tickets with no activity for 5+ days, by client and agent.

Read

Free SQL

HaloPSA Agent Utilisation Report

Free HaloPSA SQL report: hours logged per agent in the last 30 days as a utilisation percentage against a target you set.

Read

Free SQL

HaloPSA Billable vs Non-Billable Hours Report

Free HaloPSA SQL report: billable and non-billable hours per agent for the last 30 days, with billable percentage.

Read

Free SQL

HaloPSA Unassigned Tickets Report

Free HaloPSA SQL report: open tickets older than a day with no agent assigned, including the 'Unassigned' placeholder agent.

Read

Free SQL

HaloPSA SLA Breach Report by Client

Free HaloPSA SQL report: SLA resolution breach count and breach % by client and urgency, last 30 days.

Read

The pack

All 25 reports, one payment

SLA, utilisation, client profitability, billing leakage and QBR packs, plus the full schema cheat sheet and dashboard recipes. Free updates.

Get it for £79

New: the AI kit

Set up HaloPSA with ChatGPT or Claude

100 setup questions in the right order, 11 prompts that stop the AI guessing, and the rules for letting an agent click through Halo safely.

Get it for £39