Answered step by step
Verified Expert Solution
Link Copied!

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 Excelimage text in transcribedimage text in transcribedimage text in transcribed 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 Statements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting

Authors: Les Heitger, Pekin Ogan, Serge Matulich

2nd Edition

ISBN: 053881764X, 978-0538817646

More Books

Students also viewed these Accounting questions