 In this presentation, we will discuss the comprehensive problem, goals of the comprehensive problem, and components of the comprehensive problem. We will be working the payroll problem in Excel. This is going to be the Excel worksheet support accounting instruction by clicking the link below giving you a free month membership to all of the content on our website broken out by category further broken out by course. Each course then organized in a logical, reasonable fashion, making it much more easy to find what you need than can be done on a YouTube page. We also include added resources such as Excel practice problems, PDF files, and more like QuickBooks backup files when applicable. So once again, click the link below for a free month membership to our website and all the content on it. We're going to have a few tabs that we will be jumping back and forth through not too much jumping. We're going to try to put as much on an individual spreadsheet as possible, but there will be three tabs to the problem. We've got the register and record. We got the GL tab and we've got the W2 and W3. These three here are going to be the answer tab. So we're going to go through just the answers seen this information all filled out. And then these three tabs are going to be where we can work the problem. So when we work the problem, we're going to be in these three tabs and we can always refer back to the answer key to see what has been input and how it's being input. The goal of this problem is to be comprehensive enough so that we can see multiple time periods that we will be going through. And we can also see the register as compared to the earnings records for individuals. We can also see the journal entries. I'm going to go to the second tab, post the journal entries as we go, see how that would be posted to a general ledger, and see how the general ledger can then be used to create the trial balance over here. And so and then we also want to see the end of the time period problems, worksheets and information and tax reports, which include the W2 and the W3. This is going to be a kind of a worksheet within excels that we can use formulas to see this information for the W2 and the W3. We'll also show the documents from irs.gov, the actual documents, and we'll fill out the 941s with this information. These are going to be the quarterly documents and the 941b, which is going to be our our deposits. And then the 941 for a second quarter, we're going to be doing the last two quarters in a year with the assumption that we are starting a new company in the middle of the third quarter. And then we'll be entering the data and then we'll have two quarters of the year to record the 941s, a quarterly report, and the related schedule Bs. And then the year end 940. It's going to be the 940 form in the year end. And then we'll have to show the W2s and the W3. Now, because the W2 and W3 do not allow us to have a data input in the system, that's why in Excel, which worked out well, because it actually is nice to use formulas, we have the W2 and the W3 here in Excel, just like a mock data input form. So we can see how this gets put together. So that's going to be a lot of jumping, of course, because we're going to try to go through an entire year of payroll, because really, we can get into any component of payroll in order to do that, in order to jump through the entire year and be able to tie out what happens on an individual pay period to the quarterlys to the quarterly reports to the year end summary reports, and the creation of the W2 and the W3 and the 940. We're going to we're going to try not to get too complex so that we can have the ability to not get too bogged down in individual pay periods. Therefore, we've chosen to have monthly pay periods rather than bi-weekly or semi-monthly or weekly, which is probably not the most common type of pay period, but it will allow us to enter less data for a month and a half's worth, a quarter and a half to one and a half quarters or two quarters worth of information without having too much detail in there so that we can see the big picture and see how everything ties together. So we'll enter data into the payroll register and we'll do that on a monthly basis. So each month we'll enter the data into the payroll register for our employees. We're going to have four of them. And we're also going to enter the data into the earnings record over here. And this is going to be the record for each individual employee. And this will show us not only what happened for that employee during a particular pay period, but the sum up to a particular date. So we're going to be going through August, September, October, November, new company starting in August. And so we can see the data for the all the all the data for any individual employee. We'll also take the information I'm going to scroll back to the left from the payroll register to create the journal entries. So we'll then go to the second tab. I'm going to the second tab over here. And we're going to enter this information into the journal entries. Now, the journal entries are one from accounting standpoint. They're one of the most complex type of journal entries we have. You can see the journal entries quite long to enter this data into the journal entry. And we basically need two of them to record any payroll. And that doesn't matter if we do the payroll in-house or if we do it with a third party that completes the payroll, we still need to record it into our system and be able to understand what's happening in the system, whether we use an automated system or a manual system, whether we use a third party to do the payroll or not. So we've got to understand from an accounting standpoint, this payroll journal entry.