A guide to creating a household expenses spreadsheet

Looking for a family life daily expense form setting

Let’s discuss a financial management method to help everyone avoid becoming a moonlight tribe, a daylight tribe or even a time tribe.

In order to help players who have not passed the level yet, let’s learn about the specific puzzle-solving methods. Here are some helpful tips and hints: First, look carefully at the scene to look for hidden clues and objects. Second, talk to NPCs, they may provide useful information. Also, try combining and using different items, sometimes solving puzzles requires some creativity. And don't overlook the details in your environment, they can be key. Finally, if you are really stuck, you can try searching

online

Meals: 1 yuan/day/steamed buns

Electricity fee: 1 yuan/hour/candle

Water fee: 0 yuan/day/0 drops

Shopping: 0 yuan/day/no shopping

In order to help players who have not passed the level yet, let’s learn about the specific puzzle-solving methods. Here are some helpful tips and hints: First, look carefully at the scene to look for hidden clues and objects. Second, talk to NPCs, they may provide useful information. Also, try combining and using different items, sometimes solving puzzles requires some creativity. And don't overlook the details in your environment, they can be key. Finally, if you are really stuck, you can try searching

online

1 day total: food, electricity bill, water bill, shopping-50% then*2=2 yuan

In order to help players who have not passed the level yet, let’s learn about the specific puzzle-solving methods. Here are some helpful tips and hints: First, look carefully at the scene to look for hidden clues and objects. Second, talk to NPCs, they may provide useful information. Also, try combining and using different items, sometimes solving puzzles requires some creativity. And don't overlook the details in your environment, they can be key. Finally, if you are really stuck, you can try searching

online

1 month salary 2,000 yuan/1 year salary 730,000/1 month cost 60/1 year cost 720/1 month bonus 1,000/1 year bonus 12,000

In order to help players who have not passed the level yet, let’s learn about the specific puzzle-solving methods. Here are some helpful tips and hints: First, look carefully at the scene to look for hidden clues and objects. Second, talk to NPCs, they may provide useful information. Also, try combining and using different items, sometimes solving puzzles requires some creativity. And don't overlook the details in your environment, they can be key. Finally, if you are really stuck, you can try searching

online

1 year salary 1 year bonus - 1 year expense = 18580

In order to help players who have not passed the level yet, let’s learn about the specific puzzle-solving methods. Here are some helpful tips and hints: First, look carefully at the scene to look for hidden clues and objects. Second, talk to NPCs, they may provide useful information. Also, try combining and using different items, sometimes solving puzzles requires some creativity. And don't overlook the details in your environment, they can be key. Finally, if you are really stuck, you can try searching

online

In the past, 1 year of bonus, 1 year of salary minus one year of expenses saved 1 yuan, 1 jiao, 1 cent and 1 cent. A total of 1.101 yuan was saved for you~How powerful~

How to use Excel to create a ledger

Use Excel to make accounting books. You can make them according to the purpose and function. The method is as follows:

1. Preliminary design of account book

1. First list the expenses in your daily life, which can be divided into several major categories, such as daily life, fixed expenses, etc. At the same time, first make a budget for yourself. The accounting book I use is as follows ：

2. Create a new table to list your expenses in detail. Write the date, consumption category, consumption amount and payment method.

3. The table is now completed. Let’s see how to automatically count the specific consumption in our daily life by column number, so that we can better understand our consumption details.

2. Automatic consumption statistics

1. After the account book is made, what we need to do next is to put all our daily consumption in the detailed worksheet. We let him fill in the planning table himself.

Let’s take daily necessities as an example:

=SUMIFS(Detailed!$C$2:$C$3000,Detailed!$B$2:$B$3000,B14,Detailed!$A$2:$A$3000,＂>=＂&G$1,Detailed!$A$2 :$A$3000,"

Simple description:

We want to calculate the data from the second row to the 3000th row in column C in the detailed table.

condition:

(1)The corresponding column B is daily necessities (B14),

(2) The consumption date is between 2014-1-1 (G1) and 2014-12-31 (H1);

2. For other corresponding positions, you can achieve the following effect by copying --> pasting. Of course, the "subtotal" part needs to be completed through the sum function.

3. Monthly statistics

1. The above is for the whole year. How to count the parts of each month? This is also very easy. You need to do the following steps;

2. Copy the plan form;

3. Select Create a copy and click OK;

Modify some unnecessary items. Modify the worksheet name and modify the time at the same time.

4. In this way, our accounting book is ready. Later, we need to fill in the daily consumption in the detailed worksheet of this account book.

How to record daily expenses in excel

Method/Step

1

Open the excel software and fill in the most commonly consumed items (date, income, expenditure (fill in detailed items on the bottom line), remarks)

Planning Form (Merge)

First select the box (merge the selected areas), as shown in the figure to indicate the selected area and merge icon (if this row of icons is not displayed, you can right-click in the upper blank space, check "Format", or select Menu bar----View-----Toolbar----Format is OK)

After merging, add a border, make the font bold, and display the title bar in gray (it’s up to you whether you want to add color)

Fill in the date and drop down (until January 31st)

Fill in the border of the pulled out blank form (see step three for details) and add a summary column

Insert a column in front of the remarks (see picture for details), merge, and fill in the remittance amount

Fill in the font of the amount column in red, and use the same method to mark the income in green

Write a function (fill in any number for the item on January 1), and fill in the amount cell on January 1

=B4-SUM(C4:J4) (to the effect that this cell = income - and (expenditure of the following cells))

For the function on January 2, the balance on January 1 must be added first =K4 B5-SUM(C5:J5)

Select the amount cell on January 2nd. When the mouse is placed in the lower right corner of the cell and it becomes a cross, press the left mouse button and pull down (the 2nd is the same every day, but it cannot be the same as the 1st, because 1 There is no balance before the number, but there is a balance on the 1st number before the 2nd number)

Summary of various expenses after the end of January (need to write functions in the summary column)

Because this function is the sum of numbers 1 to 31 of each item, there is a shortcut icon, just click it, but you need to expand the range

(Press Enter after selecting, press Esc to cancel or exit the step you are operating) Just use it again when needed

For summary items, you only need to prepare one, and for the following, you need to place the mouse in the lower right corner of the cell (January 31st Income Summary), turn it into a cross cursor, and pull it to the right.

That’s it. You can fill it in according to your actual consumption. The amount on the last day is what you have left. It’s very accurate. Don’t forget to fill it in!

How to make a daily expense report

It’s useless to create a table. This will solve your problem——

You divide your monthly expenses into three parts. One part is necessary expenses, such as daily meals or transportation expenses. These money can be budgeted. For example, if it is 500 yuan a month, you put the 500 yuan in a wallet. , only the budget can be moved.

There is also a part of the money that is deposited in the bank. For example, if you deposit 1,000, you will deposit 1,000 as soon as your salary is paid.

The rest is pocket money. Divide it by 31 days, which is the amount you can spend every day. For every non-budgeted expenditure, you calculate whether it exceeds the limit for the day. If you copy it, put it in Spend the next day. If you need to spend a lot of money, such as treating a friend to dinner, then save up for a few days before treating the guest.

If you do this, it will be impossible to overspend. As for keeping track of how much it costs to buy cabbage and tofu, it’s impossible to do this for long, so I suggest you don’t even try it. Even if you record it, it will be in vain if you cannot distinguish the above three parts.

Hope to help you.

The above is the detailed content of A guide to creating a household expenses spreadsheet. For more information, please follow other related articles on the PHP Chinese website!