 In this presentation, we will create custom reports related to the restricted items. In other words, we're going to be tracking the restricted items with custom reports that we will be creating. The ability to create these custom reports is a great tool within Xero and a distinguishing tool that Xero has that many other accounting softwares do not have. Get ready because here we go with Xero. Here we are in our not-for-profit organization dashboard. Let's take a quick look at Excel to see what our objective will be. You'll recall that in Excel, we're entering this information into like a trial balance type of format, which would be here and then we're also creating our financial statements from it. So if we go on over to the financial statements, then we're going to be having two columns for the statement of activities or in other words, basically the income statements. And we could break those out to items with restrictions and those without restrictions. So we saw that last time we created a custom report that does that. A worksheet report works great. Now we want to think about, well, what about the items that are restricted? We have more than one kind of restriction. Can we make another report that will support this number and tell us what types of restrictions we have? We can and let's do it here. So we're going to go back on over to Xero. Let's open up our reports. Let's go to the accounting dropdown. I'm going to open up a standard income statement. So let's open up the standard income statement. Let's see what that looks like. It's for the year 2020. So here's going to be the standard income statement with one column. This is going to be including all items that we have thus far. If I select the reporting settings dropdown, we're not restricting anything with regards to the unrestricted and restricted items here. This is our filtering field that we can use to create custom type reports and filter these reports. So then I'm going to close this back up. I'm going to go up to the tab up top. I'm going to right click on that tab and I'm going to duplicate that tab. Then I'm going to go back to the tab to the left and we're going to then create another report. And this is going to be the income statement worksheet. Now this is a custom report we created in a prior presentation. So if you haven't seen that, you can go back. But we're going to do a similar kind of customization as we did in this presentation just for a different factor now. So this one, we took that standard income statement. We edited the layout as we will do in this presentation. And we broke out the unrestricted and the restricted items basically with those filtering fields that we had before. So now we have a report that looks much like the end result report statement of activities report except that we have these unrestricted columns over here and we're using that. That's why it's a worksheet report. So that's what we have thus far. Now we have the restricted items here. These restricted items to 108, which include two different things in the restriction. So we might want to run another report and say, well, what items are included in those restricted items? So let's do that now. To do that, I'm going to go back up top. I'm going to right click on this tab again and duplicate this tab. And then we'll start off with another basically just a fresh income statement and then we'll adjust it. So we're going to go to the accounting dropdown and let's open up another income statement. We have a clean income statement open, then the worksheet, and then we'll open up another income statement. This is the one that we will actually be changing at this point in time. Now remember the changing features we're going to use are basically if we go to the report settings on the right hand side, the items on the unrestricted and restricted. These are the segments that we have set up for the tracking features. So these are the tracking features that we have set up. We want to look at the restricted items and we basically want to be breaking out between the government and the time restrictions. So that's going to be our objective. So let's close this report. And then what we're going to do is I'm going to go down to the edits layout. We will edit the layout. Next thing we're going to do is be adding a column. So we're going to go back up top up here and say where it says columns, I'm going to add a column. So we'll say a column. We want to have a restricted items. That's going to be the tracking feature that we have been using. So a column related to the restricted items. I'm then going to choose one of the two restrictions. That's going to be let's choose the government grants education here and we'll choose that item. Then I'm going to change the name. I can't do it here for some reason, but I can do it in this blue area. So I double click in the blue area and I don't need the date. I'm just going to call it the government grants there. So we're going to save that. That's going to be the one column we want. Now let's add another column. So I'm going to say go back up top and add another column. And it's also going to be in the restricted items. And this one, we're going to say that let's pick the other, the other item, which is going to be the time. So time. So there we have that. And so that looks good. And then I'm going to change the name to just be time. So I'll double click on this item and delete the year just having the time. Now I actually don't want the total column over here. I don't need the total. What I'd like to do is total these two up and I can't do it with this column. So I don't want the whole income statement numbers. So I'm going to click on this column and I'm going to trash that column, clicking on the title, going up to the trash can up top and deleting that item altogether. Then we're going to add one more column for the total. So I'm going to add another column and say we want another column for the restricted items. And then I'm going to choose the government and the time. Now I'm not going to choose unassigned because the unassigned and we might go back and adjust some of the transactions related to the unassigned when we do the expense allocation. And you can think about how that works a little bit more. But because we created two separate categories for the government grants or the restricted and unrestricted, we would have to have something that would be assigned in each one. So anytime I have something that's unassigned, it's going to populate in here when we put it into the data input screen. So I'll explain that in a little bit more detail when we go through the allocation of the expenses. But at this point in time, not going to include the unassigned. There shouldn't be anything in the unassigned at this point. And if there is, if we didn't assign anything, we'll be able to check that because what we're trying to do is tie this out to what we saw on our income statement worksheet. So let's check this out. I'm going to say OK. And then let's double click on this one. I'm going to say this is the total. This is like the total. Let's do that one more time. I'm just going to call it total. And so there we have it. So now let's take a look at it. Let's say done and see what it looks like so far. So there we have it breaking out the time restriction, the government's grants, the totals. Then adding up to that 267. Now it's good to add these across because that total column is kind of calculating independently. So we can kind of, we could double check it basically by calculating across. I'll take my giant calculator here and make it a little bit smaller. And then we're going to say that if I take the totals 159000 plus 108000 we get the 267. So that looks good. Does that 267 tie out to our worksheet? So let's go over to our worksheet over here and check out. We're looking at this restricted items. The restricted items should be at the 108. So notice it's picking up that 225500 which is unrestricted. It looks like I'm going to go back on over here. You know it's got this 159. There's a problem with that number and it's actually on the worksheet report. So if I go back to the worksheet report, this 159 is in the total column but it's not allocated. It should be in the restricted items. So let's go into the editing of this report and check that out. I'm going to check out the edit of this report and see why it's not allocated to one of the columns. If I go into the restricted items here and I select the dropdown, notice in the restricted items this should be including both time and the government education. And it wasn't including this item. So I'm going to say okay. So now this restricted column is including all restricted items at this point or it should be. And so that's going to be our total. So let's go done here and see what we have. Okay so that makes sense and that's why you should want to kind of add them across here. So the restricted items should include the total. So now these all add across this way and that's going to be the 159 is now included. The restricted column now adding up to the 267,000. So now we can look at our worksheet. We say okay here's unrestricted restricted. This is not a too overwhelming worksheet. And then I can say okay if I want more detail on the restricted items, we're going to go into this report. So we'll then move over to this report where we can see that we have the items of the 267 broken out here. Now I think we made that adjustment before. I'm going to go back to this worksheet and say I think what we did not do, what I did not do is save it as a custom report. So I'm going to re-save it because I changed the formatting. I changed the layout. So I'm going to say save this report again. And so hopefully if I keep the name the same, it'll overwrite the other one. So I'm going to say save and there we have it. So hopefully we won't have to make that change again. And then if I go back to the new report we made here, now we might want to adjust the name here. So this is going to be the restricted, restricted items. So restricted items. Now note when we're running the restricted items, we can run it for the current time period, the current year in this case. And that should then tie out to the restricted items on the income statement here. If we want to also tie out to the equity section of the balance sheet, which we'll talk more about later, then we would have to run this report for the life of basically the restricted items to tie out to the equity section of the balance sheet. So just keep that in mind. We'll talk a little bit more about that as we go. But this will then be our custom report. Now let's go ahead and save this report. So we're going to say I'm going to make this a custom report. And I'm going to make it called restricted items, restricted items, and then I'll save that. And then let's just check it out. I'm going to make a new tab by right-clicking on this tab. I'm going to duplicate this tab. We don't need this open over here. And then I'm going to go back to the left tab and just check out our custom reports to make sure that it has shown up in the custom report. So we're going to go to the reports over here. See what we have in the reports. Opening up all of the reports. We're going to go into the custom report tab because we just made another custom report. And it does look like this one has been adjusted for us. And then now we have the restricted items. So again, these two are probably going to be used a lot. This one will probably be used all the time, might even be used more than the income statement if we were doing this in practice. And then this one might be used a little bit less because of the restricted items, but probably enough that we would want to put it on our star for one of our favorite reports. That's what the little star means. It's our favorite. And that means it's going to be populating if I hit this dropdown. So now I have it in the restricted reports. And now I got my balance sheet, my income statement, and my income statement worksheet, which will show us all the detail of unrestricted and restricted. Well, not all the detail. It'll show us the categories unrestricted and restricted. And then we can break out the detail of our restricted items reports. Now, later on, we're going to make one more, at least one more key report here that will break out the unrestricted items. And that will be, if I go back to our worksheet reports here for this column, but we won't do that until we apply out the expenses. So once we apply out the expenses to their categories, that's when we're really going to be in need then of seeing the more detail of the unrestricted columns. And we'll make another report for that. Now note that other software such as QuickBooks Online type of software, you could track all this with a class tracking feature, but that you're more limited with the reports, meaning you can get all the information on one report, but it's all going to be on one huge report, typically. Desktop version allows you to kind of collapse the columns, which gives you a little bit more leeway with it, but doesn't give you the flexibility that this does. It really allows us to kind of make the reports a lot more fully within the database system so that we can basically have them pretty much good and go to print out and give to somebody other than some kind of terminology things like the name of net income and whatnot. So there's more customization with the reports. Now obviously we could always still export the reports to Excel and minimize some columns. And there's pros and cons to either method because the customization feature being more flexible means that it's a little bit more complex to make and you got to make sure you organize your reports. And to have it all in the database system to me is pretty nice. So I'm liking the editing of the reports feature within Xero, a lot more flexibility with it. Anyways, that's it going to be it for now. Let's get out of here.