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.
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 spreadsheets and financial models in MS-Excel.
I can facilitate with your required results as you desire of finding the account where the fee is not charged. The model would be robust and you would be able to use it for bigger spreadsheets also.
Contact us so that we can proceed accordingly.
Cheers,
FHK
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, I will get paid once you have confirmed satisfied result.
If I do not deliver satisfied result, I will never get paid from you.
We can discuss more details to understand more easily if you have other infos.
Hope to work with you.
Thank you.
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 automated dashboards and templates and perform various types of calculations, automation, analysis and computation. I will be happy to discuss in detail how I am highly suitable for this project.
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 samples for you there.
Please send me a message so we can discuss further details of your project
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 than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman