Colabora Fácilmente En La Plantilla De Factura De Oficina Abierta Para Organizaciones Sin Fines De Lucro Con airSlate SignNow

Open office invoice template for Nonprofit

hello and welcome to my first youtube video  my name is Lenny and I'm just going to show   you how to do a budget with with using the  OpenOffice calc and this is just the way   I like to do things but first I like  to make some sheets up I like to put you alright this is just the way I like to do things  I like to name my sheets first so what I do is I   rename me cheat and I like to start off we'll  just start off with January whoops january   and i like to put an underscore and put 2016  and name this one februari februari 2016 and put March 2016 okay just and then you just  go so on and so forth I usually do a year   but it's being that i'm trying to do this  video I'm just going to do three months but   usually I try to put a year okay then the  first the first thing I put in is what I   want date second thing is income and the  next is now I have multiple people in my   multiple people in my family that make money  so just for this is I'm going to put in Pat and Melissa okay and then i have now have my  bills I gotta rent and I have electric and I have gas and that's gas for the house  so i'll put house gas house guess because   i'm going to put gas for the car to and  then house for the gas and oh of course   you can't live without the cable cable and  internet and then you have gas for the car before I put that I'd like to put my phone phone  that's my cell phone and then that's when i'll   put in the cable my cable put in we're going  to put there now I forget my mind's blank okay   phone and gas for the car and insurance okay and  that's about it for now you get the gist okay so   what we do is the first we do is we highlight  the date and of course you always start on 101   2016 okay but I want to make this a date so what  I'm going to do is I'm just going to go and i'm   going to i'm going to do format cells and the  way i want the date to appear is I like to have   the day and the year I like it this way and we  hit ok now let's say this came up because it's   too small so what you want to do is you want to  open it up just by double clicking there and then   you're just going to take this and you've  got to drag it down and as you see it's all   changing right here and you go down to the 30th  31st oops I want to go down to fall so only one   go to january thirty first being that this is  just january and again it's too small so let's   open it up okay now what I like to do is I like  to Center all that maybe Center this and make it   bold let's do that with all this stuff Center  it make it bold and also what I like to do is   I like to put make this a color let's see  what color background color let's make it let's go with a light blue cn2 okay  looks nice all right now got income   you got packed income Melissa's income  okay let's say first thing I like to do   is I like to put in 0 before I go any  further let me go down here and what   I like to do is put totals and I like to  put in this is salaries and this would be ah this will be dulse or you could put expenses  expenses don't think that's spelled right ok ok   and then ok now let's say now what we want to  do with income is we want to put in I like to   highlight this a different color to actually  before I go before I go any further I like to   take my Saturdays and my sundays and I like  them in yellow that's the weekend I like to   show that it's the weekend it's the fun  date paint the date you want to have fun   oops no cancel these you want to have fun so  I like to highlight everything here and yell all the saturdays and sundays it kind of breaks  up everything and catch it let you see things   you know the right way I think I got too many  [ __ ] different shades of yellow I don't want   that now we want the same shade of yellow so go  with this one right I think that's the one here   actually this was darker than this one or is  that the same i use the same skates if i can   and then the last weekend is saturday and sunday  look at that a lot of weekends in january that's   a good thing right weekends are always good  okay now that's all set now what I also like   to do is I'd like I like to put a I'm a border  on it so what I'm going to do is i'm gonna i'm   going to add i'm going to insert a row insert  a column okay but i'm going to make it smaller   all right and i'm also going to insert a row  okay and what I like to do is I take this to   this and I like to make it black really shows it  off black and then the same thing from here down you make it black and then will this actually let's do that let's make it  a little wider why not take three rows three rows and we're going to make that black  and then what I take this and whoops no wonder it and let me call this black and we're  going to make that black ok now a nice   little border but since we got the  bottom three let's go with another   three insert a row insert a row let's go  three rows on top too now you got a nice   border around your your thing now what I  like to do is now we just copy all this let's go into februari that basically  paste it into februari whoops sorry   not good go back back into January  oh oh what happened to January oh I   made january and march silly me okay  so we'll just stick this out copy it put in January where it belongs paste  and without boom boom and then februari paste it but this time gonna put februari whoops  put jus 116 no matter what it will work and then   we're going to just take this i'm going to  scroll down obviously gonna have to change the you're only going to go to februari 29th that's  when it ends so you just going to take this one   so you take all this and you're just going to  delete it out okay and you're also going to take   out the color so you're going to make this no Phil  okay and now obviously I take all this highlight   it all again let's do know Phil got to change  saturdays and sundays and then we back to Saturday yellow Sunday I like that yellow better than the  other one I'm going to have to change the other   one but that's no big deal whoops a Sunday make  that yellow like the darker yellow and you put   the and of course you can use whatever colors you  want I just like yellow just stands out warm and   then this saturday and something and I make that  yellow okay then we go to march now we already   got marching because I messed up but we're going  to change this 23 / 1 / 16 enter and march first   we'll come in and we're going to take it all the  way down to march 31st and the same thing again   I'm going to go like this highlight everything  and we're going to put everything back to know   film and then we're going to do saturday and  sunday all over again and we're going to select   yellow again yellow Saturday and Sunday hello  Saturday and Sunday my yellow saturday and sunday okay now the magic starts okay now we're going to  go back to january okay now the magic starts okay   okay first I want to change this I don't want  that i want well then i just got to go review   some of my old work just to see what I have  how I have it set up just what I'm curious   about something this is my own personal thing just  trying to figure out how I set it up okay so yep   okay that's right okay all right then that's great  it works ok so the first thing you want to do is   ok let's say see Pat gets paid on Fridays that's  or paid a hour payday is generally 625 dollars a   week ok so we're going to right away we're going  to change that to money I like to take this and   fold it and I like to change it to a dark green  oh not that sorry not not the background I want   to actually the font to turn green okay that's not  really I much difference so just will make it red now now let's say melissa gets paid on  wednesdays and she gets paid 500 first   of all I like to do this across the board this  way it's all done and we need it go font color   red and and money ok now it's already night  just put it in so let's say she makes 525   dollars a week ok so now what we're going  to do is she had this alright first we're   going to put in air so every Friday she  gets paid six hundred and twenty-five   dollars 625 dollars 625 dollars ok and she  gets paid every wednesday and she gets 525 okay okay now the rent is due on the  first okay now let's say that rent is let's say their rent is 500 bucks okay the  rent is 500 their electric your electric is   due on the fourteenth and that usually runs  about 130 and your house and you gasps it's   only about 50 bucks and it's doing the  fourth and your cable bill is due on the   twenty-fifth and that's usually 165 dollars  and your phone is about a hundred dollars   and it's doing the 12th then you gas for  your car you need gas new car every week   so every Friday you flit up and you put  in twenty-five dollars every Friday and   on Wednesday you put on 25 to on her payday  so this way getting twenty-five dollars every so you got $25 20 files there and $25  there okay that's when you're putting   gas okay now what you do is you now you  got to do some add this plus this equals do this this before we do that let's do this  your salaries totals salaries is some some do all this this is all your salaries wait a minute salary some now that's your salaries and then your expenses  your expenses you take all your expenses like this well before you do that you hit some  darn it expenses should put expenses   over here delete that goes a  little broken up okay and then I do this and you do some and that's going to  be your rent all the way down to your insurance   so I've got the insurance okay so let's say your  insurance is ninety dollars and it's to do then I don't know where that came from but we're  going to get rid of it get rid of that ok so   the salaries will 1260 dollars and you're  only so no do is we do this and I do this   I do this and I do some I do this over because  I didn't do it the right way and then I do plus I do d 5 + D 5 D 5 and then I start minus  a minus that minus that even though that   there I still put it just because I pay it  on that day oops okay hold on I've must have   made a mistake here d 5 plus up d 5 no plus e  5 e 5 and even though she still isn't okay so   this goes then I just continue down the  line minus g 5 minus i 5 minus j 5 minus k 5 minus your chance okay gente now that  leaves you with a hundred dollars a hundred   dollars now you got to continue this all the  way down just drag this down and it's going to   tell you what you're going to have at the end of  the month put someone wrong something went wrong I run into problems with the life like  that right nothing should be there so well and you got to put in front of  this you got to put in C 5c 5 plus   d 6 and hit enter that one hundred dollars okay obviously I'm going to have  problems in the beginning   I'll basically they're going to  have problems in the beginning all right and then of course when you do that and   what it you have to change them all  back if you want i know i like to you're going to have to and put more back to yellow okay obviously that  was the brighter yellow that I was telling you   about before okay now got obviously they're  gonna have problems they can die happy that   works out good alright so in the beginning of  month they only have one hundred dollars left   if than half but then this is this will show  you what you got what you're going to have the   rest of the by the end of the month but in  a month looking at 3965 dollars and that's   what that's basically what you know you have  extra every week you're like okay fifty bucks   extra and and then you say okay well I can  spend fifty dollars today and you know you   have that extra yeah you know you got five  hundred fifty dollars you can spend here you   got 1,150 but don't forget he's gotta and  then that's how you do the budget you just   look down and boom it's pretty good right now  I'm going to do is I'm going to take let's take   the same stats and I'm going to put all these  bills into the next loan into the next month   okay so copy that and we're going to go to the  next month I'm going to put in the bills again okay and paste it Condor to the clipboard  is bigger than the range selected all right   so you say yes but that's all right because  this is coming off anyway and you're going   to take out the yellow there we're going to  go with oil fill all right now it's back to   normal now obviously everything changes  so go like this we just highlight all   this and we're going to take out gonna put  no Phil no Phil and then we're going to go   back to here and we're going to put in the rate  remaining the fill up don't want to move that there's going to be yellow I'm  going to highlight the yellow yellow yellow yellow and and then now back to Friday so  she's gettin paid on Fridays what we   say she she got paid on Fridays she  got paid 625 so she gets 625 dollars we just kept everything standard red  that's cool that's good that's cool it was cool whoops don't want that  pullin definitely not definitely not red okay kept everything Oh again what a pain in  the neck this is I hate this up I'm gonna hit   it undo the move and I want that or you could just  hold shift control just do this little bit faster and then I go yeah okay not do that  again all right 625 and she gets paid   on Wednesdays and that was how much did  she get paid 5 25 and she got paid 520 525 5 6 25 that's it and that's the  paychecks now again salaries some sums and that's the sums for that month and and again the bills expenses some and that's expensive okay we go cheap for  expenses but anyway which is going all right   now now the only difference is here we're going  to go we're going to go back to we're going to   do some again okay but the one thing we're going  to do is we're going to go back to the previous   page and we're going to click on this I want to  fill that in and it says january on the school   2016 c35 that's where it is and you're going  to go back to februari again and now you can   it again add + D D 35d 35 + e 35 d and then  you get a minus f 35 minus g 35 up wait I'm   messing up yet it's not 35 sorry si si 55 +  d 5 minus e 5 minus f 5 wait a minute c5 nope   oh just be able to hear you're going  to add oh ah better start all over   again because I I forgot I'm what the heck  I did alright so let's try this again go to   January take this then go to februari  now we're going to add d 5 plus e 5 minus f 5 g 5 minus g 5 h 5 minus i 5 minus j 5 minus cape 5 and minus l 55 and you get  it up and then the same thing you got to do here   except you're going to take out everything here  you're going to copy this paste it here the only   thing going to do is you're going to take out  january you got to take out january you're just   going to go from the d6 and that's it then you're  gonna hit enter oh wait sorry and set a decent set   of january you're going to add this Plus so there  was no expenses so there you go and then you just   drag the rest oh I hate dragging the rest okay  well sometimes it's better to just do it so you   gotta drag it all down and you're going to do this  again and then you're going to highlight all these   old two yos and that's it and then you're gonna  do this yellow in and of course you're going to   change these to the dates that they do the first  this is doing the fifth right this was do one and   you move them around if you had to if you had  that you move them around like you said $25 on   friday so i'll 25 but you're going to delete  that one then you're going to delete that one not gonna need gas that day because you're  gonna get gassed this day 25 and you got to   get gases they not gonna get guests this day and  hopefully you don't have to buy gas as much but   you know i'm just using it as a reference but  you know hopefully you don't have to i guess   this much you never know $25 and of course  you did just it as you need it if you don't   take $25 put down 10 just go by what you would  you use you don't buy it on wednesdays and you   buy it on sunday or monday instead put it on  sunday on monday if you don't use it all you   know if you only put 10 hours in one day change  the tenon it just makes that go up so who cares   that's good that's a good thing and that's  about it and that is just about all I like   to do and then this carries over to the next  month and so on and so forth and you could do   the same thing with March do the same thing with  March and that's basically it and you could do   january-february march april may june july august  sometime october november december that's what i   like to do I like to do the full year and that's  it and that concludes my video and thank you for   watching and please like and subscribe and also  uh make comments I appreciate it thank you by now