Budgeting
You can turn the budget form of the Swiss Federal Office of Culture into a new budget with KOSMIQ, and you know what the new budget contains.
KOSMIQ turns the Excel budget form of the Swiss Federal Office of Culture (BAK, in French OFC) into a budget. You need a licence other than **Free**, even in the demo project, and you must be signed in; see [what your licence includes](/kb/article/what-your-licence-includes). AI answers can stay off.
In Budgeting, click  **KOSMIQ**. In KOSMIQ, click  **Attach a file** and choose the form's .xlsx file (at most 2 MB; see [get help from inside KOSMA](/kb/article/get-help-from-inside-kosma)). KOSMIQ recognises the form at once, says how many account rows it has and asks whether to create a budget from it.
Typing *Create a budget* without a file makes KOSMIQ ask you for the form. To keep the form as a file on an account instead, click **Attach to an Account** beside **Do it**.
Click **Do it**. KOSMA creates a new budget and opens it; the budget you had open stays unchanged.
The budget takes the form's language: **BAK Budget Herstellung FIC & DOC 2026** from the German form, **BAK Budget Réalisation FIC & DOC 2026** from the French one. You get the form's accounts with its account numbers. The form calculates overtime in a row of its own for each department; KOSMA collects it on account 40000 **Überzeit** at the top of category IV. Beside it, KOSMA creates account 40001 **Nachtzuschläge**. That is why KOSMIQ names fewer accounts after the import than account rows in the offer.
If the form states no unit for an account, KOSMA creates it as a lump sum, and KOSMIQ tells you how many such accounts there are.
Set the right unit before you enter quantities, so that 6 means six weeks and not six lump sums.
The budget is in CHF. Each wage account except directing (22000) has the subaccounts **Vorbereitung**, **Dreh** and **Abwicklung** (French: **Préparation**, **Tournage**, **Bouclage**). The form is also saved as a template under **Custom Budgets** in **New Budget** ([create a budget from a template](/kb/article/create-a-budget-from-a-template)). That template holds no figures, so a budget you create from it shows 0 everywhere. A second import creates a second budget of the same name.
The rates for social charges always come from KOSMA, not the form: check that they are current. KOSMA does not read the SSFV guideline wages either. They are in a second workbook, so their variables have no value.
What else the budget holds depends on whether the form is filled in. A form counts as filled in as soon as one account has a quantity with a price, or a typed amount. A quantity without a price does not count.
If the form is not filled in, prices and totals are 0. Quantities are 0 too, except on **Dreh**: its quantity is the variable **DW**, the shooting weeks, so it changes when you change the shoot length. The markups are KOSMA's, 7.5 % and 5 %.
The new budget takes these figures from a filled-in form:
- Wages: the form's weekly wage becomes the price, and its weeks per phase become the quantities of the three subaccounts. The account total is weeks × weekly wage × 1.0833, which adds 8.33 % holiday pay. A wage row with no weeks per phase goes entirely on **Dreh**. - Shoot length: the form's Drehzeit sets the shoot phase and **DW**. If a wage row's weeks on **Dreh** equal the Drehzeit, its quantity stays **DW** and changes when you change the shoot length. Any other number stays that fixed number. - Other accounts: the form's quantity and price, or one amount if the form states only that. VAT rows are not imported. - Overtime: KOSMA multiplies the form's percentage by 1.25, because the first overtime hours cost 125 % under Art. 16.4 of the AAB. That makes 5 % on the form 6.25 % in KOSMA, and the total goes to account 40000. - Social charges, at KOSMA's rates and including overtime: AHV/ALV/EO/IV (41000) and SUVA NBU (41005) apply to crew wages and cast fees without extras (33001) and the agency fee (34000). BVG (41003) applies to crew wages and main roles. SUVA BU (41004) applies to all crew wages and cast fees. Verw. Kosten AHV (41001) and FAK-Beiträge (41002) keep the form's amount. - Expenses: Equipe (61002), Wäschegeld Equipe (61008) and Kilometergeld (65000) keep the form's quantity and price if the form fills them. KOSMA's own row for such an account under **Extra Costs** then has no **Collect In Budget Account**. It is not counted in the budget, so the cost does not count twice. When you confirm a change in the **Extra Costs** settings, KOSMA mentions rows without a collecting account. - Swiss spending and funding: the form's columns Ausgaben in der Schweiz and Ausgaben FiSS 20%, 40% and 50% fill the budget's effect columns. For example, an account of CHF 1,000 with CHF 800 under Ausgaben FiSS 20% shows CHF 800 under **FiSS 20**. If Ausgaben in der Schweiz is empty on a row, the row's amount under Ausgaben Schweizer Produktion counts instead. The French form's columns are Dépenses en Suisse and Dépenses PICS. - Markups: Handlungsunkosten and Unvorhergesehenes take the form's rates. An empty rate counts as 0 %.
KOSMIQ tells you how many accounts took figures, and how many wage rows state no phase. It also compares the form's ZWISCHENTOTAL, the subtotal before markups, with the same figure in the budget. If they differ by more than CHF 25, KOSMIQ names both amounts and asks you to check the difference. It arises because KOSMA calculates some lines its own way, overtime and social charges among them, and does not round to whole francs as the form does.
If a cell for an amount holds text or an error, KOSMA does not read that cell, and KOSMIQ says how many accounts this affects.
KOSMA reads one form: the BAK form for fiction and documentary films 2026 of 6 March 2026, titled *Budget mit FiSS* in German and *Budget avec PICS* in French. Regional funds such as ZFS or Cinéforom are columns in it and become [effects](/kb/article/what-effects-are). Other funders' forms are not recognised. For a spreadsheet with fixed columns, see [import a budget from a spreadsheet](/kb/article/import-a-budget-from-a-spreadsheet).
If KOSMIQ offers no budget or answers **Do it** with an error, download a clean copy of the form from the funding body, keep the sheet name *budget OFC*, and attach the .xlsx file. A renamed sheet or many deleted rows mean no offer. If KOSMIQ reports a defect in the form, KOSMA saves nothing. If KOSMIQ says the form was read but the budget could not be created, there is no new budget. KOSMA saves the template without figures before it creates the budget, so the template is listed under **Custom Budgets** unless saving it was the step that failed. If an account number appears twice, KOSMIQ names the rows. If an overtime or markup rate is outside 0 to 1000 %, KOSMIQ names the cell. If a program other than Excel last saved the file, the results of its formulas can be missing, and KOSMIQ says so in the chat. Open the file in Excel, save it and attach it again, or use the clean copy.
Markdown