I would like to hire an Excel Expert
$30-250 USD
Pagado a la entrega
I need to come up with a process for conducting a billing audit. I exported data from investment advisor software showing all accounts that were sent an invoice (columns A-D). I then exported data from from the software showing all accounts that had a management fee transaction, proving that the fee was in fact deducted from the account (columns F-I). As you can see, 34 accounts were sent an invoice but only 32 accounts had the fee deducted. I need a solution (vlookup??) that will go through the spreadsheet and find the 2 accounts that did not have fees deducted. This spreadsheet is a sample. The "real" one could be hundreds of accounts which is why I'm looking for a solution. I also would need the process to be documented so that I could use this audit procedure month after month.
Nº del proyecto: #18367490
Sobre el proyecto
8 freelancers están ofertando un promedio de $104 por este trabajo
Hello? How are you? I have good experiences in "I would like to hire an Excel Expert" as you can see my profile for these (Excel). I have been working for 7 yrs in this scope. While we contract and work in our jobs Más
I am a professional Data Analyst holding years of experience in utilizing advance level tools and functions of various data analytics softwares including Excel, Tableau and Power BI to create highly dynamic and automat Más
Hi. i am an affiliate chartered accountant and an excel expert since 2009. i can produce a solution within 24 hours of award. please contact.
Hi! Thank you for taking the time to read my proposal, My name is Uriel Baray I am a VBA Excel Expert with several years of experience on the field, if you are so kind to take a look to my portfolio, I have some sam Más
Hello. I have rich experiences in Excel and i'm interest to your project. I hope to work with you. Contact me please. Thank you.
Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more tha Más
It sounds like a task I enjoy doing. I have extensive experience in data processing and analyzing in Excel.