PLEASE PROVIDE STEP BY STEP ON WHAT TO DO IN QUICKBOOKS

In this exercise, you will create your Baked Caf company file from scratch. You will be making some decisions and working off the checklist youve been updating as you create and customize the company file. The password is Password1. Continue to use the Baked Caf Company Checklist file youve already started or open it from the EYS Miscellaneous Files folder for Chapter 02 if you havent completed any of the previous chapters EYS exercises.

You have a staff of 5, which includes: you (as the owner), a master baker, a QuickBooks administrator, an apprentice baker, and an office manager. You sell catering services in the form of trays of baked goods, whole cakes, and boxes of cookies. There is no retail store. You own the 1-story building, which houses the office space and the 2,000-square foot baking and packaging space.

Create a new company file named Baked Caf using the Advanced Setup method, referring to the checklist and the information provided below. You will not add customers, vendors, or employees during the setup process (they will be brought in from Excel), but you will set up the Checking account.

Once the company setup process is complete, you will customize the file to suit your needs.

Set these preferences: Use Account Numbers, Estimates, Statements, Class Tracking; choose to display the Sales Receipt task icon on the Desktop.

Chart of Accounts:

- Rename 50900Food Purchases account to 50900Baking Ingredient Purchases and change the description to: Purchase of any baking ingredient.

- Create four subaccounts to 50900Baking Ingredient Purchases: 50910Dry Ingredients, 50920Wet Ingredients, 50930Seasonings & Extracts, and 50940Fruits and Nuts.

- Add 42200Workshop Sales and 60100Baking Professional Services.

- Delete 12400Food Inventory, since Baked Caf will not stock food items.

Lists:

- Add Website and Social Media as Customer Types to better track customer acquisition.

- Edit Job Type list: Corporate, Education, Private

- Add three classes: Overhead, Catering, Workshops, Products

Users: Set up an AP/AR Clerk user using Password2 as the password and assign proper permissions.

Services: Add these services, which will contain subitems after they are imported: 100 - Cupcakes, 200 - Cakes, 300 - Cheese Cakes, 400 - Cookies, 500 - Round Cakes

Customers, Vendors, Service, and Non-Inventory Items: Use the Add Multiple feature, opening the Import file and being sure to click the appropriate sheet tab and copying these ranges: Customers: A2:P7, Vendors: A2:O8, Service Items: A2:E20, Non-Inventory Items: A2:E4

Edits:

- Edit Customer Rosario Tejedes as Customer Type: Social Media, Payment Terms: Net 30, Account Number: C230004

- Edit Vendor Roses Catering as Vendor Type: Baking Professional, Account Default: 60100Baking Professional Services, Vendor ID: 011-11-1111, eligible for 1099, Payment Terms: Net 30, Account Number V230001

- Edit Item 110 to include the description information from the Import worksheet. (Do this for each item, as the copy/paste does not bring in the descriptions.)

- Edit the Non-Inventory Items, adding the information from the Import worksheet for each item. Make each a two-sided item before entering the information.

Transactions and Chart of Accounts Changes:

- The January American Express bill includes a receipt for linen supplies (tablecloths, napkins, and doilies) in the amount of $5,280.23 on January 8 from Kerekes Bakery & Restaurant Equipment Inc. You decide to track the linen expenses in a separate account (64000Linens) and add linens to the item list (6000 Linens). Assign overhead as the class. You will write a check on 01/29/23 for the full amount for the new item.

- A handwritten note: Tarrytown Union Free School District has accepted your bid to be its dessert provider. Set up a new 42100Catering Sales income subaccount to track this revenue stream and call it 42110Education Sales.

- An email requesting an order for the Tarrytown Union Free School District Spring Fling. Youve decided to do job tracking for your company, so create a job for this customer with Education as the job type. Then create the invoice using Catering as the class for the Spring Fling on 01/20/23 to be held on 03/19 for:

4 each of Items #210 - Whole Sheet Yellow Cakes; #215 - Whole Sheet Chocolate Cakes; #115 - Whole Sheet of Yellow Cupcakes - Themed, and #125 - While Sheet of Chocolate Cupcakes - Themed

10 of Item # 410 - Boxes of Grandmas sugar cookies

- Use the terms Net 30 and Nontaxable for the invoice, and then receive payment for check #1208 for the job on 01/28/23.

Reports: Run the Profit & Loss by Class, Profit & Loss by Job, and Balance Sheet Standard reports for all dates. Save this file as a portable file