 In this presentation, we will record a transaction related to salary's expense into our accounting system. Get ready because here we go with Aplos. Here we are in our not-for-profit organization dashboard. We're going to jump on over to our Excel file to see what our objective will be. We're going to be in tab number six, tab number six where we have our transaction. Here we are in our not-for-profit organization dashboard. We're going to be jumping on over to Excel to see what our objective will be. We're going to be in tab number six. So we're in tab number six. We're going to be recording the salary's expense. Now note that if you're going to be processing payroll through the system, that's going to be an added level of difficulty. We're not going to go through the actual payroll process within the system. We're just going to enter the transaction related to it like any other basically type of expense. If you want to learn more about payroll, we do have a course on payroll and how the payroll transactions work, but that's a whole nother course in and of itself to be processing through the payroll. However, if you think about the payroll for a normal type of business and for a not-for-profit, you have pretty much many of the same kind of concerns about it with regards to withholdings, federal income tax, state income tax, social security, Medicare, types of withholdings on that. And you can also think about doing that either through the accounting system, recording it into the accounting system or seeing if you have a third party, which is common as well to help you out with the payroll. If you have the payroll for it and that could be done by bigger companies or something like an ADP or a Paychex, which would be a third party that could help to process the payroll, and then you'd still have to enter that data in some way, shape, or form into your accounting system. So if we were to simplify the payroll transaction down to its basis and not think about the withholdings and all that kind of stuff, then typically you would just simply have salaries expense being the expense and then the credits to cash. So the purposes of our practice problem to record the expenses, that's what we're going to be recording. So we're just going to record a straight transaction. You can kind of think of it as if we had a third party, like an ADP or Paychex, and then we're taking that information, putting that into the system where they straight journal entry for us, again, not considering the withholdings here. Then we're also going to enter basically our adjusting entry. This is something that you would typically do at the end of the month. In our case, the end of January, where you're going to say, OK, there's some portion of the period that work was done for which payment wasn't made because payroll will typically be done on a more of a cash basis or on a payroll basis, rather than on a strict accrual basis, meaning you get paid every two weeks or paid every week by weekly, weekly, semi-monthly. And that means that the pay date or when you're going to record, it's not going to line up with the cutoff date into the month or year. And therefore, there's going to be time that the workers worked for which they had not yet been paid, but are going to be paid in the following period. And therefore, we should have an adjusting entry at the end of the time period, which will make it easier for the payroll to be to be processed and not have to worry with the added timing problem as well as make the financial statements correct as of the cutoff date. All right. So let's record the first one. First kind of a standard type of journal entry here, as we're going to record it. We're going to go back on into our system, back into Aplos. So let's go then to the accounting fund and accounting. We're going to enter a transaction. Now, the easiest way to enter this transaction because cash is affected will most likely be to use a register type of format. So we're going to go kind of just directly into the register here. So we'll go into the register. We're going to say the date of this transaction is going to be the 6th of January. So let's bring it on back to January, January number six. So let's bring that and then I'm going to tab through this. So the payee I'm going to say is employee. Whoops, I'm going to add this employee one. So that's going to be our employee. And again, I'm going to record like in the entire payroll as if it's one transaction here. So again, you can you can imagine multiple people getting paid with multiple with multiple transactions, possibly that would look similar. And then you might comment could be something like payroll. The amount is we're going to be putting the 209 460. So 209 460. And the deposit is not a deposit check. Now, if it's a check number, you can assign the check number here. And then you can go to the printing feature. Notice there's a printing feature here. If you're going to print checks, then what you would have to do is get the pre-printed checks. You put them into the printer and then you'd have to make sure they're lined up correctly and whatnot. The checks would already have the check number on it. So if you're going to print it, or if it's something that has already been processed, we're imagining it's processed by like an ADP over paychecks electronically. And now we're entering it into our system here. So we're not going to have the check number. And then we're going to say the account we're looking for an expense account and we have the salaries. So salaries looks good. We'll pick that one up. Now, if it wasn't salaries, if we were saying it's some other kind of payroll, we could go to the register and change that. Maybe maybe I just want it to be called wages or something. Maybe they're not salary pay, but we can do that. I would pay, I would use whatever accounts accounts are given to us. And then if we want to tweak the name for them, we can do so. So then the fund that we're going to have is going to be unrestricted. So we're going to go unrestricted. Now note that most of the expenses, the way we're going to format this will be going into the unrestricted. And, and that's going to be because if we pay, if we paid something out, that's going to trigger the release of funds or assets from a restricted to unrestricted, we will record that release happening with a transaction. So we'll show the release going from a restricted to an unrestricted category. And then the expense being in the unrestricted category. So that's how we're going to, that's how we're going to be setting this up. So then we got, so that means that pretty much all the expenses, all the expenses then will be in the unrestricted category. And if we need to unrestrict them, we'll do that with a transaction. We will see that at a later time. So then we have the unrestricted further tag. We're not going to add that now. We will be going back in. Now note, if I go back to our system here, back into Excel, notice now we're entering the expenses. We do have a requirement to enter these expenses in two ways. In essence, one, we have the statement of activities, which we're showing here by function, what we use them for, meaning the programs and then the general admin and the fundraising. And then we need to break them out further by what their objective is or their nature, which is what you would normally think with expenses. So rent, salaries, telephone, so on. Now we could put all this in one report technically, but again, that would be overwhelming to the reader. So what we want to do is create a report with like one or the other of these type of formats and then break out another report kind of like this, which will break out this information for the expenses by what they are used for in order to break them out to what they are used for, such as programs like education, community service, and the admin or management and general and fundraising, we will need to be using some type of percentages that we will have to determine. So what we're going to do now is we're going to enter all this information at this point, just into the system without breaking that out. And then we'll go back in and show you how to break that out. And that might be an easy way to do this kind of breakout because then you can kind of, you can separate and specialize the duties between entering the expenses and between breaking out the expenses to the various categories they need to be broken out into. Also note that the salaries here, we have the one line item. If we need more than one line item, then we can hit the split button. So I can say we want to hit the split button and that's going to give us more line items. So now, of course, we know that this is the checking account. This is basically a register. This will be decreasing the checking account. The other side will be going to the expense account here. And if we needed to add then another expense account, we could do so by adding another expense account below. All right, so let's go ahead and submit it. So we're going to submit, then we'll jump on over to our financial statements, our reports. So we're going to go to the reports to the upper right. We're then going to go into the balance sheet and income statement, the special ones, the fund ones, however, because yes, they're more fun because they're fund ones. And then we're going to go back up top and right click on that tab. We're going to duplicate that tab, duplicating the tab, going back to the tab, the left going back to the reports to the right at the top right. Then we're going to open the other report, which is going to be the income statement, the income statement by fund, income statement by fund going back up top, right, clicking on that report. Let's duplicate that report. Now we got the balance sheet. We got the income statement. Then we got another tab that we can do stuff on. Let's go back on over to the balance sheet. Then adjusting the date and we're going to bring it on back to January, January 31st, January 31st. So there we have that. And we have entered our transaction decreasing the checking account. So I would also add our, we're going to go to the report layout. And I like to add that total column. So I'm going to say add the total column and apply. Now note, this is also something that's pretty much a default that I would, I would like to have most of the time with the total there. So I could say I'd like to save this and I'm going to save this as a custom balance sheet by fund report. So balance sheet by fund report. And we may, we may want to do it. We're, we will do further customization to it at a later point. So, but just note, so I'll actually not save it at this point in time. So we'll talk about that later, but just note you any changes that you make, you could, you could save the report. And then you might even want to think about having saved reports in terms of internal reports, reports that you're going to be jumping into all the time like this, which can be more like worksheet type of reports. And then you can have, and I know I misspelled custom, but I'm not going to save it. So it's okay. And then you can also have the external reports, the ones that are as close as good as possible that you can then give to somebody else for the external reporting and any kind of last minute changes you need to do then that you can't do in the accounting system. You can do by exporting it to Excel. So we'll talk more about that reporting in the future. But in any case, there's the total column here. Then we're going to go into this item. So if we go into the, to the checking account, we're going to, so I went into the unrestricted portion. There's the 209 460 and there is, it's a check type of form because we entered it into the register as a decrease, so a check type of form. Let's go back. I'm going to go back on over to then our balance sheet. Let's then go to the income statements. So if we take a look at the income statement, we want to, we want to see it for the year to date. So this year to date, that's what we would like to see. Then let's hit the old dropdown on the right. Let's see the total column. I'd like to see the total column. So we'll say there that is. And now we have our expense down below. So we've got our expenses, the rent and now the salary. So there is our salaries expense. Now note that this is in the unrestricted column. We don't have it yet broken out by the tags in the unrestricted column. We will do so. And once we do, we will then go back on over here. I'm going to go to the last tab. I'm going to go to the reports dropdown. So we'll go to the reports. And then we will be running our reports going back on down by tag. So now we got the unrestricted income statement. So just keep visualizing how this is going to work. We got our income statement broken out between our funds, restricted and unrestricted. And then we'll have our fund totals down here that you could see the fund totals. And then we will be considering that information with regards to the further breakout by tag. So then if we go to our tags, then we will have the the income unrestricted, which will tie out to the unrestricted column and the income statement restricted, which will tie out to the restricted column. So that's kind of a hierarchy. You want to just start to visualize in your mind and just repeat visualizing in your mind. So now we're going to record this second item. We're going to go back to the first tab. And this is going to be an adjusting entry. So we'll get it, we'll get used to and we'll be able to then now record something with a journal entry. So I'm going to go back up top. We're going to go back up to our second transaction here in, which is going to be the adjusting entry. Now there's no cash affected here. And this is an adjusting entry, which typically would be done with a journal entry. This is something that you might have like an accounting department or something due at the end of the period or the end of the year to be more on like an accrual type of basis. So we're going to go back on over and I'm going to say, all right, now we're going to go to the accounting. Once again, we're going to be recording another transaction, but this time not with the register, but a journal entry. So we have to, we have to go back to basically the debits and credits at this point. Now I'm going to make this one as of the end of the year, because that's when the cutoff date, that's usually when we enter this information as of. So we'll put January 31st in the memo. I'm just going to put adjusting entry, something like that for, you know, wages and then we're going to say that the wages account or we put it as salaries, salaries here is going to be debited. It's going to be in the unrestricted. That's correct. And then we're going to not have a note. We could have a note, which is a DJ entry. And then the debit is going to be for 16 800 1 6 8 0 0. And then we're going to have the other side being the it's going to be a payable account like salaries payable or something like that. Now it's unlikely that we're going to have a salaries payable in the drop down here. So we're going to have to add an account to do that. Let's jump on over to another tab. So I'm going to right click on this tab up top again. I'm going to duplicate this tab. And then we're going to go to the chart of account. I'm going to go to the fund and accounting. We're going to go to the accounting drop down. We're going to go to the account list. So we're in the account list. Now within the account list, we need a liability type of account. So we need something in the liability section here. And it's going to be a current liability. So and then I'm going to hit the old plus button. It's going to be something under the accounts payable. So it's got to be in the numbering system between 21 0 0 and 2 5 0 0. So how about 21 5 21 5 0. So we'll say 21 5 0 and then the type of account. Do we want to use a register? No, I don't think we need a register. And then I'm going to say the name is going to be the wages payable. And you could have accrued wages or accrued salary or salaries payable. However, I'm also going to change the salaries expense just so you can see how to change that as well. Activity we're going to say operating investing and financing. I'll keep it in the operating. And then we're going to say the status enabled sub accounts. No, so I'm going to say save on that. Then it's going to reorder it within our category according to the account number. So it's reordered by the account number within the category. Let's also make the change while we're here to the expenses down below. Let's go to the expenses down below where we had salaries expense and still have salaries expense but are now changing it by selecting that salaries expense. And we would like to call it wages, wages is what we were used to. So we're going to say that's what we want. So I'm going to say save that. All right. So that should change that when we already have something posted to it. That's OK. We didn't delete the account. It's still there. We just changed the name for it. So then we're going to go on back over to the first tab. We're then going to be selecting the drop down. And we want to go on down to the liabilities now where we have wages payable. That's going to be the other side. I'll put it into the unrestricted. Let's keep it at the unrestricted. I'm going to say ADJ entry credit 16800. So there we have the debits and the credits for our transaction. So we're just looking at these two numbers up here. Note that we're not breaking out the salaries again to the unrestricted tag categories to 2020-2040. We'll talk about that later. We'll be back here at a later point. We're at the 16800 credit. That looks good. This is going to be increasing the salaries expense on the income statement, increasing the wages payable on the balance sheet. So let's go ahead and say post on that and then check that out. See if I have interpreted what's going to happen correctly. Let's go on back on over here. And to the balance sheet, we're in the balance sheet. And then we'll refresh the screen. So we are working with fresh reports. So we're going to refresh the screen. And there we have our wages payable. If I go into that 16800, then of course we're going to get to our transaction. You'll note here, it says it's an adjusting entry. And in the transaction type, it's a journal entry. So that transaction type is something I suggest getting used to. So you get an idea of what what transaction types do what. So that's going to be that side. Then the other side, if we go to the income statement, going on over to the income statement by fund and then refreshing that screen. So we're working with fresh reports once again. Then we're in the wages. Notice we changed the name now to wages because it was it was salaries before. But we we preferred wages. So we changed it. And then we have down here in the transaction type where we have check and then we have now the journal entry, which was our month and adjusting entry. So that's going to be it for now. Notice I am giving trial balances. So if you if you have access to the to the data files, you should have a trial balance where you could check your numbers on the trial balance at any point along the way. If you so choose, that's it for now. Let's get out of here.