6+ Income Sheet Templates in Google Docs | Google Sheets | Word | Number | Excel | Pages
One of the company’s financial statements is an income sheet, also known as an income statement or profit and loss account. It demonstrates the profits and expenditures of the company over a period of time. It shows how revenue is converted into net income or net profit. Income sheet templates are the tool to use to make income sheets.
Table of Content
- 8 Steps to Draft an Income Sheet
- 6+ Income Sheet Templates
- 1. Income and Expense Worksheet Template
- 2. Rental Income & Expense Worksheet Template
- 3. Small Business Income and Expenses Spreadsheet
- 4. Business Income & Expenses Worksheet Template
- 5. Free Income Blank Spreadsheet Template
- 6. Free Income Expense Sheet Template
8 Steps to Draft an Income Sheet
Step 1: Select the Time Period and Write the Header
The time period of the income sheet is the first thing that needs to be selected. Revenue statements evaluate earnings and expenditures over a given span of time and are produced typically on a monthly, weekly, or annual basis. Choose the span you want to use to calculate your declaration of income. Publicly traded companies must produce weekly and annually earnings reports to register with the Securities and Exchange Commission. Once this is done, write the header which includes the full name of the company and the title ‘Income Sheet’.
Step 2: Prepare the Sales Revenue
Sales revenue involves all earnings from the purchase of products and facilities, irrespective of whether the money was received or not. You need to list income from revenues for the period you have chosen. Say, for instance, you sold 10,000 inventory units for $5 apiece. You’d report USD 50,000 in sales revenue, even if you have not been paid by all of your yet.
Step 3: Calculate the Gross Profit
The gross profit you made during the time frame you chose is the total amount of money you made before your expenses. To calculate this, the first you need to do is calculate the cost of goods sold which is the immediate labor, immediate equipment, and overhead manufacturing expenses you incurred to generate the stock you sold. Write down on your spreadsheet the distinction between your sales revenue and the price of the products purchased in the next row to determine the gross profit.
Step 4: Mention the Operating Expenses
Operating expenses are costs that connect straight to the administration of the company. List the number of expenses incurred during the period next to each line item. Common working costs include wages and salaries for those staff who are not immediately engaged in the production of items, lease, insurance, office equipment, skilled charges, services, travel expenditures, advertising, depreciation, and estate tax.
Step 5: Find the Depreciation and Amortization
Both methods of depreciation and amortization serve to reduce the recorded asset costs. Depreciation is most frequently calculated using a direct row technique that gradually lowers a tangible asset’s expense over its helpful lives. For intangible assets, amortization is used and is calculated likewise to depreciation.
Step 6: Write the Non-Operational Gains
The earnings that are not related to any sort of business operation, sales or production are known as non-operational gains. These revenues stem from different activities such as unrelated sales or investments that are generally different or peripheral to normal operations. So in this section, you need to write down the revenues incurred for each item respectively beside the item itself.
Step 7: Determine Total Expenses
To find out the total expenses of the income sheet, you need to find out the non-operational losses too. Find out what losses you have incurred during your chosen time period and sum them all up together. After that, you need to determine the total operating expenses. Once you have these two in place, you need to add them up together to calculate the total expenses.
Step 8: Calculate Net Income
The final section to be included in the income sheet is the net income. Take the gross profit that you have already calculated and added that to the non-operational gains. This will give the total amount of profit that you have incurred during the period you chose. Now, you just need to subtract the total expenses from this profit margin to get your net income.
6+ Income Sheet Templates
1. Income and Expense Worksheet Template
An income sheet is a very important document that should be provided to all the employees of a company so that they know about the company’s profits and losses. If you wish to make a proper working income sheet, then you need to download this sheet template in Word. This template is available to be used in other formats too such as Google Docs, Pages, Sheets, Excel, and Numbers format.
2. Rental Income & Expense Worksheet Template
If you are providing your asset or property on rent, then it is crucial that you have a rental income and expense worksheet. Make such a sheet with the help of our sheet template in Google Docs and ensure that you know where your money is going, how and to whom. The template can be downloaded in sizes A4 and US letter sizes.
3. Small Business Income and Expenses Spreadsheet
It is tougher for a small business to make a daily income sheet as larger corporations already have theirs made from before. That is why we are offering you this sheet template that has been specifically designed to help make income sheets for small businesses. Just download this customizable template available in multiple file formats and you’re good to go.
4. Business Income & Expenses Worksheet Template
This income sheet template in Pages format provides you with a ready-made business income and expenses worksheet that can be easily used to make one for your needs. The template provides original headings and content including separate sections for listing the income and the expenses in the worksheet. So what are you waiting for? Download the template now!
5. Free Income Blank Spreadsheet Template
Are you looking for a tool to help you make your income sheet more easily? Well, you need not look any further than this sheet template in Numbers! This template offers you a free and editable blank spreadsheet that just requires the proper information to be filled in. The template can also make a payroll sheet. The template is also fully printable and can be downloaded on any OS.
6. Free Income Expense Sheet Template
One of the most important financial documents of any company is the price sheet. This sheet tells the readers all about the company’s profits as well as losses over a definite time. Need to make such a document? Then make use of this Free Income Expense Sheet Template. With this template, you will be able to make the income sheet of your company easily and efficiently. You can also edit the file to make an evaluation sheet.