· 4 A A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2018 Numbe
ID: 2437312 • Letter: #
Question
· 4 A A Byte of Accounting, Inc. Worksheet For Period Ending June 30, 2018 Number Name Unadjusted Trial Balance Entres Adusled Trial Belance Debit Income Statement Deb? Debit 81110 Cash Debit Credit Credit 54 239 0.00 0008,750 00 0.00 91120 Accounts Recevable 10 1130 Prepaid Insurance 111140 Prepaid Rent 2 1150 Office Supplies 13 1211 Office Equip 14 1212 Accun. Depr -Office E 15 1311 Computer Equip 16-?1312 Accurn. Dopr-ComputerEquip.?? 17 1411 Buikding Cost 8 1412 Accum Depr Building 19 1510 Land 20 2101 Accounts Payable 21 2102 Advanced Payments 22 2103 Interest Payable 232105 Salaries Payable 252201 Mortgage Payable 26 2202 Notos Payable 2 3100Hudson Bloom, Capial 28 3300 Hudson Bloom, Wehdrawas 1,160 00 5,976.00 249.00 1,800.00 0.00 480.00 2,172.00 0.00 229 320 00 0.00 0.00 0.00 0.00 2010? qup 21.69 0.00 3,822.00 0.00 284.39 0.00 115,000.00 0.00 22000 00000 1,295.00 1.513 64 591.00 0 00 13,300 00 0 00 113,250.00 0001 1?97200 2,00000 0.00 000 17 105 00 8,75000 0 4100 Compuler&Consulting; RevenuG 315010!Rent Expense 1,80000 1 970 00 Transactions General Journal Worksheet Income Statement Ch ?Course Modes: 1-1 Accounting/12BRA...:Dearna Luftjens-LMBS52 Exce Start! Smooth 5Explanation / Answer
Ans:
Note:
1.) Debit Balance of Adjusted Trail Balance = Debit Balance of unadjusted Trail balance+ Debit balance of adjutment entry
2.) Cedit Balance of Adjusted Trail Balance = Cedit Balance of unadjusted Trail balance+ Cedit balance of adjutment entry
3.) Net Income= Total Revenue- Total expenses
Account Unadjusted Trail Balance Adjustment Entries Adjusted Trail Balance Income Statements Number Name Debit Credit Debit Credit Debit Credit Debit Credit 1110 Cash 54239.00 0.00 0.00 0.00 54239.00 0.00 0.00 1120 Accounts Receivables 1160.00 0.00 8750.00 0.00 9910.00 0.00 0.00 1130 Prepaid Insurance 5976.00 0.00 0.00 249.00 5727.00 0.00 0.00 1140 Prepaid Rent 7200.00 0.00 0.00 1800.00 5400.00 0.00 0.00 1150 Office Supplies 480.00 0.00 0.00 289.00 191.00 0.00 0.00 1211 Office Equipments 2172.00 0.00 0.00 0.00 2172.00 0.00 0.00 1212 Acc. Dep - Office Equipment 0.00 0.00 0.00 21.69 21.69 0.00 0.00 1311 Computer Equipment 229320.00 0.00 0.00 0.00 229320.00 0.00 0.00 1312 Acc. Dep - Computer Equipment 0.00 0.00 0.00 3822.00 3822.00 0.00 0.00 1411 Building - Cost 115000.00 0.00 0.00 0.00 115000.00 0.00 0.00 1412 Accumlated Depriciation - Building 0.00 0.00 0.00 284.39 284.39 0.00 0.00 1510 Land 22000.00 0.00 0.00 0.00 22000.00 0.00 0.00 2101 Accounts Payable 0.00 1295.00 0.00 0.00 1295.00 0.00 0.00 2102 Advance Payments 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2103 Interest Payable 0.00 0.00 0.00 1513.64 1513.64 0.00 0.00 2105 Salaries Payable 0.00 0.00 0.00 591.00 591.00 0.00 0.00 2201 Mortgage Payable 0.00 123300.00 0.00 0.00 123300.00 0.00 0.00 2202 Notes Payable 0.00 113250.00 0.00 0.00 113250.00 0.00 0.00 3100 Hudson Bloom, Capita 0.00 188972.00 0.00 0.00 188972.00 0.00 0.00 3300 Hudson Bloom, Withdrawals 2000.00 0.00 0.00 0.00 2000.00 0.00 0.00 4100 Computer & Consulting Revenue 0.00 17105.00 0.00 8750.00 25855.00 25855.00 5010 Rent Expense 0.00 0.00 1800.00 0.00 1800.00 0.00 1800.00 0.00 5020 Salary Expense 1970.00 0.00 591.00 0.00 2561.00 0.00 2561.00 0.00 5030 Advertising Expense 300.00 0.00 0.00 0.00 300.00 0.00 300.00 0.00 5040 Repair and Maint. Expense 1290.00 0.00 0.00 0.00 1290.00 0.00 1290.00 0.00 5050 Oil and Gas Expense 815.00 0.00 0.00 0.00 815.00 0.00 815.00 0.00 5080 Supplies Expense 0.00 0.00 289.00 0.00 289.00 0.00 289.00 0.00 5090 Interest Expense 0.00 0.00 1513.64 0.00 1513.64 0.00 1513.64 0.00 5100 Insurance Expense 0.00 0.00 249.00 0.00 249.00 0.00 249.00 0.00 5110 Depriciation Expense 0.00 0.00 4128.08 0.00 4128.08 0.00 4128.08 0.00 Total 443922.00 443922.00 17320.72 17320.72 458904.72 458904.72 12945.72 25855.00 Net Income 12909.28Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.