 In this presentation, we will generate analyze print and export to excel month and reports and financial statements, those including the balance sheet, the income statement, and a transaction detailed report. In other words, we've entered data for the second month of operations, we'll now analyze the balance sheet and the income statement, we'll practice and check our numbers. So if you're following along, you can check the numbers with those. And then we'll take a look at the transaction detailed report, which is a great report to then dive deeper if there's any problems with the numbers that have been checked. So also a great report if you want to use it for billing or taking a look at the amount of work or transactions that have been entered. We will then export these reports and think about how we can organize these reports to be presenting them to others, whether that be supervisors or clients. It's time to rise above the crowd with Sage50Cloud accounting. Here we are in our Get Great Guitars company file. We're now going to be taking a look at reports, those month end reports. So we're going to go to the reports dropdown, we'll go into the financial statement reports first, open up the financial statements, we're going to look at the balance sheet. So we will then open up the balance sheet for the month of February. There is our balance sheet. I'm going to make this large, I'm going to scroll through it slowly so you can take a look at it. If you're following along, you can take a look at the balance sheet. Thus far, think about whether or not your numbers tie out. If your numbers do not tie out, then consider changing the dates possibly to a future date to see if any transactions had been entered after this point in time. And then if they have then use the zoom feature to drill down on it, consider how you can basically make any adjustments to any of those transactions if it's a date issue. If it's not, if you can't figure it out, then that's okay. We'll then take a look at the income statement and then the transaction detailed report, which is another great tool for figuring something out such as that. So this is going to be our balance sheet. Now let's take a look at our income statement. So I'm going to go back to our reports. We're going to go to the income statement. We're going to print all of these out or look at all of them, I should say. I'm going to remove the zeros and then we'll go back into them and think about organizing this information and how we would print it out and present it to others. So here we have it where we have the month information as well as the year to date information, which is quite nice. So once again, you could take a look at it and review the numbers at this point in time. If anything is off, check your dates, and then we'll check the transaction detailed report. Note that at the end of the month of the current month, we had the income now 12,955 year to date. We have the 7,217. We had a loss in January resulting in a lower year to date number than the February numbers. Now let's take a look at the transaction detailed report. We're going to go to the general ledger reports now. We're going to be opening up the transaction detailed report. Transaction detailed report. Let's take a look at the options up top. Opening up the options. I like to look at the actual, not the summary, uncheck the summary. And I want to take a look at the month of February. So let's bring it from February 1st to the February 29th. Because there's 29 days this year in 2020. So there we have that include number of transactions. That's fine. Let's go ahead and say okay. So if you had any problems before, this is a great report to take a look at. Again, it's a good report to kind of review your work or review someone else's work because you're not just looking at the end numbers. You're looking at the amount of transactions that happen. Also if you want to build based on transactions and think about those service items that you might want to set up as a bookkeeper or something like that. You could then set up a range and say, hey, look, if you're within this range to that range, this is the service item that we set up based on the number of transactions or possibly even the number of accounts that are affected, however you want to do it. And that can give you a more kind of objective number rather than a income number based on just hours where people are like, well, he's really working for these amount. It's more arbitrary. So this is a little bit more concrete. You can say, hey, look, there it is, right? There's the billing hours. So on this side, you're going to have the transaction type, the date and the name and information. So we could see that on down. And if that's not enough detail for you to basically understand something, then of course, on the right hand side, you're going to have more details. Let's scroll down this way and we can see everything that's going to be entered for the month of February. I'm going to scroll back up top and then take a look at the other side of this report. That's going to be the line description. And then the accounts that are going to be affected. So they actually show us the journal entry on this side of things. So here's the account. Now, obviously, we only have the account number here. So you'd have to look at the chart of accounts in order to tie that out to see what the accounts are. But you can get an idea of what account it would be with the account number, of course, because it's going to be an order by the account numbers or an order by type of account. So then you might want to check then if you're reviewing this stuff and you might want to look at the amounts on the right hand side first and then see if there's a problem with it. Then go back in and look at more detail. But in any case, we'll scroll down a little bit in this way fairly slowly. We will be providing this information, of course, in the practice files so you can take a look at it and do some comparison with it. If you so choose. Now we're going to go ahead and print this stuff out. We're going to be printing it as a PDF using the Qt PDF printer to do so. We'll save it as an Excel file and practice the fact that we can then collate it and print it all out at one time going back on over to the balance sheet. And we will make a PDF file with these reports all in one document with the use of Excel and the Qt PDF printer. So let's do that now. We can either save this on back to the balance sheet. We could save it as a PDF here. I'm going to practice using the Qt PDF printer because I think it's useful to do so. So we're going to go to the Qt PDF printer. I'm just going to go ahead and print this item out. And it's going to ask me where do we want to put it pretty soon? I hope that's what it should do. And then I'm going to say I want to put it in the section eight in the Sage 50 cow to counting section eight. And we're going to put it there and standard balance sheet. That looks good. So I'm going to say, all right, there is that one. Then I'm not going to go to the I'm going to do them all first as PDF. And then we'll go back and do the Excel. So then I'm going to go to the income statement. That's what I think is the fastest way to do it personally. And then I'm going to go to the income statement. I'm going to go say we're going to print this one as a PDF file as well. It's going to go to the Qt PDF printer. I'm going to say, OK, that's what we want. It's going to ask us where we want to put it. And I think it's already going where we want to put it. So I'm just going to say, is it going there? Yeah, income statement. That's fine. I'm going to say, OK, on that one. And then let's do the third one, which is the transaction detail report. Now, this one might be a little bit tricky because it might not fit on one page as well, which is another reason it could be useful to then export it to Excel. We have a few more options with regards to the formatting of it. But I'll print this as the PDF here. So we're going to say, print it as the Qt PDF. And there is that and save it. Now we'll export them to Excel and then we'll format them from that point. Let's start with the balance sheet again. Start from the first point balance sheet. I'm going to export it to Excel. We're going to make a new sheet. So it's going to go to a new Excel sheet. So I want to create a new Excel workbook and then it'll create the worksheet within the workbook, of course. So we'll say, OK, should then make a new Excel workbook and then put the worksheet in it. And there it is. It did exactly what it's supposed to do, which is nice. You could do any kind of formatting once in this spot, which is great, too. I usually will check the page layout to make sure that we have the name up top in the section heading or in the header section. So then I'm going to go back to the this view, the normal view. Then I'm going to save this. I'm going to save it not as the balance sheet, but as the financial statements because then I'm going to be putting the other kind of reports in the same area. Maybe I should call it reports because I got one one. The transaction report isn't really a financial statement. So maybe I should call it month in reports or something like that for February, but in any case, it's going into our Sage 50 cow docks. And then we're going to go to the section eight. And we're going to say this here's, here's the moment of truth. We'll call it reports. We'll call it month and reports, fed, but something like that. Okay. And then I'm going to say save and then close this out. We'll close this one out. And then I'm going to do this, do the income statement. Let's go to the income statement. Now going to export that to Excel, but this time to the existing Excel worksheet that we just set up. So I'm going to say, I want to go to the existing workbook. And then I'm going to find it because it's not going to the right one. I don't think right now, because that's section seven. So we'll go back to Sage 50 cow. And then we'll go to section eight and we want to go to that one. That's the one we want. So then I'm going to say, okay, it should then open up that report that we had. We put a new worksheet on it and the new data in it in that new worksheet. And there it is. It like totally did just that. So we have it. And if I go then to the second tab and there's our header, that looks pretty good back to the first tab. I'm going into the views over here, normal view versus the page layout view. Now we could format this. I could like delete these. If I don't want these numbers possibly, if I didn't want the year to date or something like that, you could do some quick formatting here. If we wanted to remove the pennies possibly you could do some quick formatting in that, in that case, I'm going to keep this for now. I'm going to save this again. We'll do some formatting in the next report. I'm going to save it. I'm going to close it and save it. You should probably save it and then close it, but I'm going to close it and save it because I'm living on the edge. And then we're going to go to the transaction detail report. And then we're going to do the same thing. I'm going to export this to Excel once again. It's going to go to that existing workbook. So we're going to say OK. And there we have this one. Now this one needs some work. If I go back to the second view over here, the page layout view, it doesn't fit on a page wide. And that is something that's just not acceptable. So we're going to have to do something about that. So what are we going to do? We get first, I would check the layout, which Sage is pretty good at changing the layout when this happens. So you go to the page layout and you go to the orientation. It's in landscape. So that's all you can do there. Then we want to maximize the size of the column. So what we're going to do is I'm going to highlight. I'm going to select from column B and go all the way out to column L. Let go. And then I'm going to put my cursor anywhere in between these columns. So it looks like that, not like that, but like that, not like that, but like that, and then double click there, double click there. And that will make the columns as large as possible without removing anything. And then we're still not quite there yet. Now, notice that there's a couple of columns I might not need. This job ID column not doing much for me here. So I might say, why don't I just remove this one? I totally don't need that. I'm just going, I'm not going to remove it. I'm going to hide it. So I'm going to hide it. So it's still there in case someone needs it, but I don't think anybody needs it, but I'm kind of too scared to delete it. Now, this one note, I've got some names over here, but maybe I don't need the whole name. Maybe I can, maybe I can make this go down a bit more so that I just have the ID, something like that. So you could do something like that might be, might be useful. You could do the same thing for the name over here. And again, you could hide another column if you so choose. So maybe this name column, I could say, let me just bring this down just enough till it fits on a page and see if that, if that's something that's not acceptable, given that if I look at the data, it looks like that's, that'll be okay. It looks like that's okay. So then if we, I'm going to keep it at that and let's check and see if we can print these three reports then out on one page. So I'm going to save it first, not on one page, but on one PDF file. So let's go to the file tab. We're going to go to the print option. Now, if we wanted to print this, now we can, we don't have to like do any fancy collating. If we've sent it to the printer, we can just say, I want to print the entire workbook. That's kind of the trick, not the sheet, the entire workbook. And then it should be pre-collated. Here's the balance sheet. Here's the income statement. Here's the transaction report. And this is the tricky one. Does it all fit on? It looks good. That one looks good. And we can export it to Excel if we have the, I mean, to a PDF. If we have the Qt PDF printer, putting them all on one page. So let's do that now. Let's print it. And then it's going to use that Qt PDF printer to put it all in one PDF file, which is fancy. So there's the month in reports. Let's go ahead and say save on that. Then I'm going to close this back out. I'm going to minimize this. I'm going to minimize this, minimize this, minimize this, close that. And then I want to get into my Sage 50 cow to cow folder. So we're going to go into the Sage 50 cow section eight. And then once again, we can give this reports to somebody else one by one with like a lot of attachments, but that's kind of a lot of attachments. We could put them into a folder, for example, calling that folder the month and reports for February. And then we could put this information in there. So I could put like the balance sheet in there. I could put the income statement in there. And then we might want to put this transaction detail report in there. This other thing was like checks, we print it. So I don't think I want to put that in there. And then I could zip that, of course, we could right click on that and zip that folder so I can right click and then compress the folder. It's not wanting to do anything with the right click right now. It's a little annoying. Let's try it again. If I right click, there it is. So then if we send it to we can compress it and that allows us to attach it to a email or something like that. Then, of course, we have it in Excel where we can print it from and that will make it collate easily. And we have it in the PDF file so we can have basically one attachment with all of those pages in the one attachment. So here we have the assets, the income statement or the balance sheet, which includes assets, income statement and then the transaction detail report at the bottom. So that's going to be it for now. Let's get out of here.