Do some Excel Work

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I need someone to make the following spreadsheets:

I have a counseling office with 4 therapist, that each see clients, and the insurance pays my company for the sessions. I need to know how much each therapist brings in per month, and how much I give them, so I have a clear oversight as to what the income is if any.

At the same time, I need to keep the insurance payments in clear view. I need to know which of the sessions are paid, and which are not yet paid. Then there is a copay that may exist for a client, but may not exist, I need to know if there is a copay, and if this has been paid.

I need to have a monthly oversight, and then a final page in which I can see all the month, and total income, total expenses . The company also has expenses other than the wages of the therapists, so I need to be able to enter that so that it will be reflected in the monthly expense's, and will come off the monthly income. So for the therapists I need to know their income and deduct their wages, so I have an idea how much they bring in, and for the company I need to have a total income per month and grand total. I need to be able to enter an expense to reflect to the total monthly income.

For the insurance claims, I need a few columns: 1) Day 2) date 3) clients name 4) insurance paid (this is to be yellow, and turn white when I add a number, so that I know if it was paid, by it being white and not yellow) 5) copay (this is little more tricky, as I know upfront how much they owe me, so I need to enter that amount, and I also need to know if the copay was paid, so I need to have some kind of oversight just like by the insurance payment it turns white from yellow, similar here, just there is a number due and number paid, so I need to have some kind of wat to see that clearly) 6) billing code 7) insurance details 8) diagnosis and than I guess 9) would be which therapist provided the session, an then that would reflect a separate area in which I can see how much each therapist made, and over there I need to enter the wages /other expenses for the particular therapist and the total net gain. that would be for the four therapist. (their names are: 1) Donna 2) Katherine 3) Michelle 4) Crystal. this is per month, and that will also be visible on a finance page, in which I can see how much income for each moth, how much expenses (the wages that are already written in under each therapists income on the month page) and then an area where I can add other expenses for the company, such as rent, furniture, phone etc etc. (there has to be an area for the expense and also an area where I can specify what the expense is for)So then I have a monthly total income, and a grand total that tells me pure net income after all expenses.

Data Entry Data Processing Excel

Project ID: #14614351

About the project

48 proposals Remote project Active 6 years ago

48 freelancers are bidding on average $123 for this job

schoudhary1553

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 excel task as per your requirement Relevant Skills and Experience I have the 5 years More

$200 USD in 2 days
(348 Reviews)
8.0
KulfiSoftwares

Hi, Can start immediately..! I can do this for you quickly and with great quality for cheap...Based in Nepal we provide quality work, and 100% satisfaction guarantee..We are not satisfied with the work until you are. More

$100 USD in 3 days
(333 Reviews)
7.7
paris2785

I've read your brief and can see that you'd like to have an Excel spreadsheet. Relevant Skills and Experience I have 7 years experience designing and developing Excel spreadsheets filled with formulas and VBA code. More

$200 USD in 5 days
(233 Reviews)
7.5
ksriniravi

I can develop the Tracker as per your requirement for $100. Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 12 More

$100 USD in 3 days
(191 Reviews)
6.8
dvcontact

Hi, If you are looking for a professional and reliable Excel expert with proficiency in data analysis, I'm your ideal candidate. I'm highly experienced in producing mathematical solutions with Excel and I have a stron More

$75 USD in 3 days
(57 Reviews)
6.5
imransgd101

Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satis More

$30 USD in 1 day
(210 Reviews)
6.6
Mehedi947264

Dear Sir, I read your project details and able to work right now in your project, Price is what you pay. Value is what you get, so you can hire me to get a Quality Service. Thanks. Mehedi.

$100 USD in 2 days
(33 Reviews)
6.1
abdussamad

Self-motivated professional, certified data entry specialist, a proficient web researcher and transcriber,blogger, web designer, Wordpress and various social sites marketer, knowledgeable in SEO. Relevant Skills and E More

$100 USD in 5 days
(40 Reviews)
5.9
furqanahmed55

Hello, I graduated from Boston University USA. I have a lot of experience doing data entry. I am very punctual and always deliver on time. My personal qualities are: - Detail Oriented, as handled many sensit More

$150 USD in 1 day
(9 Reviews)
6.1
sonarkaushik

Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. More

$99 USD in 3 days
(101 Reviews)
6.2
awaisjahangir25

Dear, I've been working in Medcal Billing Company for last 4 years and worked on same kind of reports for doctors. I can work for your required spreadsheets. do let me know. Relevant Skills and Experience MS Excel, Da More

$100 USD in 3 days
(37 Reviews)
5.3
abuubaida42

Hi, Let me help you on your data entry works. I have completed many similar projects. Relevant Skills and Experience You can see my skills in my profile. Proposed Milestones $155 USD - Price is negotiable. I will als More

$155 USD in 3 days
(14 Reviews)
4.2
ScareCrow01

Hello, You want a financial reporting system in excel. I can do that but require more than 3 days. I want to do it because i love to work in excel. Math is fun, so does excel. Lets talk in chat Relevant Skills and Exp More

$155 USD in 5 days
(21 Reviews)
4.4
dayakmlt

it can be done in excel with out macro, if we add macro it may difficult for u to edit in future. In single excel sheet, there will be multiple tabs, where u can track details in tab. Relevant Skills and Experience More

$60 USD in 5 days
(16 Reviews)
3.6
tiny27

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. Relevant Skills and Experience I have vast experience in IT / Data E More

$100 USD in 3 days
(3 Reviews)
3.2
rumesh402

Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can d More

$50 USD in 0 days
(9 Reviews)
2.6
hveer

I ensure you I will complete this project much before your deadline. Moreover, hiring me will be cost efficient, as I ask for less than my competitors. Stay tuned, I'm is still working on this proposal.

$35 USD in 3 days
(0 Reviews)
0.0
Makonge

A proposal has not yet been provided

$111 USD in 1 day
(0 Reviews)
0.0
sksripali25

I can do this project Relevant Skills and Experience I have more experiences. Proposed Milestones $35 USD - 3 days

$35 USD in 3 days
(0 Reviews)
0.0
payal1sukhwal

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0