Using the Quickbooks program, please complete the following problem and send screenshots
Chapter 6 Case 3 ALOHA PROPERTIES Aloha Properties is located at 4-356 Kuhio Highway, Suite A-1, Kapaa Kauai, HI 96746. Its phone number is 808-823-8375, and the corporation specializes in Hawaii Vacation Rentals. Its federal tax ID number is 72-6914707, and it plans to start using Quick Books Accountant as its accounting program on January1, corporation 2014. It has been in business for two years using a manual accounting system. Aloha hopes that you can help it migrate to QuickBooks Accountant. It is a prop- erty rental firm, files Form 1120 each year, and collects a 4% general excise tax (Tax name: HI Sales Tax, Description: Sales Tax) on all rental income, which must be paid to the State of Hawaii Department of Taxation located at P.O. Box ervice 1425, Honolulu, HI 96806-1425. It has chosen to use sales receipts for its cash sales and invoices and statements for its credit sales. The firm would like to use QuickBooks Accountant to keep track of bills it owes but will continue to handwrite checks. It accepts credit and debit cards. Aloha plans to use QuickBooks Accountant's service invoice format but not use progress invoicing. It also plans to use QuickBooks Accountant's payroll features but to continue calculating payroll manually, because it currently has only two W-2 employees. The firm doesn't prepare estimates and does not track employee time or segments. It does, however, plan to enter bills as received and then enter payments later. Reports are to be accrual based, and Aloha plans to use the income and expense accounts created in QuickBooks Accountant for a property management company. It will be providing services only, no 144 Chapter 6 Setting Up Your Business's Accounting System products. Most of its revenue comes from renting properties located on the island of Kauai to individual and corporate accounts. The company's policy is to collect a 50% deposit upon reservation and the balance upon arrival. Some customers (those that have prior credit approval) are invoiced upon arrival with the remaining payment due within 30 days. Deposits are recorded as payments on account, even though revenue is not recorded until customers arrive. Other customers (those without prior credit approval) must pay upon arrival, at which time a sales receipt is generated and the remaining payment is collected Service items are used, but no inventory is maintained. Existing service items, customers, vendors, and employee information are provided below. (Note Deposits for rentals not yet provided are shown as negative numbers.) Service Item Name Moana Unit #1 Moana Unit #2 Moana Unit #3 Moana Unit #4 Villa Kailani Unit #1 Villa Kailani Unit #2 Villa Kailani Unit #3 Villa Kailani Unit #4 Description Moana Unit #1 Moana Unit #2 Moana Unit #3 Moana Unit #4 Villa Kailani Unit #1 Villa Kailani Unit #2 Villa Kailani Unit #3 Villa Kailani Unit #4 Income a/c Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rate $ 2,000 2,500 $ 4,000 $12,000 3,000 4,500 $4,200 $ 6,000 Customer Name Boein General Motors Brice Montoya Sara Rice Apple Computer Balance Due (Deposits) at 12/31/13 $10,000 $75,000 3,000 6,000 $25,000 Vendor Name Reilly Custodial Blue Sky Pools Balance Owed $4,500 $1,800 Fran Aki 128-85-7413 Employee Data Social Security # Hire date Salary Hourly wage Filing status Taxes Daniele Castillo 984-74-1235 S75,000 per year n/a Married with one income Subject to Medicare, Social n/a 20 per hour Subject to Medicare, Social Security, FUTA, and all applicable state taxes Security, FUTA, and all applicable state taxes Filing state Hawaii Hawaii The company owns two properties: Moana located in Princeville and Villa Kailani located in Poipu. As of 12/31/13, it owed S3,875,000 (a 25-year mort- gage classified as a long-term liability called Notes Payable) on the two prop- erties for which it originally paid $2,000,000 and $3,000,000 (respectively) several years ago. Of this amount, $500,000 was identified as land, $250,000 as furniture and equipment, and $4,250,000 as buildings. Use Buildings as the fixed asset account name for the buildings. Accumulated depreciation for all fixed assets as of 12/31/13 was $1,200,000. Setting Up Your Business's Accounting System Chapter6 145 The company has one checking account, which had a balance of $15,000 on 12/31/13 with the Bank of Hawaii (account name: checking). Its Hawaii withholding, unemployment, and disability identification number is 84325|8452. Its unemployment tax rate s 1.9%, and the disability tax rate is 0.01%. Only two payroll items are used: Salary and Hourly. Federal taxes are paid to the U.S. Treasury, and state taxes are paid to the State of Hawaii Department of Taxation quarterly. All employees are paid monthly You've been asked to reclassify the balance in the Opening Balance Equity account as Capital Stock (S10,000) and Retained Earnings ($70,000). You've also been asked to use account names, not numbers, for all accounts. Use the information provided here to create a new QuickBooks Accountant file for Aloha. (Hint: Read the entire case before you begin, establish the new company file accepting the default name provided, and modify preferences as you did earlier in the chapter. Enter all beginning asset, liability, and equity account balances as of 12/31/13. Use journal entry adjustments to close the Opening Balance Equity account so that there is $10,000 in the Capital Stock account and $24,700 in the Retained Earnings account. Change account names and delete accounts not used so they match up with the following trial balance.) After adjustments, the trial balance at 1/1/14 should look like Figure 6.42. Aloha Properties Trial Balance As of January 1, 2014 Figure 6.42 Aloha Properties Trial Balance as of January 1, 2014 Jan 1, 14 Debit Credit 15,000,00 101,000.00 Accumulated Depreciation Buildings Furniture and Equipment 1,200,000.00 4,250,000.00 250,000.00 500,000.00 Accounts Payable Notes Payable Capital Stock Opening Bal Equity Retained Earnings TOTAL 6,300.00 3,875,000.00 10,000.00 0.00 24.700 5,116,000.00 5,116,000.00 Requirements: Once you've entered all the beginning information, print the following reports as of 1/1/14. (Be sure to keep this QuickBooks Accountant file in a safe place; it will be used as a starting file for this case in Chapter 7.) 1 Customer Balance Summary 2 Vendor Balance Summary 3 Employee Contact List (Employee and SS No. only) 4 Account Listing (Account, Type, and Balance Total only 5 Item Listing (list only Item, Description, Type, and Price) 6 Trial Balance Chapter 6 Case 3 ALOHA PROPERTIES Aloha Properties is located at 4-356 Kuhio Highway, Suite A-1, Kapaa Kauai, HI 96746. Its phone number is 808-823-8375, and the corporation specializes in Hawaii Vacation Rentals. Its federal tax ID number is 72-6914707, and it plans to start using Quick Books Accountant as its accounting program on January1, corporation 2014. It has been in business for two years using a manual accounting system. Aloha hopes that you can help it migrate to QuickBooks Accountant. It is a prop- erty rental firm, files Form 1120 each year, and collects a 4% general excise tax (Tax name: HI Sales Tax, Description: Sales Tax) on all rental income, which must be paid to the State of Hawaii Department of Taxation located at P.O. Box ervice 1425, Honolulu, HI 96806-1425. It has chosen to use sales receipts for its cash sales and invoices and statements for its credit sales. The firm would like to use QuickBooks Accountant to keep track of bills it owes but will continue to handwrite checks. It accepts credit and debit cards. Aloha plans to use QuickBooks Accountant's service invoice format but not use progress invoicing. It also plans to use QuickBooks Accountant's payroll features but to continue calculating payroll manually, because it currently has only two W-2 employees. The firm doesn't prepare estimates and does not track employee time or segments. It does, however, plan to enter bills as received and then enter payments later. Reports are to be accrual based, and Aloha plans to use the income and expense accounts created in QuickBooks Accountant for a property management company. It will be providing services only, no 144 Chapter 6 Setting Up Your Business's Accounting System products. Most of its revenue comes from renting properties located on the island of Kauai to individual and corporate accounts. The company's policy is to collect a 50% deposit upon reservation and the balance upon arrival. Some customers (those that have prior credit approval) are invoiced upon arrival with the remaining payment due within 30 days. Deposits are recorded as payments on account, even though revenue is not recorded until customers arrive. Other customers (those without prior credit approval) must pay upon arrival, at which time a sales receipt is generated and the remaining payment is collected Service items are used, but no inventory is maintained. Existing service items, customers, vendors, and employee information are provided below. (Note Deposits for rentals not yet provided are shown as negative numbers.) Service Item Name Moana Unit #1 Moana Unit #2 Moana Unit #3 Moana Unit #4 Villa Kailani Unit #1 Villa Kailani Unit #2 Villa Kailani Unit #3 Villa Kailani Unit #4 Description Moana Unit #1 Moana Unit #2 Moana Unit #3 Moana Unit #4 Villa Kailani Unit #1 Villa Kailani Unit #2 Villa Kailani Unit #3 Villa Kailani Unit #4 Income a/c Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rate $ 2,000 2,500 $ 4,000 $12,000 3,000 4,500 $4,200 $ 6,000 Customer Name Boein General Motors Brice Montoya Sara Rice Apple Computer Balance Due (Deposits) at 12/31/13 $10,000 $75,000 3,000 6,000 $25,000 Vendor Name Reilly Custodial Blue Sky Pools Balance Owed $4,500 $1,800 Fran Aki 128-85-7413 Employee Data Social Security # Hire date Salary Hourly wage Filing status Taxes Daniele Castillo 984-74-1235 S75,000 per year n/a Married with one income Subject to Medicare, Social n/a 20 per hour Subject to Medicare, Social Security, FUTA, and all applicable state taxes Security, FUTA, and all applicable state taxes Filing state Hawaii Hawaii The company owns two properties: Moana located in Princeville and Villa Kailani located in Poipu. As of 12/31/13, it owed S3,875,000 (a 25-year mort- gage classified as a long-term liability called Notes Payable) on the two prop- erties for which it originally paid $2,000,000 and $3,000,000 (respectively) several years ago. Of this amount, $500,000 was identified as land, $250,000 as furniture and equipment, and $4,250,000 as buildings. Use Buildings as the fixed asset account name for the buildings. Accumulated depreciation for all fixed assets as of 12/31/13 was $1,200,000. Setting Up Your Business's Accounting System Chapter6 145 The company has one checking account, which had a balance of $15,000 on 12/31/13 with the Bank of Hawaii (account name: checking). Its Hawaii withholding, unemployment, and disability identification number is 84325|8452. Its unemployment tax rate s 1.9%, and the disability tax rate is 0.01%. Only two payroll items are used: Salary and Hourly. Federal taxes are paid to the U.S. Treasury, and state taxes are paid to the State of Hawaii Department of Taxation quarterly. All employees are paid monthly You've been asked to reclassify the balance in the Opening Balance Equity account as Capital Stock (S10,000) and Retained Earnings ($70,000). You've also been asked to use account names, not numbers, for all accounts. Use the information provided here to create a new QuickBooks Accountant file for Aloha. (Hint: Read the entire case before you begin, establish the new company file accepting the default name provided, and modify preferences as you did earlier in the chapter. Enter all beginning asset, liability, and equity account balances as of 12/31/13. Use journal entry adjustments to close the Opening Balance Equity account so that there is $10,000 in the Capital Stock account and $24,700 in the Retained Earnings account. Change account names and delete accounts not used so they match up with the following trial balance.) After adjustments, the trial balance at 1/1/14 should look like Figure 6.42. Aloha Properties Trial Balance As of January 1, 2014 Figure 6.42 Aloha Properties Trial Balance as of January 1, 2014 Jan 1, 14 Debit Credit 15,000,00 101,000.00 Accumulated Depreciation Buildings Furniture and Equipment 1,200,000.00 4,250,000.00 250,000.00 500,000.00 Accounts Payable Notes Payable Capital Stock Opening Bal Equity Retained Earnings TOTAL 6,300.00 3,875,000.00 10,000.00 0.00 24.700 5,116,000.00 5,116,000.00 Requirements: Once you've entered all the beginning information, print the following reports as of 1/1/14. (Be sure to keep this QuickBooks Accountant file in a safe place; it will be used as a starting file for this case in Chapter 7.) 1 Customer Balance Summary 2 Vendor Balance Summary 3 Employee Contact List (Employee and SS No. only) 4 Account Listing (Account, Type, and Balance Total only 5 Item Listing (list only Item, Description, Type, and Price) 6 Trial Balance
