How Do You Create Income Templates in Excel?


Quick Answer

Use the built-in formula calculations in Excel to help calculate totals. Creating a column of totals allows users to see real-time totals as information is added and updated.

Continue Reading
Related Videos

Full Answer

Income templates make it easy to track income and expenses. By either modifying a template downloaded from the Internet or making one from scratch, users can have Excel calculate totals quickly and effortlessly.

Step 1: Gather financial information

Have as much financial information handy as possible. Bank records work well, either as electronic data or printed statements.

Step 2: Create row and column labels

In the first column, label each row with the name of a month, starting with either January or the current month, depending on the information the spreadsheet is tracking. Along the first row, label the different incomes to track. These can be client payments, totals from different jobs worked or income from different household members.

Step 3: Create formulas for monthly income totals

Use the "formulas" button in Excel to create a total at the end of each month's row. This total is all of the income from all sources inputted for that month.

Step 4: Total the yearly income

In the last cell underneath the monthly totals, use the "formulas" button again to create a total for the year, using the monthly totals. As the monthly incomes update, the yearly total also updates.

Step 5: Save the spreadsheet

At the top of the spreadsheet, click "File," and then click "Save as." Enter a title for the spreadsheet and select a location in which to store the file.

Step 6: Update the file regularly

Input data regularly to keep the file updated.

Learn more about Software

Related Questions