You have been asked to analyze the Cash Disbursements spreadsheet provided using IDEA.
Week 5 Cash_Disbursemt.xlsx
The company policy is that checks are only processed on the 15th and 30th of each month (Hint: Using IDEA modify/append the file and use @day formula for the 15th or 30th then set the criteria) and payments over $10,000 need to be authorized by the CFO, Albert Booth.
Based on what you found during your analysis using IDEA, discuss one of the controls you feel are needed for cash disbursements at this company. Design a spreadsheet (using advanced features of Excel) or a flowchart (using Lucidchart) demonstrating the implementation of the control you feel is needed based on your analysis–upload a copy. Be sure to identify a specific way to improve the cash disbursements process based on what you discovered.