Closed

Do some Excel Work

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.

Skills: Data Entry, Data Processing, Excel

See more: excel Do some Excel Work aviation, excel Do some Excel Work, freelance work excel vba, track work excel, macros written excel 2000 work excel 2007, contract work excel access, excel 2000 macros work excel 2007, article submission work excel, show project work excel, work excel file, contract work excel, online contract work excel, data entry work excel, work excel database, surf internet work excel

About the Employer:
( 1 review ) Lakewood, United States

Project ID: #14614351

50 freelancers are bidding on average $122 for this job

jkaranm

Hi Future Client, Our business is to make your business effective, profitable, & [url removed, login to view] are able to have a sound understanding of our Clients’ operations and their corporate goals, and we continually bring kno More

$250 USD in 5 days
(20 Reviews)
7.5
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
(184 Reviews)
7.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
(151 Reviews)
6.8
$30 USD in 3 days
(196 Reviews)
6.9
$250 USD in 3 days
(86 Reviews)
6.8
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
(187 Reviews)
6.6
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
(109 Reviews)
6.3
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
(73 Reviews)
5.8
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
(38 Reviews)
5.8
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
(92 Reviews)
6.2
axiomswb

We have expertise in excel VBA,webscraping, data [url removed, login to view] satisfaction is our main motto for long term relationship.

$70 USD in 2 days
(28 Reviews)
5.4
$155 USD in 3 days
(103 Reviews)
5.5
$155 USD in 3 days
(43 Reviews)
5.5
pilotarif

Dear Employer, I am a student of [url removed, login to view] Electrical Engineering. It's my main source of income. More than last 5-years having 100+ completed projects along with top positive feedback on my profile easily proof my expertis More

$155 USD in 3 days
(31 Reviews)
4.6
sourabhg98

The bid includes a complete workbook fully automated to meet all your needs and user friendly with an attractive dashboard. Relevant Skills and Experience I am an advanced Excel VBA programmer currently at the post More

$144 USD in 7 days
(30 Reviews)
4.4
asadkhan3533

Please review my profile as i have relevant experience and skills matching this project Relevant Skills and Experience Data Entry, Data Processing, Excel Proposed Milestones $88 USD - Data Entry, Data Processing, Exc More

$88 USD in 3 days
(14 Reviews)
4.3
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
(8 Reviews)
3.7
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
(6 Reviews)
3.6
$155 USD in 3 days
(7 Reviews)
3.1
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
(7 Reviews)
3.0