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.
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** | the **Amount** converted into the display currency, as in **Total** (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.
A source without a status shows **Pending**, as in the grid.
**Amount in display currency** is the **Amount** converted into the plan's display currency: the figure the grid shows in **Total**, for example **Total (EUR)**. To export in another currency, choose it in the toolbar first.
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