eSigning Annual Report Template – Foreign for Profit Made Easy

Esigning annual report template foreign for profit

Keltie man welcome back and as you know zero provides a broad range of your standard and not so standard accounting reports what we're going to go through in this session is how to take those reports and customize them to make them suit your business so to get started with customizing our reports we want to go to reports and all reports and this will bring up the standard reporting menu now you remember when we went through the overview training reporting overview training and there are a few different areas to this there was the summary which is what we Renia the custom reports which was we were going to be saving our reports we make today advisor which is that all the advisor account type reports we don't tend to deal with and then you want to imagine a bit of a line because from there we get into the different types of reports which are the draft reports the publish reports so these are more date driven these are more like a report types on these three here and these are the specific outcomes draft published in archives so if you click on do your summary reports will pick the most popular one which is their profit and loss report I'm going to show you how to customize this so the standard profit and loss when we went through our reporting training you recall how we had these report filters that we could edit and that was that was pretty cool and nice to know so if I took a look at this month and looked at a few previous periods we can look at three months of profit and loss for example July and June May April all the way up we could even choose whether we chose it and broke that down by office or not and a few other no clever things like that but what we didn't get into is how we actually customize this so I'm going to show you how to do that now now we can change the name of this report and so you might prefer to call this a profit and loss statement if you hover over a profit and loss like so you'll be able to edit title nice that's pretty easy a similarly if you want to edit the values you can click hover and click Edit here but it's people find it a bit hard to see sometimes I'll turn of leaking a scroll right the bottom and click Edit layouts this is where we're going to be spending most of our time so I've decided I want to change the layout of this report and we've got quite a few options available to us and here so here I've got three different columns as you can see and I'm gonna and we've got a bit of a menu at the top so this is zeros new reporting tool and it's only available for those reports that say new Nicks of them okay so they're all eventually going to look like this and even at the time of this recording most of them most of them are available so what we have here is a bit of a P&L as we normally would have it but it's a lot more interactive because some of the things we can do we can click and drag for example the order of things so that's pretty easy but as you can see it's quite intuitive because you just click and move your currency gains to the bottom there for example but that's not all because one of the other things you can do is you can group things up so it's a real common request I get and all I did there was click on one you know how down the command button or the control button if you're a PC user and I just collect multiple and you like as many as you'd like and simply unclick them to deselect so in one scenario in my group Apple my travel and on there are I might group up my travel and on the right hand side I could group selection and call that total travel or just travel great it's gonna ask me whether it's debit positive it will create a positive you're not sure what that means it's a good time to do this with your accountant so talk about some ways you could simplify or expand out or drill down into certain areas of your business you really keen on and yeah we want to David I'll be able to help you with this so our expenses are typically debit our revenues are typically credit when you're dealing with am dealing with a profit and loss statement but it does change report to report so do ask so I'm going to click our group selection and we won't get into switch rules just today but as you can see there we go I have created am ah I closed out of my report here we go let me just edit that again here we go I haven't actually coded anything to travel so this won't be visible and the one I've got that group that up and we'll call that uh a type of travel just traveled with an A excellent okay and that'll be a handy little drop down now so I'll try to find something that's a bit more relevant to us so I might pick out all the things that are kind of building related perhaps so telephone and here's a maintenance if it's of buildings and we'll go with rent actually telephone what else we have so office we'll just group out building off the printing stationery office light power heating up skip repairs I mean it's telephone isn't it and rent obviously cleaning it sounds pretty good so these are our kind of building related costs I mean a group all these up and I'm gonna call these building costs like so it's just to move them all under that one heater there it's pretty tidy eh I might have some start related ones as well so I've got salaries KiwiSaver employer contributions that's about it put my group those up and call those staff expenses so you come up your own hitters and pretty easily as you can see now to save that and you want to click done and that would take you back to the original document like so tour so we still have our P&L here as you can see it's called a profit and loss statement instead of profit and loss and we have where we have here doesn't look like I've actually um incurred too much of those other costs so I can't show you what that looks like but you need to take my word for it that if I had include some staff expenses that would be titled under staff expenses right so we'll get back to editing our layout I'll show you a few other nifty things we can do all right cool so you can actually add and we'll just go from left to right now and you can actually add in text so I am and suit some text example you can eat it in put in a hidden or a description or some expansionary note - or a note and put in your text here so that's in it's going to be hard coded and you can use anything you like but if I save that that's would display with a report that I've preparing so this might be a good opportunity to add in narrations for the periods it's in the report awesome that's a good example of a text text field you might insert alright okay next one is a bit of a schedule so you can add accounts to the schedule and all this is is a bit of a so you might summarize stuff up here and then add the detail into a schedule and it just gives our readers the opportunity to view the high-level information in up here and then we could do a schedule for um building costs you can add an account and put in repairs etc rent and insert just those just that information that relates to building costs excellent so that's a shuttle here we have a row so if I add in a footer this would be another maybe like a where we do I could just do one so one in a VA for expansion footer cool so yeah similar to a text field there okay now here's some of the cool things this is a row let's insert a row and we have two options here we can add a group so we can just group this and it's a manual way of grouping that selection we did earlier so if you do an tota total and can we'll do other revenue revenue then what made it create a positive cuz its revenue and inside here or group um see I just want to trash that's no one here we go cool thank you they're with me they're nice okay let's grab that selection so other Riven you recently revenue interest income I'm gonna rip that as other ribbon you create a positive and that'll do now I said now I've got will put it at the bottom as well okay so let's let's inserting a group now this is the paradigm quite excited about the formulas so still really days for formulas but here's an example of some of the stuff you can do with formulas now um real common one people like to see inside their profit loss it hasn't been possible we know a lot of accounting systems today is the ability to insert formulas into your reports so here's an example I'm gonna call this Christ's profit percentage and what we're going to do is under this insert button we're going to insert some fields now you notice it's quite a limited at the moment so you only have these four fields to work out but any combination of those fields you can insert the formula and it's going to calculate for you so gross profit percentage as we know is a closed profit divided by trading income there you go so okay done and you'll see what I mean so now that we've ended that report I now have a formula that's going to calculate on this report itself across all those months here's that gross profit percentage and it's 0.3 negative ten eighty eight percent fifty percent so that's that's a pretty cool example and it's going to eat at that layout I'll give you a few more examples now if we go into net profit and we can go and insert another formula and we'll do round we can do any profit percentage or something for that if it acts over here and ratio or something like that so Nick percentage and we can say that it's an your profit see you can actually group up anything you group up you'll notice pops into this which is pretty enough da so any profit over Nick's house trading income there we go cool so that's a formula as well nice now and it's in certain accom so see in this column some people like to include variants versus actual or previous period this period that sort of thing we can have the same set of options around the budget the notes in the office so I'll show you a few of these offices actually you're tracking category now if you insert a tracking category we can make this just for the north island so it'll be profit for the North Island and we can compare that with the total profit or I could remove some of these like so and you can completely change this might be total profit call this total profit and we can break that up and suit some rows pretty easily like so and so got north island what else do we do North Island to sell Poland so might just go north in south Finnell and yes so now I've got a total profit North Island in South Island you're not gonna sum up those so or wouldn't see it the others as well office Australia Indonesia Australia office Indonesia here we go fantastic so those four if everything's assigned it those four should add up to total profit no just click and drag that around you can see quite unsure once you get get used to it cool so the other things we can insert as a budget you can pick which and budget if I had more than one I could pick which budget this related to and it might be revenue budget for example so I had don't have one but that's so we'll get rid of there for now cool we can suit a formula in here so it could be a variance call it a variance and variation you might have your own for example we might if we insert that budget again I haven't finished there that's alright here we go budget so yeah I might have my total profit and I have my budgeted profit for example budgeted expense and I call this total here we go that's my turtle that's my budget and in my very variance uh Koreans percentage I might say that it's my yeah turtle over over all like so cool so that's another another example of came across we can also add notes and line by line that's really good because it ties in with your footers so at this in here you might go here's my explanatory footer dear number one and you can say that's number one and number two we don't have a number two it just means that if people are interested in this line level here direct sales they can come down to the bottom and view any explanatory note that cedar expels were up by 33 percent on last month or something to that effect so it's pretty cool and what haven't we done yet office formula budget date I think we've done all of that so this would just be if you wanted to insert another another month better I don't at all so I'll leave there's is it's gonna be pretty Missy but we'll call that done okay so yeah that's a bit of a dog breakfast but ideally that would be multiple profit-and-loss custom reports that we were billed for different people different purposes to make different decisions okay awesome Asahi is that report ok cool now how do we save this report because I don't want to build this every month because I've put the a lot of effort into preparing this so I want it done come down to the bottom here and I've got a few options no we all we've always been able to draft or a public draft report like where you do any of our other transactions and then you know maybe how there have you reviewed and publish it before we send it around and or have people log in and view it what I'm going to show you how to do is to save this as a custom report so I'm going to call this and profit and loss Ruben's Pro profit and loss it's a bit and you have the opportunity to make this the default view on this report now keep in mind this is not just for you so anybody running in profit and loss if you click this box they're going to get that dog breakfast of a profit and loss so I'm not going to take that but you are welcome to if you put a bit of effort into and prepare cool so now that I've made that my default view if I am so I haven't made that my default view but if I want to go and find this report again and reports and a custom we here Ruben's pro profit and loss and I can add that to my favorites here if I come back to my summary and we open that out we should get there on my favorites reports Ruben's pro profit last there we go so you can customize all these favorites here you can make unique to you that's pretty cool alright so one of the last things I'll show you is how we can a lot of people want to know how to get these out of of 0 and to like Excel or something like that if they need to and do fancy graphs and things beyond what 0 can do so at the bottom of every report you always have an export option and there's three options available print PDF that will simply print you a pretty F in it so it's pretty it's quite good-looking as you can see and it's got all the information that you included in your report in it that's a good option option number 2 excel that's for people they have excel that'll open up an Excel spreadsheet for you like so there we go just like that okay so you'll be fall from pretty familiar with it and a last option my favorite option is Google sheets it's only suitable if you have a Google account actually no I don't think I even need a Google account looks like it's opening anyway no it has logged me and so yeah you out we you all need a Google account for this but most people do have one if you're a YouTube user at all you'll have one you might not know it but it's basically the same as Excel just online and the benefit of that is that most people can use can can interact with us online without having to email around the same or multiple versions of the same spreadsheet so that's the beauty of that it's a it's an it's available online so those are your export options and you can do that from inside your custom reports tab here like so cool what you want to delete your customer report like I'm going to somebody collectively so that was how to customize your report inside your Xero as you can see there's a lot of different things we can do now to the standard see reports within our 0 we can save them as custom reports and share them with other people a lot easier and make them a bit more meaningful to us so hopefully you found that worthwhile and I'll see you on the next session