Member

Introduction

The Member Master records essential information about Members, including their personal details, contact information, membership details, and renewals.

Member Mst Features

• Create New
• Member Type (Shows Member Code and Member Type Name)
• Link to Service GroupFeature Mention Below
• Export To Excel
• Supplemnetary DetailsFeature Mention Below

Mandatory Fields

Mandatory Fields
Title - Mr, Ms, Dr etc
Member Name Validation - Member Name needs to be 100 characters only.
Date of Birth Validation - Age must be 5 years or above
Gender - Male, Female, Other. Validation - Gender and Title must match
Wing Validation - Wing must be 3 characters only.
Building No Validation - Building No must be 3 characters only.
Society / Building Name Validation - Society / Building Name needs to be 50 characters only.
Flat No Validation - Flat No must be 4 characters only.
Area Validation - Area must be between 0 - 999999 only.
Pin Code Validation - Needs to enter valid pin code.
Mobile No Validations - Duplicate Mobile No. Please Check - Mobile No needs to be 10 - 12 digits. - Mobile needs to be a valid.
Email Validation - Please enter a valid email address. - Duplicate email, Please Check
GSTIN Type Validation - “Please enter a valid GSTIN Number - GSTIN is already in use - GSTIN Code needs to be match with state code or entity state code.
GSTIN No
Member Type - Select from Member Type Master
Admitted On Validation - Future Dates are not allowed - Admitted On can not be 15 days before today’s date
Valid Upto Validation - Date can not be beyond one year - Valid upto may not be before or same the admittedon
Batch - NA, Ladies, Unisex etc. Validation - Batch cannot be Not Applicable.

Optional Fields

Optional Fields
Alternate Address - Address needs to be 50 characters only.
State Name - Maharashtra, Andra Pradesh, etc.
City
Pincode
Contact No Validation - Contact No needs to be 8-12 digits only - Duplicate Contact No. Please Check
Notes Validation - Notes must be 300 characters only.

Features

Features
Create New
Modify
Delete Validations - Master Record is live. You may not delete it - Transferrer / Transferee member records may not be deleted
Invoice Upto - Current Invoice Up to - Changed Invoice Up to Validation - Notes need to be relevant.
Renew Membership Fields Member Name readonly Valid Upto readonly Re-Admission Date Validation - Back-Dated Renewal is not allowed - Re-Admission Date should be after Valid Upto Date - Re-Admission Date may not be 1 year after Re-Admission Upto Date Re-Admission Upto Date Validations - Renew Upto should be after Re-Admission Date - Renew Upto Date may not be less than 15 Days - Renew Upto Date may not be 1 year after Re-Admission Date
Upload Membership Form Select File - Select file in PDF format. Validation - Size of Pdf File can not exceed 250 KB
Re-Upload / Download File
Other Operations
Other Services
Make Invoice Cum Receipt Fields Member NameReadonly DateReadonly Member Type Readonly Invoice Upto DateReadonly A. Outstanding As per System Readonly B. To Be BilledReadonly C. Not Yet DueReadonly D. Advance For Full YearReadonly E. Recommended AmountReadonly Amount Being Paid Now Deposit in Bank / Cash A/c Mode of Payment Cheque No(Only For Bank) Cheque Date(Only for Bank) Drawn On (Only for Bank) Notes Validations - Cheque Date Must be between financial year start date & end date. - Amount must be between 1 - 9999999.99 - Service Group Name needs to be selected - You may not use this group as service amount is 0 - Generate interest invoice / Multiple Invoice are in progress please try after some time. - Multiple Vouchers are in progress please try after some time. ℹ️ To qualify for 1 month free usage of facilities.(System will show actual pay amount for 1 month free service.)
Print Statement

Features in Other Operations

Features
Resume Invoicing
Update Invoice Upto Fields - Member NameRead Only - Change Invoice Up To - Notes Validations - Notes needs to be fill and must be relevent.
Suspend Member
Ceased Member
Surrender Member
Amend Member Info Fields - Member Id Read Only - Member Name Validations - Member Name needs to be filled - Duplicate Member Name. Please Check - This operation is not allowed as there is an outstanding Amount - Type of Member Read Only
Transfer MemberShip Fields - Member Id Read Only - Transferee Member Validations - Member Name needs to be selected - This operation is not allowed as there is an outstanding Amount - Type of Member Read Only

Other Services

Make Invoice / Receipt
Member Name
Date
Member Type
Service Group - Select from Service Group Master
Deposit in Bank / Cash A/c - Select from Bank Master
Mode of Payment
Cheque No (Only for Bank)
Cheq Date (Only for Bank)
Drawn On (Only for Bank)
Validations - Cheque Date Must be between financial year start date & end date. - Service Group Name needs to be selected - You may not use this group as service amount is 0 - Generate interest invoice / Multiple Invoice are in progress please try after some time. - Multiple Vouchers are in progress please try after some time.

Member Linked Service Group Modify Fields

Fields
Member Name Read only
Service Group

Supplementary Details

Feature
Joint Members
No Objection Certificate
Nomination Register
Parking Slot Master
Visitor Register
Share Info

Joint Member Features

• Create
• Export to Excel
• Delete
• Modify

Joint Member Create Fields

Fields
Member Name
Joint Member Name Validations - Joint Member Name already exist. - You may not add more then 5 Joint member for single Member
Joint Member Address

NOC Features

• Create
• Delete
• Modify
• Print

NOC Mandatory Fields

Mandatory Fields
NOC Type User Have to Select then it will redirect to create page
Member Name
Residing Member Name Validations - Needs to be filled
Relation with Member Validations - Relation with member needs to be filled
Residing From Validations - Future dates are not allowed.
Notes Validations - Notes needs to be filled
Renovation Starting From
Renovation Details
Deposite Details
Purchaser Name
Other Purchaser Name
Purchaser Address Validations - Address needs to be filled
Other Purchaser Address
From Date Validations - Future dates are not allowed.
Talent Name

NOC Optional Fields

Optional Fields
Relation with Member

Nomination Register Features

• Create
• Export To Excel
• Update Registered Status
• De Activate Nomination
• Nominee Index
• Delete
  - Inactive/Registered nominations may not be modified/deleted
• Print
• Modify
  - Inactive/Registered nominations may not be modified/deleted

Nomination Register Create Fields

Mandatory Fields
Member Name Validations - An active/registered nomination is already available for this member
Nomination Date Validations - Futures Dates are not Allowed
Witness 1 Name Validations - Witness names cannot be duplicate.
Witness 1 Address
Witness 2 Name
Witness 2 Address Validations - Witness Address cannot be duplicate.

Nomination Register1 Features

• Create
• Modify
• Delete

Nomination Register 1 Create Fields

Mandatory Fields
Nomination NoRead Only
Member Name Read Only
Nominee Name Validations - Nominee Name can be up to 100 characters..
Nomine Address Validations - Nominee Address can be up to 200 characters..
Nominee Relation Validations - Nominee Relation can be up to 50 characters..
Nominee Percent Validations - New nominee share percentage may not exceed balance share percent
Is Minor
Date Of Birth Validations - If nominee is minor, age must be less then 18 years
Guardian Name Validations - Guardian Name can be up to 50 characters..
Guardian Address Validations - Guardian Address can be up to 200 characters..
Guardian Relation Validations - Guardian Relations can be up to 50 characters..

Parking Slot Master Features

• Create New
• Modify

Parking Slot Master Create Fields

Fields
Type of Parking Validations - Type of Parking needs to be selected
Slot Name Validations - Slot Name needs to be filled
Notes

Parking Allotment Master Features

• Create New
• Modify

Parking Allotment Create Fields

Fields
Member Name Validations - Member Name needs to be selected
Slot No Validations - Slot No needs to be Selected
Alloted From DateBy default today's Date

Visitor Register Feature

• Create
• Visitor Report

Visitor Register Create Fields

Fields
Visitor Name Validations - Visitor Name needs to be filled
Contact No Validations - Contact Name needs to be filled
Visitor Address Validations - Visitor Address needs to be filled
Reason For the Visit Validations - Visitor Address needs to be filled
Member Name Validations - Member Name needs to be selected

Share Info Features

• Create
• Modify
• Delete

Share Info Create Fields

Fields
Member Name Validations - Member Name needs to be selected - Share Info is already exist for this member.
Occupations
Property Registration No
Receipt No
Receipt Date
Share Issue Date
Share Cretificate No Validations - Share Certificate No needs to be between 1 - 1000 - This Share Certificate No. already exists for another member - Please specify shares per member in entity mst
Share Amount Validations - Amount needs to be between 1 - 999999
Share Start No Validations - Share start No must be between 1 - 5000
Share End No Validations - Share End No must be between 1 - 5000

More Details about Make Invoice Receipt

MAKE INVOICE / RECEIPT

Helps to generate Invoice / Receipt against payment of Outstanding or services of different type of Members (Subscription / full year, Walk-In Customers, Activity Organizers)

• Subscription /Full Year: Those members who is life members and contribute for a certain period for these services like Basic services, Parking services, etc.

• Walk-In Customers: Those members who is not Life members come only for particulars services for temporary period like Swimming Coaching, Gym Coaching, Badminton Coaching, etc. Tariff rate decided already for these services.Invoice will generated on Tariff Rate.

• Activity Organizers : Those members who contribute for an organize various an activity like Dancing, Karate, during vacation yoga classes etc. They will pay Ad Hoc amt there is no fixed amt for this services. Invoice will generated on Receive Amount.

SUBSCRIPTION / FULL YEAR Details of all available fields for calculating payable amount.

1.Actual Invoiced Upto Date : Last date of availing the services 2.Target Date : Current Date / System Date 3.To Be Billed Amount : Difference of months between Actual Invoiced up to date to target date * Tariff rate 4.Not yet Due : - If To Be Billed Amount greater than or equal to Tariff rate than Not yet Due =0. - If To Be Billed Amount 0 and there is O/S than Not yet Due =Tariff - If O/S is 0 or equal or less than Tariff amt than Not yet Due=O/S amt - If both O/S and To be billed is 0 than Not yet Due=0

5.Advance for full year : Subscription amount for a year (Tariff rate* 11 Months)+ 1 Month free 6.Recommended Amount : Outstanding Amt + To Be Billed Amount - Not yet Due + Advance for full year 7.To be Invoiced Amt : Receipt Amt - O/S amt 8.Calculated month after Actual Invoiced Upto Date : To be Invoiced Amt / Tariff rate ( let Tariff rate=550) 9.Calculated Invoice upto Date : Actual Invoice Upto Date + Calculated month ( If calculated months become in this format 11.61 than 0.61*30.5 = 19 days means 11 month 19 days)
10.Finalize Invoice upto Date : Invoice Upto Date + 11 month 19 days and & If Receipt Amt - O/S - To be billed + Not yet due is greater than or equal to advance full year amt than 1 Month subscription free.

Process of Calculating Payable Amount under the different type of case of different types subscriber.

SUBSCRIPTION / FULL YEAR

Case A : Over Due Outstanding

Example : let Tariff rate per month = 550

          Actual Invoiced Upto Date : 30-Jun-17
          Target Date : 30-Jun-22
          A.Outstanding Amount : 26813
          B.To Be Billed Amount : 33000 (60 Months * 550)
          C.Not Yet Due : 0 (To Be Billed Amount greater than Tariff)
          D.Advance for Full Year : 6050 (11 Months * 550) + 1 Month free
          E.Recommended Amount (A+B-C+D) : 65863

Case 1 : Receipt Amount equal to Recommended Amount : 65863

         To be Invoiced Amt : 39050 (Recommended amt - O/S amt)
         Calculated month after Actual Invoiced Upto Date : 71 (39050/550 for calculating remaining months for services)
         Calculated Invoice Upto Date : 31-May-23 (Actual Invoice Upto Date 30-Jun-17 + 71 months)
         Finalize Invoice Upto Date : 30-Jun-23 (65863-26813-33000+0=6050, 6050=Advance full year amt, 1 month subscription free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S Amt = 25000

           To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S
           Future O/S Amt =1813(25000-26813)
           Calculated Invoice Upto Date : 30-Jun-17

Case 3 : Receipt Amount Less than Recommended Amt but greater than O/S = 30000

           To be Invoiced Amt :3187 (Recommended amt - outstanding amt)
           Calculated month after actual Invoice Upto date : 5.79 (3187/550)
           Calculated Invoice Upto Date : 24-Dec-17 ( Invoice Upto Date 30-Jun-17 + 5 Months and 0.79*30.5 = 24 days)
           Finalize Invoice Upto Date after Incentive : 24-Dec-17 ( 30000-26813-33000+0= -29813, less than 6050,No 1 month free)

Case 4 : Receipt Amount Paid Greater than Recommended Amt = 70000

To be Invoiced Amt : 43187 (Recommended amt - outstanding amt)
Calculated month after actual invoice date : 78.52 (43187/550)
Calculated Invoice Date : 16-Jan-24 ( Invoice upto date 30-Jun-17 + 78 Months and 0.52*30.5 =16 days )
Finalize Invoice Upto Date after Incentive : 16-Feb-24 (70000-26813-33000+0=10187, greater than 6050,1 month free)

CASE B : Actual Invoiced Upto Date is equal to Target Date and O/S greater than tariff

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : 1650
B. To Be Billed Amount : 0 ( Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 550 ( To Be Billed Amount = 0, & O/S > tariff rate )
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 7150

Case 1 : Receipt Amount equal to Recommended Amt : 7150

To be Invoiced Amt : 5500 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 10 (5500/550)
Calculated Invoice Date : 30-Apr-23 (Actual Invoice Upto Date + 10 Months)
Finalize Invoice Date after Incentive : 31-May-23 ( 7150-1650-0+550=6050, equal to 6050, 1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S : 1500

  To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S
  Future O/S Amt =150(1650-1500)
  Calculated Invoice Upto Date : 30-Jun-22

Case 3 : Receipt Amount less than Recommended Amt but greater than O/S : 5000

To be Invoiced Amt : 3350 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 6.09 (3350/550)
Calculated Invoice Date : 03-Jan-23 (Actual Invoice Upto Date + 6 Months and 0.09*30.5=3 days)
Finalize Invoice Date after Incentive : 3-Jan-23 (5000-1650-0+550=3900, No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 10000

To be Invoiced Amt : 8350 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 15.18 ( 8350/550)
Calculated Invoice Date : 5-Oct-23(Actual Invoice Upto Date + 15 Months and 0.18*30.5=5 days)
Finalize Invoice Date after Incentive : 5-Nov-23 (10000-1650-0+550=8900, 1 Month free)

CASE C : Actual Invoice upto Date is equal to current date and O/S amt is equal to tariff rate

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : 550
B. To Be Billed Amount : 0 (Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 550 (O/S = tariff rate)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 6050

Case 1 : Receipt Amount equal to Recommended Amt : 6050

To be Invoiced Amt : 5500 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 10 (5500/550)
Calculated Invoice Date : 30-Apr-23 (Actual Invoice Upto Date + 10 Months)
Finalize Invoice Date after Incentive : 31-May-23 (6050-550-0+550=6050,1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S : 400

To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S
Future O/S Amt =150(400-550)
Calculated Invoice Upto Date : 30-Jun-22

Case 3 : Receipt Amount Less than Recommended Amt but greater than O/S : 3000

To be Invoiced Amt : 2450 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 4.45 (2450/550)
Calculated Invoice Date : 14-Nov-22 (Actual Invoice Upto Date + 4 Months and 0.45*30.5=14 days)
Finalize Invoice Date after Incentive : 14-Nov-22(3000-550-0+550=3000,No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 12000

To be Invoiced Amt : 11450 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 20.82 (11450/550)
Calculated Invoice Date : 25-Mar-24 (Actual Invoice Upto Date + 20 Months and 0.82*30.5=25 days)
Finalize Invoice Date after Incentive : 25-Apr-24 (12000-550-0+550=12000,1 Month free)

CASE D: Actual Invoice Upto Date equal to current date and O/S amt less than Tariff

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : 275
B. To Be Billed Amount : 0(Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 275(O/S<tariff)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 6050

Case 1 : Receipt Amount equal to Recommended Amt : 6050

To be Invoiced Amt : 5775 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 10.5(5775/550)
Calculated Invoice Date : 15-May-23(Actual Invoice Upto Date + 10 Months and 0.5*30.5=15 days)
Finalize Invoice Date after Incentive : 15-Jun-23(6050-275-0+275=6050, 1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S : 200

To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S
Future O/S Amt =75(200-275)
Calculated Invoice Upto Date : 30-Jun-22

Case 3 : Receipt Amount Less than Recommended Amt but greater than O/S : 5000

To be Invoiced Amt : 4725 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 8.59 (4725/550)
Calculated Invoice Date : 18-Mar-23 (Actual Invoice Upto Date + 8 Months and 0.59*30.5=18 days)
Finalize Invoice Date after Incentive : 18-Mar-23(5000-275-0+275=5000,No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 7000

To be Invoiced Amt : 6725 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 12.23(6725/550)
Calculated Invoice Date : 7-Jul-23(Actual Invoice Upto Date + 12 Months and 0.23*30.5=7 days)
Finalize Invoice Date after Incentive : 7-Aug-23(7000-275-0+275=7000, 1 Month free)

CASE E : Actual Invoice Upto Date greater than Target date and there is O/S amt

Actual Invoice Upto Date : 31-Aug-22
Target Date : 30-Jun-22
A. Outstanding Amount : 1000
B. To Be Billed Amount : 0(Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 0(Actual invoice upto date is future date)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 7050

Case 1 : Receipt Amount equal to Recommended Amt : 7050

To be Invoiced Amt : 6050 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 11(6050/550)
Calculated Invoice Date : 31-Jul-23 (Actual Invoice Upto Date + 11 Months)
Finalize Invoice Date after Incentive : 31-Aug-23(7050-1000-0+0=6050,1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S : 900

To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S
Future O/S Amt =100(900-1000)
Calculated Invoice Upto Date : 31-Aug-22

Case 3 : Receipt Amount Less than Recommended Amt but greater than O/S : 6000

To be Invoiced Amt : 5000 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 9.09 (5000/550)
Calculated Invoice Date : 3-Jun-23 (Actual Invoice Upto Date + 9 Months and 0.09*30.5=3 days)
Finalize Invoice Date after Incentive : 3-Jun-23 (6000-1000-0+0=5000, No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 25000

To be Invoiced Amt : 24000 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 43.64 (24000/550)
Calculated Invoice Date : 20-Apr-26 (Actual Invoice Upto Date + 43 Months and 0.64*30.5=20 days)
Finalize Invoice Date after Incentive : 20-May-26 (25000-1000-0+0=24000, 1 Month free)

CASE F : Direct Pay through Voucher

A.Outstanding Amount is in negative when subscription amt paid greater than o/s directly from voucher in that case O/S amt will show in minus suppose O/S is 4400 and he is paying 4950 directly from voucher than O/S become -550.

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : -550
B. To Be Billed Amount : 0 (Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 0 (O/s is negative)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 5500

Case 1 : Receipt Amount equal to Recommended Amt : 5500

To be Invoiced Amt : 6050 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 11(6050/550)
Calculated Invoice Date : 31-May-23 (Actual Invoice Upto Date + 11 Months)
Finalize Invoice Date after Incentive : 30-Jun-23(5500+550-0+0=6050,1 Month free)

Case 3 : Receipt Amount Less than Recommended Amt : 4400

To be Invoiced Amt : 4950 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 9 (4950/550)
Calculated Invoice Date : 31-March-23 (Actual Invoice Upto Date + 9 Months)
Finalize Invoice Date after Incentive : 31-March-23 (4400+550-0+0=4950, No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 13200

To be Invoiced Amt : 13750 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 25 (13750/550)
Calculated Invoice Date : 31-July-24 (Actual Invoice Upto Date + 25 Months )
Finalize Invoice Date after Incentive : 31-Aug-24 (13200+550-0+0=13750, 1 Month free)

B.O/S amt is 0

when subscription amt paid equal to o/s directly from voucher in that case O/S amt will show as 0 suppose O/S is 4400 and he is paying 4400 directly from voucher than O/S become -0

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : 0
B. To Be Billed Amount : 0 (Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 0 (O/s is 0)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) : 6050

Case 1 : Receipt Amount equal to Recommended Amt : 6050

To be Invoiced Amt : 6050 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 11(6050/550)
Calculated Invoice Date : 31-May-23 (Actual Invoice Upto Date + 11 Months)
Finalize Invoice Date after Incentive : 30-June-23(6050-0-0+0=6050,1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt : 4400

To be Invoiced Amt : 4400 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 8 (4400/550)
Calculated Invoice Date : 28-Feb-23 (Actual Invoice Upto Date + 9 Months)
Finalize Invoice Date after Incentive : 28-Feb-23 (4400-0-0+0=4400, No 1 Month free)

Case 3 : Receipt Amount Greater than Recommended Amt : 13200

To be Invoiced Amt : 13200 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 24 (13200/550)
Calculated Invoice Date : 30-June-24 (Actual Invoice Upto Date + 25 Months )
Finalize Invoice Date after Incentive : 31-July-24 (13200-0-0+0=13200, 1 Month free)

C. O/S amt is positive when subscription amt paid less than o/s directly from voucher in that case O/S amt will show as Positive suppose o/s is 4400 and he is paying 3300 directly from voucher than O/S become 1100

Actual Invoice Upto Date : 30-Jun-22
Target Date : 30-Jun-22
A. Outstanding Amount : 1100
B. To Be Billed Amount : 0 (Actual Invoice Upto Date - Target Date =0 months) 
C. Not Yet Due : 550 (O/s is greater than tariff amt)
D. Advance for Full Year : 6050
E. Recommended Amount (A+B-C+D) :6600

Case 1 : Receipt Amount equal to Recommended Amt : 6600

To be Invoiced Amt : 5500(Receipt amt - outstanding amt)
Calculated month after actual invoice date : 10(5500/550)
Calculated Invoice Date : 30-April-23 (Actual Invoice Upto Date + 10 Months)
Finalize Invoice Date after Incentive : 31-May-23(6600-1100-0+550=6050,1 Month free)

Case 2 : Receipt Amount Less than Recommended Amt & O/S : 900

To be Invoiced Amt : No Invoice Receipt will generate because amt is paid less than O/S 
Future O/S Amt =200(900-1100)
Calculated Invoice Upto Date : 30-Jun-22

Case 3 : Receipt Amount Less than Recommended Amt but greater than O/S : 4400

To be Invoiced Amt : 3300 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 6 (3300/550)
Calculated Invoice Date : 31-Dec-22 (Actual Invoice Upto Date + 6 Months)
Finalize Invoice Date after Incentive : 31-Dec-22  (4400-1100-0+550=3850, No 1 Month free)

Case 4 : Receipt Amount Greater than Recommended Amt : 13200

To be Invoiced Amt : 12100 (Receipt amt - outstanding amt)
Calculated month after actual invoice date : 22 (12100/550)
Calculated Invoice Date : 30-Apri-24 (Actual Invoice Upto Date + 22 Months )
Finalize Invoice Date after Incentive : 31-May-24 (13200-1100-0+550=12650, 1 Month free)