22_家庭记账本智能模板_上班族家庭_工资条结构账本.xlsxVIP

每月一张工资条，拆开看

把工资条拆成14列：应发三块、扣除五块，实发与到手率自动算。看得懂工资条，才谈得上规划。

月份 基本工资 绩效奖金 补贴 应发合计 养老8% 医疗2% 失业0.5% 公积金12% 三险一金 专项附加 个税 实发工资 到手率

1 ¥18,000.00 ¥6,000.00 ¥800.00 ¥24,800.00 ¥1,440.00 ¥363.00 ¥90.00 ¥2,160.00 ¥4,053.00 ¥3,000.00 ¥1,139.40 ¥19,607.60 79.1%

2 ¥18,000.00 ¥2,000.00 ¥800.00 ¥20,800.00 ¥1,440.00 ¥363.00 ¥90.00 ¥2,160.00 ¥4,053.00 ¥3,000.00 ¥664.70 ¥16,082.30 77.3%

3 ¥18,000.00 ¥2,500.00 ¥800.00 ¥21,300.00 ¥1,440.00 ¥363.00 ¥90.00 ¥2,160.00 ¥4,053.00 ¥3,000.00 ¥714.70 ¥16,532.30 77.6%

4 ¥18,000.00 ¥8,000.00 ¥800.00 ¥26,800.00 ¥1,440.00 ¥363.00 ¥9