Please open the attached screen shot and complete the following requirements in the Microsoft excel template. Once you're finished, upload the completed Microsoft Excel template. Thanks!

E7-23A Requirements 1. Journalize the year-end adjusting entry for uncollectible accounts on the basis of the aging schedule. Calculate the resulting ending balance of the Allowance account based on the account aging. Show the T-account for the Allowance on January 31, 2014. 2. Assume that instead of a $4,100 credit balance, there is a $900 debit balance in the Allowance account prior to adjustment. Journalize the year-end adjusting entry for uncollectible accounts on the basis of the aging schedule. Calculate the resulting ending balance of the Allowance account based on the account aging. Show the T-account for the Allowance on January 31, 2014. Req. 1 Journal DATE 2014 ACCOUNTS AND EXPLANATIONS POST REF. Dr. Cr. POST REF. Dr. Cr. Computations: Balance needed in allowance account: Adjusting entry amount: Allowance for uncollectible accounts Req. 2 Journal DATE 2014 ACCOUNTS AND EXPLANATIONS Computations: Allowance for uncollectible accounts