OVERVIEW - Week 13 - Chapter 10 (Banking).html ACED 3101-IA Computerized Office Accounting OVERVIEW OF WEEK 13 - CHAPTER 10 (BANKING) In Chapter 10, we will be focusing on Banking (Transferring Funds,...

Quickbooks assignment-exported thru excel


OVERVIEW - Week 13 - Chapter 10 (Banking).html ACED 3101-IA Computerized Office Accounting OVERVIEW OF WEEK 13 - CHAPTER 10 (BANKING) In Chapter 10, we will be focusing on Banking (Transferring Funds, Reconciling Accounts, and Entering Credit Card Charges).  You should open your QuickBooks 2018 textbooks to Chapter 10 and begin reading and highlighting the important concepts.  When instructed to in the reading, you should load the Chapter 10 company file.  The company file you will need to work in Chapter 10 is provided for you in Content, Week 13.  Please locate this file and use the dropdown arrow to the right of the file and then choose Download form the menu that appears. Once again, you will be opening, backing up, restoring, and changing the company name for our data file in Chapter 10.  When Backing Up and Restoring, you should use the ACED 3101 Work Files folder you created on your computer. As an aid, a video demonstration has been provided for Chapter 10.  The file can be found in the Content area of BlazeView, in Week 13, below the link you clicked on for the information you are reading now.  My hope is that you will open this video and listen/watch it before you work on Chapter 10.  You can pause, rewind, fast forward, etc. as needed.  Since online students don't have the added advantage of being in the class with me, I am hoping that this audio file will be the next best thing.  Please let me know if it is helpful or not. The Learning Objectives for Chapter 10 are listed below: Chapter 10 Objectives (Banking) Transfer funds between accounts using the Transfer Funds between Accounts window Reconcile cash accounts using the Reconcile window Enter credit card charges using the Enter Credit Card Charges window Pay credit card charges using the Write Checks window Display and print banking-related reports, accounting reports, and financial statements INSTRUCTIONS FOR CHAPTER 10 (BANKING) To use as a learning aid, there is a demonstration video for Chapter 10.  The link for this video can be found in the Content area of BlazeView, in Week 13, below the link you clicked on for the information you are reading now.  The best method for working through Chapter 10 would be to watch/listen to the demonstration video first before reading and working through the lesson.  Listed below are the specific links that you will see in our Week 13 Module.  Please follow the instructions below very carefully: 1.  VIDEO - Chapter 10 Demonstration (Banking) A video has been provided for you to watch an accountant demonstrate and discuss the major procedures associated with Chapter 10. The video is the second link in the Week 13 Module.  Click the link and watch the professional demonstrate how to do the QuickBook procedures concerning payroll setup. 2.  TEXTBOOK - Chapter 10 (Banking) Return to our Week 13 Module and locate the textbook link here in BlazeView.  This link will open your eBook to Chapter 10 or you can just use your printed textbook (printed textbook might be easier to work from).  As you are reading, please highlight or underline important concepts in your book so that you can refer to them later when doing your review questions and case problem.  Work carefully through the entire chapter, performing all of the steps given.  This will take you about an hour and a half. 3.  DATA FILE for Lesson - CH10 Kristin Raina Interior Designs For all of our chapter lessons, we pretend that we are working for an interior designer. The link with this name is for you to use to load QuickBooks 2018 and open CH10 Kristin Raina Interior Designs.  Simply return to BlazeView, Week 13 Content, and click the dropdown arrow next to the Kristin Raina file and choose "download."   4.  ASSIGNMENT - Review Questions - Chapter 10 (Banking) After you finish watching the Chapter 10 video demonstration and working through the Chapter 10 lesson, you are ready for your review questions.  For this assignment, you will complete 40 review questions over terms and procedures you have learned while working through Chapter 10 - Banking. To complete this graded assignment, students should return to Week 13's Content and click on the assignment named ASSIGNMENT - Chapter 10 Review Questions; the SNAP document will load, and you will prompted to answer multiple-choice questions related to Chapter 10's content.  You may redo these questions as many times as you desire until you score your desired grade.  SNAP will post your grade in our BlazeView gradebook. This assignment is worth 40 points and is due by 11:59 p.m., EST, on Saturday, April 11, 2020. 5. TEXTBOOK - End of Chapter Pages and Case Problem 1 Instructions The link with this name in the Week 13 Module will provide eBook pages for a quick overview of the chapter and then the instructions and transactions for Case Problem 1. You may also use your printed textbook if you prefer. 6. DATA FILE - Chapter 10 - Case Problem 1 For all of our Case Problem 1 problems, we will pretend that we work for a music studio. The link in Week 13 module with this name is for you to load QuickBooks 2018 and open CH10 Lynn's Music Studio company file.  Simply return to BlazeView, Week 13 Content, and click the dropdown arrow next to the DATA FILE - Lynn's Music Studio and choose "download."  A company file icon will then appear in the bottom left of your screen.  When it stops animating, click it.  Your software (QuickBooks 2018) will load first; then you will have the Update Company questions (follow the instructions in our book); after that, you will most likely have to answer the password questions that are now showing up (Student1).  CH10 Lynn's Music Studio will then load. 7. SNAP CHECKER AND GRADER - Chapter 10 - Case Problem 1 - Detail Bank Reconciliation Report  and SNAP CHECKER AND GRADER - Chapter 10 - Case Problem 1 - Journal Report For each chapter that we work through this semester, students will be given the opportunity to exhibit their new skills in a graded assignment.  We will accomplish this for Chapter 10 through the use of the Case Problem 1 on pages 429 through 430 of our textbooks.  This assignment has two reports (Detail Bank Reconciliation report and Journal report)  Each is worth 50 points for a total of 100 points.  Both are due Saturday, April 11, 2020, by 11:59 p.m., EST.  The instructions are as follows: Turn to page 429 Locate Case Problem 1 Use the skills you have acquired in Chapter 10 to complete instructions 1-12 on pages 429 through 430. Be especially careful when opening, backing up, restoring, and Changing the Company Name that you DON't skip the fifth step--Changing the company name.  This must be done AFTER you have backed up and restored.   When you get to Step 9, rather than "Printing" the Detail Bank Reconciliation Report, you should "Display" it.  When you are ready, click Excel and export this report.  Save this spreadsheet using the filename Ch10 Bank Reconciliation - Your Last Name.   Close Excel. When you get to Step 12, you should display the reports required in steps a, b, c, and d.  The second report that you will submit for your grade for this assignment is in Step c, the Journal.   Be careful to change the dates to 06/30/2019 through 07/31/2019. Once the Journal report appears on your screen, you are ready to export it to Excel. Use the button at the top of the Journal report to export this report to Excel. On your Excel screen, click File, Save As, and save your report in the ACED 3101 Work Files Folder using the filename Ch10 Journal - Your Last Name. Close Excel; it is very important that you CLOSE EXCEL The SNAP Checker and Grader program will mark the cells that are incorrect for you.  You can decide if you are satisfied with the number of errors or decide if you want to re-do your Detail Bank Reconciliation report or your Journal report. This program will also post your finished grades into our BlazeView gradebook.  Students may check their work up to a total of five times. This assignment is due by 11:59 p.m., EST on Saturday, April 11, 2020. SPECIAL ASSIGNMENT Students who are OAT majors AND have already received experiential credit for their internships need to upload some of their course assignments to an OAT portfolio.  If you are an OAT major and WILL do an internship (ACED 4300), then disregard these instructions (you are NOT required to do a portfolio).  This special assignment is only for those students who have completed the Experiential Credit form along with letters from employers, etc. and have received credit for ACED 2940 on their transcripts.  If you are one of these students, a portfolio has already been created for you.  You can find it in your BlazeView list of classes; you may have already seen it.  The name of it is ACED OAT Outcomes Assessments CO.  It should be listed as one of your classes on your BlazeView opening screen. This portfolio will simply be a collection of various assignments that you've already done from some of your OAT courses. Instructions have been provided here in our course for those of you who qualify to upload your Chapter 10 Banking - Reconciliation Report to your portfolio; it's the same file you will submit for your case problem.  You will see those instructions in Content - Week 13 at the very end of the assignments list. 397 10CHAPTER Objectives • Transfer funds between accounts using the Transfer Funds Between Accounts window • Reconcile cash accounts using the Reconcile window • Enter credit card charges using the Enter Credit Card Charges window • Pay credit card charges using the Write Checks window • Display and print banking-related reports, accounting reports, and financial statements Banking Transferring Funds, Reconciling Accounts, and Entering Credit Card Charges 398 CHAPTER 10 | Banking An integral part of operating any business is effectively managing cash. This usually involves maintaining cash in one or more bank accounts. In addition, it involves transferring funds among the bank accounts, recon- ciling account balances, using credit cards for business purchases, and making credit card payments. QuickBooks allows you to transfer funds from one bank account to another, process the month-end bank reconcili- ation, and enter and pay credit card charges using the Banking menu at the main menu bar. Many companies have more than one checking account. The regular checking account, commonly known as the operating account, is used to pay bills and collect and deposit receivables and other funds. Usually, a company maintains a separate checking account solely for payroll transac- tions. Periodically, funds from the operating checking account are trans- ferred to the payroll checking account to
Apr 21, 2021
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here