
Completed
Posted
Paid on delivery
I'm seeking a proficient Excel specialist to help me create a comprehensive spreadsheet for tracking client expenses and calculating my commission. The spreadsheet should be structured as follows: - Individual tabs for each client: Each client's tab will detail any expenses associated with that client, such as coaching, tickets, signage, and F&B. - Main Overview Page: This page will provide a summary of all clients and will automatically update whenever a new expense is added to a client's tab. The overview page will detail their total spend with us both in cash and cash saving contra, which then calculates my total commission. The ideal candidate should have: - Advanced Excel skills, particularly in creating complex formulas and managing multiple tabs. - Experience with financial spreadsheets and expense tracking. - Ability to create a user-friendly and visually appealing layout. Please note, I want to categorize the expenses by type. No graphical summaries are needed; text summaries will suffice. Please include expense categories such as tickets, coaching, signage production, food and beverage expenses, merchandise etc.
Project ID: 38855518
44 proposals
Remote project
Active 1 yr ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

$0 AUD in 3 days
8.8
8.8

Hello, I am a Microsoft certified Excel specialist and Google certified data analyst with over 10 years of experience. I can deaign an Excel workbook with individual tabs for each client and a summary page. I have reviewed the attached excel sheet and have a few questions before we begin the project. Please check out my profile to see my portfolio. I am available to discuss the project further. Regards, Aisha
$250 AUD in 7 days
9.3
9.3
44 freelancers are bidding on average $166 AUD for this job

"""""""""""""""""""ADVANCE EXCEL EXPERT/EXCEL EXPENSE TRACKER"""""""""""""""""""""""" ""Sir, I’ll create a user-friendly Excel tracker with individual client tabs for detailed expenses and a summary page to calculate total spend and your commission automatically. Categories like tickets, coaching, and F&B will be included for clear tracking. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 330+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$99 AUD in 1 day
7.5
7.5

Hello, I just came across your job posting and I'm quite intrigued by the opportunity. As an experienced freelancer with a strong track record, I believe I could be a valuable asset to your project. I'm eager to discuss the details further and see how my skills align with your needs. Please feel free to reach out to me at your earliest convenience so we can have a more detailed conversation about the project requirements and how I can contribute to its success. I'm prepared to begin working promptly once the details are finalized. Thank you for considering my application. I look forward to the possibility of collaborating with you. Best regards, Fatima
$250 AUD in 7 days
7.3
7.3

hey there, Already i check your attached EXECL file, I can provide you create a comprehensive spreadsheet for tracking client expenses and calculating your commission .And i can start the work right now and delivery the work within 8 hours.
$60 AUD in 1 day
6.3
6.3

-------------------I CAN DO IT RIGHT AWAY-------------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, Formulas, building an excel file, excel dashboard, pivot tables, Power BI, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$80 AUD in 1 day
5.9
5.9

With confidence in utilizing my advanced Excel skills, I am well-suited to design, structure and create the precise spreadsheet you require. My proficiency extends beyond basic formulas into managing multiple tabs and creating complex, yet understandable, spreadsheets that incorporate meticulous calculations. I also understand the significance of categorizing expenses by type. Moreover, I hold invaluable experience in accounting and finance; a career spanning over 7 years and counting. With this experience, I've executed seamless data migrations from various accounting software including QuickBooks, Xero and Wave - aligning well with your goal of achieving comprehensive expense tracking on one platform that is user-friendly. Additionally, my ability to deftly calculate accounts for both UK and US based companies reinforces my competence in managing client expenses and commission calculations. My clients consistently commend me for reliable and efficient processing of large volume financials. I ensure expense accuracy, as even minor missteps can snowball into significant discrepancies. With me onboard, maintaining transparent financial records will never feel like a chore rather a pleasure as I transform raw data into organized information that simplifies decision-making for maximum commission optimization.
$140 AUD in 7 days
5.8
5.8

Hello employer, I hold a Master's degree in Economics and statistics making me a suitable person for your project " Excel Spreadsheet for Client Expense Tracking ". I have more than 3 years of professional experience in statistical analysis. Besides, I have skills in Visual Basic, Data Processing, Data Entry, Microsoft Office and Excel. On Freelancer.com, I seek to help individuals, groups, or companies solve their statistical problems in various types of disciplines. My previous experience includes, but is not limited to: Descriptive Statistics, Visual Representation, Regression Analysis, Analysis of Variance, Nonparametric Statistics, etc. Click on my profile, (https://www.freelancer.com/hireme/monicawriter99) to see my profile reviews as well as have an insight into what I will do for you. Thank you.
$154 AUD in 2 days
5.1
5.1

Hello Ryan, I am excited to work on your project to create an Excel spreadsheet for tracking client expenses and calculating your commission. I propose to design individual tabs for each client detailing expenses like coaching, tickets, signage, F&B, and a main overview page summarizing all clients. This overview page will automatically update with new expenses, showcasing total spend and your commission. My advanced Excel skills will ensure complex formulas, multiple tab management, and user-friendly layout creation. I have experience in financial spreadsheets, expense tracking, and will categorize expenses by type as per your requirements. Let's collaborate to streamline your expense tracking process effectively. How would you prefer the commission calculations to be displayed on the overview page? Would you like specific breakdowns or an overall total? Regards, Rajat
$30 AUD in 6 days
2.8
2.8

As an Excel specialist, I have developed a reputation for creating comprehensive, user-friendly spreadsheets that cater to individualized tracking needs. My prior experience in financial spreadsheets and expense tracking makes me uniquely qualified to handle the complexity of systematically categorizing and managing your clients' expenses. Your request aligns perfectly with my skills in designing complex formulas, managing multiple tabs, and creating a visually appealing layout. I've also successfully implemented unique data management systems in the past, and your need to automatically update the main overview page as new expenses are added is something I am more than familiar with. My goal is to streamline your expense tracking process, ensuring accuracy while saving you time; this means you can focus on what really matters - serving your clients while growing your business In addition to my Excel expertise, The efficient workflow automation I have mastered will apply directly to your commission calculations, and beyond just creating the spreadsheet, a deeper understanding of finances means that we can tweak areas where you feel deem necessary to ensure maximal profit yield. I am excited about the opportunity to provide you my extensive skill set by tailoring them to meet your specific needs. Choose me quality delivery on time with attention to every detail, every single time! So why Wait? Let's start collaborating now!
$140 AUD in 7 days
3.3
3.3

As an experienced Data Analyst, I've had the opportunity to work with complex spreadsheets and harness Excel's power for extensive data organization and analysis. Tasked with expense tracking on various occasions, I’ve made significant contributions by creating detailed and easily verifiable summaries to fit specific needs of diverse organizations. I am confident in my ability to beautifully structure multiple tabs and formulas that will allow you to effortlessly categorize expenses by type in a visually appealing manner. Having honed my data manipulation skills using SQL, I will help you make your spreadsheet efficient and tidy by designing a robust database management system to manage your extensive datasets effectively. This ensures accurate results, less manual labor, and hence more time spent effectively elsewhere. Drawing from my extensive experience creating complex financial spreadsheets as a Data analyst and in the MERN stack, I can not only get the job done but exceed your expectations in visualizing cash saving contra as requested. Let's discuss how I can turn this vision into reality!
$140 AUD in 7 days
1.8
1.8

Hi, I am a UK-qualified ACCA accountant with extensive experience in designing financial spreadsheets and managing complex expense tracking systems. With advanced Excel skills, I can create the comprehensive spreadsheet you're looking for, ensuring that each client's expenses are tracked accurately and efficiently. The structure of the spreadsheet will include individual tabs for each client, where I will categorize expenses such as coaching, tickets, signage, food and beverage, and merchandise. Each tab will allow for easy input of expenses, and the data will automatically update on the main overview page. This page will summarize the total spend for each client, including both cash expenses and cash saving contra, and will calculate your commission accordingly. I will ensure that the layout is user-friendly and visually organized, with clear categories for each type of expense. The formulas will be designed to provide accurate tracking and commission calculations, without the need for graphical summaries. I look forward to helping you create an efficient and streamlined system to manage your client expenses and commissions. Best regards, Farooq Waseem ACCA
$70 AUD in 1 day
0.0
0.0

With an assortment of invaluable skills under my belt, I assure you that choosing me to handle your Excel spreadsheet project will bring about the desired precision and efficiency you seek. My wealth of experience as an administrative and executive virtual assistant has seen me expertly navigate projects involving complex spreadsheets, similar to yours. I am highly proficient with Microsoft Office Suite specifically Excel, and can confidently leverage its advanced features to build a meticulous expense tracking system for you. Expense tracking is no strange territory for me as I have overseen financial operations for several businesses in the past which required significant attention to detail like this project mandates. I completely comprehend the significance of categorizing expenses by type and my adeptness with creating formulas will allow me to effectively automate calculations related to your commission earnings. In addition, this project's requirement for a visually appealing layout perfectly aligns with my knack for creating aesthetically pleasing output. Even whilst juggling multiple tabs on the spreadsheet – a task that I do impressively well due to my multitasking capabilities– I will ensure that the main overview page bears a clean and understandable summary of all clients' expenses pairs with innovative designs if necessary. Choose me, Temitope, and rest assured your Expectations will not only be met but Would be surpassed.
$140 AUD in 7 days
0.0
0.0

Hi There! I have understood the requirements for the task. I have 8+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -Python -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks Anjali
$140 AUD in 7 days
0.0
0.0

No problem for me. I have done similar works to your project 2 months ago, so I am feeling confident with your project completion. Ping me to discuss with me please. Thanks and Best Regards
$140 AUD in 7 days
0.0
0.0

Dear Sir/Madam, I am an Excel VBA developer with 10 years experience in creating automated solution for manual reporting tasks. I can create you an Excel based tool in which you can add a new client with a button click on the ribbon. It will create a new sheet and it will be linked to the Main Overview Page together with the existing ones. Beside that, I will make the client sheet easy to fill with datepickers and dropdowns (expense categories). If you have many clients, I can create a navigation panel that makes it easy to go to a client's sheet using a search bar. Regards, Balint
$250 AUD in 7 days
0.0
0.0

Brisbane, Australia
Payment method verified
Member since Dec 3, 2024
₹750-1250 INR / hour
$8-15 USD / hour
$80-240 HKD
₹12500-37500 INR
$2-8 USD / hour
₹600-1500 INR
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹100-400 INR / hour
$10-30 AUD
₹750-1250 INR / hour
$15-25 USD / hour
$2-8 AUD / hour
₹12500-37500 INR
$15-25 USD / hour
₹100-400 INR / hour
$250-750 USD
₹400-750 INR / hour
€250-750 EUR