Background: As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance out

Background:

As a result of your preliminary findings, TechWear’s audit committee has asked that you postpone the issuance of your audit report until at least 80% of the accounts receivable balance outstanding at December 31, 2016, has been resolved (e.g., collected, written off or returned).

As of May 31, 2017, approximately 80% of the accounts receivable balance has been settled, so it is time to perform your procedures. The client has provided you with the data that you requested (in the module: ACT558_Module_06_P5_Data.xls Download ACT558_Module_06_P5_Data.xls). Procedures already have been performed by your team to ensure that the data you received is complete and accurate.

The data file includes two tabs — 2017 AR data and 2016 Unapplied cash.

2017 AR data tab

This data includes January through May 2017 cash received, write-offs and returns for 2016 account balances. The data fields are the same as what you received for 2016, with the exclusion of the invoice date. Additionally, the “Type” field includes transaction information for write offs (Write-off) and returns (Returns).

2016 Unapplied cash tab

This data includes the same fields as what you received for the 2016 accounts receivable data. This data represents the unapplied cash at the end of 2016 updated now to reflect a “type” of “CashReceipt” and also includes the transaction number, applied to transaction number and invoice date information.

Required:

Submit in one Word document with a cover page the answers to the following questions:

Prepare a December 31, 2016, runoff analysis as of May 31, 2017 (demonstrating how the December 31, 2016, balance has “run off,” meaning explain what happened to the beginning balance to get to the ending balance, between January 1 and May 31, 2017). Display this at the customer level with the ability to drill down to the transaction (invoice) level. Document your findings by completing the following table:Adjusted accounts receivable as of December 31, 2016$15,118,973.57RunoffNet returnsNet bad debt write-offsNet cash receiptsRemaining accounts receivable as of May 31, 2017

Calculate the 2017 cash receipts on the December 31, 2016, balance by month and provide a visualization of the trend.

Determine what amount of the December 31, 2016, accounts receivable balance you believe is collectible. Prepare a summary report as part of your Word document for the audit committee that includes your audit findings and audit adjustments (continue using the previous summary of audit findings document from question #1). Your Word document should be 2-3 pages in length, double-spaced, and take you less than 10 minutes to present as a guide. Use the previous template to present your audit adjustments for the accounts receivable balance, only as provided below (note that you can add or delete items from the table below if you have more/fewer findings and adjustments than listed). Also, use the visualizations that you have prepared to support your report.

Summary of audit findings Accounts receivableAs of December 31, 2016$18,114,802.50Audit finding/adjustment Audit finding/adjustment Audit finding/adjustment Audit-adjusted balance as of December 31, 2016

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Corporation: Walmart In this discussion, please reflect on changes in accounting principles and error corrections. How can you determine the difference between error correction and fraud? Add an exa

Corporation: Walmart In this discussion, please reflect on changes in accounting principles and error corrections. How can you determine the difference between error correction and fraud? Add an example from a public corporation. Include a copy of the corporation’s disclosure note and explain the effect the change or error correction

Company: Tesla In this discussion, find a cash flow statement for a large public corporation and analyze the statement. Share a copy of the statement and its disclosures. Explain why the cash flow st

Company: Tesla In this discussion, find a cash flow statement for a large public corporation and analyze the statement. Share a copy of the statement and its disclosures. Explain why the cash flow statement is required and useful. Consider using AI (Copilot or Chatgpt.com) to help with the analysis. Minimum:

Explain the difference between an error correction and a change in accounting principles and how each is accounted for. Scenario: Ray Solutions decided to make the following changes in its accounting

Explain the difference between an error correction and a change in accounting principles and how each is accounted for. Scenario: Ray Solutions decided to make the following changes in its accounting policies on January 1, 2016: Changed from the cash to the accrual basis of accounting for recognizing revenue on

In this discussion, please reflect on this weeks’ topics on changes in accounting principle, changes in reporting entity, and error correction. Explain how each of these are reported. Provide an examp

Differentiate between the three types of accounting changes. Apply retrospective and prospective approaches to accounting changes. Analyze the process of identifying and correcting accounting errors. In this discussion, please reflect on this weeks’ topics on changes in accounting principle, changes in reporting entity, and error correction. Explain how each of

Topic: Calculate basic and diluted earnings per share (EPS). In this discussion, please reflect on this weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topi

Topic: Calculate basic and diluted earnings per share (EPS). In this discussion, please reflect on this weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” o

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” of Fundamentals of Managerial Accounting Concepts. Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2.

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Researc

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret the notes disclosing the plans, reviewing the notes and explaining the post-retirement benefits that the corporations offer. This discussion supports CO-3 by

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies t

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. There are two ways for companies to borrow money. They can sign a note to borrow money from a bank or they can issue

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following: An entrepreneur is someone who has a passion and desire to organize and operate their own business. Using a business plan, an

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copil

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic, and what you learned after

KEONIA- UP TO 12/5/2025- *** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!* **** THIS ASSIGNMENT HAS 4

KEONIA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 4 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** FISCAL ACCOUNTABILITY **** PART

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: A virtual business is any kind of business that is run via the Internet. With no physical location

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts. Not only is the employee paying taxes, but the employer is also paying additional payroll taxes. Watch the following

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the fin

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the financial statements. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Minimum 250 words At

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, please complete the following: When multiple employee personalities come into one business unit, there is a possibility of conflict happening.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important part of business operations. Internal controls are used to protect assets. Both companies and individuals use internal controls. Companies

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important fo

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important for making informed decisions that balance financial performance with social and environmental responsibility. It helps managers align strategies with sustainability goals, drive innovation, and support