Home Insert Draw Page Layout 2 G8 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 25 26 27 28 29 30 31 32 33 34 35 36 37 38 Paste 39 40 41 42 43 44 Excel File Edit View Insert Format AutoSave OFF S + 5 = Formulas A A A X Arial BIU B Account Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 Accum. Depr.-Office Equip 1311 Computer Equip. 1312 Accum. Depr.-Computer Equip 1411 Building Cost 1412 Accum. Depr.-Building 1510 Land 2101 Accounts Payable 2102 Advanced Payments 2103 Interest Payable 2105 Salaries Payable 2201 Mortgage Payable 2202 Notes Payable 3100 Hudson Bloom, Capital 3300 Hudson Bloom, Withdrawals 4100 Computer & Consulting Revenue. 5010 Rent Expense Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. x fx 5020 Salary Expense 5030 Advertising Expense 5040 Repairs & Maint. Expense 5050 Oil & Gas Expense 5080 Supplies Expense 5090 Interest Expense 5100 Insurance Expense 5110 Depreciation Expense Total NET INCOME Balance 10 10 V 0.00 0.00 0.00 0.00 0.00 2,300.00 Unadjusted Trial Balance Debit 77,722.00 Credit 1,156.00 2,871.00 8,800.00 630.00 1,802.00 0.00 197,520.00 0.00 100,000.00 0.00 19,000.00 0.00 0.00 0.00 0.00 A 1,620.00 300.00 1,240.00 940.00 0.00 0.00 3.441.00 0.00 419,342.00 Tools Data Window Window Help D Data Instructions FAQ Welcome Select destination and press ENTER or choose Paste = = = + 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,810.00 0.00 0.00 0.00 107,100.00 97.000.00 194,112.00 0.00 Review View Tell me 18,320.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 419,342.00 == E F For Period Ending June 30, 2023 Adjusting Entries Debit 0.00 5,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 486.00 0.00 0.00 0.00 371.00 0.00 0.00 0.00 6,357.00 Chart of Accounts Credit 0.00 0.00 0.00 0.00 371.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 486.00 0.00 0.00 0.00 0.00 5,500.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ab Wrap Text Merge & Center 6,357.00 2,836 G Adjusted Trial Balance Debit Credit Transactions H 17 SP3794 582 Accounting $ % 9 V I General Journal 0 J Income Statement Debit Credit .00 Worksheet K Conditional Format Formatting as Table L UM Debit Balance Sheet L W Credit Income Statement Cell Styles M 25% 25% Sat 12:13 PM Samantha Parneg Q Insert v Delete v Format v N . V Changes in Owner's Equity 8 FO 28-01 V Sort & Filter O P Find & Select Share P M Analyze Sensitivity Data Q Comments Check for Updates Balance Sheet R A S 100% Home Insert Draw Page Layout Q E9 2 3 4 5 6 7 8 Paste 21 22 23 24 25 26 27 28 29 Excel File Edit View Insert Format Tools Data Window AutoSave OFF S + 5 = Formulas A A X A El village Productions Arial BIU 9 10 11 12 13 14 15 16 1411 Building 17 1412 Accum. Depr.-Building 18 1510 Land 19 2101 20 2102 2103 2105 2106 1311 1312 Number Name 1110 Cash 1120 Accounts Receivable 1130 Prepaid Insurance 1140 Prepaid Rent 1150 Office Supplies 1211 Office Equip. 1212 2201 2202 3100 3300 3400 4100 30 5010 31 5020 32 5030 33 5040 Accum. Depr.-Office Equip. Computer Equip. Accum. Depr.-Computer Equip. Accounts Payable Advanced Payments Interest Payable Salaries Payable 10 10 Income Taxes Payable Mortgage Payable Notes Payable Hudson Bloom, Capital Hudson Bloom, Withdrawals Income Summary V Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. x fx A Computer & Consulting Revenue Rent Expense Salary Expense Building Blocks of Accounting.. A Financial Perspective Chart of Accounts Data Advertising Expense Repairs & Maint. Expense Instructions FAQ Select destination and press ENTER or choose Paste B 50 Sheet Legal Pad Review == Welcome Window Help = = = View Tell me Chart of Accounts. Debit Debit Debit Debit Debit Credit Debit Normal Balance Debit Credit Debit Credit Debit Credit Credit Credit Credit Credit Credit Credit Credit ab Wrap Text Debit Credit Credit Debit Debit Debit Debit 2,836 Merge & Center v Transactions 7 D 582 SP3794 General $ % 9 V E General Journal F 0 G .00 Worksheet H L UM Conditional Format Formatting as Table I J Income Statement W Cell Styles K 25% 25% Sat 12:13 PM Samantha Parneg Q Insert v Delete v Format v L M . V N FO 28-01 V Sort & Filter Changes in Owner's Equity B O Find & Select P Share Balanc Comments M Analyze Sensitivity Data Check for Updates Q R 01 LOND S Home Insert Draw Page Layout 2 E9 U Paste 9 10 Excel File Edit View Insert Format Tools Data Window AutoSave OFF S + 5 = 37 38 39 10 X A Arial E SUUNTIE ESPOSITORIO 1130 Prepaid Insurance 1140 Prepaid Rent 11 1150 Office Supplies 12 1211 Office Equip. 13 1212 Accum. Depr.-Office Equip. BIU 14 1311 Computer Equip. 15 1312 16 1411 Building 17 1412 Accum. Land 18 1510 19 2101 20 2102 2103 21 22 2105 23 2106 24 2201 25 2202 26 3100 27 3300 28 3400 29 4100 30 5010 31 5020 32 5030 33 5040 34 5050 35 5080 36 5090 5100 5110 Accum. Depr.-Computer Equip. Depr.-Building Accounts Payable Advanced Payments Interest Payable Salaries Payable Income Taxes Payable 10 10 Mortgage Payable Notes Payable Hudson Bloom, Capital Hudson Bloom, Withdrawals Income Summary Computer & Consulting Revenue Rent Expense Salary Expense Advertising Expense Repairs & Maint. Expense Oil & Gas Expense Supplies Expense Interest Expense Insurance Expense Depreciation Expense Formulas Data V Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. x fx fx B A A A Instructions FAQ Welcome Select destination and press ENTER or choose Paste Window Help Review == = = = View Tell me Chart of Accounts. + Down Debit Debit Debit Debit Credit Debit Credit Debit Credit Debit. Credit Credit Credit Credit Credit Credit Credit Credit Debit Credit Credit Debit Debit Debit Debit Debit Debit Debit Debit Debit ab Wrap Text 2,836 Merge & Center C Transactions 7 D 582 SP3794 General $%9 E General Journal F 0 G .00 Worksheet H L UM Conditional Format Formatting as Table I J Income Statement W Cell Styles K 25% 25% Sat 12:13 PM Samantha Parneg Q Insert v Delete v Format v L M . TULE V N 0. V Sort & Filter Changes in Owner's Equity B O Find & Select P Balanc Share FO M Comments Analyze Sensitivity Data Check for Updates Q R 1.00LONY911000 S Home Insert Draw Page Layout Paste A80 1 2 3 4 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 Excel File Edit View Insert Format Tools Data Window AutoSave OFF A X Transaction 08 08 08 07 Jun 10 07 Jun 10 09 09 10 10 10 10 11 11 B BIU | Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx Date 13 13 Jun 14 Jun 14 Jun 14 Jun 16 Jun 16 Jun 16 Jun 16 Jun 16 Jun 16 Jun 17 Jun 17 12 Jun 17 12 Jun 17 Arial C Account Name 2202 Notes Payable 1110 Cash 8 8 5100 Insurance Expense 1130 Prepaid Insurance 1110 Cash sro = 1510 Land 1411 Building 1110 Cash 2201 Mortgage Payable 1140 Prepaid Rent 1110 Cash D A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. Formulas 2101 Accounts Payable 1110 Cash 5030 Advertising Expense 2101 Accounts Payable A A V Data Review Window Help E 1110 Cash 4100 Computer & Consulting R Services performed for Pitman Pictures Jun 21 Jun 211 Instructions FAQ Select destination and press ENTER or choose Paste = = = = = Description Being amount paid against 5 yea 23,000.00 Being amount paid against 5 year note to royce com Purchase of land & building Purchase of land & building Purchase of land & building Purchase of land & building Payment of rent Payment of rent Being purchased one year insura 3,441.00 2,871.00 Being purchased one year insurance Being purchased one year insurance policy for comp Services performed for Pitman Pi 8,000.00 comes View Tell me Advertising Expense invoice rece Advertising Expense invoice received Payment of accounts payable Payment of accounts payable Welcome Chart of Accounts F 2,836 Debit 19,000.00 100,000.00 8,800.00 300.00 Wrap Text 240.00 Merge & Center G Credit 23,000.00 6,312.00 8,000.00 11,900.00 107,100.00 8,800.00 300.00 240.00 Transactions H 581 I SP3794 General V J % 9 General Journal www. K 500 .00 L Worksheet AA Conditional Format Cell Formatting as Table Styles M N W Income Statement O O 18% P Sat 12:49 PM Samantha Parneg Q Insert v Delete Format v Q R Share 27. O. Q Sort & Filter Changes in Owner's Equity 8 S m Find & Select T Analyze Data U Comments Check for Updates Balance Sheet Sensitivity A V 100% W Home Insert Draw Page Layout Paste A80 1 2 3 4 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 Excel File Edit View Insert Format Tools Data AutoSave OFF BES 5 = Formulas A X Transaction 141 14 15 15 16 16 17 17 BIU | Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx 18 18 19 19 B 20 20 Date Jun 21 Jun 21 Jun 21 Jun 21 Jun 22 Jun 22 Jun 22 Jun 22 Jun 22 Jun 22 Jun 23 Jun 23 Arial Jun 23 Jun 23 C Account Name 1211 Office Equip 1110 Cash 8 8 5020 Salary Expense 1110 Cash A A D A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. 2101 Accounts Payable 1110 Cash 1150 Office Supplies 2101 Accounts Payable V 1110 Cash 1120 Accounts Receivable 1120 Accounts Receivable Record of revenue 4100 Computer & Consulting R Record of revenue Data Review E Description Fax Machine purchased Fax Machine purchased 5040 Repairs & Maint. Expense Computer repairing fee 2101 Accounts Payable Computer repairing fee = = = = = Need a Description Instructions FAQ Welcome Select destination and press ENTER or choose Paste Advertising expenses paid Advertising expenses paid Need a Description comes Window Help Need a Description View Chart of Accounts 2,836 F Debit 650.00 4,200.00 810,00 1,240.00 300.00 630.00 Tell me 3,365.00 Wrap Text Merge & Center G Credit 650.00 4,200.00 810.00 1,240.00 300.00 630.00 3,365.00 Transactions H 581 I SP3794 General V J % 9 General Journal www. K 500 .00 L Worksheet Conditional Format Cell Formatting as Table Styles M N W Income Statement O O 18% P Sat 12:49 PM Samantha Parneg Q Insert v Delete Format v Q R Share 27. O. Q Sort & Filter Changes in Owner's Equity S 8 E Find & Select T Analyze Data Balance Comments U Sensitivity Check for Updates V SOGOVONSTO LORO N W Home Insert Draw Page Layout Paste A80 1 2 3 4 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 Excel File Edit View Insert Format Tools Data Window Help AutoSave OFF BES 5 = Formulas A X Transaction 23 23 22 Jun 29 22 Jun 29 24 24 25 25 26 26 27 27 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx B 28 28 Date Jun 29 Jun 29 Jun 29 Jun 29 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Jun 30 Arial Jun 30 Jun 30 BIU | C Account Name 8 8 2101 Accounts Payable 1110 Cash 1110 Cash 1120 Accounts Receivable 5020 Salary Expense 1110 Cash 5050 Oil & Gas Expense 2101 Accounts Payable D A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. 5010 Rent Expense 1140 Prepaid Rent 5080 Supplies Expense 1150 Office Supplies FAQ A A V 3300 Hudson Bloom, Withdrawals 1110 Cash Data Need a Description E Need a Description Need a Description = = = = = Description Need a Description Instructions Select destination and press ENTER or choose Paste Welcome Need a Description Need a Description Need a Description comes Review View Tell me Chart of Accounts 2,836 F Debit 5,799.00 810.00 940.00 2,300.00 Wrap Text 371.00 Merge & Center G Credit 5,799.00 810.00 940.00 2,300.00 371.00 Transactions H 581 I SP3794 General V J % 9 General Journal www. K 500 .00 L Worksheet Conditional Format Cell Formatting as Table Styles M N W Income Statement O O 18% P Sat 12:49 PM Samantha Parneg Q Insert v Delete Format v Q R Share 27. O. Q Sort & Filter Changes in Owner's Equity 8 S m Find & Select T Analyze Data Balance Comments U Sensitivity Check for Updates V SORONONSTO ORO C W Home Insert Draw Page Layout Paste A80 1 2 3 4 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 Excel File Edit View Insert Format Tools Data Window AutoSave OFF A X Transaction B 29 29 Date 28 Jun 30 28 TT-TO-I 31 BIU | = = = = = Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. fx fx Jun 30 Jun 30 Jun 30 30 30 Jun 30 Jun 30 31 Jun 30 Jun 30 32 Jun 30 32 32 32 Jun 30 Jun 30 Jun 30 Jun 30 33 33 Jun 30 Arial 34 Jun 30 34 Jun 30 C Account Name 5080 Supplies Expense 1150 Office Supplies 5090 Interest Expense 2103 Interest Payable 5090 Interest Expense 1130 Prepaid Insurance sro = 8 8 D A Byte of Accounting General Journal Note: You can only enter data into the yellow filled cells. 5020 Salary Expense 2105 Salaries Payable Formulas 5110 Depreciation Expense Building 1411 1311 Computer Equip. 1211 Office Equip. 5090 Interest Expense 2103 Interest Payable A A V Data Review E Description Need a Description 1120 Accounts Receivable 4100 Computer & Consulting R Need a Description Need a Description Need a Description Instructions Welcome FAQ Select destination and press ENTER or choose Paste Need a Description Need a Description Need a Description Need a Description Window Help Need a Description comes Chart of Accounts View Tell me 2,836 F Debit 371.00 5,500.00 Wrap Text 486.00 Merge & Center G Credit 371.00 5,500.00 486.00 Transactions H 581 I SP3794 General % 9 $ % V General Journal www. K 500 .00 L Worksheet Conditional Format Cell Formatting as Table Styles M N W Income Statement O O 18% P Sat 12:49 PM Samantha Parneg Q Insert v Delete Format v Q R Share 27. O. Q Sort & Filter Changes in Owner's Equity S 8 E Find & Select T Balanc Analyze Data Comments U Sensitivity Check for Updates V SOROVONSON JORD A W