CLOUD 9Jo Wadley, partnerJosh Thomas and Suzie Pickering, audit seniorsMark Batten, IT audit managerYou are a graduate working for W&S Partners, a Canadian accounting firm with offices located in each of Canada’s major cities. W&S Partners has just been awarded the December 31, 2023, audit for Cloud 9 Ltd. (Cloud 9). The audit team assigned to this client is:Sharon Gallagher, audit managerIan Harper and you, graduates?mage transcription textONBank CLOUD 9 LTD. Online BankingEFT payments for December 3, 2023Passcode accepted: Carla J… Show more… Show moreImage transcription textCLOUD 9 LTD. System 01 version 1.9Daily Reconciliation of AR Posting toBank Report as at Decem… Show more… Show moreImage transcription textCLOUD 9 LTD. System 01 version 1.9Daily Reconciliation of AR Posting toBank Report as at Novem… Show more… Show moreImage transcription textONBank CLOUD 9 LTD. Online BankingEFT payments for October 23, 2023Passcode accepted: Carla… Show more… Show moreImage transcription textONBank CLOUD 9 LTD. Online BankingEFT payments for October 8, 2023Passcode accepted: Carla J… Show more… Show moreImage transcription textCLOUD 9 LTD. System 01 version 1.9Daily Reconciliation of AR Posting toBank Report as at Octobe… Show more… Show moreImage transcription textCLOUD 9 LTD. System 01 version 1.9 DailyReconciliation of AR Posting to Bank Report asat September 19, 2023 Description… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: FootLocker – Pitt St. Mall 435 Pitt St., Shop 4London, ON 135947 Swift Purchas… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: Wide FtoadSpecialty Retailer 74 Shore Highway 135215Fredericton, NB Swift Purchase or… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: CrossCountry Sports 769 First Avenue 134104 St.John’s, NL Swift Purchase order re… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: MeyerSports – Burnaby 328 Elizabeth Ave Burnaby, BC134063 Swift Purchase order refer… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: RebelSports – World Square 680 George Street, Shop12 Barrie, ON 133410 Swift Purcha… Show more… Show moreImage transcription textCLOUD 9 LTD. SALES INVOICE TO: David Jones23 Main St, Shop 43 Toronto, ON 132811 SwiftPurchase order reference: P00132… Show more… Show morePART 1 Control Testing & Data AnalyticsSharon Gallagher and Josh Thomas have assessed the internal controls at Cloud 9 as being effective at an entity level. This means that, at a high level, the company demonstrates an environment where potential material misstatements are prevented or detected.RequiredYou have been assigned the task of documenting the understanding of the process for recording sales, trade receivables, and cash receipt transactions for wholesale customers. In your absence, Josh met with the Cloud 9 financial controller, Carla Johnson, and received permission to tape the interview, which is provided as a transcript (see?ppendix A). Using this interview transcript and other information presented in the case, you are asked to:Prepare a flowchart or narrative documenting your understanding of the sales to cash receipts process for wholesale sales.Identify any follow-up questions you would like to ask the client if aspects of the process are not adequately explained. You could address such questions to Carla Johnson or any other employee you deem appropriate.Draw up a worksheet using the following format.?se the column “Potential Material Misstatement” and identify the potential material misstatements that could occur in the sales to cash receipts process. Use as many rows as you need. Identify the potential material misstatements that could occur in the sales to cash receipts process for wholesale sales. Using the material misstatements identified, complete the third column “Assertions” to identify the financial statement assertion that is affected for each potential material misstatement. Lastly, in column four, include the transaction-level internal controls Cloud 9 has implemented to prevent and/or detect potential errors.During discussions with management, Josh asked how often the product prices are changed. Carla Johnson, the Financial Controller, responded that they didn’t change that often. Describe a data analytics technique that could be used to corroborate Carla’s statement using the five-step approach. Be specific in identifying a logical source that Josh might be able to obtain data from in order to better understand pricing fluctuations.Appendix AAppendix A: Cloud 9 Ltd.W&S Partners is a Canadian accounting firm with offices located in each of the major cities. W&S Partners has just won the December 31, 2023, statutory audit work for Cloud 9 Ltd. The audit team assigned to the client is Partner, Jo Wadley; Audit Manager, Sharon Gallagher; Audit Seniors, Josh Thomas and Suzie Pickering; IT Audit Manager, Mark Batten; and Audit Juniors, including Ian Harper, Weijing Fei, and you.Prior-year audits were conducted by Ellis & Associates. As part of the change of auditors process, Jo Wadley met with R. J. Ellis (Managing Partner, Ellis & Associates) to discuss acceptance of Cloud 9 Ltd. as a client and to inquire about access to Ellis & Associates’ work papers. In the discussion, R. J. Ellis stated that there were no issues that W&S Partners should be aware of before accepting the client or commencing the work.Cloud 9 Ltd. Company BackgroundOriginally founded in 2000 by Ron McLellan, the Toronto-based company was a manufacturer and retailer of customized basketball shoes. In 2013, Cloud 9 Inc. (a publicly listed Canadian company) purchased the original company from Ron McLellan and renamed it Cloud 9 Ltd. As part of the sale agreement, Ron McLellan was appointed to the Cloud 9 Ltd. board of directors.The parent company, Cloud 9 Inc., has wholly owned subsidiaries in the United Kingdom, Germany, United States, China, and Brazil, and has built a reputation around the fact that its shoes are comfortable and durable. The company promotes itself using its now well-known tagline, “Our shoes are so comfortable, it’s like walking on Cloud 9.” Currently, Cloud 9 Ltd. is primarily a wholesaler of athletic shoes to its main customers: David Jones, Meyer Sports, Foot Locker, and Rebel Sports.Cloud 9 Ltd. receives the majority of its inventory from the production plant in China, with the remainder coming from the United States. All inventory is purchased free on board (FOB) shipping point, which means Cloud 9 Ltd. takes ownership of the products once the international courier accepts the goods for delivery. The inventory is sent to the main warehouse in Richmond, B.C., which is linked to retailers through an electronic inventory system. When retail inventory levels get low, the company ensures that deliveries are made using its own transport trucks, thus ensuring control throughout the entire process.In February 2021, Cloud 9 Ltd. launched its new product line, which included the Heavenly 456 walking shoe. Advertising campaigns and media coverage have been very successful and sales for this style of shoe have steadily increased. For Cloud 9 Ltd., the Heavenly 456 now makes up 20 percent of total sales.A specific marketing campaign was initiated in 2023 to promote and build the Cloud 9 brand in Canada. The Canadian company was granted permission from its parent entity to sponsor a new soccer team, the Thompson Thunders, for the 2023 season. Under this sponsorship agreement, Cloud 9 Ltd. is to provide all the athletic footwear for the team, and have sole merchandising rights. The agreement also includes general advertising rights at the stadium.In a separate contractual arrangement, Cloud 9 Ltd. has signed Kevin McDonald, the captain of the Thompson Thunders, as spokesperson for the brand. This arrangement allows Cloud 9 Ltd. to use Kevin’s image to promote and build the brand in Canada.To further establish the brand, the first Cloud 9 retail store was opened in Toronto on June 1, 2023. The store operates on a just-in-time inventory system linked with the main?arehouse in Richmond. However, the management team reports that there have been a few hiccups in determining ideal inventory quantities for the store to allow optimum availability of merchandise to the customers. There have also been some thefts of merchandise from the store and in order to reduce inventory loss by theft, the company has installed closed-circuit television cameras.PersonnelCloud 9 Ltd. has 52 full-time employees. In the retail store, the company employs part-time staff, with casual employees enhancing staff levels in the busier retail period.To administer the company’s finances, Cloud 9 Ltd. employs Finance Director David Collier, Financial Controller Carla Johnson, and Business Systems Manager Justin Reeves. These three employees are entitled to participate in the employee share purchase plan and receive stock options in Cloud 9 Inc. if revenue targets are met.Financial InformationResponding to pressure from its parent company, Cloud 9 Ltd. set a goal of increasing its revenue by 3 percent for the 2023 fiscal year. One of the critical success factors for the company achieving this 3-percent increase is to grow its share of the North American footwear market. However, with the new store opening and the subsequent increase in costs, as well as the costs related to the sponsorship deals, the management team is projecting a loss for the year.In addition, to build customer loyalty and promote sales in the retail store, Cloud 9 Ltd. introduced a loyalty program whereby customers earn one point for every $10 that they spend. Customers can then redeem points by going online to receive coupons that can be exchanged for merchandise in the store.On October 1, 2022, the company took out an additional loan of $2 million with Ontario Bank to help fund the store costs and to purchase additional delivery trucks and vans. This loan is repayable over five years. The company’s other debt relates to loans issued five years ago from a company that is majority-owned by one of the directors.All inventory is purchased in U.S. dollars, which the company translates into Canadian dollars. The company provides a 12-month warranty on all footwear. Historical claims have been 2 percent of total sales.The prior-year income statement and balance sheet are included below.Following are the December 2023 trial balance for Cloud 9 Ltd., a draft statement of income for 2023, a transcript of a meeting with Carla Johnson (Cloud 9 Ltd. financial controller), and sales and cash control testing support.TRANSCRIPT OF MEETING WITH CARLA JOHNSONPresent: Carla Johnson, Financial Controller, Cloud 9 Ltd. Josh Thomas, Audit Senior, W&S PartnersJT:Thanks for seeing me, Carla.CJ:You’re welcome, Josh. What can I do for you?JT:I need to ask you some questions about Cloud 9’s process for recording wholesale revenue transactions, including the trade receivables and cash receipts aspects. After I understand the process, I’ll need to select a sample transaction to confirm my understanding of the process as you have explained.CJ:Well, I can tell you what should be happening, but you may want to go and speak to the sales manager or warehouse managers to confirm that they do what the company policy and procedures say.JT:Good point, I’ll make appointments to see them. Thanks. So let’s start at the beginning?ow does a sales transaction get initiated?CJ:We’ve got a pretty complex inventory management software system called Swift. It was designed by some of our tech guys in the United States. It tracks and does everything!JT:Sounds impressive!CJ:Anyway, the customers?et’s say the Sport Mart store in Toronto?omplete a purchase order online through a site that is linked to Swift.JT:How do the customers decide the quantity and know the price?CJ:Swift is linked (don’t ask me how) and sends an alert when the inventory balance of our products gets below the predetermined limit they set with us. They can select the quantity based on their needs, but the prices are set in the system. They get sent price lists from the sales manager so they know the current prices.JT:How often are prices changed?CJ:Depends on the market, really. They don’t change too frequently.JT:What if you don’t have the products?CJ:The system doesn’t allow them to place an order greater than our current inventory levels. If they need more, they need to fill out a separate request form that gets emailed to our warehouse manager so she can place the order with China.JT:OK, so they complete a purchase order. Then what?CJ:The submitted purchase order goes through a credit check and then becomes a sales order. That’s all done behind the scenes in the system. We really don’t see anything on our side until the sales order stage.JT:Guess that saves a lot of time and trees!CJ:Yeah, there’s so much that we rely on the system to do for us, it’s scary. If we were hit by an electrical storm, we’d be in trouble.JT:What happens to the sales orders?ow do they get filled?CJ:Every day, the warehouse manager downloads the outstanding sales orders to these little hand-held computer/scanner thingies. It’s very Star Trek. Warehouse personnel use these to select the items off the shelves onto pallets. The pallets are taken to a staging area where each product is then scanned. This establishes the shipping document in Swift, which then gets printed for the delivery.JT:Are the shipping documents approved before the goods go out the door? How do you know that what got sent is what was ordered?CJ:Swift matches the quantities and products on the shipping document to the sales order. Once they match, the approval box is activated and the shipping supervisor can enter his pass code. This officially approves the shipping document and it gets printed.JT:How many orders do you fill in a day? It sounds like a lot for one person to do.CJ:We probably complete about 50 orders a day. Shoes aren’t perishable items, you know, so it’s not like we are sending products to every store, every day. We’re trying out the “pit crew” concept, where there’s two shipping supervisors with about four to five warehouse employees in their crew team. So they are in the staging area with them and do it right there with the hand-held devices. They like to have little contests to see who can do it the fastest. You should go down there; it’s quite a lively group. David encourages it and it’s been great for productivity and morale.JT:Sounds like a great working environment. Better than being stuck in a broom closet sifting through invoices!CJ:Ah, the life of an auditor. I remember the good old days …JT:And the goods are sent out on your own trucks?CJ:That’s right. We’ve bought our own trucks and vans rather than relying on couriers. The drivers pick up their loads in the morning and bring back anything undelivered. Because shoes are an easy product to off-load, we have to be careful about theft. So nothing can be left in the back of a truck at the end of the day. It comes back here and gets locked up in the shipping cage until it can be delivered again.JT:Why would goods be undelivered?CJ:Sometimes the drivers get behind or the store is closed unexpectedly. So there are occasions when all the goods won’t get delivered in the day.JT:OK, so once the goods are delivered to the customer, how do you bill them?CJ:The drivers have the customers sign for the goods and then give us the signed copy. We go into the billing system and pull up the draft invoice that was generated when the shipping document was approved. We match the quantities in the invoice against the shipping document and confirm customer sign-off. This way, we only bill for those goods that were actually received by the customer. At 4 p.m., we do a batch run for the day. The copy is stapled to the signed shipping document and put on file. The running of the batch run posts the invoices to the sales journal and accounts receivable subledger.JT:Does finance ever go back to the sales order?CJ:No. Since a shipping document can’t get generated unless it agrees to the sales order, we don’t go back that far into the process. Why, do you think we have to?JT:I wouldn’t say so at this stage. But you’d have to be sure to have some tight controls around Swift, given that it seems to do everything.CJ:Like I said, it does everything.JT:What is the cash receipts process?CJ:We get most payments via EFT, so my AR clerk downloads the previous day’s receipts from online banking. She then goes into the subledger to post the receipts against the customer accounts. When she’s finished posting each entry, she runs a batch report of all postings and reconciles it back to the bank statement. I review that reconciliation and sign off.JT:Are bank reconciliations done in a timely manner?CJ:I do bank recs each month for the operating and savings accounts. David reviews and approves them. Keep in mind what I just explained is for the wholesale transactions. We have separate procedures for the store regarding daily cash balance reconciliations to the deposits in the operating bank account.JT:Yes, our graduate will be handling the store side of the sales to cash receipts process. They will probably come and talk to you in a day or two. Well, I think that should do it for now. I may have some follow-up questions for you as I start getting my head around all of this.CJ:Door’s always open.JT:Thanks for your time.BusinessAccountingACCT MISC
Get a plagiarism-free order today we guarantee confidentiality and a professional paper and we will meet the deadline.