Automated Mutual Fund Excel Dashboard

I keep a running list of every lumpsum, SIP and SWP I make, but right now all I have is a raw spreadsheet. I need a single Excel workbook that turns that manual entry into clear, fully-automated insights on my mutual-fund portfolio.

Here is what I have in mind:
• One Transactions sheet where I will continue to type or paste each deal (lumpsum, SIP, SWP, redemption, etc.).
• A Holdings statement, organised the way mutual-fund investors actually think—fund-wise totals with units held, average cost, current NAV, current value, and unrealised gain/loss in both ₹ and %.
• Dynamic reports that spin off automatically from the data:
– Detailed transaction register
– Valuation snapshot that recalculates the moment I update NAVs
– A concise summary page highlighting original investment, current value, absolute return, CAGR/XIRR and other key ratios.

If you can also leave hooks for future add-ons such as performance summaries, dividend tracking or capital-gains breakdowns, even better.

Deliverables
1. An unlocked Excel (.xlsx) file with all formulas, pivot tables/charts and VBA or Power Query (if used) clearly documented.
2. Short user guide explaining where I paste new transactions and how the calculations refresh.
3. Quick hand-off call or video walk-through after delivery.

Acceptance criteria
• Entering or editing a row on the Transactions sheet automatically updates the Holdings statement and all reports with no further input.
• CAGR/XIRR and valuation figures match sample numbers I will supply.
• Workbook performs smoothly on Microsoft 365 desktop (Windows).

If this sounds like your cup of tea, let’s get started—I’m ready to share my current file and sample data right away.