 of February. Now we have the same kind of thing that I could use this balance sheet but it has a bunch of subtotals in it and whatnot and it might be easier for our budget to exclude all of these subtotals so it might actually be easier to once again use the trial balance because it doesn't have all the subtotals. So if I go to the trial balance over here I can run this let's run it for the totals as my starting point and now I just have my balance sheet on top of my income statement the balance sheet being the assets which are from cash down to the machinery and equipment those are mostly debits and then we have the liabilities and equity being the other side we have the accounts payable credits of the liability and then we have the the the liabilities down to the equity here here's where equity starts and this is where it gets a little bit messy in that the income statement is part of equity so there's a couple different I don't really want the income statement I would like to remove the income statement and have it just roll into owner's equity but I could just squish all this know all these numbers into one number as owner's equity I could do this a couple different ways like I could start for example by just taking this up a year to 010125 010125 and run it so then now everything's been squished into equity same numbers but what if I had transactions in January of 2025 so let me just do it this way I'm going to say 010124 to 022924 and so there's our two months I'm going to export this and then I'll just delete the income statement and roll the income statement into into equity I'll show you how to do that it sounds complicated but it's not difficult so let's go ahead and check it out so I'm going to say export this to excel now I've already done the income statement in excel over here so we already have a worksheet open so if you don't have a worksheet then you then you don't have to use that one but I'm going to so I'm going to enable the editing and I would like to move this over to the other worksheet where we already have the income statement budget stuff so I'm going to right click on the trial balance here and I'm going to say copy or move and then I'd like to put it over uh in another in my other workbook which is the budget workbook and then I'll just say move it there pour five or please if you would and then I'm going to grab it and drag it to the right so the first two tabs are income statements I'll double click on them and I'll just say let's say p&l for short p&l one and then this was a p&l worksheet p&l worksheet or something like that and this one's going to be the balance sheet we'll say one okay so now I can just clean it up I'm going to hold control and scroll up and I'm just going to clean this up to get to get just to all I want is just one line of numbers possibly having not debits and credits but rather assets being positive liabilities and equities being negative or in other words I'll represent the credits with negative numbers so I can put them in one column and prove that I'm in balance not by having two columns that match each other but rather by having to sum up the negatives and the positives debits positive credits negative and it'll map out to zero that's a little bit easier to see because then I can then I can easily make my adjustments on one column instead of two columns so let me show you what I mean there's not really a whole you could try to do this with an account equation format and not use debits and credits but in in my opinion this area is where the debits and credits are going to become more useful and so it's a lot easier to do I think although if you don't understand debits and credits you'll still be able to see what I'm doing here pretty clearly I believe so let's go ahead and do this I'm gonna I'm gonna format the whole worksheet to be the normal format first so I'm gonna go to the home tab paintbrush just a cell over here and then I'm going to paintbrush the entire worksheet on the triangle so that's my default formatting then I'm gonna right click on it and format the cells to what I would like so it's all uniform formatting to start out with I'm gonna go currency negative numbers bracketed I don't really need I don't want the dollar sign and I don't need the decimals because it's a it's a budget right so it's gonna be rounded so I'll say okay and then I'm gonna make it all bold home tab font group bold you don't have to make it bold yourself but I think that shows up a little bit better possibly on a on a screen recording and then I'm just going to delete all the stuff so let's just delete from I don't need the header from row one to five I'm selecting actually on the numbers row one to five right click delete and then I'm going to scroll down and say I don't need the totals down here I'll go ahead and delete that I'll be able to use my balancing concept hopefully to figure out if I messed anything up so I'm going to delete this stuff and then and then I'm going to go up and say okay now the credits these are the credits what I'd like to do is put them in here but have them be negative so the trick to do that here's a little trick we can use we can pull this I'm going to take this whole column or I could take the whole column this way like here's the column right click copy it I'm going to paste it over here first right click pasting it special but subtract so it's going to subtract nothing's in these cells therefore it should just give me negative numbers flipping the sign boom they're all negative then I'm going to copy that and put that back over here right click and paste I want to paste it just like one two three because I don't want any any uh format formulas notice that these still have these funny formulas even though it's just a number so I'm going to do the same thing over here just to get rid of those equal signs I'm going to select the whole thing right click and copy and then right click and paste one two three and now there's no equal signs it's just what we call a hard coded number I no longer need this cell so it has served its purpose and now it will be deleted so I don't know why that's we're going to take it out because it's served its purpose you're going to delete that okay I'm trying to mess with my soundboard apologies for that it's going to be good once I get it so I'm going to pull this over so now I can just drag these into the same column it's easier to use this and then control x which is the same as cutting right click and cut and then hold on a sec uh control x and control v pasting so I'm just going to do this all the way down control x control v cut and paste control x control v