Startup Costs

Customize a monthly budget template in Excel Step 2: Enter your budget data of income and expenses into the table, and calculate the total incomes of every month and every item: (1) Calculate total income per month: In Cell B7 enter =SUM(B4:B6), then drag the Fill Handle to apply this formula to Range C7:M7.

Click the cell that you want to use to calculate your total in the income column, select the list arrow, and then choose the Sum calculation. There are now totals for the income and the expenses. When you have a new income or expense to add, click and drag the blue resize handle in the bottom-right corner of the table.

Open Microsoft Excel 2010 and start a new workbook by choosing "File" and "New." In the "Available Templates" section, choose "Blank Workbook" to begin. Decide how many worksheets you want to use for your accounts. Create headings for each data item you plan to record in your worksheets.

Click the cell that you want to use to calculate your total in the income column, select the list arrow, and then choose the Sum calculation. There are now totals for the income and the expenses.

Open Excel. Add headings for the columns in the top row your income worksheet. Format your columns. Select your expense worksheet and set it up for recording expense data. Format your expenses columns.

Open your income and expenses Excel worksheet. Select an empty cell beneath the last item in your "income" column. Type "Total Income" in this cell, then press the "Enter" key. Select the cell directly beneath the "Total Income" label. Type "=SUM(" into this empty cell.

Open Excel. Add headings for the columns in the top row your income worksheet. Format your columns. Select your expense worksheet and set it up for recording expense data. Format your expenses columns.

1Open a blank Microsoft Excel spreadsheet.2Write down the necessary categories for your spreadsheet.3Type the date in the first column on the Excel spreadsheet.4Type a column for the "Payee" of the costs and expenses next to the "Date" column.5Add all additional categories in the following columns.How to Create Cost & Expense Sheets in Excel Techwalla\nwww.techwalla.com > articles > how-to-create-cost-expense-sheets-in-excel

For each expense, enter the date and description. Use the dropdown menus to select payment type and category for each expense. For each expense, enter the total cost. Attach all necessary receipts to the document. Submit for review and approval!