Chorilo Logo

Export membership & wedding anniversaries

Export membership anniversaries and wedding anniversaries for a year as Excel, CSV or PDF. The basis for honours and congratulations in your choir.

Web
Chöre›Chor›Chor-Einstellungen›Berichte

This feature is only available on the web.

Permission required: Reports & Exports – Export reports

What is this?

Under Reports there are two anniversary lists:

  • Membership Anniversaries: members who reach a singing anniversary in the selected year; suggested are 25, 40, 50, 55, 60 and 65 singing years. It counts the time in your choir from the entry date plus the previous choirs from the singing career.
  • Wedding Anniversaries: members who celebrate a wedding anniversary in the selected year; suggested are 5, 10, 20, 25, 30, 40, 50, 60, 70, 80, 90 and 100 years of marriage.

Every choir honours differently. You decide which years count before downloading.

How to export

  1. Click Ensembles in the sidebar, pick your choir and then Choir settings.
  2. Select Reports and then Membership Anniversaries or Wedding Anniversaries.
  3. Choose the Member Status: Active Members, Passive Members or All Members.
  4. Choose the Year.
  5. Check the years under Anniversaries at. Change a number, delete a row with the trash icon or add a new one with Add year.
  6. Choose the Format: Excel, CSV or PDF. Excel is preselected.
  7. Click Download.

If Wedding Anniversaries are missing under Reports, the Wedding Anniversary field is hidden under Choir settings > Member fields.

What the export contains

Membership Anniversaries: first name, last name, entry into current choir, anniversary reached (date), anniversary years, total singing years, email, phone, mobile phone, street, postal code, city.

Wedding Anniversaries: first name, last name, wedding date, years of marriage, email, phone, mobile phone, street, postal code, city.

Why the singing career matters

Membership anniversaries count singing years across all choirs entered. If a member's previous choirs are missing, only the time in your choir counts, and an anniversary shows up too late or not at all.

Permission

You need the permission Export reports.

Tips

  • Plan ahead. Pick next year to prepare honours early.
  • Check the entry date and singing career of new members.
  • Enter wedding anniversaries if members appreciate congratulations.

Frequently asked questions

Which anniversaries are included?▾
You decide. Suggested are **membership anniversaries** at 25, 40, 50, 55, 60 and 65 singing years and **wedding anniversaries** at 5, 10, 20, 25, 30, 40, 50, 60, 70, 80, 90 and 100 years of marriage. Under **Anniversaries at** you change, delete or add years, for example 10 or 15 singing years. Milestone birthdays are in the birthday list.
Do I have to enter the years every time?▾
No. Your browser remembers the selection for this choir. On another device or for another person the suggestions apply again. **Restore defaults** takes you back to the suggestions.
How far ahead can I plan?▾
You pick a calendar year: next year, the current year or one of the four years before.
Are anniversaries reported to the choir association automatically?▾
No, the report does not send anything by itself. You download it and pass it on wherever you need it.

Still have a question? Ask the AI help bot.

Click the help button in the bottom right and ask your question.