Q:

# How do you create an income and expense spreadsheet?

A:

To create an income and expense spreadsheet, use a spreadsheet program to create a table detailing all incomes and expenses, and then fill in and calculate the necessary figures, explains The Nest. Copy and paste the template in other sheets for all months.

## Keep Learning

Start by dividing all bills into groups and sum up the totals, advises The Nest. For example, you may add water and electric bills for one month and include them in the same class. Add all earnings, including your spouse's income. A person who gets paid ever week should multilply the amount by four to get the total monthly earnings.

In column A, label row 2 through 4 as follows: anticipated income, actual income and difference, notes The Nest. In column B, enter the amount you expect to earn in row 2 and the exact amount you get in row 3. The exact amount should be a negative in order to compare the figure with the amount you predict to get. Key in "=SUM(B2:B3)" in the fourth row of column B and press Enter to display the difference.

In the rest of the rows in column A, enter all the group names of expenses, and key in the corresponding anticipated and difference values in column B rows, states The Nest. Enter the negative values of the actual expense in column C, and key in "=SUM(B5:C5)", altering the row number as necessary to calculate the difference between anticipated and actual expenses.

Sources:

## Related Questions

• A: Cost/income ratio shows a company's expenses in conjunction with its income, according to MoneyWeek. This is done by dividing the operating costs, which in... Full Answer >
Filed Under:
• A: Setting up a household budget involves gathering information about the family's income and expenses and then entering the information in a printed ledger, ... Full Answer >
Filed Under:
• A: Construct a personal or business budget form within a spreadsheet program by creating a blank document and designating cells for each month within a time p... Full Answer >
Filed Under:
• A: Median incomes by state are available at Census.gov as of 2015, according to the U.S. Census Bureau. Using a spreadsheet format, the website offers househo... Full Answer >
Filed Under:
PEOPLE SEARCH FOR