◐ Openly Construction Cost Tool v1.0
Funding Status · Same as the Funding tab
BKP Summary (Main Groups)
| BKP | Name | Original KV | KV News | % | IS | Δ Original | Consumption |
|---|
Project Details
Currency: CHF · All amounts include VAT (8.1%). The "Last Updated" date is automatically updated whenever a change is made.
Building Statistics
Exterior walls (windows included)
| Name | sq. ft. | linear meter | cubic meters | Note |
|---|
Ceilings / Floors
| Name | sq. ft. | cubic meters | Note |
|---|
Roof
| Name | sq. ft. | Note |
|---|
Walls
| Name | sq. ft. | linear meter | Height (m) | Note |
|---|
Windows & Doors
| Name | pcs. | sq. ft. | linear meter | Note |
|---|
Hierarchical list organized by BKP with subtotals. Clicking ▸ expands the actual entries for each leaf position (date, text, amount from the bank statement). The only editable column is "Current Bank Statement." Any change updates the entire tool.
| BKP | Name | Original KV | KV News | IS | Δ (Budget vs. Actual) | % |
|---|
Overview of all account transactions
The sum of all credits (deposits) and debits (outgoing payments) for each account. "Balance" = Deposits − Outgoing payments.
| Account | Deposits | Outputs | Balance | Number of bookings |
|---|
Raiffeisen Construction Account (CH31 8080 8007 1838 2944 0)
The "Assigned to BKP " column shows the cost item to which the entry is assigned (number + description). The "Category" field is used for grouping notes (e.g., "Deposit," "Interest," "Loan Refinancing") and excludes the entry from the project total.
Ignore: Check this box to completely remove an entry from all reports (Balance Overview, Actual Costs, Cost Control, Reconciliation). Ignored rows appear grayed out/strikethrough.
Ignore: Check this box to completely remove an entry from all reports (Balance Overview, Actual Costs, Cost Control, Reconciliation). Ignored rows appear grayed out/strikethrough.
| Ignore | Date | Payee | Amount | Assigned to BKP | Category/Note |
|---|
VP Bank Checking Account (LI26 0880 5504 2887 3000 1)
Ignore: Check this box to completely remove an entry from all reports (Balance Overview, Actual Costs, Cost Control, Reconciliation). Ignored rows appear grayed out or struck through.
| Ignore | Date | Payee | Amount | Assigned to BKP | Category/Note |
|---|
Manual cost entry
Record expenses that do not appear on a bank statement (e.g., outstanding invoices or cash payments). Each entry is treated as a bank transaction and is automatically included in all actual reports, cost control, and reconciliation.
Recorded manual costs
| Date | Description | Amount | Assigned to BKP | Category/Note |
|---|
Import Raiffeisen bank statement
Upload a new Raiffeisen bank statement (PDF or text file). Transactions are automatically recognized and imported. The account balance as of the specified date is transferred directly to the financing section (Raiffeisen Bank Account Balance). Existing transactions are deduplicated based on date and amount.
Or: Paste text from a bank statement
Reconciliation · Unposted Bank Entries
Rule: Actual costs are imported into the tool exclusively via bank account transactions (VP Bank, Raiffeisen) and manually entered transactions. Each time the tool is loaded, it attempts to automatically assign transactions to a cost center (see activity log below). Everything listed here could not be assigned automatically and is waiting for you to assign it.
| Account | Date | Text | Load | Credit | Assign BKP | Promotion |
|---|
Activity Log · Automatically Assigned Entries
The tool has automatically assigned these entries to a BKP item based on vendor names and contract items. Each assignment can be edited manually —adjust the BKP if the automatic assignment is incorrect. Colors indicate the rule’s confidence level.
| Account | Date | Text | Load | Credit | BKP (editable) | Rule / Rationale | Promotion |
|---|
Cash Flow Statement (Focus on BKP 2-5)
Starting point: Outstanding construction costs (contracted BKP 2–5 minus actual BKP 2–5 + business case reserves). Below that: all funding sources (green, positive). Result: funding surplus (green) or funding shortfall (red).
| Position | CHF | Note |
|---|
Funding Sources (editable)
All amounts are net in CHF. Positive amounts = cash inflow / available funds. Changes are immediately reflected in the financing statement above. Raiffeisen bank account balance = current available balance in the Raiffeisen construction account; this amount is deducted before other sources.
| Source | Amount (CHF) | Note |
|---|