Find Jobs
Hire Freelancers

I would like to hire an Excel Expert

$30-250 USD

Cancelled
Posted over 5 years ago

$30-250 USD

Paid on delivery
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.
Project ID: 18367490

About the project

8 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $104 USD for this job
User Avatar
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
$150 USD in 3 days
5.0 (159 reviews)
6.7
6.7
User Avatar
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.
$155 USD in 3 days
4.9 (63 reviews)
6.4
6.4
User Avatar
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.
$50 USD in 1 day
4.7 (42 reviews)
5.3
5.3
User Avatar
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 in 1 day
4.7 (28 reviews)
5.1
5.1
User Avatar
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
$35 USD in 3 days
5.0 (13 reviews)
4.0
4.0
User Avatar
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 in 3 days
4.3 (8 reviews)
4.1
4.1
User Avatar
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
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
It sounds like a task I enjoy doing. I have extensive experience in data processing and analyzing in Excel.
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Seattle, United States
0.0
0
Member since Dec 16, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.