Explore BrainMass
Share

Explore BrainMass

    Accounting: Accounts Receivable Aging Report

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com October 9, 2019, 7:56 pm ad1c9bdddf
    https://brainmass.com/business/accounting/accounting-accounts-receivable-aging-report-133831

    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 ...

    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.

    $2.19