Expense And Profit Spreadsheet – Free template in Excel for the control of expenses and income. This sheet is very similar to the previous templates with the same formats and formulas, it is a change from the previous ones in regards to data validation, since the previous ones in the field Reference / Description of expenditure / Income, we must introduce a series Of Data and in this we can put the one that we wish, but we have to take into account that at the time of entering a record if we write it of different form it would add individually according to what is written, reason why at the time of sumar would add independently If it is not Equal written, if you have commas, hyphens, dots, accents, etc. (So it should be described identically).
Example: we want to consult individually an expense or income of a specific year, since once introduced the year and the reference sum of those that are identical.
If there are 4 records of Gasoleo / Gasoleo of 50 € (3 with accent Gasoleo) and others without accent, summary 3 records of Gasoleo: 150 euros and another one of Gasoleo 50.
It is therefore convenient to write all references in the same way, so it is convenient to check the names from time to time to visualize the content. In conditional format we can highlight the values that are repeated to know if any we have put it badly.
In order to not delete the formulas all the templates are with a password (although it is blank), but if you want to modify the formulas or other data, you have to unprotect it in (In the Excel 2010 Menu select Check – Unprotect sheet)
Image of Excel sheet that you can download at the bottom.
The same Excel workbook contains another template (simple) of the monthly income and expenses which on the sumo side the total expenses as well as the income, as well as the average expenses and the monthly income as shown by the example of the Next image Select image to enlarge).
You can also download the template-4, which is the same as the template-3, the only thing that changes is the drop-down list of cell D6. Template 3 shows all references beyond the repeats and this does not.