FIN922 SECURE ACCOUNTING

1
FIN922 SECURE ACCOUNTING
Luis Teofilo Nunez Presidentlnunez_at_cautus.net 1-3
05-372-7989 X 23
Dr. Carlos FerranProfessor of MIS (and
DBMS)cferran_at_psu.edu
August 8, 2003
2
Agenda

• Introduction
• Accounting Information Systems An asset or a
  service
• Developing a Computerized Accounting Information
  System
• The SIM model
• Current technologies and trends for Accounting
  Information Systems

3
Agenda

• Advantages of an AIS service through the Web
• Application Secure Accounting
• Questions and Answers

4
Who are we?

• Transnational corporation funded in March of 1999
• Our offices are located in
• Miami, FL, USA Financial District
• Caracas, Venezuela
• We develop On-line Management Information Systems
  using Java technology.
• We have a multidisciplinary team, with years of
  experience in management, marketing, accounting
  and technology.

5
Who are we?

• Luis Teofilo Nuñez
• BS - Computer Science (Northeastern University in
  Boston Massachusetts)
• Executive Director of El Universal (The largest
  daily newspaper in Venezuela)
• Founder Computación Global (information
  technology magazine for the Venezuelan market)
• Member of the board in several major Venezuelan
  financial institution like Arrendadora
  Consolidado (subsidiary of Venezuela's third
  largest bank), Banco de Venezuela (the second
  largest bank), Notitarde (newspaper in Valencia,
  Venezuela)  
• Launched the on-line version of Computación
  Global, www.computacion.com. 
• Current president of Cautus Networks Corp.

• Carlos Ferran Urdaneta
• Doctor of Business Administration (Boston
  University)
• Master in Finance
• Assistant Professor of Management Information
  Systems at Penn State University
• Teaches courses in Database Management Systems
  and Information System Strategy
• Former CIO at a major Venezuelan bank
• Consultant on information systems to several
  major Venezuelan and US institutions like PDVSA,
  Inelectra, Sunbeam Corp, USFeed Grain Council, US
  Meats, and American Soybean Association.
• His current research is on how culture and
  technology affects the way we communicate and is
  aimed towards a better understanding of how
  Technology Mediated Communications (TMC) differ
  from face-to-face communications.

6
Who are you?

• Directors
• Vice Presidents
• Technology Managers
• Developers

7
Accounting Information Systems An asset or a
service

• Before 80s
• Service
• Low cost
• Batch

• 80s
• Asset
• Low cost
• On-line
• Not networked
• Incomplete

• 90s
• Asset
• High cost
• On-line
• Networked
• Integrated
• Comprehensive

• Today
• Service
• Low cost
• On-line
• Networked
• Integrated
• Ubiquitous
• Comprehensive

8
Developing a Computerized Accounting Information
System

• Using a mirror image of the books for the
  database structure generates anomalies
• Accounting Transactions reflect business
  transactions
• Business transactions are stored in separate data
  objects
• Redundancy and possible inconsistency

9
Developing a Computerized Accounting Information
System

• Mirror the existing manual system

Bookkeeping structure
Redundant Database structure
10
Developing a Computerized Accounting Information
System

• Using an appropriate database structure
  eliminates some possible anomalies
• Accounting transactions derived from business
  transactions should not be physically stored
  they should be derived
• Accounting transactions derived from business
  transactions should be found on database views
  (stored queries) of the business systems

11
Developing a Computerized Accounting Information
System

• SIM SolutionA proper DB Structure

Bookkeeping structure
Non Redundant Database structure
Redundancy
12
Developing a Computerized Accounting Information
System

• Reengineer Accounting
• An established profession whose principles are
  based on tradition and consistency
• A profession made up of individuals not usually
  inclined to change
• A powerful charter that regulates the profession
• Accounting will progress through evolution not
  revolution

13
Developing a Computerized Accounting Information
System

• Mirror the existing manual system
• Back to mirroring the manual system in both the
  background and the foreground
• Leave the foreground (User Interface) but
  reengineer the background (DB structure and
  algorithms)

14
Developing a Computerized Accounting Information
System

• Technologies Trends
• Develop in-house
• Software packages
• Large ERP system that includes best practices
• Flexible packages that adapts to current
  organizational infrastructure
• Adapt a generic program from and by a consulting
  company
• Outsource--Hire the service over the web
• Java technology
• HTML technology

15
Developing a Computerized Accounting Information
System-Summary

• We Should not design the DB structure as mirror
  images of the accounting books
• We cannot change the way that accountants view
  accounting
• Except for accounting firms, Accounting
  Information Systems (AIS) are not part of the
  core of the business of most companies
• If your AIS is not a part of your core business
  treat it as a service/necessity and not as an
  asset

16
The SIM model

• SIM is a database model developed by Cautus
  Networks Corp. and used by SecureAccounting
• The SIM model eliminates the database redundancy
  normaly inheritated from the manual system
• SecureAccounting creates a user interface that
  use views of the SIM model to mirror the manual
  system

17
Advantages of an AIS service through the web

• No investment on AIS as an asset
• Concentrate in your core competencies
• Worldwide access (Internet)
• Always updated
• Professional data backup
• Professional data security

18
Secure Accounting
19
Secure Accounting
www.secureaccounting.net
www.secureaccounting.net
20
Secure Accounting
Login
21
Secure Accounting
Company Login
securedemo2
22
Secure Accounting
User Login
LTN

23
Secure Accounting
Main Menu
24
Secure Accounting
Main Menu
25
Secure Accounting
Customers
26
Secure Accounting
Customers
27
Secure Accounting
Customers
28
Secure Accounting
Chart of Accounts
29
Secure Accounting
Transactions
30
Secure Accounting
Reconcile Bank Account
31
Secure Accounting
Reconcile Bank Account
32
Secur Accounting
Reconcile Bank Account
33
Secure Accounting
Reconcile Bank Account
34
Secure Accounting
Reports
35
Secure Accounting
System
36
Secure Accounting
Windows
37
Secure Accounting
Windows
38
Secure Accounting
Windows
39
Secure Accounting
Help
40
Business Model
41
Business Strategies
42
Questions Answers
?
?
?