Accounting Information Systems 4

--looks for inconsistencies, eg. proper nouns spelled two different ways. (Always use spell-check to help locate such inconsistencies.)

SMW’s current accounting information system is a cutting edge relational database system through Microsoft Access with internal controls set to adequately prevent and detect errors and fraud. This relational database system tracks sales orders, shipments, accounts receivable, cash receipts, purchases, accounts payable, cash disbursements, inventory levels and other relevant accounting information. The system’s output is compliant with Generally Accepted Accounting Principles (GAAP). The database processes currently in use at SMW are described below.

* Documents used: customer order, sales order, shipping document, sales invoice, sales journal, remittance advice, bank deposit list, cash receipts jornal, credit memo, sales return and allowance journal, uncollectable account authorization form, a/r master file, a/r trail balance, monthly statement

This control is directly related to the accuracy transaction-related audit objective for sales. The auditor might test the effectiveness of this control by examining a sample of duplicate sales invoices for the clerk’s initials indicating that the unit selling price was verified.

Verify Tests: 0 data validity errors detected in Jaysberg_Auth_Prices, Jaysberg_Sales_Returns, and Jaysberg_Sales_Trans, and the counts were respectively: 101, 55, and 383.

1.3 Before going to the next account, let’s analyze the Accounts Payable account closer. This account is special. Look at the Control data tab

*During the interaction, CAE assured the customer that a technician will be fixing her services tomorrow (8/06/2015) between 10:00am to 12:00PM however, upon checking on the account history and based on the order number(10009710563520320001) and the CRTicket(CR491045371) generated by the CAE, a truck roll was scheduled on 08/07/2015 between 10:00am to 12:00PM. CAE mislead the customer by providing incorrect information.

Validated the client entered data from customer side utilizing Java script. Alarmed the client when entered incorrective information.

1. Obtain an aged trial balance of individual customer accounts. Recalculate the total and trace to the general ledger control account.

You decide that you will address Smackey Dog Food, Inc.’s accounts receivables through confirmations. Discuss the various

Bookkeeper 's Hiring Test [11]PAYROLL BANK11 - PHE 003 If employee Linda is paid $10 an hour and recorded the following hours for the workweek, what are her gross wages for the workweek under federal law? Hours worked 8 4 8 6 4 4 5

In the set of all past due accounts, let the event A mean the account is between 31 and 60 days past due and the event B mean the account is that of a new customer. The union of A and B is

c. Trace the check number and amount of outstanding items – Occurrence, Completeness, & Accuracy (AU-C 315.A114 a.i-iii)

Century National Bank has offices in several cities in the Midwest and the southeastern part of the United States. Mr. Dan Selig, president and CEO, would like to know the characteristics of his checking account customer. To better understand the customers, Mr. Selig asked Ms. Wendy Lamberg, director of planning, to select a sample of customers and prepare a report. To begin, she has appointed a team from her staff and the team has selected a random sample of 60 customers. All the information gathered is tabulated in the table below:

Management control system are accounting tools that gather information and use it to evaluate the performance of different organizational resources like human, physical, financial and also the organization as a whole considering the organizational strategies. In other words, the managemant control sytstem is aligned with the organization 's performance. Management control system can be formal or informal. However, organization uses different accounting tool to capture their performance. The balance scoredboard is deemed to be a good management control tool when use effectively with a thought out transfer price system. Transfer pricing can be defined as the setting of the price for goods and services sold between controlled (or related)