Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need to make income statement worksheet owner equity balance sheet Auran DP Tortuga End of Month 1 - 2 - Excel e Search Sarah Holden
need to make income statement worksheet
owner equity
balance sheet
Auran DP Tortuga End of Month 1 - 2 - Excel e Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments 12A A == - Wap Test Bad Goud Neutral 47 Home Insert X Cut Copy Format Panter Clipboard Iho Parte General 5 % 911 BIL- Normal Condon Tomates Calculation Furmaling - Title Check Cell === Murge & Carter - 45 Exploratory... put Insert Dela me ON Analyse F Sort & Tind Clear File - S Feng Editing Font Alq Number Cels Analys Al Tortuga Financial Services A F C . K L M N 0 P R S U V V. D WorkSheet 2 Income Statement Debit Credit Balance Sheet Debit Credit For Month Ended November 30, 2021 Trial Balance Adustments Debit Credit Debit Credit 29,629.25 220.00 2.500.00 SOD 00 100.00 2.445.00 10.00 2,000.00 99 75 1,350.00 29.629.25 220.00 2,500.00 400.00 2.435.00 1.900.25 1,350.00 18,705 00 18.705 00 3 1 Account Title 5 Cash 8 Petty Cash 9 Accounts Receivable 10 Merchandise Inventory 11 Suppies 12 Prepaid Insurance 13 Accounts Payable 14 Social Security Payable 15 Medicare Payable 16 Employee Income Tax Withheld Payable 17 FUTA Payable 18 SUTA Payable 19 Jonny Deep. Capital 20 Jonny Deeo. Drawing 21 Jack Courtau Capital z2 Jack Cousteau Drawing 23 Income Summary 24 Consulting Sales 2 Medallion Sales 26 Purchases 27 Advertising pense 28 Insurance Expense 29 Miscellaneous Expense 30 Payrol Expense 31 Payrol Taxes Expense 32 Rent Expense 39 Repair Expense 34 Suppies Expense 35 Utilities Expense 36 Total 37 5.570.00 5.570.00 1 000 00 1,000.00 200.00 200.00 100.00 100.00 9,950.00 19,930.00 9.950.00 19,930.00 2.760.00 1.000 DO 99.75 223.00 1,500.00 207.75 1.500.00 65.00 2.700.00 1,000.00 99.75 223.00 1,500 00 207.75 1,500.00 85 00 10.00 595.00 6,000 50 21.799 50 29.880.00 10.00 595.00 50,935 00 50935 00 209 75 209.7 29 880.00 42 854 5D 21.055.00 21,799.50 29.880.00 12.851.50 12.851.50 chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet + . Ready Type here to search O 11 w 10:11 AM AQ 9C Raincoming & 4* 11/1/2017 Acer I Tortuga End of Month 21 - 2 - Excel - - Search Sarah Holden SH Fle Home Insert Page Layout Formulas Data Review View Share Comments Maanda GD 18 AA = = = = Arinum Wrap Test General Bad Neutral Good F ON X Cut Copy 3 format Panter Clipboard II Paste 27 92 Sort find Anatyre File - S Normal Condona Format Calculation Furmaling - Table BIV- === 0-A- 5 % 91 Check Cell Insert Delme met Exploratory input Clear 45 E Merge Cartier Aliq Fami Number Cels Eden Salus A1 Tortuga Financial Services End of Month Assignment C D F R H ! J K M N 0 P Q R S T U V W Y Y Tortuga Financial Services - End of Month Assignment 1 2 Charl of Accounts 3 4 Balance Sheet Accounts income Statement Accounts 6 G (100) ASSETS 1400) REVENUE 7 110 Cash 410 Corcubing Balet 120 Petty Cash 420 Medalion Sales 9 130 Accounts Receivable 10 140 Merchandise Inventory 150D) EXPENSES 11 150 Supplies 505 Purchases 12 160 Prepaid CA 510 Athertising Expense 13 520 Fxpanse 14 530 Micro Experi 15 (200) LIABILITIES 533 roll Expers 16 210 Accounts Payable 535 Pyroll Tax Expense 17 220 Social Security Payable 540 Rent Expense 18 230 Medicare Payable 650 Repair Expense 19 240 Employee Income Tax Withheld Payable 660 Supplies Expense 20 250 FUTA Payable 570 Utilities Expense 21 260 SUTA Payable 22 2 2001 OWNERS COUTY 24 310 Jenny Deep, Capral 25 320 Jenny Lep, Drawing 26 330 Jack Cousteau Captal 27 340 lack Couste Crawing 78 350 Income Summary 29 30 31 ACC Receivable Lacy Accounts Payable Ledger 32 1110 Pullack 2210 Supply Hut 33 1120 Duvy ones 2220 Computer Country 2230 Executive Excursions 36 36 37 29 40 41 42 -13 44 Chart of Accounts leders worlohet income Statement Owner equity balance sheet + Ready 100 Type here to search O 11 w 1017 AM 9" Raincoming AOC 4* 1111 9& * 11/1/201 Acer I Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data REICH View Share Comments Home Insert X Cut Copy Format Panter B AA == Wrap Test General Bad Goud Neutral 27 Aurium - F Clear Paste 11 Normal Condtional Formates Calculation Furmatliny - to Tie- BI- === ON Analyse 5 - % 912 45 Merge & Carter Check Cell Exploratory input Insert Dela me Sort find File - S Clipboard Fant Alignment Number Cels Eden Analys Al F = J K K L M N () R S s T u v w X 7 A4 AR AL C ACCOUNT Cash 5 H 1 ACCOUNT NO. 110 Pa 1 BALANCE CREOT DERIT CROT 3 POST DATE ITEM DERIT 30 Balince 5 6 7 71 8 9 9 11 12 ACCOUNT Petty Cash ACCOUNT NO 120 Paan POST. BALANCE CROT DATT ITEM CREDT DERIT V ACCOUNT NO. 130 Puge PALANCE POST C- DEDIT CREDT DEDIT CRIOT 2,500.00 POST ACUUNI NU. 140 po MALAT CAEDT DEBIT CAEDT DEBIT 5X 14 New 30 Halance 15 1 16 17 ACCOUNT Accounts Receivable 19 201 DATE ITEM 21 22 Nov 30 Balance 23 21 25 ACCOUNT Merchandise Inventory 27 28 | DATE ITEM 23 30 Nov 30 balance 31 32 22 ACCOUNT Supplies 36 36 | DATE ITEM 38 cov 30 Balance 39 40 41 ACCOUNT Prepaid Insurance 43 44 DAIL ITEM +2 Chart of Accounts Ledgers Ready POST ACCOUNT NO. 150 Page BALANCE CREDT DEBIT CREDT DEBIT ACCOUNT NO 160 POST POH BALANCE CHE DEBII CHU DEBII worksheet Income Statement Owner equily balance sheet + Type here to search o E- w 7615 AM 9" Raincoming AOC 4* 11/11 9& * Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Hep Share Comments B General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard = = = = 2 Wrap Test === Mange Carta 45 F Parte horeca 47 Sort & Find File - S Normal Condtional Formates Calculation Formatting Towe (@ ON Anatyre BI- 5 % 911 Check Cell Exploratory input Insert Delme me Clear Fant Alignment Number Eden Analys A1 for F 5 H 1 J 1 K M N () R S s U v W X Y 7 A4 AR AL ACCOUNT NO. 180 Pega BALAN CRENT DERIT CREDIT 2.000.00 ACCOUNT NO. 210 Para F E 40 41 ACCOUNT Prepaid Insurance 43 POST 4 DATE ITEM ar 43 46 Sex Nov 20 Balance 30 47 48 49 ACCOUNT Accounts Payable 51 POST. LATE ITEM 23. 54 Nov 30 Balance 55 56 57 ACCOUNT Social Secunty Payable 59 POST. DATE TIEM OT BALANCE Den CREDIT CH DEBIT CREDIT 1,350.00 ACCOUNT NO. 220 Page BALANCE CREDIT DEBIT CREDIT DEHIT 93 54 55 ADCOUNT Medicare Payable ACCOUNT NO 230) Page POST. 67 68 BALANCE CREDT DATE ITEM DEBIT CREDT DEBIT 70 71 72 73 ACCOUNT Employee Income Tax Withheld Payable ACCOUNT NO 240 PO 75 76 POST SEE DALANCE DEBIT CAEDT DATE ITEM DEBIT CAEDT 78 79 81 ACCOUNT FUTA Payable ACCOUNT NO 250 Chart of Accounts Ledgers worlohet income Statement Owner equity balance sheet + Ready Type here to search O E- w 10:16 AM 9" Raincoming AOC 4* 11/1/21 & Acer I Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Insert Page Layout Formula Data REICH View Share Comments Home X Cut B AA == Wrap Test Gunara Bad Goud Neutral Iho 1 F 47 Sort find File - S (@ ON Anatyre Paste Normal Condtional Formates Calculation Furmatliny - to Tie- BI- 5 - % 912 Check Cell Exploratory input Insert Dele om Format Panter === & 45 E Merge Cartier Algnent Clear Clipar Fant Number Cels deng Analys Al 3 C D F F F - JK M N () a R S S T 1 u v w w X Y 7 A4 AR B0 81 ACCOUNT FUTA Payable ACCOUNT ND 250 Para POST. 89 34 DATE ITEM BALANCE CREDIT DEEN CRED DEBIT S. ALCULNT SUTA Payable ACCOUNT NO. 200 56 B7 58 59 91 52 90 94 9 POST. Phy BALANG CREDIT DATE ITEM DEBIT CHEDT DE HII 97 ADCOUNT Jonny Deep, Capital ACCOUNT NO 310 Page POST BALANCE 100 DATE ITEM CEDIT CREDT DEBIT CREDT IV. 102 New 10 Balance 18.00 103 104 105_ALCONY Jonny Deeo. Drawing ACCOUNT NO. 320 107 POST PALANCE 108 DAT ITEM C- CEDIT CREDT DEDIT CRIOT 10 110 Rey 30 Balance 5,580.00 111 112 113_ACCOUNT Jack Cousteau. Capital ACCOUNT NO. 330 Pega 115 POST. BALANCE 116 DATE TIEM DEBIT CREDIT DEHIT CROT 11 118 New 30 Balance 1,000.00 119 . 120 121 ACCOUNT Jack Cousteai. Drawing ACCOUNT NO 340 Pa Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet Ready Type here to search O E- 11 T + w 7015 AM 9" Raincoming AOC 4* 11/11 9& * Auran DP Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments B AA = = = Wrap Test General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard F Parte 11 Normal Condtional Formates Calculation Fumetting Table 47 Sort find a File - S (@ ON Analyse BIU. Check Cell 5 - % 912 Insert Dele om = = = = 45 Merge Cartier Exploratory... put Clear Fant Algnent Number Eden Analys Al fur F F H J J K K M M N () R S T U v W X Y 7 A4 AR Ar ACCOUNT NU, 340 POST SEE CALANCE CAEDT DEBIT CAEDT DEBIT 125 DATE 29600 ACCOUNT NO. 350 Pure 121 AUCUN ACCOUNT Jack Cousteau, Drawing 123 ITEM 125 Nov e 30 Halance 127 124 129 ACCOUNT Income Summary 131 132 DATE ITEM 134 ev 135 136 13 ALCUNI Consuting Sales 139 140 DAT ITEM POST 90 COIT BALANCE DOIT CROT CREDT ALDOUNI NU. 410 POST DALANCE CAEDT CR DEBIT CREDT 9 950.00 ACCOUNT NO 420 Pat BALANCE CREDIT CREDIT DEBIT 19.900 142 Nav 30 Halance 143 144 145 ADCOUNT Medallion Sales 147 POST. 148 | DATE ITEM 1990 150 New Balance 30 151 152 153 ACCOUNT Purchases 155 POST. 156 DATE ITEM DEBII 1571 der 158 Nov 30 Balance 159 160 161 ACCOUNT Advertising Expense 163 PUSI chart of accounts Ledgers worksheet ACCOUNT NO. 505 Poat BALANCE CREDIT CHU DEBII 250 ACCOUNT NO. 510 Pega BALANCE income Statement Owner equity balance sheet + Ready Type here to search O FI w 9" Raincoming AQ & 4x & 10:15 AM 11/1/201 Auto Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments B AA General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard = = = 2 Wrap Test === 45 E Merge Cartier 1 TH F Parte Normal Condtional Formates Calculation Fumetting Table 47 Sort find a File - S BI- 5 % 911 ON Anatyre Check Cell Exploratory... put Insert Dela me Clear Fant Alignment Number Shytes Cels deng Analys A1 M M N () R S T T 1 u v w X 7 A4 AR AL --- 1 DATE DEBIT c D F F 5 H 1 J K 160 161 ADCOUNT Advertising Expense ACCOUNT NO 510 163 POST BALANCE 164 | DATE ITEM DEBIT CREDT DEBIT CREDIT 100 165 Nev 30 Balance 103000 167 168 169 ACCOUNT Insurance Expense ACCOUNT NO. 520 171 TANCE ITEM Spa DEBIT CAEDT DEBIT CAEDT 1/4 Ney 175 176 111AECOUNT Miscelaneous Expense ACCOUNT NO 530) Page 179 POST BALANCE 100 DATE ITEM DEBIT CREDIT CREDIT 182 30 Balance Nov 183 184 185 ACCOUNT Payroll Expense ACCOUNT NO. 533 187 POST BALANCT 188 DATE ITEM CEDIT CREDT DEDIT CRIOT 189 190 X 30 Halance v 1550 191 192 193 ACCOUNT Payrolls Expense ACCOUNT NO. 535 Page 195 PUSI. BALANCE 196 DATE ITEM DERIT CREOT DERIT CROT 190 New 30 Balance 201.13 199 200 201 ACOUNT Rent Expense ACCOUNT NO. 510 Pue 1 Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet Ready Type here to search O E- 11 + w 9C Raincoming A D & 4* F 10:16 AM " & 11/1/201 Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data REICH View Share Comments Home Insert X Cut In Copy 3 format Panter B AA Gunara Bad Goud Neutral Iho == Wrap Test === 45 E Merge Carter F II Paste 47 Sort find a File - S Normal Condtional Formates Calculation Fuum.lling to Tie- BIL- 5 % 911 Check Cell ON Anatyre Exploratory... put Insert Delme me Clear Clipar Fant Algnent Number Shytes Cels deng Analys Al F F 5 H JK M N () R S u v w X Y 7 A4 AR Al ACCOUNT NO. 540 Pro POST BALANCE CREDT DEGIT CREDT DEDIT 1.500.00 ACCOUNT NO. 550 ABC D 199 200 201 ACCOUNT Rent Expense 203 204 | DATE ITEM 2 U 200X30 Balance 207 200 209_ACCOUNT Repair Expense 211 213 DATE ITEM 214 New 30 Halance 215 216 21 ACCOUNT Supplies Expense 219 220 DATE ITEM 22 222 223 POST Pega CALANCE CREDT DEBIT CAEDT DEBIT 35.00 ACCOUNT NO. 580 Pure POST ar BALANCE CROT ACCOUNT NO 570 Peoa POST DES CALANC DEBIT CREDIT DEBIT CREDT Tas 225 ACCOUNT Utilities Expense 227 220 DATE ITEM 2 730 Nov 30 Halance 231 232 233 ACCOUNTS RECEIVABLE LEDGER 234 235 ACCOUNT Pearl Black 237 238 DATE ITEM 239 210 Nov HT 30 Balance ACCOUNT NO 1140 Page POST DEBIT BALANCE DEBIT CREDT CREDT Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet + Ready E Type here to search O E- w 10:15 AM 9" Raincoming AOC 4* 11/12 9& * Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Home Insert Page Layout Formula Data REICH View Share Comments B General Bad Goud Neutral 27 O X Cut Copy 3 format Panter Clipboard === Wrap Test ==== 45 E Merge & Cartier F 1 Parte @ ON Analyse Normal Condona Tomatx Calculation Fumetting - Table 5 % 913 BI- Check Cell Insert Delmem Exploratory input Clear Sort Find File - S Edit ng Font Alqent Number Styles Cels Analys Al L M N () R S T U v w W X Y 7 A4 AR Ar. COST A 3 B c F F 5 H J 2411 248 New 30 Balance 249 250 251 ACCOUNTS PAYABLE LEDGER 252 253ACCOUNT Supply Hut ACCOUNT NO 2210 Para 255 POST BALANCE 256 DATE ITEM DEBI CREDI DEBIT CREDI 258 Nov 30 Balance 650.00 259 260 261 ACCOUNT Computer Country ACCOUNT NO. 2220 Page 263 POST BALANCE 264 DATE ITEM DEBIT CREDT DEBIT 205 266 Ny 30 Balance 267 268 269 ACCOUNT Executive Excursions ACCOUNT NO. 2230 271 POST. BALANCE DATE ITEM DEBIT CHELT DEBIT CREDIT 212 i . 270 Nes 30 Balance 330.00 775 276 277 278 279 280 ai 781 202 283 284 205 286 787 Chart of Accounts Ledgers worksheet Income Statement Owner equity balance sheet Ready 212 + Type here to search O 11 w 10:16 AM 9C Raincoming AD * 11/20 " & 4x Auran DP Tortuga End of Month 1 - 2 - Excel e Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments 12A A == - Wap Test Bad Goud Neutral 47 Home Insert X Cut Copy Format Panter Clipboard Iho Parte General 5 % 911 BIL- Normal Condon Tomates Calculation Furmaling - Title Check Cell === Murge & Carter - 45 Exploratory... put Insert Dela me ON Analyse F Sort & Tind Clear File - S Feng Editing Font Alq Number Cels Analys Al Tortuga Financial Services A F C . K L M N 0 P R S U V V. D WorkSheet 2 Income Statement Debit Credit Balance Sheet Debit Credit For Month Ended November 30, 2021 Trial Balance Adustments Debit Credit Debit Credit 29,629.25 220.00 2.500.00 SOD 00 100.00 2.445.00 10.00 2,000.00 99 75 1,350.00 29.629.25 220.00 2,500.00 400.00 2.435.00 1.900.25 1,350.00 18,705 00 18.705 00 3 1 Account Title 5 Cash 8 Petty Cash 9 Accounts Receivable 10 Merchandise Inventory 11 Suppies 12 Prepaid Insurance 13 Accounts Payable 14 Social Security Payable 15 Medicare Payable 16 Employee Income Tax Withheld Payable 17 FUTA Payable 18 SUTA Payable 19 Jonny Deep. Capital 20 Jonny Deeo. Drawing 21 Jack Courtau Capital z2 Jack Cousteau Drawing 23 Income Summary 24 Consulting Sales 2 Medallion Sales 26 Purchases 27 Advertising pense 28 Insurance Expense 29 Miscellaneous Expense 30 Payrol Expense 31 Payrol Taxes Expense 32 Rent Expense 39 Repair Expense 34 Suppies Expense 35 Utilities Expense 36 Total 37 5.570.00 5.570.00 1 000 00 1,000.00 200.00 200.00 100.00 100.00 9,950.00 19,930.00 9.950.00 19,930.00 2.760.00 1.000 DO 99.75 223.00 1,500.00 207.75 1.500.00 65.00 2.700.00 1,000.00 99.75 223.00 1,500 00 207.75 1,500.00 85 00 10.00 595.00 6,000 50 21.799 50 29.880.00 10.00 595.00 50,935 00 50935 00 209 75 209.7 29 880.00 42 854 5D 21.055.00 21,799.50 29.880.00 12.851.50 12.851.50 chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet + . Ready Type here to search O 11 w 10:11 AM AQ 9C Raincoming & 4* 11/1/2017 Acer I Tortuga End of Month 21 - 2 - Excel - - Search Sarah Holden SH Fle Home Insert Page Layout Formulas Data Review View Share Comments Maanda GD 18 AA = = = = Arinum Wrap Test General Bad Neutral Good F ON X Cut Copy 3 format Panter Clipboard II Paste 27 92 Sort find Anatyre File - S Normal Condona Format Calculation Furmaling - Table BIV- === 0-A- 5 % 91 Check Cell Insert Delme met Exploratory input Clear 45 E Merge Cartier Aliq Fami Number Cels Eden Salus A1 Tortuga Financial Services End of Month Assignment C D F R H ! J K M N 0 P Q R S T U V W Y Y Tortuga Financial Services - End of Month Assignment 1 2 Charl of Accounts 3 4 Balance Sheet Accounts income Statement Accounts 6 G (100) ASSETS 1400) REVENUE 7 110 Cash 410 Corcubing Balet 120 Petty Cash 420 Medalion Sales 9 130 Accounts Receivable 10 140 Merchandise Inventory 150D) EXPENSES 11 150 Supplies 505 Purchases 12 160 Prepaid CA 510 Athertising Expense 13 520 Fxpanse 14 530 Micro Experi 15 (200) LIABILITIES 533 roll Expers 16 210 Accounts Payable 535 Pyroll Tax Expense 17 220 Social Security Payable 540 Rent Expense 18 230 Medicare Payable 650 Repair Expense 19 240 Employee Income Tax Withheld Payable 660 Supplies Expense 20 250 FUTA Payable 570 Utilities Expense 21 260 SUTA Payable 22 2 2001 OWNERS COUTY 24 310 Jenny Deep, Capral 25 320 Jenny Lep, Drawing 26 330 Jack Cousteau Captal 27 340 lack Couste Crawing 78 350 Income Summary 29 30 31 ACC Receivable Lacy Accounts Payable Ledger 32 1110 Pullack 2210 Supply Hut 33 1120 Duvy ones 2220 Computer Country 2230 Executive Excursions 36 36 37 29 40 41 42 -13 44 Chart of Accounts leders worlohet income Statement Owner equity balance sheet + Ready 100 Type here to search O 11 w 1017 AM 9" Raincoming AOC 4* 1111 9& * 11/1/201 Acer I Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data REICH View Share Comments Home Insert X Cut Copy Format Panter B AA == Wrap Test General Bad Goud Neutral 27 Aurium - F Clear Paste 11 Normal Condtional Formates Calculation Furmatliny - to Tie- BI- === ON Analyse 5 - % 912 45 Merge & Carter Check Cell Exploratory input Insert Dela me Sort find File - S Clipboard Fant Alignment Number Cels Eden Analys Al F = J K K L M N () R S s T u v w X 7 A4 AR AL C ACCOUNT Cash 5 H 1 ACCOUNT NO. 110 Pa 1 BALANCE CREOT DERIT CROT 3 POST DATE ITEM DERIT 30 Balince 5 6 7 71 8 9 9 11 12 ACCOUNT Petty Cash ACCOUNT NO 120 Paan POST. BALANCE CROT DATT ITEM CREDT DERIT V ACCOUNT NO. 130 Puge PALANCE POST C- DEDIT CREDT DEDIT CRIOT 2,500.00 POST ACUUNI NU. 140 po MALAT CAEDT DEBIT CAEDT DEBIT 5X 14 New 30 Halance 15 1 16 17 ACCOUNT Accounts Receivable 19 201 DATE ITEM 21 22 Nov 30 Balance 23 21 25 ACCOUNT Merchandise Inventory 27 28 | DATE ITEM 23 30 Nov 30 balance 31 32 22 ACCOUNT Supplies 36 36 | DATE ITEM 38 cov 30 Balance 39 40 41 ACCOUNT Prepaid Insurance 43 44 DAIL ITEM +2 Chart of Accounts Ledgers Ready POST ACCOUNT NO. 150 Page BALANCE CREDT DEBIT CREDT DEBIT ACCOUNT NO 160 POST POH BALANCE CHE DEBII CHU DEBII worksheet Income Statement Owner equily balance sheet + Type here to search o E- w 7615 AM 9" Raincoming AOC 4* 11/11 9& * Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Hep Share Comments B General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard = = = = 2 Wrap Test === Mange Carta 45 F Parte horeca 47 Sort & Find File - S Normal Condtional Formates Calculation Formatting Towe (@ ON Anatyre BI- 5 % 911 Check Cell Exploratory input Insert Delme me Clear Fant Alignment Number Eden Analys A1 for F 5 H 1 J 1 K M N () R S s U v W X Y 7 A4 AR AL ACCOUNT NO. 180 Pega BALAN CRENT DERIT CREDIT 2.000.00 ACCOUNT NO. 210 Para F E 40 41 ACCOUNT Prepaid Insurance 43 POST 4 DATE ITEM ar 43 46 Sex Nov 20 Balance 30 47 48 49 ACCOUNT Accounts Payable 51 POST. LATE ITEM 23. 54 Nov 30 Balance 55 56 57 ACCOUNT Social Secunty Payable 59 POST. DATE TIEM OT BALANCE Den CREDIT CH DEBIT CREDIT 1,350.00 ACCOUNT NO. 220 Page BALANCE CREDIT DEBIT CREDIT DEHIT 93 54 55 ADCOUNT Medicare Payable ACCOUNT NO 230) Page POST. 67 68 BALANCE CREDT DATE ITEM DEBIT CREDT DEBIT 70 71 72 73 ACCOUNT Employee Income Tax Withheld Payable ACCOUNT NO 240 PO 75 76 POST SEE DALANCE DEBIT CAEDT DATE ITEM DEBIT CAEDT 78 79 81 ACCOUNT FUTA Payable ACCOUNT NO 250 Chart of Accounts Ledgers worlohet income Statement Owner equity balance sheet + Ready Type here to search O E- w 10:16 AM 9" Raincoming AOC 4* 11/1/21 & Acer I Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Insert Page Layout Formula Data REICH View Share Comments Home X Cut B AA == Wrap Test Gunara Bad Goud Neutral Iho 1 F 47 Sort find File - S (@ ON Anatyre Paste Normal Condtional Formates Calculation Furmatliny - to Tie- BI- 5 - % 912 Check Cell Exploratory input Insert Dele om Format Panter === & 45 E Merge Cartier Algnent Clear Clipar Fant Number Cels deng Analys Al 3 C D F F F - JK M N () a R S S T 1 u v w w X Y 7 A4 AR B0 81 ACCOUNT FUTA Payable ACCOUNT ND 250 Para POST. 89 34 DATE ITEM BALANCE CREDIT DEEN CRED DEBIT S. ALCULNT SUTA Payable ACCOUNT NO. 200 56 B7 58 59 91 52 90 94 9 POST. Phy BALANG CREDIT DATE ITEM DEBIT CHEDT DE HII 97 ADCOUNT Jonny Deep, Capital ACCOUNT NO 310 Page POST BALANCE 100 DATE ITEM CEDIT CREDT DEBIT CREDT IV. 102 New 10 Balance 18.00 103 104 105_ALCONY Jonny Deeo. Drawing ACCOUNT NO. 320 107 POST PALANCE 108 DAT ITEM C- CEDIT CREDT DEDIT CRIOT 10 110 Rey 30 Balance 5,580.00 111 112 113_ACCOUNT Jack Cousteau. Capital ACCOUNT NO. 330 Pega 115 POST. BALANCE 116 DATE TIEM DEBIT CREDIT DEHIT CROT 11 118 New 30 Balance 1,000.00 119 . 120 121 ACCOUNT Jack Cousteai. Drawing ACCOUNT NO 340 Pa Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet Ready Type here to search O E- 11 T + w 7015 AM 9" Raincoming AOC 4* 11/11 9& * Auran DP Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments B AA = = = Wrap Test General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard F Parte 11 Normal Condtional Formates Calculation Fumetting Table 47 Sort find a File - S (@ ON Analyse BIU. Check Cell 5 - % 912 Insert Dele om = = = = 45 Merge Cartier Exploratory... put Clear Fant Algnent Number Eden Analys Al fur F F H J J K K M M N () R S T U v W X Y 7 A4 AR Ar ACCOUNT NU, 340 POST SEE CALANCE CAEDT DEBIT CAEDT DEBIT 125 DATE 29600 ACCOUNT NO. 350 Pure 121 AUCUN ACCOUNT Jack Cousteau, Drawing 123 ITEM 125 Nov e 30 Halance 127 124 129 ACCOUNT Income Summary 131 132 DATE ITEM 134 ev 135 136 13 ALCUNI Consuting Sales 139 140 DAT ITEM POST 90 COIT BALANCE DOIT CROT CREDT ALDOUNI NU. 410 POST DALANCE CAEDT CR DEBIT CREDT 9 950.00 ACCOUNT NO 420 Pat BALANCE CREDIT CREDIT DEBIT 19.900 142 Nav 30 Halance 143 144 145 ADCOUNT Medallion Sales 147 POST. 148 | DATE ITEM 1990 150 New Balance 30 151 152 153 ACCOUNT Purchases 155 POST. 156 DATE ITEM DEBII 1571 der 158 Nov 30 Balance 159 160 161 ACCOUNT Advertising Expense 163 PUSI chart of accounts Ledgers worksheet ACCOUNT NO. 505 Poat BALANCE CREDIT CHU DEBII 250 ACCOUNT NO. 510 Pega BALANCE income Statement Owner equity balance sheet + Ready Type here to search O FI w 9" Raincoming AQ & 4x & 10:15 AM 11/1/201 Auto Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data Review View Share Comments B AA General Bad Goud Neutral Home Insert X Cut Copy 3 format Panter Clipboard = = = 2 Wrap Test === 45 E Merge Cartier 1 TH F Parte Normal Condtional Formates Calculation Fumetting Table 47 Sort find a File - S BI- 5 % 911 ON Anatyre Check Cell Exploratory... put Insert Dela me Clear Fant Alignment Number Shytes Cels deng Analys A1 M M N () R S T T 1 u v w X 7 A4 AR AL --- 1 DATE DEBIT c D F F 5 H 1 J K 160 161 ADCOUNT Advertising Expense ACCOUNT NO 510 163 POST BALANCE 164 | DATE ITEM DEBIT CREDT DEBIT CREDIT 100 165 Nev 30 Balance 103000 167 168 169 ACCOUNT Insurance Expense ACCOUNT NO. 520 171 TANCE ITEM Spa DEBIT CAEDT DEBIT CAEDT 1/4 Ney 175 176 111AECOUNT Miscelaneous Expense ACCOUNT NO 530) Page 179 POST BALANCE 100 DATE ITEM DEBIT CREDIT CREDIT 182 30 Balance Nov 183 184 185 ACCOUNT Payroll Expense ACCOUNT NO. 533 187 POST BALANCT 188 DATE ITEM CEDIT CREDT DEDIT CRIOT 189 190 X 30 Halance v 1550 191 192 193 ACCOUNT Payrolls Expense ACCOUNT NO. 535 Page 195 PUSI. BALANCE 196 DATE ITEM DERIT CREOT DERIT CROT 190 New 30 Balance 201.13 199 200 201 ACOUNT Rent Expense ACCOUNT NO. 510 Pue 1 Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet Ready Type here to search O E- 11 + w 9C Raincoming A D & 4* F 10:16 AM " & 11/1/201 Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Page Layout Formula Data REICH View Share Comments Home Insert X Cut In Copy 3 format Panter B AA Gunara Bad Goud Neutral Iho == Wrap Test === 45 E Merge Carter F II Paste 47 Sort find a File - S Normal Condtional Formates Calculation Fuum.lling to Tie- BIL- 5 % 911 Check Cell ON Anatyre Exploratory... put Insert Delme me Clear Clipar Fant Algnent Number Shytes Cels deng Analys Al F F 5 H JK M N () R S u v w X Y 7 A4 AR Al ACCOUNT NO. 540 Pro POST BALANCE CREDT DEGIT CREDT DEDIT 1.500.00 ACCOUNT NO. 550 ABC D 199 200 201 ACCOUNT Rent Expense 203 204 | DATE ITEM 2 U 200X30 Balance 207 200 209_ACCOUNT Repair Expense 211 213 DATE ITEM 214 New 30 Halance 215 216 21 ACCOUNT Supplies Expense 219 220 DATE ITEM 22 222 223 POST Pega CALANCE CREDT DEBIT CAEDT DEBIT 35.00 ACCOUNT NO. 580 Pure POST ar BALANCE CROT ACCOUNT NO 570 Peoa POST DES CALANC DEBIT CREDIT DEBIT CREDT Tas 225 ACCOUNT Utilities Expense 227 220 DATE ITEM 2 730 Nov 30 Halance 231 232 233 ACCOUNTS RECEIVABLE LEDGER 234 235 ACCOUNT Pearl Black 237 238 DATE ITEM 239 210 Nov HT 30 Balance ACCOUNT NO 1140 Page POST DEBIT BALANCE DEBIT CREDT CREDT Chart of Accounts Ledgers worksheet income Statement Owner equity balance sheet + Ready E Type here to search O E- w 10:15 AM 9" Raincoming AOC 4* 11/12 9& * Auriin PH Tortuga End of Month 1 - 2 - Excel Search Sarah Holden SH Fle Home Insert Page Layout Formula Data REICH View Share Comments B General Bad Goud Neutral 27 O X Cut Copy 3 format Panter Clipboard === Wrap Test ==== 45 E Merge & Cartier F 1 Parte @ ON Analyse Normal Condona Tomatx Calculation Fumetting - Table 5 % 913 BI- Check Cell Insert Delmem Exploratory input Clear Sort Find File - S Edit ng Font Alqent Number Styles Cels Analys Al L M N () R S T U v w W X Y 7 A4 AR Ar. COST A 3 B c F F 5 H J 2411 248 New 30 Balance 249 250 251 ACCOUNTS PAYABLE LEDGER 252 253ACCOUNT Supply Hut ACCOUNT NO 2210 Para 255 POST BALANCE 256 DATE ITEM DEBI CREDI DEBIT CREDI 258 Nov 30 Balance 650.00 259 260 261 ACCOUNT Computer Country ACCOUNT NO. 2220 Page 263 POST BALANCE 264 DATE ITEM DEBIT CREDT DEBIT 205 266 Ny 30 Balance 267 268 269 ACCOUNT Executive Excursions ACCOUNT NO. 2230 271 POST. BALANCE DATE ITEM DEBIT CHELT DEBIT CREDIT 212 i . 270 Nes 30 Balance 330.00 775 276 277 278 279 280 ai 781 202 283 284 205 286 787 Chart of Accounts Ledgers worksheet Income Statement Owner equity balance sheet Ready 212 + Type here to search O 11 w 10:16 AM 9C Raincoming AD * 11/20 " & 4x
Step 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