BSBFIM501_Task 4
docx
keyboard_arrow_up
School
Federation University *
*We aren’t endorsed by this school
Course
511
Subject
Accounting
Date
Nov 24, 2024
Type
docx
Pages
3
Uploaded by varunarora2886
BSBFIM501
Assessment Task 4
Debtor management project
Aged Debtors Analysis Report
Client 1 cross the 90 days for the pending payment
$4,356.00
Client 2cross the 120+days for the pending payment
$5,214.00
Client 3cross the 60 days for the pending payment
$3,781.00
Company's terms of payment are within 10 days of invoice. All debtors are currently lying
beyond the limit placed by company in terms of days.
Company is currently not able to strictly follow their age debtor policy as debtors are currently
lying beyond 10 days. Since debtors are aged now thus company has to be strict to recovery of
those debtors
I intend to include a review of the company's aged debtors. As per the aged Debtor Report, it has
3 consumers with outstanding payments. The provisions agreed upon for purchases by the
company and consumers shall be applicable to the invoice within 14 days. However, these
consumers could not pay off their loans for longer than 14 days. User 1 has a $4,356 loan that
has not been settled for 90 days. Client 2 has a $2714 loan that has not been repaid for the last
120 days. For the outstanding bill, $37811 Client 3 passes the 60 days.
This indicates that debt management by the company was unsuccessful. In comparison, the
corporation has also struggled to collect the company's potential profits.
The following are suggestions for methods for how debtors should be treated by the company.
These techniques will provide the organization with investigations, tests, and precautions that
may be implemented in the future.
1. Credit policy and trading conditions-Credit agreements need to be periodically reviewed to
ensure that they are appropriate for the risk profile of organisations. The loan policy should be
conveyed in writing clearly to all debtors and understood by all employees. Trade terms such as
prepayments, down rates, terms and any early termination discounts should be reported to
include such items as.
2. Invoicing and estimates-All quotes, forecasts, invoices, contracts, agreements, purchase orders
and related documentation should be in compliance with the provisions of the trade and credit
policies and, in order to prevent any confusion, specifics of the essence of the work/products
supplied, the numbers, the timing and the arrangement and manner of payment should be
conveyed clearly. In paper, ensuring the acceptance of terms is notified. And, of course, as early
and as often as practicable, invoice,
3. Accounts receivable procedures-Workers can specifically set out and understand the
mechanism for collections, articulating the timings of different messages (letters / emails / phone
calls). The reimbursement of the undisputed sum should often be pursued in the case of debtor
disputes in order to preserve cash flows.
4. Credit reviews to monitor and mitigate risks-Credit checks on new and current customers
should be carried out on a routine basis in order to recognize issues that can impact credit limits.
Credit data products such as ledger monitoring and notifications are readily available to monitor
deterioration in creditworthiness and mitigate credit danger.
5. Examination structure and ledger tracking-Scheduled credit limit checks are essential to
ensure that settings are acceptable for individual debtors. In order to detect adverse changes in
the debtor ledger and ensure prompt action, it is necessary to periodically document the
outstanding days (DSO).
2. Send an Email to the CEO
To:
ceo@gmail.com
Date: 04-12-2023 & 10:00am
Subject:- Aged Debtor Report
Dear Sir/Madame,
As per the aged debtor report we have decided to implement some strategies to improve the aged
debtor report. Please find the below attachment for more information.
These recommendations are for your review and approval. Should you have any queries, don’t
hesitate to contact me.
Kindly Regards
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Question 9
Concord Company provides for bad debt expense at the rate of 3% of accounts receivable. The following data are available for 2018:
Allowance for doubtful accounts, 1/1/18 (Cr.)
$ 11300
Accounts written off as uncollectible during 2018
10400
Ending accounts receivable
1204000
The Allowance for Doubtful Accounts balance at December 31, 2018, should be
$37020.
$900.
$36120.
$35220.
arrow_forward
What is the amount of write offs during Year 2 based on the following financial information?
Balance Sheet Excerpts As At Year
Year 2
Year 1
End(000s)
Gross Accts Receivable
Allowance for Doubtful Accounts
Net Accts Receivable
Provision for Bad Debt
O $15
$20
$37
$52
$456
$20
$437
$25
$321
$32
$294
$40
arrow_forward
Problem 84 (LAA)
Summa Company revealed the following account balances
on December 31, 2020
Accota payable
Accounta receivable, net of allowance for doubtful
accounts PS0.000
Accrued taxes
Aecrued interest receivable
Autherined sbare capital, 60,000 aharea. P100 par
Building, net ofaccumulated depreciation of P500,000 3,000.000
Cash on hand
Cash in bank
Bond sinking fund
Furniture and equipment, net ofaccumulated
depreciation of P900,000
Iaventory
Investment property
Land
Deferred tax liability
Bonds payable due June 30, 2021
Notes payable
Notes reoeivable
Patent
Ocher accrued liabilities
Prepaid expenses
Share premium
Retained earninge appropristed for contingencies
Retained eantings
Share ubecription receivable
Subscribed share capital E000 shares
Unianoed share capital
1000,000
50.000
30,000
5,000.000
50.000
650.000
2000.000
1,500,000
1,200,000
700.000
1,000,000
650.000
2.000.000
850.000
200,000
370,000
150,000
100,000
300,000
200,000
2.700,000
500,000
L000,000
2.000,000
Required:…
arrow_forward
question 6 part 4 and 5
arrow_forward
Calculate the total estimated uncollectibles based on the below information.
Number of Days Outstanding
Total
0–30
31–60
61–90
91–120
Over 120
Accounts receivable
$400,900
$227,000
$95,800
$38,700
$22,900
$16,500
% uncollectible
1%
4%
5%
8%
10%
Estimated uncollectibles
$enter the total estimated bad debts amount in dollars
$enter the estimated bad debts amount in dollars
$enter the estimated bad debts amount in dollars
$enter the estimated bad debts amount in dollars
$enter the estimated bad debts amount in dollars
$enter the estimated bad debts amount in dollars
arrow_forward
Problem 5: The following selected accounts were taken from the trial balance of
Romen Company as December 31, 2020:
750,000
150,000
450,000
2,700,000
525,000
3,900,000
30,000
150,000
240,000
900,000
1,800,000
4,460,000
222,000
393,600
150,000
2,787,500
Accounts receivable
Installment receivable – 2018
Installment receivable - 2019
Installment receivable – 2020
Beginning inventory
Purchases
Freight-in
Repossessed merchandise @ NRV
Repossession loss
Cash sales
Credit sales
Installment sales
Deferred gross profit – 2018
Deferred gross profit – 2019
Operating expenses
Cost of installment sales
Additional information:
a. Gross profit rate for 2018 and 2019 installment sales were 30% and
32%, respectively.
b. The entry for repossessed goods was:
Repossessed Merchandise
Repossession loss
Installment Receivable – 2018
150,000
240,000
180,000
210,000
c. Merchandise on hand at the end of 2020 (new and repossessed) was 282,000.
Installment Received - 2019
Required: Compute for the following :
1.…
arrow_forward
View Policies
Current Attempt in Progress
Vaughn Manufacturing has outstanding accounts receivable totaling $ 6.47 million as of December 31 and sales on credit during the
year of $ 24.5 million. There is also a credit balance of $ 11500 in the allowance for doubtful accounts. If the company estimates that
6% of its outstanding receivables will be uncollectible, what will be the amount of bad debt expense recognized for the year?
O $388200.
O $ 399700.
O $ 376700.
O $1470000.
Save for Later
Attempts: 0 of 1 used
Submit Answer
arrow_forward
P7-1
arrow_forward
INTERMEDIATE ACCOUNTING 2
DEBT RESTRUCTURE
arrow_forward
Question 8
At January 1, 2025, XYZ Company had an allowance for doubtful
accounts with a $39,300 credit balance. XYZ Company reported
the following information for 2025:
4
Sales revenue
Cash collections from customers
Write-offs of uncollectible accounts
Recoveries of previously written-off accounts
Bad debt expense
In order to estimate the bad debt expense, XYZ Company prepared
the following aging schedule at December 31, 2025:
not past due
1-30 days past due
31-60 days past due
61-90 days past due
over 90 days past due
total accounts receivable
$392,800
$307,500
?
Accounts Receivable % Uncollectible
3%
7%
11%
24%
46%
$181,000
$ 36,000
$ 42,000
$ 14,600
$ 31,090
$ 21,000
$ 13,000
$293,000
Calculate XYZ Company's accounts receivable balance at
January 1, 2025.
arrow_forward
QS 9-3 (Algo) Recovering a bad debt LO P1
Solstice Company determines on October 1 that it cannot collect $55,000 of its accounts receivable from its customer, P. Moore. It uses the direct write-off method to record this loss as of October 1. On October 30, P. Moore unexpectedly pays his account in full to Solstice Company.Record Solstice’s entries for recovery of this bad debt.
arrow_forward
2021 Dec 31 Recorded Bad Debt Expense of $15,500
2022 Apr 1 Wrote off J.Salazar account of $3500 as uncollectible
2022 June 4 Wrote off T.Savvy account of $4000 as uncollectible
2022 August 10 Recovered $1500 from T. Savvy
Required
Journalize the transactions using the income statement approach to estimate bad debts.
Journalize how Sloan Company would record the T Savvy bad debt situation if the direct write-off method had been used. Assume the bad debt was recovered on August 10, 2023.
arrow_forward
Please answer question correctly
arrow_forward
Accounting question: If you are doing a balance sheet with notes payable of 96,600. Assuming 13,600 of the note payable will be paid the following year. Where are how do you enter it.
Long Term Liability?
arrow_forward
Problem 7:
Purple Company showed the following balances on December 31, 2019:
2,000,000
(60,000)
Accounts receivable
Allowance for doubtful accounts
The following transactions transpired during the year 2020:
a. On May 1, received a P300,000, six month, 12% interest bearing note from MN, a customer, in
settlement of account.
b. On June 30, Purple Company factored P400,000, of its accounts receivable to a finance company. The
finance company charged a factoring fee of 5% of the accounts factored and withheld 20% of the
amounts factored.
c. On August 1, discounted the MN note at the bank at 15%.
d. On November 1, MN defaulted on the P300,000 note. Purple Company paid the bank the total amount
due plus a P12,000. protest fee and other bank charges.
e. On December 31, Purple Company assigned P600,000 of its accounts receivable to a bank under a
non-notification basis. The bank advanced 80% less a service fee of 5% of the accounts assigned.
Purple Company signed a promissory note for the…
arrow_forward
SEE MORE QUESTIONS
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,

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
Related Questions
- Question 9 Concord Company provides for bad debt expense at the rate of 3% of accounts receivable. The following data are available for 2018: Allowance for doubtful accounts, 1/1/18 (Cr.) $ 11300 Accounts written off as uncollectible during 2018 10400 Ending accounts receivable 1204000 The Allowance for Doubtful Accounts balance at December 31, 2018, should be $37020. $900. $36120. $35220.arrow_forwardWhat is the amount of write offs during Year 2 based on the following financial information? Balance Sheet Excerpts As At Year Year 2 Year 1 End(000s) Gross Accts Receivable Allowance for Doubtful Accounts Net Accts Receivable Provision for Bad Debt O $15 $20 $37 $52 $456 $20 $437 $25 $321 $32 $294 $40arrow_forwardProblem 84 (LAA) Summa Company revealed the following account balances on December 31, 2020 Accota payable Accounta receivable, net of allowance for doubtful accounts PS0.000 Accrued taxes Aecrued interest receivable Autherined sbare capital, 60,000 aharea. P100 par Building, net ofaccumulated depreciation of P500,000 3,000.000 Cash on hand Cash in bank Bond sinking fund Furniture and equipment, net ofaccumulated depreciation of P900,000 Iaventory Investment property Land Deferred tax liability Bonds payable due June 30, 2021 Notes payable Notes reoeivable Patent Ocher accrued liabilities Prepaid expenses Share premium Retained earninge appropristed for contingencies Retained eantings Share ubecription receivable Subscribed share capital E000 shares Unianoed share capital 1000,000 50.000 30,000 5,000.000 50.000 650.000 2000.000 1,500,000 1,200,000 700.000 1,000,000 650.000 2.000.000 850.000 200,000 370,000 150,000 100,000 300,000 200,000 2.700,000 500,000 L000,000 2.000,000 Required:…arrow_forward
- question 6 part 4 and 5arrow_forwardCalculate the total estimated uncollectibles based on the below information. Number of Days Outstanding Total 0–30 31–60 61–90 91–120 Over 120 Accounts receivable $400,900 $227,000 $95,800 $38,700 $22,900 $16,500 % uncollectible 1% 4% 5% 8% 10% Estimated uncollectibles $enter the total estimated bad debts amount in dollars $enter the estimated bad debts amount in dollars $enter the estimated bad debts amount in dollars $enter the estimated bad debts amount in dollars $enter the estimated bad debts amount in dollars $enter the estimated bad debts amount in dollarsarrow_forwardProblem 5: The following selected accounts were taken from the trial balance of Romen Company as December 31, 2020: 750,000 150,000 450,000 2,700,000 525,000 3,900,000 30,000 150,000 240,000 900,000 1,800,000 4,460,000 222,000 393,600 150,000 2,787,500 Accounts receivable Installment receivable – 2018 Installment receivable - 2019 Installment receivable – 2020 Beginning inventory Purchases Freight-in Repossessed merchandise @ NRV Repossession loss Cash sales Credit sales Installment sales Deferred gross profit – 2018 Deferred gross profit – 2019 Operating expenses Cost of installment sales Additional information: a. Gross profit rate for 2018 and 2019 installment sales were 30% and 32%, respectively. b. The entry for repossessed goods was: Repossessed Merchandise Repossession loss Installment Receivable – 2018 150,000 240,000 180,000 210,000 c. Merchandise on hand at the end of 2020 (new and repossessed) was 282,000. Installment Received - 2019 Required: Compute for the following : 1.…arrow_forward
- View Policies Current Attempt in Progress Vaughn Manufacturing has outstanding accounts receivable totaling $ 6.47 million as of December 31 and sales on credit during the year of $ 24.5 million. There is also a credit balance of $ 11500 in the allowance for doubtful accounts. If the company estimates that 6% of its outstanding receivables will be uncollectible, what will be the amount of bad debt expense recognized for the year? O $388200. O $ 399700. O $ 376700. O $1470000. Save for Later Attempts: 0 of 1 used Submit Answerarrow_forwardP7-1arrow_forwardINTERMEDIATE ACCOUNTING 2 DEBT RESTRUCTUREarrow_forward
- Question 8 At January 1, 2025, XYZ Company had an allowance for doubtful accounts with a $39,300 credit balance. XYZ Company reported the following information for 2025: 4 Sales revenue Cash collections from customers Write-offs of uncollectible accounts Recoveries of previously written-off accounts Bad debt expense In order to estimate the bad debt expense, XYZ Company prepared the following aging schedule at December 31, 2025: not past due 1-30 days past due 31-60 days past due 61-90 days past due over 90 days past due total accounts receivable $392,800 $307,500 ? Accounts Receivable % Uncollectible 3% 7% 11% 24% 46% $181,000 $ 36,000 $ 42,000 $ 14,600 $ 31,090 $ 21,000 $ 13,000 $293,000 Calculate XYZ Company's accounts receivable balance at January 1, 2025.arrow_forwardQS 9-3 (Algo) Recovering a bad debt LO P1 Solstice Company determines on October 1 that it cannot collect $55,000 of its accounts receivable from its customer, P. Moore. It uses the direct write-off method to record this loss as of October 1. On October 30, P. Moore unexpectedly pays his account in full to Solstice Company.Record Solstice’s entries for recovery of this bad debt.arrow_forward2021 Dec 31 Recorded Bad Debt Expense of $15,500 2022 Apr 1 Wrote off J.Salazar account of $3500 as uncollectible 2022 June 4 Wrote off T.Savvy account of $4000 as uncollectible 2022 August 10 Recovered $1500 from T. Savvy Required Journalize the transactions using the income statement approach to estimate bad debts. Journalize how Sloan Company would record the T Savvy bad debt situation if the direct write-off method had been used. Assume the bad debt was recovered on August 10, 2023.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


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