 zero accounting software 2023 income from bank feeds with bank rules one customer but two income accounts 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 duplicating some tabs to put reports in like we do every time we're gonna right-click on that tab up top and then duplicate it and then right-click on the tab up top again and duplicate it again back to the middle tab going to the accounting drop down opening up the balance sheet report tabbing to the right accounting drop down this time the income statement report we're gonna change the dates on the income statement to 2022 because that's the year that our transactions are in from the bank feeds January to December of 2022 update let's go to the first tab we're gonna go to the accounting drop down into our bank feeds which is under the bank accounts we've got our one account connected thus far we're gonna go to the drop down for the manage of the accounts account transactions so we're now gonna keep on adding some of the deposit side of things trying to construct our income statement from the deposits noting that we're kind of assuming at this time we're imagining we're doing like gig work or something so that it's fairly easy for us to wait till something clears the bank and record it as revenue when it does if I go into the cash coding over here the new thing we're gonna do if I if I sort by the payee is we're gonna say what if we've got different kinds of deposits coming from the same customer and this could be a similar kind of thing that you would have on the expense side of things what if for example you had different kind of expenses or different kinds of accounts for the same vendor on the expense side when money is going out it might be for like a half office depot or home depot or something where you might normally buy supplies but sometimes you might be buying equipment or something like that and you might say is there any way I can differentiate the information in the account to make that differentiation sometimes that might be by the dollar amount but here we're specifically looking at the added detail so for for example here you might have multiple types of income coming from Amazon right you might have book sales you might have you might have Amazon affiliate marketing you might be selling inventory on Amazon so is there a way that I can distinguish you might have different locations from Amazon where is it being sold in or something like that so we could look in here and try to say is there anything in this added detailed information that can help me distinguish between one type of income and the other so for example here even in the payee line they have Amazon which is really the customer you would think would simply be Amazon but you have this differentiating factor with the income and the California now if that ties into two different sources of income you can use that as a differentiation factor now even this description sometimes the bank feed memo information comes in and possibly you might end up with a different number for example that might indicate different kinds of locations so you might be able to get into a little bit more detail on the memo description and see if there's a differentiating factor that might be indicating different locations or something like that which could help you to make more detailed bank rules and break out the different customer payments for different things to separate accounts let's go back to the reconcile tab okay so let's add the detail here so I'm going to go in I'm going to assume this one I want to make a specific rule differentiating this amazon.com from that amazon.california for example so let's go into here and say add a rule or let's add the detail first because I want to add an account as I go now when you when you're going to create an actual customer notice that you could just call it amazon right I could just call it amazon as the customer and have one customer for multiple different rules and still be able to apply it to different accounts or you might want to have a separate customer so I'm going to add some of that differentiation factor here so that I can track it in different customer fields so if I sort it by customer it's going to be a different customer even though really it's it's the same kind of overall company of amazon so that's an option you can have I go down here it's going to be I'm not going to have an item description the account that it's going to go to I'm going to make up another account here and break it out and I'm going to call it let's pretend that this one is let me see what revenue accounts I'm on here it's my account number my account number is three four three five four three six zero let's say four three six zero so four three six zero on the account number it's going to be a revenue type of account so I'm going to say it'll be a revenue type and then I'm going to call it amazon crime so that's like similar to youtube or if you if you uploaded movies or something like that then that type of income so let's say I can differentiate I'm just making this up but let's say we're going to differentiate in that fashion and put this to amazon prime account so I'm going to say all right let's save that and then I can make a rule for that if I wanted to hit in the options button now that I have my account entered and create a bank rule let's create a bank rule and it's going to be any conditions match that's fine it's going to be if you have any uh I like any text field I love I love that they have that option of any text field which it isn't often there in other softwares like uh like a quickbooks because that allows you to use the rule to apply to all you know all the text fields you don't have to say well is this a description or is this the memo field or something like that when you're trying to put these more detailed rules in there and then I can say I want it to contain I want it to contain and we only really need the contain you could do exact here but I still just may make it contain and I just want to make sure that it contains the portion that is different the differentiating portions from the other rule now if we wanted a rule to pull in all amazon items all amazon related stuff to the same account then I would want to make a more generic rule possibly saying if it contains amazon just do this to it but if I want to differentiate them I can include that differentiating factor which is this bit and make sure that that's in there so it will only apply it to that differentiating factor now if there was more information that I needed to differentiate such as the description here again I could use an any text field to do that but then I can pick up the piece of the number that's a differentiating factor or I can have the two line items and say you want to make sure that it matches all of them all the rules in order to to get it but I this should be enough with just one for now so I'm going to remove that second one I'm going to call it amazon can I just copy it no I can't copy it let's copy it down here I'm going to call this amazon.com so I'm going to copy and paste that there and that's going to be my new contact so and again I made a different amazon.com not just amazon so that'll be differentiating from I think the other one was amazon.california or something ca and so down here I'm going to say the account is going to be the income account of amazon prime 100% going to it and then I'll just take it so the reference that looks good so if we save this and then I can record it so so now these two are both being pulled in because they're amazon.com so I can pull both of those in and check it out if I go to my balance sheet and update it the checking account should go up by those massive amounts in here but the other side is going to go to the income statement updating the income statement into the new income account amazon prime if I go into it we're racking in the the money almost eight dollars right there that's what I'm talking about we're so there it is amazon.com received money for them all right back on over now the other one if we have received money from amazon