
Closed
Posted
Paid on delivery
I need a clean, easy-to-maintain Microsoft Excel workbook that tracks our business expenses and automatically splits net profit between two partners according to adjustable ownership percentages. Core data points for every expense must include the date of expense, type of expense, amount spent, and the category it falls under (e.g., marketing, supplies, travel). From there, the sheet should roll those figures into a monthly and year-to-date summary, subtract them from revenue, and then calculate each partner’s share of the remaining profit in real time. A simple input cell for each partner’s percentage is essential so we can update ownership stakes if they ever change. Deliverables • One unlocked Excel file with clearly labeled input sections, expense log, summary dashboard, and automated profit-sharing outputs • Built-in formulas (no external macros) that recalculate partner payouts instantly as new rows are added • Light formatting for readability—filters, alternating row colors, and a couple of at-a-glance totals or charts are welcome I’ll provide sample revenue figures once we start; you can mock up the sheet with placeholder data first if that helps. Let me know if you foresee any edge cases I should consider, and share a brief note on similar trackers you’ve built so I know we’re on the same page.
Project ID: 40558049
16 proposals
Remote project
Active 22 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
16 freelancers are bidding on average ₹1,497 INR for this job

As an experienced freelance in accounting and Excel, I come equipped with a proficiency that marries perfectly for your expense and profit-share tracker project. Accuracy is an integral part of my work ethic, so you can rest assured that every single figure will be handled with meticulous attention. Additionally, my fast turnaround time guarantees efficient work without compromising the quality. Building Microsoft Excel workbooks to automate processes brings me excitement. I have developed such trackers before with immense success, utilizing built-in formulas (no external macros) just as you have demanded. In a similar vein, I keep tabs on emerging accounting technologies such as QuickBooks, which allows me to provide integrated financial statements, ledgers and reconciliations among other things for your business.
₹600 INR in 1 day
3.5
3.5

Dear Client, I will create a clean, professional, and easy-to-maintain Excel workbook for tracking business expenses and automatically calculating profit shares between two partners. Features included: Dedicated expense log with columns for Date, Expense Type, Amount, Category, and Notes Flexible revenue input section Automatic monthly and Year-to-Date summaries Real-time profit calculation after expenses Adjustable ownership percentages for each partner with instant share updates Dashboard with key totals, filters, and simple charts for quick insights Clean formatting (alternating rows, conditional formatting, filters) All calculations use built-in Excel formulas only — no macros needed. The file will be unlocked and fully customizable. I will include placeholder data for testing and can incorporate your sample revenue figures immediately. Deliverables: One complete .xlsx file Clear labels and instructions inside the sheet Basic user guide (how to add expenses and update percentages) The tracker will be accurate, user-friendly, and ready for daily use. Ready to start right away. Looking forward to delivering this for you. Best regards,
₹1,050 INR in 1 day
3.5
3.5

I would love the opportunity to build your Excel Expense & Profit-Share Tracker. I have strong experience creating automated Excel workbooks with formulas, financial tracking, dashboards, and clean, user-friendly layouts that are easy to maintain without requiring macros. For your workbook, I will create: A well-organized Expense Log with Date, Expense Type, Category, Amount, and other relevant fields. Clearly separated input sections for revenue and adjustable partner ownership percentages. Automatic monthly and year-to-date summaries. Real-time net profit calculations after deducting all expenses. Automated profit-sharing calculations that instantly update as new revenue or expenses are entered. A clean dashboard with key totals, filters, alternating row formatting, and simple charts for quick insights. An unlocked Excel file using only built-in formulas, making it easy to edit and expand in the future. I will also use structured Excel Tables so formulas automatically extend as new records are added, eliminating the need for manual updates. A few edge cases worth considering include: Negative adjustments or refunds. One-time partner percentage changes during the year. Miscellaneous income or non-operating expenses. Optional tax or reserve deductions before profit distribution. Separate monthly payouts while maintaining accurate year-to-date totals.
₹6,000 INR in 7 days
1.4
1.4

Hi There, I can build a clean, automated, and easy-to-maintain Excel workbook to track your expenses and dynamically split your net profit. Based on my extensive data analytics background, including my current role as Senior Data Analyst, I frequently develop financial models, calculation sheets, and transaction trackers that prioritize user clarity and real-time updates. I will structure your workbook with a dedicated, tabular expense log capturing the date, type, amount, and category, and use dynamic Excel tables to ensure all monthly and year-to-date summary formulas expand automatically as you add rows. The dashboard will feature real-time profit-sharing calculations driven by adjustable percentage cells, letting you model ownership changes instantly. I will apply clean formatting, alternating row colors, data validation dropdowns for expense categories, and simple summary charts for a quick visual overview. No macros will be needed, keeping the file unlocked and fully secure. One edge case we should account for is handling unpaid or pending expenses to ensure your profit split aligns strictly with realized cash flow. Let's contact to discuss details. Solution Vector Roman Khakhula
₹1,500 INR in 7 days
0.8
0.8

Hi, I am a Certified Public Accountant (CPA) with 7+ years of experience in financial analysis, reconciliations, reporting, and advanced Microsoft Excel through Deloitte and Forvis Mazars. I regularly work with large datasets, financial models, and automated spreadsheets to support audit engagements and financial reporting. I can create a clean, user-friendly Excel workbook that includes: Expense log with categorized entries Monthly and year-to-date summaries Automated profit calculation after expenses Adjustable ownership percentage inputs Automatic profit-sharing calculations for both partners Built-in Excel formulas (no macros) Filters, formatting, dashboards, and summary charts for easy monitoring The workbook will be fully unlocked, easy to maintain, and designed so you can update transactions and ownership percentages without modifying formulas. My focus is on accuracy, automation, and creating a practical solution that's simple to use. I can also recommend improvements to make the tracker more scalable as your business grows. I am available to start immediately and can deliver a high-quality workbook within your required timeline. Thank you for your consideration. I look forward to working with you. Best regards, Celyn Benaso, CPA
₹1,000 INR in 7 days
0.0
0.0

Hello, I can create a clean and user-friendly Excel workbook that tracks expenses, calculates monthly and yearly summaries, and automatically distributes net profit between partners based on adjustable ownership percentages. The workbook will include: ✔ Expense entry table with categories and filters ✔ Revenue input section ✔ Automatic profit calculations ✔ Dynamic partner profit-sharing based on ownership percentages ✔ Monthly and year-to-date summaries ✔ Dashboard with key metrics and charts ✔ Organized formulas with no external macros required As an accounting student with experience working in Excel and business data organization, I focus on creating spreadsheets that are easy to use, maintain, and update. I can deliver a first version within 24-48 hours and make adjustments based on your feedback. Looking forward to working with you. Best regards.
₹1,050 INR in 3 days
0.0
0.0

Hi, Yes, I can build a clean, fully automated Excel workbook with adjustable partner percentages, expense tracking, monthly summaries, and real-time profit calculations using formulas only. Just a quick question: should the revenue be entered manually each month, or will it come from a separate sheet? I’m ready to start right away.
₹1,050 INR in 7 days
0.0
0.0

Hello, Your project is exactly the type of Excel workbook I enjoy building. I can create a clean, professional workbook that automatically tracks expenses, calculates net profit, and instantly splits profits between partners using adjustable ownership percentages. The workbook will include: • Well-organized expense and revenue entry sheets • Automatic monthly and yearly summaries • Dynamic profit calculations • Adjustable ownership percentages • Dashboard with charts and key financial summaries • Clean formatting, filters, and easy-to-maintain formulas • No external macros unless specifically requested I have experience creating professional Excel dashboards, automated reporting systems, and business tracking workbooks, with a strong focus on accuracy and ease of use. I maintain a 5-star Freelancer rating, and I also run a successful Etsy shop with 500+ sales and a 4.9/5 rating based on over 100 reviews, reflecting my commitment to delivering high-quality work and excellent customer service. I can begin immediately and provide updates throughout the project to ensure the workbook meets your exact requirements. I look forward to working with you.
₹1,000 INR in 1 day
0.0
0.0

Drawing from years of experience and proven expertise in data entry and excel, I am your top choice for this project. My meticulous attention to detail and efficient work process will ensure an excellent, easy-to-use Excel workbook that perfectly aligns with your needs. While automating the profit share component with adjustable ownership percentages should prove challenging, my skills in Excel shape my confidence to meet this substantial requirement. I have designed various business trackers like this in the past which makes me uniquely prepared for the job at hand. In all those previous projects, it was essential that the clients' interfaces were user-friendly, well-structured and easy-to-understand, especially so in instances where deciphering data is crucial to decision-making. Time and again, my designs proved to be valuable assets that simplified tracking processes for both individuals and teams alike, a skill I believe will be essential as we collate your revenue figures. Additionally, being skilled in localization translation into Simplified Chinese can be invaluable if you ever need to expand into different markets. My proficiency in localization translation allows me to accurately translate your Excel Workbook or other related documents into Simplified Chinese without compromising functionality. To conclude, engaging me on this project guarantees prompt delivery of a robust solution that is tailor-made for your business needs.
₹1,050 INR in 3 days
0.0
0.0

Hi, I can build this Excel tracker today. I will create one unlocked workbook with an expense log, revenue input area, monthly/YTD summary, adjustable ownership percentages, and automatic partner profit-share calculations using formulas only. No macros are needed. I can include placeholder data first so you can test the workflow, then replace it with your sample revenue figures. The file will be simple to maintain: add rows to the expense table and the summaries/payouts update automatically. I can also add a short instructions sheet so both partners know exactly where to enter expenses, revenue, and percentage changes.
₹1,000 INR in 1 day
0.0
0.0

Hi, I can build the Excel expense and profit-share tracker as one clean unlocked workbook with input sheets, an expense log, monthly/YTD summaries, and partner payout formulas. I would keep it formula-based, not macro-dependent, so you can update revenue, expenses, categories, and ownership percentages without needing any special setup. I will also add simple formatting, filters, totals, and a small dashboard view for quick review. I can mock it up with sample data first, then adjust the workbook once you share your real revenue and category structure.
₹1,200 INR in 3 days
0.0
0.0

I understand exactly what you need and can build it end‑to‑end: a single, well‑structured Excel workbook to track your business expenses and automatically split net profit between two partners according to adjustable ownership percentages. The workbook will include: * A clean expense log with date, type of expense, amount, and category (e.g., marketing, supplies, travel) * Monthly and year‑to‑date summaries that roll up all expenses * Revenue input (with placeholder data initially) and automatic net profit calculation (revenue minus expenses) * Adjustable partner ownership % input cells, with real‑time calculation of each partner’s share of profit * A simple dashboard with at‑a‑glance totals, filters, and a couple of charts for quick visibility I’ll also include clear labels, sample/placeholder data, and short usage notes so it’s easy for both partners to use from day one. To add more value, I can also build this on a shared online system like Google Sheets. I’ll structure it so both partners can update and view real‑time data from anywhere, including on mobile while on the move. This avoids version confusion, keeps you both aligned, and makes the file far more practical for daily use. My quote may be slightly higher than the lowest bids because I focus on long‑term usability: a visually clean, intuitive, and well‑documented system that you’ll actually enjoy using, not just a one‑time file that “just works.” You can suggest if you need a excel or a online version.
₹3,000 INR in 3 days
0.0
0.0

Bhubaneswar, India
Member since Jul 3, 2026
₹600-1500 INR
$10-30 USD
$15-25 USD / hour
₹750-1250 INR / hour
$30-250 USD
$30-250 USD
₹750-1250 INR / hour
₹100-400 INR / hour
€18-36 EUR / hour
₹12500-37500 INR
₹600-1500 INR
₹1500-12500 INR
₹100-400 INR / hour
₹600-1500 INR
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
$250-750 USD
₹6000-12000 INR
$750-1500 USD