We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Create Cost & Expense Sheets in Excel

Updated March 24, 2017

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.

Loading ...
  1. Open a blank Microsoft Excel spreadsheet.

  2. 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.

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

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

  5. 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.

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

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

  8. 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.

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

Loading ...

About the Author

Mike Johnson has been working as a writer since 2005, specializing in fitness, health, sports, recreational activities and relationship advice. He has also had short stories published in literary journals such as "First Class Magazine." Johnson holds a Bachelor of Science in education and history from Youngstown State University.

Loading ...