How to prepare a chart of accounts?
1. Assets: refers to all valuable resources owned by an enterprise, which can be divided into three categories: current assets, fixed assets, and other assets. Current assets refer to cash and assets that a business hopes to turn into cash.
2. Liabilities: refers to the debts of an enterprise, which can be divided into current liabilities, long-term liabilities and other liabilities.
3. Capital: Also known as shareholders’ equity, it is the part of the enterprise that belongs to shareholders, so it is equal to the difference between assets and liabilities.
4. Income: refers to the income generated by an enterprise from selling products or providing services. It can be divided into two categories: operating income and non-operating income. Operating income is the income within the scheduled business scope of the enterprise, while non-operating income refers to the scheduled business scope. Non-financial income, such as interest income from non-financial industries.
5. Expenses: refer to expenses incurred due to income, which are divided into four subcategories: direct costs, sales expenses, administrative expenses, and non-operating expenses.
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
Press the key combination to complete.
2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)
Recommended by the editor of Download Home
New chart of accountsIt is a very practical form, and most of the forms you fill in are for general purposes. If you happen to need a new chart of accounts, download it quickly. also,Inbound and outbound data statistics table,Employee resignation approval formIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works