This feature allows you to view and manage your Attendance & Payment information
First you will need to setup and/or check the options for this module
- Especially you will need to set the "Start" and "Current" period.
- The "Start" period indicates the first period that you would like to analyse and manage
- The "Current" period will initially be the same then move on each month and is usually the previous "Full" month.
- The "Selected" period will initially be the same, but allow you to change this to view past periods.
- You can set the default Fee for each session
- This can be individually set for each Session if different once you have set the default
- You can set a different fee for "Visitors" and a "Reduced Rate". This will be used if the Members "Pay Status" is set to "Visitor Rate" or "Reduced Rate" accordingly
- The limits are used for Reporting purposes and giving players a "Payment Status"
- Important, you will need to choose how you identify "Players" in your payment system,
- Usually it will be by "EBU" no.
- You may have set up Online Banking with "ClubId" as the reference
- Your payment system may report by Email
- You may asked your players to use Online Banking and use Name as reference
- Or you can use a separate "Pay Reference", but it is not necessary to duplicate the other entries
- You can click on a line in the "Summary" or "Players" list to view the detail and then manually override a Players Rate for the Session.
Once you have set up the options, Bridgewebs will automatically scan all uploaded results for the periods chosen and you can view the current status of the Attendance module.
Next, you will need to ensure that your Membership database is set up with the appropriate references.
- If one Player pays for another Player, then you can set their "Paid by Partner Reference" to the Pay Reference of the partner.
- This applies whatever field you use to match payments e.g. If you use the EBU Number, e.g. Mary pays for John
Name1 |
Name2 |
EBU |
Paid by Partner Reference |
John |
Jones |
277288 |
672772 |
Mary |
Jones |
672772 |
|
Finally, you can "Upload" csv format payment files received from your banking organisation.
Use the [Browse] (may be different words depending on Browser) buttons to find the file and [Open]
Once you have opened and uploaded the file, Bridgewebs will allow you to match which columns on the import file match to the required Bridgewebs fields.
- Bridgewebs requires 3 bits of information (fields), Date, Pay reference, Amount
- You can set the columns to match Bridgewebs fields and others will be ignored
- Bridgewebs will validate the data and match the payment reference to the Membership database
You can also upload other files such as Subscriptions or Adjustments( Debit or Credit)
CSV File from Banking Organisation
We have found that Csv files from Banks tend to group all references into one Description field, separated by a ','. e.g.
Bridgewebs will try EACH element in the Description field to match to your chosen Member Reference field
You can set your options with prefixes to ignore in the matching process, e.g. EBU,REALBRIDGE
|
|
|
|
|
Date |
Type |
Description |
Value |
Balance |
|
|
|
|
|
08/12/2020 |
BAC |
'MRS SHEILA JONES, EBU 12345 , FP 08/12/20 1555 , 00156522632BFRVGYQ |
20.00 |
420.00 |
07/12/2020 |
TFR |
'03DEC019 00040 , REALBRIDG 617711 , PAID WITH RECOUR , SE , CHQ NEGOTIATION |
16.00 |
400.00 |
As an alternative, you could set the Pay Reference field on the Membership to the Reference provided by the player, but you will need to do this for all players.
|