Closed

Automate monthly commissions calculations

I have about right now about 50 sales reps commissions reports that I am imputing into Power BI to first pull the whole report because I have to create a journal entry based on this data. The data in put into Fishbowl transferred to Quickbooks desktop 2020 and then refreshed on Power BI. It takes me about 5 days to complete this process. I need someone who has some coding knowledge and very advanced Microsoft excel skills that can get this process at least automatically calculated by each rep and the regional managers then automatically attached to that reps proper email address and ready to send but prompts me to review before sending out.

Skills: Excel, Accounting, Intuit QuickBooks, MYOB, Data Processing

See more: line address book send people complete, fedex ground calculated days, days complete css webpages, excel monthly expenses format average per days, days complete 100 html pages dreamweaver, automate email address creation, complete email address list, days complete magento project, days complete wordpress template, find complete net coding website, infopath date calculations default date days today, sending data micro complete project, excel monthly commissions report, automate monthly report, microsoft excel monthly roster, email address harvesting sending program, complete design coding, complete site coding, excel automate monthly report

About the Employer:
( 0 reviews ) Youngsville, United States

Project ID: #22315530

32 freelancers are bidding on average $1080 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$1200 USD in 10 days
(324 Reviews)
7.9
P0L

Hello, I’m an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$1000 USD in 5 days
(336 Reviews)
7.3
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I have developed this type of tools several times. I can More

$900 USD in 7 days
(234 Reviews)
6.9
NoelReubenMuturi

Hello. My name is Noel. I have read your brief; you need assistance with an accounting project. I am a BSc. in Accounting and ACCA, and a proficient accountant with over 10 years of experience in Finance and Accounting More

$1125 USD in 7 days
(198 Reviews)
7.4
suyashdhoot

Hi I am a very experienced statistician, data scientist and business analyst. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several com More

$1500 USD in 7 days
(71 Reviews)
6.7
shikhamehta

Hey, I am an expert in Excel (completed more than 500 projects successfully here on Freelancer itself) but more importantly, I have worked in incentive compensation management domain and have created several commissi More

$1500 USD in 30 days
(113 Reviews)
6.6
avinav606lx

Hi there This looks feasible and we can do this in Excel VBA or in python. I am an expert in Excel VBA/python data handling and report generation. Ping me to discuss data logics and start the project Thanks A

$750 USD in 3 days
(165 Reviews)
6.5
polarjin2017

Hello? How are you? I am excited to work with you on this project. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formula, etc... [login to view URL] More

$750 USD in 5 days
(93 Reviews)
6.7
nvchien94

Hello there, I am an Excel expert and skillful in VBA coding for data processing. Please directly contact and share me your dataset. I will need your support in detail step-step to handling data manually then I can ma More

$750 USD in 2 days
(145 Reviews)
5.9
wsh2

Summary: Highly experienced recurring Journal Entry (to include allocations, clearing, accruals and reversals) MsEXCEL programming expert. You have a whole 5 days? Heheheh - Just kidding. Suffice it to say I can def More

$1125 USD in 7 days
(35 Reviews)
6.1
bhupendrayadav

I can develop an advance excel based tool with VBA to automate the process of preparing different sales reports and sending them on email. please initiate chat to discuss this in detail, I can also show you my previous More

$750 USD in 3 days
(37 Reviews)
5.4
SergioAlfaroV

Hello! I am a Systems Engineer with 14 years of experience in BI projects. I am an expert Excel, Power BI and SQL coder, as you can see in my portfolio. I can replicate the calculations on Power BI directly (using DAX) More

$1000 USD in 7 days
(10 Reviews)
5.5
GopalJp

Dear Sir, I can develop you commission calculator and the process in Microsoft Excel with buttons and code. I am a qualified VBA and Macros developer in Excel. I am also an accountant having 8 years experience. I l More

$1000 USD in 10 days
(29 Reviews)
5.2
winghei

Dear Sir/Madam: I would like to express my interest on this project. I am an Accountant and currently working as a fullstack software developer primarily focusing on MS-based products and web development (Angular/Node More

$1000 USD in 7 days
(8 Reviews)
4.6
wonwon424

Hello I am interested in your project. I've carefully gone through your job and I am interested in your job because I have a lot of experiences in various data science and report projects. I will provide user-friendly More

$1125 USD in 10 days
(4 Reviews)
3.9
dataEntryExperty

I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$750 USD in 1 day
(14 Reviews)
3.2
alokes

Hi, I am a Software Professional developing software in MS Excel/ Access with VBA for last 22 years. I would like to develop the database using MS Excel/ MS Access as per your requirement.

$750 USD in 7 days
(2 Reviews)
2.5
vishwakarma09

Hi, I have worked on funnelling data leads and I have automated workflows like this. You can share your input formats and I can work with you to create a process to automate the refining of data. You can share your pr More

$1250 USD in 7 days
(1 Review)
2.6
elenaleslee01

Hi I've just read your job description and now I am interested in your job. You can give a glance at my recent works in Amazon seller central and kindle&smash book editing. I gained a Master's Degree last year and I More

$750 USD in 7 days
(1 Review)
1.9
MikeA515

I am a CPA that specializes in Excel, VBA, and Process Automation. I use VBA on a daily basis to pull data, reformat canned reports, run complex functions, and perform analytics at the click of a button. If you can e More

$1000 USD in 5 days
(1 Review)
1.5