Excel based Solutions

The ECL Fixed Asset Manager is a Fixed asset register and a planning tool in one and is the software you need to meet your fixed assets accounting and planning requirements. Based on Microsoft Excel and programmed in Visual Basic, this application is easy to understand and gives full flexibility to meet individual requirements and unlike pure spreadsheet solutions is absolutely reliable and entry error proof. It is designed to meet International Accounting Standards (IAS) / International Financial Reporting Standards (IFRS) and other accounting requirements, as well as providing an indispensable tool to plan and control your business.

Get your free demo version (30 day trial) now!

Standard features:

bulletGeneral
bulletbased on easy to understand Microsoft Excel
bulletdeveloped in Microsoft Visual Basic for Applications
bulletMaster data
bulletup to 7 different classification criteria (site, division, Cost centre, department, location, asset class, tax asset class)
bullet4 accounting codes possible per asset (balance sheet code (accounting + tax), P&L code (accounting + tax)
bullet2 different accounting treatments per asset
bullet3 free text fields
bulletinput fields for acquisition cost (accounting + tax), residual value (accounting + tax), replacement value, insurance value
bullet3 fields for additional information (vendor, serial no., project no.)
bulletdepreciation start date different from capitalisation date allowed
bulletup to 65000 records
bulletAutomated functions
bulletnew record (use of existing assets as templates for fast data entry)
bulletdelete record
bulletdeactivate asset (sale, scrap, disposal)
bullettransfer asset (to different site, asset class etc.)
bulletsplit asset (to handle partial disposal, partial transfer)
bulletgroup asset (to include different parts into one record)
bulletCalculation
bulletaccumulated depreciation
bullet2 different depreciation methods (accounting and tax) per asset
bulletretroactive calculation of past years (for assets capitalised in previous years)
bulletdifferences between accounting and tax values for deferred tax
bulletdepreciation check (understand the formulas in Excel)
bulletsimulation for the following 4 financial years (accounting and tax)
bulletReporting
bullet7 standard report templates pre-configured
bulletunlimited number of user defined report templates
bullet10 different filter criteria for each report
bullet10 different sort criteria for each report
bulletfree format of user defined report templates
bulletDatabase Explorer
bulletall fields of the database are visible and can be analysed in an Excel spreadsheet
bulletdatabase can be freely sorted, filtered and analysed (using Excel standard functions)
bulletYear End Procedure
bulletasset data and depreciation values are automatically transferred into the new financial year
bulletasset data can be maintained in both current year and previous year (automated update possible)
bulletassets disposed off in previous year will not be taken over into the new year
bulletPassword Protection
bulletuser password protection (password can be changed by user)
bulletBackup and Restore
bulletup to 10 backups can be maintained automatically (the 11th overwrites the 1st)
bulletPlanning (Budgets and Forecasts)
bulletfor planning purposes actual data is copied into a separate database
bulletsimulation of existing assets
bulletcreation of new (planned) assets
bulletroll forward of existing asset data into existing planning database without changing previously planned assets
bulletdetailed planning possible (e.g. on the basis of individual projects or Cost Centre budgets)
bulletplanning can be based on existing planning data (allowing multiyear long term planning)
bulletnumber of planning versions unlimited
bulletCustomising
bulletuser can customise most of the settings (no specialised knowledge necessary)
bulletsupport available for special needs (take advantage of the flexibility of the Fixed Asset Manager)
bulletinterfaces to and from general ledger (SAP, Sage etc.) can be easily built in most cases.
bulletSystem Requirements
bulletMicrosoft Excel 2000 or higher (older Excel versions on request)
bulletMicrosoft Windows 98 or higher
bulletAdditional Features on Request
bulletadditional depreciation methods
bulletadditional report templates
bulletonline/phone support for customising and training
bulletadditional functions as required
bulletinterfaces to ledger or other software
bulletSAP downloads from SAP asset module
bulletother interfaces
bulletmulti-currency handling
bulletolder Excel versions
bulletchange of nomenclature
bullethiding of unused features
bulletadditional asset books (group depreciation etc.)
bulletmulti-company licences

View: screen shots

Get your free demo version (30 day trial) now!

Price: £ 395.00 (+VAT), includes Fixed Asset Manager (Version 1.3e) full version + 1 hour of online/phone support for setup, customising, training or additional requirements. (Send email quoting: "FAM Intro Offer" with your email address, name and contact details) mail to: sales@eppert-consulting.com

This software is also available in German!

Back to Software Solutions

mail to: info@eppert-consulting.com

Home  Site Map  Software Solutions  About us  Contact us