 zero accounting software 2023 bank rules split expense into two accounts and tracking categories get ready to become an accountant hero with zero 2023 here we are in our custom zero home page going into the company file we set up in a prior presentation the bank feed file we're going to duplicate those tabs to put our reports in right click it on the tab up top and duplicating it we're going to right click on the tab up top and duplicate again let's go back to that middle tab and open up our favorite reports the accounting drop down and the balance sheet tab into the right the other favorite report accounting drop down and the income statement you never get tired you never get tired of the favorites right you can play them over and over again and then they and then people try to force you to watch some new thing like a disney movie or something you're like no no that's trash i'm sticking with the good stuff man i'm sticking with the fit and we're gonna hit the january to december of 2023 uh 22 that is and updating let's go back to the first tab now back to the first tab and go to the account drop down and we're looking at the bank accounts we're putting in our more sophisticated rules this time we've got our bank feeds in place we're looking at our checking account and let's look at the reconcile tab we've been constructing our financial statements from the information through the bank feeds as much as we can using normally fairly straightforward rules such as we're paying the gas company or something so we've got whatever the so-called gas company for example goes to the account of uh gas expense or utilities but sometimes it's more complex than that this time we're going to imagine that we want to be breaking out an expense to two separate categories now this could happen for a couple different reasons for example you you might be in a system where you have uh two locations two different locations and your expenses you would like to say well i'm paying this bill but i want to be breaking that bill out on a percentage basis for the two locations you might have that sometimes it comes into play if you have a not-for-profit organization where you might be breaking your expenses out to not profit you know categorizations for like a form of class tracking type type of thing or i should say kind of like fund accounting type of thing so what we would like to do then is we're going to we're going to go to that i'm going to go to the tab to the right and we're going to imagine that we have some expenses on the income statement and what we would like to do is break out the expenses we're going to do it in two ways we're going to make one two separate accounts which we're going to imagine are broken out by location and we'll also see if we can make two categories tracking categories that will be on uh the income statement up top so we can we can break it out that way as well and then we can use our super cool edit layout tab over here to expand or collapse or format further our report now we added the tracking categories in a prior presentation just let's just recap on how to do that let's go to the first tab if you wanted to add those tracking categories accounting drop down advanced stuff we're going into the advanced not too bad but it is advanced we're going into the the range of the expert here so we're going into we had the tracking categories if you add a location or a tracking category here then the top part is the tracking category name and then you can put multiple things that you're tracking under that category name for us we have the locations i'm just going to say location one location two and then i have n a or not applicable neither location i want to be able to assign a location to every every transaction if i'm using this kind of strategy usually because that will allow me to to kind of catch errors oftentimes if i wanted to add another category i can add another one which would give us another tab over here but that's the general outline with uh those categories now let's add some accounts to our chart of accounts accounting drop down i'm going to go into the chart of the accounts i'm going to add new two new accounts which are just going to be test accounts they're going to be expenses let's go over to the expense side just to make it a little bit easier to see and i'm going to make another one just calling it six zero six zero let's say six zero six zero add an account it's going to be called six oh six oh and it's going to be an expense type of an account and the name is simply going to be test test expense expense so test expense and i'm going to put location one and then i'm going to make another one six oh six five test expense location two so i'm going to save that and let's add another one add another thank you may i have another six oh six five it's going to be an expense and it's going to be test expense location two and we will add that one so now if i scroll down we've got these two locations when i add information to these items they will show up on the income statement as two separate locations right we're going to start putting things in here two separate locations which i can then group together using my edit layout and make a subcategory for them and i can also break them out by category location up top so we're actually going to do double duty having them broke out by account and by tracking category and then uh that gives us like a