36049 - How to use an Accounting Software Application

Learning outcomes

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  installed in green lab

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

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.

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