Parrots Campgrounds Polly Parrot opened Parrots Campgrounds. The camp is open from April through October. Campers typically register for one week, arriving on Sunday afternoon and packing up the following Saturday afternoon. The registration fee includes space and meals, the use of fishing boats, and other activities around the campgrounds. The chart of accounts for the camping operations is provided below. Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought F$4814$ Parrots Campgrounds $1516$ Assets $17101$ Cash $120$ Accounts Receivable $192021130$ Office Supplies $150$ Food Supplies $160$ Prepaid Insurance $180$ Equipment $181$ Accum. Depr.$-$Equipment $232425$ Liabilities $26200$ Accounts Payable $210$ Wages Payable $2728$ Owner's Equity $3031300$ Polly Parrot Capital $310$ Polly Parrot Drawing $390$ Income Summary $3233$ Revenues $3435400$ Registration Fees $3637$ Expenses $394041501$ Wages Expense $520$ Rent Expense $521$ Office Supplies Expense $522$ Food Supplies Expense $523$ Phone Expense $531$ Utilities Expense $532$ Insurance Expense $540$ Postage Expense $550$ Depr. Exp. $---$Fishing Boats $444647$ required Tab $1$ Journal Entries Tab $2$ Ledger Tab $3$ Worksheet Tab $44$ REQUIRED: $1.$ Enter the April transactions in a general journal. Enter transactions on Tab $1-$ Journal Entries. $2.$ Post the entries to the general ledger in Tab $2.3.$ Prepare a trial balance on a work sheet in Tab $3.4.$ Complete the work sheet $-$ Tab $3.5.$ Journalize the adjusting entries in Tab $46.$ Post the adjusting entries to the general ledger in Tab $2$ and in the Worksheet in Tab $3.7.$ Prepare the income statement in Tab $5.8.$ Prepare the statement of owner's equity in Tab $5.9.$ Prepare the balance sheet in Tab $5.10.$ Journalize the closing entries in tab $611.$ Post the closing entries to the general ledger in Tab $3$ using the green highlighted lines. $12.$ Prepare a post$-$closing trial balance in Tab $3$ x cut Excel File Edit View Insert Format Tools Data Window Help AC$107$ Unit $7$ Final Parrots Campground Project Home Insert Page Layout Formulas Data Review View Calibri $($Body$)-14$ A$-$ A$+$ Wrap Text General Copy BIU Format Merge & Center $\%)$ Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it c$27$ x v fx Purchased food supplies from Wendy's Super Market on account, $$,9000.$ Paste $906\mathrm{.}0.$OD journal Entries entire accounting process. As such, students should plan on about three to she hours to complete this problem. General Journal Date Always list the Debit item first Debit Accounts Credit The following transactions took place during April April $1$ Parrot invested cash in business, $$100,000.71$ Paid insurance premium for seven month camping season, $$14,00092$ Paid rent for lodge and campgrounds for the month of April, $$25,000112$ Deposited registration fees, $$32,000.12$ Purchased $10$ fishing boats on account for $$45,000.$ The boats have estimated useful lives $2$ of five years, at which time they will be donated to a local day camp. Arrangements were made to pay for the boats in August $3$ Purchased food supplies from Wendy's Food Market on account $$5,00015155$ Purchased office supplies from Petersons Office Supplies on account, $$12501718197$ Deposited registration fees, $$48\mathrm{.}3002010$ Purchased food supplies from Wendy's Market on account, S$7,200212210$ Pald wages to fishing guides, $$9,5002614$ Deposited registration fees, $5345002616$ Purchased food supplies from Wendy's Super Market on account, $5,90002317$ Paid wages to fishing guides, $59,50018$ Paid postage $5275$ da cu Tab $1$ Journal Entries required Tab $2$ Ledger sheet Tab $4$ Adjusting Entries Tab $5$ Fin Statements Safari D AC$107$ Unit $7$ Final Parrots Campground Project Template Home Sun $1$:$22$ PM SON Data Review View Insert Cut Ceny. Page Layout Formulas Calibri $($Body$).14$ General Paste $13$ Format Merge & Centar $$.\%)$ Conditional Format Formatting Table Styles Inseri Formal Cear Activate Office to Create and Edit Buy Office or sign in to activate Onice if you ve already bought C$49$ fx Paid phone bill, $$1,350.$ A E G $21$ Deposited registration fees, $535,600141524$ Purchased food supplies from Acme Super Market on account, $$8\mathrm{.}50036724$ Paid wages to fishing guides, $59,50028$ Deposited registration fees, $541,0000129$ Pald wages to fishing guides, $59,50030$ Purchased food supplies from Wendy's Super Market on account, $$6,30030$ Paid Wendys Super Market on account, $$32,700.30$ Paid utilities bill, $$2,750.30$ Paid phone bit, $1,350.30$ Polly Parrot withdrew cash for personal use, $$5,500$ This is the total of all your entries it does Column Totals not match the next line you have journals $493,225493,225$ that are posted incorrectly. Note the check Check figure figures arbitrary and it will not balance to Difference $1493,225)(493,225)$ any other numbers in this problem If this total is more than then you Tab $4$ Adjusting Entries Tabs Fin Statements Tab & Closing entries Tab $7$ postcoung TB required Tab $1$ Journal Entries Tab $3$ Workshoot Tab $2$ Ledger Excel File Edit View Insert Format Tools Data Window Help AC$107$ Unit $7$ Final Parrots Campo View Home Insert Page Layout Formulas Data Review Cut A A Wrap Text Custom Copy Calibri $($Body$).$ BIU Paste A Format Merge & Center $ $.\%$ Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it$.133$ A B D $1121$ Post the transaction from General Journal in Tab $1$ in the ledger accounts below. Go to tab $3$ and see if Col band balance. If they do$,$ you have posted everything correctly if they do not balance, you will need to find your posting error in the general $32$ ledger below. When you balance go to step $3453$ Go to Tab $4$ and journal the adjusting entries $674$ Come back to Tab $2$ and post adjusting entries $8$ in the orange rows $9105$ Check the Worksheet to make sure you are in balance. $116$ Prepare and post closing entries $12$ Parrots Campground $13$ Cash$-101$ General Ledger $14$ Ref Description Debit Credit Balance Office Supplies $-13015$ Beginning Balance $16171819202122$ Equipment $-$ Fishing Boats $-18023$ Ref Description Debit $24252627$ Description Debit Credit Balance Credit Balance $28$ Excel File Edit View Insert Format Tools Data Window Help AC$107$ Unit $7$ Final Parr Home Insert Page Layout Formulas Data Review View X Cut Calibri $($Body$)11$ A A Wrap Text Copy Paste BI U A Merge & Center Format Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it$.$ lile $133$ A B C D E F G H $1$ J $2829$ Accumulated Depreciation $181$ Ref Description Debit Credit Balance Debit Credit Balance Food Supplies $150$ Rel Description Debit Credit Balance Debit Credit Balance $30313233343536$ Accounts Receivable$-12037$ Ref Description $383940$ Capital$-30041$ Ref Description $42434445464748$ Draw$-31049$ Ref Description $5051525354$ Prepaid Insurance $160$ Ref Description Deb Debit Credit Balance Cred Balance Tools Data Data Window Help AC$107$ Unit $7$ Final Parrots Home Insert Page Layout Formulas Review View X Cut Calibri $($Body$)$ A A so Wrap Text$-$ Cus Copy Paste BI Format Merge & Center $ Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it$.133$ C D K Debit Credit Balance A $55$ Wage Expense$-50156$ Ref Description $57585960$ Prepaid Rent Red Description Deb Cred $616263$ Accounts Payable$-200$ Ref Description Debat Credi Balance $646$S $66$ Food Supply Expense $-52467$ Ref Description $6869$ Debit Credit Balance Debit Credit Balance $70717273$ Insurance Expense $53274$ Ret Description $7576777879$ BIO $81$ wages Payable$-210$ Ref Destro Debler Credit Balance Registration Fees$-400$ Ref Der Bub De $8284$ Office Supply Expense $52185$ Ref Description $86$ Det Credit Balance Tab $5$ Find Tab $1$ Journal Entries required Tab $2$ Ledger Tab $4$ Austing Entries Tab $3$ Worksheet L Det rue COIL View insert Format Tools Data Window Help su AC$107$ Unit $7$ Final Parrots Cam Home Insert Page Layout Formulas Data Review View X Cut Calibri $($Body$)-11$ A A Copy to Wrap Text Custom Paste Format BIU Merge & Center $ $.\%$ Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it$.133$ A C D H $06$ Utilities Expense $533$ Rent Expense $52097$ Ref Description Debit Credit Balance Ref Description Crede Balance $98$ beg balance $99100101102103$ Depreciation Expense $-550$ Phone Expense $523104$ Ret Description Debit Credit Balance Red Derties Det Crede $1051060107010$R $01090110$ Postage Expense $540111$ Income Summary$-313$ hel Desc Debe Cred $112$ Ret Description Debit Credit Balance $113$ Fees Income $1141$ Expenses $115116117118119120121122123124125126$ Capital $30012712129$ Tab $5$ Fin su Tab Adjusting Entries required Tab $2$ Ledger Tab $1$ Journal Enviros Tab $3$ Worksheet TIP Home Insert US Page Layout AC$107$ Unit $7$ Final Parrots Campground Project Template $90\%$ Formulas Data Review View X Cut Copy Calibrl $($Body$)20$ Wrap Text Paste Custom Format B Merge & Center $ $.\%)$ Conditional Format Cell Formatting as Table Styles Inser Delete For Activate Office to Create and Edit Buy Orice or sign in to activate Office if you've already bought it$.$ fx "Tab $4$ Adjusting Entries'ID$14-9$ Parrots Tris Balance DR CR Ref Adjustmes DR Adjusted Trial Balance DR CR CR Income sement DR CR Kance sheet DR CR Post Closing the Balance DR CR $-$ b Cash$-101$ Accounts Receivable$-120$ Office Supplies $-130$ Food Supplies $150$ Prepaid Insurance $160$ Equipment Fishing Boats $-180$ Accumulated Depreciation $181$ Accounts Payable$-200$ wages Payable $210$ Capital$-300$ Draw$-310$ Registration Fees $400$ Wage Expense $-501$ Rent Expense $520$ Office Supply Expense $521$ Food Supply Expense$-524$ Phone Expense$-523$ Utilities Expense $533$ Insurance Expense $532$ Postage Expense $540$ Depreciation Expense $-550$ Page $1$ Hage $3$ net income Wrap Text ali $|$ Merge & C $12$ a $3$ b Home Insert Page Layout Formulas Data Review View X Cut Calibri $($Body$)14$ A A Copy Paste BIU Format Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it$.$ C$6$ fx Wages earned but not yet paid at the end of April $$1900$ D Adjusting Entries Office Supplies on hand $$400$ Food Supplies remaining on hand $$6000$