How to Create Cost & Expense Sheets in Excel
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.
- Creatas Images/Creatas/Getty Images