Financial account details

​​​Classification of financial account details:

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.
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, which can be divided into two categories: operating income and non-operating income.
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.

​ ​ 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.

The Financial Account Detailed Table 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 Financial Account Detailed Table, please download it quickly.Sports results registration form,Party Member Pioneer Index Evaluation Statistics TableIt is also a good software. Welcome to click to download and experience it!