Sample Spreadsheet For Business Expenses – Excel allows you, as well as other spreadsheets such as Google Drive spreadsheet, to make in detail a template to take control of expenses of your company or particular business.
In this article read the comments, following the simple steps, create a useful template to have all day in the information in reference to the expenses of your business or professional activity and thus be more effective in making decisions.
If you do not carry your own accounting, you can ask a manager or a board that indicates the data and click on the same in the template to be updated at all times.
Company Excel sheet expenses – Print screen of Microsoft Excel Cuesta Y.
Print screen Microsoft Excel Cuesta Y.
1. Open a book and enter data
Open an Excel workbook and place yourself on one of the pages.
Write in box A1 the year that is in the control of expenses, suppose Year 2014, cell B1 January, C1 February and so on until December, the next cell being the Totales.
2. Continue entering data
In boxes A2, A3, and successive places the different types of expenses of the company such as: Purchases merchandise, Personnel expenses, Loan interest, Light, Telephone, Other expenses, Amortization, etc. The last cell will be called Total Month.
In the cells from January to December and in each type of expenditure, enter the amounts to which they ascend each one until completing the table completely.
3. Get your template
Located in the column of January, in the blank cell that follows the last box with data, press twice on the summation icon that is located above in the options of the tape, will appear the sum of the total expenses of January, repeat the operation for the remaining months.
Analogously in the row of each of the expenses.
You can enhance the appearance of the graph by formatting the boxes, for example by placing bold or color to the titles of the rows and columns, to the totals, of your choice.
4. To complete
If you found this template interesting, you can also be practical:
Create a dashboard or dashboard with Excel.
Uses Excel in the company.
Uses of Excel in the company
Excel applications, or in general spreadsheets, in the company are many and not always used. To counter this situation I explain below a series of actions that Excel allows you to perform and the application of such actions in the company. I recommend you to be updated in the contents of the site and to subscribe to the Free newsletter and the ecourses.