ACC 411 Module Two Data Analytics Activity Template
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
411
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
1
Uploaded by MasterBat3510
ACC 411 Module Two Data Analytics Activity Template
Directions:
Complete this template by replacing the bracketed text with the relevant information.
Using the provided Data Visualization Screenshot and Data Analytics Cash Data Set, answer the following
questions for each criterion:
1.
Examine expenditures
to look for anomalies.
A.
Which day in March shows the largest amount of expenditure for the bank account ending in 4190?
[Add content here.]
2.
Examine transactions to
identify transaction types.
A.
What type of transactions are paid through the bank account ending in 3176?
[Add content here.]
3.
Examine the
interactive capability to analyze transaction amounts.
A.
What is the transaction amount for the commission occurred on March 4?
[Add content here]
4.
Examine
cash internal control
to analyze internal controls for cash expenditures.
A.
When looking at the bank account ending in 3176, what is the largest daily expenditure in March 2019?
[Add content here.] B.
Why do you think the expenditure is significantly larger compared to those on other days in March?
[Add content here]
5.
Review
auditing procedures
to analyze weekend transactions.
A.
What transactions do you observe over the weekends based on the total amount shown
in the visualization or bank accounts ending in 4190?
[Add content here]
B.
What might larger or smaller total amounts for the weekends indicate?
[Add content here]
Question Five Hint:
3/2, 3/3, 3/9, 3/10, 3/16, 3/17, 3/23, 3/24 and 3/30, 3/31 are all weekends.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
What are the step(s) when using the Sales with Payment customer workflow?
A. Create sales receipts deposited to the Undeposited Funds account > Create Bank Deposit
B. Create Sales Receipt deposited to the checking account
C. Create Bank Deposit
D. Create Invoice > Receive Payment deposited to the Undeposited Funds account > Create Bank Deposit
arrow_forward
Knowledge Check 01
Identify the type of activity by choosing the best answer for
each question.
Select each item listed below as being an identifying,
recording, or a communicating activity.
Items
Preparing and entering a list of checks issued.
Using a cash register to enter sales.
Entering a list of the sales invoices, including the prices and quantities, for the company's recordke
Interpreting information from financial reports.
Preparing financial statements for creditors.
arrow_forward
DATA FLOW DIAGRAM—CASH DISBURSEMENTSPrepare a data flow diagram that reflects the activities presented in the process outlined in Problem 4.SYSTEM FLOWCHART APUsing the format presented in Figure 2-4 in the text, develop a similar flowchart for the process of paying vendor accounts payable.The Process: Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice and a cash disbursement voucher are sent to the cash disbursement department, where a check is prepared and sent to the vendor. A copy of the check, the invoice, and the voucher are returned to the AP department and filed.
arrow_forward
DATA FLOW DIAGRAM-CASH DISBURSEMENTSPrepare a data flow diagram that reflects the activities presented in theprocess outlined in this Problem.
SYSTEM FLOWCHART APUsing the format presented in Figure 2-4 in the text, develop a similarflowchart for the process of paying vendor accounts payable.The Process: Vendors send invoices to the AP department where they are
reviewed and approved for payment. Once approved, the invoice anda cash disbursement voucher are sent to the cash disbursementdepartment, where a check is prepared and sent to the vendor. A copy ofthe check, the invoice, and the voucher are returned to theAP department and filed.
arrow_forward
Consider the following information items as you respond to the question:i. Customer master fileii. Journal entry to record the receipt of cashiii. Pre-numbered documentsiv. Schedule of accounts receivableAccounting information systems have five generic elements. Which of the following statements is most true?
A. "Pre-numbered documents" can be an example of three of the five elements.
B. "Schedule of accounts receivable" can be an example of all five elements.
C. Both "Pre-numbered documents" can be an example of three of the five elements and "Schedule of accounts receivable" can be an example of all five elements are true.
D. Neither "Pre-numbered documents" can be an example of three of the five elements nor "Schedule of accounts receivable" can be an example of all five elements is true.
arrow_forward
Question 11
What's used to validate the bank and credit card account balances on
a balance sheet?
Trial balance
Transaction Detail report filtered by account
Reconciliation reports
O Cash flow projection
Statement of Changes in Financial Position
arrow_forward
Subject: Accounting Information SystemQuestion: What would be the correct system flowchart for this given process: Accounts Payable and Cash Disbursement Process:Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice and a cash disbursement voucher are sent to the cash disbursement department, where a check is prepared and sent to the vendor. A copy of the check, the invoice, and the voucher are returned to the AP department and filed.
arrow_forward
QBO's Dashboard displays one or more of the following:
Multiple Choice
Bar and pie charts.
Line graphs.
Data metrics and visualization.
Current bank accounts.
All of these.
arrow_forward
Review the following transactions
Requirements
A (Click the icon to vicw the transactions )
1.
Prepare headings for a cash receipts journal. Jounalize the transactions that should be recorded in the cash
receipts journal
Total each column of the cash receipts journal
2.
Requirements 1 & 2. Prepare headings for a cash receipts journal. Journalize the transactions that should be recorded in the cash receipts journal. Total each column of the cash receipts journal. (If a box is not used in the journal leave the box empty, do not
select information and do not enter a zero. Abbreviations used Disc. = Discount, Acct = Accounts, Pay = Payable, Rec = Reccivable, Rev = Revenue, Oth = Other, COGS = Cost of Goods Sold, Mer = Merchandise, Inv. = Inventory, and Sis Dsc. Forf =
Sales Discounts Forteited.)
Cash Receipte Journal
Page
More info
PR
Feb. 1
Sold merchandise inventory on account, terms n/30, to Clara Co., $1,275. Cost of
SpOods, $010. Invoice no. 401.
Feb.
Feb. 6
Sold merchandise inventory…
arrow_forward
Simplifying the ABC System: TDABC
Golding Bank provided the following data about its resources and activities for its checking account process:
Time per Unit
Traditional Interest-Bearing
Resources
Activities
Driver
of Activity
Account
Account
Supervision
S70,000 Processing accounts
No. of accounts
0.20 hr.
2,000
1,000
Phone and supplies
90,000 Issuing statements
No. of statements
0.10 hr.
60,000
10,000
Salaries
275.000 Processing transactions
No. of transactions
0.05 hr.
160.000
120,000
Computer
25,000 Answering customer inquiries
No. of inquiries
0.15 hr.
1,500
1,500
Tatal
$460,000
At practical capacity, Golding uses 25,000 check processing hours.
Required:
1. Calculate the capacity cost rate answers to the nearest cent.
for the checking account process. Round your
18.4 V per hour
Calculate the activity rates for the four activities. Round your answers to the nearest cent.
Processing accounts
3.68 V per account
Issuing statements
1.84 V per statement
Processing transactions
0.92 V per…
arrow_forward
1. A special journal contains columns for Cash, Purchases Discounts and Accounts Payable. This journal is a
(an)
A. Invoice Register
B. Sales Journal
C. Cash Receipts Journal
D. Cash Disbursements Journal
2. Which of the following is true of a voucher system?
A. All major expenditures, including cash transactions for payment of rent and utilities expense,
would first be credited to Vouchers Payable before payment is made.
B. Transactions are first entered in the check register, and later, when payment is made, in the
voucher register.
C. The check register replaces the cash receipts journal.
D. The voucher register contains a debit column for Vouchers Payable
3. An accounting clerk would take first which of the following steps?
A. Post individual amounts to the subsidiary ledgers.
B. File source documents
C. Journalize the business transaction
D. Post to the general ledgers.
4. The book of original entry that will accommodate entries which cannot be appropriately recorded in any of
the…
arrow_forward
What specific information would you need to begin a cash receipts forecast?
arrow_forward
Which of the following provides the highest-quality evidence regarding the Valuation of recorded accounts payable?
Question 5 options:
Inspecting invoices for all cash disbursements during the year.
Performing analytical procedures.
Confirming balances with creditors and suppliers.
Recalculating the balance of accounts payable.
arrow_forward
When posting the column totals of a cash payments journal, a debit should be posted to
a.Unearned Revenue
b.Sales Discounts
c.Accounts Payable
d.Cash
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,
Related Questions
- What are the step(s) when using the Sales with Payment customer workflow? A. Create sales receipts deposited to the Undeposited Funds account > Create Bank Deposit B. Create Sales Receipt deposited to the checking account C. Create Bank Deposit D. Create Invoice > Receive Payment deposited to the Undeposited Funds account > Create Bank Depositarrow_forwardKnowledge Check 01 Identify the type of activity by choosing the best answer for each question. Select each item listed below as being an identifying, recording, or a communicating activity. Items Preparing and entering a list of checks issued. Using a cash register to enter sales. Entering a list of the sales invoices, including the prices and quantities, for the company's recordke Interpreting information from financial reports. Preparing financial statements for creditors.arrow_forwardDATA FLOW DIAGRAM—CASH DISBURSEMENTSPrepare a data flow diagram that reflects the activities presented in the process outlined in Problem 4.SYSTEM FLOWCHART APUsing the format presented in Figure 2-4 in the text, develop a similar flowchart for the process of paying vendor accounts payable.The Process: Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice and a cash disbursement voucher are sent to the cash disbursement department, where a check is prepared and sent to the vendor. A copy of the check, the invoice, and the voucher are returned to the AP department and filed.arrow_forward
- DATA FLOW DIAGRAM-CASH DISBURSEMENTSPrepare a data flow diagram that reflects the activities presented in theprocess outlined in this Problem. SYSTEM FLOWCHART APUsing the format presented in Figure 2-4 in the text, develop a similarflowchart for the process of paying vendor accounts payable.The Process: Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice anda cash disbursement voucher are sent to the cash disbursementdepartment, where a check is prepared and sent to the vendor. A copy ofthe check, the invoice, and the voucher are returned to theAP department and filed.arrow_forwardConsider the following information items as you respond to the question:i. Customer master fileii. Journal entry to record the receipt of cashiii. Pre-numbered documentsiv. Schedule of accounts receivableAccounting information systems have five generic elements. Which of the following statements is most true? A. "Pre-numbered documents" can be an example of three of the five elements. B. "Schedule of accounts receivable" can be an example of all five elements. C. Both "Pre-numbered documents" can be an example of three of the five elements and "Schedule of accounts receivable" can be an example of all five elements are true. D. Neither "Pre-numbered documents" can be an example of three of the five elements nor "Schedule of accounts receivable" can be an example of all five elements is true.arrow_forwardQuestion 11 What's used to validate the bank and credit card account balances on a balance sheet? Trial balance Transaction Detail report filtered by account Reconciliation reports O Cash flow projection Statement of Changes in Financial Positionarrow_forward
- Subject: Accounting Information SystemQuestion: What would be the correct system flowchart for this given process: Accounts Payable and Cash Disbursement Process:Vendors send invoices to the AP department where they are reviewed and approved for payment. Once approved, the invoice and a cash disbursement voucher are sent to the cash disbursement department, where a check is prepared and sent to the vendor. A copy of the check, the invoice, and the voucher are returned to the AP department and filed.arrow_forwardQBO's Dashboard displays one or more of the following: Multiple Choice Bar and pie charts. Line graphs. Data metrics and visualization. Current bank accounts. All of these.arrow_forwardReview the following transactions Requirements A (Click the icon to vicw the transactions ) 1. Prepare headings for a cash receipts journal. Jounalize the transactions that should be recorded in the cash receipts journal Total each column of the cash receipts journal 2. Requirements 1 & 2. Prepare headings for a cash receipts journal. Journalize the transactions that should be recorded in the cash receipts journal. Total each column of the cash receipts journal. (If a box is not used in the journal leave the box empty, do not select information and do not enter a zero. Abbreviations used Disc. = Discount, Acct = Accounts, Pay = Payable, Rec = Reccivable, Rev = Revenue, Oth = Other, COGS = Cost of Goods Sold, Mer = Merchandise, Inv. = Inventory, and Sis Dsc. Forf = Sales Discounts Forteited.) Cash Receipte Journal Page More info PR Feb. 1 Sold merchandise inventory on account, terms n/30, to Clara Co., $1,275. Cost of SpOods, $010. Invoice no. 401. Feb. Feb. 6 Sold merchandise inventory…arrow_forward
- Simplifying the ABC System: TDABC Golding Bank provided the following data about its resources and activities for its checking account process: Time per Unit Traditional Interest-Bearing Resources Activities Driver of Activity Account Account Supervision S70,000 Processing accounts No. of accounts 0.20 hr. 2,000 1,000 Phone and supplies 90,000 Issuing statements No. of statements 0.10 hr. 60,000 10,000 Salaries 275.000 Processing transactions No. of transactions 0.05 hr. 160.000 120,000 Computer 25,000 Answering customer inquiries No. of inquiries 0.15 hr. 1,500 1,500 Tatal $460,000 At practical capacity, Golding uses 25,000 check processing hours. Required: 1. Calculate the capacity cost rate answers to the nearest cent. for the checking account process. Round your 18.4 V per hour Calculate the activity rates for the four activities. Round your answers to the nearest cent. Processing accounts 3.68 V per account Issuing statements 1.84 V per statement Processing transactions 0.92 V per…arrow_forward1. A special journal contains columns for Cash, Purchases Discounts and Accounts Payable. This journal is a (an) A. Invoice Register B. Sales Journal C. Cash Receipts Journal D. Cash Disbursements Journal 2. Which of the following is true of a voucher system? A. All major expenditures, including cash transactions for payment of rent and utilities expense, would first be credited to Vouchers Payable before payment is made. B. Transactions are first entered in the check register, and later, when payment is made, in the voucher register. C. The check register replaces the cash receipts journal. D. The voucher register contains a debit column for Vouchers Payable 3. An accounting clerk would take first which of the following steps? A. Post individual amounts to the subsidiary ledgers. B. File source documents C. Journalize the business transaction D. Post to the general ledgers. 4. The book of original entry that will accommodate entries which cannot be appropriately recorded in any of the…arrow_forwardWhat specific information would you need to begin a cash receipts forecast?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage LearningAccounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- College Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,

Auditing: A Risk Based-Approach (MindTap Course L...
Accounting
ISBN:9781337619455
Author:Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:Cengage Learning

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
Publisher:Cengage Learning,