Question
Please adjust the provided AR aging schedule - and apply our policy Note from Miranda: Based on the above recorded transactions, please update the previous
- Please adjust the provided AR aging schedule - and apply our policy
Note from Miranda: Based on the above recorded transactions, please update the previous months aged accounts receivable schedule. Then please apply the companys policy, which main points are noted below. Please use the provided templates.
Policy notes:
- No individual customer will have an account balance that exceeds $10,000
- We will write off accounts that are 120+ overdue
- We notify customers after 90 days that their account is not in good standing
Using the following template, please update in the blank version below:
Plants From Paradise | |||||||
Aged Receivables Listing | |||||||
November 30, 2021 | |||||||
Account # | Name | <30 days | 30 - 60 days | 60 90 days | >90 days | 120+ days | Total Balance |
150 - 100 | Larry's Landscaping | $2,300 | $2,300 | ||||
250 - 100 | Billy Jeans Ponds | $0 | |||||
350 - 100 | Harrys Hedges | $1,500 | $1,500 | ||||
450 - 100 | Big Berry Corp | $8,750 | $8,750 | ||||
Total | 2,300 | $8,750 | 1,500 | 12,550 |
Apply the policy:
- For any account that exceeds (at any point) $10,000 please flag for my review (1 mark)
- Prepare any journal entries required for accounts that are to be written off, please note that Plants from Paradise has an Allowance for Doubtful accounts account balance of $2,000.
Entry # | Date | Description | Account Name | Debit or Credit | Amount |
- For all accounts that are greater than 90 days, please identify them, and draft a quick (3-4 sentence) email template that communicates for each overdue account
- Plants from Paradise December 22, 2021 Victoria BC 250 - 555-5858 Bill To: Larry Larry's Landscaping Victoria BC 250 - 888-8989 DESCRIPTION AMOUNT Plant Order $ 5,179.99 Soil Order $ 1,250.00 Delivery $ 99.98 Total $ 6,529.97 THANK YOU FOR YOUR BUSINESS! Invoice #21-080 Plants from Paradise December 20, 2021 Victoria BC 250 - 555-5858 Bill To: Larry Larry's Landscaping Victoria BC 250 - 888-8989 DESCRIPTION AMOUNT Plant Order $ 179.99 Delivery $ 49.99 Total $ 229.98 THANK YOU FOR YOUR BUSINESS! Invoice #21-078 Page 2 of 4 Plants from Paradise December 15, 2021 Victoria BC 250 - 555-5858 Bill To: Billy Jean Billy Jean's Pond Co Victoria BC 250 - 888-8999 DESCRIPTION AMOUNT Soil Order $ 250.00 Plant order $ 799.00 Total $ 1,049.00 THANK YOU FOR YOUR BUSINESS! Invoice #21-077 Page 3 of 4 Plants from Paradise December 15, 2021 Victoria BC 250 - 555-5858 Bill To: Larry Larry's Landscaping Victoria BC 250 - 888-8989 DESCRIPTION AMOUNT Plants Order $ 2,000.00 Delivery $ 49.99 Total $ 2,049.99 THANK YOU FOR YOUR BUSINESS! Invoice #21-076 Page 4 of 4
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started