 In this presentation, we're going to continue on with part 2 of recording our typical kind of month-end type expenses like the telephone and utility type expenses. Get ready because here we go with App Loas. Here we are in our not-for-profit organization dashboard. We're going to be heading on over to Excel to see what our objective will be. So we're going to be on over in Excel. We're in the eighth tab. Last time we made these first two ones green because we did those ones. And now we're going to continue to make the next one green because that's the next one we're going to do. We're going to be recording our expenses. This is going to be the utilities expense. We're going to right-click on that one, make it green. So we're going to be paying, we're going to say Edison, that means cash is going down, other side, utilities expense. Let's go back on over to our App Loas. We're going to be going to the fund accounting. We're going to go to the transactions. I think the easiest way to enter this is with the register for the check register. So we're going to go into that check register. We got the checking up top date. Let's bring this on back to January, January 31st. We're going to say the payee. We're going to say Edison is going to be our utility company. So that's our power company, Edison. So we'll pick that up. I'm not going to put a comment. Probably good to do so when you can. I'm going to say 9100, 9100. I'm going to type that too, as I said. No check number for this because we're going to say that we're doing an electronically account. Do we have a utilities account? Did they give us one? We don't. So first month of operations, we're just going to add them as we go going up top, right-clicking on this tab, duplicating it. I would typically have these two tabs open so that we can jump back and forth from the chart of accounts as we enter the first month of operations. We got the fund accounting over here and then we're going to go into the accounts drop-down, the good old account list. We're going to be thinking about those accounts as we add them, which accounts we want to add. So utilities, so now we're talking electric. I could put it into an electric expense or try to group some of the utilities. To me, typically utilities includes electric and gas. If you want to break those two out, you can. If you wanted to include the telephone, for example, in utilities, you can. But I think at this point, the standard convention to me at least would be utilities being electric and gas for most organizations. So that's what I'm going to go with. I'm going to go the five three, let's say six zero. So five, three, six, zero, five, three, six, zero. We're going to make it the unrestricted category. I'm going to say utilities. And again, you might have just an urge to put expense by that you can, but it's already in the expense category. So either way is fine. So then I'm going to say save five, three, six, zero, zero. And populates down here in accordance with the account numbers and by category. And then we're going to go back to the first tab. We're going to type that number in then because we just added it for that purpose. Five, three, six, zero. There it is. Utilities unrestricted category. We're not going to be adding any tags. That's it. Let's go ahead and submit it. So we'll submit that one. Now we saw these two on the financials last time. I'm not going to go back into it until the end here. So the expenses went up. The other side is going to go to cash. Let's check it out again. Let's go back on over and say that one's done. We've highlighted it. Now let's do the next one, which is supplies. Now I'm going to say this is going to office depot that we're buying supplies from. So I'm going to say office depot supplies. So let's go back on over and say we've got the date once again, 30th of January. And then the payee, I'm going to say office depot. And this is going to be new or we have it here already. Office depot, there's a C next to it for some reason, but I'm going to pick that one up. And then we're going to say the amount is 500. We might want to say what the supplies are because this is kind of like a generic category. So we might want to list, you know, general office supplies that we got there. And then we're going to say that do we have a supplies account? Now this one, I think they gave us one that's somewhat appropriate in our expenses where we have, we have the printing and postage. And then they also have up here, didn't we have another one? Rents, ex building office supplies. So that's where I would put that one. So they've got that one set up for us. Just remember that that office supplies is like I say, kind of a dumping ground sometimes for people. So it could become miscellaneous, in other words, they put all expenses to office supplies. So, you know, you want to think about how much you want to go in there which counts you want to break out from there unrestricted and then we'll add the tags later. So let's submit that one. And then let's take a look at our reports now because I think the next one's going to be a little bit different. So let's go to the second tab and open up our reports from here right clicking on that tab, duplicating that tab. Then we're going to go to the reports on the right side. We're going to be opening up our favorite two reports. That's going to be the balance sheet, but by the fund fund balance sheet because it's more fun. Then we're going to go back to the tab to the left and right click on it, duplicate it again. We're going to be opening up our income statement by going to the reports and then opening up the income statement. Income statement by fund once again, going back to the balance sheet by fund. We're going to change the date date. Let's bring it on back to January 30th, January 31st, January 31st. And then we'll say there we go. And then the checking account should be decreasing. So I'm going to go on over to the checking account. Also just remember that when you see this report, you might want to see the totals too. So you might want to always just kind of check this off and you might want to save this. We'll talk about memorizing reports later. But you can say the dropdown and say, hey, I'd like to see the total columns and say apply. And then you'll get your total column over here for the total and the checking account. So it doesn't look like negative, which could be kind of scary. And so then you're going to go down and say that there's the post office and there is Edison. So that's that. Let's go on back to the balance sheet. Then let's go to the income statement and let's refresh the incomes or let's date. We need dates and we're going to bring this from this year to date. This year to date. Once again, you might want to hit the good old dropdown and say, hey, I'd like to see the totals. Would you show me the totals, please? And then say yes. And if you ask nicely, then sometimes they'll apply it. And sometimes not. So let's say totals, totals, and then apply. So see that. There we go. All right. And then we're going to say down here that now we have the printing and postage and the utilities, both in the unrestricted category, we're going to give more detail on the unrestricted category using tags. We'll do that later. Now let's go back to our Excel. Last one's going to be a little bit different. So now we're going to say we have office supplies again, but now we didn't pay for them yet. We're going to say this one's going to go to a payable. So this in other words would be like a bill that we're going to enter into the system. Now bills can be useful for some different reasons. You might want to enter this information in as a bill basically and then sort your bills, pick which bills you want to print and then print them. And if you're printing the checks from the system, that could be kind of a useful way to sort that information. But the basic idea of the bill then is we're going to be entering this using a different form and it will be increasing the liability account, accounts payable, that we have not yet paid. The other side going to the expense, in this case the supplies expense, then we can attract those payables that we owe and then pay them at another time. So that's going to be increasing then the accounts payable. So accounts payable is going to be increasing the other side going to the expense. All right. So I'll make that one green because that's the one we're on even though it's on the bottom because all the other ones were green and that'll mess me up if I don't make this one green because it's the last green one. We're working on the last green one. All right. Then we're going to go back on over. We're going to go to the first tab. Then we're going to go to the fund accounting again. We're looking at those transactions. We want an accounts payable transaction. So the accounts payables going up accounts payable type transaction. This is basically kind of like a bill transaction if you're used to something like a QuickBooks. So then we're going to say the vendor is going to be office depot again. So I'm going to say office depot memo. I'm not going to put one reference number. I'm not going to put one date. I'm going to say is January 30th January 30th terms. Now if we set the terms it'll set the due date. So whatever the due date on you know the bill is you could put the due date manually over here where you could set the term which will populate the due date automatically. And then I'm going to say the amount I believe was 500 again was it. It was no 4500 thing I checked that time 4500 remaining balance 4500. Okay. And then we'll be the office expenses. So that's going to be the 5300 office expenses. And then it's going to go to the fund of the unrestricted fund. So that's going to be the fund we're not going to then have the tags here. Now the percent you can either put the percent or the amount that's going to be applied here I'm just going to put 100% and then and then say tab and it'll populate the total bringing that total 4500 down to here. If we were to add other categories as we will do in the future this percentage breakout great tool will help us to break out as we break out between the tags for the unrestricted categories 20 20 20 40 breakout as we'll see we'll do that later. Let's go ahead and submit this once we do however just note what's going to happen. Accounts payable should be going up the other side should be going to that expense account. So let's say submit and see if it if it gives me any kind of red things and I messed up or anything like that it wants a memo there's a red thing. So we're going to say this is for postage let's just say on the or let's say office supplies office supplies and then let's submit it again. See if they get any other more red things that say I messed up somehow. Nope that looks good and now if you move back down to the bottom you'll get kind of a summary of your activity down here. I'm going to go back to our reports now go back up to our reports balance sheet let's refresh the balance sheet with a little refresh button and see what we have here then I'm going to go back down we want to look at our liabilities there's our accounts payable there's the four thousand five hundred in it that's what we would expect to see because we just have the bill and there's the bill note anytime you see bill that means it's a bill to us and just remember that when you see these transaction types you want to get an idea in your mind what the transaction types mean it's really useful what's going to be the transaction where the accounts that are affected also note that a bill means that it's a bill that someone paid to us you know the bill that we're sending to somebody else for work that we did in theory if we're a for-profit you know it would be an invoice so the bills are the things that we have to pay the invoices of the outgoing things that are usually the things that we are charging for for work that we did so an invoice to someone else would be a bill to us right if they sent out an invoice to us it's still a bill okay so then if we then go to the income statement check out the income statement and we want to refresh that screen we should see then down at the bottom that we have now and another expense or an increase to the expense that we had already created for the supplies office supplies is now at that five thousand five thousand consisting of these two items there's the four thousand five hundred we just set up let's go on back over to the income statement back to the to the previous tab I want to open up another report here now so I'm going to go and open up another report by going to the reports all the way to the right and then we want us we want a supporting report for the payables that we owe so if I go back down to the bottom of these reports to the other reports we can have an aged payable so similar to our aged receivable so we've just entered a payable so now we've got okay here's our payable information and so this gives us our age payable report if I bring this back to January so January there we have it so these are people we owe this one this one is still in the current category as opposed to when the 30 days and 30 to 60 and so on and so forth let's go back to the first tab now obviously this the number here four thousand five hundred on this report note should also tie out to if I go back to the balance sheet the number here on the accounts payable so typical question would be how much money do we owe other people at this point in time balance sheet four thousand five hundred who do we owe who do we have to write a check to and and how outstanding are these debts we go then to the supporting report for that number here four thousand five hundred as all we owe to one vendor that being office depot okay let's go back to the to the first tab again and then if we go into the people just we can also see within the people section if we go to the contact list and say that we have the office depot down here you could see the activity for for you could see our our customers and vendors here so you could see our items age payable so there's our age payable for the office details so that's another another way you can get basically information you can also just note that we're building our contact list as we're going our people list which includes customers and vendors also note that I am going to be printing the trial balance as we go and let me just take a look at trial balance and so you'll have these reports for you that will at least give you the account totals that won't break out on the fund information but they'll give you the the account totals so you can check your total numbers as you go through these practice problems you could find the trial balance by going down to the to the bottom of these reports and it's all the way at the bottom reports you likely won't use but we'll build them anyway what is the trial balance okay I like the trial balance I don't know so this is going to be the trial balance by debits and credits and it's it's useful because you can have all the accounts basically on one report including the balance sheet accounts and the income statement account so you can check basically all of your numbers with this one report so I think it's a good review report we will be print printing this after many of the presentation so you kind of check your numbers there if you're working along with practice problem as you go that's going to be it for now let's get out of here