When entering the budget, the revenue calculation logic must first be determined:
The "Client's contract, initial" cost is entered as a single number (the cost of the Client's contract manually entered in the red circle, the cost of the construction budget/direct costs in the blue circle):
The cost of the customer's contract is derived from the budget, both the cost of the construction budget/direct cost and the customer's cost are described behind each cost line. For this kind of calculation, you have to check the box "Calculate the cost of the contract from the budget". In the red circle, the cost of the customer's contract, in the blue circle, the cost of the construction budget/direct costs.
If the Agreement has no income, check the box "This project has no income". Import direct cost budget (construction budget/direct cost cost in the blue box).
Description of the import process:
The Bauwise import table shows the columns needed to import data into the Bauwise environment. In the example below, the required columns are in the order of listing: cost location, name, unit, quantity, unit price, budget, customer contract (initial):
If, for example, there is no "Unit price" in the budget file or there is no need to import the cost of "Customer's contract (initial)", these columns can be hidden in Bauwise by opening the selection of columns from the button marked with a red circle in the screenshot below and removing the check mark from the column name.
Example of budget numbering:
Copy of Copy of Lepingute soovituslik numeratsioon - Excel fail.
If there are more than ten sub-lines, two additional numbers must be used, i.e. the sub-line of chapter 152 is 15211. Reason: otherwise, the list will reach number 1531, which belongs to the next chapter 153.
To import the budget, make the budget active and copy it (Previously I have hidden rows/columns not needed for import):
Then paste it in the "Cost location" box:
If we enter the budget of a specific project, the rows are automatically sorted and grouped according to the previously specified structure. However, if there is no overall structure, then there are no intermediate summing lines and all budget lines go under one division, i.e. there is no disaggregation (so-called main lines and sub-lines).
After the import, I check that the direct cost budget and the Customer's contract correspond to what was budgeted (the control numbers are circled). If the numbers match, the budget has been successfully imported.
The budget structure can also be entered manually.
Later, more lines can be added to the budget structure. The new job (cost location) is automatically added to the correct division in the structure, taking into account the job code.
Ridu saab kustutada klikkides rea peale ja hiire paremklikiga valides avanevast menüüst käsu „Delete Row(s)”.
Impordi vaates on paremas ülanurgas punane nupp “Kustuta kogu eelarve”, millega saab eelarve kustutada juhul, kui imporditud ridu ei kleebitud õigesti. Kuid arvestama peab, et see nupp kustutab eelarve jäädavalt ja kogu eelarve peab alati uuesti importima.
Nupult “Tagasi” saab pärast importimist liikuda eelarve vaate juurde.
Impordi vaatesse saab liikuda nupult “Redigeeri eelarvet“:
Add Comment