The spreadsheet will combine all of this information and give you a total of your expenses. The expenses section is split into two main parts: operating expenses and non-recurring expenses. Your total income will be calculated by adding both your sales revenue and non-operation income, minus your cost of sales. If you receive any non-operation income, for example rental or interest, fill this out below, as this will be used to calculate your total income. Your gross profit will be calculated automatically once you enter your sales revenue and cost of sales data. Names of your individual products and services can be entered in column B (in place of the Product/Service 1) text, simply by clicking in the cell and typing over it. The income section allows you to keep track of any money you are bringing in through sales of your products and services. The spreadsheet will automatically calculate percentages and totals based on this information. The only information you need to fill in is the white cells, where data from each quarter should go. There is space on the spreadsheet to enter everything you need in order to create a profit and loss statement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |