In Progress

Money Remittance Database. Urgent !!!!

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:

For beneficiary:

Name

Surname

Telephone1

Telephone2

Email

Address

City

country

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.

For sender

Name

Surname

telephone

email

address

city

country

Transactions:

Number

Date

sender (with all details)

beneficiary (with all details)

banking details where the money has to be deposited (if payment type is deposit)

amount sent

currency (Only XAF)

Service Fees Rate (Default 8% can be increased or decreased)

Service Fee ( Amount * service rate) Must be automatic calculation.

Exchange rate

Amount in Zar ( here the calculation is as follow: XAF amount divided by 656 and then multiplied by exchange rate ).

Payment date.

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

Skills: Anything Goes, Microsoft Access

See more: money remittance database, service database access, payment received bank, none given, microsoft access developers, microsoft access database developers, microsoft access database developer, developers access, access database developers, service fees, email database management, database developers, bank account name, microsoft access developer, zar, xaf, service management database, receipt print, money store, microsoft exchange service, easy fast money, cash advance, customer details database, protected account number, bank transactions entered

About the Employer:
( 3 reviews ) Johannesburg, South Africa

Project ID: #2587012

Awarded to:

rhomeu

MS Access expert here. Please see my profile.Thanks

$250 USD in 3 days
(39 Reviews)
6.5

9 freelancers are bidding on average $211 for this job

Prashantskin

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

$200 USD in 4 days
(486 Reviews)
6.9
sinfulm3

Hello Sir, kindly check PMB.

$150 USD in 4 days
(8 Reviews)
3.8
amfuries

############# ****** WE HAVE DONE THE SIMILAR APPLICATION PLEASE CHECK THE PM ****** #############

$100 USD in 1 day
(2 Reviews)
3.2
ideadezigner

Please Check PMB

$100 USD in 1 day
(11 Reviews)
2.2
skendertopilla

fast, accurate, reliable, trustworthy The fee of 8% can be an editable field which you can increase or decrease according to your needs.

$199 USD in 4 days
(0 Reviews)
0.0
UPwF5r47O

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$250 USD in 1 day
(0 Reviews)
0.0
DaddyWarbucksEsq

My name is George Panko, dba The Immaculate Cohhection*. I am relatively new to this freelancer site, but am well-established on Guru.com. Since 2001, I have specialized in designing, developing, and maintaining M More

$250 USD in 7 days
(0 Reviews)
0.0
mrintelligence

Look for LIVE DEMO in PMB

$250 USD in 5 days
(0 Reviews)
0.0
boyet0911

Experienced programmer/developer for business processes and solutions. kindly check your pmb for my details.

$250 USD in 15 days
(0 Reviews)
1.5