Chart of Accounts

Chart of AccountsIt is a chart of accounts prepared based on general classification accounts and detailed classification accounts. The free download of Excel template for chart of account details 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 chart of account details template, please pay attention to Huajun Software Park. .

Tips for using chart of accounts

How to prepare a basic 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.

General tips for chart of accounts table ​​​1. Find duplicate content formula: =IF(COUNTIF(A:A,A2)>1, "Duplicate", "").
​ ​ 2. Use the year and month of birth to calculate the age formula: =TRUNC((DAYS360(H6, "2009/8/30", FALSE))/360,0).
3. Calculation formula from the birth year and month of the entered 18-digit ID number:
=CONCATENATE(MID(E2,7,4),"/",MID(E2,11,2),"/",MID(E2,13,2)).
​​ 4. To let the system automatically extract the gender from the entered ID number, you can enter the following formula:
=IF(LEN(C2)=15, IF(MOD(MID(C2,15,1),2)+1."Male","Female), IF(MOD(MID(C2,17, 1),2 )=1,"Male","Female")) "C2" in the formula represents the cell where the ID number is entered.
Recommended by the editor of Huajun Software Park

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 chart of accounting details, download it quickly. also,Summary table of student union competition scores,Kindergarten temperature registration formIt is also a good software. Welcome to click to download and experience it!