Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who manages the company Accounts Receivables. She was given the following information by the Finance Manager which was extracted from the debtor's ledger as at December 31, 2022. Category of Total value of Customers Sales To Customer $ Keith Green Karen White 240,000 390,000 380,000 Paul Gayle 346,000 June Hinds 180,0000 John Wayne Date of Sales December 16, 30 days 2021 December 10, 2021 November 15, 2022 June 26, 2022 August 25, 2022 Terms Percentage provision to be created 60 days 30 days 30 days 30 days Date of Last Payment on A/C January 15, 2022 February 14, 2022 December 20, 2022 October 24, 2022 September 24, 2022 Total Amount Paid to Date on Account S 90,500 180,000 170,000 295,000 235,000 The Accountant decided that she would age the debt outstanding in the following category and the percentage to be provided for bad debt in the amount stated beside each category accordingly. Aging Category
Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who manages the company Accounts Receivables. She was given the following information by the Finance Manager which was extracted from the debtor's ledger as at December 31, 2022. Category of Total value of Customers Sales To Customer $ Keith Green Karen White 240,000 390,000 380,000 Paul Gayle 346,000 June Hinds 180,0000 John Wayne Date of Sales December 16, 30 days 2021 December 10, 2021 November 15, 2022 June 26, 2022 August 25, 2022 Terms Percentage provision to be created 60 days 30 days 30 days 30 days Date of Last Payment on A/C January 15, 2022 February 14, 2022 December 20, 2022 October 24, 2022 September 24, 2022 Total Amount Paid to Date on Account S 90,500 180,000 170,000 295,000 235,000 The Accountant decided that she would age the debt outstanding in the following category and the percentage to be provided for bad debt in the amount stated beside each category accordingly. Aging Category
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question

Transcribed Image Text:30-60 Days
60-120 days
120-180 days
180-240 days
240-300 days
300-365 days
Over 365 days
Requirements:
5%
10%
150%
25%
40%
70%
100
a. With the aid of a spread sheet use the above information to create a debtor's aging
schedule with the additional columns if necessary.
b. Draft a sample of an appropriate letter which the accountant could sent to Karen
White to make payment on his accounts
Show the entries for the total amount of provisions for bad debt to be created.
C.

Transcribed Image Text:Question
Carlene Johnson is the Accountant in the Finance Department at Fairway Trading Limited who
manages the company Accounts Receivables. She was given the following information by the
Finance Manager which was extracted from the debtor's ledger as at December 31, 2022.
Category of Total value of
Customers
Sales
To Customer
$
Keith
Green
Karen White
June Hinds
John Wayne
180,0000
240,000
390,000
380,000
Paul Gayle 346,000
Date of Sales
December 16, 30 days
2021
December 10, 60 days
2021
November
15, 2022
30 days
June 26, 2022
30 days
30 days
August 25,
2022
Terms
Percentage provision to
be created
Date of Last
Payment on
A/C
January 15,
2022
February
14, 2022
December 20,
2022
October 24,
2022
September
24, 2022
Total
Amount
Paid to Date
on Account
S
90,500
180,000
170,000
295,000
235,000
The Accountant decided that she would age the debt outstanding in the following category and
the percentage to be provided for bad debt in the amount stated beside each category
accordingly.
Aging Category
HEART Collegs of
QUET INSTIT
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education