 In this presentation, we're going to record transactions related to standard types of expenses within our not-for-profit organizations, things like the telephone expense and the utilities expense. Get ready because here we go with zero. Here we are in our not-for-profit organization dashboard. We're going to go on over to Excel to see what our objective will be. So here we are in Excel. We're going to be recording transactions related to those standard kind of expenses. We'll start off with the telephone expense. We're going to go to the printing and postage utilities and so on and so forth. So these will be standard in terms of similar to a for-profit organization informed the type of transaction we're going to have in terms of the accounts, decreasing the cash accounts, the other side going to typically an expensive count. Now also note that we're going to have this information broken out as it would normally be broken out in a for-profit by the nature of the transaction, the expense categories being things like rent expense, salaries expense and so on and so forth. But we're also going to want to then break them out by what they're used for, their function, including the programs, education, community service for us, admin type expenses, and fundraising. So we're going to do this in a two-step process and this is what I would recommend if you for normal bookkeeping, do the normal bookkeeping, enter it just like you would for a for-profit, record the expenses by their nature as you normally would, rent expense, telephone and so on and then go back in as we'll do later and then reallocate all of them in accordance with your percentages which is going to be 20, 40, 20, 20, 20 for us. And so we'll do that in a future presentation. You'll specialize your tasks that way. You can make the data input whoever does the data input for the expenses can not doesn't need to know as much to do that and probably a little bit faster to do that way. So we're going to do the first half then just enter in the normal types of transactions with the natural categorization here. All right, so let's go on back over. We're going to go back into zero. We're going to select the old plus drop down here and be picking the spend money. We're going to be spending money for the expenses related to the not for-profit organization. We're spending money out of the checking account so we're going to take it out of the normal checking account. First one's going to be the telephone bill which we're going to say we pay Verizon. We do our telephone with Verizon although we've been offered a very nice deal from AT&T and we're thinking about switching up just for that time period. But in any case, we're going to bring this on back to January. This is going to be January 30th. We're going to say we're doing these ads pretty much the end of the month, January 30th that we will enter this as of. We're going to say we could put the period of the phone, right? We could put like a period covered or something like that but the vendor pretty much says most of what we need to say here. So I'm just going to keep it blank. We're going to then put the amount, the amount that's going to be for the 6200. So we're going to say here the amount of 6200. The account something like telephone should be here. Let's see if we have an account for the telephone. It's rolling down. See if they give us a telephone expense type of account. Don't have it. It's interesting. I was guessing we would have had that one. So that's not a problem or anything. Just thought we might have one if I type in here telephone. Nope. Okay. So what's the account number that we're going to want? Something like let's make it 6220 for the number. Then I'm going to add the account up top. So let's add the account and I'm going to say code 6220. Then the type is just going to be a normal expense type of transaction. So normal expense transaction. And then the name I'm going to say telephone. And there we have it. So that looks good. Let's go ahead and save that. And there it is. So I'm not going to put it into restricts for unrestricted categorization. It will later go into the unrestricted and we'll break it out by the 2020-2040 breakout here. However, I'm going to leave it uncategorized for now, which means it'll show up in the uncategorized category, making it easy for us to then go in all at once at a later point, going into those uncategorized categories and then categorizing them. So this is going to decrease the cash account. Other side, go into the telephone company. Let's go save and another. So we're going to say thank you for the form. Let's, can we have another? And we're going to go back out over here and I'm going to, now I'm going to highlight the ones that we're working on green or at least I'll highlight like the last one will be green. We're working on the last green one. That's the rule. Last green one. That's the one we're working on. So now we're going to go to the printing and postage expense. So let's say, all right, printing and postage. Let's just say we're getting this from the post office. I'm just going to make up a vendor here and we'll make this as of the end of the year, January 30th. Bring this on back to the January 30th as well and we could put a description. Now note that once we have the vendor set up, just like in a for-profit organization, the second month of operations will be a little bit post office. I'm missing an E here. Okay. Now I have set up two vendors. Okay. I'm not going to. So in the second month of operations, the vendors will be set up and it'll help us out a little bit. So it'll be easier for the second month of operations, just like a for-profit where zero will memorize some of the transactions and help us out with the transaction. Of course, just like a for-profit, we do want to have consistency. So the same vendors should typically be going to the same accounts for the most part, general rule. So printing and postage expense. Do we have a printing and postage expense? Let's put the amount first because I wanted to, I'm getting ahead of myself here. Let's do 12,900. And then we're looking for the printing and postage expense. Do we have printing and postage? I don't think so. We probably got office expense here. But let's make another category. We want to categorize the printing and postage. So let's go to the 6230. Let's go 6230. I'm going to go back up top, make another code and we're going to call it 6230. And we're going to say the name is going to be printing and postage. I think that's how you spell postage, I hope. If not, I apologize, but I'm going to keep it as is. I didn't have a red line under it. And then I'm going to go down to the expense. It's going to be an expense type of account. Expense type of account code 6230 printing and postage name. Let's save that. We're going to go ahead and save that one. This one will be decreasing the cash count by that 12,900. Other side going to the expense printing and postage. Not being categorized in terms of the categorization. We will do that later as we went through last time. Let's go ahead and say save and thank you. Let's have another. And then go back on over to what the next one's going to be, utilities. So I'm going to make this one green. So the general rule here is we're working on the last green one. The last green one is the one we're on. So I don't have to make this one blue because we're working on the last green one. That's the rule. Okay, so then we're going to go back on over utilities. We're going to say this is our Edison is the vendor. This son is the vendor for the utilities. Let's bring this on back to January again. So we'll bring it on back to January 30th, January 30th. All right, that's going to be the Edison telephone company. We're going to say the amount then is going to be four back to excel the 9100. So 9100, 9100. Then the account, I typically would put this in the utilities account. But no, you have some leeway. You could put this breaking it out just to an electric bill. If you want to break out, I would typically put like the utilities, including gas and electric in the utilities, but some people would put phone in the utilities. So really on the expense side of things, your question is, how much detail do I want on the expense side of things? There's going to be some kind of standardization, but there's also some some deviation from the standardization. So it really depends on the industry. You have some flexibility there. Let's make up another account. It's going to be 62. Let's make it 6240. So I don't see a utilities account. So I'm going to add one. So I'm going to say the code is going to be 6240. 6240. We're going to call it the name utilities utilities. It's going to be the type of account is will be an expense type of account expense type of account code number, count number 6240 name utilities. Let's go ahead and save that save that. What has happened here? What's going to happen? We're going to decrease the cash count and then the expense of utilities going up by the 9100 decrease cash increase the expense decreasing net income. Alright, thank you. Let's have another save and another big blue button on the bottom right. I really like clicking that big blue button. It's really enjoyable. And so then we're going to go back over here and we're going to then highlight this one. We're going to be on that last green one. This is going to be a supplies. So we're going to go to the supplies. Let's go back on over here. And now we're going to say I'm going to say this comes from office depot office depot for the supplies. And then we'll select the drop down. Let's bring this on back to January 30th. Once again, we're looking for the supplies. And we'll say this is going to be one and the amount of $500. 500. Let's see if we have an office supplies type of account here. So advertising bank is pretty common business and license dues, utilities, professional payroll, mileage, bad debt, no other expense, no office. Interesting. Alright, so we're going to go back up top. I'll keep it in our series here that we've been adding, which was 6250. Let's make a 6250. Back up top we'll say code section 6250, basically the account number. This is going to be for office supplies. And then we're going to say the name or the account type is going to be an expense type of account, expense type of account. So expense account, code, account number, 6250, name, office supplies. Then we're going to say save, save that. What's this going to do? Decrease the cash account, other side going to office supplies. We're not going to assign a class, therefore it's going to be in the unclassified category in our income statement worksheet. Alright, thank you. Can we have another big blue button? We get to click down there. We don't get to click that all the time because we've been enjoying that presentation. So then we're going to do one more. Now this one's a little bit different here because this has a payable account. So on this side we're going to be increasing the office supplies, but we haven't paid it. We're entering in essence a bill into the system. Same kind of format we would have for a for-profit organization. Instead of cash going down on the credit side, we're increasing the liability. So we're going to enter a bill. So I'm going to go back over here and I don't need this form because we're entering a bill this time. So let's go back up to the plus button. We want to enter a bill. Now remember for zero, as well as most accounting software, a bill means to us that we got a bill. That means that we're going to enter it in the system that we're going to bill somebody. We're entering a bill from somebody. When we have an invoice, that means we're invoicing someone else or you could think of it billing someone else. So an invoice to us will be a bill to somebody else. A bill to us is an invoice from somebody else. So the bill might say on it invoice because it came from another company and so it's an invoice, but for us it's a bill because we're entering into the bill section. So obviously there's two sides of that transaction. You got to keep in mind which side of the transaction we are and then use the terminology of the software to name whichever side we are on. Bill to us means someone gave us a bill which could be called invoice to them. All right, so we're going to enter the bill. Bill and then I'm going to say that it's going to look very similar to what we had before the prior screen. However, now it's a bill type of form, which means that accounts payable is going to go up. So anytime you see bill type form, accounts payable is going to go up. So once again, I'm going to call, I'm going to say office depot, office depot, not post office. And then I'm going to say this is going to be for the end of January, January 30th. And let's say the due date, we'll say it's February 30th or there's not, there's 29, there's 29 days in 2020, February. And then we're going to go down here say quantity one. And we're going to go and say that that's going to be 4500 for the amount. Amount 450, that's a seven. I wanted a five. And then I'm going to say drop down. And the other side of the account is going to go to that office supply set up. Once again, not using the restricted or unrestricted. What's this going to do when we record it? It's going to be saving, it's going to be increasing the accounts payable now instead of decreasing cash. The other side going to the office supplies going to be uncategorized for the income worksheet that we will have. So here we go. Let's hit the big green button this time. Now let's go on up to our report. So we're going to go to the accounting drop down. We're going to go into that balance sheet report. Let's open up the old balance sheet report. Changing the date, we're going to bring this out to 2020. So we're going to bring it out to January 31, 2020. We're going to update that report. Let's then open up the other report before we start to analyze everything. So I'm going to hit, I'm going to go up top. We're going to right click on the tab, duplicate the tab, put the balance sheet on the right, go back to the tab to the left, open up the income statement then accounting drop down, going down to that income statement, open up the income statement. Then we're going to copy this tab or duplicate it. So let's go up to the tab up top, right click on the tab up top and duplicate the tab up top. Then we're going to go back to the tab to the left and we'll do this one more time, go into the accounting drop down and then go to the income statement worksheet. I'm not sure that will be the last time, but the last time for right now, we'll open up the income statement worksheet. Then let's go over to the balance sheet. Let's analyze what we have thus far. I'm on one, two, five on the zoom in. So we're zooming into one, two, five percent. Are we? Yeah, there we are. And then I'm going to scroll down in the checking account. Let's check the checking account. Let's give the checking account a check. Scrolling down to the checking account, we have our items here, including the office depot that we spent the 13, the post office, the office depot again, and then the Verizon and Edison. So there's our transactions there decrease in the checking account. That looks pretty straightforward. If I go back up top, back to the balance sheet. The other side is going to be on the income statements. Let's go to the income statement tab and scroll on down to the income statement where we see our transactions here where we have the rent, the telephone, the utilities and the salaries and wages. So we have that broken out. And before I forget, let's go back to the balance sheet. Just recall that we had that one transaction, which we put in a bill. So the bill resulted down here in this accounts payable transaction. So that means that we're going to owe money in the future. Now we can, of course, track the bills in a similar feature as we would for the accounts receivable to track the bills that are owed and then pay those bills at a future time. So here's going to be the transaction. If we needed to go back into that transaction, we can go into it here. And that would take us back into this transaction. Now one way to pay the bill is to go into the bill and go to the bottom of it where you have the amount pay or the pay amount. And then you can make the payment and record the payment in that way, tying it directly to the actual bill. I'm going to go back to the balance sheet, go back here and then back again. Now I also want to take a look while I remember here the bill feature in our system. So let's go back to the first tab. I'm going to right click on this tab. So we have a place that we can look at do stuff other than look at reports, right click on this tab and duplicate that tab. So now I got the balance sheet income statement income statement worksheet. And then we're going to do stuff on this tab to the left. That's why I'm always doing stuff on the left tab. And so then let's take a look at the dashboard. Let's go back on over to our dashboard here. And then if you go down to this section where it says bills, you need to pay right on the homepage. This is one one area or one way you can you can get into that information for the bills you need to pay. So then in the bills section, you'll see this item here that says awaiting payment. So then we can go into the awaiting payment bill. And this is where you can kind of sort your bills and then make the payment on them. You can make the payment by checking off here if you have multiple bills that you want to pay. And or you can make the payment by going into that bill and then recording the payment on it by then going down to the bottom and recording the pay date and the payment on it. So that's how you pay the bill. If I go back then to the to the prior tab, once you make the payment, it'll be removed from this screen and it'll go into the paid screen here. So also note that if you go to the contacts and you wanted to track your information, if I go to all all contacts, then you'll also see that the contacts will be broken out based on if they if you if you owe them money or if they owe you money by basically customers or vendors then or they call them suppliers here. So if I go into the suppliers items, so notice I have 12 contacts and in the suppliers, there's that office depot once again. So you can also run reports in a similar fashion with regards to who you owe. So I'm going to go back up to the dashboard here. Let's go into the income statement again, income statement tab, recalling that we have the expenses as we would normally see them in a for profit recorded by nature. Then if I go to the income statement worksheet over here, note that they're at the end of the day, we need to pull them over into unrestricted. They're not in unrestricted now because like we said, we're going to do that in a two-step process. So we put them in unrestricted now making it easy for somebody to just do the data input, do the normal accounting and pay off the expenses. Then we're going to go into all these items, we're going to drill back in from this side and then reallocate to these items in accordance with their percentages allocating them not only to unrestricted but to the subcategories based on the programs and the admin based on that 2020-20-40 breakout. So we'll do that in a future presentation. That's going to be it for now. Let's get out of here.