I run a Uber driver, income processing service.
I accept people's payments from Uber
I take the drivers on as employees and pay them as such.
I issue them with a fuel card for petrol purchases and an e-tag for toll road usage.
Each week from their Uber income, I deduct
- those two amounts (tolls and fuel)
- Workcover insurance (1.1%)
- Superannuation 9.5%
- my Fee GROSS < $500 (per week) CHARGE $5
GROSS BETWEEN $501 - $1000, we charge $8
GROSS EARNINGS GREATER THAN $1001 $15
I have attempted to create an excel spreadsheet that will allow me to import data from the fuel card usage and from tolls, allow me to input driver's income and then produce a report showing:
- Employee Code
- Gross income
- fee breakdown
- Income history graph
- Toll usage for past 7 days
- Fuel card usage with average mileage (based on odometer reading) (graph)
I was advised due to the volume of data being imported each week, a database would be a better way to go. (see access database attached)
The excel sheet worked, but I couldn't get the report to generate the way I wanted. So I attempted to convert this to an Access DB.
Import CSV files from fuel & toll data (sample files provided when assigned)
Have a GUI interface to request reports
Ability to produce individual reports in batch and export (either as PDF or email (individually)
Ability to request reports for specific employee
Perform the deduction calculation
This database can either be web based or desktop based (access? or other)
I engage with most bidders, those placing low bids only to jack up the price later will not be considered.
25 freelancers están ofertando el promedio de $327 para este trabajo
hi, I would suggest a mysql database setup on your desktop. The milestones for the project will be : 1. set up the database, 2. data model , 3. module for loading csv files, 4. GUI to get reports.
I am a J2EE developer and can make your project with ms access DB so comforting that you can access all the details of Your every Employee very Easily.