Purchase Solution

Accounting: Accounts Receivable Aging Report

Not what you're looking for?

Ask Custom Question

1. What is an account receivable aging report?

2. Why is an accounts receivable aging report needed for an audit?

3. What is an accounts receivable aging report used for in normal business company
operations?

4. What data will you need to prepare the report?

5. Where will you collect the data you need to prepare the report?

6. If the data are maintained on paper, how will you collect the necessary data?

7. If the data are in machine-readable form, how will you collect the data?

8. What will the report look like; i.e., how will you organize the data collected to create the information needed for auditing?

Purchase this Solution
Solution Summary

The solution provides a comprehensive explanation of the preparation and purpose of an accounts receivable aging report for both the company and for the outside auditors. A sample report has been prepared in Excel.

Solution Preview

Please see the attached file.

1. It is a listing of accounts receivable by customer which will agree in total to the amount in the accounts receivable general ledger account. It is arranged in columnar format with the first column being the total owed by the first customer. Normal columns are headed as Total, <30 days, 31-60 days, 61-90 days, and >91 days. The amounts in the total column are sorted by dating of the invoices from the customer. Sample below.

2. The purpose for reviewing the aging report in an ...

Purchase this Solution
Free BrainMass Quizzes
Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

View More Free Quizzes
Related BrainMass Solutions

  • Accounting problems for Bogus Company

    accounts on the basis of the aging schedule, show the T-account for the Allowance at December 31st, 2007, and show how "Bogus Company" will report Accounts Receivable on its December 31st, 2007 balance sheet.

  • Accounting for uncollectible accounts - allowance method

    Dec 31 Recorded uncollectible account expense based on the aging of accounts receivable, as follows: AGE OF ACCOUNTS Accounts Receivable 1-30 days 31-60 days 61-90 days over 90 days $165,000 $97,000

  • Accounting Computer Spreadsheet Problems

    Accounting 350 - Computer Spreadsheet Assignment #2 (Chapter 7) Dusty Horseman Corporation provides the following aging schedule of accounts receivable at December 31, 2011.

  • The Jones Beauty Supply Co.

    (B) Jones should report the allowance for uncollectible accounts on the balance sheet as a contra account.

  • Worcester Company Adjusting Entries

    e) Repeat the previous question assuming that Worcester uses the direct write-off method instead of the allowance method in accounting for uncollectible accounts receivable.

  • The Magrath Company Case Study

    How should Magrath account for and report the accounts receivable factored on April 1, 2011? Why is this accounting treatment apprpriate? 2.

  • Accounting - Theoretical and Practical Questions

    483851 Accounting Assistance 1. What is meant by the net realizable value for accounts receivable? 2. What is aging of accounts receivable, and how is it used to account for uncollectible accounts? 3.

  • Accounts receivable aging in a health care organizations

    in the accounts receivable process is named Dottie... she's been with the company for the past 43 years and Dottie probably doesn't utilize an aging report!

  • Computing Bad Debts Expense

    Total credit sales $2,200,000 Accounts receivable at December 31 825,000 Bad debts written off 33,000 (a) What amount of bad debts expense will Hermesch Company report if it uses the direct writeoff method of accounting for bad debts?

View More Related Solutions