How do I create a personal budget table?

You can create a personal budget table using a software table that has been supplied with your personal computer or purchasing an office software package and using the software that is included with it. Before you can create a personal budget table, you will have to determine both monthly income and monthly expenses. Some people do this by recording every purchase they make per month, including payments or debts accounts. Others collect each income and divide them into categories, then at the end of the month to load the amounts.

Open the software program. You may be able to find a template for a personal budget table online or you can create your own. Prepare one table for each month. If you create your own personal budget table, prepare one column for your reception per month. Enter "Receipt" at the top of the column. Enter = Sum (A2: A15) in the 16th row, where "A" is a letter of column and "2" and "15" rows numbers. When entering a delay in the income column, they will be automaticallyadded to the order = sum.

Create categories for expenditure on a personal budget table. Common categories include housing costs, public services, car payments and other transport, food and personal belongings. Take a look at your income and find out what you normally spend money on and create a category. Determine the amount for each category based on the recorded expenditure. Ideally, your expenses will be quite less than your net income. If they do not do so, you will have to think of ways to limit certain categories.

Indicate each category of expenditure your own column. Enter the category name in the upper row of the column and the target amount of a few rows into the column. In the line above the aim type = sum (B2: B20), replacing B with the actual letter of the column and numbers with actual rows numbers. Furthermore, in the line below the target costs type = sum (B21: B22), where line 21 is a line with the total cost of this KateGorii and Line 22 is the target amount. The sum will help you see at first glance how much you stayed in each category or whether you switched in any category.

If you want, you can also program your personal budget table so that all your expenses for a month and targeted expenses do and then compare them with income. In the column to the right of the other columns, in the same row as expenditure, type = sum (B21: Z21), where "B" and "Z" are the first and last columns and "21" is a series. Then in a series with the amount of target expenditure type = sum (B22: Z22), which will be a total of all targeted expenses. Type = sum (B23: Z23) in a row just below it to find out the difference between your actual and targeted expenses.

IN OTHER LANGUAGES

Was this article helpful? Thanks for the feedback Thanks for the feedback

How can we help? How can we help?