SuperCRM provides you with the opportunity to run complex filters on your databases to identify. extract information, and communicate with membership subsets. In addition to these filters, you can run some standardised reports to identify members that may require administrative action.
To access these reports, click Reports on the top bar of the SuperCRM dashboard.
A list of the reports that are available to your organisation will appear. By default, you will see two reports:
Potential duplicates
This report provides a listing of any people that share the same First Name and Last Name, and provides an interactive link to allow you to merge/link two people together if you determine that the two records are the same person.
Sporty automatically links people together if enough personal details match, but this report will display people that do not have enough matching parameters for an automated match.
To run this report, click Potential duplicates then click Send.
The report will display two or more lines for each person the system has identified as a potential duplicate. The person's First name, Last Name, Date of Birth, Email, Address, Phone 1, and Phone 2 will be displayed to allow you to check if any of the values match to allow you to confirm if each instance relates to a single person.
When clicking the link, you will be asked to confirm which values you want to keep. Select Merge (Clubs and Schools) or Link (RSOs/NSO's) to confirm the action, and merge the two records into one person.
Select Not a duplicate if you have identified the person are in fact two distinct people. This will ensure the people will no longer appear on your potential duplicate reports.
Debtors report
This report provides a listing of all people that have an outstanding balance associated with any registrations they have submitted.
To run this report, click Debtors report, then select the Season/s, Organisation Form/s, and registration date period you wish to run the report against, then click Send.
This report will display the Person's Name, Person ID, Registration Reference, Transaction Reference, the form that is linked to the outstanding payment, the date of registration, and the amount Payable, Paid and Balance Owing. If the form has grades and teams associated to it, the Grade and Team of the Person will also be displayed, allowing you to provide team managers with a list of members with outstanding payments due.
Note: Additional bespoke reports can be generated as standardised reports for your organisation. There will be a development fee to populate these reports to your specifications. Please complete this form for further information.
Audit History
This report will capture all changes made in your organisations database. This will include changes made in clubs managed by your organisation.
To run this report, simply click Audit History and enter the date range you wish to check for changes. To prevent information overload, this date range is restricted to a 1-2 day period. If you wish to check for changes across a wider range, multiple reports can be run.
You will soon receive an email containing your report.
The report will read as follows
- Person ID: - The unique identifier for the individual who was changed.
- Person First/Last Name: - Their First/Last Names.
- Changed Date: - When the change occurred.
- Changed By: - Who made the change (i.e. which administrator or "End user" if the change was made by the individual themself).
- Event: - Whether the change was newly created or a modification to existing information.
- Old Value: - The information saved before the change.
- New Value: - The information saved after the change.