Budgeting
You can turn an .xlsx spreadsheet into categories, groups and accounts of a budget, and you know what the import brings across and what you add afterwards.
The import creates new categories, groups and accounts in a budget from a spreadsheet, so you do not type the numbers again. KOSMA imports the structure and the numbers only. You add formulas and account details in KOSMA afterwards. If a template already has the structure you need, start from the template; see [create a budget from a template](/kb/article/create-a-budget-from-a-template).
KOSMA is working on an automatic import. Until then, the KOSMA team imports your budgets for you as a service: from Movie Magic, SESAM, Excel and from your company's own templates. Write to <support@kosma.io>.
Put the data on the first sheet of an .xlsx file. The first row holds the column names. KOSMA finds each column by its name, so the order does not matter:
The names work in every KOSMA language, as the import dialog lists them and as KOSMA writes them when you export a budget to Excel. KOSMA ignores every other column, for example Total. You can leave out the columns you do not need, so a budget you exported from KOSMA imports as it is.
Every row with an account number becomes an account and needs a value in Category, Group, No. and Description. A row without an account number but with a Quantity, Price/Unit, Unit, Currency or Factor becomes a sub-position of the account above it, as in a KOSMA export. The account's total is then the sum of its sub-positions, and Quantity and Price/Unit of the account row itself are taken over by its first sub-position. KOSMA skips rows without an account number that have none of these values, such as headings, even when they have a Description. Quantity, Price/Unit, Unit, Currency and Factor can stay empty. Factor is the budget's X column. An empty Quantity or Factor counts as 1 and an empty Price/Unit as 0, so a row with Quantity 3, Price/Unit 100 and no Factor gets a total of 300. Quantity, Price/Unit and Factor hold numbers. KOSMA reads 1.234,50 and 1,234.50 alike. Write a number with its decimals, because 1.234 on its own could mean either. Each account number may appear only once, in the file and in the budget you import into.
KOSMA reads only .xlsx files and shows no others when you choose the file. Save an older .xls file as .xlsx in your spreadsheet program first. If the file is damaged, or is an .xls file that was only renamed to .xlsx, KOSMA imports nothing and shows an error.
Use one currency in the whole file. KOSMA makes it the budget's default currency and also applies it to rows that have no currency.
If the budget does not have the file's currency yet, KOSMA adds it with exchange rate 1. The exchange rates of the budget's other currencies are then wrong. Enter the current rates in **Currencies**; see [set the currencies and the reporting currency](/kb/article/set-currencies-and-the-reporting-currency).
In Budgeting, choose **Import Data** in the project menu. KOSMA opens **Import Budget Data**.
Click **Load .xlsx File** and choose the .xlsx file. KOSMA adds the rows to the budget and closes the dialog.
KOSMA creates a category for each Category name in the file and a group for each group within it, after the budget's existing content. KOSMA adds the accounts to them in the order of the file. Existing categories, groups and accounts stay as they are. To undo the whole import in one step, press ⌘Z (Ctrl+Z on Windows).
KOSMA imports only the result of each spreadsheet formula, so quantities and prices arrive as fixed numbers. They no longer change when the numbers they were calculated from change. Where a number must depend on other numbers again, add a [formula](/kb/article/write-a-formula) or a [variable](/kb/article/what-variables-are) in KOSMA.
In the **Account Details** panel, add what each imported account needs. The import fills nothing in this panel: **Companies**, **Effects**, **Fringes & Supplements**, **Extra Costs** and **Taxes** stay empty on every account. See [how account details work](/kb/article/how-account-details-work).
Keep the account numbers from the file, or renumber the budget with **Edit** > **Renumber Budget Items**. Only the accounts keep the numbers from the file. The new categories and groups continue the budget's existing numbering. See [number accounts and groups](/kb/article/number-accounts-and-groups).
**If the import fails.** If the file breaks one of the rules in step 1, KOSMA imports nothing. The message names the file, the row and the column of the first problem (`KOSMA-E-1024`). Correct that cell and click **Load .xlsx File** again.
**If Load .xlsx File is greyed out.** You can only read this budget, for example on a **Free** licence or as a guest without editing access. See [what your licence includes](/kb/article/what-your-licence-includes).
Markdown