Tips for using tax clearance forms
Tax Clearance Return FormHow to fill it out?
(1) All assets shall be recognized at their realizable value or transaction price, and income or losses from asset transfer shall be recognized;
(2) Confirm the income or loss from the liquidation of creditor's rights and debt settlement;
(3) Change the accounting principle of going concern and deal with expenses of accrued or deferred nature;
(4) Make up losses in accordance with the law and determine liquidation proceeds;
(5) Calculate and pay liquidation income tax;
(6) Determine the remaining property, dividends payable, etc. that can be distributed to shareholders.
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")) The "C2" in the formula represents the cell where the ID number is entered.
Recommended by the editor of Huajun Software Park
tax clearance returnIt is a very practical form, and most of the forms it fills out are for general purposes. If you happen to need a tax clearance form, download it quickly. In addition,Monthly statement of income and expenditure,income item budget tableIt is also a good software. Welcome to click to download and experience it!





















Useful
Useful
Useful