Mutual Fund and SIP Tracker in Google Sheets helps investors and advisors track fund value, SIP status, invested amount, current value, and monthly contribution in one editable Google Sheets file. AMFI reported Rs. 31,781 crore collected through SIPs in June 2026, while Indian mutual fund AUM stood at Rs. 82.22 lakh crore as of June 30, 2026. Built by PK for a 300K+ subscriber learning audience, this one-time $6.99 tracker avoids recurring app fees and keeps your spreadsheet under your Google Drive control.
Key Features of Mutual Fund and SIP Tracker in Google Sheets
- Total Portfolio Value card: See the current high-level portfolio value before reviewing fund-level details.
- Overview dashboard: Review allocation, SIP status, invested value, current value, and monthly SIP contribution from one page.
- Multiple slicers: Filter the dashboard quickly by available fields so reviews stay focused.
- Fund-level charts: Compare invested value and current value by fund name for easier performance checks.
- SIP status tracking: Separate active, paused, closed, or custom SIP statuses using dropdown-driven lists.
- Reference List sheet: Maintain Fund Category, AMC / Fund House, and Status options in one setup area.
- Google Sheets workflow: Copy the file to Drive, edit the dropdown lists, and share view or edit access with trusted collaborators.
What’s Inside the Mutual Fund and SIP Tracker in Google Sheets
1 – Overview Page
The Overview Page is the main reporting page for the tracker. The top Total Portfolio Value card gives a fast portfolio snapshot, while slicers let you filter the dashboard without rebuilding formulas.
Fund Allocation by Category: This chart shows how the portfolio is distributed across fund categories. It helps you spot concentration in equity, debt, hybrid, index, or other custom groups.
SIP Count by Status: This view counts SIPs by status, such as active, paused, stopped, or completed. It helps investors review which plans are still running and which need follow-up.
Invested Value by Fund Name: This chart compares the original invested amount across funds. It shows where capital has been committed before checking current market value.
Current Value by Fund Name: This chart compares the latest value across fund names. It helps identify which funds carry the largest current portfolio weight.
Monthly SIP Contribution by Fund Name: This chart shows planned or active monthly SIP amounts by fund. It helps users review recurring cash flow and rebalance future contributions.
Mutual Fund and SIP Tracker in Google Sheets
2 – Reference List Sheet
The Reference List sheet stores dropdown values used across the tracker. Clean lists reduce typing errors and keep slicers, summaries, and chart labels consistent.
Fund Category by Dropdown List: Add or edit category names so each mutual fund can be grouped consistently.
AMC / Fund House by Dropdown List: Maintain fund house names in one place so the same AMC is not typed multiple ways.
Status by Dropdown List: Control status labels for SIP tracking, such as Active, Paused, Closed, or Watchlist.
Reference List Sheet
Mutual Fund and SIP Tracker in Google Sheets vs. Microsoft Excel Tracker vs. Paid Portfolio SaaS – Where This Fits
| Feature | This Google Sheets tracker | Microsoft Excel tracker | Paid portfolio SaaS |
|---|---|---|---|
| Cost | $6.99 one-time sale price | Template cost plus possible Microsoft licensing | Usually monthly or annual subscription |
| Platform | Google Sheets in Drive | Excel desktop or web | Vendor-hosted app |
| Setup time | Copy file, edit lists, enter fund records | Open workbook and customize formulas | Create account, configure portfolios, import data |
| Real-time collaboration | Native Google Drive sharing | Requires OneDrive or SharePoint workflow | Depends on plan |
| Customizable fields | Editable dropdown lists, formulas, labels, and charts | Editable if workbook is unlocked | Often limited by vendor settings |
| SIP-focused view | SIP count, status, and monthly contribution by fund | Must be built or adapted | Depends on product features |
Who This Template Is For – and Who It’s Not For
This tracker is for individual investors, financial advisors, mutual fund distributors, finance coaches, families, and small offices that want a clear spreadsheet view of mutual fund holdings and SIP activity.
It is not a live NAV feed, trading tool, tax filing system, brokerage connector, or investment advice product. Use it for structured tracking after entering or pasting your own fund data.
How to Use the Mutual Fund and SIP Tracker in Google Sheets
- Open the PDF guide included with the download and click the Google Sheets copy link.
- Create your own editable copy in Google Drive.
- Review the Reference List sheet and update Fund Category, AMC / Fund House, and Status values.
- Enter or paste your mutual fund and SIP records in the connected tracker structure.
- Open the Overview Page and use slicers to filter the dashboard.
- Review total portfolio value, fund allocation, SIP status, invested value, current value, and monthly SIP contribution.
Real-World Use Cases
Neha, individual investor: reviews active SIPs and monthly contribution by fund before adjusting future investments.
Arjun, financial advisor: uses category allocation and current value by fund to prepare a client portfolio review.
Meera, family finance planner: tracks multiple fund houses and SIP statuses in one shared Google Sheet.
Frequently Asked Questions
Does this tracker work in Google Sheets?
Yes. It is designed for Google Sheets and should be copied into your own Google Drive account.
What does the Overview Page show?
It shows Total Portfolio Value, fund allocation by category, SIP count by status, invested value, current value, and monthly SIP contribution by fund name.
Can I customize fund categories and AMC names?
Yes. The Reference List sheet lets you edit Fund Category, AMC / Fund House, and Status dropdown values.
Does it connect to live NAV data?
No. This tracker is built for manual entry or pasted data, which keeps it editable and simple to audit.
Can I share it with someone else?
Yes. You can share your copied Google Sheet using standard Google Drive permissions.
Is this investment advice?
No. It is a tracking template and does not provide financial, tax, legal, or investment recommendations.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
You may also like Investment Management Dashboard in Google Sheets, Stock Portfolio Tracker in Google Sheets, Personal Finance Net Worth Tracker in Google Sheets, and Mutual Funds Dashboard in Power BI. Browse more Google Sheets tracker templates and Google Sheets financial tools.
Watch the step-by-step video Demo:
Add the Mutual Fund and SIP Tracker in Google Sheets to your finance toolkit and review portfolio value, SIP status, fund allocation, and monthly contributions from one editable spreadsheet.
Last updated: July 23, 2026.
Compatibility and Requirements
- Works in Google Sheets. You need a free Google account and a web browser.
- Fund Category, AMC / Fund House and Status come from dropdown lists on the Reference List sheet. Google explains dropdowns in Create an in-cell dropdown list.
Reviews
There are no reviews yet.