How to Create Cost & Expense Sheets in Excel

Written by mike johnson | 13/05/2017
How to Create Cost & Expense Sheets in Excel
Excel can be easy to use for cost and expense sheets. (Creatas Images/Creatas/Getty Images)

Cost and expense sheets are something that all business owners and self-employed individuals need to have in place and update regularly. These sheets also can be used by an average person planning a vacation, home renovation or similar event or project. The Microsoft Excel program can be very helpful in assisting you with keeping track of and adding up all costs and expenses that you incur, no matter what the purpose.

Open a blank Microsoft Excel spreadsheet.

Write down the necessary categories for your spreadsheet. Common categories for costs and expenses of businesses, for example, include office supplies, software and equipment, legal and accounting, postage, advertising, travel and organisation fees. Choose categories that are specific to your purposes for the cost and expense sheet.

Type the date in the first column on the Excel spreadsheet.

Type a column for the "Payee" of the costs and expenses next to the "Date" column.

Add all additional categories in the following columns. For example, Column C in the spreadsheet might be "Office Supplies," Column D "Software and Equipment" and so on.

Scroll down a few rows and add "Total" to the bottom of the "Payee" column.

Highlight all rows from just under each category heading to the "Total" row for each category.

Click "Formulas" from the top menu. Then, click "AutoSum." This will add up the total cost and expense for each category and continue to add up the total as you add more costs and expenses in that category.

Touch "Control" and "S" on your keyboard and save the Excel spreadsheet on your computer.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.