Закрыт

Excel/Google Revenue Earning Sheet

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.

Example:

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

Fare: $500

Approx. Hours: 5

Wait Time: 3 Hours

Hourly Trip: If it was an hourly trip then ill enter hours like 10 Hours

Tolls: $20

Gratuity: $50

Cash Tip: $10

Parking: $20

Cleaning Fee: $$100 (In case someone spilled a drink or something)

Water Fee: $5

Food: $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

Навыки: Excel, Google Sheets

О клиенте:
( 0 отзыв(-а, -ов) ) United Kingdom

ID проекта: #34304094

133 фрилансеров(-а) готовы выполнить эту работу в среднем за $123

(483 отзывов(-а))
8.4
(529 отзывов(-а))
7.9
(34 отзывов(-а))
6.7
(224 отзывов(-а))
6.9
(131 отзывов(-а))
6.8
SShtv

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and m Больше

$150 USD за 3 дней(-я)
(121 отзывов(-а))
6.5
AccountantArman

"Sir, Your project needs skills of both an accountant and excel and I am an expert of both. Price will be as per your budget. and work will be delivered within 24 hours. Excel is my filed and complex formulas is my pas Больше

$166 USD за 1 день
(187 отзывов(-а))
6.6
(49 отзывов(-а))
6.7
(46 отзывов(-а))
6.5
(96 отзывов(-а))
6.2
(168 отзывов(-а))
6.5
(45 отзывов(-а))
6.0
narsim3128

NOTE : I HAVE EXPERTISE IN WEB SCRAPING/RESEARCH. With respect to this project I would like to present myself as a candidate for your consideration. I have successfully completed projects which involved web scraping/r Больше

$30 USD за 7 дней(-я)
(71 отзывов(-а))
6.1
kingqueen369

Hello Greetings !!! ✅project Name :checked your project Excel Revenue Earning Sheet ✅Completed Time : 24 or 36 [login to view URL] your requirement deadline . ✅Click on the "CHAT" button so we will discuss it in detail. I Больше

$40 USD за 1 день
(84 отзывов(-а))
5.8
hamidr2020

Hello, I am an Excel expert. I have thoroughly read the project details and your requirements. I offer my services to create Excel Revenue Earning Sheet to look at the overall picture of earnings and expenses for daily Больше

$120 USD за 2 дней(-я)
(63 отзывов(-а))
5.5
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thanks.

$200 USD за 3 дней(-я)
(73 отзывов(-а))
5.7
Shihab014371

Hi Nauman.... I have already read your job details. I can start the work immediately once you awarding me. Kindly chat with me we can discuss

$50 USD за 7 дней(-я)
(16 отзывов(-а))
5.3
charleslimnet

Hello I am a proficient chartered accountant (C.A.) in business and finance analysis. I have 18 years’ experience as a practicing CPA and 20 years’ experience as an academic researcher and analyst. I am passionate abou Больше

$150 USD за 3 дней(-я)
(41 отзывов(-а))
5.8
merinsinha

Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Больше

$150 USD за 2 дней(-я)
(133 отзывов(-а))
5.5
sobhad20

Hi There, I can do this project right now with perfectly. Kindly ping me to start your work now. Regard’s Sobha

$30 USD за 1 день
(96 отзывов(-а))
5.2