80.2K

Verified Solution

Link Copied!

i need help creating special journals, a General Journal, General Ledger, Unadjusted trial balance, Accounts Receivable subsidary Ledger, Accounts Payable Subsidary Ledger, an accounting worksheet, an adjusted trial balance, and income statement and statement of owners equity, a balance sheet and a post closing trial balance using the information in the first 2 photos and the templates provided bellow. These are are clearest photos i could get.

G H 7 18 3 Date Description 4 1:00 Signed 6 mo lease and prepaid October rent of $750 Check Document 11# Vendor/Customer Terms 5 1-00 Received $800 cash for lawn services rendered. 6 Deposit 3.0d Received $18,600 invoice from vendor for inventory Purchase Invoice 458 Trees LL s hipped 10/1, terms FOB Shipping Point 1 2 /10 /30 8 4-Od Paid $140 to fill gas fuel barrel and purchase oil 11 Check 1111111150 9 m 7-00 Paid $210 to purchase office supplies in Check 11111111511 10 8-Od Deposited $2,800 weekly cash sales. 11 Deposit 111111211 11 Cost of Inventory was 51,940.1111 12 10-0c Pald Invoice #1458 1111 Check 11 152 Tress LLC 13. 11-0a Pald accountant $800 for services rendered 111 Check 11 1 53 14 11-0d Advertised services in local paper. Cost $7511331 Purchase invoice 360 Daily News 1/30 15 12-Od Sold inventory, on account, for $5,000 Sales Invoice10102 Miles, Co 2 715.30 16 Cost of Inventory was $2,5001111 17 13-0d Paid carrier Transit Inc, $85 for freight charges Check incurred for inventory purchased from 19 Trees LLC (Purchase Invoice #458) 2014-0d Received full payment, on account, Deposit 3 21 Miles, Co Invoice 10102 22 15.0d Deposited $2,995 weekly cash sales Deposit 23 Cost of Inventory was $1.940 24 20-Od Paid excavator, Bullder's Inc. $5,000 for land. Check 25 clearing in anticipation of building a new facility 26 20 0d Paid $410 to full gas fuel barrel and purchase oil Check 156 27 20-Oct. Purchased $20,000 inventory, on account Purchase Invoice 511 Trees LLC 2/10,n/30 28 22-0a Deposited $5.400 weekly cash sales Deposit 29 Cost of Inventory was $4.65011 30 25-Od Paid sub-contractor $2,000 for services rendered Check 157 31 27.0d Billed customer $1100 for lawn wintonizing services Sales Invoice 10103 Local Community College 32 Cost of inventory was $750 33 28-0a Received a $24.600, 12% 60 day note in exchange Note New Business Company 12% 60 day 34 for services Services rendered 35 C ost of Inventory $18,000 + 36 29-Od Deposited $6,900 weekly cash sales Deposit 37 Cost of Inventory was $5.765 Check 38 31-Od Traded old truck plus $7,000 cash for new 39 truck. The business uses 5yr SL C heck 40 31.0d Nick withdrew $1,500 cash for personal use 41 31 Oct Write-off Hyde, Inc account receivable as uncollectible a Pald sub-contractor $2,000 for sences tendered 10103 Locaten 130 hexchange Note posted Sooty 18.000 e rod AutoSave 01 2 Calls le Home insert Page Layout Formulas D PROTECTED VIEW Be careful--files from the Internet can contain " A Part B Adjusting Entries Round all calculations to a whole dollar. Description 1 3 months of the 6-month prepaid Insurance policy has expired 2 The business uses 5-year straight-line depreciation and assumes zero salvage value. Compute 1 yr depreciation on equipment. 3 $400 of gas and oil remains at year end. 4 $200 of office supplies are on hand at year end. 5 The current market value of the inventory is $26,950 6 Nick estimates that 1.5% of net credit sales will be uncollectible. Credit sales for the first 11 montify were $75,000 7 Compute interest earned on note receivable (Use 360 day year and round to whole dollar) 8 Record the adjustment for expired rent. 9 Compute 6 months interest accrual on a 2 year 8% Note Payable 10 Accrue 11,000 of income tax expense A B Current Balances Debit Credit $21,265 $1,135 $1,000 $575 $5,900 $1,100 $25,000 $18,000 $5,400 $ 11,400 $3,420 $80,000 $0 $4.399 4 AC# Title 5 1010 Cash 6 1020 Accounts Receivable 7 1020.1 Allowance for Doubtful Accounts 8 1025 Interest Receivable 9 1028 Note Receivable 10 1030 Office Supplies 11 1035 Prepaid Gas and Oil 12 1040 Prepaid Insurance 13 1045 Prepaid Rent 14 1060 Inventory 15 1080 Truck 16 1080.1 Accumulated Depreciation - Truck 17 1085 Equipment 18 1085.1 Accumulated Depreciation - Equipment 19 1090 Land 20 1095 Land improvements 21 2010 Accounts Payable 22 2020 Income Tax Payable 23 2030 Interest Payable 24 2040 Unearned Revenue 25 2070 Note Payable 26 3010 Nick Roberts, Capital 27 3030 Nick Roberts, Withdrawal 28 3090 Income Summary 29 4010 Sales Revenue 30 4010.1 Sales Discounts 31 40102 Sales Returns and Allowances 32 4020 Interest Revenue 33 5000 cost of Goods Sold 34 6010 Advertising Expense 35 6020 Depreciation Expense s 36 6030 Gas and Oil Expense 37 6035 Income Tax Expense 38 6040 insurance Expense 39 6050 Interest Expense 40 6060 Office Supplies Expense 41 6070 Phone Expense 42 6080 Professional Fees Expense s 43 | 6090 Rent Expense 44 6100 Subcontractor Expense 45 6110 Uncollectible Account Expense 45 Total $1,000 $55,000 $10,741 $162,000 $750 $500 $69,000 $1.345 $2,490 $3,800 $700 $242.950 $242.960 49 T actions Special Journals General Jo AC 2 Practice Set Template 2 AutoSave on 2. File Home insert Page Layout Formulas Data Review View Help Acrobat Search W PROTECTED VIEW Be careful-files from the Internet con contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing T24 X v for Sales Journal Page 4 Accounts Receivable DR/ Sales Post Ref. Revenue CR cost of Goods Sold DR/ Inventory CR 3 Date Invoice # Customer Account Debited Terms Debits Cash Receipts Journal Page 10 Credits Other Accounts Sales Accounts Revenue Receivable Account Title Post Ref. Cost of Goods Sold DR Anventory Credit Sales Discount Amount Date Reference Cash Purchase Jums PRO 20 - Credits DNS Other Arctos Ref Terms Post Rela tie Intory Account Title Por t Cash Paviments (Disbursements louri Page 43 GENERAL JOURNAL 1) 101 Date Account Thies and explanation Post Rel D e Credit Chart of Accounts Transactions Special Journals General Journal General Ludger Unadjusted GENERAL LEDGER 4 Account Title: 5 Date Explanation Balance Forward Cash Post Ret DEBIT 1010 BALANCE 21.265 NCR Roberts, Capital Post Ret DEBIT CREDIT Account Title: Explanation Balance Forward CREDIT 10.741 Account Title: Explanatos Balance Forward Nick Roberts with rawal Post Ret DEBIT Date CREDIT BALANCE 14 Account 15 Date Account Rece Post Ret DEBIT 1020 CREDITBALANCE Explanation Account Title Date income Summary Poster D E aton CREDIT BALANCE Account Title: Aowance for Dout Acco Date Explanation Post Rel DEBIT Balance forward CREDIT BALANCE DENT CREDIT BALANCE AC 2 Practice Set Template 2015-1 (0) - Protected View - Excel AutoSave on a File Home Insert Page Layout Formulas Data Review View Help Acrobat Search W PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit asset to stay in Protected View Cable Editing MNOLOR Account Title: Date Sales Discounts Post Ret DEBIT 4910 BALANCE Explanation CREDIT 37 38 39 0 Account TWI N 41 Date Explanation Balance Torward 431 le Recevable Post Ret DEBIT CREDIT BALANCE Sales Returns and Allowance Post Re DEBIT CREDIT BALANCE M 47 AB Account The 49 Date Explanation Orice Supplies Post Ret DEMT Balance Forward CREDIT mierest Revenue Post Ref DELI C REDIT BALANCE Explanatic 56 Account me SOMO p lanation Pred Gas and on Poster DEHT CREDIT BALANCE C Acce Date ostoode od Post Red DE C REDIT Explanation Balance Forward HALANCE 68.000 --- HA 66 Account Post Ref DEBIT CREDIT BALANCE 67 Date BICHI DIMANCE 1345 T4 Account Poster DEI CREDIT 75 Dale Explanation 23 Expo d Post e EBIT CREONTRALANCE AR Soudury Lee Account Title Date Explanation Balance Forward Advertising Expense Post Rel DEBIT CREDIT BALANCE Prepaid Rem Post Ref DEBIT CREDIT BALANCE 74 Account Two: 75 Date Explanation 76 Balance Forward 77 78 Account Title: Date Explanation Balance Forward Depreciaron Expense Post Ref DFRIT CREDIT 82 Account TW 83 DMO Explanation Balance Forward Post Ret DEBIT CREDIT BALANCE Casando pens Account Title: Date Explanation 3 $85338 Post Ret DEBIT CREDIT BALANCE Med Depec POR C REDI RALANC PRED CRIME on Special l a de Chart of Accounts AL 2 Practice Selempute 2015-10- Prolet View - obave , Home insert Page Layout Formulas Data Review View Help Acrobat Search PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing B A S C D F G H J K L M N O Account Title: Date Explanation Balance forward O R Insurance Expense Post Rel DEBIT CREDIT BALANCE 10 Account Title: 111 Date Explanation 112 Balance Forward Equipment Post Ret DEBIT CREDIT BALANCE 11.400 Interest Expense Post Ref DEBT Account Title: Date Explanation Balance Forward CREDIT BALANCE 116ccount Title: Accumulated Dopredation Equipment 112 Date Explanation Post Ret DEBIT CREDIT 12 Balance Forward 119 1085 BALANCE 3.420 121 122 Omice Supplies Expense P ost Ret DEBIT Account Title: Date Explanation Dace Forward CREDIT BALANCE 1231 124 Account Thie: 125 Date Explanation Balance forward Land Post Ret DEBIT CREDIT BALANCE 30,000 Account Post Ret DEBIT CREDITBALANCE 128 129 10 131 132 ACCOUNT 133 Date E ation Balance Forward Land improvemen Post Ret DEBIT CREDIT BALANCE 144 136 17 Professional Post Red Expense DEBIT CREDIT Explanatio Post Rel DEBIT CREDIT 140 Account 141 Date Bance Forward BALANCE AP Subsidury Ledger Re AR Subsidury Ledger 150 Account The Undsted Tral Balance General Ledger Spec Journals General ou Chart of Accounts Account Professions Feste Post Ret DEBIT Explanatio CREDIT BALANCE MCCO 141 Date Expansion ACCP Poster DEBIT CREDIT BALANCE 10 SES Explanation ACCOUNT 151 Date antion Poster DEHICHI DIOMAS 157 ACCOM TIDEN NECO 8 Robert's Lawn Service Unadjusted Trial Balance October 31, 20- Debit Credit HHHHH Chart of Accounts Transactions Special Journals General Journal General Ready AutoSave 01 E 2.S E File Home Insert Page Layout Formulas Data Review PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless your Accounts Receivable Subsidiary Ledger 101 3 Miles, Co 4 Date ml Ref Debit Credit Balance 109 8 Local Community College 9 Date Jml Ref Debit Credit Balance 11 111 Debit Credit Balance 1.135 14 Hyde, Inc 15 Date Url Ref 16 Balance Forward 17 18 19 Weston Place 20 Date Jnl Ref 120 Debit Credit Balance B IE Accounts Payable Susidiary Ledger 205 Jml Ref Debit Credit Balance 2 Trees LLC 3 Date 5 278 8 Daily News 9 Date Jrol Ref Debit Credit Balance 11 13 Bill's Repair 14 Date Jnl Ref 15 30-Sep P19 Debit Credit 293 Balance 4,399 4,399 DE Worksheer Robert's Lawn Service October 31, 20- Unadjusted Trial Balance Debit Credit Adjustments Debit Credit Adjusted Trial Balance Debit Credit Income Statement Debit Credit Balance Sheet Debt Credit 7 Account Tiles 8 Cash 9 Accounts Receive 10 Allowance for Doublu Accounts 11 Interest Pocelvable 12 Not Receivable 13 Oulce Supplies 14 Piepold Gas and 15 Prep sd Insurance 16 Prepaid Renk 17 Inventory 1 Truck 19 Accumshed Deprecision-Truck 20 Equipment 21 Accumulated Depreciation Equipment 22 Land 23 Land improvements 24 Accounts Payable 25 Income Paya 26 Incest Pwable 27 Une ained Revenue 28 Note Payable 25 Nick Roberts, Cool 30 Nok Roberts Withdrawal 31 Sales Revenue 2 Sales Decounts 3 Sales Returns and Allowances 34 Interest Revenue 39 Cost of Goods Sold- 30 Advertising Expense 37 pecahon pense 36 Gas OlExpense 39 Income Tax Expense 40 ulance Ependo 41 T est Expense 42 Office Supplies Expense 43 Phone Expense 44 ProbesnonalFoer Expense 45 Rere Expende 46 Subcontractor Expens 47 Uncollectible Account Expe 50 51 Totals 52 Net Income Unad usted Tral General Ledger General Journal 9 Transactions Special Journals Chart of Accounts Ready 8 9 Robert's Lawn Service Adjusted Trial Balance October 31, 20- Debit Credit 40 Chart of Accounts Transactions Special Journals General Journal General

Answer & Explanation Solved by verified expert

See Answer