Find Jobs
Hire Freelancers

Do some Excel Work

$25-50 USD / hour

Avslutat
Publicerad över sex år sedan

$25-50 USD / hour

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.
Project ID: 14616896

Om projektet

16 anbud
Distansprojekt
Senaste aktivitet sju år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
16 frilansar lägger i genomsnitt anbud på $36 USD/timme för detta uppdrag
Använd avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply ============
$41 USD Om 40 dagar
4,9 (348 omdömen)
8,0
8,0
Använd avatar
Hi, I would like to make a sample excel sheet for you to make sure that, your requirements are fulfilled. I would need the Therapists data and the financial data as well. Could you please send it over, so that I shall create a sample template for your approval ? Interested to work on this. Kindly discuss further so that let's get started. Ready to start right away. Thanks BP Web Analysts
$50 USD Om 40 dagar
5,0 (221 omdömen)
7,8
7,8
Använd avatar
Hi, I will work as per your project requirements. I ensure you 100% accuracy of my work. I will start working right now. Please see my profile reviews to check my working reputation. I am waiting for your response to discuss further. Thanks
$49 USD Om 3 dagar
5,0 (326 omdömen)
7,2
7,2
Använd avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have an Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets filled with formulas and VBA code. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. I am online from 8 am to 11 pm (GMT+3).
$30 USD Om 40 dagar
4,9 (233 omdömen)
7,5
7,5
Använd avatar
Hi, I have experience in Insurance and I am a guru in Excel and VBA. I have experience in accounting, Financial Report Tools, and Microsoft Excel. I served as CFO, Controller, and Chief Accountant at global parent companies, and I have extensive experience in accounting, consolidating, forecasting, budgeting, and costing I am a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation. I am a financial professional and guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)Therefore, I can help you design, build or modify spreadsheets in Excel to deliver professional analysis and reliable functionality suited to your needs. I offer you 35+ years of experience working on a variety of companies including, VC's, privet investors, entrepreneurs, startups, retailers, power plants, farms, insurance, universities, constructions, medical equipment manufacturer companies, among others.
$50 USD Om 40 dagar
4,9 (90 omdömen)
7,1
7,1
Använd avatar
I am a statistical analyst, with strong background of Pure Statistics including a strong grip on statistical software including SPSS, Excel, Minitab, STATA, SAS, Mathematica, Statistica and Eviews. Brilliant skills in Multivariate Analysis, Factor Analysis, Discriminant Analysis, Logistic and Multiple Logistic Regression, Panel; Cross Sectional & Time Series Analysis, Fixed & Random Effect Models, ANOVA, MANOVA, ANCOVA, Principal Component Analysis, Simple & Multiple Linear Regression, Non-Linear Models, Generalized Linear Models, Control Charts, Hypothesis Testing, Poisson Regression, Binary Data Analysis, Z-test, T-test, Chi-Square Test, F-test, Parametric Methods, Non Parametric Methods, Best Model Selection, Problems related to Inference, Estimation, Probability, Sampling, Calculus, Economics, Mathematics and vice versa. In-spite of data analysis task, I deliver high quality content on time at an affordable price. My work is done efficiently and effectively, & I meet clients' needs
$40 USD Om 1 dag
4,9 (76 omdömen)
6,0
6,0
Använd avatar
A proposal has not yet been provided
$27 USD Om 15 dagar
4,7 (12 omdömen)
4,1
4,1
Använd avatar
*I would charge a flat rate for this* Native English speaker. Excel/VBA expert. I've custom built these systems before, entirely in Excel. I've read your requirements and can already think of a few things. Just send me a message and we can chat!
$27 USD Om 40 dagar
5,0 (2 omdömen)
2,8
2,8
Använd avatar
I am an aspiring computer scientist currently on my third year in my degree programme. I am willing to do your work for free because my main goal is to build on my reputation as a credible freelancer. My goal is have a very strong foundation and reputation on freelancer by the time i finish my degree, which is why i am opting to do the work for free.
$41 USD Om 40 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
Hello sir. I am an expert in Excel, data entry and data processing. I have an experience of more than 6 years. If you wish to have a best quality job and a low price, I invite you to choose me.
$27 USD Om 40 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I will create a good spreadsheet to snow how much each therapist brings in per month, and how much to give them, so that clear oversightis shown as to what the income is if any. I will show accounts paid and any copays that have been paid or are due. I will show a monthly oversight, and then a final page in whichshows all the month, and total of the income and total expenses . I will also show the expenses other than the wages of the therapists, so that profit can be known and displayed for each month.
$41 USD Om 40 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
A proposal has not yet been provided
$25 USD Om 3 dagar
0,0 (0 omdömen)
0,0
0,0
Använd avatar
I can do this work due to my expirience. I worked many years in finance and with excel spreedshits. I woul enjoy doing it.
$41 USD Om 40 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för ARGENTINA
Argentina
0,0
0
Medlem sedan juli 11, 2017

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.