I have done the journal entries and attempted doing the unadjusted trial balance but, as you can see in the pictures, my debits are not equaling my credits. I am not sure if I made an error in the journal entries or in another spot and would love any help that I can get!
ACCT 211 - Spring 2020 INTEGRATED LEARNING PROJECT 2 INSTRUCTIONS VINE & BRANCHES - SUNFLOWER DESIGNS Important: This assignment should be completed alone. Students should treat this assignment similar to the requirements of an in-class open-book exam. That is the only resources allowed are the textbook and the professor. 1. CREATE JOURNAL ENTRIES FOR THE October 2019 TRANSACTIONS BELOW FOR SUNFLOWER DESIGNS: a. On October 1, $300 of office supplies was purchased on credit; the terms of the invoice were net 30. All of the supplies were used during the month of October b. On October 2, a 36-month liability insurance policy was purchased to cover Sunflower Designs. The full cost of the policy, $4,500, was paid in cash on the same date. c. On October 1, a network server was purchased on credit totaling $3,000. The estimated useful life of the computer is five (5) years and is expected to have no salvage value. The invoice terms were 2/10, net 30. net 30 d. On October 4, payroll checks were issued for the wages payable balance. e. On October 5, Sunflower Designs purchased $3,200 worth of inventory Items for resale. These items were purchased on credit and the invoice term is 2/10, net 30. f. On October 9, a check was issued to pay for the inventory purchased on October 5. B. on October 10, Sunflower Designs paid for the office supplies purchased on credit on October h. On October 12, Sunflower Designs completed and delivered an interior design layout to a customer for $7,580. The customer had paid for the services in advance in a previous month, and Sunflower Designs had appropriately recorded the deposit. On October 14, Sunflower Designs completed, delivered, and billed an interior design layout for $16,400 to a new customer. The terms of the invoice were 2/10, net 30. 1. On October 16, Sunflower Designs paid $3,250 in wages to a temporary employee. On the same date, the company remitted payroll taxes of $150, previously accrued, to the appropriate government entities. k On October 18, Sunflower Designs received a refund of $38 from their office supply vendor for items that were returned on the October 1 purchase. I. On October 20, a customer paid the balance due for an interior design layout. The invoice for these services was sent to the customer on June 20, 2018. The contract price was $6,250, 1. On October 20, a customer paid the balance due for an interior design layout. The invoice for these services was sent to the customer on June 20, 2018. The contract price was $6,250. Last edit: 12/16/19 Page 1 of 3 m. On October 24, Sunflower Designs sold a side table from inventory for $736. The inventory cost for this item was $320. The customer paid cash for this purchase. n. On October 26, $375 worth of inventory was returned to supplier because of defects. The Inventory had been purchased on account in August and had not been paid for. o. On October 30, the customer delivered a check for one-half of the interior design invoice delivered on October 14. 2. CREATE THE OCTOBER 31, 2019 UNADJUSTED TRIAL BALANCE 3. CREATE ADJUSTING JOURNAL ENTRIES FOR OCTOBER 31, 2019: o. Record the depreciation for the laptop purchased on October 1. p. Record the October 2019 depreciation for all computers & software owned before the October 1 purchase. These items are being depreciated over 5 years using the straight-line method with no salvage value. q. Record the October 2019 depreciation for the furniture & fixtures. These items are being depreciated over 7 years using the straight-line method with no salvage value. r. Record the adjusting entry for October's rent. Sunflower Designs paid $4,200 in advance for 6 months' rent on June 1, 2019. All previous months' adjusting entries were made as required. 5. Record the adjusting entry for the consumption of prepaid insurance for the month of October. The preexisting policy has 42 months remaining as of October 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t Record the amount due to employees for time worked during October, but not paid. The amount earned by the employee was $4,400. The payroll taxes should be accrued at 20% of the wages and the entry should be made, payment for these taxes will occur in November 4. CREATE THE ADJUSTED TRIAL BALANCE 5. CREATE THE OCTOBER 31, 2019 INCOME STATEMENT. File Home Insert Draw Formulas Data Review View Calibri (Bo.. . BI UB A B also Sunflower Designs Journal Entry Oct-19 Account Debit Credet Oct. 1 300 Office Supplies Expense Accounts Payable Purchased goods terms, 1/30 300 Oct. 1 3.000 Computers and Softwares Accounts Payable Purchased goods, terms 2/10,n/30. 3,000 Oct. 2 4,500 Prepaid Insurance Cash 4,500 Oct. 4 Wages Expense Wages Payable 3,200 Inventory Accounts Payable Purchased goods terms, 2/10,n/30. 3,200 Accounts Payable Cash Inventory 3,136 Oct. 10 Accounts Payable Cash Oct 12 7.SRO Unearned Revenue Design Revenue 7.580 Journal Entries Trial Balance Income Statement Balance Sheet File Home Insert Draw Formulas Data Review View Calibri (Bo... 1 . B I U I A E 22 Unearned Revenue Design Revenue Oct. 14 16,400 Accounts Receivable Design Revenue terms, 2/10, 1/30 16,400 Wages Expense Payroll Taxes Expense Cash Cash Office Supplies Expense Oct. 20 Cash Furnishing Sales Cost of Goods Sold Inventory Oct 26 Accounts Payable Inventory Oct 30 Cash Accounts Receivable Journal Entries Trial Balance Income Statement Balance Sheet Home Insert ACCT 211 LP 2 Template Draw Formulas Data Review View BIUA 225 . October 1, 2013 Begling Transactions from journal Otober 10, 2015 United Entries through Trial Balance Adjusting ournal Entries Entries through t.) 16.10.00 1950 100.00 9.21400 10000 1115 Decem 1130 uur Stres 1125 A dept 1140 Macht 1150 A d DepE Journal Eneries Trial Balance income statement Balance Sheet ACCT 211 - Spring 2020 INTEGRATED LEARNING PROJECT 2 INSTRUCTIONS VINE & BRANCHES - SUNFLOWER DESIGNS Important: This assignment should be completed alone. Students should treat this assignment similar to the requirements of an in-class open-book exam. That is the only resources allowed are the textbook and the professor. 1. CREATE JOURNAL ENTRIES FOR THE October 2019 TRANSACTIONS BELOW FOR SUNFLOWER DESIGNS: a. On October 1, $300 of office supplies was purchased on credit; the terms of the invoice were net 30. All of the supplies were used during the month of October b. On October 2, a 36-month liability insurance policy was purchased to cover Sunflower Designs. The full cost of the policy, $4,500, was paid in cash on the same date. c. On October 1, a network server was purchased on credit totaling $3,000. The estimated useful life of the computer is five (5) years and is expected to have no salvage value. The invoice terms were 2/10, net 30. net 30 d. On October 4, payroll checks were issued for the wages payable balance. e. On October 5, Sunflower Designs purchased $3,200 worth of inventory Items for resale. These items were purchased on credit and the invoice term is 2/10, net 30. f. On October 9, a check was issued to pay for the inventory purchased on October 5. B. on October 10, Sunflower Designs paid for the office supplies purchased on credit on October h. On October 12, Sunflower Designs completed and delivered an interior design layout to a customer for $7,580. The customer had paid for the services in advance in a previous month, and Sunflower Designs had appropriately recorded the deposit. On October 14, Sunflower Designs completed, delivered, and billed an interior design layout for $16,400 to a new customer. The terms of the invoice were 2/10, net 30. 1. On October 16, Sunflower Designs paid $3,250 in wages to a temporary employee. On the same date, the company remitted payroll taxes of $150, previously accrued, to the appropriate government entities. k On October 18, Sunflower Designs received a refund of $38 from their office supply vendor for items that were returned on the October 1 purchase. I. On October 20, a customer paid the balance due for an interior design layout. The invoice for these services was sent to the customer on June 20, 2018. The contract price was $6,250, 1. On October 20, a customer paid the balance due for an interior design layout. The invoice for these services was sent to the customer on June 20, 2018. The contract price was $6,250. Last edit: 12/16/19 Page 1 of 3 m. On October 24, Sunflower Designs sold a side table from inventory for $736. The inventory cost for this item was $320. The customer paid cash for this purchase. n. On October 26, $375 worth of inventory was returned to supplier because of defects. The Inventory had been purchased on account in August and had not been paid for. o. On October 30, the customer delivered a check for one-half of the interior design invoice delivered on October 14. 2. CREATE THE OCTOBER 31, 2019 UNADJUSTED TRIAL BALANCE 3. CREATE ADJUSTING JOURNAL ENTRIES FOR OCTOBER 31, 2019: o. Record the depreciation for the laptop purchased on October 1. p. Record the October 2019 depreciation for all computers & software owned before the October 1 purchase. These items are being depreciated over 5 years using the straight-line method with no salvage value. q. Record the October 2019 depreciation for the furniture & fixtures. These items are being depreciated over 7 years using the straight-line method with no salvage value. r. Record the adjusting entry for October's rent. Sunflower Designs paid $4,200 in advance for 6 months' rent on June 1, 2019. All previous months' adjusting entries were made as required. 5. Record the adjusting entry for the consumption of prepaid insurance for the month of October. The preexisting policy has 42 months remaining as of October 1, and recall that the new policy provides coverage for 24-months. The previous months' adjusting entries were made as required. t Record the amount due to employees for time worked during October, but not paid. The amount earned by the employee was $4,400. The payroll taxes should be accrued at 20% of the wages and the entry should be made, payment for these taxes will occur in November 4. CREATE THE ADJUSTED TRIAL BALANCE 5. CREATE THE OCTOBER 31, 2019 INCOME STATEMENT. File Home Insert Draw Formulas Data Review View Calibri (Bo.. . BI UB A B also Sunflower Designs Journal Entry Oct-19 Account Debit Credet Oct. 1 300 Office Supplies Expense Accounts Payable Purchased goods terms, 1/30 300 Oct. 1 3.000 Computers and Softwares Accounts Payable Purchased goods, terms 2/10,n/30. 3,000 Oct. 2 4,500 Prepaid Insurance Cash 4,500 Oct. 4 Wages Expense Wages Payable 3,200 Inventory Accounts Payable Purchased goods terms, 2/10,n/30. 3,200 Accounts Payable Cash Inventory 3,136 Oct. 10 Accounts Payable Cash Oct 12 7.SRO Unearned Revenue Design Revenue 7.580 Journal Entries Trial Balance Income Statement Balance Sheet File Home Insert Draw Formulas Data Review View Calibri (Bo... 1 . B I U I A E 22 Unearned Revenue Design Revenue Oct. 14 16,400 Accounts Receivable Design Revenue terms, 2/10, 1/30 16,400 Wages Expense Payroll Taxes Expense Cash Cash Office Supplies Expense Oct. 20 Cash Furnishing Sales Cost of Goods Sold Inventory Oct 26 Accounts Payable Inventory Oct 30 Cash Accounts Receivable Journal Entries Trial Balance Income Statement Balance Sheet Home Insert ACCT 211 LP 2 Template Draw Formulas Data Review View BIUA 225 . October 1, 2013 Begling Transactions from journal Otober 10, 2015 United Entries through Trial Balance Adjusting ournal Entries Entries through t.) 16.10.00 1950 100.00 9.21400 10000 1115 Decem 1130 uur Stres 1125 A dept 1140 Macht 1150 A d DepE Journal Eneries Trial Balance income statement Balance Sheet