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).
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. also,government procurement budget table,government budget revenue chart of accountsIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works