Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help putting these 10 transactions in the spreadsheet. Then I need to use the spreadsheet to create 3 financial documents. Thanks. A B

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

I need help putting these 10 transactions in the spreadsheet. Then I need to use the spreadsheet to create 3 financial documents. Thanks.

A B 1 Katelyn's Pet Fitness REGULAR TRANSACTIONS NOT RECORDED YET: KPF had received a payment from collected $20,000 of her accounts receivable during December TRANSACTION 1 and forgot to record it. KPF sent gift baskets to her customer list for the holidays. This cost a total of $3,000 which Katelyn paid for in December 2022. KPF landed a new corporate customer in December 2022 who wanted to pay $120,000 for a 12 month subscription to the dog walking service. The subscription starts on January 1,2023 . The customer asked if this purchase could be on account and payment would be made in January. KPF paid her staff an extra salary amount at year end as a bonus payment for a successful year's TRANSACTION 4 business. This amount was $4,000 and was paid to the employees in December 2022. 12 KPF had a customer who paid $2,000 cash for the dogs walked during the last week of December 13 TRANSACTION 5 2022. ADJUSTING TRANACTIONS NOT RECORDED YET: NOTE: Adjusting entries are generally recorded every month, and all prior month's entries have been properly recorded. Only the below AJE's for December still need to be recorded. KPF noticed in the unearned revenue balance, that $25,000 of the balance was earned by dog TRANSACTION 1 walking for her customers in December 2022. Katelyn had not recorded this as yet. KPF pays their employees every Wednesday. The 2022 year ended on a Friday, but she did not pay the employees for the two days they worked in 2022 until the following week (which was in January TRANSACTION 2 2023). This amount totaled $17,500. TRANSACTION 3 KPF did not record the insurance expense for the month of December 2022 of $8,000. KPF had an advertising campaign done in December 2022 by a marketing firm. Katelyn found the TRANSACTION 4 invoice on her desk for $11,000 and it was not due until January. KPF did not send an invoice to a customer for the month of December 2022 dog walking services of TRANSACTION 5 $9,000. =1=L====1=1= Katelyn's Pet Fitness Katelyn's Pet Fitness Katelyn's Pet Fitness Balance Sheet Income Statement Statement of Stockholders' Equity December 31, 2022 For the Year ended December 31, 2022 For the Year ended December 31, 2021

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

Conservation Easement IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304133923, 978-1304133922

More Books

Students also viewed these Accounting questions