Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View General - T H LÀ E B < Autosum Á * Cut La Copy Paste - Format Painter Clipboard Times New Rom 12 - A A BI U DA ♡ - Wrap Text a Merge & Center Alignment Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear Sort & Filter Editing Find & Select Font Number Cells fic F11 ДА ID F G H I J CC 3 Date Credit Debit $ 37,000.00 General Journal 1-Mar Merchandise Inventory Accounts Payable-Van Industries (Amount of merchandise Purchased on account from Van Industries) 37,000.00 $ 14,800.00 2-Mar Accounts receivable Sales Revenue Amount of sales on credit to Min Cho against inv.no.854) 14.800.00 $ 7,400.00 7,400.00 2-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 15 16 3 Mar(3a) Office Supplies 17 Accounts Payable 18 (Amount of Supplies purchased from Gabel Company) IS 1.110.00 1.110.00 19 S 7,400.00 21 3 Mar(36) 22 22 ► Sheet1 Ready Accounts receivable Sales Revenue (Amount of sales on credit to Linda Witt against int no 855) Sheet2 Sheet3 7,400.00 OD A 100% u ENG - 0 12:15 27-02-2020 2 . Type here to search O W
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View General - T H LÀ E B < Autosum Á * Cut La Copy Paste - Format Painter Clipboard Times New Rom 12 - A A BI U DA ♡ - Wrap Text a Merge & Center Alignment Conditional Format Formatting as Table Styles Cell Styles Insert Delete Format 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 с F G H I А 20 21 3 Mar(36) S 7,400.00 Accounts receivable Sales Revenue (Amount of sales on credit to Linda Witt against inv.no.855) 7,400.00 S 3,700.00 3-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 3,700.00 $ 72,000.00 6-Mar Cash Notes Payable Amount borrowed from bank against Notes Payable) 72,000.00 S 18,500.00 9-Mar Office Equipment Accounts Payable (Amount of Office Equipment Purchased from Spell Supply) 18,500.00 $ 3.700.00 10-Mar Accounts receivable Sales Revenue (Amount of sales on credit to Jovita Albany against inv.no.856) 3.700.00 41 42 $ 1,850.00 10-Mar Cost of goods sold | Merchandise Inventory Sheet1 Sheet2 Sheet3 1.850.00 Ready BOU 100% ve A O ENG 0 12:15 27-02-2020 2 + . Type here to search W
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General - T H LÀ E B < Autosum Á Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells fic F11 А F G H I J S 1.850.00 10-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 1,850.00 S $ 13,720.00 280.00 14,000.00 48 12-Mar Cash=($14000*98%) Sales Discount=($14000*29) Accounts Receivable Amount Received from Nin Cho, after allowing 2% Sales Discount) 49 50 13 Mar(a) Accounts Payable Cash (37000*98%) Merchandise Inventory=($37000*2%) 53 (Amount Paid after receiving 2% discount) $ 37,000.00 36.260.00 740.00 52 55 13 Mar (6) S S 7.252.00 148.00 Cash=($7400*98%) Sales Discount=($7400*2%) Accounts Receivable (Amount received from Linda Vitt) 7,400.00 $ 28,000.00 14-Mar Merchandise nventory Accounts Payable-CD Company | Amount of merchandise Purchased) Sheet1 Sheet2 Sheet3 61 62 28,000.00 Ready + BOU 100% 0 ^ ENG 27-02-2020D Type here to search
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut B General AutoSum" 21 Times New Rom 12 - A A BI U DA h Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 с F G H I $ 28,000.00 14-Mar Merchandise nventory Accounts Payable-CD Company (Amount of merchandise Purchased) 28,000.00 $ 15,900.00 64 15 Mar (a) 65 66 Sales Salaries Expenses Cash (Amount of Half months Salary Paid) 15,900.00 67 68 69 15 Mar (b) $ 59,200.00 Cash Sales Revenue (Amount of cash sales) 59,200.00 $ 47,360.00 15-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 47,360.00 $ 1.630.00 16-Mar Store Supplies Accounts Payable-Gabel Company (Amount of merchandise Purchased from Gabel company) 1,630.00 1.030.00 80 81 17-Marl Accounts Pavable-CD company Sheet1 Sheet2 Sheet3 IS 2.800.00 Ready BOU 100% 0 + Type here to search A 3 ENG 12:16D 27-02-2020
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy General - T H LÀ E B Times New Rom 12 - A A BI U DA < Autosum Fill Á Z Paste ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 - F G H I 81 $ 2.800.00 82 17-Mar Accounts Payable-CD company Merchandise Inventory (Amount of Goods returned) 2.800.00 S 555.00 86 19-Mar Accounts Payable-Spell Company Office Equipment (Amount of returned of office Equipment) 555.00 S IS 3,626.00 74.00 20-Mar Cash=($3700*98%) Sales Discount=($3700*2%) Accounts Receivable (Amount of cash received from Jovita Albany) 3,700.00 $ 25,200.00 23-Mar Accounts Payable-CD Company=($28000-$2800) Cash=($25200*98%) Merchandise Inventory=($25200*29) (Amount paid to CD Company after adjusting return of $2800 and Discount of 2%) 24.696.00 504.00 S 11,100.00 27-Mar Accounts receivable Sales Revenue (Amount of sales on credit to Jovida Albany against inv.no.857 11,100.00 101 102 Sheet1 Sheet2 Sheet3 Ready BOU 100% rue A ENG 0 12:16 + . S Type here to search 27-02-2020
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General - T H LÀ E B < Autosum Á Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells fic F11 А F G H I J 102 103 $ 4,440.00 104 27-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 4.440.00 S 4.440.00 108 109 28-Mar Accounts receivable Sales Revenue (Amount of sales on credit to Linda Vitt against inv.no.858 4.440.00 111 112 $ 1.776.00 28-Mar Cost of goods sold Merchandise Inventory (Amount of cost of goods sold) 1.776.00 114 115 116 S 15,900.00 Sales Salaries Expenses Cash (Amount of Sales Salaries for half Month) 15,900.00 117 31 Mar (a) 118 119 120 121 31 Mar (b) 122 123 124 Sheet1 Ready S 65,120.00 Cash Sales Revenue (Amount of cash sales) 65,120.00 Sheet2 Sheet3 BOU 100% rue A ENG 0 12:16 + S. Type here to search 27-02-2020
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General - T H LÀ E B < Autosum Á Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells - F11 А C F G H I 124 125 126 $ 39,072.00 31-Mar Cost of goods sold Merchanise Inventory (Amount of cost of goods sold) 39,072.00 129 Merchandise Inventory $ 60,000.00 To Balance B/d $ 7.400.00 3,700.00 1,850.00 740.00 47,360.00 2.800.00 504.00 4.440.00 1.776.00 39,072.00 15.358.00 1.25,000.00 $ S $ $ $ S $ $ S $ 136 138 139 140 By Bal cd $ 60,000.00 Total 141 Total 144 Sales Revenue Amount $ 1,65,760.00 Account Head To Balance Cld Account Head 145 Amount $ 14,800.00 To 700 an Sheet1 Sheet2 Sheet3 Ready O 100% 0 12:16 27-02-2020 2 Type here to search A O ENG
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy General 1 - AutoSumA Times New Rom 12 - A A BI U DA Paste ♡ - Wrap Text a Merge & Center Alignment conditional sobre es un insert bei Conditional Format Formatting as Table Styles Insert Delete Format Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Number Cells - F11 А F G H I J 143 144 145 146 Account Head Sales Revenue Amount $ 1,65,760.00 Account Head To Balance Cld 147 Amount $ 14.800.00 $ 7.400.00 $ 3,700.00 $ 59,200.00 $ 11,100.00 S 4.440.00 $ 65.120.00 S 1.65,760.00 Total $ 1,65,760.00 Total Account Head Account Head By Balance Cld Amount $ 1.05,598.00 Cost of goods sold Amount $ 7,400.00 $ 3,700.00 $ 1.850.00 $ 47,360.00 $ 4.440.00 $ 1.776.00 $ 39,072.00 $ 1,05,598.00 162 Total Total S 1,05,598.00 164 Sheet1 Sheet2 Sheet3 Ready OD A 100% ENG - 0 12:16 27-02-2020 Type here to search
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General 1 - AutoSumA Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 А E F G H I JE 165 166 Account Head Account Head 167 168 Accounts Receivable Amount $ 14,800.00 $ 7,400.00 $ 3,700.00 $ 11,100.00 $ 4,440.00 169 170 Amount $ 13,720.00 $ 280.00 $ 7,252.00 S 148.00 $ 3,626.00 74.00 S 16,340.00 S 41.440.00 171 By Bal cd Total Total $ 41.440.00 Account Head Office Supplies Amount Account Head $ 1.110.00 By Bal Cld Amount $ 1,110.00 179 Total JS 1.110.00 Total S 1.110.00 Account Head Account Head Accounts Payable Amount S 36,260.00 $ 740.00 S 2.800.00 Amount $ 37,000.00 $ 1,110.00 $ 18,500.00 185 186 Sheet1 Sheet2 Sheet30 1 Ke Ready O 100% u ENG 0 12:16 27-02-2020 Type here to search A O W .
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General 1 - AutoSumA Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 А c F G H I J 182 183 Account Head Account Head Accounts Payable Amount $ 36,260.00 $ 740.00 $ 2.800.00 $ 555.00 $ 24.696.00 $ 504.00 $ 20,685.00 Amount $ 37,000.00 $ 1.110.00 $ 18,500.00 S 28.000.00 $ 1.630.00 186 188 189 190 To Bal Cld 191 192 Total $ 86,240.00 Total S 86.240.00 193 Cash Alc Account Head Amount Account Head $ 13,720.00 $ 72,000.00 $ 7.252.00 $ 59,200.00 $ 3,626.00 By Balance cd $ 65,120.00 Amount S 36.260.00 $ 24.696.00 $ 15,900.00 $ 15,900.00 $ 1.28.162.00 198 199 201 202 203 $ 2.20.918.00 $ 2,20,918.00 Total Sheet2 Sheet1 Sheet3 Ready OD 100% - 0 12:16 Type here to search A ' ENG 27-02-2020 0
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy General Times New Rom 12 - A A BI U DA ♡ - Wrap Text a Merge & Center Alignment - tod. T H LÀ E B Conditional Format set insert Delete Format < Autosum 2 clear Á Sort & Find a Paste Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Number Cells - fie F11 А D E F G H I JE 204 205 Notes Payable Amount $ 72,000.00 Account Head To Balc/d Account Head Amount $ 72,000.00 209 Total $ 72,000.00 S 72.000.00 210 212 Account Head Office Equipment Amount $ 18,500.00 Account Head Amount $ 555.00 S 17.945.00 $ 18,500.00 By Bal Cld 215 Total $ 18,500.00 Account Head Sales Discount Amount Account Head 280.00 By Bal Cld S 148.00 S 74.00 Amount S 502.00 Total S 502.00 502.00 224 225 Sheet1 Sheet2 Sheet3 Ready 0 + BO A 100% ENG N 12:16 Type here to search 27-02-2020
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Copy General - T H LÀ E B < Autosum Á Times New Rom 12 - A A BI U DA Paste ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Number Cells - F11 А F G H I JE Account Head Sales Salaries Expenses Amount Account Head $ 15,900.00 By Bal c/d $ 15,900.00 Amount $ 31,800.00 229 230 Total IS 31 800 00 S 31,800.00 Account Head Store Supplies Amount Account Head $ 1.630.00 By Bal cd TA Amount $ 1.630.00 S 16 238 Total $ 1.630.00 S 1.630.00 239 Trial Balance Credit Account Title Cash Accounts Receivable Merchandise Inventory Office Supplies Store Supplies Sheet2 Sheet3 Debit $ 1.28.162.00 $ 16,340.00 $ 15,358.00 $ 1,110.00 S 1.630.00 245 246 Sheet1 1 No Ready OD 100% - 0 Type here to search A PENG 12:16 27-02-2020
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General 1 - AutoSumA Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 А - for F G H I J Trial Balance 241 Credit 243 Debit $ 1,28,162.00 $ 16,340.00 $ 15,358.00 $ 1.110.00 $ 1.630.00 $ 17,945.00 245 246 247 Account Title Cash Accounts Receivable Merchandise Inventory Office Supplies Store Supplies Office Equipment Accounts Payable Notes Payable Z.Church Capital Cost of goods sold Sales Revenue Sales Salaries Sales Discount 248 20.685.00 72,000.00 60,000.00 $ 1,05,598.00 1,65,760.00 $31.800.00 S 502.00 Total S 3,18.445.00 S 3.18.445.00 258 259 Accounts Receivable Ledger Jovita Albany Debit 260 Date Account Title Credit Balance Le 2700.00 K Sheet1 Sheet2 Sheet3 Ready OD A 100% rue ENG - 0 12:16 27-02-2020 2 S. Type here to search O
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General 1 - AutoSumA Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Conditional Format Formatting as Table Styles conditional fo Cell Styles Insert Delete Format se nse Insert 2 Clear Sort & Filter Editing Find & Select Font Number Cells fic F11 A E F G H I J 258 259 Accounts Receivable Ledger Jovita Albany Debit $ 3.700.00 260 Date Credit 262 Account Title 10-Mar 20-Mar 20-Mar 27-Mar Balance $ 3,700.00 3,626.00 S 74.00 74.00 S S 11,100.00 263 264 $ 11,100.00 265 266 267 Date Min Cho Debit Credit $ 14,800.00 269 Explanation 02-Mar Sales Revenue 12-Mar Cash 12-Mar Sales Discount Balance $ 14,800.00 $ 1.080.00 S 800.00 13,720.00 280.00 271 272 Linda Witt 274 Date Credit Debit S 7,400.00 275 276 277 Explanation 03-Mar Sales Revenue 13-Mar Cash 13-Mar Sales Discount 28-Mar Sales Revenue Balance $ 7,400.00 7,252.00S 148.00 148.00 S S 4.440.00 S 4.440.00 278 279 Sheet1 Sheet2 Sheet3 0 Ready BOU 100% rue A O ENG 0 12:16 27-02-2020 2 + . Type here to search S W
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View Σ AutoSumΑ. * Cut Copy General Times New Rom 12 - A A BI U DA Paste ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles Format Painter Clipboard 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 fic C D E F G H I J 280 281 282 Date Accounts Payable Ledger CD Company Debit Credit 284 Explanation 14-Mar Inventory 17-Mar Inventory 23-Mar Cash 23-Mar Purchase Discount Balance 28,000.00 $ 28,000.00 $ 25,200.00 $ 504.00 285 286 $ 2.800.00 S 24.696.00 S 504.00 287 Gabel Company 288 289 Date Credit 290 291 Explanation 03-Mar Office Supplies 16-Mar Store Supplies Debit S 1.110.00 S 1.630.00 Balance S 1.110.00 $ 2.740.00 293 Van Industries Date Debit Credit 295 296 Explanation 01-Mar Inventory 13-Mar Cash 13-Mar Purchase Discount Balance 37,000.00 $ 37,000.00 S 740.00 $ S S 36.260.00 740.00 297 298 299 Spell Supply Debit Credit 300 Date 301 Explanation 09-Mar Office Equipment Sheet1 Sheet2 Sheet3 Balance 18,500.00 S 18,500.00 Ready BOU 100% ^4 = ENG N 0 12:17. 27-02-2020 + a. Type here to search
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut Σ AutoSumΑ. General Times New Rom 12 - A A BI U DA Paste E Copy Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells fic F11 A E F G H I J 298 299 Spell Supply Debit Credit 300 Date 301 Explanation 09-Mar Office Equipment 19-Mar Office Equipment Balance 18,500.00 $ 18,500.00 $ 17.945.00 302 S 555.00 303 304 305 Church Company Schedule of Accounts Receivable March 31st 307 308 309 310 311 Jovita Albany Linda Witt Min Cho Total Accounts Receivable $ $ $ $ 11,100.00 4.440.00 800.00 16,340.00 312 313 315 316 Church Company Schedule of Accounts Payable March 31st 317 318 $ S 2,740.00 CD Company Gabel Company Van Industri Sheet2 Sheet3 319 220 Sheet1 Ready OD ^ 100% - 0 ENG 27-02-2020 Type here to search D.
Book1 - Microsoft Excel - 2 X Home Insert Page Layout Formulas Data Review View * Cut General - T H LÀ E B Times New Rom 12 - A A BI U DA < Autosum Fill Á Z E Copy Paste Format Painter Clipboard ♡ - Wrap Text a Merge & Center Alignment Insert Delete Format Conditional Format Formatting as Table Styles Cell Styles 2 Clear Sort & Filter Editing Find & Select Font Number Cells F11 А F G H I J 303 304 305 306 Church Company Schedule of Accounts Receivable March 31st 307 308 309 310 Jovita Albany Linda Witt Min Cho Total Accounts Receivable $ $ $ $ 11,100.00 4.440.00 800.00 16,340.00 311 312 314 315 Church Company Schedule of Accounts Payable March 31st 316 317 318 2,740.00 $ $ 319 320 CD Company Gabel Company Van Industry Spell Supply Total Accounts Payable 321 $ $ 17.945.00 20.685.00 322 323 324 325 Sheet1 Sheet2 Sheet3 Ready OD ^ 100% - 0 ENG 27-02-2020D Type here to search