Make an income and expense worksheet in Excel by creating formulas that deduct spent money from the earned income. Sites such as Kiplinger and Budget Worksheets also feature interactive online income and expense worksheets, while Track Every Coin offers smartphone and Web apps for tracking expenses and creating charts.Continue Reading
To create an income and expense worksheet in Excel, open a blank project, and create column headings for each money in the year, starting at cell B1. Starting at cell B2, Enter the word "Income" beneath each month's name. At cell A2 and moving downward, enter the different expenses incurred during a month, such as utility bills, rent or grocery bills. Beneath the final entry for expenses, enter the term "Final Balance," and create a formula that subtracts the sum of the expenses in that month from the month's income. The value should be displayed in the total row for each month.
To use an online form, such as the one at Kiplinger, begin by creating entries for each form of income the household received during each month. The site allows users to enter names on the entries to differentiate between parties or income sources. Next, move on to the expenses section, adding in the appropriate values for each type of expense.Learn more about Household Budgets