The below is an idea as to the flow we're going to use to automate this entire process.
I.D number to check for duplicates
Check if on debt review, admin, sequestration select none (Box) to be added
Add Personal details Section on landing page
Add Work details Section on landing page
Add Payslip info Section on landing page
Ask What instalment can the client afford to pay
Add Day to Day expenses Section on landing page
Add creditors section where we can input creditor information on landing page
Give total of creditor Instalments on landing page automatically through auto calculations formulas and process son our Excel master sheet
Indicate negative figure, System automatically calculates over indebtedness as per our excel master sheet.
Insert increase or decrease instalment Box, which alters the instalments (Increase it or Decrease it)
Set debit date using landing page calendar (This debit date needs to populate on the contract itself under the debit order mandate debit date)
Save Application, Edit Lead in system, pull and send for signing function
Send USSD for client to approve to cellphone to sign the contract, once USSD approved signed copy emailed.
Set profiles for different users with agent name and company name. Password and username protected.
Pull out daily weekly monthly yearly reports excel, PDF of lead information and which company signed which client. Used for reporting and building marketing database.
Have a search function to insert I D number and pull up record. Set work status of record in distribution, pending contact, suspended, cancelled and per creditor on the record option to add banking details for each creditor for that client and upload supporting client docs. Contracts to be saved in the client's record, option to pull any time. Allocate the record to a sub company for reporting under main system owner. Total earnings etc.
Automate the entire journey via SMS after the contract is signed email to go out to client asking them to email 3 months bank statement, the latest payslip, and I.D copy within 7 business days to our email address.
Cloud based system with storage or PHP Website with Database.
Information on front landing page need to populate the contract with all the above information and calculations automatically done in the background by the system added onto the contract that's sent out. Formulas and example of calculations to be sent as per our master Excel sheet.
Option to change contract content and branding on our own.
Option to create suspend or terminate user profiles and to reset passwords from my side…
Please advise me if this needs to be built from scratch, or you are able to use an existing framework and upgrade to our specifications.
We're also looking for a prepaid option for the USSD and SMS feature.
I have attached some examples of the landing page layout and information.