answer please

MUST USE EXCEL TEMPLATE MUST SHOW YOUR WORK XYZ Co had a credit balance of $8,000 in its AFDA. Required: Prepare T-Account entries for each transaction. Transaction 1) On October 31, 2022, a customer balance for $1,000 from a prior year was determined to be uncollectible and was written off. Transaction 2) On December 15, 2022, the customer balance for $1,000 written off on October 31, 2022, was collected in full