When this upload fits
- Plan or forecast — write monthly amounts from a model into their own layer and select them in the report next to actuals.
- Modelled additions — keep values that do not come from the accounts separate from imports and manual entries.
- Overwrite again — later replace the same layer with the current state from the spreadsheet.
Prerequisites
- The add-in is set up (email, organisation UUID, add-in API key).
- In Fyvel there is an unlocked booking layer to write to. Under Booking layers, create a layer of type Custom. Snapshots are locked and do not accept an upload. Layers of type Statistic cannot be filled with this template.
- You have the layer UUID of the target layer. On the Booking layers page it is under the name. The copy icon puts it on the clipboard.
- The organisation UUID is under
Company settings > Add-ins.
Insert the template
Excel: Open the task pane and under Upload click + Template, then Booking layer values. Google Sheets: Open the sidebar, click +, then under Upload-Vorlage click Buchungsebenen-Werte. The add-in creates a new sheet, by defaultfyvel-upload. If that name already exists, the sheet is called fyvel-upload (2), and so on.
Cell A1 must stay FYVEL UPLOAD. That is how the add-in recognises the sheet.
Fill in the sheet
Row 7 describes the columns. Data rows start at row 12. In column A you choose the row type from the list:
Each row has exactly one row type. The UUID or number must belong in Fyvel to the company of the booking layer.
Cost Center (column C) is optional. If you fill it, enter the cost-center number as an integer. An empty cell on a category row uses that category’s cost center. If the category has none, or the row is an account group or account, the amount is stored without a cost center. A number in the cell is kept as entered, including when it differs from the category.
Period (row 9, from column E) is the month of the value column. The first period is a date. Each following column moves one month forward. You can change the start date. The following months follow it. A value column without a date is ignored as long as there are no amounts below it. If the column has amounts, the period date must be set.
Amounts start at row 12 in the columns headed Value (by default E through P, twelve months). Empty amount cells are skipped. Add further months to the right: heading
Value and a date in the period row.
Enter amounts the way they should appear in a P&L with the usual sign convention. In balance-sheet rows the direction is reversed.
Send the data
Excel: On the sheet’s row, click Send. Only this sheet is sent. A booking-layer-values sheet writes into the booking layer from cell B5. Google Sheets: In the sidebar under Hochladen, click Senden on the sheet’s row. Only this sheet is sent. A booking-layer-values sheet writes into the booking layer from cell B5. Two sheets with the same layer UUID replace each other, and the add-in asks before sending. After sending, the sidebar shows how many rows arrived from how many sheets. You can then select the layer in reports and in the add-ins, including as a forecast layer in rolling forecast.Plan module from Excel or Google Sheets
Revenue and cost of goods sold are often calculated in a model of their own, for example quantity × price. An upload module makes these values part of a plan:- Open the plan, click Edit, and in the modules step add an upload module under Upload from Excel or Google Sheets. Each company in the plan gets its own layer for it.
- Open the module’s tab. It has a guide and a prepared template to download: one sheet per company with the organisation and layer UUID already filled in, and one value column per plan month. Optionally, the template adds one row per category for selected account groups.
- Link the value cells to your model and send the sheets as described above.
- Only admins with access to planning can upload.
- The upload rejects periods outside the plan horizon.
- Every upload replaces all of the company’s values in this module.
- Fyvel does not check whether the same accounts are already planned in another plan module. Make sure nothing is planned twice.
- If the module is locked, the upload fails with Layer is locked.
Common errors
- No upload sheet found — A1 is not exactly
FYVEL UPLOAD. - Organisation UUID or layer UUID is missing — B4 or B5 is empty.
- Layer is locked — the layer is a snapshot or locked for another reason.
- UUID or account number is invalid — the entry does not exist in this organisation, or not at the company of the layer.
- Unknown row type — column A contains something other than Category, Account Group, Account, or Account Number.