Chapter 8 Comprehensive Payroll One-Month Project Using QuickBooks

Dear Students,

The purpose of this project is to manually calculate and enter the payroll data for the month of December in the software of QuickBooks as it was indicated in the step-by-step instructions provided below. In addition, this project offered you the great opportunity to get familiarized with the Manual Payroll feature of the software of QuickBooks.

In order to complete this Comprehensive Payroll Project using QuickBooks desktop Version in chapter 8, you MUST use 2019 QuickBooks Desktop and follow the step-by-step instructions provided in your textbook website at lablearning.com/qbd-install. Then, please activate a FIVE-Month trial of the 2019 QuickBooks Desktop software that will allow you to work with sample company files using the QuickBooks software. Please, be aware that this free software is not compatible with Mac  computers.

Please, see the instructions on the inside front cover of this book or on the documentation provided to you when you purchased your ebook. Please, make sure that you install the right version 2019 QuickBooks Desktop in your computer order to complete this project.

Complete Comprehensive One-Month Payroll Project using the QuickBooks 2019 Desktop Version by following the ONE-MONTH PROJECT instructions provided in Chapter 8 from page 234 to page 237. You MUST submit your assignment before Monday, April 12, 2021 at 11:59 PM.

Please, click on this web link to access the students portable files for this course from the following website http://labyrinthelab.com/lrc/in order to download and save them in USB drive or C:drive before trying to restore the portable company file using the 2019 QuickBooks Desktop Software.

** CAUTION: Please, remember that QuickBooks files provided for you are already set up. Please, keep in mind:
• All employees, their year-to-date earnings, and tax payments have been entered.
• QuickBooks records the journal entry with each payroll check you create. You won’t need to prepare additional entries.
• There may be small errors due to rounding and how historical data is calculated in QuickBooks.
You can use the File menu to restore a portable company file or open a company file. The last company file open when QuickBooks was exited is the file that opens automatically when QuickBooks is next started. When you save a transaction, it’s simultaneously saved to the QuickBooks working company file, so you don’t have to issue a separate save command, as you would in Microsoft Word or Excel.

In this exercise, you will restore the portable company file you will use for the one-month project. ** CAUTION: This exercise assumes QuickBooks 2019 is installed on your computer. For installation guidance, please refer to the QuickBooks Installation Guide: lablearning.com/qbd-install
1. Start QuickBooks 2019.
A splash screen displays the version of QuickBooks you’re launching and opens the program window. If this is the first time you’ve used the QuickBooks installation on this computer, the QuickBooks Setup window will appear.
2. Choose FileOpen or Restore Company.
3. Choose Restore a Portable File and click Next.
4. Navigate to your file storage location, click Ellipses Corp. (Portable), and click Open.
5. Click Next and save the file as: Ellipses Corp.
It may take up to a few minutes for the portable company file to open. If prompted, choose to update all options and click Get Updates. Close the update window when the process is complete. (Intuit provides maintenance releases throughout the lifetime of the product, and this may require you to update the files before working with them.)
6. Type Password1 and click OK.
7. Click OK to close the QuickBooks Desktop Information window and, if necessary, close the Accountant Center window and the New Feature tour windows.

For more details, please refer to the following  documents. It is crucial to read them.

• QuickBooks Installation Guide- 2019 QuickBooks Desktop
• Using QuickBooks for Payroll
• Chapter 8 Important Notes & Hints for Comprehensive One-Month Project Using QuickBooks Desktop Version

 Here is the steps by step on how to create PAYROLL TAX FORMS in QuickBooks and solve any error message while you are exporting the forms in Excel

  * Select REPORTS at the top menu bar > Employees & Payroll > More Payroll Reports in Excel > Tax Form Worksheets.
  *  If prompted by the Excel security warning, saying macros are not enabled in Excel, follow the directions to enable macros for your version of Excel.
   * Choose the type of tax worksheet you want to create and the dates, click Create Report.

Below are the step by step on How To Enable Macros In Excel 2013-2016

   (1) Click the File Tab (top-left most tab in the window)
   (2) Click the Excel Options button.
   (3) Click Trust Center in the menu on the left.
   (4) Click Trust Center Settings in the window on the right.
   (5) In the new window that opens click Macro Settings in the menu on the left.
   (6) Select Enable all macros.

Please, watch the following short tutorials on how to use the software of the 2019 QuickBooks desktop.

• QuickBooks Desktop Pro 2019 Tutorial Restore a Company File from a Local Backup Copy Intuit Training
• QuickBooks Pro 2019 Restore Backup File - QuickBooks Desktop 2019 https://youtu.be/lBPc3Lw7Tmo
• Backup And Restore QuickBooks Company file (Flash drive) https://youtu.be/tBP2fyzh3Gw
• QuickBooks Desktop Pro 2019 Tutorial Exporting Reports to Microsoft Excel Intuit Training 
  https://youtu.be/jurKGy_iAHM

Watch these short tutorials on how to set up and run payroll in QuickBooks:

• https://www.youtube.com/watch?v=Pgehae0jdGE
• https://www.youtube.com/watch?v=dPsit2wO5SM

If you have any technical issues with 2019 QuickBooks Desktop software, then please contact Intuit Education Support

https://quickbooks.intuit.com/learn-support/en-us/contact

https://www.intuit.com/partners/education-program/support/

Requirements:

Export the following required reports to Microsoft Excel and submit them in this forum. In QuickBooks, you will have the ability to export any payroll report to an existing Excel file. In that way, you will be able to see ONE Excel file that includes different sheets with the three (3) payroll summary reports & SUTA calculations in ONE Excel file. In addition, you should submit your payroll tax forms (W-2, W-3, form 941 and form 940).

• Run Payroll Summary Report that summarizes December for each of the four employees. and export the report to Microsoft Excel
• Run Payroll Summary Report that summarizes the 4th quarter (October-December) and export the report to Microsoft Excel
• Run Payroll Summary Report that summarizes payroll data for the entire year and export the report to Microsoft Excel
• Calculate total SUTA tax owed for the year by Ellipses Corp., the employer and provide it to the instructor via a Microsoft Excel file.
• Complete Form 941 for the 4th quarter for Ellipses Corp.
• Complete the Annual Form 940 for Ellipses Corp.
• Based on the QuickBooks reports previously generated, complete COPY A of Form W-2 for each of the four employees.
• Based on the QuickBooks reports previously generated, complete Form W-3 for Ellipses Corp.