The Sportlyzer Blog

We write about sports coaching, club management, training, and our software updates.

Software update: Excel reports for invoices, debtors, attendance and archived players

August 10, 2018 - Posted by

We’ve added quite many Excel reports and fine-tuned some of the existing ones.

Invoicing:

  • Excel reports of player profile data include pre-payment, debt and balance
  • Invoices and debtors reports available in Excel (XLSX) format
  • Debtors Excel reports available by invoices or by people
  • Invoices Excel report includes paid/unpaid amounts, groups, etc.

Other:

  • Attendance Excel report separates training, event and competitions
  • Download archived players to Excel

Excel reports for invoices, debtors, attendance and archived players

 

1. Excel reports of player profile data include pre-payment, debt and balance

You can now download the full player list with everyone’s profile data as well as with pre-payment, debt and balance. This means that all related information about a player can be accessed from one Excel file. This is useful when registering for a tournament, organising training camps, getting a birds-eye-view of your club, etc.

You can access this report from two places:

  1. Players -> Select required players -> Export -> Full export
  2. Reports -> Players report

 

2. Invoices and debtors reports available in Excel (XLSX) format

You can now download different invoicing reports to XLSX file format (only CSV was available until now). This makes it easier to handle the reports without needing any specific Excel skills.

Invoices Excel reports - Sportlyzer

 

3. Debtors Excel reports available by invoices or by people

Some time ago we added the “People” view in the Debtors page. Now you can also download these people to Excel for a more thorough analysis.

Excel reports of debtors - Sportlyzer

 

4. Invoices Excel report includes paid/unpaid amounts, groups, etc.

We have updated the invoices report to include:

  • Invoice type (group, project, single)
  • Group/project name
  • Payment status
  • Paid amount
  • Due amount

Hopefully, this will give you a better overview of your invoices and will give you an opportunity to easily understand how your groups or projects are performing.

 

5. Attendance Excel report separates training, event and competitions

We added new columns to the attendance report in Excel to include specific data about training, event and competition attendance. This will give you a better overview of how each of these event types is performing.

 

6. Download archived players to Excel

You can now download all of your archived players to Excel before deleting them fully from Sportlyzer.

Excel report of archived players - Sportlyzer

 


Sportlyzer is an award-winning team and training management software for youth and amateur sports. Log in or sign up now!

Sportlyzer - Sports Technology Awards 2016 winner

Jaan Saks

Jaan is the CEO of Sportlyzer and has been involved in sports for his whole life. He has been part of the Estonian speed and inline skating teams, winning various national and international championships. He has coached kids, juniors and adults and has co-founded his own amateur skating team. Besides his athlete and coach career, Jaan has co-started various successful sports events and is still organizing them today as a hobby.

More Posts


Need help? Contact us now