EN I HU I DE

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

How can ABUX come in handy?


ABUX offers numerous corporate benefits with its unique solutions. Read more about them below and watch the related presentation.

Flexible Commercial Planning & Forecasting

ABUX supports strategic planning at an aggregated level, allowing retailers to plan efficiently across thousands of products and partners. Plans can be flexibly structured by product group, region, customer segment, or channel — enabling scalable forecasting that adapts to business complexity.

Cost, Margin & Partner Transparency

ABUX delivers precise cost allocation and margin calculation by product, channel, and partner. This enables early identification of underperforming products or categories, supports partner-level profitability analysis, and provides a solid foundation for bonus calculations and contract evaluations.

Multidimensional Insight, Scenarios & Automated Reporting

ABUX enables multidimensional analysis of actual sales data across geography, partners, products, and time. With built-in scenario management and automated reporting, teams can run what-if simulations, track weekly forecasts, and align commercial decisions with financial performance — all from a single source of truth.



Do you want to see ABUX in action?

Book a live presentation