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.
Rows can be deleted by clicking on the row and selecting "Delete Row(s)" from the menu that opens with the right mouse button.
In the import view, in the upper right corner, there is a red button "Delete all budget", which can be used to delete the budget if the imported lines were not pasted correctly. However, it should be noted that this button deletes the budget permanently, and the entire budget must always be re-imported.
After importing, you can use the "Back" button to go to the budget view.
You can go to the import view from the "Edit budget" button:
Add Comment