Hi, can you help me with the adjusting entries and adjusting trial balance in the worksheet? I already did the adjusting journal entries but I don't know how to put them in the worksheet. Like how the adjusting journal entries are gonna affect the unadjusted trial balance?

docs.google.com C LacusCurtius . Allen's Star N... ACCT 3220 Winter 2020 CS... Homework Help - Q&A from... Course List ~ Lyryx Learning... Introduction to Financial Acc... bad debt expense journal en... how to screen shot macbok... ACCT 3220 Winter 2020 CSL Unadjusted Trial Balance .XLSX + EE Share C File Edit View Insert Format Data Tools Help All changes saved in Drive 100% * $ % .0_ .00 123 Arial 11 . BISA . 3 fx G H K M N 0 P Q R S 1 Adjusting Journal Entries 2 3 Date Accounts Debit Credit 4 1 31-Oct Cost of Goods Sold 10,000 5 Inventory 10,000 6 tion, To adjust inventory for expired inventory 2 31-Oct Accounts Payable 35,000 Inventory 35,000 9 To adjust inventory 10 3 31-Oct Prepaid Insurance 8,750 11 Insurance Expense 8,750 12 charge - $720 To adjust for Unexpired Insurance 13 4 31-Oct Depreciation Expense 118,500 14 Merchandise Inventory 80,000 15 Accumulated Depreciation -Warehouse Equipment 25.000 16 Accumulated Depreciation -Office and Selling Equipment 13,500 17 To record Depreciation 18 5 31-Oct-20 Accounts Receivable 1,500 19 Cash 1,500 20 To record NSF Cheque returned 21 6 31-Oct-20 Office & Administrative Expense (720+50) 770 22 Cash 770 23 To record bank charges and fees 24 7 31-Oct-19 Cash 3,150 25 Accounts Receivable 3, 150 26 To record the cash received by EFT 27 8 31-Oct-19 Bad Debt Expense (Sales&W.H Expense) 17,051 28 Allowance for uncollectible accounts 17,051 29 To record Allowance for uncollectible accounts 30 9 31-Oct-19 Dividends 150,000 31 Dividends Payable $3 x 50,000 150,000 32 To record Dividends Pavahle + student worksheet 2018 FS 1 Journal Entries Bank Reconciliation Statement Financial Statements + Exploredocs.google.com C LacusCurtius . Allen's Star N... ACCT 3220 Winter 2020 CS... Homework Help - Q&A from... Course List ~ Lyryx Learning... Introduction to Financial Acc... bad debt expense journal en... how to screen shot macbok... ACCT 3220 Winter 2020 CSL Unadjusted Trial Balance .XLSX * + EE Share C File Edit View Insert Format Data Tools Help All changes saved in Drive 100% * $ % .0_ .00 123 Arial 11 . B IS A Q B 3 = I HVV C + Y - E - 8 1 1 fx F G H M N 0 P Q R 27 8 31-Oct-19 Bad Debt Expense (Sales&W.H Expense) 17,051 28 Allowance for uncollectible accounts 17,051 29 To record Allowance for uncollectible accounts 30 9 31-Oct-19 Dividends 150,000 31 Dividends Payable $3 x 50,000 150,000 32 To record Dividends Payable 33 10 31-Oct-19 Interest Expense 39, 146 34 Discount on Bond Payable 4,146 35 Interest Payable 35,000 36 To accrue Interest Payable on the Bond 37 11 31-Oct-19 Interest Expense 32,000 38 Interest Payable 800,000 x 4% 32,000 39 To accrue Interest Payable on the Note 40 41 42 43 44 45 46 47 48 58 + student worksheet 2018 FS 1 Journal Entries Bank Reconciliation Statement Financial Statements 1 + ExploreA B C D E Little Rock Ltd. Worksheet At October 31, 2019 Unadjusted Trial Balance DEBIT CREDIT Cash $25,300 Accounts receivable $885,500 Prepaid insurance $8,200 Inventory $628,800 Buildings $2,000,000 Warehouse equipment $751,000 Accumulated depreciation $154,200 Office and storage equipment $320,000 Accumulated depreciation $30,000 Accounts payable $535,382 Bonds payable $869,921 Bank loan $800,000 Common shares $500,000 Common Shares receivable - Dad $90,000 Retained earnings $1,036,847 Sales $6,707,000 Cost of goods sold $3,831,350 Insurance expense $15,000 Sales and warehouse salaries $833,000 Sales bonus $30,000 Office and administrative expenses $210,000 Distribution & warehouse expenses $1,022,800 Gain on sale of office equipment $2,000 Interest expense $35,000 $10,660,650 $10,660,650