Tips for using asset income statement
How to prepare an asset income statement?
1. Prepare accounting vouchers based on original vouchers, register the general ledger and subsidiary accounts, and conduct account verification, account fact verification and accounting verification.
2. Under the premise of ensuring that all accounting business is accounted for, prepare a trial balance sheet, check the correctness of accounting accounts, and prepare for the preparation of accounting statements.
3. Calculate and fill in each item of the income statement based on the balance of the profit and loss account in the trial balance sheet and the balance of the relevant detailed accounts.
4. Calculate operating profit. It is based on operating income, minus operating costs, business taxes and surcharges, sales expenses, administrative expenses, financial expenses, and asset impairment losses, plus gains from changes in fair value (minus fair value gains and losses) and investment income (minus investment losses) to calculate operating profit.
5. Calculate the total profit. It is based on operating profit, plus non-operating income, subtracting non-operating expenses, to calculate the total profit.
6. Calculate net profit (or net loss). Net profit is calculated based on total profit, minus income tax expenses.
4. Check the completeness and correctness of the income statement, including whether the header part is complete, whether each item is correctly filled in, and whether the calculation of various profits is correct.
5. Relevant personnel sign and seal.
2. You can see many ready-made formats in [Table Style]. You can directly click on any style you like.
3. Then select the area range, which is the data source. Select the default to only apply the table style.
4. You can also set conditional formatting for specific data in the table. For example, if you want to mark data with an amount greater than 2,000 yuan, you can select [Data]--[Conditional Formatting]--select greater than 2000 as the condition and mark it in red. Result. Select OK to see the effect.
5. If the amount of highlighted data is relatively large, you can use the [data bar] of conditional formatting to display it. In this way, you can see who has more and who has less by looking at the color in the cell.
6. Which cell is selected with the mouse, the color of the cell will become different from other cells. You can select it at the bottom of the table, and the color can also be adjusted according to your own preferences. There is a sun mark to protect your eyes. The mode can also be changed at any time.
7. When a lot of content is entered in the cell, the text on the edit bar will display multiple lines, which will block the cell content below the edit bar. You can see a small triangle in the middle below the edit bar. It is the "edit box collapse" function. It allows the content of the edit bar to be folded to facilitate cell reading and editing.Recommended by the editor of Huajun Software Park
Asset Profit and Loss StatementIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need to download the asset income statement, please download it quickly. also,Program host registration form,Holiday travel situation survey formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works