Reports Overview

There are 24 different reports available to you, with each of these being able to be further refined and customised using report options and column filters. A majority of our reports can be printed or exported to either PDF or Excel. This is a brief overview of each of these reports to help give you an idea of what each one might be used for. 

Activity

The Activity report is a robust report that includes four different tables within the report results (Appointments, Sales Without Appointments, Payments and Payments Reconciliation). Most commonly, this report is used for end-of-day payment reconciliation, however it can also be useful for getting an overview of sales for a period and the like. The report itself shows gross sales for all appointments that have services assigned to them. Appointments are displayed if their start date is within the specified date range. You can also use this report to predict future sales. The total outstanding payments figure displays the value for all appointments that haven't been received.

Client Reports

Appointments Somewhat self-explanatory, the Appointments report will show you a list of all individual client appointments in the account, filtered by the criteria that you define (date range, referrer source, location, diary, appointment status). 

Birthdays A basic utility report that shows cients who have a birthday that falls within the selected date range. 

Statistics A handy report for generating a list of clients that fall into certain demographics (you can look at client types, gender, status, age etc.)

Classification Generate a list of clients depending on their client classification or classifications. This report has a filter to refine the client list depending on when the client was added to your Power Diary account, so you can look at recent clients, or all clients. 

Client Retention See appointment numbers over a clients lifetime. A clients lifetime is based on the date that the client record was created to the point at which they have no future appointments booked. This is defined using the start and end date filters. The client retention report uses a 'client lifetime' metric to generate the list. This is defined by the date of a client's first appointment to the point at which they have no future appointments booked. This means that the start and end date filters find all clients who have their first appointment on or after the start date but have no further appointments booked after the end date. 

Referral Expiry This report will show you all clients who has a referral expiring within the specified date range. You are able to further refine the results using the diary filter if need be. 

New Clients The New Clients report is useful for generating a list of your new clients. The report can either be generated to look at the client's first appointment as the metric or the date that they were added to the system.

Inactive Clients This report will allow you to generate a list of clients who are deemed as inactive in the system. The metric used for this is whether or not they have had an appointment since the date that you specify. 

Membership Expiry The Membership Expiry report will give you a list of clients who has a membership on their client record set to expire within the date ranges you define. 

Appointment Count This report gives you the ability to find clients who have had a cerain number of appointments in a given period of time. The report includes a diary and client type filter for extra granularity. 

Client Sources The Client Sources report will break down of where your clients are coming from. The report uses the 'how-heard' field on a clients record to determine this. It will also show you how much has been billed to these clients, giving you an idea of what marketing sources are performing will and which aren't. 

Financial Reports

Invoices & Payments All of your invoices filtered by invoice or payment date. This report is great for getting an overview of your invoicing for a specificed period of time, and has diary, sale to, location and payment status filters. 

Sales The Sales report is a great report for giving you an overview of your sales. The report has the same filters as the Invoices & Payments report but the results are more appointment-specific. 

Accounts Receivable This report will show you your receivables as of the specific date and who each amount is payable by. 

Aged Receivables Similar to the Accounst Receivable, but this report will give you an aged break down, showing you which accounts are in arrears as of 30, 60 or 90 days. 

System Reports

Deleted Appointments The Deleted Appointments report is a handy utility report when looking for an appointment that has gone missing. The report will show you a list of appointments that were scheduled for the given time frame that have been deleted (click Show Log in the far right column to see a detailed breakdown of when it was deleted and by which user). 

SMS Usage This report will give you a breakdown of the SMS usage within your account for the specified date range. 

Recurring Expiry This report is used to generate a list of recurring appointments that are set to expire after the given date. You can run this report for client appointments, group appointments or for group participants. 

Export Appointments This report generates a list of appointment data that can be exported to CSV. This is handy if you're wanting a backup of your appointment data.

Marketing Logs This report shows you a break down of all marketing campaigns sent through Power Diary within the specified date range.

Recent Referrals This report summaries all referrals that have been made within the specified date range. You are able to filter this on a per-diary basis if need be. 

Inactive Referrers This report will show you all referrers who haven't referrer a client within the designated date range. 

Pack Expiry This report will display all clients who have a session pack that expires within the specified date range. You can further refine this report by using the created from date ranges, product, status and diary filters or looking for packs with a particular number of sessions remaning. 

Reporting FAQs

Which report will show me who my best or most consistent referrer is? The Recent Referrals report is best for this. If you wanted to see your most consistent referrer for the past year simply set the date range for the last 12 months. You can then sort the report by the 'billed' column to see which referrers have brought in the most money to your business. The number in brackets next to the referrers name such as: (8) - indicates the number of clients that referrer has referred. 

Which report is best for payment reconciliation? The Activity report has a payments reconcilation table at the very bottom which is perfect for this.

Where to next?

Theres more to reporting! Check out some of our articles below for a more in-depth look.