Shanghai Nanny Salary Calculator (Free Excel)

The Excel file is a single sheet. You select from four dropdowns:

• Neighborhood: Former French Concession, Jing'an, Pudong, Hongqiao, Minhang, Xintiandi, or 'other'.
• Experience tier: entry (1–2 years), mid (3–5 years), senior (6–10 years), or veteran (10+ years).
• Language ability: Mandarin-only, functional English, fluent bilingual.
• Role structure: live-in, live-out, part-time hourly.

The sheet returns: monthly base salary band (low / mid / high), estimated 13th-month bonus, Chinese New Year red envelope estimate, food and board valuation for live-in, annual training budget, and a 12-month all-in total in both ¥ RMB and USD.

The bands are derived from the same data feeding our salary bands article — calibrated against actual 2026 placements we and partner agencies have worked on.

Neighborhood matters because supply pressure differs across districts. FFC and Hongqiao carry premiums; Minhang and Pudong sit closer to the citywide median.

Experience tier matters because tenure compounds salary expectation. A veteran candidate doesn't just have more skill; she has options. Underpaying her by 15% versus market means she leaves at month 9 for a better offer.

Language ability is the single biggest non-experience modifier. Fluent bilingual carries a 30–50% premium on top of the experience band. Functional English is a 10–15% modifier. Mandarin-only is the base.

Role structure changes the calculation entirely. Live-in includes food and board valuation (~¥ 1,500–2,500/month typical); live-out does not. Part-time hourly bypasses the monthly framework entirely.

The calculator returns four numbers per scenario:

• Monthly base salary band (low / mid / high) — what the cash salary lands at.
• 13th-month bonus — typically equal to one month's salary, paid in early January.
• Chinese New Year red envelope — separate from 13th-month, typically ¥ 1,000–2,500, customary.
• Annual all-in — the cash salary plus bonuses plus food/board valuation plus training and gift budget. This is the number to compare against your relocation-package allowance.

The USD conversion uses a fixed 7.20 ¥/USD rate baked into the sheet (you can override). Updating to current rate is a one-cell change.

The bands are calibrated against actual 2026 placements across our partner-agency network — approximately 200 placement-quotes per quarter across the major districts. We also cross-check against the published bands from 2–3 larger Shanghai agencies and adjust quarterly.

The bands are tight enough to be useful but wide enough to honestly reflect that any given placement may land outside the median. Bilingual-fluent veteran candidates in FFC may exceed the upper band; entry-tier candidates in Minhang may settle below the lower band. The calculator gives you the realistic center of mass — not the absolute extremes.

Form below. Name + email. The Excel file (shanghai-nanny-salary-calculator-2026.xlsx) arrives via email within 2 minutes. File size ~280 KB, opens in Excel, Numbers, or Google Sheets (with minor formula adjustments for Sheets).

GDPR + PIPL: data goes to mike@agileopsai.com only. Two emails total — the calculator, then one follow-up seven days later. Unsubscribe with one click.