
Completed
Posted
Paid on delivery
Overview: Create an Excel workbook with three interconnected sheets: a "Client Portfolio" sheet, a "Client Deposits & Withdrawals" sheet, and a "Client Dashboard" sheet. This workbook will be used to track a specific client's (investor's) lending activities, including their investments, loans to customers, and their overall profit. All calculations must be automated using appropriate Excel formulas. Sheet 1: Client Portfolio This sheet will track all loan details for the client's customers. Data to be tracked (Columns): Customer Name: A text field for the name of the borrower. Contract Type: A drop-down list or text field (e.g., "New Loan," "Refinance"). Transaction Date: The date the loan was initiated. Original Loan Amount: The principal amount borrowed by the customer (e.g., $5,000). Total Loan with Interest: The total amount to be repaid by the customer, including the 20% fixed interest. This should be an automated calculation: Original Loan Amount * 1.20. Monthly Installment: The fixed monthly payment. This should be an automated calculation: Original Loan Amount * 10%. Payment Start Date: The date of the first monthly payment. Number of Payments: The total number of payments required to repay the loan. This should be an automated calculation: Total Loan with Interest / Monthly Installment. Monthly Payment Schedule: Create a series of columns (e.g., "Jan-25," "Feb-25," etc.) to track each customer's monthly payments. Each column should show the scheduled payment amount for that month. Payment Status: A column for each month's payment (e.g., "Jan-25 Payment Status"). This will be a manual entry field for "Paid" or a similar status. Remaining Balance: A column that automatically calculates the remaining total loan amount with interest after each monthly payment. Missed Payments Indicator: A flag or visual indicator that automatically counts and highlights customers who have missed a payment. For example, show a "Missed: 2" if a customer has missed two payments. Notes: A text field for me to add any comments or notes about the customer. Sheet 2: Client Deposits & Withdrawals This sheet will track the client's (investor's) cash flow with your office. Data to be tracked (Columns): Transaction Date: The date of the deposit or withdrawal. Transaction Type: A drop-down list with "Deposit," "Withdrawal," or "Office Fee." Amount: The dollar value of the transaction. Payment Method: A drop-down list with "Cash" or "Bank Transfer." Running Total: A column that automatically calculates the client's current balance with your office. Office Commission Fee: An automated calculation based on the number of active customers in the "Client Portfolio" sheet. 1–20 customers: $100 fee. 21–40 customers: $200 fee. This fee should be automatically deducted from the client's account balance at the appropriate time (e.g., at the end of each month). Sheet 3: Client Dashboard This sheet will serve as a high-level summary for the client. Key Metrics to display: Total Available Cash: The client's current balance, reflecting their deposits, withdrawals, and any fees. This should be directly linked to the "Running Total" from the "Client Deposits & Withdrawals" sheet. Total Principal Invested: The sum of all "Original Loan Amount" values from the "Client Portfolio" sheet. Total Interest Earned: The total interest earned from all customer loans. This should be a sum of all (Total Loan with Interest - Original Loan Amount) values. Total Profit (Compound): A calculation that shows the cumulative profit over time, taking into account the client's initial investment and the interest earned. This should update automatically as payments are made. Customer Count: The total number of active customers. Visual Charts: A simple chart or graph showing the client's Total Available Cash and Total Profit over time to visualize their investment growth. Additional Requirements: Use appropriate Excel formulas (e.g., SUMIF, VLOOKUP, IF statements, etc.) to ensure all calculations are automated. Design the workbook with a clean, professional layout that is easy to read and understand. Provide a brief guide or a set of notes explaining how to use and update the workbook, particularly for manual entries. Ensure the sheets are interconnected so that changes in one sheet (e.g., a new customer loan) automatically update the other sheets (e.g., the dashboard).
Project ID: 39692813
41 proposals
Remote project
Active 11 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

alsalam ealaykum I’ve reviewed your requirements and prepared a sample of the Client Portfolio sheet to showcase the automation, clean design, and formulas I’ll deliver. One point to clarify is the Monthly Payment Schedule. Fixed columns like “January-25,” “February-25,” etc. can become messy when loan terms vary (e.g., 12 vs. 50 months). Instead, I propose a dynamic schedule table that generates only the needed months per loan, calculates due dates from the Payment Start Date, and tracks paid/missed status without wasting space — keeping it clean, scalable, and easy to maintain. Final workbook features: Automated 3-sheet system (Portfolio, Deposits & Withdrawals, Dashboard) with interconnected formulas. Loan tracking with interest, installments, balances, and missed payment flags. Cash flow with running totals, transaction types, and automated monthly commission fees. Dashboard with cash, principal, interest, profit, customer count, and charts. Advanced Excel functions and optional VBA for smooth automation. Professional, user-friendly formatting. Step-by-step usage guide. I can share my sample sheet immediately so you can review my work style before awarding the project. Best regards, Bassiouny Mohamed
£35 GBP in 7 days
1.4
1.4
41 freelancers are bidding on average £38 GBP for this job

Hi Abdulhadi, Thank you for considering my proposal. With over 8 years of real-world experience and freelance work in Excel, I am well-equipped to assist you with your Comprehensive Lending Activity Tracker project. I have carefully reviewed the project requirements and am eager to discuss it further with you. I would like to connect with you in chat to delve deeper into the specifics of your project and how I can tailor my expertise to meet your needs. Regards.
£20 GBP in 1 day
7.2
7.2

Hi, I am an experienced certified Cost And Management Accountant (ACMA) and Financial Analyst and Certified Public Accountant (CPA) having more than 7+ years' experience in finance. I have gone through your project with interest and it seems a perfect match with my skills. May I ask you a few questions about your project? What’s the principal activity of your business? Do you have any specific reporting requirements? When would you like to start? I have been providing Financial Modelling, Business Analysis, Business Plan, Financial Analysis, Financial Forecasting, Excel, Advance Excel, Visual Basics, Payroll, Data Processing, Data Entry, Finance, Accounting, Financial Research services and serve my more than 3+ years with top rated Audit firm (KPMG) during which I have dealt with a number of clients and provided them extremely satisfied services. Apart from that, I am also highly proficient in different accounting software packages like Excel, Advance Excel, Quick Book, Intuit Quick Book ,XERO, Microsoft Dynamic, Enterprise and more. I am a fast learner, problem solver, detail oriented and highly organized. Looking forward to hearing from you soon! Looking forward to hearing from you Thanks & Regards. Zakwan
£35 GBP in 1 day
6.2
6.2

Hi there, I'm Ravinder, a detail-oriented professional with more than 15 years of experience in accounting, finance, and data automation using Excel VBA and Power BI, which makes me an apt fit for your lending activity tracker project. I have already completed over 180 projects on various platforms, and not only do I tick all the boxes for the skills you've mentioned but I exceed them with my ability to bring valuable insights through data visualizations and dynamic charts. I have a strong command over advanced Excel formulas needed for automating the three interconnected sheets required for comprehensive tracking. Moreover, I understand that running a financial institution involves complex calculations. My proficiency in financial modeling, cash flow management, and budgeting will ensure that all your loan details in the "Client Portfolio" sheet are correctly calculated and accurately represented. I will incorporate IF statements, VLOOKUP along with other relevant formulas to achieve your desired automated calculations effortlessly. In conclusion, not only do I bring extensive expertise in accounting & finance but also а sophisticated skillset in Excel macros, Dashboards (including interactive & automated ones), data analysis, and modeling to ensure that your work gets done throughly as per the described specs. My highly flexible schedule ensures that your work will always get my undivided attention and will be delivered efficiently with absolute data accuracy on time.
£50 GBP in 2 days
6.3
6.3

I am thrilled to bid on this project, leveraging my 12+ years of experience in refining academic writing, research papers, and dissertations. My personalized approach is designed to help you achieve your academic goals, whether you're looking to improve your writing skills, enhance your research, or perfect your dissertation. I offer a comprehensive range of services tailored to your needs, including academic consultation, research paper editing, dissertation support, essay writing assistance, and expert formatting in Harvard, APA, MLA, Chicago, and Vancouver styles. My goal is to provide you with the guidance and support you need to produce high-quality work that showcases your knowledge and expertise. By working together, I am confident that we can achieve great results, including improved writing clarity, coherence, and structure, leading to better academic performance and increased confidence. I'm excited about the opportunity to collaborate with you and help you reach your full potential. Please message me for further discussion!
£20 GBP in 1 day
6.4
6.4

Hello there,, I've just checked your project detail carefully. I am eager to apply for the position of business plan writer for your technology-focused startup. With extensive experience in creating detailed and effective business plans, I am confident in my ability to help attract potential investors and provide a clear strategic direction for your business-to-business operations. With my expertise in financial research, business analysis, and market research, I am well-equipped to create a robust business plan that will attract potential investors and guide your operations effectively. My experience in the technology sector and working with business-to-business operations will enable me to tailor a plan that meets your specific needs. I specialize in creating business plans for technology-focused startups, particularly those targeting the business-to-business market. For your project, I will develop a detailed plan that covers all essential aspects, including market analysis, business strategy, financial projections, and operational guidelines. My goal is to provide a clear and compelling document that attracts potential investors and serves as a roadmap for your business operations. Best Regards
£20 GBP in 1 day
5.2
5.2

My name is "Usama Safdar" and I am a Ph.D degree holder which means I am highly-capable to tackle this project "Content Editor " with 100 percent accuracy. I am a professional writer with over 6 years of experience in writing; Essays, Research Summaries, Thesis, Dissertation, Lab Reports and Case Studies. I always provide High-Quality Solutions within the shortest possible time with all instructions followed against very reasonable prices. I can manage works even with shortest deadlines like; "2500 words work in just 6 Hours" with very reasonable time. As a pro academic writer I am also familiar with all the referencing styles; such as APA, Harvard, OSCOLA, IEE, MLA etc. I always provide plagiarism-free solutions and as a prove I also provide "FREE Turnitin reports". For Samples, please visit my profile https://www.freelancer.com/u/SolutionMart Please message me to start the discussion. Thank You
£20 GBP in 1 day
5.2
5.2

My name is Rabia Faisal, I am working in the writing industry since 2011. During this time, I have served countless clients with a full amount of satisfaction by providing them with TOP Quality Solutions. I have command of all references APA, Harvard, IEEE, MLA & Chicago, etc. I will provide plagiarism-free work with 100 percent accurate grammar within your given deadline. Please message me to get Top Class Services. I am waiting; https://www.freelancer.com/u/TopWritingGuru
£20 GBP in 1 day
5.3
5.3

Hi, I have an M.B.A in Business and Finance form Harvard University, and more than 10 years of experience business and data analysis consultant, I have helped clients take off their business and reach new heights by optimizing the strategy, research, analyzing their market and competitive position, and creating a clear and compelling business plan to articulate their opportunity. I can surely assist you in writing a business plan. Here is what I can write for you in your business plan. 1. Executive summary 2. Opportunity in your field 3. Products and services 4. Execution of your plan 5. Marketing strategies 6. Competitor Analysis 7. Financial plan 8. Data Analysis I will provide you with a financial plan that includes how you'll finance your business, costing and financial projections. It will be a well-planned and well-researched business plan with the financials of up to 5 years. Let's chat to discuss your business. Thank you.
£20 GBP in 1 day
4.9
4.9

As an experienced MS Office expert, I can promise a comprehensive and streamlined lending activity tracking system, customized to your every requirement. My mastery of MS Excel includes advanced functions like SUMIF, VLOOKUP, IF, that would be your best bet for automating the vast calculations specified in your project overview. I've created countless client portfolio trackers, but none as complex and interconnected as what you need here. That's why my positive attitude, meticulous work style and proclivity for deadline delivery makes me the perfect partner for your project. In addition to technical skills, my Excel portfolio includes creating diverse dashboards and pivot tables from scratch. This means I understand the right visual representation of numbers to construct clear value-oriented narratives from your data. Lastly, beyond just raw technical prowess--what differentiates me is a focus on recognizing and understanding the unique needs of every project I undertake. I offer personalized solutions woven with my prompt communication skills throughout--ensuring we're always on the same page. Such dedication endows projects with life rather than just the repetitive functions within them. Let's team up now and solidify our path towards an integrated and powerful lending tracker system!
£35 GBP in 7 days
4.8
4.8

Hello there,, I have advanced experience in Data Mining, Statistics, Statistical Analysis and Data Science. With my vast background in data analysis and management, I am confident in my ability to handle your categorical data project effectively and efficiently. I have extensive experience in collecting, cleaning, analyzing, and visualizing data using Python programming, an invaluable asset for a project of this nature. Additionally, I am well-versed with CRISP-DM framework and adept at identifying patterns within datasets Choosing me means benefitting from not only my expertise but also my personal approach to projects. I understand that each task is unique, requiring tailored skills, and so I'm willing to go the extra mile to provide you with results that meet and exceed your expectations. Let's join forces in this project as our combined strengths will surely produce a result that's efficient, elegant and insightful! Let's not waste any more time! Together, we can mine this data efficiently and answer the questions to achieve your goals. Best Regards, Thanks
£20 GBP in 1 day
4.4
4.4

Hi I have read your requirements regarding the money lending tracker i can make it i need to discuss some details with you so let's chat and move further
£30 GBP in 1 day
3.5
3.5

As a passionate and highly-skilled Data Scientist and Statistical Analyst, my expertise perfectly aligns with your project description. I have exceptional proficiency in Excel, which is vital for this project's successful completion. Over the years, I've developed comprehensive Excel workbooks just like what you're demanding, complete with interconnected sheets and automated calculations using appropriate formulas. In addition to my Excel mastery, I'm experienced in Data Science & Analytics, which gives me an edge on how to effectively track and present complex data in an organized manner. Not only would I automate all the calculations as specified for each column but also ensure a visually appealing User Interface (UI) that accurately represents all the key metrics. Moreover, I believe in clean, reproducible and well-documented code that guarantees ease of use and future modifications. Finally, I add value beyond just coding. With my background in machine learning and data-driven decision-making, I can integrate advanced functions into your workbook such as advanced regression analysis that may be required for forecasting or addressing any other pressing needs you might have. Choose me for your project to embrace meaningful insights from your lending activity tracker while streamlining its use through effective data representation and automation!
£30 GBP in 2 days
3.2
3.2

Hello, I’ve reviewed the project outline for creating a detailed lending activity tracker in Excel. It sounds like a fantastic way to manage client investments and loan repayments, ensuring accuracy and automation. My background in financial modeling and Excel spreadsheet development makes me a strong fit for this task. I’ve successfully built similar tracking systems for various investment portfolios. I’m happy to discuss the specifics further and provide a more detailed estimate. Would you be available for a brief call to explore the project in more detail?
£35 GBP in 5 days
1.7
1.7

Hi, I understand that you need an Excel workbook with three connected sheets to track your client's lending activities, investments, and profit. I can create this for you with all calculations done automatically. The workbook will include: 1. Client Portfolio Sheet • Record all customer loan details (Name, Contract Type, Date, Amount, etc.) • Automatic calculations for total loan with interest, monthly installments, and remaining balance • Payment schedule for each month with status (“Paid” or missed) • Automatic missed payment alerts • Notes section for extra comments 2. Client Deposits & Withdrawals Sheet • Record deposits, withdrawals, and office fees • Automatic running balance • Office commission fee calculation based on number of customers (e.g., $100 for 1–20 customers, $200 for 21–40 customers) 3. Client Dashboard Sheet • Show total cash available, total principal invested, interest earned, and total profit • Show number of active customers • Simple chart to display cash and profit growth over time Additional Features • All sheets will be linked, so updates in one sheet will reflect in others automatically • Clean, professional layout • Short guide on how to use and update the file I will make sure the workbook is easy to use, accurate, and ready for your needs. Thank you,
£50 GBP in 7 days
1.9
1.9

I commend you on this project's scope and complexity. As an experienced data professional, my expertise in data visualization and Excel would be wonderfully suited to deliver the automation tools, interconnected sheets, and all other nuanced features you require. I've handled a variety of financial and data-intensive projects that employ complex Excel formulas similar to yours, so I'm confident in developing meticulous systems that eliminate manual errors while providing the vital figures of your operation. My degree in Mathematics & Computing supplements my deep knowledge of Excel functions like SUMIF, VLOOKUP, IF statements, which are crucial here. These will be instrumental not only for automating calculations like the loan interest and monthly installments but also for tasks like plotting visual charts to showcase investment growth over time. Finally, meticulousness is at the heart of what I bring to the table. Accuracy is everything when it comes to financial tracking, and you can count on me to deliver highly reliable solutions. With me on board, you get a skilled data expert who values precision and professionalism above everything else.
£35 GBP in 4 days
0.7
0.7

Your project deserves a clean, seamless solution — and that’s exactly what I deliver. I understand the need for automated calculations, interconnected sheets, and a professional layout. Using advanced Excel formulas, I will create a user-friendly workbook that tracks lending activities and cash flow while providing insightful metrics in a clean design. While I am new to Freelancer, I bring years of hands-on experience and have successfully delivered similar projects off-site. I’m committed to delivering your project successfully to build a strong, trusted profile here. I would love to chat more about your project! Regards, Romano Coetzee
£50 GBP in 10 days
0.0
0.0

?YOU PAY WHEN YOU ARE HAPPY WITH THE WORK ? I am a person for your project, I will work with you until you are 100% satisfied. Your project requiring automated Excel tracking of investment activities aligns perfectly with my expertise in creating clean, professional, and user-friendly integrated workbooks. While I am new to Freelancer, I have ample experience outside the platform. I would love to chat more about your project! The worst that can happen is you walk away with a free consultation. Regards, Brandon Booth
£50 GBP in 14 days
0.0
0.0

Hi,sir I need this project I need money to pay my university fee please give me this project I’m an Excel expert with strong skills in data entry, formulas, dashboards, and automation (VBA). I’ve done similar projects and can deliver accurate, professional work fast. Let’s discuss your project – I’m ready to start now. Thanks, Muhammad Asad
£20 GBP in 2 days
0.0
0.0

I will design a professional Excel workbook with three interconnected sheets to manage a client’s lending portfolio and cash flow. Sheet 1: Client Portfolio – Tracks borrower details including name, contract type, transaction date, original loan, total with fixed 20% interest (auto-calculated), monthly installment (10% of original loan), payment start date, number of payments, monthly payment schedule, payment status, remaining balance, and missed payment indicators. Sheet 2: Deposits & Withdrawals – Logs client’s deposits, withdrawals, and office fees. Includes automated running balance and monthly office commission based on active customers (1–20 = $100, 21–40 = $200). Sheet 3: Dashboard – Displays total cash available, principal invested, total interest earned, cumulative profit, customer count, and visual charts for growth trends. All calculations will use automated formulas (SUMIF, VLOOKUP, IF, etc.). The design will be clean, user-friendly, and fully linked so updates in one sheet reflect in others. A usage guide will be included.
£35 GBP in 7 days
0.0
0.0

✅ EXCEL EXPERT HERE! ✅ To automate your loan tracking effectively, I’ll implement advanced Excel formulas like SUMIF and VLOOKUP across all three sheets, ensuring seamless interconnectivity. This will allow you to track customer loans, deposits, and overall profits effortlessly. With over 5 years of experience in Excel, I specialize in creating detailed, dynamic spreadsheets tailored to client needs. I’ll ensure that all calculations—from monthly payments to total profit—are automated and that the workbook features a clean, professional design. Additionally, I’ll provide a brief user guide to help you with manual entries and navigation. I’m ready to start on this project and would love to discuss your specific needs further. Best Regards,
£35 GBP in 7 days
0.0
0.0

Lambeth, Saudi Arabia
Payment method verified
Member since Aug 9, 2025
£20-250 GBP
₹150000-250000 INR
₹600-1000 INR
$250-750 USD
$30-250 AUD
₹12500-37500 INR
₹12500-37500 INR
$250-750 CAD
$30-250 USD
₹600-1500 INR
£20-250 GBP
₹750-1250 INR / hour
₹12500-37500 INR
$250-750 USD
€30-250 EUR
£18-36 GBP / hour
₹12500-37500 INR
$10-30 USD
₹12500-37500 INR
$2-8 USD / hour
₹600-1500 INR