There is growing evidence that higher body mass index (BMI) is associated with lower survival in breast cancer patients. The aim of this study was to investigate whether there is an association between body mass index (BMI) at breast cancer diagnosis and breast cancer prognosis and whether this association is dependent on menopausal status and tumor subtype in a less developed population in northern China. We collected 1,225 patients with primary invasive cancer in stage I-IIIC for retrospective analysis from October 2010 to December 2020. We used Kaplan–Meier and Cox regression analyses and estimated the relationship between baseline BMI and breast cancer-specific survival (BCSS). Next, we further evaluated whether the effect of BMI on breast cancer prognosis differed by menopausal status and tumor subtype. We found that death rate and prognosis were worse for patients with BMI ≥ 24, more than four positive lymph nodes, and triple negative status. Interestingly, BMI played a different prognostic role depending on tumor subtype and menopausal status. For premenopausal women, patients with BMI ≥ 24 had significantly lower BCSS compared to those with BMI < 24 in human epidermal growth factor receptor 2 (HER2) overexpression (HR: 4.305, p = 0.004) and triple negative subtypes (HR: 1.775, p = 0.048). By contrast, there was no association between BMI ≥ 24 and higher death regardless of tumor subtype in post-menopausal patients (p > 0.05). BMI influences breast cancer outcome depending on tumor subtype and menopause. BMI ≥ 24 might be a risk factor for BCSS, particularly in premenopausal women with HER2 overexpression or triple negative subtype. In contrast, BMI ≥ 24 was not associated with higher death regardless of tumor subtype in post-menopausal patients.