Better together: ABUX + MS EXCEL

Many people use Excel as a database manager, which is not its original function, making this activity cumbersome. ABUX uses Excel for data presentation, but handles database management itself, returning Excel to its original spreadsheet and data presentation function.

With ABUX, accurate and consistent data management is achieved while allowing the user to remain in their familiar environment.

Read more
Excel Abux
Basic excel functions
Formulas, Macros, Graphs, Pivot tables, formatting solutions etc.
Software based on OLAP cube, dinamic Excel-extension.
Based management
Centralized data storage (SPOT - single point of truth)
Automatic data transmission from source systems
Data security is available over huge number of records
Role-based access control
Implementing structural changes rapidly
Database management (on Excel platform)
Financial planning
Direct connection with database (even through Pivot)
Templates for input data
Top-down planning via Pivot
Usage of templates for planning (with automatic access control, no need to create separated tables for users with various data access)
Automatically filled business plan through the aggregation of already completed input templates.
Handling parallel versions of business plan
Reporting
Automatic data update in the background
Scheduled report sending function
Rapid, ad-hoc reporting
Unlimited number of dimensions and hierarchies in business reports
Drilldown (data drilling) till source data (i.e. invoices)
Managaeble size of reports (data is stored in Advanced Budgeting instead of Excel sheet)
Additional, extra functions
Cash-flow, balance sheet and P/L immediately
Consolidation (complete financial consolidation including inter company eliminations, partial ownership rules
Template for planning an investment, calculation for depreciation
Anonymus platform for HR planning
Age of assets as an automatic function in analysis
Cost allocation (based on product/partner/project/working no./cost-centre/etc ...)
Calculation of break-even point (based on partner or product hierarchy)
Calculation of bonuses (based on partner and product hierarchy)
Forecast calculation in background
Copying versions rapidly - to create any combination of versions based on facts or plan data

Trade

Planning

ABUX enables efficient planning of commercial activities, especially in managing a large number of partners and products.

Since elementary-level planning is not feasible, the technology provides the opportunity to execute planning at an aggregated level. The level of aggregation can be flexibly defined based on individual needs and across any dimension.

Features:

  • Plan-based Dynamic Forecasting: The system can automatically create dynamic forecasts based on previously prepared plan versions, allowing the annual plan for 2025 to be continually updated.
  • Top-down Data Entry: It breaks down aggregated data entry to the elemental level, enabling hierarchical data management.
  • Access Management: During the planning process, multiple users' permissions can be defined separately for any dimension and aggregation level.
  • Parallel Plan Version Management: Optimistic, pessimistic, and realistic scenarios can be created in unlimited numbers, supported by a flexible version copying function.

ABUX integrates with the financial reporting system, ensuring the alignment of planning processes.

Cost Allocation and Coverage Calculation

ABUX assists in the effective allocation of costs, enabling coverage calculation and accurate assessment of profitability.

Multidimensional Analysis of Actual Data

The system allows for detailed, multidimensional analysis of actual data, taking into account the following factors:

  • Geographical Analysis: Territorial data processing, which aids in understanding local markets.
  • Product-Partner Characteristics: Analysis of products and partners to support commercial decisions.


Do you want to see ABUX in action?

Book a live presentation