33:010:458 33:010:458 Accounting Information Accounting - - PowerPoint PPT Presentation

▶
33 010 458 33 010 458 accounting information accounting
SMART_READER_LITE
LIVE PREVIEW

33:010:458 33:010:458 Accounting Information Accounting - - PowerPoint PPT Presentation

Jan 05, 2023 113 likes •240 views

33:010:458 33:010:458 Accounting Information Accounting Information Systems Systems Dr. Peter R. Gillett Associate Professor Department of Accounting, Business Ethics and Information Systems Rutgers Business SchoolNewark and New

slide-1
SLIDE 1

33:010:458 33:010:458 Accounting Information Accounting Information Systems Systems

  • Dr. Peter R. Gillett

Associate Professor Department of Accounting, Business Ethics and Information Systems Rutgers Business School–Newark and New Brunswick

slide-2
SLIDE 2

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

2

A.I.S. Class 22: Outline A.I.S. Class 22: Outline

Learning Objectives for Chapter 10 Chapter 10 Quiz Learning Objectives for Chapter 11 Chapter 11 Quiz Group Work for Chapters 10 & 11 Combo Boxes ACCESS Features Ash Accounting Reports for Financing Cycle

slide-3
SLIDE 3

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

3

Learning Objectives for Chapter 10 Learning Objectives for Chapter 10

In this chapter you will learn how to :

* Create a model of the human resource business process * Create a Microsoft Access database based on the business

process model

* Create controls to enforce business rules * Create and maintain employee records * Create and maintain records of time worked * Calculate gross and net pay * Record payments to employees * Produce information for financial statements * Produce information for internal purposes

slide-4
SLIDE 4

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

4

Chapter 10 Quiz Chapter 10 Quiz

?

slide-5
SLIDE 5

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

5

Learning Objectives for Chapter 11 Learning Objectives for Chapter 11

In this chapter you will learn how to :

* Create a model of the financing business process * Create a Microsoft Access database based on the business

process model

* Create controls to enforce business rules * Create and maintain owner/investor and creditor records * Create and maintain cash records * Record loan agreements * Record debt issue proceeds received from creditors * Record debt payments of principal and interest to creditors * Record stock subscriptions * Record stock issue proceeds received from owners/investors * Record dividend declarations * Record dividends paid to owners/investors * Produce information for financial statements * Produce information for internal purposes

slide-6
SLIDE 6

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

6

Chapter 11 Quiz Chapter 11 Quiz

?

slide-7
SLIDE 7

Accounting Information Systems

Group Work Chapters 10 & 11 Group Work Chapters 10 & 11

Discuss Chapters 10 & 11 Identify any significant new features or functions

(other than just related to these being different cycles)

Identify what is different about the authors’

Pipefitters Supply Company implementations, as compared to our designs for Ash Accounting

What reports would you expect to produce for

the Financing cycle?

November 16, 2009

  • Dr. Peter R. Gillett

7

slide-8
SLIDE 8

Accounting Information Systems

Combo Boxes Combo Boxes

The advantages of using a Combo Box include:

* Data entry clerks do not need to memorize lists of

employee type numbers

* Only valid type numbers can be entered in the

Employee table

* It reduces storage needs in the Employee table by

storing Type numbers instead of descriptions

* New Types can be added easily to the Employee type

table, and they will automatically appear in the Employee Information form Combo Box

November 16, 2009

  • Dr. Peter R. Gillett

8

slide-9
SLIDE 9

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

9

ACCESS Features ACCESS Features

IIF() FICA: Int([GrossPay] * 0.062 * 100) / 100

* 2009 FICA is 6.2% of salary up to $106,800 * 2009 Medicare is 1.45% of salary with no limit

slide-10
SLIDE 10

Accounting Information Systems

November 16, 2009

  • Dr. Peter R. Gillett

10

Ash Accounting Ash Accounting How do we compute and store payroll

details?

* Use Queries to compute pay & deductions * Use Append Query to store details on link

tables, with nested queries to do the main calculations

* Use Form with Button and Macro to initiate

payroll computations

slide-11
SLIDE 11

Accounting Information Systems

Ash Accounting Ash Accounting

The authors have developed a scheme for

having a single Cash Disbursements event, making use of Cash Disbursements Types

The authors compute (in Excel) and store details

  • f the Repayment schedule – whereas we

would probably plan to store the data on which it is based (the type of calculation, term of loan, interest rate, etc.) and COMPUTE the repayments as they become due

November 16, 2009

  • Dr. Peter R. Gillett

11

slide-12
SLIDE 12

Accounting Information Systems

Financing Cycle Reports Financing Cycle Reports

Loans

* Loan Terms * Loans Received * Repayments * Interest Expense * Loan Repayment Schedule * Loan Maturities Schedule * Checks * Short-term Loan Liabilities * Long-term Loan Liabilities

Stocks

?

November 16, 2009

  • Dr. Peter R. Gillett

12