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. It's urgent and we want only ms access developers
Thanks in advance
9 freelancers are bidding on average $211 for this job
Res.Buyer I have gone through your project requirements regarding access project of money remittance I will develop it within 4 days only Please see PMB for details Regards Prashant