Property Tax Return It is a property tax levied on the property owner according to the taxable residual value or rental income of the house. Property tax declare Table Excel template is provided by Huajun Software Park for free download. The source file is in xlsx format. You can download the source file yourself edit Modify the content style. For more information about the free download of the property tax declaration form, please pay attention to Huajun Software Park.
How to use the property tax declaration form
Property Tax Return How to fill in?
1. The property tax belongs to the individual property tax in the property tax, and its tax object is only the house;
2. The scope of expropriation is limited to business houses in cities and towns;
3. The taxation method shall be stipulated according to the operation and use mode of the house. The tax shall be levied according to the residual value of the house property for self use, and the tax shall be levied according to the rental income for the leased house.
General Skills of Real Estate Tax Return 1. Formula for finding duplicate content:=IF (COUNTIF (A: A, A2)>1, "Duplicate", ""). 2. The age formula is calculated by the date of birth:=TRUNC ((DAYS360 (H6, "2009/8/30", FALSE))/360,0). 3. Calculation formula from the date of birth of the 18 digit ID card number entered: =CONCATENATE(MID(E2,7,4),"/”,MID(E2,11,2),”/”,MID(E2,13,2))。 4. The system automatically extracts gender from the input ID card number. You can enter the following formula: ="C2" in IF (LEN (C2)=15, IF (MOD (MID (C2,15,1), 2)+1. "Male", "Female", IF (MOD (MID (C2,17, 1), 2)=1, "Male", "Female") formula represents input ID Number of cells.
Recommended by the editor of Huajun Software Park
Property Tax Return It is a very practical form, and most of the forms filled in are general-purpose. If you just need a real estate tax return, please download it. In addition, Payroll Template , Financial statement template It is also a good software. Welcome to click to download it!