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.

Habilidades: Processamento de Dados, Processamento de dados, Excel

Veja mais: excel Do some Excel Work aviation, excel Do some Excel Work, freelance work excel vba, data entry, data processing, excel, 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

Acerca do Empregador:
( 2 comentários ) Lakewood, United States

ID do Projeto: #14614351

48 freelancers estão ofertando em média $123 nesse trabalho


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

$250 USD in 5 dias
(79 Comentários)

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 Mais

$200 USD in 2 dias
(348 Comentários)
$30 USD in 3 dias
(506 Comentários)

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. Mais

$100 USD in 3 dias
(333 Comentários)

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. Mais

$200 USD in 5 dias
(233 Comentários)
$250 USD in 3 dias
(138 Comentários)

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 Mais

$100 USD in 3 dias
(191 Comentários)

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 Mais

$30 USD em 1 dia
(210 Comentários)

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 Mais

$75 USD in 3 dias
(57 Comentários)

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 dias
(33 Comentários)

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 Mais

$144 USD in 7 dias
(134 Comentários)

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 Mais

$150 USD em 1 dia
(9 Comentários)

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

$70 USD in 2 dias
(44 Comentários)
$155 USD in 3 dias
(100 Comentários)

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. Mais

$99 USD in 3 dias
(101 Comentários)

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 Mais

$100 USD in 5 dias
(40 Comentários)
$155 USD in 3 dias
(115 Comentários)
$150 USD in 5 dias
(40 Comentários)

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 Mais

$100 USD in 3 dias
(37 Comentários)

Dear Employer, I am a student of [login to view URL] 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 Mais

$155 USD in 3 dias
(41 Comentários)