The general ledger account for Accounts Receivable shows a debit balance of $40,000. The Allowance for Uncollectible Accounts has a credit balance of $2,000. Net sales for the year were $250,000. In the past, 3 percent of net sales have proved uncollectible. An aging of accounts receivable accounts results in an estimate of $9,000 of uncollectible accounts receivable.

Calculate Uncollectible Accounts Expense and the ending balance of the Allowance for Uncollectible Accounts using (a) the percentage of net sales method and (b) the accounts receivable aging method.Create an Excel spreadsheet.