Financing
You know how to export a financing plan as an Excel file, what each column holds and what the file leaves out.
The export saves a financing plan as an Excel file with one row per source. You can send it to a financier, an accountant or a co-producer who does not work in KOSMA.
With a plan open in Financing, choose **Export Data** in the **Project** menu. KOSMA opens your computer's save dialog and suggests the plan's name as the file name, with the extension .xlsx. If no plan is open, **Export Data** is greyed out. KOSMA shows no message after saving.
The file has one worksheet, named *Financing* in every language.
The columns appear in this order, with the headers in your KOSMA language.
| Column | Holds | | ------------------------------ | ------------------------------------------------------------------------------------------------------------------ | | **Country** | the country the source is under | | **Group** | the group the source is under | | **Source** | the source's name | | **Currency** | the source's currency | | **Amount** | the result of the source's **Amount**, in its currency | | **Amount in display currency** | a stored value, not a converted amount (see below) | | **Currency rate** | the value of one unit of the budget's default currency in the source's currency, to five decimal places | | **Status** | **Pending**, **Submitted** or **Confirmed** |
Sources appear in the order of the grid. Countries, groups, installments and totals have no rows of their own. Deactivated sources are included, with no mark.
If you have not set a status for a source, its **Status** cell stays empty, although the grid shows **Pending**.
**Amount in display currency** is not a converted **Amount**. It is a stored value that does not change when you change the amount. For a source you added in KOSMA 3, it shows 0. For a source from KOSMA 2, the previous version, it shows the value from KOSMA 2. The demo project shows such values too. Do not calculate with this column.
Example: budget in EUR, source in CHF, **Currency rate** 0.93000. Then 9,300 CHF is 10,000 EUR. To convert an **Amount** into the budget's default currency, divide it by **Currency rate**.
An **Amount** entered as a formula goes into the file as its result, never as the formula. If the formula has no result, or the source has no **Amount**, the file shows 0. To see the formulas in the grid, click  **Switch value/expression display** in the toolbar. See [switch between values and formulas](/kb/article/switch-between-financing-values-and-formulas).
The file has no columns for the number, company, effect, tax, cash flow rule, tags, notes or attachments of a source. It also has no percentage shares and no received amounts.
If the recipient needs the installments, or a plan without the deactivated sources, print the plan instead. In the **Project** menu, choose **Print…**. In the print dialog, tick **Installments** to include them. KOSMA prints deactivated sources only if you tick **Deactivated Funds**. See [print a financing plan](/kb/article/print-a-financing-plan).
Markdown