We are running a money transmitter company and we want a database to store all remittances. These senders and beneficiary a regular customers and money is sent between 2 offices and only 2 different currencies are involved.
The data that need be stored are:
We need to store beneficiary banking details but the trick here is that a customers can have none, one or more bank account. Also the customer can use someone else bank account to receive the money. In that case we will need the banking details of that someone else. The banking details are : account holder name, account number,bank name, branch name, branch code.
sender (with all details)
beneficiary (with all details)
banking details where the money has to be deposited (if payment type is deposit)
currency (Only XAF)
Service Fees Rate (Default 8% can be increased or decreased)
Service Fee ( Amount * service rate) Must be automatic calculation.
Amount in Zar ( here the calculation is as follow: XAF amount divided by 656 and then multiplied by exchange rate ).
Agent (the one who entered the transaction)
Concerning the transactions we need to know if the payment to the beneficiary was made cash or deposited into an account and we must know in which account exactly if we want to trace the transactions.
We need the following reports:
Transaction per customers (date, amount , etc...)
Transaction per date ( from one date to another)
customers details with banking details
More important to be able to determine which customers has not received money for a specified periode. Each customer is supposed to received money at least once a month ( example for the last 2 or 3 months)
Also we need to be able to print a receipt for each transaction.
The database should be password protected
Sometimes credit are given to beneficiary and we need a popup reminder when he received some money to be able to deduct what he is owing.
Some major improvement can be done by the developer to make management and entry easy and fast.
Thanks in advance
23 freelancere byder i gennemsnit $170 på dette job
Hi This is Piyush Patel I have 8 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM
Hi.. Expert database developer here. Assure you 100% accurate database according to your requirements. My bid is for exact database. Ready to start. Have a look at PM. Regards