Aloha Properties is located at 4-356 Kuhio Highway, Suite A-1. Kapaa Kauai, HI 96746. Its phone...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
how to set up the QuickBooks Accountant file for Aloha Properties based on the information provided 1 Create a New Company File Open QuickBooks Accountant Go to the File menu and select New Company 2 ... View the full answer
Posted Date:
Students also viewed these organizational behavior questions
-
Lisa Hunter has been in business for two years and her company, Hunter Environmental Consulting (HEC), has been very successful. Lisa would like to expand the business by opening offices in central...
-
Crane Manufacturing is considering the purchase of a new sewing machine that costs $19200. The machine, because of its efficiency, will save about $4160 in cost each year. The machine is expected to...
-
The Desert Harbor Inn has been in business for more than 100 years but was recently renovated. On January 1, 2004, the balance sheet of the company was as shown on the next page. During 2004, the inn...
-
What are the possible sources of error in this project?
-
The data in the table describe retail furniture store sales ($ billions) versus housing starts over a 5-year time period. a. Determine the least-squares regression equation for predicting retail...
-
As of the end of June, the job cost sheets at Racing Wheels, Inc., show the following total costs accumulated on three custom jobs. Job 102 was started in production in May and the following costs...
-
Thomas Brookie went shopping in the Winn Dixie Supermarket. He purchased his items and brought them to the car without incident. He then made additional trips in and out of the store to get empty...
-
Refer to the data in Exercise 162 for Weller Corporation. Required: Compute the following financial ratios for long-term creditors for this year: Times interest earned ratio. Debt-to-equity ratio.
-
Other than the wind speed, what factor has the most impact on the amount of power generated by a wind turbine? Swept area of rotor Turbine style Terrain Blade material.
-
The soil mass in Figure P9-13 is loaded by a force transmitted through a circular footing as shown. Determine the stresses in the soil. Compare the values of r using an axisymmetric model with the ...
-
The studies on gloves and music are fascinating. Something else to think about: Will this lead to a disruptive technology in the music industry? Could this bring the music industry back into K-12...
-
Amara typically exercises for 30 minutes a day, 5 days a week. If she is permanently picking up two more shifts at work, what would a fitness mentor MOST LIKELY recommend for her to manage increased...
-
While leaning out a window that is 7.10 m above the ground, you drop a 0.600-kg basketball to a friend at ground level. Your friend catches the ball at a height of 1.00 m above the ground. Determine...
-
Suppose a major storm takes the pipeline for gasoline "offline" for a short period of time. During that time, the price of gasoline sold increased 30%. Some will label this as "price gouging". Using...
-
Summarize the case study given below Winning the Sydney to Hobart- A Case Study in Project Management Lynn Crawford, University of Technology, Sydney PMI Proceedings, 1993, pp. 53-59 INTRODUCTION...
-
1. Who is required to prepare consolidation accounts? 2. When is the preparation of consolidated accounts not required? 3. When would goodwill on consolidation be considered impaired?
-
"Imagine you are going to build e-commerce software for an online store. The software will need authentication and there are two kinds of users, the customer, and the administrator. The customer can...
-
The MIT Sloan School of Management is one of the leading business schools in the U.S. The following table contains the tuition data for the masters program in the Sloan School of Management. a. Use...
-
Consider an EPR state \(|\phiangle_{A B}\); Alice measures the spin on \(z\), then Bob measures it on \(x\), and then Alice measures it again on \(z\). Classify the possible answers for the second...
-
Explore whether the original Bell inequality can be violated at large angles as well.
-
Instead of the Bell-CHSH inequality in the text, consider an inequality obtained in the same way from \(\tilde{M}=\left(A+A^{\prime} ight) B^{\prime}+\left(A-A^{\prime} ight) B\) instead of \(M\). Is...
Study smarter with the SolutionInn App