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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
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: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.
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
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
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education