just Adjusted Trial Balance

Adjusted Trial Balance

4. S Lurry Oristal Perfumes & Coats Ch April, 2017. Mr. dady kumalheu perfumes cometic business Luxury Oriental Perfumes & Comic: The business with coming ele. The following recents that happened on April 27 1. Ape . Shady metod 90,000 Ainahan parlame Oudelled the cometi the cmt 10.000 SAR in exchange for any Lary Oriental Perfumes & Cosmetics 2. Ape 1. Luxury Oriental Perfumes & Cosmetic Med building to be med for wascheuse e signing the note pale SAR .000 The Laxary Oriental Perfumes & Cosmetics to pay interest 3. Apr 2.Luxury Oriental Perfumes & Cosmetics USAR for yearly Lease policy that will pre Mach 31. 2018 Ape Lunar Oriental Perfumes & Commelin Elibition pound the con 12.000 SAR l The full payment in September 2017 Ape 5. Luxury Oriental Perfumes & Cosmetics 13.00 SAR Biles andre ping 10.000 SAR and he Ape 6 Low Oriental Perfume & Cosmetics and lobes starting Monday Apr 11.2017. Fach laboragement set the salary tab 3 SAR -de werweck Sunday is of days. Fue payment is May 2017 7. Ape Lery Oriental Perfumes & Coat 1000 Squreshop supplies X. Ap & Luxury Oriental Perfumes & Cosmetics Reserved 70.000 SAR Bences Age Luxury Orkestar Perfumes & Cases Select one of the bacal advertising company for the 2.000 SAR the company will complete the advertisement service on Ap 12 Lasery Oriental Perfumes & Cemetes Poid 2.000 SARA dowe pomagal to pay the balance de after the 10 A 12 Lasery Oriental Perfumes & Cesare Paid he wilde to the local advertising company after they conduhod the rece 11. Ape 15 Luxury Oriental Perfumes & Cosmetics Red 7.000 SAR i cash Ahmed (adicators of the main the red on Apr 26, 2017 12. Ape 19. Len Oriental Perfumes & Cosmetics Provide Hairdressing nice for 16.000 SAR to Yousseady's relatives and he age was the deler 13. Ap 25 nary Ovita Perfumes & Comte Red 5.000 SAR onkin avance for a pervation of office to face the sensold be provided on May 2, 2017 14. Apr 26. Luxury Oriental Perfumes & Commerce Ahmed we had paid in scheme carlie is performed . PNU_CBA Not for publication 15. Apr 27 Luxury Oriental Perfumes & Cosmetics med of the same trom Youssef (Shady's relatives 16. A 29 Oriental Tom & CompuSSAR 17. Ap 10 Lary Ortal Perfumes & Component of year's profit of 4.000 SAR cash Regalred: Apply the contigodend wordesting 1. Analyze business action 2. Jurmaline the traction 3 Posto Lastract 4 Prepare adjusted trial balance $. Jourse and post ajuste Extraje de Apel 0307 Supplies on hund SOSAR There Prepares nejusted trial hace 7. Prepare the financial statemente Sected coming statement Salement of Financial powing the Journaling Thepura Pow-closing trial once Note that the excel file should include ? shoes dels and proberfoma Set 5-Adrested trial balance Luxury Oriental Perfumes & Cosmetics On April 1, 2017, Mr. shady Kamal began perfumes and oud oil and cosmetics business, Luxury Oriental Perfumes & Cosmetics. The business will have a monthly accounting cycle. The following are some events that happened on April 2017. 1. Apr I. Shady invested 90,000 SAR in cash and some perfumes, Oudoil, and other cosmetics that cost 10,000 SAR in exchange for ordinary shares in Luxury Oriental Perfumes & Cosmetics. 2. Apr 1. Luxury Oriental Perfumes & Cosmetics Purchased building to be used for warchouse for signing 5 months note payable for SAR 80,000. The note Luxury Oriental Perfumes & Cosmetics to pay interest at an annual rate of 12% 3. Apr 2. Luxury Oriental Perfumes & Cosmetics Paid 90,000 SAR for a yearly Lease policy that will expire March 31, 2018 4. Apr 3. Luxury Oriental Perfumes & Cosmetics rented a stall in Exhibition ground that cost 12,000 SAR semiannual. The full payment due in September 30, 2017. 5. Apr 5, Luxury Oriental Perfumes & Cosmetics purchased 13,000 SAR Rose Water Bottles and other accessories paying 10,000 SAR and the balance on account. 6. Apr 6. Luxury Oriental Perfumes & Cosmetics haired 3 labors starting Monday Apr 10, 2017. Each labor agreement set the salary to be 360 SAR for a six-day workweek (Sunday is off day). First payment is May 9, 2017 7. Apr 7. Luxury Oriental Perfumes & Cosmetics Paid 10,000 SAR to acquire shop supplies. 8. Apr 8, Luxury Oriental Perfumes & Cosmetics Received 30,000 SAR for services performed 9. Apr 9. Luxury Oriental Perfumes & Cosmetics Signed an advertisement contract with one of the local advertising company for advertisement that cost 29.000 SAR the company will complete the advertisement service on Apr 12. Luxury Oriental Perfumes & Cosmetics Paid 2,000 SAR on Apr 9 as a down payment and agreed to pay the balance due after the advertisement 10. Apr 12. Luxury Oriental Perfumes & Cosmetics Paid the total amount due to the local advertising company after they conducted the service. 11. Apr 15. Luxury Oriental Perfumes & Cosmetics Received 7,000 SAR in cash from Ahmed (a client) for a reservation of Bridal makeup essentials service to be provided on Apr 26, 2017 12. Apr 19. Luxury Oriental Perfumes & Cosmetics. Provide Hairdressing service for 16,000 SAR to Youssef (shady's relatives) and he agree to pay the total amount due later. 13. Apr 25. Luxury Oriental Perfumes & Cosmetics. Received 5,000 SAR cash in advance for a reservation of office inauguration fragrance services. The service should be provided on May 2, 2017 14. Apr 26. Luxury Oriental Perfumes & Cosmetics perform the service to Ahmed, who had paid in advance earlier this month. PNU_CBA uses Not for publication 15. Apr 27. Luxury Oriental Perfumes & Cosmetics received 50% of the total amount due from Youssef (Shady's relatives) 16. Apr 29. Luxury Oriental Perfumes & Cosmetics paid 5,500 SAR utilities bill. 17. Apr 30. Luxury Oriental Perfumes & Cosmetics paid dividends out of last year's profits of 4.0XX) SAR cash 15. Apr 27. Luxury Oriental Perfumes & Cosmetics received 50% of the total amount due from Youssef (Shady's relatives) 16. Apr 29. Luxury Oriental Perfumes & Cosmetics paid 5,500 SAR utilities bill. 17. Apr 30. Luxury Oriental Perfumes & Cosmetics paid dividends out of last year's profits of 4,000 SAR cash. Required: Apply the accounting cycle and worksheet using excel 1. Analyze business transaction 2. Journalize the transaction 3. Post to Ledger accounts. 4. Prepare an unadjusted trial balance 5. Journalize and post adjusting entries. Extra adjustment data appears on April 30,2017 consist of: Supplies on hand 3000 SAR. Depreciation expense 5600 6. Prepare an adjusted trial balance 7. Prepare the 4 financial statements (Income Statement, retained earnings statement, Statement of Financial position) following the standards. 8. Journalive and post-closing entries 9. Prepare a Post-closing trial balance Note that the excel file should include 7 sheets (with linked cells and prober formula) Sheet 5- Adjusted trial balance 4. S Lurry Oristal Perfumes & Coats Ch April, 2017. Mr. dady kumalheu perfumes cometic business Luxury Oriental Perfumes & Comic: The business with coming ele. The following recents that happened on April 27 1. Ape . Shady metod 90,000 Ainahan parlame Oudelled the cometi the cmt 10.000 SAR in exchange for any Lary Oriental Perfumes & Cosmetics 2. Ape 1. Luxury Oriental Perfumes & Cosmetic Med building to be med for wascheuse e signing the note pale SAR .000 The Laxary Oriental Perfumes & Cosmetics to pay interest 3. Apr 2.Luxury Oriental Perfumes & Cosmetics USAR for yearly Lease policy that will pre Mach 31. 2018 Ape Lunar Oriental Perfumes & Commelin Elibition pound the con 12.000 SAR l The full payment in September 2017 Ape 5. Luxury Oriental Perfumes & Cosmetics 13.00 SAR Biles andre ping 10.000 SAR and he Ape 6 Low Oriental Perfume & Cosmetics and lobes starting Monday Apr 11.2017. Fach laboragement set the salary tab 3 SAR -de werweck Sunday is of days. Fue payment is May 2017 7. Ape Lery Oriental Perfumes & Coat 1000 Squreshop supplies X. Ap & Luxury Oriental Perfumes & Cosmetics Reserved 70.000 SAR Bences Age Luxury Orkestar Perfumes & Cases Select one of the bacal advertising company for the 2.000 SAR the company will complete the advertisement service on Ap 12 Lasery Oriental Perfumes & Cemetes Poid 2.000 SARA dowe pomagal to pay the balance de after the 10 A 12 Lasery Oriental Perfumes & Cesare Paid he wilde to the local advertising company after they conduhod the rece 11. Ape 15 Luxury Oriental Perfumes & Cosmetics Red 7.000 SAR i cash Ahmed (adicators of the main the red on Apr 26, 2017 12. Ape 19. Len Oriental Perfumes & Cosmetics Provide Hairdressing nice for 16.000 SAR to Yousseady's relatives and he age was the deler 13. Ap 25 nary Ovita Perfumes & Comte Red 5.000 SAR onkin avance for a pervation of office to face the sensold be provided on May 2, 2017 14. Apr 26. Luxury Oriental Perfumes & Commerce Ahmed we had paid in scheme carlie is performed . PNU_CBA Not for publication 15. Apr 27 Luxury Oriental Perfumes & Cosmetics med of the same trom Youssef (Shady's relatives 16. A 29 Oriental Tom & CompuSSAR 17. Ap 10 Lary Ortal Perfumes & Component of year's profit of 4.000 SAR cash Regalred: Apply the contigodend wordesting 1. Analyze business action 2. Jurmaline the traction 3 Posto Lastract 4 Prepare adjusted trial balance $. Jourse and post ajuste Extraje de Apel 0307 Supplies on hund SOSAR There Prepares nejusted trial hace 7. Prepare the financial statemente Sected coming statement Salement of Financial powing the Journaling Thepura Pow-closing trial once Note that the excel file should include ? shoes dels and proberfoma Set 5-Adrested trial balance Luxury Oriental Perfumes & Cosmetics On April 1, 2017, Mr. shady Kamal began perfumes and oud oil and cosmetics business, Luxury Oriental Perfumes & Cosmetics. The business will have a monthly accounting cycle. The following are some events that happened on April 2017. 1. Apr I. Shady invested 90,000 SAR in cash and some perfumes, Oudoil, and other cosmetics that cost 10,000 SAR in exchange for ordinary shares in Luxury Oriental Perfumes & Cosmetics. 2. Apr 1. Luxury Oriental Perfumes & Cosmetics Purchased building to be used for warchouse for signing 5 months note payable for SAR 80,000. The note Luxury Oriental Perfumes & Cosmetics to pay interest at an annual rate of 12% 3. Apr 2. Luxury Oriental Perfumes & Cosmetics Paid 90,000 SAR for a yearly Lease policy that will expire March 31, 2018 4. Apr 3. Luxury Oriental Perfumes & Cosmetics rented a stall in Exhibition ground that cost 12,000 SAR semiannual. The full payment due in September 30, 2017. 5. Apr 5, Luxury Oriental Perfumes & Cosmetics purchased 13,000 SAR Rose Water Bottles and other accessories paying 10,000 SAR and the balance on account. 6. Apr 6. Luxury Oriental Perfumes & Cosmetics haired 3 labors starting Monday Apr 10, 2017. Each labor agreement set the salary to be 360 SAR for a six-day workweek (Sunday is off day). First payment is May 9, 2017 7. Apr 7. Luxury Oriental Perfumes & Cosmetics Paid 10,000 SAR to acquire shop supplies. 8. Apr 8, Luxury Oriental Perfumes & Cosmetics Received 30,000 SAR for services performed 9. Apr 9. Luxury Oriental Perfumes & Cosmetics Signed an advertisement contract with one of the local advertising company for advertisement that cost 29.000 SAR the company will complete the advertisement service on Apr 12. Luxury Oriental Perfumes & Cosmetics Paid 2,000 SAR on Apr 9 as a down payment and agreed to pay the balance due after the advertisement 10. Apr 12. Luxury Oriental Perfumes & Cosmetics Paid the total amount due to the local advertising company after they conducted the service. 11. Apr 15. Luxury Oriental Perfumes & Cosmetics Received 7,000 SAR in cash from Ahmed (a client) for a reservation of Bridal makeup essentials service to be provided on Apr 26, 2017 12. Apr 19. Luxury Oriental Perfumes & Cosmetics. Provide Hairdressing service for 16,000 SAR to Youssef (shady's relatives) and he agree to pay the total amount due later. 13. Apr 25. Luxury Oriental Perfumes & Cosmetics. Received 5,000 SAR cash in advance for a reservation of office inauguration fragrance services. The service should be provided on May 2, 2017 14. Apr 26. Luxury Oriental Perfumes & Cosmetics perform the service to Ahmed, who had paid in advance earlier this month. PNU_CBA uses Not for publication 15. Apr 27. Luxury Oriental Perfumes & Cosmetics received 50% of the total amount due from Youssef (Shady's relatives) 16. Apr 29. Luxury Oriental Perfumes & Cosmetics paid 5,500 SAR utilities bill. 17. Apr 30. Luxury Oriental Perfumes & Cosmetics paid dividends out of last year's profits of 4.0XX) SAR cash 15. Apr 27. Luxury Oriental Perfumes & Cosmetics received 50% of the total amount due from Youssef (Shady's relatives) 16. Apr 29. Luxury Oriental Perfumes & Cosmetics paid 5,500 SAR utilities bill. 17. Apr 30. Luxury Oriental Perfumes & Cosmetics paid dividends out of last year's profits of 4,000 SAR cash. Required: Apply the accounting cycle and worksheet using excel 1. Analyze business transaction 2. Journalize the transaction 3. Post to Ledger accounts. 4. Prepare an unadjusted trial balance 5. Journalize and post adjusting entries. Extra adjustment data appears on April 30,2017 consist of: Supplies on hand 3000 SAR. Depreciation expense 5600 6. Prepare an adjusted trial balance 7. Prepare the 4 financial statements (Income Statement, retained earnings statement, Statement of Financial position) following the standards. 8. Journalive and post-closing entries 9. Prepare a Post-closing trial balance Note that the excel file should include 7 sheets (with linked cells and prober formula) Sheet 5- Adjusted trial balance