Celenia Enhanced Budget Control

- Celenia EBC module is fully integrated with Microsoft Dynamics NAV
- Automatic projection of budgets based on historical data
- Tight integration between NAV and Microsoft Office Excel
- Financial budgets and sales budgeting on customers and items
- Budgeting on NAV dimension structure
- Automatic calculation of budget for revenue, VAT and COGS
- Rolling budgets and forecasts with just one click
- Cash flow analysis
- Complete budget control and easy follow-up

AUTOMATIC PROJECTION
Today, most budgets are done in Excel with little or no historical data to support the process. With Celenia EBC, new budgets are projected in NAV based on data from previous years, which improves accuracy and ensures that the structure and logic of the ERP system is reflected in the budget and makes budgets/actuals comparisons easy. With Celenia EBC, you can specify which data you would like base y our proje ction on. For instance, making budgets for the following year four months ahead of time means not having historical data for the entire previous year to compare with. Celenia EBC allows you to use those four months from the previous fiscal year to ensure that your budget reflects relevant season changes. Furthermore, you can apply percentage factors at different levels to adjust your projections.

TIGHT INTEGRATION BETWEEN NAV and EXCEL
Celenia EBC is fully integrated with Excel, enabling you to use Excel for modifications and adjustment of the automatically projected numbers without worrying about data loss or compatibility problems.
Quantities, sales prices and cost prices can be exported from NAV to a single Excel sheet, updated in just one view and imported back into NAV.
After creating a budget template inside the Celenia EBC module in NAV, the budget can be exported to Excel spreadsheets and be distributed to other decision makers in the budget process, w ho will b e able to make changes directly in the spreadsheet. The structure of the budget will not be altered because only value fields are open for modifications, the reporting structure is locked. The adjusted numbers are easily imported from Excel back to into NAV. Only Celenia EBC gives you complete control of the budgeting process and structure, even with input from other decision makers.

FINANCIAL BUDGETS AND SALES BUDGETING
Celenia EBC offers two types of budgets: A sales budget on customers and items, where revenue is budgeted, and a financial budget where revenues from the sales budget are transferred, where other income and costs are budgeted, and balance sheet adjustments are done.

BUDGETING ON NAV DIMENSION STRUCTURE
Sales budgeting can be done on any combination of customer/customer posting groups, items and inventory posting groups, and can be split by any dimension of the reporting structure. This enables more detailed budgets and the ability to follow up on individual customer/item/dimension combinations.

AUTOMATIC CALCULATION OF REVENUE, VAT and COGS
Revenue, VAT and COGS are calculated automatically and included in the budget.

ROLLING BUDGETS AND FORECASTS
With Celenia EBC, rolling budgets and forecasts are created with just one click.

CASH FLOW ANALYSIS
Financial budgets can be applied to standard NAV budgets, a unique integrated approach that allows you to do budget/actual comparison and cash flow analysis using standard NAV Analysis Reports and Account Schedules, and extend with any NAV reporting tool.

CONTROL
Celenia EBC makes it easy to do budgets, gives you complete control of both sales and finances budget, and enables effective follow-up and comparison of finance and budget data.