I would like to hire an Excel Expert

Cancelado Publicado hace 5 años Pagado a la entrega
Cancelado 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.

Excel

Nº del proyecto: #18367490

Sobre el proyecto

8 propuestas Proyecto remoto Activo hace 5 años

8 freelancers están ofertando un promedio de $104 por este trabajo

ACMAuk

I am Chartered Management Accountant from Chartered Institute Of Management Accountants UK and CGMA from American Institute Of CPAs having 7 years of professional experience in development of highly professional spread Más

$150 USD en 3 días
(159 comentarios)
6.7
polarjin2017

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

$155 USD en 3 días
(63 comentarios)
6.4
daniyal3214

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

$50 USD en 1 día
(42 comentarios)
5.3
khurram1984

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.

$85 USD en 1 día
(28 comentarios)
5.1
urielbaray

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

$35 USD en 3 días
(13 comentarios)
4.0
lightingdavid

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.

$140 USD en 3 días
(8 comentarios)
4.1
JSAConsultants

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

$50 USD en 3 días
(0 comentarios)
0.0
mbgatlabayan

It sounds like a task I enjoy doing. I have extensive experience in data processing and analyzing in Excel.

$166 USD en 5 días
(0 comentarios)
0.0