Personal income tax withholding return formHow to fill it out?
The following items of personal income shall be subject to personal income tax:
(1) Income from wages and salaries;
(2) Income from labor remuneration;
(3) Income from royalties;
(4) Income from royalties;
(5) Business income;
(6) Interest, dividends, and bonus income;
(7) Income from property leasing;
(8) Income from property transfer;
(9) Incidental income.
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
Personal Income Tax Withholding ReturnIt 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 personal income tax withholding return form, please download it quickly. also,Tourism service online questionnaire,Tourism industry indicator accounting tableIt is also a good form template. You are welcome to click to download and experience it.
it works
it works
it works