1. Compute the balance required in the allowance for uncollectible accounts at the end of the year. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong.) Customer Allowance needed Past Due Current 1-30 Days 31-60 Days 61-90 Days Over 90 Days Total 2. Prepare the journal entry to record the bad debt provision for the current year. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.) Accounts Debit Credit 3. Prepare the journal entry to record the bad debt provision for the current year assuming that the allowance for uncollectible accounts had a $30,000 debit balance. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. Use cell references from prior calculations, if applicable.) Accounts Debit Credit Customer Bad Debt Expense, Aging of Accounts Receivable, Journal Entry. Giaraldi Garden Products, Inc. developed an aged schedule of accounts receivable at the end of each year. Giaraldi Garden Products: Aged Schedule of Accounts Receivable Past Due Current 1-30 Days 31-60 Days 61-90 Days Over 90 Days The company estimated an allowance for uncollectible accounts based on the following estimates: Aging Category Current Allowance Provided 3% 1-30 days past due 6% 31-60 days past due 18% Totals 61-90 days past due 45% Carey Company $ 10,000 $ 34,500 $ 44,500 Over 90 days past due 100% Gibson, Ltd. $ 423,000 $ 27,000 450,000 KW Quarterly Onix Construction 33,000 $ 67,000 100,000 1,500 101,500 Giaraldi reported for the current year: 45,000 Carpenter Lumber Totals 387,000 $ 125,000 810,000 $ 185,000 $ 167,000 $ 90,500 500 235,500 512,500 Net credit sales $ 18,500,000 55,000 $ 127,000 $ 1,344,000 The company's ending balances of accounts receivable and the allowance for uncollectible accounts are presented below: Ending Balance Accounts Receivable 1,344,000 Allowance for Uncollectible 130,000 Unadjusted Ending Balance