Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please look at the following Excel sheet and record the transactions on the balance sheet, income statement, and Transaction Analysis Template. TRANSACTION 1 TRANSACTION 2
Please look at the following Excel sheet and record the transactions on the balance sheet, income statement, and Transaction Analysis Template.
TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 PAW sent promotional mailers costing $746 to potential customers in their area in December, hoping to attract new customers and start the year 2023 off with a bang. PAW paid for the mailers in December 2022. PAW landed a new corporate customer, Biogen, in December 2022. Biogen agreed to pay $90,000 for an 18-month subscription to PAW's doggie day-care service. The subscription will start on January 1, 2023. Biogen paid for the subscription in December 2022. In December 2022, PAW paid $60,000 in advance for a new insurance policy. This policy will cover their business operations for the full year 2023 (January 1 - December 31). PAW bought bags, leashes, and treats at a total cost of $1,750 from the local pet supply warehouse in December 2022. During December 2022, PAW collected \$2,700 from a customer who had purchased doggie day-care services earlier in the year on account. As of December 31, 2022, PAW had not yet recorded this receipt of cash. ADJUSTING TRANACTIONS NOLRECORDED YEL: NOTE: Adjusting entries are generally recorded at the end of every month, and PAW's AJEs have been properly recorded through November 30, 2022. Only the below AJEs for December 2022 still need to be recorded. TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 PAW pays their employees every Monday. The year 2022 ended on a Friday, but PAW did not pay the employees for the last four days they worked in 2022. The workers will be paid for these days (a total of $25,780 ) in the first week of January 2023. PAW paid for their December 2022 office rent in November. As of December 31, they had not yet recorded the rent expense of 9,000 that related to the month of December 2022. PAW had their office professionally cleaned in December 2022 for a total of $1,200. Jeri found the invoice from the cleaners (with a due date of January 5, 2023) buried in a mound of unopened mail on his desk. PAW performed doggie day-care services totalling $10,000 for Geode Company in December 2022. As of the end of the year, PAW had not yet sent a bill to the Geode for these services. Jeri noticed that $10,000 of the unearned revenue balance at December 31, 2022 had actually been earned by providing day-care services in December 2022. He has not yet recorded this transaction. 1 You can put all three financial statements on this tab. 2 a. Income Statement c. Balance Sheet Pets at Work Pets at Work Balance Sheet December 31, 202 For the Year ended December 31, 2022 For the Year endect Doldes' Equity \begin{tabular}{ll} \hline Missing Transactions & TAT \end{tabular} Financial Statements TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 PAW sent promotional mailers costing $746 to potential customers in their area in December, hoping to attract new customers and start the year 2023 off with a bang. PAW paid for the mailers in December 2022. PAW landed a new corporate customer, Biogen, in December 2022. Biogen agreed to pay $90,000 for an 18-month subscription to PAW's doggie day-care service. The subscription will start on January 1, 2023. Biogen paid for the subscription in December 2022. In December 2022, PAW paid $60,000 in advance for a new insurance policy. This policy will cover their business operations for the full year 2023 (January 1 - December 31). PAW bought bags, leashes, and treats at a total cost of $1,750 from the local pet supply warehouse in December 2022. During December 2022, PAW collected \$2,700 from a customer who had purchased doggie day-care services earlier in the year on account. As of December 31, 2022, PAW had not yet recorded this receipt of cash. ADJUSTING TRANACTIONS NOLRECORDED YEL: NOTE: Adjusting entries are generally recorded at the end of every month, and PAW's AJEs have been properly recorded through November 30, 2022. Only the below AJEs for December 2022 still need to be recorded. TRANSACTION 1 TRANSACTION 2 TRANSACTION 3 TRANSACTION 4 TRANSACTION 5 PAW pays their employees every Monday. The year 2022 ended on a Friday, but PAW did not pay the employees for the last four days they worked in 2022. The workers will be paid for these days (a total of $25,780 ) in the first week of January 2023. PAW paid for their December 2022 office rent in November. As of December 31, they had not yet recorded the rent expense of 9,000 that related to the month of December 2022. PAW had their office professionally cleaned in December 2022 for a total of $1,200. Jeri found the invoice from the cleaners (with a due date of January 5, 2023) buried in a mound of unopened mail on his desk. PAW performed doggie day-care services totalling $10,000 for Geode Company in December 2022. As of the end of the year, PAW had not yet sent a bill to the Geode for these services. Jeri noticed that $10,000 of the unearned revenue balance at December 31, 2022 had actually been earned by providing day-care services in December 2022. He has not yet recorded this transaction. 1 You can put all three financial statements on this tab. 2 a. Income Statement c. Balance Sheet Pets at Work Pets at Work Balance Sheet December 31, 202 For the Year ended December 31, 2022 For the Year endect Doldes' Equity \begin{tabular}{ll} \hline Missing Transactions & TAT \end{tabular} Financial StatementsStep 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