Sign Nebraska Banking Profit And Loss Statement Fast

Industry sign banking nebraska profit and loss statement fast

this is just quick video on how to create a profit loss statement or do some financial analysis from bank statements that you've downloaded for me to get banking to excel so oftentimes you might not be running a zero far or my power or whatever and you just want to quickly put together a problem while statement so you download your bank statement to excel something like this the description is going to be a bit longer at top just Queen's and some dummy ones here and obviously it's going to be a lot longer has a number of transactions but this will do for now so we've got all these transactions in here so this is the description that's come on bank statement so all we need to do another column here that's right what the description is for now to make this quick easy you can sort by comma C so I was going to data sort is sort by a description and we get everything together so we know that they obtained since it's a sales fuel with us keepers and by recalled Spence left down and then office work so we've got Spencer's will pretend spattering we want to use the transfer so from the while statement we don't have to worry about transfers egress so if you're a sole trader you don't worry about that as a Bunnings here's a maintenance for whatever it is I copy that down so now we've got the account for all our transactions so all we have to do now is highlight everything so hide at all the cells so for this we do need column headings or if we go to insert and then we click on pivot table I'm just click on here existing worksheet and location was quick there doesn't matter we click on quick ok now if you click on account so counts go into rows and then the amount amounts go to values and so it's something everything up here so now some quick for the profit/loss time we're going to do a couple things we just copy this is give you by a formula to a pivot table so to get the net amount which is team poppers down it's still refers to this cell here so it's been knowing so just got to you or you can you do this just copy that and then you can work with these cells so this is the gross amount technically it's a net and then we cut the net so these are the figures we can then use for the panel and if we want we can just copy do something like this so we'd have to worry about transfers for a profit loss statement so we can play around with this and um so just want to copy the values or or we could um yeah do it we like feeling whoops the game too fast yeah oh there we go so we've got that and sales so I can sick sales at the top and then put our expenses get rid of all these decimal points and then we can quickly work out our profit loss