36049 - How to use an Accounting Software Application

Learning outcomes

he Teachingobjective is the learning of accountability skills aimed at quantitative determinations, evaluation, analysis and use of data, even with the current regulations.

Course contents

Accounting Management Learning Program
Ercole Vagnozzi


PART I - INTRODUCTION

1. THE INFORMATION MANAGEMENT IN A COMPANY
2. ACCOUNTING SYSTEMS for Enterprises (EDP)
3. ACCOUNTING  MANAGEMENT SYSTEMS for enterprises (ERP)
4. MONO-SYSTEMS AND CLIENT / SERVER

PART II -  ADMINISTRATIVE / ACCOUNTING FIELD - Aaccounting Management  system settings

1.  PARAMETERSCONFIGURATION
2. AUDITORS' PLAN
3. ACCOUNTING CAUSALS
4. RECORDINGS OF FIRST NOTE
5. PRINTS:
a. THE JOURNAL BOOK
b. BUDGET
c. VAT REGISTERS

PART III - USE OF a MANAGEMENT Prgram

1. PURCHASE FORM
2. SALES FORM
3. GENERAL ACCOUNTING MODULE
4. OBSERVATIONS AT THE END OF THE YEAR

PART IV - BUSINESS INTELLIGENCE
- ETL (extract load transformation) of data and system settings with BI software QLIKVIEW

1. standard Interface of the query formulation
2. Drill Down
3. roll up
4. Data Cube (slice-and-dice)

Readings/Bibliography

-The course includes theoretical skills be studied through lecture notes deposited on campus link https://campus.cib.unibo.it

- the use of two softwares available in the green lab and to be downloaded:


Management system called Euro09 to download at the link http://dl.dropbox.com/u/15620196/euro09.iso full of manuals (requires daemon tools http://www.daemon-tools.cc/ita/homeper to be installed)

ETL (Extract Transformation Load) through software and workbench manual available in green lab and sto download at: http://www.mysql.it/products/workbench/


Business intelligence software named QlikView full of examples and downloadable manual from the link http://www.qlikview.com/it
Recommended reading:

Teaching methods

The course provides a comprehensive overview on the use of computerized accounting systems, dealing with a point of view of both theoretical and practical issues related to the main business processes and their automation.
The course also fits the exercices module which is part of thecomputerized accounting systems' course (Prof. G.Neri).

Assessment methods

The final evaluation will cover the following modules:
1. Case studys to be directly solved through the accounting management system and the creation of the BI system;
2.open questions on theoretical topics presented in class

Teaching tools

The course will take place almost exclusively with the use of PC
The softwares used are in the bibliography

Links to further information

http://www.serice.it

Office hours

See the website of Ercole Vagnozzi