make a Balance sheet  using this information in the Trial Balance. Separate BS for 2022 and 2023. 

Transcribed Image Text:

A B 1 2 234 C D E J.K HOTEL CEBU TRIAL BALANCE AS OF DECEMBER 31, 2022 and 2023 5 AMOUNTS 6 ACCOUNT CODE 7 10001 ACCOUNT DESCRIPTION Cash in Bank 2022 MOVEMENTS 2023 1,308,300 405,000 1,713,300 8 10002 9 10003 Accounts Receivable Allowance for Doubtful Accounts Expense 552,980 178,000 730,980 10,000 - 13,800 23,800 10 10004 Prepaid Insurance 200,000 240,000 440,000 11 10005 Prepaid Audit Expense 50,000 50,000 12 10006 Office Supplies 120,000 25,000 145,000 13 10007 Cleaning Supplies 110,000 30,000 140,000 14 10008 Room Supplies 150,000 20,000 170,000 15 10009 Linens and Bedding Inventory 180,000 61,500 241,500 16 10010 Food and Beverages Inventory 200,000 116,000 316,000 17 10011 Retail Inventory 160,000 90,000 250,000 18 10012 Building 1,300,000 1,300,000 19 10013 Accumulated Depreciation - Building 130,000 130,000 20 10014 Hotel Equipment 220,000 335,000 555,000 21 10015 Accumulated Depreciation - Hotel Equipment 44,000 - 64,000 108,000 22 10016 Furniture and Fixtures 150,000 278,000 428,000 23 10017 Accumulated Depreciation - Furniture and Fixtures 37,500 59,000 96,500 24 10018 Investment in equity securities - FVOCI 120,000 120,000 25 20001 Accounts Payable 190,000 496,700 686,700 26 20002 Interest Payable 9,500 18,000 27,500 27 20003 Notes Payable 210,000 350,000 560,000 28 30001 Ungarnod Rovonuo 05.500 118.000 313.500 A B 1 2 234 C D E J.K HOTEL CEBU TRIAL BALANCE AS OF DECEMBER 31, 2022 and 2023 5 AMOUNTS 6 ACCOUNT CODE 7 10001 ACCOUNT DESCRIPTION Cash in Bank 2022 MOVEMENTS 2023 1,308,300 405,000 1,713,300 8 10002 9 10003 Accounts Receivable Allowance for Doubtful Accounts Expense 552,980 178,000 730,980 10,000 - 13,800 23,800 10 10004 Prepaid Insurance 200,000 240,000 440,000 11 10005 Prepaid Audit Expense 50,000 50,000 12 10006 Office Supplies 120,000 25,000 145,000 13 10007 Cleaning Supplies 110,000 30,000 140,000 14 10008 Room Supplies 150,000 20,000 170,000 15 10009 Linens and Bedding Inventory 180,000 61,500 241,500 16 10010 Food and Beverages Inventory 200,000 116,000 316,000 17 10011 Retail Inventory 160,000 90,000 250,000 18 10012 Building 1,300,000 1,300,000 19 10013 Accumulated Depreciation - Building 130,000 130,000 20 10014 Hotel Equipment 220,000 335,000 555,000 21 10015 Accumulated Depreciation - Hotel Equipment 44,000 - 64,000 108,000 22 10016 Furniture and Fixtures 150,000 278,000 428,000 23 10017 Accumulated Depreciation - Furniture and Fixtures 37,500 59,000 96,500 24 10018 Investment in equity securities - FVOCI 120,000 120,000 25 20001 Accounts Payable 190,000 496,700 686,700 26 20002 Interest Payable 9,500 18,000 27,500 27 20003 Notes Payable 210,000 350,000 560,000 28 30001 Ungarnod Rovonuo 05.500 118.000 313.500

Answer rating: 100% (QA)

To create balance sheets for 2022 and 2023 well organize the trial balance information into the standard balance sheet format Lets start with the bala... View the full answer