1. First, we divide financial statements into basic categories, such as family members, expenditure categories and income categories.

2, and then according to the actual income and expenditure of each member of the family, fill in the specific income and expenditure data.

3. Then, we click the fx formula and select the sum formula. Let's calculate each item vertically first.

4. After entering the formula function parameter setting, modify the summation range area, and we choose B3: B6.

5. Then click on the lower right of the first sum formula, pull it to the right, and automatically fill in the formula on the right.

6. Then, we calculate the income and expenditure of each family member on the right, and the formula is = income-expenditure. See the figure below for details.

7. Finally, we add a border to the form, organize the form and make it beautiful.