Here are some common sources of error.
Account Management
There are accounts in the budget view that do not exist in the bookkeeping, for example, "4999 Budget diff: Direct costs".
This may, for example, be due to:
1. An account appears in multiple places in the file (NOTE! only one row per account will be imported), which leads to incorrect summation.
Solution: Correct the file and import it again.
2. An account is listed under the wrong account range in the file (NOTE! accounts are imported in numerical order, regardless of how they are arranged in the file being imported)
Solution: Correct the file and import it again.
3. Incorrect summation on one of the rows in the income statement summaries in the imported file
Solution: Correct the file and import it again.
4. If importing is done by account groups, you need to follow the groups that are standard in the system. There may be incorrect summations between costs and revenues.
Solution: Correct the account ranges in the file and import it again.
5. There are accounts in the Excel file that do not have values; the system may then "insert" values into those accounts because they are included in the import file.
Solution: Remove accounts without values, or alternatively, set 0 in each column. All accounts in the file need to have a value.
File Import
The file cannot be imported:
- The file that was downloaded is not the same file that was filled in and imported
Solution: Download a new file from Boardeaser and fill it in again
- Formatting has been applied in one of the cells.
Solution: Download a new file from Boardeaser and fill it in again
Create Budget Proposal
- The downloaded Excel file contains no figures.
Troubleshooting:
Check that you are using the row template "result full" to download the budget.
Check that the row template for "result full" has not been replaced. If so, revert to the original and try downloading again.
- Proposals created for upcoming years based on this year's actuals + this year's budget do not show any figures from the budget, only for the months for which there are actuals.
Solution: Check that the budget is imported at the account level; if it is at the account group level, it is not possible to match the actuals to individual accounts and supplement with the account group's budget. Export the budget using the "Result full" row template and import again, or alternatively, create it as a new active budget. Export the budget proposal again.
Create Forecast or Budget from Actuals + Budget for Current Year
- Proposals created for the current year based on this year's actuals + this year's budget do not show any figures from the budget, only for the months for which there are actuals. See also the guide How do I create a forecast in Boardeaser? for further information.
Possible error sources:
1. To include future budget values in a forecast/budget, you must be in the period for the last day of the financial year, for these to appear. The bookkeeping must also be imported up to and including the last day of the month for which the actuals are to be calculated. A source of error may be that the system has interpreted that bookkeeping is imported for the entire financial year or a later date in the middle of a month, due to, for example, accruals, and you may need to correct the date in the system for the date up to which transactions are imported.
You can find this under Financials > Data Management (in each organisation), then click the three dots (···) in the upper-right corner and select Settings.
A new window will appear where you can change the date to the last day of the month under "Correct latest period". The date is saved automatically.
2. If there is an active forecast for the financial year, the system will retrieve data from it instead of from the budget. Therefore, check which figures are shown in any active forecast, and if they are incorrect, either delete the forecast or set it as inactive.
After reviewing the two steps above, try again to create a new forecast by being in the last period of the financial year.
Merging Budgets for Subsidiaries/Business Areas
- The totals differ compared to the individual budgets.
Solution: Only accounts with actuals from the bookkeeping are included in the merge. Check whether there is a budget in any company on an account with no actual amount. Correct the budget to an account based on actuals, then redo the merge.
Components
- The budget for the financial year is not visible in the report tables.
See the guide How do I enter my Budget/Forecast in a table? for how to enter a budget in the report tables.
Examples of possible errors:
- The budget is not active; only an active budget will be shown in components. (This also applies to business areas, companies, etc.; each budget must be active)
- The report table may include either a fixed budget column or a forecast column. Check under components that a fixed budget is not selected, yet it shows as active.
- Forecast values are not shown for future periods
Solution: Check the selected period for which to show actuals. If the last period in the financial year is selected, only actuals will be shown
- Incorrect budget or forecast values
Solution: Check that the correct budget/forecast is selected in rows/columns, or that the correct budget/forecast is active for the financial year.
- No figures are shown when a business area is selected
Solution: Re-import bookkeeping for all financial years to be shown in the components. Business areas are "tagged" in the bookkeeping when it is imported to Boardeaser
Rendering Errors
"Warning Message during rendering" - something has gone wrong, and the system cannot visualise the data.
- Check that there are no incorrect financial years on any budget in the BUDGET YEAR column under "Manage budget". The budget year is based on the dates in each column; this formatting must not be changed from the original file. If so, remove the budget(s) and start again. The message should then disappear.
- Check the number of periods entered in the budget specification on the latest active budget, so that there is only data for the accounting year (corresponding to BUDGET YEAR). If there is data in more periods than for the financial year, this will cause a data clash when new data is imported for the corresponding date, and the system does not know how to handle it, hence the rendering error.
Solution: Create a new active budget and import only data for the financial year. Then you can import the budget for the following year.