Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help posting it again. I really need help its urgent Parrots Campgrounds Polly Parrot opened Parrots Campgrounds. The camp is open from April through
Please help posting it again. I really need help its urgent
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 F48 14 Parrots Campgrounds 15 16 Assets 17 101 Cash 120 Accounts Receivable 19 20 21 130 Office Supplies 150 Food Supplies 160 Prepaid Insurance 180 Equipment 181 Accum. Depr.-Equipment 23 24 25 Liabilities 26 200 Accounts Payable 210 Wages Payable 27 28 Owner's Equity 30 31 300 Polly Parrot Capital 310 Polly Parrot Drawing 390 Income Summary 32 33 Revenues 34 35 400 Registration Fees 36 37 Expenses 39 40 41 501 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 44 46 47 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 4 6. 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 6 11. 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 AC107 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 c27 x v fx Purchased food supplies from Wendy's Super Market on account, $,9000. Paste 90 6.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. 7 1 Paid insurance premium for seven month camping season, $14,000 9 2 Paid rent for lodge and campgrounds for the month of April, $25,000 11 2 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,000 15 15 5 Purchased office supplies from Petersons Office Supplies on account, $1250 17 18 19 7 Deposited registration fees, $48.300 20 10 Purchased food supplies from Wendy's Market on account, S7,200 21 22 10 Pald wages to fishing guides, $9,500 26 14 Deposited registration fees, 534500 26 16 Purchased food supplies from Wendy's Super Market on account, 5,9000 23 17 Paid wages to fishing guides, 59,500 18 Paid postage 5275 da cu Tab 1 Journal Entries required Tab 2 Ledger sheet Tab 4 Adjusting Entries Tab 5 Fin Statements Safari D AC107 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 C49 fx Paid phone bill, $1,350. A E G 21 Deposited registration fees, 535,600 14 15 24 Purchased food supplies from Acme Super Market on account, $8.500 36 7 24 Paid wages to fishing guides, 59,500 28 Deposited registration fees, 541,000 0 1 29 Pald wages to fishing guides, 59,500 30 Purchased food supplies from Wendy's Super Market on account, $6,300 30 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,225 493,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 AC107 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 1 1 2 1 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 3 2 ledger below. When you balance go to step 3 4 5 3 Go to Tab 4 and journal the adjusting entries 6 7 4 Come back to Tab 2 and post adjusting entries 8 in the orange rows 9 10 5 Check the Worksheet to make sure you are in balance. 11 6 Prepare and post closing entries 12 Parrots Campground 13 Cash-101 General Ledger 14 Ref Description Debit Credit Balance Office Supplies - 130 15 Beginning Balance 16 17 18 19 20 21 22 Equipment - Fishing Boats - 180 23 Ref Description Debit 24 25 26 27 Description Debit Credit Balance Credit Balance 28 Excel File Edit View Insert Format Tools Data Window Help AC107 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 28 29 Accumulated Depreciation 181 Ref Description Debit Credit Balance Debit Credit Balance Food Supplies 150 Rel Description Debit Credit Balance Debit Credit Balance 30 31 32 33 34 35 36 Accounts Receivable-120 37 Ref Description 38 39 40 Capital-300 41 Ref Description 42 43 44 45 46 47 48 Draw-310 49 Ref Description 50 51 52 53 54 Prepaid Insurance 160 Ref Description Deb Debit Credit Balance Cred Balance Tools Data Data Window Help AC107 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-501 56 Ref Description 57 58 59 60 Prepaid Rent Red Description Deb Cred 61 62 63 Accounts Payable-200 Ref Description Debat Credi Balance 64 6S 66 Food Supply Expense - 524 67 Ref Description 68 69 Debit Credit Balance Debit Credit Balance 70 71 72 73 Insurance Expense 532 74 Ret Description 75 76 77 78 79 BIO 81 wages Payable-210 Ref Destro Debler Credit Balance Registration Fees-400 Ref Der Bub De 82 84 Office Supply Expense 521 85 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 AC107 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 520 97 Ref Description Debit Credit Balance Ref Description Crede Balance 98 beg balance 99 100 101 102 103 Depreciation Expense - 550 Phone Expense 523 104 Ret Description Debit Credit Balance Red Derties Det Crede 105 106 0 107 0 10R 0 109 0 110 Postage Expense 540 111 Income Summary-313 hel Desc Debe Cred 112 Ret Description Debit Credit Balance 113 Fees Income 1141 Expenses 115 116 117 118 119 120 121 122 123 124 125 126 Capital 300 127 12 129 Tab 5 Fin su Tab Adjusting Entries required Tab 2 Ledger Tab 1 Journal Enviros Tab 3 Worksheet TIP Home Insert US Page Layout AC107 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'ID14 -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 1 2 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. C6 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 Insurance expired during the month of April $2000 d Depreciation on Fishing Boats for April $750 Wages earned but not yet paid at the end of April $1900 7 REQUIRED 8 1 Prepare the adjusting journal entries in the General Journal 2 post the adjusting entries in the General Ledger Tab 2 in the Orange lines. 3 Post the adjusting entries in Col. D and E 4 Prepared and adjusted trial balance in Tab 3 12 13 Ref # Accounts Debit Credit 14 a 15 16 b 4 5 6 e 9 10 11 1 1 17 18 C 19 Page 1 Page 2 20 d 21 22 e 23 24 25 26 Column Totals Check figure Difference 27 35,500 35,500 (35,500) (35,500) If this total is more than 0, then your have transactions that do not palance. 28 29 30 31 Hint: if either of these red numbers can be divided by 9 evenly 32 you probably have a transposition error meaning you entered 18 instead of $1 required Tab 1 Journal Entries Tab 2 Ledger Tab 3 Worksheet Tab 4 Adjusting Entr cut 11 = = Wrap Text Calibri (Body) BIU 1 Copy Format Paste loll Merge & Center Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it. F41 A 1 Financial Statements 1 Complete the Financial Statements in tab 5 2 Then prepare the closing entries in tab 6 Post the closing entries on the green lines the Ledger 3 in Tab 3 Income Statement 30-Apr Parrots Revenue Total Revenue Expenses 10 11 13 14 15 16 17 18 Total Expenses Net Income 20 Tab & Worksheet Tab 2 Ledger Tab 4 Adjusting Entries required Tab 1 Journ Entries B5.5. Home Insert Page Layout Formulas Data Cut Calibri (Bodyl - 11 AA- Copy B AC107 Unit 7 Final Parrots Campground Project Template Review View Wrap Text Marge & Center General la Activate Office to Create and Edit Buy Me or sign in to active Office if you've already bought $ Conditional Format Cell Formatting as Table Styles rer Delete Format 741 30-Apr Parrots Owner Equity 24 Beginning Equity 25 Net Income as Draw 27 Ending Equity Balance 28 23 Balance Sheet Assets Parrots 30 31 Liabilities Accounts Payable-200 wages Payable - 210 Total Liabilities 34 35 36 37 Equity Net Equipment Total Assets 19 Total Liabilities and Equity Check figure 234,475 41 42 Tabs Fine Stements Tab 3 Worksheet Tab 7 palengo Tab Adjusting Entries Tab 1 Journal Entries Tab 2 Ledger Tab Chong entries required AC107 Unit 7 Final Parr Home Insert Page Layout Formulas Data Review View Cut G 00 vouw Calibri (Body) - 11 A A Wrap Text Copy : Paste BIU Format - Merge & Center - Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it. 041 fx A B D E F 1 Steps 2 1 Close Revenue to Income Summary - prepare journal entry 3 4 2 Close All expenses to income Summary - prepare journal entry 5 6 3 Close Net income (Income - expenses) to Capital prepare journal entry 4 Close Drawing to Capital - prepare journal entry 9 10 5 Post these entries to the general ledger in tab 2 11 using the green lines to post these entries 12 13 6 Prepare a Post closing trail balance in Tab 3 Col Mand N 14 15 Complete the closing entries to income summary here 16 DR 17 1 18 19 to close revenue to income summary 20 21 2 22 list all expenses here 23 24 25 26 27 28 29 30 31 to close expenses to income summary 32 CR 33 3 34 35 To close net income to capital 36 37 4 38 39 To close Draw to Capital account 40 41 42 43 44 45 46 47 48 required Tab 1 Journal Entries Ta Tab 2 Ledger Tab 3 Worksheet Tab 4 Adjusting Entries cut AC107 Unit 7 Final Home Insert Page Layout Formulas Data Review View Calibri (Body) - 11 Wrap Text Copy : Paste Format BI Merge & Center Activate Office to Create and Edit Buy Office or sign in to activate Office if you've already bought it. E x G1 D E F Credit Page 1 1 Prepare the Post Closing Trial Balance 2 3 4 Parrots Campground 5 Post Closing Trail Balance 6 Accounts Debit 7 8 9 10 11 12 13 14 15 16 17 Total 18 19 20 21 22 23 24 25 26 27 28 29 Check Figure 235,225 required Tab 1 Journal Entries Tab 2 Ledger Tab 3 Worksheet Tab 4 Adjusting EntriesStep 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