Exercise 3-2 and 3-3

Ck. No. Date Description of Transaction Payment Deposit Balance 1 10/17 1 Balance 48,128.29 1018 10/19 | Office Suppliers1 100.34 48,028.45 1019 10/20 Moss Advertising 125.00 47,903.45 10/20 Cash Sales* [2,000+122] Sales Receipt 1002 2,122.00 50,025.45 1020 10/23 Cellular Service (Cell service is Telephone expense) 82.13 49,943.32 1021 10/25 Journal of Accounting (Dues & Subscriptions) 75.00 49,868.32 1022 10/29 Hour Deliveries (Freight & Delivery Expense) 42.40 49,825.92 ATM2 10/30 Village Restaurant3 (Meal with clients) 126.40 49,699.52 10/30 Cash Sales [1,500+91.50] Sales Receipt 1003 1,591.50 51,291.02 1023 10/30 Paper Supply Co. (Stationery & Printing) 425.22 50,865.80 1024 10/30 Hour Deliveries 22.25 50,843.55 1025 10/30 Office Suppliers 19.99 50,823.56 Bank accounts 101 Checking In QuickBooks $50,823.56 Figure 3-46: Bank accounts balance 4. Continue with @ Exercise 3-2. Exercise 3-2: Follow the instructions below to complete Exercise 3-2: Page 137 1. Export the Journal, Trial Balance, Profit and Loss, and Balance Sheet as Excel and Adobe PDF files. The date range is 10/1/20XX to 10/30/20XX. 2. Use these file names: Exercise 3-2 October Journal Exercise 3-2_October Trial Balance Exercise 3-2_October Profit and Loss Exercise 3-2_October Balance Sheet Hint: Another way to save Adobe PDF files is to Export to Excel and save the file. Then, on Excel's file menu, click File > Save as Adobe PDF > Convert to PDF> go to the location to save the PDF file. Steps are included in Appendix A, Troubleshooting. Troubleshooting: Page 138 0) When the PDF file displays, right-click > select Save as > go to the location where you want to save the file > type the file name. 1) If exporting to Excel is not working, exit Excel and try again. Or, sign out and sign back in. Check Your Figures: Account No. 101 Checking, $50,823.56 Account No. 207 Arizona Department of Revenue Payable, $366.00 Account No. 401 Sales, $6,000.00 Account No. 601 Advertising Expense, $125.00 Account No. 605 Dues & subscriptions, $150.00 Account No. 619 Meals and Entertainment. $126.40 Account No. 621 Office Supplies, $226.85 Account No. 627 Shipping and delivery expense, $47.00 Net income, $4,457.56 Total Liabilities and Equity, $69,823.56 Exercise 3-3: Problem Solving Problem Solving Exercise 3-3 is available within Connect. It includes: 1. What is the date of the beginning balance? 2. Describe the beginning balance transaction type and the account distribution. 3. What are the steps for accessing the report that shows the beginning balance? 4. When you set up sales tax, what three areas are set up automatically? Ck. No. Date Description of Transaction Payment Deposit Balance 1 10/17 1 Balance 48,128.29 1018 10/19 | Office Suppliers1 100.34 48,028.45 1019 10/20 Moss Advertising 125.00 47,903.45 10/20 Cash Sales* [2,000+122] Sales Receipt 1002 2,122.00 50,025.45 1020 10/23 Cellular Service (Cell service is Telephone expense) 82.13 49,943.32 1021 10/25 Journal of Accounting (Dues & Subscriptions) 75.00 49,868.32 1022 10/29 Hour Deliveries (Freight & Delivery Expense) 42.40 49,825.92 ATM2 10/30 Village Restaurant3 (Meal with clients) 126.40 49,699.52 10/30 Cash Sales [1,500+91.50] Sales Receipt 1003 1,591.50 51,291.02 1023 10/30 Paper Supply Co. (Stationery & Printing) 425.22 50,865.80 1024 10/30 Hour Deliveries 22.25 50,843.55 1025 10/30 Office Suppliers 19.99 50,823.56 Bank accounts 101 Checking In QuickBooks $50,823.56 Figure 3-46: Bank accounts balance 4. Continue with @ Exercise 3-2. Exercise 3-2: Follow the instructions below to complete Exercise 3-2: Page 137 1. Export the Journal, Trial Balance, Profit and Loss, and Balance Sheet as Excel and Adobe PDF files. The date range is 10/1/20XX to 10/30/20XX. 2. Use these file names: Exercise 3-2 October Journal Exercise 3-2_October Trial Balance Exercise 3-2_October Profit and Loss Exercise 3-2_October Balance Sheet Hint: Another way to save Adobe PDF files is to Export to Excel and save the file. Then, on Excel's file menu, click File > Save as Adobe PDF > Convert to PDF> go to the location to save the PDF file. Steps are included in Appendix A, Troubleshooting. Troubleshooting: Page 138 0) When the PDF file displays, right-click > select Save as > go to the location where you want to save the file > type the file name. 1) If exporting to Excel is not working, exit Excel and try again. Or, sign out and sign back in. Check Your Figures: Account No. 101 Checking, $50,823.56 Account No. 207 Arizona Department of Revenue Payable, $366.00 Account No. 401 Sales, $6,000.00 Account No. 601 Advertising Expense, $125.00 Account No. 605 Dues & subscriptions, $150.00 Account No. 619 Meals and Entertainment. $126.40 Account No. 621 Office Supplies, $226.85 Account No. 627 Shipping and delivery expense, $47.00 Net income, $4,457.56 Total Liabilities and Equity, $69,823.56 Exercise 3-3: Problem Solving Problem Solving Exercise 3-3 is available within Connect. It includes: 1. What is the date of the beginning balance? 2. Describe the beginning balance transaction type and the account distribution. 3. What are the steps for accessing the report that shows the beginning balance? 4. When you set up sales tax, what three areas are set up automatically