We need a simple yet scalable debit card management program/script that will help us manage the distribution of debit cards.
It will need to allow the creation, editing and reporting of cardholder accounts with personal information, card numbers linked to the cardholder, and ID documents linked to the cardholder that have been uploaded to the system (or a reference number that would link the cardholder ID to an offline file system where they would be stored.)
The system should allow for the manual creation of a new accounts, batch creation from csv or xcl format, or automated creation from an external site that would send the data via an api call or some other method, and/or additional cards added to existing records.
It should show status and allow change for pending, approved, denied and sent, with a comment field to note information pertinent to records.
It should allow for notes to be entered in cardholder record, with date and time.
It should have reporting capability to produce on variety of groupings, such as number issued total, number active, suspended, and per merchant or distributor.
It should have a section that has merchant or distributor (agent) information, and a listing of cards per that merchant or distributor,
It should have section with Card Program information such as fees, cost of cards, type of card, fulfillment option, and links to files or documents associated with the program, as well as a listing of merchants or companies distributing the cards in the program.
And other management tools that may be needed.
Any copyright to the finished script/program will pass to us.