Create a complete journal entrie, the worksheet through the trial balance with all totals for columns, and the worksheet formulas tab through the Trial Balance.
3 . A. Merge Center - $ - %. Conditional Formatas Check Call Delon Clear Sort & fi very CDF You have been hired as an accountant for SecGoin Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for Secoin Consulting Inc. resulted in the balances that are included in the first 2 columns of the Worksheet (see the worksheet tab) M. Amount Amount 11,400 9,562 8,590 During January, the first month of operations, the following transactions occurred: Date Event 1-Jan Paid for 12 months rent on office space 3-Jan Purchased additional office supplies on account 4-Jan Purchased office furniture. 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 32 10-Jan Paid for utilities. 33 14-Jan Received cash in advance from Stanley Inc. for work to be performed over the next 12 months. 34 15-Jan Performed services for various customers for cash and on account. 35 26-Jan Paid the bill for supplies purchased previously 36 28-Jan Paid salaries to employees for 1 week 37 29-Jan Dividends were declared and paid 38 31-Jan Collected payments for amounts previously billed. 0.02 interest rate 30,000 loan amt 1.650 13,200 11,560 cash 9,860 4,650 1,000 19,650 22560 on account At the end of January, the following additional information is available to help determine what adiustments are needed: info JE ADJUSTING JE CLOSING E Worksheet statements worksheet formas 958P Sex Wil Review come Insert Insert Page Layout Page Lay Formulas Data Times New Ro - 12 = B IU. . .A. Project 1 ACC3010 Tuesday.xlsx - Excel View Tell me what you want to do PWrap Text General I D Normal Merge & Center - $ - % , Conditional Format as Neutral Formatting Table- Algement Number 5 sy - 1 x ment Recovery covered the following fies. See with to keep CREDIT 2 JOURNAL ENTRIES - SeeGoin Consulting Inc ACCOUNT DEBIT Rent Expense 11400 DATE Files de Shannon 1 ML ersion rated from the last 16019 924 AM Tudtshan 1 an Versione last time the us 09 12:10 PM pinakita hrysler.co Version created last time theus 2019 945 AM Tarda sharan Version created from the last 1 w a Shannon 2019 17:10 PM e n created from the last 5/2012 into E ADJUSTING JE CLOSING JE Worksheet statements or het tomas Review sout Formulas Data 10 KA== - 6.A. Font Accents Project 1 ACC3010 Tuesday.xlsx - Excel View Tell me what you want to do... PWrap Text General . D Accenta Merge & Center - $ -% Conditional Format as Comma * Formatting Table Comma [0] Styles Number Alignment A BEGINNING DEBIT NUMBERS CREDIT Worksheet - SeeGoin Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE DEBIT CREDIT DEBIT CREDIT ACCOUNT 9860 35 000 36.500 9.860 5 Accounts Receivable 6 Supplies 7 Prepaid Rent 8 Land 9 Computer Equipment 10 Accumulated Depreciation, Comp Equip 11 Office Furniture 12 Accumulated Depreciation off Furn 13 Accounts Payable 14 Salaries Payable 15 Interest Payable 16 Uneamed Revenue 17 Long-term Notes Payable 18 Common Stock 19 Retained Earnings 20 Dividends 21 Service Revenue 22 Salaries Expense 23 Rent Expenso infoJE ADJUSTING JE 160 000 CLOSING JE Worksheet statements worksheet formulas fi
