ideas on how to monitor pay and play gym users with basic software?

Question

how to track pay and go gym users efficiently without complicated computer software ,how many visits they make a month for example

Answer 1

If you already have Access or another database application handy, you could do it like this. If you are dealing with a really small group (<100 users), you could do this in a spreadsheet (with tabs in the workbook replacing tables).

The key thing is to have a field to capture any piece of data you will need later. If you do that right, you'll be able to set up a bigger, badder system later by just exporting all your existing data history up to the new application.

Table 1: Member Table
FIELDS: Member#, Name, Address, PlayRate$, Key dates (billing, join, last use), etc

Table2: Activity Table
FIELDS: Member#, Activity-Date, Notes, BilledFlag, pd flag

So, anytime someone comes in, you add a record to the activity table. When you bill a group, you mark it on the billed flag. If they pay as they come in, you mark it billed & paid.

Answer 2

Why not set up a spreadsheet in Excel?