attached was the journal entries and then all info from january. i am needing the general ledger for febuary, the trial balance and adjusted trial balance, balance sheet, income statement,ect.

My Place, House of Dcor MANUAL INSTRUCTIONS FOR FEBRUARY 1) Joumalize the transactions listed below and on the next page and post to the ledger accounts. Omit explanations. 2) Prepare an unadjusted trial balance. 3) Journalize the adjusting entries and post to the general ledger, Adjustment data are provided on the next page. 4) Prepare an adjusted trial balance. 5) Prepare a schedule of accounts receivable 6) Prepare an income statement for the two months ended February 28, 20Y8. If not completing the optional requirements below, use only the year-to-date amount column to complete your statement Optional: Prepare the statement for both the month of February and the year to date. Balances in the income and expense accounts currently reflect year-to-date activity. Complete the year-to-date income statement first. To calculate February figures, subtract January figures (from last month's income statement) from the year-to-date figures. Optional: Include vertical analysis figures in the statement by calculating the percent of cach line item to total revenue Note: If working the set with the general ledger software, the generated statement will auto- matically include monthly and year-to-date figures and include percentages for vertical analysis. 7) Prepare a retained caring statement for the two months ended February 28, 20Y8. 8) Prepare a balance sheet as of February 28, 20Y8 9) Complete the analysis test for February on page 37 GENERAL LEDGER SOFTWARE INSTRUCTIONS Follow the instructions on page 2 of this booklet Detailed instructions for this month are available in the general ledger software by clicking the Instructions button near the bottom of your screen. (Note that you may have to scroll down and over to see this button.) TRANSACTIONS FOR FEBRUARY Feb General Entries Issued Check No. 109 for $3.500 for the current month's advertising 6 Issaed Check No. 110 for $2,000 for February office rent. 7 Received $10,300 from Premet Comp for decorating services performed throughout its office building 33 27 Feb. 11 Received $6,000 from Maribel Thompson for decorating services performed January 12 on account. 15 Received $4,800 from Floyd and Peterson Law Firm for services performed to decorate its conference room. 22 Received $8,000 from Roberto Andriani for decorating services performed January 25 on account. Customer decided to pay part of the debt ahead of time. 25 Redecorated the restaurant facilities of Riviera's Caf on account for $11,500 (net 60). 27 Issued Check No. 111 for $225 to pay the utilities bill for the month. Issued Check No. 112 for $350 in payment of the telephone bill for the month. 27 Issued Check No. 113 for $230 for postage. 27 Issued Check No. 114 for $500 for business automobile expenses. 27 Issued Check No. 115 for $5,600 to Sophia LeBron for salary. (Payroll taxes are nor con- sidered in this entry. Transactions in later months will show you how to journalize payroll tax deductions and expenses.) Adjusting Entries a) Expired insurance for the period, $500. b) Supplies on hand at the end of the month, $675. E F G H B JOURNAL Page Post Ref. Credit Description ate EB Debit 5,500 5,500 4 Advertising Expense Cash 2,000 6 Rent Expense Cash 2,000 10,300 7 Cash Service Revenue 10,300 6,000 11 Cash Accounts Receviable 6,000 4,800 15 Cash Service Revenue 4,800 8,000 22 Cash Accounts Receviable 8,000 11,500 25 Account Receviable Service Revenue 11,500 27 Utilities Expense Cash 225 225 27 Telephone Expense Cash 350 350 27 Postage Expense Shanti Journal entry 230.00 D E F B 11,500 25 Account Receviable Service Revenue 11,500 225 27 Utilities Expense Cash 225 350 27 Telephone Expense Cash 350 7 230.00 27 Postage Expense Cash 230.00 500.00 A 27 Auto Expense Cash 500.00 5600.00 27 Salary Expense Cash 5600.00 Adjusting Entries a insurance Expense Prepaid insurance 500.00 500.00 325.00 b supplies Expense Supplies + EPIC 325.00 Sheet1 Journal entry General Ledger Balance Post Ref Date Debit Credit Debit Account 1001 Petty Cash Credit 1002 Cash J1 60,000.00 J1 J1 6,000.00 6,000.00 1,600.00 7,000.00 J1 J1 J1 5-Jan 5-Jan 6-Jan 7-Jan 7-Jan 10-Jan 20-Jan 30-Jan 30-Jan 30-Jan 30-Jan 30-Jan 10,000.00 8,000.00 60,000.00 54,000.00 48,000.00 46,400.00 39,400.00 49,400.00 57,400.00 57,210.00 56,910.00 56,710.00 56,260.00 50,660.00 J1 J1 J1 J2 J2 J2 190.00 300.00 200.00 450.00 5,600.00 7 3 3 . 1 2 3 4 Edit Excel File View Insert Format Tools Data Window Help GL Solution Jan AutoSave Home Insert Review Page Layout Draw Formulas Data View X 29 11 Calibri (Body) A A General Paste BIU a A $ % ) 28 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. B16 x f fo C D E G H F Balance 1 General Ledger Date Debit Credit 2 Account 3 1004 Accounts Receivable Post Ref 12.Jan 25 Jan Credit 11 6,000.00 31 12,000.00 Debit 6,000,00 18,000.00 5 6 7 9 10 11 12 13 14 15 16 17 IB 19 20 23 22 24 25 1001 1002 1004.1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 Edit View Tools Data Excel File Window Help Insert Format SU GLSolutionJan AutoSave Draw Home Insert Page Layout Formulas Data Review View | 22 A 11 General Calibri (Body) BIU AA Paste $ %) $ A1 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates oxfx General Ledger A 1 General Ledger Post Ref D F G Balance Date Debit Credit Debit Credit 2 Account a 1008 Estimated Returns Inventory 5 7 1.600.00 9 1009 Supplies 10 11 12 13 7-an 31 Jan 13 J2 Adjusting 1.600.00 1,000.00 600.00 15 16 17 18 15 20 1011 Prepaid insurance 21 22 23 6,000.00 adjusting 5 Tan 31 Jan 31 12 500.00 6,000.00 5.500.00 25 1001, 1002 1004, 1005, 1007 100 1024 2001 - 2020 3001 - 3010 40014002 Excel Window Help File Edit View insert Format Tools Data AutoSave Au. Insert Draw Page Layout Formulas Data GLSolution jan Home Review View Calibri (Body) 11 con APA General For Paste $ %) $328 Cel Office Update To keep up-to-date with security updates, fores, and improvements, choose Check for Updates ASO Ax fx TA C 0 F H 25 26 27 28 1013 Prepaid Rent 29 6-Jan 1 2,000.00 2,000.00 10 31 32 1015 Deposits 6-Jan 13 2.000.00 2,000.00 33 14 25 1020 Land 35 17 38 1023 Furniture and Fixtures 39 40 41 1024 Accumulated Depreciation 42 83 14 45 47 45 49 50 1001 1002 1004 1005, 1007 100 1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 Data Window Help Excel File Edit View Insert Format Tools AutoSave ore u Home Insert Draw Page Layout Formulas GL Solution.Jan Data Review View Til Calibri (Body) 11 ' ' General lo Paste BIU A 2 $ %) Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates Al 4 x fc General Ledger TA D E F G H 1 General Ledger Balance Post 2 Account Date Rer Debit Credit Debit Credit 3 2001 Accounts Payable 4 5 6 7 & 9 10 11 12 13 2002 Notes Payable 14 15 16 17 2003 Salaries Pavable 10 20 21 2004 Cash Dividends Payable 22 24 2005 FICAT Payable 1001 1002 1004.1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001-2002 Excel File Edit View Innert Format Tools Data Window Help AutoSave CE GLSolutionJan Home Insert Draw Page Layout Formulas Data Review View Calibr (Body 11 A 4 General Cend Form Paste BTU D $%$## INS Cels Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates, A53 4 xfx A B c 29 30 2006 SUTA Tax Payable 32 3a 34 2007 FUTA Tax Payable 35 16 38 2008 WH income Tax Payable 39 40 31 42 200) Income Tax Payable 43 44 45 2010 Customers Refunds Payable 45 47 48 49 50 55 2020 Notes Payable.Long Term 52 53 1001, 1002 1004, 1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 PC Excel File Edit View Insert Format Tools Data Window Help AutoSave GLSolutionJan Home Insert Draw Page Layout Formulas Data Review View X Calibrl (Body) 11 AA General Paste BTU a. Av $ % ) Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates J15 x x A B D E F H 1 General Ledger Balance Post 2 Account Date Hef Debit Credit Debit Credit 33001 Common Stock 4 5 11 60,000.00 60,000.00 5 6 7 3007 Retained Earnings B 9 10 11 3008 Cash Dividends 12 13 14 15 3010 Income Summary 16 12 18 19 20 23 24 35 1001, 1002 1004, 1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 EPIC Excel File Edit View Insert Format Tools Data Window Halo AutoSave GL Solutionjon Home Insert Draw Page Layout Formulas Data Review View 11 A A 29 General Calibr (Body BTW Paste = = = -A- Condit Tome 2 Cells $ % 9 M Office Update To keep up to date with security updates, from, and improvements, choose Check for Updates C1 x fx C G A General Ledger ce 2 Account 4001 Decorating fees Post Me Debt Credit Debit Credit 10 ja 12 Jan 20 Jan 25 Jan It 11 JI 10,000.00 5.000.00 3.000.00 12,000.00 10,000.00 16,000.00 24,000.00 36,000.00 2 1 9 10 11 12 13 14 15 16 17 19 10 1001 1002 1004, 1000, 1007 1000 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 Data Window Help ExcolFile Edit View Insert Format Tools AutoSave na 5.5. Home Insert Draw Page Layout Formulas GL SolutionJan Data View Review 2 Calibrl (Body) 11AA General Il lil 19 Paste B I U OA $ % ) Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates F1 1 x fe Balance A B C D H 1 General Ledger Balance Post 2 Account Date Red Debit Credit Debit Credit 3 5001 Cost of Goods Sold 4 5 6 2 8 9 10 11 30-lanz 5.600.00 5.600.00 13 14 5004 Salaries Expense 15 16 17 18 19 20 21 22 21 SOOS Rent Expense 24 25 1001 1002 2.000.00 2.000.00 1004, 1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001 - 4002 Excel File Edit View insert Format Tools Data Window Help AutoSave GL SolutionJan Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) X LG 11 23 A A Accounting Pasta $ % Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates F48 x fx A B C D E F G H 23 5005 Rent Expense 24 6-Jan 31 2,000.00 2.000.00 25 25 27 28 30 11 32 5006 Advertising Expense 7-Jan 11 7,000.00 7,000.00 34 35 36 37 39 40 41 5002 Automobile Expense 30 Jan 12 450.00 450.00 44 45 1001, 1002 1004, 1005. 1007 1038-1024 2005 - 2020 3001 - 3010 4001 - 4002 Excel File Edit View Tools Data Window Help Insert Format a su AutoSave GLSolutionJan Home Insert Draw Page Layout Formulas View X Callbr (Body) Data Review 23 " 11 Accounting III Paste $ % ) AIN Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates F75 x fx B D E F G H 31 Jan 2 600.00 600.00 50 51 5008 Supplies Bxpense 52 Adjusting 53 54 55 SG 57 58 59 50 61 62 635009 Insurance Expense 54 Adjusting 65 66 67 31-Jan 12 500.00 500.00 69 70 1 72 5010 Utilities spense 22 24 75 1001, 1002 30-Jan 190.00 190.00 1004, 1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 Excel Dota Window Help File Edit View Insert Format Tools AutoSave @yu. Insert Draw Page Layout Formulas GL SolutionJan Home Data Review View Calibri (Body) 11 29 General Paste a. A- Hill $ % ) Office Update To keep up to date with security updates, fores, and improvements, choose Check for Updates F96 ex fe A B C D E 0 71 72 5010 Utilities Expense 73 30 Jan 11 190.00 190.00 74 75 75 77 79 BO 81 5011 Telephone Expense 30 Jan 1 300.00 300.00 53 84 85 86 87 88 89 90 93 92 93 94 95 56 1001, 1002 1004, 1005, 1007 1008 1024 2001 - 2020 3001 - 3010 4001 4002 Data Window Help GLSolutionJan Excol File Edit View Insert Format Tools AutoSave ABSU. Home Insert Draw Page Layout Formulas or View Calibel (Body! 11 A A General Data Review = = 25 = = P AD Condition Format Call Style Paste BTU A $ %) 828 a Office Update To keep up to date with security updates, foces, and improvements, choose Check for Updates 11 ex fe A 3 c G 1 General Ledger Balance Post 2 AM Date Debit Credit Debit Credit 5012 Postage pense 30-an 22 200.00 5 7 1 10 12 13 14 5013 Depreciation Expense 15 15 17 19 5014 Dues and subcription Dipense 20 21 22 SOLS Uncollectible ecounts pense 23 13 1001 1002 1004, 1005, 1007 1003-10 2001 - 2020 3001 23010 4001 - 2002 5001 Excel File Edit View Insert Format Tools Window Data Help Jan AutoSave Insert Draw Home Page Layout Formulas Data Review View Calibri (Body) 11 A X LG General Paste BIU A V $ % 4 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Up F19 4 x fx A B C D E F G H My Place House of Dcor 2 Unadjusted Trial Balance 31-Jan-20 Acct Account No. Debit Credit 5. Cash 1002 50,660.00 6 Accounts Receivable 1004 18,000.00 7 Supplies 1009 1,600.00 8 Prepaid Insurance 1011 6,000.00 9. Prepaid Rent 1013 2,000.00 10 Deposits 1015 2,000.00 11 Common Stock 3001 60,000.00 12 Decorating Fees 4001 36,000.00 13 Salaries Expense 5004 5.600.00 14 Rent Expense 5005 2,000.00 15 Advertising Expense 5006 7,000.00 16 Automobile Expense 5007 450.00 17 Utilities Expense 5010 190.00 18 Telephone Expense 5011 300.00 19 Postage Expense 5012 200.00 20 96,000.00 96,000.00 21 25 Jounal Entries Unadjusted Trial Bandu Adjusted a Bwancu Schedule Excel file Edit View Insert Format Tools Data Window Help AutoSave Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 2 11 ' ' General ilil Paste B 1 a. Av $ % HI 4 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for A19 XV fx Utilities Expense A D E F G H My Place House of Dcor 2. Unadjusted Trial Balance 3 31-Jan-20 Acct Account No. Debit Credit 5 Cash 1002 50,660.00 6 Accounts Receivable 1004 18,000.00 7 Supplies 1009 1,000.00 8 Prepaid Insurance 1011 5,500.00 9 Prepaid Rent 1013 2,000.00 10 Deposits 1015 2,000.00 11 Common Stock 3001 60.000.00 12 Decorating Fees 4001 36,000.00 13 Salaries Expense 5004 5,600.00 14 Rent Expense 5005 2,000.00 15 Advertising Expense 5006 7,000.00 16 Automobile Expense 5007 450.00 17 Supplies Expense 500R 600.00 18 Insurance Expense 5009 500.00 19 Utilities Expense 15010 190.00 20 Telephone Expense 5011 300.00 21 Postage Expense 5012 200.00 22 96,000.00 96,000.00 23 25 Journal Entries Undjusted Trial Balance Adjusted Trial Balance Sche Excel File Edit View Insert Format Tools Data Window Help AutoSave Ja Home Insert Draw Page Layout Formulas Data Review View X lb Calibri (Body 11 - A A AA- Paste BIU Accounting $ % == += Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for L B6 xfx 12000 A B c D E F H My Place, House of Dcor 2 Schedule of Accounts Receivable 3 31-Jan-20 4 5 Maribel Thompson $ 6,000.00 6. Roberto Andriani 12,000.00 7 Total Accounts Receivable $ 18,000.00 8 9 10 11 12 13 14 16 17 18 19 20 21 22 23 24 25 26 Journal Entries FC Unadjusted Trial Balance Adjusted Trial Balance Sched Data Window Help Excel File Edit View Insert Format Tools AutoSave orts. Home Insert Draw Page Layout Formulas X Calibri (Body) 11 AA Data Review View Genera Paste BIU a. Av $ Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check Xv fx My Place, House of Dcor A1 D G My Place, House of Dcor Income Statement For the Month Ended January 1, 2020 $ 26,000.00 5 Decorating Fees 6 Expenses: 7 Salaries Expense 8 Rent Expense 9 Advertising Expense 10 Automobile Expense 11 Supplies Expense 12 Insurance Expense 13 Utilities Expense 14 Telephone Bxpense 15 Postage Expense 16 Total Expenses 17 Net Income 18 19 20 21 22 23 $ 5,600.00 2,000.00 7,000.00 450.00 600.00 500.00 190.00 300.00 200.00 16,840.00 $ 19,160.00 25 26 FFC Journal Entries Unadjusted Trial Balance Adjusted Trial Balance Excel File Edit View Insert Format Tools Data Window Help AutoSave Home Insert Draw Page Layout Formulas Data Review View . X DO Calibrl (Body) 11 General A A AA- Paste BIU $ 98 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check A1 x fx My Place, House of Dcor E 1 B My Place, House of Dcor Statement of Retained Earnings For the Month Ended January 1, 2020 $ 19,160.00 $ 19,160.00 5 Retained Earnings, January 1, 2020 6 Net Income 7 Retained Earnings, January 31, 2020 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 BR X 25 26 Journal Entries EPIC Unadjusted Trial Balance Adjusted Trial Balance Sche My Place, House of Dcor MANUAL INSTRUCTIONS FOR FEBRUARY 1) Joumalize the transactions listed below and on the next page and post to the ledger accounts. Omit explanations. 2) Prepare an unadjusted trial balance. 3) Journalize the adjusting entries and post to the general ledger, Adjustment data are provided on the next page. 4) Prepare an adjusted trial balance. 5) Prepare a schedule of accounts receivable 6) Prepare an income statement for the two months ended February 28, 20Y8. If not completing the optional requirements below, use only the year-to-date amount column to complete your statement Optional: Prepare the statement for both the month of February and the year to date. Balances in the income and expense accounts currently reflect year-to-date activity. Complete the year-to-date income statement first. To calculate February figures, subtract January figures (from last month's income statement) from the year-to-date figures. Optional: Include vertical analysis figures in the statement by calculating the percent of cach line item to total revenue Note: If working the set with the general ledger software, the generated statement will auto- matically include monthly and year-to-date figures and include percentages for vertical analysis. 7) Prepare a retained caring statement for the two months ended February 28, 20Y8. 8) Prepare a balance sheet as of February 28, 20Y8 9) Complete the analysis test for February on page 37 GENERAL LEDGER SOFTWARE INSTRUCTIONS Follow the instructions on page 2 of this booklet Detailed instructions for this month are available in the general ledger software by clicking the Instructions button near the bottom of your screen. (Note that you may have to scroll down and over to see this button.) TRANSACTIONS FOR FEBRUARY Feb General Entries Issued Check No. 109 for $3.500 for the current month's advertising 6 Issaed Check No. 110 for $2,000 for February office rent. 7 Received $10,300 from Premet Comp for decorating services performed throughout its office building 33 27 Feb. 11 Received $6,000 from Maribel Thompson for decorating services performed January 12 on account. 15 Received $4,800 from Floyd and Peterson Law Firm for services performed to decorate its conference room. 22 Received $8,000 from Roberto Andriani for decorating services performed January 25 on account. Customer decided to pay part of the debt ahead of time. 25 Redecorated the restaurant facilities of Riviera's Caf on account for $11,500 (net 60). 27 Issued Check No. 111 for $225 to pay the utilities bill for the month. Issued Check No. 112 for $350 in payment of the telephone bill for the month. 27 Issued Check No. 113 for $230 for postage. 27 Issued Check No. 114 for $500 for business automobile expenses. 27 Issued Check No. 115 for $5,600 to Sophia LeBron for salary. (Payroll taxes are nor con- sidered in this entry. Transactions in later months will show you how to journalize payroll tax deductions and expenses.) Adjusting Entries a) Expired insurance for the period, $500. b) Supplies on hand at the end of the month, $675. E F G H B JOURNAL Page Post Ref. Credit Description ate EB Debit 5,500 5,500 4 Advertising Expense Cash 2,000 6 Rent Expense Cash 2,000 10,300 7 Cash Service Revenue 10,300 6,000 11 Cash Accounts Receviable 6,000 4,800 15 Cash Service Revenue 4,800 8,000 22 Cash Accounts Receviable 8,000 11,500 25 Account Receviable Service Revenue 11,500 27 Utilities Expense Cash 225 225 27 Telephone Expense Cash 350 350 27 Postage Expense Shanti Journal entry 230.00 D E F B 11,500 25 Account Receviable Service Revenue 11,500 225 27 Utilities Expense Cash 225 350 27 Telephone Expense Cash 350 7 230.00 27 Postage Expense Cash 230.00 500.00 A 27 Auto Expense Cash 500.00 5600.00 27 Salary Expense Cash 5600.00 Adjusting Entries a insurance Expense Prepaid insurance 500.00 500.00 325.00 b supplies Expense Supplies + EPIC 325.00 Sheet1 Journal entry General Ledger Balance Post Ref Date Debit Credit Debit Account 1001 Petty Cash Credit 1002 Cash J1 60,000.00 J1 J1 6,000.00 6,000.00 1,600.00 7,000.00 J1 J1 J1 5-Jan 5-Jan 6-Jan 7-Jan 7-Jan 10-Jan 20-Jan 30-Jan 30-Jan 30-Jan 30-Jan 30-Jan 10,000.00 8,000.00 60,000.00 54,000.00 48,000.00 46,400.00 39,400.00 49,400.00 57,400.00 57,210.00 56,910.00 56,710.00 56,260.00 50,660.00 J1 J1 J1 J2 J2 J2 190.00 300.00 200.00 450.00 5,600.00 7 3 3 . 1 2 3 4 Edit Excel File View Insert Format Tools Data Window Help GL Solution Jan AutoSave Home Insert Review Page Layout Draw Formulas Data View X 29 11 Calibri (Body) A A General Paste BIU a A $ % ) 28 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. B16 x f fo C D E G H F Balance 1 General Ledger Date Debit Credit 2 Account 3 1004 Accounts Receivable Post Ref 12.Jan 25 Jan Credit 11 6,000.00 31 12,000.00 Debit 6,000,00 18,000.00 5 6 7 9 10 11 12 13 14 15 16 17 IB 19 20 23 22 24 25 1001 1002 1004.1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 Edit View Tools Data Excel File Window Help Insert Format SU GLSolutionJan AutoSave Draw Home Insert Page Layout Formulas Data Review View | 22 A 11 General Calibri (Body) BIU AA Paste $ %) $ A1 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates oxfx General Ledger A 1 General Ledger Post Ref D F G Balance Date Debit Credit Debit Credit 2 Account a 1008 Estimated Returns Inventory 5 7 1.600.00 9 1009 Supplies 10 11 12 13 7-an 31 Jan 13 J2 Adjusting 1.600.00 1,000.00 600.00 15 16 17 18 15 20 1011 Prepaid insurance 21 22 23 6,000.00 adjusting 5 Tan 31 Jan 31 12 500.00 6,000.00 5.500.00 25 1001, 1002 1004, 1005, 1007 100 1024 2001 - 2020 3001 - 3010 40014002 Excel Window Help File Edit View insert Format Tools Data AutoSave Au. Insert Draw Page Layout Formulas Data GLSolution jan Home Review View Calibri (Body) 11 con APA General For Paste $ %) $328 Cel Office Update To keep up-to-date with security updates, fores, and improvements, choose Check for Updates ASO Ax fx TA C 0 F H 25 26 27 28 1013 Prepaid Rent 29 6-Jan 1 2,000.00 2,000.00 10 31 32 1015 Deposits 6-Jan 13 2.000.00 2,000.00 33 14 25 1020 Land 35 17 38 1023 Furniture and Fixtures 39 40 41 1024 Accumulated Depreciation 42 83 14 45 47 45 49 50 1001 1002 1004 1005, 1007 100 1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 Data Window Help Excel File Edit View Insert Format Tools AutoSave ore u Home Insert Draw Page Layout Formulas GL Solution.Jan Data Review View Til Calibri (Body) 11 ' ' General lo Paste BIU A 2 $ %) Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates Al 4 x fc General Ledger TA D E F G H 1 General Ledger Balance Post 2 Account Date Rer Debit Credit Debit Credit 3 2001 Accounts Payable 4 5 6 7 & 9 10 11 12 13 2002 Notes Payable 14 15 16 17 2003 Salaries Pavable 10 20 21 2004 Cash Dividends Payable 22 24 2005 FICAT Payable 1001 1002 1004.1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001-2002 Excel File Edit View Innert Format Tools Data Window Help AutoSave CE GLSolutionJan Home Insert Draw Page Layout Formulas Data Review View Calibr (Body 11 A 4 General Cend Form Paste BTU D $%$## INS Cels Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates, A53 4 xfx A B c 29 30 2006 SUTA Tax Payable 32 3a 34 2007 FUTA Tax Payable 35 16 38 2008 WH income Tax Payable 39 40 31 42 200) Income Tax Payable 43 44 45 2010 Customers Refunds Payable 45 47 48 49 50 55 2020 Notes Payable.Long Term 52 53 1001, 1002 1004, 1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 PC Excel File Edit View Insert Format Tools Data Window Help AutoSave GLSolutionJan Home Insert Draw Page Layout Formulas Data Review View X Calibrl (Body) 11 AA General Paste BTU a. Av $ % ) Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates J15 x x A B D E F H 1 General Ledger Balance Post 2 Account Date Hef Debit Credit Debit Credit 33001 Common Stock 4 5 11 60,000.00 60,000.00 5 6 7 3007 Retained Earnings B 9 10 11 3008 Cash Dividends 12 13 14 15 3010 Income Summary 16 12 18 19 20 23 24 35 1001, 1002 1004, 1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 EPIC Excel File Edit View Insert Format Tools Data Window Halo AutoSave GL Solutionjon Home Insert Draw Page Layout Formulas Data Review View 11 A A 29 General Calibr (Body BTW Paste = = = -A- Condit Tome 2 Cells $ % 9 M Office Update To keep up to date with security updates, from, and improvements, choose Check for Updates C1 x fx C G A General Ledger ce 2 Account 4001 Decorating fees Post Me Debt Credit Debit Credit 10 ja 12 Jan 20 Jan 25 Jan It 11 JI 10,000.00 5.000.00 3.000.00 12,000.00 10,000.00 16,000.00 24,000.00 36,000.00 2 1 9 10 11 12 13 14 15 16 17 19 10 1001 1002 1004, 1000, 1007 1000 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 5001 Data Window Help ExcolFile Edit View Insert Format Tools AutoSave na 5.5. Home Insert Draw Page Layout Formulas GL SolutionJan Data View Review 2 Calibrl (Body) 11AA General Il lil 19 Paste B I U OA $ % ) Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates F1 1 x fe Balance A B C D H 1 General Ledger Balance Post 2 Account Date Red Debit Credit Debit Credit 3 5001 Cost of Goods Sold 4 5 6 2 8 9 10 11 30-lanz 5.600.00 5.600.00 13 14 5004 Salaries Expense 15 16 17 18 19 20 21 22 21 SOOS Rent Expense 24 25 1001 1002 2.000.00 2.000.00 1004, 1005, 1007 1008-1024 2001 - 2020 3001 - 3010 4001 - 4002 Excel File Edit View insert Format Tools Data Window Help AutoSave GL SolutionJan Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) X LG 11 23 A A Accounting Pasta $ % Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates F48 x fx A B C D E F G H 23 5005 Rent Expense 24 6-Jan 31 2,000.00 2.000.00 25 25 27 28 30 11 32 5006 Advertising Expense 7-Jan 11 7,000.00 7,000.00 34 35 36 37 39 40 41 5002 Automobile Expense 30 Jan 12 450.00 450.00 44 45 1001, 1002 1004, 1005. 1007 1038-1024 2005 - 2020 3001 - 3010 4001 - 4002 Excel File Edit View Tools Data Window Help Insert Format a su AutoSave GLSolutionJan Home Insert Draw Page Layout Formulas View X Callbr (Body) Data Review 23 " 11 Accounting III Paste $ % ) AIN Office Update To keep up-to-date with security updates, foxes, and improvements, choose Check for Updates F75 x fx B D E F G H 31 Jan 2 600.00 600.00 50 51 5008 Supplies Bxpense 52 Adjusting 53 54 55 SG 57 58 59 50 61 62 635009 Insurance Expense 54 Adjusting 65 66 67 31-Jan 12 500.00 500.00 69 70 1 72 5010 Utilities spense 22 24 75 1001, 1002 30-Jan 190.00 190.00 1004, 1005, 1007 1008 - 1024 2001 - 2020 3001 - 3010 4001 - 4002 Excel Dota Window Help File Edit View Insert Format Tools AutoSave @yu. Insert Draw Page Layout Formulas GL SolutionJan Home Data Review View Calibri (Body) 11 29 General Paste a. A- Hill $ % ) Office Update To keep up to date with security updates, fores, and improvements, choose Check for Updates F96 ex fe A B C D E 0 71 72 5010 Utilities Expense 73 30 Jan 11 190.00 190.00 74 75 75 77 79 BO 81 5011 Telephone Expense 30 Jan 1 300.00 300.00 53 84 85 86 87 88 89 90 93 92 93 94 95 56 1001, 1002 1004, 1005, 1007 1008 1024 2001 - 2020 3001 - 3010 4001 4002 Data Window Help GLSolutionJan Excol File Edit View Insert Format Tools AutoSave ABSU. Home Insert Draw Page Layout Formulas or View Calibel (Body! 11 A A General Data Review = = 25 = = P AD Condition Format Call Style Paste BTU A $ %) 828 a Office Update To keep up to date with security updates, foces, and improvements, choose Check for Updates 11 ex fe A 3 c G 1 General Ledger Balance Post 2 AM Date Debit Credit Debit Credit 5012 Postage pense 30-an 22 200.00 5 7 1 10 12 13 14 5013 Depreciation Expense 15 15 17 19 5014 Dues and subcription Dipense 20 21 22 SOLS Uncollectible ecounts pense 23 13 1001 1002 1004, 1005, 1007 1003-10 2001 - 2020 3001 23010 4001 - 2002 5001 Excel File Edit View Insert Format Tools Window Data Help Jan AutoSave Insert Draw Home Page Layout Formulas Data Review View Calibri (Body) 11 A X LG General Paste BIU A V $ % 4 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Up F19 4 x fx A B C D E F G H My Place House of Dcor 2 Unadjusted Trial Balance 31-Jan-20 Acct Account No. Debit Credit 5. Cash 1002 50,660.00 6 Accounts Receivable 1004 18,000.00 7 Supplies 1009 1,600.00 8 Prepaid Insurance 1011 6,000.00 9. Prepaid Rent 1013 2,000.00 10 Deposits 1015 2,000.00 11 Common Stock 3001 60,000.00 12 Decorating Fees 4001 36,000.00 13 Salaries Expense 5004 5.600.00 14 Rent Expense 5005 2,000.00 15 Advertising Expense 5006 7,000.00 16 Automobile Expense 5007 450.00 17 Utilities Expense 5010 190.00 18 Telephone Expense 5011 300.00 19 Postage Expense 5012 200.00 20 96,000.00 96,000.00 21 25 Jounal Entries Unadjusted Trial Bandu Adjusted a Bwancu Schedule Excel file Edit View Insert Format Tools Data Window Help AutoSave Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) 2 11 ' ' General ilil Paste B 1 a. Av $ % HI 4 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for A19 XV fx Utilities Expense A D E F G H My Place House of Dcor 2. Unadjusted Trial Balance 3 31-Jan-20 Acct Account No. Debit Credit 5 Cash 1002 50,660.00 6 Accounts Receivable 1004 18,000.00 7 Supplies 1009 1,000.00 8 Prepaid Insurance 1011 5,500.00 9 Prepaid Rent 1013 2,000.00 10 Deposits 1015 2,000.00 11 Common Stock 3001 60.000.00 12 Decorating Fees 4001 36,000.00 13 Salaries Expense 5004 5,600.00 14 Rent Expense 5005 2,000.00 15 Advertising Expense 5006 7,000.00 16 Automobile Expense 5007 450.00 17 Supplies Expense 500R 600.00 18 Insurance Expense 5009 500.00 19 Utilities Expense 15010 190.00 20 Telephone Expense 5011 300.00 21 Postage Expense 5012 200.00 22 96,000.00 96,000.00 23 25 Journal Entries Undjusted Trial Balance Adjusted Trial Balance Sche Excel File Edit View Insert Format Tools Data Window Help AutoSave Ja Home Insert Draw Page Layout Formulas Data Review View X lb Calibri (Body 11 - A A AA- Paste BIU Accounting $ % == += Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for L B6 xfx 12000 A B c D E F H My Place, House of Dcor 2 Schedule of Accounts Receivable 3 31-Jan-20 4 5 Maribel Thompson $ 6,000.00 6. Roberto Andriani 12,000.00 7 Total Accounts Receivable $ 18,000.00 8 9 10 11 12 13 14 16 17 18 19 20 21 22 23 24 25 26 Journal Entries FC Unadjusted Trial Balance Adjusted Trial Balance Sched Data Window Help Excel File Edit View Insert Format Tools AutoSave orts. Home Insert Draw Page Layout Formulas X Calibri (Body) 11 AA Data Review View Genera Paste BIU a. Av $ Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check Xv fx My Place, House of Dcor A1 D G My Place, House of Dcor Income Statement For the Month Ended January 1, 2020 $ 26,000.00 5 Decorating Fees 6 Expenses: 7 Salaries Expense 8 Rent Expense 9 Advertising Expense 10 Automobile Expense 11 Supplies Expense 12 Insurance Expense 13 Utilities Expense 14 Telephone Bxpense 15 Postage Expense 16 Total Expenses 17 Net Income 18 19 20 21 22 23 $ 5,600.00 2,000.00 7,000.00 450.00 600.00 500.00 190.00 300.00 200.00 16,840.00 $ 19,160.00 25 26 FFC Journal Entries Unadjusted Trial Balance Adjusted Trial Balance Excel File Edit View Insert Format Tools Data Window Help AutoSave Home Insert Draw Page Layout Formulas Data Review View . X DO Calibrl (Body) 11 General A A AA- Paste BIU $ 98 Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check A1 x fx My Place, House of Dcor E 1 B My Place, House of Dcor Statement of Retained Earnings For the Month Ended January 1, 2020 $ 19,160.00 $ 19,160.00 5 Retained Earnings, January 1, 2020 6 Net Income 7 Retained Earnings, January 31, 2020 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 BR X 25 26 Journal Entries EPIC Unadjusted Trial Balance Adjusted Trial Balance Sche