Club Management

Purposes in VVwin

The modern database for the sports club.

MEMBERS

• entering of the member's data (max. 9999 families + 9 members of the family for each Client)
  — every members of the family own an independent data sheet
  — when you click on 'Save and new Row' of the current membership status is displayed
• displays and edit of the member's data with form or in tabular form after any sort criteria, as a family also with divergent name
  — export as csv for transmitting on other computers and export as ldif for e-mail programs
  — automatic calculation of the IBAN values and mandate references
• entering and edit of the bank data for members
• entering and edit of the contact data for members
• entering and edit of the archive data for members and non-members
• entering and edit of the photo data for member cards
  
  
• printing the membership lists according to different choice criteria: Whole Club, new entries, divisions, age groups, employees
• printing the birthday lists for round birthdays and for all birthdays, of the function lists as well as the honour lists for the honourary needle and for the active needle
  
  
• members statistics of the whole club and the divisions, population pyramid, age structure for the local authority district as well as members inquest for the sports alliance
  — age groups and years statistics in the CSV, DAT and XML format
  — It the statistics data of the last ten years stand at the possession
  
  
• activity log, member's entries and member's escapes, passive members, newspaper list, mail list, contact list
• member cards with or without photo
• precast letters for admission, notice, exclusion
  — circular about rtf files
• circular, round messages, address adhesive labels and computer letter addresses according to different choice criteria
  
  
• single lists and statistics are saved while calling the menu items automatically or by choice 'file' as a formatted text file, formatted web page or as a csv file for the Excel import
• ... and all that at the touch of a button!

FEES

• automatic debit and credit booking for all members
  — to membership dues and departmental contributions are booked according to entry in the club stock either quarterly, half-yearly or yearly
• construction of DTA, ASCII and XML files for the fee indent (cash service), SEPA standard (Creditor-ID, Mandate reference and -date)
  
  
• displays of the fee data, fee statistics
• edit the debit and credit data, printing the debit and credit lists
  
  
• list printing of the debit amounts and the invoice amounts, printing debits and calculations, printing the fee lists, the direct payers, new entries, change lists
  
  
• to calls of the payment inputs by automatic shortcut to the accountancy
• computing of the debit balances, printing reminding letters
• precast letters for accounts, payments, remindings, invoices
  
  
• ... and all that at the touch of a button!

FINANCES

• entering of the booking entry data alternatively with automatic sales tax/pretax booking entry according to chart of accounts
  — chart of accounts to German Sports Association or more own
  — when you click on 'Save and new Row' of the current balance is displayed
• displays and edit of the booking entry data with form or in tabular form after any sort criteria
  — Import of bank statements in online banking
  — export as csv for transmitting on other computers
• construction of XML files for credit transfers and direct debits (Cash-Service)
  — SEPA is implemented
  
  
• printing the voucher and month lists of the bank and cash boxes documents (banks book, cash book), cash box lists, voucher balances, month balances
  
  
• printing the booking entry lists for accounts (account sheets) and cost centres, account balances
• cost accounting of sports divisions
• controlling of sport use and budget
  
  
• journal, trainer accounts, tax/pretax accounts
  
  
• annual:
  — cash report,
  — automatic profit and loss calculation for ideal area, sports area, business area and asset management,
  — final balance and opening balance sheet,
  — budget
  
  
• it the accountancy data of the last three years stand at the possession
• you must only account and enter, all other automatically goes
• ... and all that at the touch of a button!

SPORTS

• entering and edit of the training hour data
• entering and edit of the event data
• construction of DTA and ASCII files for trainer and janitor transfers (cash service)
  
  
• printing trainer hours, hall hours and trainer hours
• printing the training plan and the hall allocation
• printing events and the schedule
  
  
• trainer costs, janitor costs
• cost accounting of sports divisions
• controlling of sports use
  
  
• single lists are saved while calling the menu items automatically or by choice 'file' as a formatted text file, formatted web page or as a csv file for the Excel import
• ... and all that at the touch of a button!

CLUB DATA

• entering, edit and printing the stock data
  — to the stock data names and keys belong for divisions (max. 99, 5 per Memb.), banks (everybody in Germany), Club fees (max. 999999) and division fees (max. 5x999999), honours (max. 99, 9 p. M.), functions (max. 99, 9 p. M.), accounts (arbitrarily), cost centres (max. 99), gymnasiums (arbitrarily), streets (everybody in the place), trainer (arbitrarily) and trainer licenses
• as well as to you with bank code number and accounts is known, proceed also with all other stock data: You select by the name, however, in the members or finance tables only the keys are saved, the names stand in own stock data tables – as it is proper for a relational database! If something changes in the stock data, e.g., the fee set, you must change only the key (amount) and nothing in the members and fee data
  
  
• edit of the club stock with entries to the Club
• user administration for up to 10 users with password, Client and module allocation and choice of languages
• edit of the client stock for up to 5 Clubs with own Club stock and own stock data
  — Clients can be, e.g., a bigger division of the Club with own accountancy, the conveyor association or several Clubs with common office
  — you can administer the Clients from different computers, as long as these are in the network interlocking and the database is on one computer, as a server acted
  
  
• enter and edit the language files of your desired language, available are german, dutch and english. Languages are associated to the users! You can progress your language yourselves
• database: backup and pack of the database, version update, recovery dots
• turn of the year
  
  
• tools: change book, log book, version book, export and import of data from / into the database about csv files, report generator with SQL query, themes by users and program modules
  — Query Builder for the import of data from other programs
  — Data Protection Book according to EU-DSGVO
• ... and all that at the touch of a button!

Club
Management
© Dr. Hartmut Braun, Karlsruhe

Home

Characteristics

Purposes

News