Formatting A1 X V fx | ACCT500: Course Project A B C ACCT500: Course Project 1 Requirement Requirement Description Worksheet Name 2 Prepare the Journal Entries in the General Journal 1 - Journal Entries 3 Post Journal Entries to the General Ledger - General Ledger A Prepare a Trial Balance 3 - Trial Balance 6 There are also hints contained within certain cells on some of the Worksheet tabs. You can hover over the red pointer at the top right-hand corner of the cell to read the hint. Hints are provided for the following balances: 10 1) The debits for the journal entries are on the Journal Entries tab. 2) The credits for the journal entries are on the Journal Entries tab. 12 3) The cash balance is on the General Ledger tab. 13 4) The debits for the trial balance are on the Trial Balance tab. 14 5) The credits for the trial balance are on the Trial Balance tab. 15 16 17 Meru September Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial Balance Grading Rubric + Ready TX Accessibility: Investigate 6,089 JUL 21 atv AiPaste BI UV Formatt C11 X V fx Received $15,000 in cash for plumbing services provided. During its first month of operation, the Plumbing Repair Company, which, specializes in plumbing repair services, completed the following transactions. September Transactions Date Transaction Description September 1 Started a plumbing repair business by making a $100,000 deposit in a company bank account, in exchange for 20,000 shares of $5 par value common stock. September 1 Purchased insurance for the year and paid $3,000 cash. September 2 Paid monthly rent with $3,500 cash on a warehouse to store the plumbing equipment. September 5 Purchased plumbing equipment for $25,000, making a $5,000 down payment and placing $20,000 on account. September 6 Purchased supplies for $2,000 on account. September 7 Paid $750 cash for advertising in local newspapers. September 10 Received $15,000 in cash for plumbing services provided. September 12 Paid $5,000 for plumbing equipment previously purchased on account on September 5th. September 15 Provided plumbing services on account for $2,500. September 23 Received $22,000 in cash for plumbing services provided. September 25 Received $1,500 cash for plumbing services performed on account on September 15th. September 28 Paid $500 cash for a utility bill. September 30 Paid cash dividends of $1,000. September 30 One month's insurance expired. September 30 The inventory of supplies showed a balance of $1,200 on hand at the end of the month.ce LA Paste B I U v $ ~ % " 00 Condit Forma D10 x fx Equipment Use the following account descriptions for journal entries. Chart of Accounts Account Account Type Number Account Title Normal Balance Assets 111 Cash Debit 115 Accounts Receivable Debit 117 Supplies Debit 119 Prepaid Insurance Debit 144 Equipment Debit Liabilities 212 Accounts Payable Credit Stockholders Equity 311 Common Stock Credit 313 Dividends Debit Revenue 411 Service Revenue Credit Expenses 510 Insurance Expense Debit 511 Rent Expense Debit 512 Advertising Expense Debit 514 Supplies Expense Debit 517 Utility Expense Debit Menu September Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger 3 - Trial BalaC D E F G H A B REQUIREMENT #1: Prepare journal entries to record the September transactions in the General Joumal below. Remember that Debits must equal Credits-All of your Journal Entries should balance. General Journal Account Number from Chart of Date Accounts tab Account Title from Chart of Accounts tab Debit Credit 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 September Transactions 1 - Journal Entries 2 - General Ledger 3 - Trial Menu Chart of Accounts Ready X Accessibility: InvestigateE8 4 X V fx G H D E B C A REQUIREMENT #2: Post the September journal entries to the following T-Accounts and compute ending balances. 7 Date Service Revenue (411) Date Cash (111) 10 11 13 14 15 Insurance Expense (510) 16 Accounts Receivable (115) 17 18 19 20 21 22 23 24 Rent Expense (511) 25 Supplies (117) 26 27 28 29 30 31 32 33 Prepaid Insurance (119) Advertising Expense (512) 34 35 36 37 38 39 40 41 3 - Trial Balance Menu September Transactions Chart of Accounts 1 - Journal Entries 2 - General Ledger Ready Accessibility: InvestigateC33 + XV fox G H B D E. F A REQUIREMENT #3: Prepare a trial balance for September in the space below. The Plumbing Repair Company Trial Balance September 30 Account Account Balance Title Debit Credit Number 10 11 12 13 14 17 18 19 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 2 - General Ledger 3 - Trial Balance 1 - Journal Entries Menu September Transactions Chart of Accounts Ready Accessibility: Investigate