The better way to do financial reporting and budgeting in Excel

Home
Solutions
Budgeting
Financial Modeling
Financial Reporting
Consolidations
Services
About Us
Contact Us
Site Map
Solutions
 
XCELLEGEN is a development environment for building financial analytic applications in Microsoft Excel. It improves Excel by giving you a better way to develop Excel applications, such as financial reporting, budgeting and long-term corporate modeling.

XCELLEGEN solves many of the problems associated with creating financial analytic applications in Excel. It has a seamless integration to an accounting intelligent database that delivers accurate numbers in the right format whenever you need them. Importing and exporting balances to the accounting database eliminates error-prone spreadsheet links.

XCELLEGEN includes these key components: (1) Worksheet Author tools, (2) Data Management functions, (3) Tools to audit workbooks, and (4) a Financial Reporting tool.

XCELLEGEN is unique in the way it maintains Excel formulas. Instead of entering formulas into cells, you use XCELLEGEN to define formulas and then accurately publish them to cells.

The Author tools allow someone who has full access to all XCELLEGEN functionality; create applications and models for users who need a controlled environment for financial analytics.

The Data Management functions manage the accounting intelligent database where balances are stored by their natural accounting sign for current period and year-to-date. Reporting and budgeting is easier because balances by period are displayed properly. There can be many Accounting Intelligent Databases for finance, sales or headcount.

The financial reporting tool is used to create board quality reports from data in other worksheets within the same workbook. Models have XCELLEGEN worksheets that contain complex calculations. The reporting tool can summarize and clarify data for presentation.
 XCELLEGEN Excel models have these common characteristics:

  • Based on monthly processing
  • Models are required to be updated for new actual results
  • Processing does not have to be "instantaneous"
  • Data has balances for period to date and current period
  • End-users will use Excel for analysis

 


Important Features

  • Accounting-intelligent database
  • Import and export data to Excel Models
  • Report on non-financial information
  • Eliminate spreadsheet links
  • Create "real Excel" formulas using 10 row types
  • Create sophisticated custom reports with ease
  • Limit data display with Security Filtering
  • Adjust report timeframes
  • Audit and document assumptions and formulas
 Developing Applications

XCELLEGEN is a natural extension of Excel, and leverages your Excel skills. To develop applications using Author, you should be an advanced Excel user with basic database skills and an understanding of accounting. The more ambitious your application development plans are, the more important it is for you to become a competent XCELLEGEN Author.


XCELLEGEN is extremely flexible, allowing you to implement many types of financial analytic applications. In addition to the "template" applications on this website, here are more examples:

  • Capital asset modeling
  • Customer retention analysis
  • Human resource analysis
  • Complex business models
  • Sales forecasting
  • Inventory costing and analysis


DOWNLOAD BROCHURE:

Take a look at an overview of how to create and maintain models.

XCELLEGEN AUTHOR