Settlement statementHow to prepare?
1. Settlement by month
Implement the method of advance payment at the end of the tenth day or in the middle of the month, settlement at the end of the month, and liquidation after completion. For projects completed across multiple years, a project inventory will be conducted at the end of the year and annual settlement will be processed.
2. One settlement after completion
If the construction period of a construction project or a single project of all construction and installation works is within 12 months, or the project contract value is less than 1 million yuan, the project price can be advanced in the middle of each month and settled once upon completion.
3. Target settlement method
That is, in the project contract, the content of the contracted project is broken down into different control interfaces, and the owner's acceptance of the control interface is used as a prerequisite for payment of the project payment.
General tips for project settlement form forms 1: IF function conditional judgment
The IF function is one of the most commonly used judgment functions, which can complete either-or judgments.
The assessment score standard is 9 points. It is necessary to judge whether the assessment results in column B are qualified.
=IF(B4>=9,"qualified","unqualified")
2: Quick sum and average
If you want to directly know the sum or average of certain numbers, just select those numbers to find out. After selection, summation, average, and count will be displayed in the bottom status bar.
3: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
Recommended by the editor of Huajun Software Park
Project Settlement FormIt 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 project settlement form, please download it quickly. also,Employee Spring Festival Leave Registration Form,Spring Festival duty scheduleIt is also a good software. Welcome to click to download and experience it!
it works
it works
it works