1. Description of the project required
I run a business that offers agency banking services for various banks (KCB, Equity, Cooperative, Mpesa, Airtel, etc). The main activities are
- Agency banking activities (Balance enqury, Deposits and withdrawals)
- Money Transfer services & sell of airtime - (MPESA, AITELmoney & Equitel),
- Retail shop for stockable items and services.
All cash transactions is handled by one cashier in a cash box (money in & money out) including sales from the shop and deposits and withdrawals from
the agency banking. So I have the following "accounts" -
CASH ACCOUNT,
MPESA account
AIRTEL account
KCB BANK account
COOPERATIVE Bank account
EQUITY BANK account
etc (can add more in future)
I need a system that will record all transactions (shop stock sales, Deposits, Withdrawals & Airtime sales) and then at the end of the day produce
a reconcilliation report to see if the cash in hand and the closing balances are correct - to detect any fraud/losses/etc
The data to be recorded in the database includes the following
Transaction ID |
Transaction Date |
Transaction Type |
Transaction RefCode |
Customer ID No |
Transaction Value |
Service Provider Name (Bank)|
Customer Names |
Customer Id No. |
Customer Phone Number |
Customer Account No. |
Actual Opening Balance |
Actual Closing Balance |
Notes/comments |
2. The Report at day end should look something like this.
TENDO STAR LIMITED
CASH POSITION ANALYSIS REPORT FOR DATE: __________________
ACCOUNT OPENING BALANCE: stock sales: TOTAL DEPOSITS: TOTAL WITHDRAWALS: CLOSING BALANCE: ACTUAL CLOSING BALANCE: DISCRIPERNCY
CASH ACCOUNT 50000 1000 20000 10000 60000 55000 -5000
MPESA
AIRTEL
KCB
COOP
EQUITY
etc (can add more)
I hope you get the idea.
Other reports could be Monthly analysis, Yearly analysis , etc
3. If possible, I would also appreciate a module to track the commissions that my service providers should pay me. I have agreement that shows how
much commission i get paid for each transanction based on its monetary value or just per transaction.
4. The application should be simple to use and should include user rights (Administrator, cashier, manager) restricting what each user is able to access.- for obvious reasons.
5. It can be any database application that can run on windows as a stand alone application or as a web bases application running on lacalhost. eg. WAMP server based. Actually a web-based application is prefered over an Access database.
6. The POS module should be standard with ability to do sales, check stock availability, Reorder point, stock taking, Purchase orders, invoicing, Supplier/ventor tracking, Quotation & Receipting capabilities.
I have done similar projects before with 5* ratings.
I have been developing software for clients on this freelance websites with 100% customers' satisfaction.
Relevant Skills and Experience
MY RECENT WORK
• Website Development
• HTML5 Web Development
• C# and Web Development
• Import and Update Telecom Marketing Website Database
Proposed Milestones
$233 USD - work
$200 USD - work
$200 USD - work
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as
per your requirement
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$100 USD - Once the project is complete
Hi, if you really want to have a professional software for your project I can make it via Ms Access.
Relevant Skills and Experience
vba, Excel, sql, ado, Access
Proposed Milestones
$1666 USD - default
For the POS system, I have a ready made that I can customize for you, however I can also add the other options to it and make it one, kindly message me for more discussions. Thank you
Relevant Skills and Experience
Software Development, Software Architecture
Proposed Milestones
$25 USD - default
I've been working with Databases since 1984: data analysis, modeling, migration, conversion, integration, aggregation, optimization, performance tuning, etc. And extensive, varied & detailed reporting
Relevant Skills and Experience
I would propose using PostgreSQL for the database and PHP for the web interface: both are free, expandable and popular.
#s 3 and 4 are easy.
#6, we will need to discuss after the rest is functional
Proposed Milestones
$4 USD - Excellent references upon request
$40 USD - Fully document the scope of the project with time lines, etc - project plan
$100 USD - Create documented tables
$100 USD - Enter dummy data
$500 USD - Create web user interface
$100 USD - Enter data thru web interface
$200 USD - Retrieve data thru web interface
$200 USD - Create documented reports
$200 USD - Test everything til now before continuing
What OS and version are we doing this on?
What format is the current data in?
I understood the the requirements very well. Cash in hand, Airtel accounts, etc we can create as a day book. each entry will be against any one day book. day end we can generate day book wise report to see opening balance, each transactions, total transaction amount, and closing balance.
is it fine for you?