Accounting Pookela Excellence

1
AccountingPookelaExcellence

• Prof. Joel Peralto
• Carol Yacht, Author

2
Accounting software is on every desktop
3
Why integrate technology?

• Because there is a gap between how we teach and
  what is done in the business world.
  
• Because we need to teach students how technology
  has reshaped business.
  
• There is a 75 retention rate with hands-on
  practice.
  
• W. Steve Albrecht, Brigham Young
  University Robert J. Sack, University of
  Virginia study published by American Accounting
  Association, 2000. http//aaahq.org/pubs/AESv16/to
  c.htm

Carol Yacht, Author
Accounting Pookela

February 19, 2006
4
Retention Rates Learning Pyramid
National Training Labs, Institute for Applied
Behavioral Science Bethel, Maine
Carol Yacht, Author
Accounting
Pookela
February 19, 2006

5
What software does business use?

• Microsoft Office Suite
• Word
• Excel
• Outlook, PowerPoint, Publisher, Access
• Internet Explorer
• Accounting Quicken, Peachtree, QuickBooks,
  Microsoft Business Solutions-Great Plains, MAS90
  
• Small Business Accounting
• http//www.microsoft.com/office/editions/prodinfo
  /smallbusiness/management/default.mspx

Carol Yacht, Author
Accounting Pookela

February 19, 2006
6
Accounting Software Market

• Entry-level software Sales up to 5 million 20
  employees 5 million companies. (PT/QB)
  
• Small to medium business software Sales up to
  100 million 100 employees 516,000 companies.
  (PT/QB/GP)
  
• Small to medium enterprise software Revenues up
  to 500 million 500 employees 84,000 companies.
  (GP/MAS90)
  
• Enterprise resource planning software Revenues
  500 million 500 employees 17,000 companies.
  (SAP Oracle Peoplesoft)

A Strategy for Finding the Right Accounting
Software, Journal of Accountancy, September 2003
www.aicpa.org/pubs/jofa/sep2003/johnston.htm
7
Accounting Courses
Financial
Excel
Publisher Designed Peachtree QuickBooks
Computer Accounting
Managerial
Peachtree Great Plains
Excel
Accounting Information Systems
Intermediate
Great Plains
Access
Cost
Great Plains
Access
8

• Form-based-- source-document screens for data
  entry e.g., purchase orders sales orders
  checks.
  
• Cash transactions and bank reconciliation.
• Customer and Vendor transactions .
• Numerous reports including financial statements.
• Payroll accounting option (fee-based service).

Accounting Pookela
February 19, 2006
9
General Ledger Software Design
__________________________________________________
_____________________________________________
Carol Yacht, Author
Accounting Pookela

February 19, 2006
10
General Ledger System
Carol Yacht, Author
Accounting Pookela

February 19, 2006
11
Peachtree/QuickBooks Pros Cons

• Peachtree reinforces accounting procedures.
• QuickBooks does not follow the debit/credit
  paradigm.
  
• Peachtree is double-entry accounting.
• QuickBooks is single-entry.
• Peachtree organizes records by monthly accounting
  periods.
  
• QuickBooks has one set of data for the entire
  year.
  
• Peachtree is free to schools.
• QuickBooks is purchased by schools.
• Peachtree prepares students for enterprise
  software use.
  

Carol Yacht, Author
Accounting Pookela

February 19, 2006
12
QB Peachtree Microsoft Small Business
Accounting Software Comparison
Carol Yacht, Author
Accounting Pookela

February 19, 2006
13
QB Peachtree SBA Software Comparison
Carol Yacht, Author
Accounting Pookela

February 19, 2006
14
QB Peachtree SBA Software comparison
http//www.microsoft.com/office/accounting/prodinf
o/quickcompare.mspx
Carol Yacht, Author
Accounting Pookela

February 19, 2006
15
Peachtree QuickBooks Great Plains CD version
__________________________________________________
_____________________________________________
Carol Yacht, Author
Accounting Pookela

February 19, 2006
16
Web-Delivered Accounting Software
__________________________________________________
_____________________________________________
Carol Yacht, Author
Accounting Pookela

February 19, 2006
17
Using Spreadsheets in Accounting

• In a spreadsheet accounting course, students
  apply accounting procedures to Excel. Topics
  include
  
• Excel tutorial - learn basic spreadsheet
  elements, such as how to move around, enter data,
  save, format, use page setup and print.
  
• Accounting projects - use Excel templates to
  manipulate accounting data analyze spreadsheets.
  Reinforce financial and managerial accounting
  concepts.
• Model building - build spreadsheets from
  scratch. For example, payroll, depreciation,
  amortization schedules.
  
• Case problems - advanced model-building
  projects.
  

Carol Yacht, Author
Accounting Pookela

February 19, 2006
18
Excel balance sheet
__________________________________________________
_____________________________________________
Carol Yacht, Author
Accounting Pookela

February 19, 2006
19
Excel income statement
__________________________________________________
_____________________________________________
Carol Yacht, Author
Accounting Pookela

February 19, 2006
20
Questions?