Effective management reporting
can dictate the success or failure of any organisation.
Without accurate and timely management reports,
organisations run the risk of losing track of
key performance indicators (KPIs), allowing critical
errors to be made and profit-making opportunities
overlooked.
Exchequer Software
recognises the damage that inadequate management
information can do to a business, so powerful
reporting capabilities have always been inherent.
|
|
In addition to the standard
reports built into the system, Exchequer uses OLE
(Object Linking and Embedding) technology to
create up-to-the-minute reports, which have
the flexibility to be used for budgeting, forecasting,
cash-flow analysis, consolidations and financial
modelling.
OLE technology is primarily
used to link Microsoft Excel dynamically to
the rich financial management data held within
Exchequer.
This is possible only because
of the unique way financial data is stored within
the system. There is no importing, no macros
and no waiting! All you do is open up your
spreadsheet, enter your password and the real-time
data will instantly appear.
By utilising this technology,
vital decision support data, such as general
ledger actuals and budgets, stock sales and
margins, customer buying trends and much more,
can be instantly retrieved onto any Excel spreadsheet.

Every
functionality you could wish for
There is no need to go through
transition files to accumulate data; live
values from Exchequer are linked dynamically. Over
300 Add-In functions are supplied with the
Exchequer financial modules.
In order to deliver even
greater levels of information to decision-makers,
Exchequer's advanced Excel integration even
offers the facility to drill-down on totals
within the spreadsheet in order to present
a list of relevant transactions. These transactions
may then be selected in order to view the
original transaction just as if you were
working in the main software system itself.
Reader-friendly reports
You may wish to offer departmental
managers accurate and easy-to-use management
reports in a format they understand. By
designing these reports using this technology,
managers can instantly view and interrogate
information at any time in this simple and
familiar format.
Existing users of Exchequer
find queries to the finance department have
reduced dramatically due to the ability to
view individual transactions making up totals
directly from the reports.
 In
addition to this, an optional OLE SavePack
is available, which provides a further 200
functions for updating specific data within
Exchequer from an Excel spreadsheet. Using
these functions you can set budgets in your
spreadsheet that seamlessly update the budgets
inside Exchequer.
You can also create journal
transactions, ideal for calculating and posting
inter-company, cost-allocation or depreciation
journals.
Finally, most data fields
within the customer, supplier and stock databases
can be updated from Excel, providing a powerful
tool for maintaining records or performing
instant price updates.
The power of this technology
cannot be emphasised enough. Its impact
on analysis and presentation within your organisation,
without clumsy importing and exporting, extends
the reach of your accounting system beyond
the most ambitious expectations.
The scope of its use is truly
staggering, as many thousands of Exchequer
users have discovered to their advantage.
It is a fact that 80% of SMEs
are having to spend hours or more producing
meaningful management reports - a process
which should be taking minutes, and 67% of
SMEs would prefer the ability to be able to
produce these reports within Microsoft Excel,
in order to improve ease of use and simplify
data analysis. These are ALL features which
are readily available within Exchequer.
|