. X AutoSum - Fill - Insert Delete Format 2 Clear Sort & Find & Filter Select Editing Cells Q R S S T V w Cash Sales $3,500 - Cla TheBrightSpot_Week2_All_nls_1-5 August.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 Wrap Text General E) Copy Paste BI U .00 Merge & Center $ - % Conditional Format Format Painter Cell .00 0 Formatting as Table Styles Clipboard Font Alignment Number Styles J9 B C D E F G H L L M N o P 1 TASK 2 Parti) WEEK 2 2 Record the following transactions in the appropriate journals. Remember. Bright Spot CREDIT SALE TERMS are 2/10, n/30. 3 DAILY TRANSACTIONS IN DATE ORDER 4 Aug. 1 Rec'd supplier invoice from Aladdin Ltd for inventory, $8,500, terms 2/14, n30, freight CASH RECEIPTS JOURNAL 5 $150 COD. Issued cheque #451 to Fast Freight Ltd. for freight charges DEBITS CREDITS 6 Rec'd supplier invoice from The Rubber Barons for office supplies, $45, terms n30. Date Account Bank Disc. Allow Sales A/Rec's 7 Sales for the day were: 8 Cash $1,200 9 2 Light Fantasy 10 P. Hogan $650 11 11 Rec'd cheque from customer A. McConnell. Invoice issued on July 23 for $255 12 Aug. 2 Rec'd supplier invoice from Baker Supplies for inventory, $750, terms n/30. Issued 13 10 cheque #452 for $50 freight charges to Star Express 14 14 Rec'd cheques from customers W. Harrigan Invoice issued on July 25 for $375 and 15 13 B. Yang Invoice issued on July 16 for $350 16 Paid suppliers. Beacon Ltd (terms 2/5, n30) with Ch# 453 on invoice dated July 28 17 17 for $2,000. Also paid Cable Kings (terms 2/10, n30) with Chq#454 on invoice Progress totals 18 dated July 27 for $3,500 u 19 Aug. 3 Sales for the day were: CASH PAYMENTS JOURNAL 20 Cash Sales $2,330 DEBITS CREDITS 21 J Roberts $700 Date Account Cheque # Other Acc's A/Payable Bank 22 PTsu $3,000 incl. $30 delivery charge 23 Aug. 4 Paid suppliers. Aladdin Ltd (terms 2/14, n30) with Chq# 455 on invoice dated July 21 24 for $4,500. Also paid Phullops Lamps (terms 2/10,n30) with Chq#456 on invoice 25 dated July 26 for $3,000 26 Aug. 5 Rec'd cheque from customer Roberts. Invoice issued on July 27 for $175 27 Sales for the day were: 28 Cash Sales $2,450 29 N Smith $4,500 incl. $45 delivery charge 30 31 Progress totals KI Task 2 Week 2 Ready Disc. Rec'd BO. 80% - U TheBrightSpot_Week2_All_nls_1-5 August.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View AutoSum - Fill - 9 Insert Delete Format 2 Clear Sort & Find & Filter Select- Editing Cells Q R S S v w % Cut Calibri - 11 - AA Wrap Text General Ea Copy Paste BIU Merge & Center $ - % 4.0.09 Conditional Format Format Painter Cell .00 .0 Formatting as Table Styles Clipboard Font Alignment Number Styles J9 fic B C D E F F G . 1 L M N o P 25 dated July 26 for $3,000 26 Aug. 5 Rec'd cheque from customer Roberts. Invoice issued on July 27 for $175 27 Sales for the day were: 28 Cash Sales $2,450 29 N Smith $4,500 incl. $45 delivery charge 30 31 Progress totals 32 33 PURCHASE JOURNAL 34 Inv Date Account name Terms Purchases A/Payable 35 36 37 38 Progress totals 39 40 SALES JOURNAL 41 Inv Date Account name Sales Deliv. Exp A/Receivable 42 12 43 44 AE 45 46 47 48 Progress totals 20 49 50 51 51 52 53 54 54 55 56 Task 2 Week 2 Ready 3O 80% W+ . X AutoSum - Fill - Insert Delete Format 2 Clear Sort & Find & Filter Select Editing Cells Q R S S T V w Cash Sales $3,500 - Cla TheBrightSpot_Week2_All_nls_1-5 August.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View * Cut Calibri 11 Wrap Text General E) Copy Paste BI U .00 Merge & Center $ - % Conditional Format Format Painter Cell .00 0 Formatting as Table Styles Clipboard Font Alignment Number Styles J9 B C D E F G H L L M N o P 1 TASK 2 Parti) WEEK 2 2 Record the following transactions in the appropriate journals. Remember. Bright Spot CREDIT SALE TERMS are 2/10, n/30. 3 DAILY TRANSACTIONS IN DATE ORDER 4 Aug. 1 Rec'd supplier invoice from Aladdin Ltd for inventory, $8,500, terms 2/14, n30, freight CASH RECEIPTS JOURNAL 5 $150 COD. Issued cheque #451 to Fast Freight Ltd. for freight charges DEBITS CREDITS 6 Rec'd supplier invoice from The Rubber Barons for office supplies, $45, terms n30. Date Account Bank Disc. Allow Sales A/Rec's 7 Sales for the day were: 8 Cash $1,200 9 2 Light Fantasy 10 P. Hogan $650 11 11 Rec'd cheque from customer A. McConnell. Invoice issued on July 23 for $255 12 Aug. 2 Rec'd supplier invoice from Baker Supplies for inventory, $750, terms n/30. Issued 13 10 cheque #452 for $50 freight charges to Star Express 14 14 Rec'd cheques from customers W. Harrigan Invoice issued on July 25 for $375 and 15 13 B. Yang Invoice issued on July 16 for $350 16 Paid suppliers. Beacon Ltd (terms 2/5, n30) with Ch# 453 on invoice dated July 28 17 17 for $2,000. Also paid Cable Kings (terms 2/10, n30) with Chq#454 on invoice Progress totals 18 dated July 27 for $3,500 u 19 Aug. 3 Sales for the day were: CASH PAYMENTS JOURNAL 20 Cash Sales $2,330 DEBITS CREDITS 21 J Roberts $700 Date Account Cheque # Other Acc's A/Payable Bank 22 PTsu $3,000 incl. $30 delivery charge 23 Aug. 4 Paid suppliers. Aladdin Ltd (terms 2/14, n30) with Chq# 455 on invoice dated July 21 24 for $4,500. Also paid Phullops Lamps (terms 2/10,n30) with Chq#456 on invoice 25 dated July 26 for $3,000 26 Aug. 5 Rec'd cheque from customer Roberts. Invoice issued on July 27 for $175 27 Sales for the day were: 28 Cash Sales $2,450 29 N Smith $4,500 incl. $45 delivery charge 30 31 Progress totals KI Task 2 Week 2 Ready Disc. Rec'd BO. 80% - U TheBrightSpot_Week2_All_nls_1-5 August.xlsx - Microsoft Excel Home Insert Page Layout Formulas Data Review View AutoSum - Fill - 9 Insert Delete Format 2 Clear Sort & Find & Filter Select- Editing Cells Q R S S v w % Cut Calibri - 11 - AA Wrap Text General Ea Copy Paste BIU Merge & Center $ - % 4.0.09 Conditional Format Format Painter Cell .00 .0 Formatting as Table Styles Clipboard Font Alignment Number Styles J9 fic B C D E F F G . 1 L M N o P 25 dated July 26 for $3,000 26 Aug. 5 Rec'd cheque from customer Roberts. Invoice issued on July 27 for $175 27 Sales for the day were: 28 Cash Sales $2,450 29 N Smith $4,500 incl. $45 delivery charge 30 31 Progress totals 32 33 PURCHASE JOURNAL 34 Inv Date Account name Terms Purchases A/Payable 35 36 37 38 Progress totals 39 40 SALES JOURNAL 41 Inv Date Account name Sales Deliv. Exp A/Receivable 42 12 43 44 AE 45 46 47 48 Progress totals 20 49 50 51 51 52 53 54 54 55 56 Task 2 Week 2 Ready 3O 80% W+