Built and run by one person.

Composition Validation

The cross-checks behind the holdings data, with the current pass and mismatch counts.

Source data: AMFI official NAV files - 37 million and growing daily, 38,000+ (about 8,600 active, the rest matured or merged), 2006-04-01 to present · Last updated: 2026-06-30
Live tool

Analyze any Indian mutual fund or portfolio across 30+ return, risk and benchmark metrics in the live MFPRO tool.

This page publishes the composition-validation results shown live in the app under Composition > Methodology > Validation. For every fund and every month we load, we independently sum every holding-level market value in our database and compare that total against the fund house's own Grand Total in its published portfolio disclosure.

A row passes when our database total matches the AMC's stated grand total to within a small rounding tolerance. Every difference is reported exactly, never smoothed. The handful of non-matching rows are each documented in the notes below: most are a deliberate methodology difference (for example, we include derivative mark-to-market that the fund house excludes from its stated grand total), and a few are a genuine error in the source spreadsheet. None is a gap in our parsing - our holdings sum matches the disclosure's own section sub-totals in every case.

Summary

Across 216 fund-month combinations covering 9 monthly snapshots (2025-06-30 to 2026-06-30), 205 reconcile to within tolerance and 11 carry a documented, explained difference - a deliberate methodology choice or a source-file error, never an unexplained gap.

MetricValue
Fund-month combinations216
Passing (within tolerance)205
Documented differences (explained)11
Monthly snapshots9
Coverage2025-06-30 to 2026-06-30

How to Read This Table

Excel Grand Total is the total the AMC states in its disclosure. DB Total is our independent sum of every holding we parsed and loaded. Difference and Diff % are the exact gap between the two. Status is PASS when the gap is within rounding tolerance, FAIL when there is a larger gap - which we then investigate and explain (see Documented Differences below). Values are in the same unit the disclosure reports (Rs. lakh).

Documented Differences (11)

Each row below is a non-match we investigated and can fully explain. Most are a deliberate methodology difference - we include derivative mark-to-market that the fund house excludes from its stated grand total - so the gap is expected, not an error on either side. The PPFAS rows are a genuine hardcoded-cell error in the source spreadsheet (the stated grand total is a typed value, not a formula). In every case our independent holdings sum matches the disclosure's own section sub-totals; we publish these as-is rather than hide them.

FundMonthDifferenceDiff %Reason
KOTAKFLEXICAP2025-09-3010,414.580.1926%Futures MTM Rs 10,414 (0.19%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKFLEXICAP2026-03-3144,219.830.8818%Futures MTM Rs 44,220 (0.88%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKFLEXICAP2026-05-3116,351.840.2984%Futures MTM Rs 16,352 (0.30%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-01-3113,391.400.2268%Futures MTM Rs 13,391 (0.23%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-02-2813,787.970.2235%Futures MTM Rs 13,788 (0.22%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-03-3137,784.810.6787%Futures MTM Rs 37,785 (0.68%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-04-3016,445.860.2588%Futures MTM Rs 16,446 (0.26%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-05-3115,348.610.2370%Futures MTM Rs 15,349 (0.24%) intentionally included; Kotak excludes derivatives from Grand Total
KOTAKMIDCAP2026-06-3012,997.470.1922%Futures MTM Rs 12,997 (0.19%) intentionally included (KEI 9,515 + Persistent 3,482); Kotak excludes derivatives from Grand Total
PPFASFLEXICAP2025-09-3015.060.0001%PPFAS Grand Total cell F195 is hardcoded as =11972317.44+15.06 (not a SUM formula). Our sum of all holdings matches section sub-totals exactly but is Rs 15.06 more than their Grand Total. Error is in PPFAS spreadsheet, not our converter.
PPFASFLEXICAP2026-04-3084.100.0006%PPFAS Grand Total hardcoded mismatch Rs 84.10 (0.0006%). Same pattern as 2025-09-30 - error in PPFAS spreadsheet, not our converter.

Full Reconciliation Results

FundMonthExcel Grand TotalDB TotalDifferenceDiff %Status
AXISFOCUSED2025-06-301,302,465.101,302,465.100.000.0000PASS
AXISFOCUSED2025-09-301,225,684.681,225,684.680.000.0000PASS
AXISFOCUSED2025-12-311,197,169.561,197,169.560.000.0000PASS
AXISFOCUSED2026-01-311,138,180.011,138,180.010.000.0000PASS
AXISFOCUSED2026-02-281,130,512.921,130,512.920.000.0000PASS
AXISFOCUSED2026-03-31996,674.15996,674.150.000.0000PASS
AXISFOCUSED2026-04-301,079,367.131,079,367.130.000.0000PASS
AXISFOCUSED2026-05-311,066,602.471,066,602.470.000.0000PASS
AXISFOCUSED2026-06-301,107,838.921,107,838.920.000.0000PASS
AXISMCF2025-06-303,206,852.433,206,852.430.000.0000PASS
AXISMCF2025-09-303,114,694.143,114,694.140.000.0000PASS
AXISMCF2025-12-313,171,714.743,171,714.740.000.0000PASS
AXISMCF2026-01-313,089,529.953,089,529.950.000.0000PASS
AXISMCF2026-02-283,197,711.793,197,711.790.000.0000PASS
AXISMCF2026-03-312,883,453.942,883,453.940.000.0000PASS
AXISMCF2026-04-303,227,632.033,227,632.030.000.0000PASS
AXISMCF2026-05-313,285,212.823,285,212.820.000.0000PASS
AXISMCF2026-06-303,380,299.683,380,299.680.000.0000PASS
AXISSMALLCAP2025-06-302,637,920.222,637,920.220.000.0000PASS
AXISSMALLCAP2025-09-302,597,537.692,597,537.690.000.0000PASS
AXISSMALLCAP2025-12-312,654,688.462,654,688.460.000.0000PASS
AXISSMALLCAP2026-01-312,551,675.512,551,675.510.000.0000PASS
AXISSMALLCAP2026-02-282,600,772.322,600,772.320.000.0000PASS
AXISSMALLCAP2026-03-312,391,864.982,391,864.980.000.0000PASS
AXISSMALLCAP2026-04-302,736,396.942,736,396.940.000.0000PASS
AXISSMALLCAP2026-05-312,784,005.192,784,005.190.000.0000PASS
AXISSMALLCAP2026-06-302,939,379.382,939,379.380.000.0000PASS
FRANKLINFOCUSED2025-06-301,224,876.381,224,876.380.000.0000PASS
FRANKLINFOCUSED2025-09-301,224,876.381,224,876.380.000.0000PASS
FRANKLINFOCUSED2025-12-311,224,876.381,224,876.380.000.0000PASS
FRANKLINFOCUSED2026-01-311,186,991.431,186,991.430.000.0000PASS
FRANKLINFOCUSED2026-02-281,175,038.131,175,038.130.000.0000PASS
FRANKLINFOCUSED2026-03-311,030,136.741,030,136.740.000.0000PASS
FRANKLINFOCUSED2026-04-301,081,906.911,081,906.910.000.0000PASS
FRANKLINFOCUSED2026-05-311,070,811.341,070,811.340.000.0000PASS
FRANKLINFOCUSED2026-06-301,088,391.311,088,391.310.000.0000PASS
HDFCFLEXICAP2025-06-307,958,453.557,958,453.550.000.0000PASS
HDFCFLEXICAP2025-09-308,555,959.128,555,959.120.000.0000PASS
HDFCFLEXICAP2025-12-319,629,499.069,629,499.060.000.0000PASS
HDFCFLEXICAP2026-01-319,745,156.319,745,156.310.000.0000PASS
HDFCFLEXICAP2026-02-2810,045,531.9510,045,531.950.000.0000PASS
HDFCFLEXICAP2026-03-319,133,490.819,133,490.810.000.0000PASS
HDFCFLEXICAP2026-04-3010,047,923.0810,047,923.080.000.0000PASS
HDFCFLEXICAP2026-05-3110,182,182.4410,182,182.440.000.0000PASS
HDFCFLEXICAP2026-06-3010,649,563.1110,649,563.110.000.0000PASS
HDFCFOCUSED2025-06-302,086,827.412,086,827.410.000.0000PASS
HDFCFOCUSED2025-09-302,353,298.252,353,298.250.000.0000PASS
HDFCFOCUSED2025-12-312,653,749.492,653,749.490.000.0000PASS
HDFCFOCUSED2026-01-312,633,219.822,633,219.820.000.0000PASS
HDFCFOCUSED2026-02-282,713,619.652,713,619.650.000.0000PASS
HDFCFOCUSED2026-03-312,416,950.702,416,950.700.000.0000PASS
HDFCFOCUSED2026-04-302,618,215.062,618,215.060.000.0000PASS
HDFCFOCUSED2026-05-312,608,241.882,608,241.880.000.0000PASS
HDFCFOCUSED2026-06-302,730,327.292,730,327.290.000.0000PASS
HDFCLARGECAP2025-06-303,890,512.453,890,512.450.000.0000PASS
HDFCLARGECAP2025-09-303,825,104.063,825,104.060.000.0000PASS
HDFCLARGECAP2025-12-314,060,432.604,060,432.600.000.0000PASS
HDFCLARGECAP2026-01-313,962,090.303,962,090.300.000.0000PASS
HDFCLARGECAP2026-02-284,008,519.284,008,519.280.000.0000PASS
HDFCLARGECAP2026-03-313,545,849.813,545,849.810.000.0000PASS
HDFCLARGECAP2026-04-303,812,127.333,812,127.330.000.0000PASS
HDFCLARGECAP2026-05-313,780,830.573,780,830.570.000.0000PASS
HDFCLARGECAP2026-06-303,902,368.683,902,368.680.000.0000PASS
HDFCMIDCAP2025-06-308,406,142.768,406,142.760.000.0000PASS
HDFCMIDCAP2025-09-308,485,473.098,485,473.090.000.0000PASS
HDFCMIDCAP2025-12-319,264,154.749,264,154.740.000.0000PASS
HDFCMIDCAP2026-01-319,218,686.759,218,686.750.000.0000PASS
HDFCMIDCAP2026-02-289,425,689.549,425,689.540.000.0000PASS
HDFCMIDCAP2026-03-318,535,792.468,535,792.460.000.0000PASS
HDFCMIDCAP2026-04-309,474,471.759,474,471.750.000.0000PASS
HDFCMIDCAP2026-05-319,735,048.429,735,048.420.000.0000PASS
HDFCMIDCAP2026-06-3010,085,831.3610,085,831.360.000.0000PASS
HDFCSMALLCAP2025-06-303,578,058.783,578,058.780.000.0000PASS
HDFCSMALLCAP2025-09-303,682,766.993,682,766.990.000.0000PASS
HDFCSMALLCAP2025-12-313,775,312.983,775,312.980.000.0000PASS
HDFCSMALLCAP2026-01-313,694,054.243,694,054.240.000.0000PASS
HDFCSMALLCAP2026-02-283,742,394.383,742,394.380.000.0000PASS
HDFCSMALLCAP2026-03-313,372,428.363,372,428.360.000.0000PASS
HDFCSMALLCAP2026-04-303,816,817.863,816,817.860.000.0000PASS
HDFCSMALLCAP2026-05-313,880,947.923,880,947.920.000.0000PASS
HDFCSMALLCAP2026-06-304,041,680.454,041,680.450.000.0000PASS
ICICIFOCUSED2025-06-301,224,350.711,224,350.710.000.0000PASS
ICICIFOCUSED2025-09-301,290,918.171,290,918.170.000.0000PASS
ICICIFOCUSED2025-12-311,456,853.141,456,853.140.000.0000PASS
ICICIFOCUSED2026-01-311,493,548.681,493,548.680.000.0000PASS
ICICIFOCUSED2026-02-281,514,539.531,514,539.530.000.0000PASS
ICICIFOCUSED2026-03-311,457,082.281,457,082.280.000.0000PASS
ICICIFOCUSED2026-04-301,600,894.931,600,894.930.000.0000PASS
ICICIFOCUSED2026-05-311,614,715.811,614,715.810.000.0000PASS
ICICIFOCUSED2026-06-301,701,175.571,701,175.570.000.0000PASS
ICICILARGECAP2025-06-307,233,605.097,233,605.090.000.0000PASS
ICICILARGECAP2025-09-307,303,452.287,303,452.280.000.0000PASS
ICICILARGECAP2025-12-317,850,191.397,850,191.390.000.0000PASS
ICICILARGECAP2026-01-317,664,555.707,664,555.700.000.0000PASS
ICICILARGECAP2026-02-287,745,158.557,745,158.550.000.0000PASS
ICICILARGECAP2026-03-316,994,754.906,994,754.900.000.0000PASS
ICICILARGECAP2026-04-307,565,043.027,565,043.020.000.0000PASS
ICICILARGECAP2026-05-317,629,698.117,629,698.110.000.0000PASS
ICICILARGECAP2026-06-307,942,073.747,942,073.740.000.0000PASS
ICICIVALUE2025-06-305,409,642.265,409,642.260.000.0000PASS
ICICIVALUE2025-09-305,544,454.095,544,454.090.000.0000PASS
ICICIVALUE2025-12-316,127,176.166,127,176.160.000.0000PASS
ICICIVALUE2026-01-316,035,277.256,035,277.250.000.0000PASS
ICICIVALUE2026-02-286,057,133.676,057,133.670.000.0000PASS
ICICIVALUE2026-03-315,585,175.725,585,175.720.000.0000PASS
ICICIVALUE2026-04-305,958,829.805,958,829.800.000.0000PASS
ICICIVALUE2026-05-315,895,442.515,895,442.510.000.0000PASS
ICICIVALUE2026-06-306,019,825.176,019,825.170.000.0000PASS
KOTAKFLEXICAP2025-06-305,484,097.665,484,097.660.000.0000PASS
KOTAKFLEXICAP2025-09-305,408,312.985,418,727.5610,414.580.1926FAIL
KOTAKFLEXICAP2025-12-315,645,950.885,645,950.880.000.0000PASS
KOTAKFLEXICAP2026-01-315,647,865.185,647,865.180.000.0000PASS
KOTAKFLEXICAP2026-02-285,685,322.905,685,322.900.000.0000PASS
KOTAKFLEXICAP2026-03-315,014,619.895,058,839.7244,219.830.8818FAIL
KOTAKFLEXICAP2026-04-305,483,863.255,483,863.250.000.0000PASS
KOTAKFLEXICAP2026-05-315,480,132.925,496,484.7616,351.840.2984FAIL
KOTAKFLEXICAP2026-06-305,585,029.395,585,029.390.000.0000PASS
KOTAKMIDCAP2025-06-305,710,196.195,710,196.190.000.0000PASS
KOTAKMIDCAP2025-09-305,829,959.465,829,959.460.000.0000PASS
KOTAKMIDCAP2025-12-316,063,684.196,063,684.190.000.0000PASS
KOTAKMIDCAP2026-01-315,904,113.425,917,504.8213,391.400.2268FAIL
KOTAKMIDCAP2026-02-286,169,440.136,183,228.1013,787.970.2235FAIL
KOTAKMIDCAP2026-03-315,567,598.315,605,383.1237,784.810.6787FAIL
KOTAKMIDCAP2026-04-306,353,949.406,370,395.2616,445.860.2588FAIL
KOTAKMIDCAP2026-05-316,474,942.486,490,291.0915,348.610.2370FAIL
KOTAKMIDCAP2026-06-306,761,099.846,774,097.3112,997.470.1922FAIL
MIRAELARGECAP2025-06-304,072,459.364,072,459.350.010.0000PASS
MIRAELARGECAP2025-09-303,961,549.943,961,549.940.000.0000PASS
MIRAELARGECAP2025-12-314,180,246.604,180,246.600.000.0000PASS
MIRAELARGECAP2026-01-314,037,091.594,037,091.590.000.0000PASS
MIRAELARGECAP2026-02-284,018,440.704,018,440.700.000.0000PASS
MIRAELARGECAP2026-03-313,534,262.643,534,262.640.000.0000PASS
MIRAELARGECAP2026-04-303,823,920.603,823,920.600.000.0000PASS
MIRAELARGECAP2026-05-313,769,240.943,769,240.940.000.0000PASS
MIRAELARGECAP2026-06-303,837,927.433,837,927.430.000.0000PASS
MOTILALMIDCAP2025-06-303,305,312.573,305,312.570.000.0000PASS
MOTILALMIDCAP2025-09-303,474,889.463,474,889.460.000.0000PASS
MOTILALMIDCAP2025-12-313,688,018.023,688,018.020.000.0000PASS
MOTILALMIDCAP2026-01-313,443,218.303,443,218.300.000.0000PASS
MOTILALMIDCAP2026-02-283,368,920.263,368,920.260.000.0000PASS
MOTILALMIDCAP2026-03-313,104,665.633,104,665.630.000.0000PASS
MOTILALMIDCAP2026-04-303,573,497.513,573,497.510.000.0000PASS
MOTILALMIDCAP2026-05-313,645,820.773,645,820.770.000.0000PASS
MOTILALMIDCAP2026-06-303,747,386.663,747,386.660.000.0000PASS
NIPPONLARGECAP2025-06-304,382,859.974,382,859.970.000.0000PASS
NIPPONLARGECAP2025-09-304,646,311.184,646,311.180.000.0000PASS
NIPPONLARGECAP2025-12-315,087,568.525,087,568.520.000.0000PASS
NIPPONLARGECAP2026-01-315,010,660.785,010,660.780.000.0000PASS
NIPPONLARGECAP2026-02-285,140,379.635,140,379.630.000.0000PASS
NIPPONLARGECAP2026-03-314,652,052.564,652,052.560.000.0000PASS
NIPPONLARGECAP2026-04-305,169,028.235,169,028.230.000.0000PASS
NIPPONLARGECAP2026-05-315,166,030.425,166,030.420.000.0000PASS
NIPPONLARGECAP2026-06-305,322,704.495,322,704.490.000.0000PASS
NIPPONMIDCAP2025-06-303,906,554.983,906,554.980.000.0000PASS
NIPPONMIDCAP2025-09-303,932,897.813,932,897.810.000.0000PASS
NIPPONMIDCAP2025-12-314,212,449.654,212,449.650.000.0000PASS
NIPPONMIDCAP2026-01-314,172,736.074,172,736.070.000.0000PASS
NIPPONMIDCAP2026-02-284,398,250.754,398,250.750.000.0000PASS
NIPPONMIDCAP2026-03-313,967,613.163,967,613.160.000.0000PASS
NIPPONMIDCAP2026-04-304,582,033.194,582,033.190.000.0000PASS
NIPPONMIDCAP2026-05-314,741,541.364,741,541.360.000.0000PASS
NIPPONMIDCAP2026-06-304,916,910.304,916,910.300.000.0000PASS
NIPPONSMALLCAP2025-06-306,660,179.546,660,179.540.000.0000PASS
NIPPONSMALLCAP2025-09-306,613,610.736,613,610.730.000.0000PASS
NIPPONSMALLCAP2025-12-316,828,714.916,828,714.910.000.0000PASS
NIPPONSMALLCAP2026-01-316,581,216.246,581,216.240.000.0000PASS
NIPPONSMALLCAP2026-02-286,764,150.146,764,150.140.000.0000PASS
NIPPONSMALLCAP2026-03-316,180,884.576,180,884.570.000.0000PASS
NIPPONSMALLCAP2026-04-307,267,299.167,267,299.160.000.0000PASS
NIPPONSMALLCAP2026-05-317,460,406.747,460,406.740.000.0000PASS
NIPPONSMALLCAP2026-06-307,840,703.257,840,703.250.000.0000PASS
PPFASFLEXICAP2025-06-3011,039,231.5911,039,231.590.000.0000PASS
PPFASFLEXICAP2025-09-3011,972,332.5011,972,347.5615.060.0001FAIL
PPFASFLEXICAP2025-12-3113,330,862.0313,330,862.030.000.0000PASS
PPFASFLEXICAP2026-01-3113,396,980.5213,396,980.520.000.0000PASS
PPFASFLEXICAP2026-02-2813,425,317.1113,425,317.110.000.0000PASS
PPFASFLEXICAP2026-03-3112,896,648.3212,896,648.320.000.0000PASS
PPFASFLEXICAP2026-04-3014,094,913.0514,094,997.1584.100.0006FAIL
PPFASFLEXICAP2026-05-3114,144,673.2714,144,673.270.000.0000PASS
PPFASFLEXICAP2026-06-3014,338,843.3514,338,843.350.000.0000PASS
SBICONTRA2025-06-304,738,962.024,738,962.020.000.0000PASS
SBICONTRA2025-09-304,720,541.864,720,541.860.000.0000PASS
SBICONTRA2025-12-314,996,707.514,996,707.510.000.0000PASS
SBICONTRA2026-01-314,872,933.404,872,933.400.000.0000PASS
SBICONTRA2026-02-284,911,149.684,911,149.680.000.0000PASS
SBICONTRA2026-03-314,375,358.734,375,358.730.000.0000PASS
SBICONTRA2026-04-304,735,217.264,735,217.260.000.0000PASS
SBICONTRA2026-05-314,726,307.634,726,307.630.000.0000PASS
SBICONTRA2026-06-304,736,168.144,736,168.140.000.0000PASS
SBIFOCUSED2025-06-303,861,043.413,861,043.410.000.0000PASS
SBIFOCUSED2025-09-303,891,682.223,891,682.220.000.0000PASS
SBIFOCUSED2025-12-314,317,302.154,317,302.150.000.0000PASS
SBIFOCUSED2026-01-314,299,842.034,299,842.030.000.0000PASS
SBIFOCUSED2026-02-284,331,054.394,331,054.390.000.0000PASS
SBIFOCUSED2026-03-313,973,873.483,973,873.480.000.0000PASS
SBIFOCUSED2026-04-304,604,195.114,604,195.110.000.0000PASS
SBIFOCUSED2026-05-314,662,339.024,662,339.020.000.0000PASS
SBIFOCUSED2026-06-304,727,418.784,727,418.780.000.0000PASS
SBILARGECAP2025-06-305,395,908.065,395,908.060.000.0000PASS
SBILARGECAP2025-09-305,282,993.225,282,993.220.000.0000PASS
SBILARGECAP2025-12-315,587,913.265,587,913.260.000.0000PASS
SBILARGECAP2026-01-315,482,132.565,482,132.560.000.0000PASS
SBILARGECAP2026-02-285,524,618.865,524,618.860.000.0000PASS
SBILARGECAP2026-03-314,892,569.464,892,569.460.000.0000PASS
SBILARGECAP2026-04-305,346,833.945,346,833.940.000.0000PASS
SBILARGECAP2026-05-315,352,740.445,352,740.440.000.0000PASS
SBILARGECAP2026-06-305,506,395.595,506,395.590.000.0000PASS
SBISMALLCAP2025-06-303,569,618.893,569,618.890.000.0000PASS
SBISMALLCAP2025-09-303,558,485.493,558,485.490.000.0000PASS
SBISMALLCAP2025-12-313,626,844.913,626,844.910.000.0000PASS
SBISMALLCAP2026-01-313,444,923.113,444,923.110.000.0000PASS
SBISMALLCAP2026-02-283,493,172.683,493,172.680.000.0000PASS
SBISMALLCAP2026-03-313,228,555.793,228,555.790.000.0000PASS
SBISMALLCAP2026-04-303,714,077.693,714,077.690.000.0000PASS
SBISMALLCAP2026-05-313,739,460.723,739,460.720.000.0000PASS
SBISMALLCAP2026-06-304,015,665.714,015,665.710.000.0000PASS

216 rows, 2025-06-30 to 2026-06-30. This is the complete per-fund-month reconciliation, identical to the live Validation tab in the app.