Practice Set 1-Service Business RECORD TRANSACTIONS Enter the transactions for Your Name's Concierge for You and print as indicated. When preparing invoices, use an Intuit Service Invoice form, a message of your choosing, and do not e-mail invoices or accept online payments. Start numbering the Invoices with number 35 and Sales Receipts with the number 22. Unless the transaction indicates something different, use lines. Provide transaction memos when needed for clarification. Print invoices, sales receipts credit memos, and checks as they are entered. Unless instructed to do so by your professor, o not t print Payment Receipts and Bills (even if not printed, they are included on the transmittal sheet t). Always resize the columns in reports to display information in full. Week 1: January 1-6,2018: PS company name and legal name from Your Name's Concierge for You to Your ame's Concierge for You(Type your actual name! For example, Robin Rosen would enter Robin Rosen's Concierge for you) Check with your instruc Report Header/ Footer should not include the Date Prepared, Time Prepared, or the Report Basis. If so, make the changes. tor to see if you should change Report Preferences so that the Service, Name: Transport, Description: Transportation; Rate: 35.00. Account: Services Change the Capital account Student's Name, Capital to Your Name, Capital. (Use your own name.) Find all accounts with the name Automobile as part of the account name. Change every occurrence of Automobile to Business Vehicles. Delete any unwanted descriptions Find all accounts with the name Office Equipment as part of the account name. Change every occurrence of Office Equipment to Office Furniture/Equipment. Delete any unwanted descriptions. Make the following inactive: Interest Expe Delete the following accounts: Reimbursed Expenses, Sales, Amortization Expense, Professional Development, and Recruiting. Add Petty Cash to the Chart of Accounts. Transfer $100 from Checking to Petty Cash to fund the account. Use January 1, 2018 as the transaction date Print an Account Listing in Portrait orientation. Customize the Report on the Header/Footer tab change the Subtitle to show the date: January 1, 2018. Hide the columns for Description and Tax Line and resize any columns that are not displayed in full. If you print to a pdf file, save the nse: Mortgage: Taxes: Property. Travel & Ent. document as 1-Your Name Acct List PS1 Prior to recording any transactions, print a Trial Balance as of January 1, 2018. If you print to a pdf file, save the document as 2-Your Name Trial Bal PS1 Change the name of the vendor Canon Drive Stationers to Canon Stationers. Change the description for the sales item Pets from Pet Sitting to Pet Care. We were out of paper, toner cartridges for the laser printer, and various other office supplies that we need to have on hand. Received a bill-Invoice 8106-from Canon Stationers for $450 for the office supplies we received today. (Even though the Bills are listed on the transmittal sheet, check with your instructor to see if you should print them. If you do print Bills, print without lines around each field.) If you print to a pdf file, save the document as 3-Your Name Bill Canon Stationers PS1. mplete Course 272 QUICKBOOKS DESKTOP 2018: A Co Dr. Adam Cohen has arranged for you to take his dogs to the vet for shots an walk his dogs 1 hour per day every day. Bill Dr. Cohen for 3 hours for one hour a day for 14 days, terms Net 30. (Refer to the Item List for the appropriate sales items and put this all on Invoice 35. Remember to use an Intuit Service Invoice as business form.) Use an appropriate customer message and print the invoice without lines. On the Name Information Changed dialog box, click "No" so you do not change the terms for Dr. Cohen from Net 15 to Net 30. If you print to a pdf file, save the document as 4-Your Name Inv 35 Cohen PS1. transport and Pet Care Samantha Waters is having a party in two weeks. Bill Samantha Waters for 12 hours of party planning. Invoice 36, terms Net 30. If you print to a pdf file, save the document as 5-Your Name Inv 36 Waters PS1 12/18 Mr. Weaver's mother has several doctor appointments. He has asked Your Name's Concierge for You to take her to these appointments. Bill Jack Weaver for 8 hours of transportation (Because of the current date of your computer and terms of net 10, you will find that this and many of the invoices you prepare will be marked Past Due. Disregard this message.,) If you print to a pof file, save the document as 6-Your Name Inv 37 Weaver PS1. 1/3/18 Gloria Elliott needed to have her shelves relined. You did part of the house this week and will return next week to continue the work. Bill her for 12 hours of household chores for this week. If you print to a pdf file, save the document as 7-Your Name Inv 38 Elliott PS1 1/4/18 Record the bill from Western Insurance, (7654 Western Avenue, Hollywood Phone 310-555-1598, Main Email: Westernins@abc.com, Fax 310-555-8951, terms Net 30) for Business Vehicles Insurance for the year, $2,400, Invoice 2287. If you print to a save the document as 8-Your Name Bill Western Ins PS1. pdf file, ks for Customer Payments on account for balances dated 12/31/2017 from the ollowing customers: Dr. Ramon Valdez, $275, Check 713; Roberto Romero, $250, Check 36381; Jack Weaver, $450, Check 6179; Joseph Lane, $1,000, Check 38142. (Even though the Payment Receipts are listed on the checklist, check with your instructor to see if you should print them.) If you print to a pdf file, save the document as 9-Your Name R PS1, 10-Your Name Rcv Pmt Romero PS1, 11-Your Name Rcv Pmt Weaver PS1, 12-Your Name Rcv Pmt Lane PS1. cv Pmt Valdez 1/5/18 Prepare Sales Receipt 22 to record a cash sale. Received Check 2894 for 2 hours of errands and 1 hour of household chores for a new customer: Fatema Nasseri, 18062 Beverly Drive, Beverly Hills, CA 90210, Main Phone: 310-555-7206, Fax: 310-555-6027, Main E-mail: FNasseri@abc.com, Payment Terms: Net 10, Preferred Delivery Method: None. Note: Remember to key the last name first for the customer name.) Print the sales receipt. If you print to a pdf file, save the document as 13-Your Name SR 22 Nasseri PS1 1/6/18 Prepare Unpaid Bills Detail Report for January 6, 2018. Print the report. If you print to a pdf file save the document as 14-Your Name Unpaid Bills PS1. Pay bills for the amount owed to Wilshire Flowers and Pacific Gasoline on December 31 er to the Vendor List shown on the second page of the practice set or to the Unpaid Bills Detail Report to determine the amounts for the checks. Remember that the due dates will not be 12/31/17t hey will be 01/10/18.) Print the checks using a Standard check style- ey may be printed on one page or individually. If you print to a pdf file, save the document as 15-Your Name Cks 1-2 PS1 Make the bank deposit for the week. Deposit date is 1/6/18. Print a Deposit Summary. If you print to a pdf file, save the document as 16-Your Name Dep Sum PS1 Print Trial Balance from 01/01/18 to 01/06/18. If you print to a pdf file, save the document PS 17-Your Name Trial Bal PS1 Backup your wok ftorthe week. Use Concierge 2018 (Backup Week 1) as the file name. Week 2: January 7-13, 2018 1/9/18 Received checks for payment on accounts from the following customers: Dr. Cohen, $500, No. 7891; Ms. Lim, $200, No. 97452; Ms. Blair, $600, No. 925: Mr. Evans $50, No. 178; and Mr. Austin, $750, No. 3916. If you print to a pdf fle, save the document as 18-Your Name Rcv Pmt Cohen PS1, 19-Rcv Pmt Lim PS1, 20-Rcv Pmt Blair PS1, 21-Rcv Pmt Evans P$1, 22-Rcv Pmt Austin PS1 Received a bill-Invoice 81085-from Pacific Gasoline, $325 for the bi-weekly gasoline charge. If you print to a pdf file, save the document as 23-Your Name Bill Pacific Gasoline PS1 Every week we put fresh flowers in the office to provide a welcoming environment for any customers who happen to come into the office. Received a bill-Invoice 9287-from Wilshire Flowers for $60 for office flowers for two weeks. (Miscellaneous Expense) If you print to a pdf file, save the document as 24-Your Name Bill Wilshire Flowers PS1. 1/10/18 Danielle Blair really likes the floral arrangements in the office of Your Name's Concierge for You. She has asked that flowers be brought to her home and arranged throughout the house. When you complete the placement of the flowers in the house, Danielle gives you Check 387 for $180 for 3 hours of errands and 3 hours of household chores. This is payment in full for three weeks of floral arrangements. Prepare the Sales Receipt. If you print to a pdf file, save the document as 25-Your Name SR 23 Blair PS1. Joseph Lane has arranged for Your Name's Concierge for You to supervise and coordinate the installation of new tile in his master bathroom. Bill Mr. Lane for 5 hours of repair service for hiring the subcontractor, scheduling the installation for 1/14, 1/15 and 1/16, and contract preparation. If you print to a pdf file, save the document as 26-Your Name Inv 39 Lane PS1 Returned faulty printer cartridge that we had purchased in December to have on hand Received Credit Memo 5 from Canon Stationers, $95. (Did you use the asset account?) If you print to a pdf file, save the document as 27-Your Name CM Canon Stationers PS1. QUICKBOOKS DESKTOP 2018: A Compl 274 1/13/18 Pay all bills for the amounts due on or before January 13. (Hint: Are there There should be two checks. Print the checks-all on one page or pdf file, save the document as 28-Your Name Cks 3-4 PS1 Correct Invoice 38 issued to Gloria Elliott on 1/03/18. The num 14 instead of 12. Print the corrected invoice. (Do not change the date.) If you print to a save the document as 29-Your Name Inv 38 Elliott Corrected PS1 Make the bank deposit for the week. Deposit date is 1/13/18. Print a Deposit Summary. If you print to a pdf file, save the document as 30-Your Name Dep Sum PS1. Print Trial Balance from 01/01/18 to 01/13/18. If you print to a pdf file, save the document as 31-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup week 2) as the file name. any credits to apply?) ld be ber of hours billed shou pdf file, Week 3: January 14-20, 2018 1/15/18 Pay postage due 64 cents. Use Petty Cash. Number is 1 for Petty Cash. Print Petty Cash Acco Chart of Accounts. Print in Landscape orientation. If you print to a pdf file, save the document as 32-Your Name Petty Cash QuickReport PS1. unt QuickReport by clicking the Report button at the bottom of the Mr. Lane's bathroom tile was installed on 1/14, 1/15 and 1/16. The installation was completed to his satisfaction. Bill him for 24 hours of repair service. If you print to a pdf file, save the document as 33-Your Name Inv 40 Lane PS1. 1/18/18 Danielle Blair's neighbor, Alex Levin, really liked the flowers in Danielle's house and asked you to bring flowers to his home and office. This week he gave you Check 90-163 for 1 hour of errands and 1 hour of household chores. Add him to the customer list: Alex Levin, Main Phone: 310-555-0918, 236 West Camden Drive, Beverly Hills, CA 90210, Payment Terms: Net 10, Preferred Delivery Method: None. If you print to a pdf file, save the document as 34-Your Name SR 24 Levin PS1. 1/19/18 Tonight is Samantha's big party. She has arranged for both you and Alex to supervise the party from 3 p.m. until 1 a.m. Bill Samantha Waters for 20 hours of party planning and supervision. If you print to a pdf file, save the document as 35-Your Name Inv 41 Waters PS1 Print a Customer Balance Summary Report for all transactions. If you print to a pdf file, save the document as 36-Your Name Cust Bal Sum PS1. 1/20/18 Record the checks received from customers for the week: Mr. Weaver, $280, No. 9165, Ms. Elliott, $150, No. 7-303, Dr. Cohen, $455, No. 89162, and Mr. Lane, $325, No. 38197. If you print to a pdf file, save the document as 37-Your Name Rcv Pmt Weaver PS1, 38-Your Name Rcv Pmt Elliott PS1, 39-Your Name Rcv Pmt Cohen PS1, 40-Your Name Rcv Pmt Lane PS1. 275 Practice Set 1-Service Business Make the bank deposit for the week. Deposit date is 1/20/18. Print a Deposit Summary. If you print to a pdf file, save the document as 41-Your Name Dep Sum PS1 Print Trial Balance from 01/01/18 to 01/20/18. If you print to a pdf file, save the document as 42-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup Week 3) as the file name. Week 4: January 21-272018 1/23/18 Samantha's party went so smoothly on the 19h that you went home at 11 p.m. rather than 1 a.m. (Alex stayed until 1 a.m.) Issue Credit Memo 42 to Samantha Waters for 2 hours of party planning and supervision. Apply the credit to Invoice 41 dated January 19, 2018. If you print to a pdf file, save the document as 43-Your Name CM 42 Waters PS1. Dennis Evans arranged to have his pets cared for by Your Name's Concierge for You during the past 7 days. Bill him for 1 hour of pet care each day. Dennis wants to add a doggie door and a fenced area for his dog. Bill him 24 hours of repair service for the planning and overseeing of the project. If you print to a pdf file, save the document as 44-Your Name Inv 43 Evans PS1 PS Use Petty Cash to pay for a box of file folders to be used immediately in reorganizing some of the files in the office, $14.84. (This is an expense and is Check 2 for Petty Cash.) Print a Petty Cash Account QuickReport in Landscape. Fit the report to one page wide. If you print to a pdf file, save the document as 45-Your Name Petty Cash QuickReport PS1. 1/24/18 You arranged for theater tickets, dinner reservations, and an after-theater surprise party for Dr. Valdez to celebrate his wife's birthday. Bill him for 4 hours of errands, 3 hours shopping for the gift, and 8 hours of party planning. If you print to a pdf file, save the document as 46-Your Name Inv 44 Valdez PS1. Received a bill-Invoice 9802-from Wilshire Flowers for $60 for office flowers for two weeks. If you print to a pdf file, save the document as 47-Your Name Bill Wilshire Flowers PS1. Received a bill Invoice 81116-from Pacific Gasoline, $355 for the bi-weekly gasoline charge. If you print to a pdf file, save the document as 48-Your Name Bill Pacific Gasoline PS1. Write a check to Canon Stationers for the purchase of a new printer for the office, $500. Note: If you get a warning to use Pay Bills because we owe the company money, click Continue Writing Check.) Print the check using standard-style checks. If you print to a pdf file, save the document as 49-Your Name Ck 5 Canon Stationers PS1 276 QUICKBOOKS DESKTOP 2018: A Complete CourgU 1/27/18 Dr. Cohe n has arranged for Your Name's Concierge for You to feed and walk his dogs y day. Bill him for Pet Care, 1 hour per day for the past two weeks. In addition, n is going to have a party and wants Your Name's Concierge for You to planit or him. Bill him for 20 hours party planning. When the dogs were puppies they did some amage to the interior of the house. To prepare for the party several areas in the house need to be reorganized and repaired. Bill him for 18 hours of household chores and 20 hours of repairs. If you print to a pdf file, save the document as 50-Your Name Inv 45 eve Cohen PS1. Write checks to pay for telephone, rent, and utilities. The telephone company will be added to the Vendor List. Vendor information is provided in each transaction. Print checks using standard-style checks. They may to a pdf file, save the document as 51-Your Name Cks 6-8 PS1 o Monthly telephone bill: $150, Bel Air Telephone. Add the vendor: Bel Air Telephone, Main Phone 310-555-4972, 2015 Beverly Boulevard, Bel Air, CA 90047, Payment Terms the be printed as a batch or individually. If you Net 30 Monthly rent for office space: $1,500, Rodeo Realtors. Monthly utility bill for $424.00 from Westside Utilities is for: Water $195 and Gas and Electric $229. o Prepare and print in Portrait orientation an Unpaid Bills Detail Report for January 27. If you print to a pdf file, save the document as 52-Your Name Unpaid Bills PS1. Pay bills for all amounts due on or before January 27. Print checkl(s). If you print to a pdf file, save the document as 53-Your Name Ck 9 Wilshire Flowers PS1. Prepare a Check Detail Report from 1/1/18 to 1/27/18. Use Landscape orientation and fit report to one page wide. If you print to a pdf file, save the document as 54-Your Name Ck Detail PS1 Record payments received from customers: Ms. Waters, $600, No. 4692; Dr. Cohen, $1,550, No. 7942:Mr. Evans, $735, No. 235; Dr. Valdez, $645, No. 601; Ms. Elliott $140, No. 923-10. (If any of the payments are not payments in full, leave as an underpayment Include the Memo: Partial Payment.) If you print to a pdf file, save the document as 55-Your Name Rcv Pmt Waters PS1, 56-Your Name Rcv Pmt Cohen PS1, 57-Your Name Rcv Pmt Evans PS1, 58-Your Name Rcv Pmt Valdez PS1, 59-Your Name Rcv Pmt Elliott PS1 Make the bank deposit for the week. Deposit date is 1/27/18. If you print to a pdf file, save the document as 60-Your Name Dep Sum PS1 Print Customer Balance Detail Report in Portrait orientation for All Transactions. If you print to a pdf file, save the document as 61-Your Name Cust Bal Detail PS1 rint Trial Balance from 01/01/18 to 01/27/18. If you print to a pdf file, save the document as 62-Your Name Trial Bal PS1. your work for the week. Use Concierge 2018 (Backup Week 4) as the file name Back up your work for the week. Use Concierge Week 5: January 28-30, 2018 1/30/18 Write a check for your monthly withdrawal, $1,200. If you print to a pdf file, save th document as 63-Your Name Ck 10 Owner PS1 Since a fax machine is a business necessity, you decided to give your new fa Your Name's Concierge for You. Record this $350 nvestment of equipment by you Practice Set 1-Service Business 277 they are remodeling the offices, Rodeo Realtors decreased the amount of rent to $1,000 per month. Correct and reprint Check 7 for rent payment. If you print to a pdf file, save the document as 64-Your Name Ck 7 Rodeo Realtors Corrected PS1. Record adjusting entries for: o Business Vehicles Insurance, $200 o Office Supplies Used, $150. o Depreciation: Business Vehicles, $500 and Office Furniture/Equipment, $92 Print Trial Balance from 01/01/18 to 01/30/18. If you print to a pdf file, save the document as 65-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup Week 5) as the file name. End of the Month: January 31, 2018 Prepare the bank reconciliation using the following bank statement. Record any adjustments necessary because of the bank statement. PS Golden Bank 1234 Rodeo Drive Beverly Hills, CA 90210 Your Name's Concierge for You 2789 Robertson Boulevard Beverly Hills, CA 90210 Beginning Balance, January 1, 2018 $25,350.00 1/1/2018, Transfer 100.0025,250.00 1/6/2018, Deposit 2,070.00 27,320.00 1/7/2018, Check 1 250.0027,070.00 25.0027,045.00 1/7/2018, Check 2 1/13/2018, Deposit 29,325.00 2,280.00 1/15/2018, Check 3 500.00 28,825.00 255.0028,570.00 1/16/2018, Check4 29,840.00 1,270.00 1/20/2018, Deposit 500.00 29,340.00 1/28/2018, Check5 1,000.00 28,340.00 1/29/2018, Check7 1/31/2018, Payment: Business Vehicles Loan: Interest $551.87; Principal $177.57 729.4427,610.56 1/31/2018, Payment: Office Furniture/ Equipment Loan: Interest $59.45; Principal $15.44 74.89 27,535.67 25.00 27,510.67 1/31/2018, Service Charge 27,563.67 53.00 1/31/2018, Interest $27,563.67 Ending Balance, January 31, 2018 lete Course QUICKBOOKS DESKTOP 2018: A Comp 278 Print a Reconciliation Detail Report. If you print to a pf file, save the document as 66-Your Name Bank Rec PS1. Print the following reports as of 1/31/18: o Trial Balance from 1/1/18 through 1/31/18 in Portrait. if you print to a pdf file, sa document as 67-Your Name Trial Bal PS1. the 2/28/18 in Landscape. If you print to a pdf file, save the document as 68-Your Name Cash Flow Forecast PS1 o Statement of Cash Flows from 1/1/18 through 1/31/18 in Portrait. If you print to a pdf file, save the document as 69-Your Name Stmt of Cash Flows PS1. o Profit & Loss (Standard) from 1/1/18 through 1/31/18 in Portrait. If you print to a pdf file, save the document as 70-Your Name P & L PS1. Transfer the Net Income/Owner's Equity to owner's Capital account. Close the Drawing account. Close the period as of 01/31/18. Do not use any passwords Prepare a Balance Sheet (Standard) as of 1/31/18. Print in Portrait. If you print to a pdf file, save the document as 71-Your Name Bal Sheet PS1 Prepare the Journal from 1/1/18 through 1/31/18, expand the report, print in Landscape orientation, and Fit to 1 page wide. If you print to a pdf file, save the document as 72-Your Name Journal PS1. Create an Archive Backup named Concierge 2018 (Archive 01-31-18). Back up your work for the week. Use Concierge 2018 (Backup Complete) as the file name. Practice Set 1-Service Business RECORD TRANSACTIONS Enter the transactions for Your Name's Concierge for You and print as indicated. When preparing invoices, use an Intuit Service Invoice form, a message of your choosing, and do not e-mail invoices or accept online payments. Start numbering the Invoices with number 35 and Sales Receipts with the number 22. Unless the transaction indicates something different, use lines. Provide transaction memos when needed for clarification. Print invoices, sales receipts credit memos, and checks as they are entered. Unless instructed to do so by your professor, o not t print Payment Receipts and Bills (even if not printed, they are included on the transmittal sheet t). Always resize the columns in reports to display information in full. Week 1: January 1-6,2018: PS company name and legal name from Your Name's Concierge for You to Your ame's Concierge for You(Type your actual name! For example, Robin Rosen would enter Robin Rosen's Concierge for you) Check with your instruc Report Header/ Footer should not include the Date Prepared, Time Prepared, or the Report Basis. If so, make the changes. tor to see if you should change Report Preferences so that the Service, Name: Transport, Description: Transportation; Rate: 35.00. Account: Services Change the Capital account Student's Name, Capital to Your Name, Capital. (Use your own name.) Find all accounts with the name Automobile as part of the account name. Change every occurrence of Automobile to Business Vehicles. Delete any unwanted descriptions Find all accounts with the name Office Equipment as part of the account name. Change every occurrence of Office Equipment to Office Furniture/Equipment. Delete any unwanted descriptions. Make the following inactive: Interest Expe Delete the following accounts: Reimbursed Expenses, Sales, Amortization Expense, Professional Development, and Recruiting. Add Petty Cash to the Chart of Accounts. Transfer $100 from Checking to Petty Cash to fund the account. Use January 1, 2018 as the transaction date Print an Account Listing in Portrait orientation. Customize the Report on the Header/Footer tab change the Subtitle to show the date: January 1, 2018. Hide the columns for Description and Tax Line and resize any columns that are not displayed in full. If you print to a pdf file, save the nse: Mortgage: Taxes: Property. Travel & Ent. document as 1-Your Name Acct List PS1 Prior to recording any transactions, print a Trial Balance as of January 1, 2018. If you print to a pdf file, save the document as 2-Your Name Trial Bal PS1 Change the name of the vendor Canon Drive Stationers to Canon Stationers. Change the description for the sales item Pets from Pet Sitting to Pet Care. We were out of paper, toner cartridges for the laser printer, and various other office supplies that we need to have on hand. Received a bill-Invoice 8106-from Canon Stationers for $450 for the office supplies we received today. (Even though the Bills are listed on the transmittal sheet, check with your instructor to see if you should print them. If you do print Bills, print without lines around each field.) If you print to a pdf file, save the document as 3-Your Name Bill Canon Stationers PS1. mplete Course 272 QUICKBOOKS DESKTOP 2018: A Co Dr. Adam Cohen has arranged for you to take his dogs to the vet for shots an walk his dogs 1 hour per day every day. Bill Dr. Cohen for 3 hours for one hour a day for 14 days, terms Net 30. (Refer to the Item List for the appropriate sales items and put this all on Invoice 35. Remember to use an Intuit Service Invoice as business form.) Use an appropriate customer message and print the invoice without lines. On the Name Information Changed dialog box, click "No" so you do not change the terms for Dr. Cohen from Net 15 to Net 30. If you print to a pdf file, save the document as 4-Your Name Inv 35 Cohen PS1. transport and Pet Care Samantha Waters is having a party in two weeks. Bill Samantha Waters for 12 hours of party planning. Invoice 36, terms Net 30. If you print to a pdf file, save the document as 5-Your Name Inv 36 Waters PS1 12/18 Mr. Weaver's mother has several doctor appointments. He has asked Your Name's Concierge for You to take her to these appointments. Bill Jack Weaver for 8 hours of transportation (Because of the current date of your computer and terms of net 10, you will find that this and many of the invoices you prepare will be marked Past Due. Disregard this message.,) If you print to a pof file, save the document as 6-Your Name Inv 37 Weaver PS1. 1/3/18 Gloria Elliott needed to have her shelves relined. You did part of the house this week and will return next week to continue the work. Bill her for 12 hours of household chores for this week. If you print to a pdf file, save the document as 7-Your Name Inv 38 Elliott PS1 1/4/18 Record the bill from Western Insurance, (7654 Western Avenue, Hollywood Phone 310-555-1598, Main Email: Westernins@abc.com, Fax 310-555-8951, terms Net 30) for Business Vehicles Insurance for the year, $2,400, Invoice 2287. If you print to a save the document as 8-Your Name Bill Western Ins PS1. pdf file, ks for Customer Payments on account for balances dated 12/31/2017 from the ollowing customers: Dr. Ramon Valdez, $275, Check 713; Roberto Romero, $250, Check 36381; Jack Weaver, $450, Check 6179; Joseph Lane, $1,000, Check 38142. (Even though the Payment Receipts are listed on the checklist, check with your instructor to see if you should print them.) If you print to a pdf file, save the document as 9-Your Name R PS1, 10-Your Name Rcv Pmt Romero PS1, 11-Your Name Rcv Pmt Weaver PS1, 12-Your Name Rcv Pmt Lane PS1. cv Pmt Valdez 1/5/18 Prepare Sales Receipt 22 to record a cash sale. Received Check 2894 for 2 hours of errands and 1 hour of household chores for a new customer: Fatema Nasseri, 18062 Beverly Drive, Beverly Hills, CA 90210, Main Phone: 310-555-7206, Fax: 310-555-6027, Main E-mail: FNasseri@abc.com, Payment Terms: Net 10, Preferred Delivery Method: None. Note: Remember to key the last name first for the customer name.) Print the sales receipt. If you print to a pdf file, save the document as 13-Your Name SR 22 Nasseri PS1 1/6/18 Prepare Unpaid Bills Detail Report for January 6, 2018. Print the report. If you print to a pdf file save the document as 14-Your Name Unpaid Bills PS1. Pay bills for the amount owed to Wilshire Flowers and Pacific Gasoline on December 31 er to the Vendor List shown on the second page of the practice set or to the Unpaid Bills Detail Report to determine the amounts for the checks. Remember that the due dates will not be 12/31/17t hey will be 01/10/18.) Print the checks using a Standard check style- ey may be printed on one page or individually. If you print to a pdf file, save the document as 15-Your Name Cks 1-2 PS1 Make the bank deposit for the week. Deposit date is 1/6/18. Print a Deposit Summary. If you print to a pdf file, save the document as 16-Your Name Dep Sum PS1 Print Trial Balance from 01/01/18 to 01/06/18. If you print to a pdf file, save the document PS 17-Your Name Trial Bal PS1 Backup your wok ftorthe week. Use Concierge 2018 (Backup Week 1) as the file name. Week 2: January 7-13, 2018 1/9/18 Received checks for payment on accounts from the following customers: Dr. Cohen, $500, No. 7891; Ms. Lim, $200, No. 97452; Ms. Blair, $600, No. 925: Mr. Evans $50, No. 178; and Mr. Austin, $750, No. 3916. If you print to a pdf fle, save the document as 18-Your Name Rcv Pmt Cohen PS1, 19-Rcv Pmt Lim PS1, 20-Rcv Pmt Blair PS1, 21-Rcv Pmt Evans P$1, 22-Rcv Pmt Austin PS1 Received a bill-Invoice 81085-from Pacific Gasoline, $325 for the bi-weekly gasoline charge. If you print to a pdf file, save the document as 23-Your Name Bill Pacific Gasoline PS1 Every week we put fresh flowers in the office to provide a welcoming environment for any customers who happen to come into the office. Received a bill-Invoice 9287-from Wilshire Flowers for $60 for office flowers for two weeks. (Miscellaneous Expense) If you print to a pdf file, save the document as 24-Your Name Bill Wilshire Flowers PS1. 1/10/18 Danielle Blair really likes the floral arrangements in the office of Your Name's Concierge for You. She has asked that flowers be brought to her home and arranged throughout the house. When you complete the placement of the flowers in the house, Danielle gives you Check 387 for $180 for 3 hours of errands and 3 hours of household chores. This is payment in full for three weeks of floral arrangements. Prepare the Sales Receipt. If you print to a pdf file, save the document as 25-Your Name SR 23 Blair PS1. Joseph Lane has arranged for Your Name's Concierge for You to supervise and coordinate the installation of new tile in his master bathroom. Bill Mr. Lane for 5 hours of repair service for hiring the subcontractor, scheduling the installation for 1/14, 1/15 and 1/16, and contract preparation. If you print to a pdf file, save the document as 26-Your Name Inv 39 Lane PS1 Returned faulty printer cartridge that we had purchased in December to have on hand Received Credit Memo 5 from Canon Stationers, $95. (Did you use the asset account?) If you print to a pdf file, save the document as 27-Your Name CM Canon Stationers PS1. QUICKBOOKS DESKTOP 2018: A Compl 274 1/13/18 Pay all bills for the amounts due on or before January 13. (Hint: Are there There should be two checks. Print the checks-all on one page or pdf file, save the document as 28-Your Name Cks 3-4 PS1 Correct Invoice 38 issued to Gloria Elliott on 1/03/18. The num 14 instead of 12. Print the corrected invoice. (Do not change the date.) If you print to a save the document as 29-Your Name Inv 38 Elliott Corrected PS1 Make the bank deposit for the week. Deposit date is 1/13/18. Print a Deposit Summary. If you print to a pdf file, save the document as 30-Your Name Dep Sum PS1. Print Trial Balance from 01/01/18 to 01/13/18. If you print to a pdf file, save the document as 31-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup week 2) as the file name. any credits to apply?) ld be ber of hours billed shou pdf file, Week 3: January 14-20, 2018 1/15/18 Pay postage due 64 cents. Use Petty Cash. Number is 1 for Petty Cash. Print Petty Cash Acco Chart of Accounts. Print in Landscape orientation. If you print to a pdf file, save the document as 32-Your Name Petty Cash QuickReport PS1. unt QuickReport by clicking the Report button at the bottom of the Mr. Lane's bathroom tile was installed on 1/14, 1/15 and 1/16. The installation was completed to his satisfaction. Bill him for 24 hours of repair service. If you print to a pdf file, save the document as 33-Your Name Inv 40 Lane PS1. 1/18/18 Danielle Blair's neighbor, Alex Levin, really liked the flowers in Danielle's house and asked you to bring flowers to his home and office. This week he gave you Check 90-163 for 1 hour of errands and 1 hour of household chores. Add him to the customer list: Alex Levin, Main Phone: 310-555-0918, 236 West Camden Drive, Beverly Hills, CA 90210, Payment Terms: Net 10, Preferred Delivery Method: None. If you print to a pdf file, save the document as 34-Your Name SR 24 Levin PS1. 1/19/18 Tonight is Samantha's big party. She has arranged for both you and Alex to supervise the party from 3 p.m. until 1 a.m. Bill Samantha Waters for 20 hours of party planning and supervision. If you print to a pdf file, save the document as 35-Your Name Inv 41 Waters PS1 Print a Customer Balance Summary Report for all transactions. If you print to a pdf file, save the document as 36-Your Name Cust Bal Sum PS1. 1/20/18 Record the checks received from customers for the week: Mr. Weaver, $280, No. 9165, Ms. Elliott, $150, No. 7-303, Dr. Cohen, $455, No. 89162, and Mr. Lane, $325, No. 38197. If you print to a pdf file, save the document as 37-Your Name Rcv Pmt Weaver PS1, 38-Your Name Rcv Pmt Elliott PS1, 39-Your Name Rcv Pmt Cohen PS1, 40-Your Name Rcv Pmt Lane PS1. 275 Practice Set 1-Service Business Make the bank deposit for the week. Deposit date is 1/20/18. Print a Deposit Summary. If you print to a pdf file, save the document as 41-Your Name Dep Sum PS1 Print Trial Balance from 01/01/18 to 01/20/18. If you print to a pdf file, save the document as 42-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup Week 3) as the file name. Week 4: January 21-272018 1/23/18 Samantha's party went so smoothly on the 19h that you went home at 11 p.m. rather than 1 a.m. (Alex stayed until 1 a.m.) Issue Credit Memo 42 to Samantha Waters for 2 hours of party planning and supervision. Apply the credit to Invoice 41 dated January 19, 2018. If you print to a pdf file, save the document as 43-Your Name CM 42 Waters PS1. Dennis Evans arranged to have his pets cared for by Your Name's Concierge for You during the past 7 days. Bill him for 1 hour of pet care each day. Dennis wants to add a doggie door and a fenced area for his dog. Bill him 24 hours of repair service for the planning and overseeing of the project. If you print to a pdf file, save the document as 44-Your Name Inv 43 Evans PS1 PS Use Petty Cash to pay for a box of file folders to be used immediately in reorganizing some of the files in the office, $14.84. (This is an expense and is Check 2 for Petty Cash.) Print a Petty Cash Account QuickReport in Landscape. Fit the report to one page wide. If you print to a pdf file, save the document as 45-Your Name Petty Cash QuickReport PS1. 1/24/18 You arranged for theater tickets, dinner reservations, and an after-theater surprise party for Dr. Valdez to celebrate his wife's birthday. Bill him for 4 hours of errands, 3 hours shopping for the gift, and 8 hours of party planning. If you print to a pdf file, save the document as 46-Your Name Inv 44 Valdez PS1. Received a bill-Invoice 9802-from Wilshire Flowers for $60 for office flowers for two weeks. If you print to a pdf file, save the document as 47-Your Name Bill Wilshire Flowers PS1. Received a bill Invoice 81116-from Pacific Gasoline, $355 for the bi-weekly gasoline charge. If you print to a pdf file, save the document as 48-Your Name Bill Pacific Gasoline PS1. Write a check to Canon Stationers for the purchase of a new printer for the office, $500. Note: If you get a warning to use Pay Bills because we owe the company money, click Continue Writing Check.) Print the check using standard-style checks. If you print to a pdf file, save the document as 49-Your Name Ck 5 Canon Stationers PS1 276 QUICKBOOKS DESKTOP 2018: A Complete CourgU 1/27/18 Dr. Cohe n has arranged for Your Name's Concierge for You to feed and walk his dogs y day. Bill him for Pet Care, 1 hour per day for the past two weeks. In addition, n is going to have a party and wants Your Name's Concierge for You to planit or him. Bill him for 20 hours party planning. When the dogs were puppies they did some amage to the interior of the house. To prepare for the party several areas in the house need to be reorganized and repaired. Bill him for 18 hours of household chores and 20 hours of repairs. If you print to a pdf file, save the document as 50-Your Name Inv 45 eve Cohen PS1. Write checks to pay for telephone, rent, and utilities. The telephone company will be added to the Vendor List. Vendor information is provided in each transaction. Print checks using standard-style checks. They may to a pdf file, save the document as 51-Your Name Cks 6-8 PS1 o Monthly telephone bill: $150, Bel Air Telephone. Add the vendor: Bel Air Telephone, Main Phone 310-555-4972, 2015 Beverly Boulevard, Bel Air, CA 90047, Payment Terms the be printed as a batch or individually. If you Net 30 Monthly rent for office space: $1,500, Rodeo Realtors. Monthly utility bill for $424.00 from Westside Utilities is for: Water $195 and Gas and Electric $229. o Prepare and print in Portrait orientation an Unpaid Bills Detail Report for January 27. If you print to a pdf file, save the document as 52-Your Name Unpaid Bills PS1. Pay bills for all amounts due on or before January 27. Print checkl(s). If you print to a pdf file, save the document as 53-Your Name Ck 9 Wilshire Flowers PS1. Prepare a Check Detail Report from 1/1/18 to 1/27/18. Use Landscape orientation and fit report to one page wide. If you print to a pdf file, save the document as 54-Your Name Ck Detail PS1 Record payments received from customers: Ms. Waters, $600, No. 4692; Dr. Cohen, $1,550, No. 7942:Mr. Evans, $735, No. 235; Dr. Valdez, $645, No. 601; Ms. Elliott $140, No. 923-10. (If any of the payments are not payments in full, leave as an underpayment Include the Memo: Partial Payment.) If you print to a pdf file, save the document as 55-Your Name Rcv Pmt Waters PS1, 56-Your Name Rcv Pmt Cohen PS1, 57-Your Name Rcv Pmt Evans PS1, 58-Your Name Rcv Pmt Valdez PS1, 59-Your Name Rcv Pmt Elliott PS1 Make the bank deposit for the week. Deposit date is 1/27/18. If you print to a pdf file, save the document as 60-Your Name Dep Sum PS1 Print Customer Balance Detail Report in Portrait orientation for All Transactions. If you print to a pdf file, save the document as 61-Your Name Cust Bal Detail PS1 rint Trial Balance from 01/01/18 to 01/27/18. If you print to a pdf file, save the document as 62-Your Name Trial Bal PS1. your work for the week. Use Concierge 2018 (Backup Week 4) as the file name Back up your work for the week. Use Concierge Week 5: January 28-30, 2018 1/30/18 Write a check for your monthly withdrawal, $1,200. If you print to a pdf file, save th document as 63-Your Name Ck 10 Owner PS1 Since a fax machine is a business necessity, you decided to give your new fa Your Name's Concierge for You. Record this $350 nvestment of equipment by you Practice Set 1-Service Business 277 they are remodeling the offices, Rodeo Realtors decreased the amount of rent to $1,000 per month. Correct and reprint Check 7 for rent payment. If you print to a pdf file, save the document as 64-Your Name Ck 7 Rodeo Realtors Corrected PS1. Record adjusting entries for: o Business Vehicles Insurance, $200 o Office Supplies Used, $150. o Depreciation: Business Vehicles, $500 and Office Furniture/Equipment, $92 Print Trial Balance from 01/01/18 to 01/30/18. If you print to a pdf file, save the document as 65-Your Name Trial Bal PS1 Back up your work for the week. Use Concierge 2018 (Backup Week 5) as the file name. End of the Month: January 31, 2018 Prepare the bank reconciliation using the following bank statement. Record any adjustments necessary because of the bank statement. PS Golden Bank 1234 Rodeo Drive Beverly Hills, CA 90210 Your Name's Concierge for You 2789 Robertson Boulevard Beverly Hills, CA 90210 Beginning Balance, January 1, 2018 $25,350.00 1/1/2018, Transfer 100.0025,250.00 1/6/2018, Deposit 2,070.00 27,320.00 1/7/2018, Check 1 250.0027,070.00 25.0027,045.00 1/7/2018, Check 2 1/13/2018, Deposit 29,325.00 2,280.00 1/15/2018, Check 3 500.00 28,825.00 255.0028,570.00 1/16/2018, Check4 29,840.00 1,270.00 1/20/2018, Deposit 500.00 29,340.00 1/28/2018, Check5 1,000.00 28,340.00 1/29/2018, Check7 1/31/2018, Payment: Business Vehicles Loan: Interest $551.87; Principal $177.57 729.4427,610.56 1/31/2018, Payment: Office Furniture/ Equipment Loan: Interest $59.45; Principal $15.44 74.89 27,535.67 25.00 27,510.67 1/31/2018, Service Charge 27,563.67 53.00 1/31/2018, Interest $27,563.67 Ending Balance, January 31, 2018 lete Course QUICKBOOKS DESKTOP 2018: A Comp 278 Print a Reconciliation Detail Report. If you print to a pf file, save the document as 66-Your Name Bank Rec PS1. Print the following reports as of 1/31/18: o Trial Balance from 1/1/18 through 1/31/18 in Portrait. if you print to a pdf file, sa document as 67-Your Name Trial Bal PS1. the 2/28/18 in Landscape. If you print to a pdf file, save the document as 68-Your Name Cash Flow Forecast PS1 o Statement of Cash Flows from 1/1/18 through 1/31/18 in Portrait. If you print to a pdf file, save the document as 69-Your Name Stmt of Cash Flows PS1. o Profit & Loss (Standard) from 1/1/18 through 1/31/18 in Portrait. If you print to a pdf file, save the document as 70-Your Name P & L PS1. Transfer the Net Income/Owner's Equity to owner's Capital account. Close the Drawing account. Close the period as of 01/31/18. Do not use any passwords Prepare a Balance Sheet (Standard) as of 1/31/18. Print in Portrait. If you print to a pdf file, save the document as 71-Your Name Bal Sheet PS1 Prepare the Journal from 1/1/18 through 1/31/18, expand the report, print in Landscape orientation, and Fit to 1 page wide. If you print to a pdf file, save the document as 72-Your Name Journal PS1. Create an Archive Backup named Concierge 2018 (Archive 01-31-18). Back up your work for the week. Use Concierge 2018 (Backup Complete) as the file name