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 QuickBooks Accountant as its accounting program on January 1, 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 property 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 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 corporation service Chapter 6 Sewing Up Your Bodien products. property management company. It will be providing services only, no 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 (those that have prior credit approval) are invoiced upon arrival with the a 50% deposit upon reservation and the balance upon arrival. Some customers remaining payment due within 30 days. Deposits are recorded as payments on account, even though revenue is not recorded until customers arrive. Other cus- tomers (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, custom- ers, vendors, and employee information are provided below. (Note: Deposits for rentals not yet provided are shown as negative numbers.) Description Moana Unit #1 Moana Unit #2 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 Customer Name Boeing General Motors Brice Montoya Sara Rice Apple Computer Vendor Name Reilly Custodial Blue Sky Pools Employee Data Social Security # Hire date : Salary Hourly wage Filing status Taxes Moana Unit #3 Moana Unit #4 Villa Kailani Unit #1 Villa Kailani Unit #2 Villa Kailani Unit #3 Villa Kailani Unit #4 Balance Due (Deposits) at 12/31/13 $ 10,000 $ 75,000 -$3,000 -$6,000 $ 25,000 Balance Owed $4,500 $1,800 Income a/c Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Rental Income Fran Aki 128-85-7413 1/1/12 $75,000 per year in/a Married with one income Subject to Medicare, Social Security, FUTA, and all applicable state taxes Hawaii Rate $ 2,000 $ 2,500 $ 4,000 $12,000 $ 3,000 $ 4,500 $ 4,200 $ 6,000 231TR39009 ANDIA Daniele Castillo 984-74-1235 1/1/12 n/a $20 per hour Single Subject to Medicare, Social Security, FUTA, and all applicable state taxes Hawaii Filing state The company owns two properties: Moana located in Princeville and Villa Kai- lani located in Poipu. As of 12/31/13, it owed $3,875,000 (a 25-year mortgage fied as a long-term liability called Notes Payable) on the two properties for which it originally paid $2,000,000 and $3,000,000 (respectively) several years ago. Of this e classi- 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 build- ings. Accumulated depreciation for all fixed assets as of 12/31/13 was $1,200,000. 12/3 hole une pay Tre tio ace als fil co yo a C Setting Up Your Business's Accounting System 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 with- holding, unemployment, and disability identification number is 8432518452. Its unemployment tax rate is 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 Taxa- tion quarterly. All employees are paid monthly. You've been asked to reclassify the balance in the Opening Balance Equity account as Capital Stock ($10,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 Checking Accounts Receivable Accumulated Depreciation Buildings Furniture and Equipment Land Accounts Payable Notes Payable Capital Stock Opening Sal Equity Retained Earnings TOTAL Jan 1,14 Debit 15,000.00 191,000.00 4.250,000.00 250.000.00 500,000.00 0.00 Credit 1,200,000.00 6,300 00 3.875,000 00 10,000.00 24.700.00 5,116,000.00 $115,000.00 Chapter 6 Figure 6.42 Aloha Properties Trial Balance as of January 1, 2014 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