Create a completed Adjusting Journal Entrie, the Worksheet with the Trial balance and adjustements and Adjusted Trial Balance Column with totals for all columns.

At the end of January, the following additional information is available to help determine what adjustments are needed: Amount 31-Jan Supplies were counted at month end 31-Jan One month of the services for Stanley Inc. has been performed (see above) 31-Jan One month of interest has accrued on the note payable for the bank loan. 43 44 45 5670 46 47 6580 950 31-Jan Additional work for customers has been performed during the last week of January but not billed yet 31-Jan One month of the prepaid rent has been used up 21. Depreciation expense needs to be recognized for the computer equipment and for the office furniture 31-Jan Salaries are paid every Friday (for a 5 day work week). January 31, 2019 was a Thursday 190 off fium 49 165 comp equip 4,650 File Paste Home Insert Page Layout Formulas Data of cut Times New Ro - 12 AA == > PWrap Text General Copy Format Painter B TUU A . E32Merge & Center - $ % Clipboard Font Alignment Numbe - X for C D ADJUSTING JOURNAL ENTRIES - SeeGoin Consulting Inc DATE ACCOUNT DEBIT CREDIT ES H I J K L M ADJUSTMENTS ADJUSTED TRIAL BALANCE DEBIT CREDIT DEBIT CREDIT D E F G Torksheet - SeeGoin Consulting Inc UNADJUSTED TRIAL NUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT 74,410 37,150 125,760 22,560 19,650 2,910 9,562 19.422 11,400 11,400 35,000 36,500 8,590 8,590 9.860 9,562 9,562 13,200 30,000 13,200 30,000 160.000 1.000 1.000 34120 34,120 4 650 4.650 statements worksheet formulas financial statement formu... A BEGINNING NUMBERS ADJUSTMENTS DE DIE CREDIT STED TRAIN WLANCE DEBIT CREDIT ACCOUNT DERIT CREDIT 500 Cash 5 Accounts Receivable 6 Supplies Worksheet SeeCoin Cong Inc JANINY UNADJUSTED TRIAL ENTRIES FALANCE DEBIT CREDIT DEBIT CREDIT 74.410 37.150 125 MIO 22.50 19.650 2,910 9.52 19.422 11.00 11400 35 000 MO SINO 35 000 36,500 Land 9 Computer Equipment 10 Accumud Deprecision, Comp Equip 11 Office Furniture 12 Accumulated Depreciation Of Fum 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Uneamed Revenue 17 Long termes Payable 10 Common Stock 19 Retained amnings 20 Didends 21 Service Revenge 13200 ADJUSTING CLOSING JE Worksheet statements Worksheettomas financial statement form B TU U A . Merge center %100 + Formatting Table Format Painter Clipboard Font Alignment - Numbers BEGINNING NUMBERS Worksheet - SeeGoin Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE 8,590 8,590 ADJUSTMENTS ADJUSTED TRIAL BALANCE 9,860 9,860 9,562 9,562 13 200 30 000 13200 30,000 160,000 160.000 71 Office Furniture 12 Accumulated Depreciation, Off Fur 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Unearned Revenue 17 Long term Notes Payable 18 Common Stock 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salaries Expense 23 Rent Expense 24 Supplies Expense 25 Utos Exponse 20 Interest Expense 27 Depreciation Expense Comp Equip 20 Depreciation Expense Office Furniture 1.000 1,000 34120 34, 120 4 650 4650 1.650 100.000 100.000 143,682 143.602 240802 2 46382 Paste Copy Check Cel 20 Sarata Seydi - Project 1 Part 1 ACC3010 Tuesday.xlsx - Excel File Home Insert Page Layout Formulas _Data Review View Tell me what you want to do Times New Ro - 9 AA . Wrap Text D Normal Bad Good Format Painter BIU. . .A. Esa . Merge & Center - % Conditional Format as Neutral Calculation Formatting - Table Clipboard Alignment Styles 077 1X - A D E F During January, the first month of operations, the following transactions occurred: 27 Date Event Amount Amount 28 1-Jan Paid for 12 months rent on office space 11.400 29 3-Jan Purchased additional office supplies on account. 9,562 30 4-Jan Purchased office furniture. 8,590 Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be 31 8-Jan paid back in 5 years 30,000 loan amt 0.02 interest ra 32 10-Jan Paid for utilities. 1,650 33 14-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months 13,200 34 15-Jan Performed services for various customers for cash and on account. 11,560 cash 22560 on accoun 35 26-Jan Paid the bill for supplies purchased previously. 9,860 36 28-Jan Paid salaries to employees for 1 week. 4,650 37 29-Jan Dividends were declared and paid. 1,000 38 31-Jan Collected payments for amounts previously billed. 19,650 Copy BIU-- A-EE e Paste Merge & Center - $ - % Format Painter Clipboard Alignment Num! Font 119 - X V for CREDIT DATE 1-Jan JOURNAL ENTRIES - SeeGoin Consulting Inc ACCOUNT DEBIT Prepaid Rent 11400 Cash (To record rent paid in advance) 11400 7 3-Jan 9562 Supplies Accounts Payable (To record purchase of supplies) 9562 4-Jan 8590 Office Furniture Cash (To record purchase of furniture) 8590 14 15 8-Jan 30000 Cash Long-term Notes Payable (To record amount borrowed) 30000 10-Jan 1650 Utilities Expense Cash (To record payment of utilities expense) 1650 23 14-Jan Cash Unearned Revenue InfoJ ADJUSTING JE 13200 13200 Worksheet statements worksheet formu CLOSING JE Home Insert Page Layout % Cut Geneva 09 Copy Format Painter BIU Clipboard Font X for Formulas Data AA == . A a Review View Tell me what you want to > PWrap Text General Merge & Center - $ % Alignment Numt 13200 Unearned Revenue (To received services provided) 11560 22560 15-Jan Cash Accounts Receivable Service Revenue (To record service provided) 34120 9860 26-Jan Accounts Payable Cash (To record bill paid) 9860 4650 28-Jan Salaries Expense Cash (To record salaries paid) 4650 1000 29-Jan Dividends Cash (To record Dividend 1000 19650 31-Jan Cash Accounts Receivable (To record cash received) 19650 Into E ADJUSTING JE CLOSING JE_Worsheet statements worksheet om