Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help me explaining this information in excel AutoSave OFF Accounting Cycle Case Study - Preston Hill Bed & Breakfast - ASSIGNMENT FILE (1).xls -

please help me explaining this information in excel

image text in transcribed

AutoSave OFF Accounting Cycle Case Study - Preston Hill Bed & Breakfast - ASSIGNMENT FILE (1).xls - Compatibility Mode Q ~ Search Sheet Home Insert Page Layout Formulas Data Review View Shar X cut WI AutoSum Paste Copy Arial 11 A A = 22 Wrap Text General LI Fill v AY Format B I U v div Av E E Merge & Center v $ % 2 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles Clear Filter A4 X V fx C D E G Q P Q R S Preston Hill Bed & Breakfast Trial Balance For the Month Ended April 30, 2018 5 Account Unadjusted Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet ustments Post-Closing Trial Balance Number Account Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit 9 101 Cash 10 105 Accounts Receivable 115 Supplies 12 120 Prepaid Rent 13 1 125 Prepaid Insurance 4 140 Delivery Van 15 150 Vehicles 6 155 Accumulated Depreciation 17 165 Security Deposits 8 203 Accounts Payable 208 Deferred Room Rental Revenue 210 Notes Payable 310 Common Stock 22 390 Retained Earnings 23 501 Room Rental Revenue 505 Administrative Fee Revenue 25 605 Advertising 26 610 Depreciation Expense 27 615 Dues Expense 28 620 Food Expense 29 640 Interest Expense 30 645 Insurance Expense 1 655 Printing Expense 650 Office Supplies 660 Postage 665 Licenses and fees 35 670 Telephone 36 675 Rent Expense 37 685 Utilities 38 690 Wage Expense 695 Uniforms 40 700 Dividends 750 Income Summary 42 Net Income (Loss) Totals

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

Accounting Information Systems And Internal Control

Authors: Eddy Vaassen, Roger Meuwissen, Caren Schelleman

2nd Edition

0470753951, 9780470753958

More Books

Students also viewed these Accounting questions

Question

What are the attributes of a technical decision?

Answered: 1 week ago

Question

Identify the critical elements in a performance management system

Answered: 1 week ago

Question

Identify the skills necessary for effective coaching

Answered: 1 week ago