Downloadable files for organizing, tracking and planning.
Track your most critical daily data each day! This spreadsheet has one sheet for each month of the year, with one row for each day. Just enter the following each day when you finish your shift:
• Hours worked
• MIles driven
• # of Rides
• Amount Earned in Fares
• In-App Tips
• Cash tips
The spreadsheet will automatically calculate the following:
• Gas used (based on mileage and MPG)
• Monthly totals for all columns
• Avg. hours worked per day
• Avg. rides given per hour
• Avg. hourly earnings
• Avg. rate per mile driven
• Avg. amount earned per ride
• Avg. tip per ride
• Tips as a percentage of income
You can keep this file on your phone for easy access and updating each day from your car.
Track Yearly Trends with This Worksheet! This spreadsheet has 2 rows for each week of the year, one for Lyft and one for Uber (color-coded blue and pink). Simply enter the numbers for each week froi
• Hours worked
• # of Rides
• Amount Earned in Fares
• In-App Tips
• Bonus Amount
• Cash tips (from your daily logs)
The spreadsheet will automatically calculate the following:
• Combined Totals (Weekly and Annually)
• Avg. Rides per hour (Weekly and Annually)
• Avg. $ per hour (Weekly and Annually)
• Avg. $ per ride (Weekly and Annually)
• Avg. Tips per ride (Weekly and Annually)
• Pie graph showing what percent of your annual income is fares, app tips, cash tips, bonuses
• Bar graph comparing weekly earnings for Lyft and Uber over the entire year
You can view or download your weekly statements from Uber and Lyft periodically throughout the year to update the sheet, or do it all at the end of the year.