Current location - Health Preservation Learning Network - Health preserving recipes - How to make financial statements
How to make financial statements
1. First, open an Excel blank worksheet and add some borders.

2. Secondly, fill in the corresponding contents according to the individual family classification. Generally speaking, it can be divided according to food, clothing, housing and transportation, or it can be divided more finely, but generally speaking, there are only a few categories.

3. Then, make a monthly financial statement, the classification is consistent with the general statement, pay attention to insert the summation formula, and record the daily progress.

4. Then link the monthly data in the summary table and use the formula method to realize automatic change, which is simple and convenient.

5. Link the monthly total consumption data in the summary table, and also use the formula method.

6. It is simple and convenient to insert the balance item into the formula and use "income-expenditure".