Excel / Google Sheets Project
I am looking for an Excel/Google sheet to record the company revenue.
We are a small Limousine company, and we are getting jobs from 5 to 10 other big Limousine companies, and we are billing them for Fares, Approx. Hours, Wait Time, Hourly Trip, Tolls, Gratuity, Cash tip, Parking, Cleaning fee, Water Fee, Food, Extras Fee, etc.
Our goal is to look at the figures for a certain date to the week/month/year so we know how our business is doing and which months or weeks are doing better comparing other weeks or months so we can plan and take action accordingly.
Empire Limo sent us the job so the data I will manually enter into your spreadsheet is
Trip Number: 7817488472 (Which stays unique)
Passenger Name: Laura Smith (It Could be a repeat which is OK)
Pickup Address: 10 Columbus Circle, Manhattan, NY, 10010
Drop Off Address: Terminal 4, JFK, NY, 11430
Approx. Hours: 5
Wait Time: 3 Hours
Hourly Trip: If it was an hourly trip then ill enter hours like 10 Hours
Cash Tip: $10
Cleaning Fee: $$100 (In case someone spilled a drink or something)
Water Fee: $5
Extras Fee: Like any damage to the car or if the client asked for Wi-Fi or anything like that and we are charging for it
(So, all these numbers I will enter manually depending on the job we received from a network)
There are 5 to 10 Main networks we work with, so I want to see each network like Empire Limo sent us how many jobs and what daily, weekly, monthly, and yearly revenue we earned in above-mentioned categories. Likewise, other 4/5 networks keep the same pattern above.
In the expense section, there can be Fuel, Tolls, Repairs, Food, and Misc. & 2/3 Other categories and we can name them later on (So we don’t have to go through everything all over again)
So, I can look on a certain date / weekly, monthly, yearly, etc. how much was the expense. Like I want to see last month how much Empire Limo gave us work and numbers on each category plus I want to see how much our obvious expense in that week or day or in each category month was and totals for all.
Moving forward, the driver who completed the job has a per-hour rate & gets paid for each job explained above and he also gets paid in each category mentioned above.
For the fare we are collecting as an example $100 - The driver charged us $80 so we know $80 is gone and we have $20 earning. In the $80 he took from us we know he took 65 for fare, 5 for parking, and 10 for gas so altogether 80 he charged us, and this is how we got left with $20
Overall, our goal is to look at the overall picture of earnings and expenses for daily weekly monthly, and yearly. Which company gave us what in each category and which driver charged us what in each category and all those numbers on daily weekly monthly and yearly basics.
This way we can say to Empire Limo that look last month you gave us work for 5K but this month our average is below 5K OR Q1 you gave us work for 20K and in Q2 you gave us 14K so please give us more.
Plus, each category will give us a picture that how much we are earning in each category like tolls etc. and what we need to slow down or charge more etc.
We will plan based on the data we are getting from your spreadsheet.
Just to make sure, we will be able to see through your spreadsheet which network and which customer gave us what on each date week year, etc.
We can discuss more with your questions and suggestions