Income statement latest format template

Income statement latest format templateIt is a financial statement that reflects the operating results of an enterprise during a certain accounting period. The free download of the latest format template of the income statement Excel template is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the latest format template of the income statement, please pay attention to Huajun Software Park.

Tips for using the latest format template of the income statement

The latest format template of income statementHow to fill it out?
Step 1: Reflect net sales, that is, the balance after total sales minus sales returns and discounts, as well as sales tax.
Step 2: Reflect the gross sales profit, which is the balance after net sales minus sales costs.
Step 3: Reflect sales profit, that is, the balance after gross sales profit minus sales expenses, management expenses, financial expenses and other period expenses.
Step 4: Reflect operating profit, that is, the balance after sales profit plus other business profits.
Step 5: Reflect the total profit, that is, the balance after operating profit plus (minus) net investment income, non-operating income and expenses, the cumulative impact of changes in accounting methods on previous profits and losses, and other items.
Step 6: Reflect the profit after income tax, that is, the balance after total profit minus accrued income tax (expense).

General tips for the latest format template of the income statement 1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
​ ​ 2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3. Change number format
Excel’s shortcut keys are not chaotic, but follow a certain logic.
For example, if you want to quickly change the format of a number, you can immediately add a dollar sign to the number, because the $ symbol and the number 4 share the same key.
In the same way, "Ctrl+shift+5" can quickly change the number into the form of percentage (%).
Recommended by the editor of Huajun Software Park

Income statement latest format templateIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need the latest format template of the income statement, come and download it. In addition,government procurement budget table,government budget revenue chart of accountsIt is also a good software. Welcome to click to download and experience it!