Find Jobs
Hire Freelancers

Database application to run a small business

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
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.
Project ID: 15072893

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $1,191 USD for this job
User Avatar
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
$333 USD in 25 days
4.8 (27 reviews)
6.2
6.2
User Avatar
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
$100 USD in 1 day
5.0 (13 reviews)
5.4
5.4
User Avatar
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
$1,666 USD in 20 days
4.4 (11 reviews)
5.3
5.3
User Avatar
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
$25 USD in 1 day
5.0 (1 review)
2.7
2.7
User Avatar
A proposal has not yet been provided
$500 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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?
$1,444 USD in 30 days
0.0 (1 review)
0.0
0.0
User Avatar
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?
$20 USD in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of KENYA
Kenya
0.0
0
Member since Sep 1, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.