Excel Financial Reporting , Financial Analysis Tools

iSuite

The Global Software iSuite contains state-of-the-art reporting tools for the materials management and financial operations of your organization.

Developed as a single system, iSuite uniquely integrates the materials management, general ledger, and accounts payable functions to deliver information to the user's desktop. iSuite incorporates the latest web-based and browser technologies and tools in its reporting.

Some of the key features of the iSuite of financial analysis tools include:

Extensive features for materials management, general ledger, and accounts payable.
Dynamic integration with Excel to provide features such as reporting and graphing, budgeting, and journal voucher entry.
Easy exchange of information with other applications.
Full EDI functionality (850, 855, 856, 832, 810, and electronic matching)
A wide range of hand-held functionality, including bar code capture and utilization. Information and reporting delivered in Adobe PDF, Microsoft Word, and Excel with a single click.

Internet-based Global Procurement system (iGPS)

Purchasing Management

Features Include:

Automatic generation of purchase orders from requisitions
File items and non-file items on a single requisition and PO
Blanket, standing, credit, consignment, and receipt-less purchase orders
Note capability at PO header and line levels
Vendor order cycles
Multiple buy-from locations, invoicing, and paying locations per vendor
Suggested order lists generated automatically
Stockless purchasing tools and direct delivery to departments
Multiple "ship to" locations
Fully integrated EDI (850, 855, 856, 832, and 810)
850 (PO) and 810 (invoice) electronic matching
Contract management including contract notification on price change

Requisition Management

Features Include:

Easy to use online requisitioning
Cross-organization requisitions
Requisition approval routing based on item type, cost, commodity code, vendor, and approver's organization
Automated pick cycle support
Customized order guides for departmental supplies
External requisition import
Par cart fulfillment
Detailed department usage analysis available online to departmental managers
Mass change capabilities

Inventory Control

Features Include:

Unlimited organizations and asset locations
Charge-to vs. ship-to departments
Cross-organization/multi-location capabilities
Bar code (e.g. UPN) item management
Item tracking via lot number, serial number, and/or expiration date
Catalog includes stock and non-stock items
Chargeable and non-chargeable expense code allowed per item
Flexibility to manage an unlimited number of units of measure per item
Dynamic links to item pictures and MSDS (internal or Internet addresses)
User defined fields

Invoicing

Features Include:

Recurring invoices
Integration with Materials Management for invoice / PO matching
EDI 810 support for automated invoice / PO matching
Invoice exceptions easily handled
Separate invoice entry and approval processes
Optional invoice groups and invoice controls
Extensive invoice tolerance parameters
Unapproved invoice accrual processing
Invoice distribution
Single or multi-organizational distribution accounts

Vendor Management

Features Include:

Single vendor file for purchasing and accounts payable
Separately maintained purchasing and accounts payable data
Multiple purchasing locations per vendor
Multiple and separate invoicing and paying locations per vendor
Vendor balances and vendor statistics
Vendor suspension and reinstatement
Views of purchase orders, invoices, payments, etc., by vendor or location
Single or multi-organizational distribution accounts
Distribute by dollar amount or percentage
Selectable profiles for invoice creation
Flexible vendor and invoice inquiry
Powerful custom reporting tool

Payments

Features Include:

Payment selection by invoice, vendor or payment profile
Payment priorities
View and edit invoices selected for a payment
Free-form check formatting
Separate processes for selecting, approving, and printing checks
Reinstate voided checks
EFT payments
Clear/unclear individual checks or a range of checks
Enter and process handwritten checks
Automated cleared check import

Internet-based Global Financial System (iGFS)

GENERAL LEDGER- ACCOUNTS

General

Features Include:

Customizable account structure
Maximum length of 45 positions and nine segments
Financial and statistical accounts
Mass copying of individual accounts across departments, or mass account copying to new departments
Automatic entries to inter-company accounts
General Ledger exchanges information with Accounts Payable

Inquiry

Features Include:

Actual balances by account by period
Journal entry detail
Budget statistics
Drilldown from summary to detailed to source data

GENERAL LEDGER- JOURNAL VOUCHERS

Features Include:

Auto reversing journal vouchers
Recurring journal vouchers
Journal voucher templates
Statistical journal vouchers
Excel-based journal vouchers with dynamic upload to GL
Un-posting of journal vouchers
Mass posting of journal vouchers
Automatic journal voucher import from other systems
Prior period / prior year processing and controls

GENERAL LEDGER- BUDGETS

Features Include:

Unlimited budgets per account per year
Budget creation for financial and statistical accounts
Budget revision tracking
Statistical journal vouchers
Excel-based budgeting dynamically integrated with GL

GENERAL LEDGER- FINANCIAL STATEMENTS

Features Include:

Customizable financial statements and management reports
Easy to use spreadsheet-like report builder
No third party products required
Presentation quality formatting
Automatic scheduling and generation
Drilldown from any financial statement number
Interactive Microsoft Excel reporting interface to live GL data
Macros provided to assist report creation
Consistent security parameters between both reporting options
Drilldown to detail to source from Excel reports