Report Generator for EXCEL

The Report Generator for Excel is a tool for creating custom financial statements in Excel using data from the Acomba General Ledger.

The Report Generator for Excel brings you the flexibility of Excel functions to create custom financial statement templates. The integration with the Acomba General Ledger means your financial statements are always up to date and you have access to data from previous periods for accurate comparative analyses.

Key Features and Benefits

• Enjoy all the flexibility of Excel to produce custom reports with graphics and links
• Use Excel’s features to create financial statement templates tailored to your needs
  - Sorting
  - Dynamic cross tabulations
  - In-depth analysis
• Access all your accounting data to easily create comparative reports for a year, quarter, month, product, department or project.

Highlights

• Flexibility of Excel to produce custom financial statements
• Access to data from previous periods for comparative analysis

Required Acomba program

Acomba System Manager (Version 8) and Acomba General Ledger

OR

Acomba Construction Suite

OR

Acomba Professional Services Suite

AND

Excel®

• Use of Excel to create and save custom financial statement templates (unlimited number of templates)
• Added Acomba menu for selecting information from Acomba companies
• Interaction between reports and the Acomba database of accounting information
• All Excel options for:
  - Processing data (statistics functions, time/date, etc.)
  - Presenting data (graphics, layout, character fonts, column width, links, etc.)
  - Page layouts
  - Report printing
• Use of an unlimited number of General Ledger accounts
• Production of comparative or consolidated analysis reports for an unlimited number of companies and fiscal years
• List of previous financial statements in each file
• Account range selection according to diverse criteria
• Access to accounting data:
  - General functions (company information)
  - General Ledger functions (information on period balances: account number, name of account, balance, budget, etc.)
  - Project functions (period balances for projects)