 Another common thing you might do is like type and then you might want the distance which is going to pull over here and then maybe you want to filter by this other Further filtering down which was the personal that that that broke out into the trip purpose, right? So within the trip purpose I can put that maybe into the filter Boom it pulls it down here automatically. So it kind of has this added drop-down, but you could put it into the filters And so now you've got The business personal and the unreviewed but I can hit the drop-down and say I just want to see it like the charity and then and then filter Now obviously the business and personal goal I mean the business goes away and now you just have the personal breaking out by charity and then you can do the same for medical Right if we wanted to do something Like that. All right, so just some good data to mess with some pivot tables with so if I go back on over here And I wanted to see if I was entering this month by month You might use this data to enter into your software like once a year or help give it to your tax professional You can organize it this way and just give it to your tax professional and whatever makes sense Or you might do adjusting entries at the end of the year to kind of get an idea or do an adjusting entry kind of Monthly so let's take this data and do our month our monthly kind of adjusting entries So if I look at this let's filter it this way by just looking at at May and Then I'm gonna say that I want to look at the meeting The meeting with let's say that we just want to look at the business stuff so I'm gonna say just the business stuff and so that comes out to our 35.76 and if I multiply that times the rate, that's how they're getting this 2342 for the rate now hold on I wanted this for June the second month Let's do this for June So there we have it. So now we've got And not may what may still there just June Okay, so there we have it. So so it's just a Wapping $11 that we're gonna say on the mileage method. So let's do our our journal entry thing we did before But now for the second month. So if I go to the income statement and I look at this just for For oh six oh one two three and I run it here so There's June all we have are these items in that month. I'm gonna say let's see this on a Classes breakout now We don't have any classes yet And I'm gonna do this breakout basically removing these two amounts or just this one Because that's not deducted under the mileage method and then I'll add the deduction that we calculated over here for that month Which is just the $11. I know they don't tie out because we just randomly put in dollar amounts here But they would be closer in practice You would think because the mileage method the iris is trying to attempt it to be somewhat approximating the actual So if I go back on over, I'm gonna say there's $200 That I'm going to make a journal entry for Removing it for taxes and then I'll put in the amount we we can deduct for this month. So I'm gonna go to the tab to left plus button and I'm gonna make our journal entry again like we did in the prior presentation, but this time for the end of June this is gonna be a monthly adjusting entry Which you might do in practice on a yearly basis if you just want to do it once a year But just to get the idea we're gonna say that this is going to be going to auto Expense and this is gonna be for 200 and then the other side is also gonna go to auto Wait, not just auto expense. There's an auto tax adjustment The auto tax adjustment that we set up last time Which is a new account that's just gonna have our adjustments sub-account of the auto expense so what I would like it to do then is reduce the the the The one with no class and then I'm gonna make the this one then be our tax Adjustment, so there's our tax adjustment So this will just be a column by column adjustment won't have any net impact on this account because the two will total out and Back to zero. So let's save and close it if I go back on over here just to check it out boom And so now we have our this It doesn't have any net effect on the total if we took the classes off And now this not specified area has been adjusted to account for Decreasing the amount that we're not gonna be able to deduct on an actual method keeping the 150 We can deduct and this is gonna be kind of a jewelry so we can see the detail of what we're doing and then I'm gonna put on the books the amount that we can deduct just for the second month Which we say in our this 11 1101. That's what we're calculating noting that I'm I had to kind of Export it out here to see it because if I look at this report, it's only kind of giving us the summary data for The entire year here, right? We could have a custom date. Let's do the custom date and this is for June 1st to June 30th and So there's that gives us a custom date so we can do it that way as well to kind of double-check our numbers We could sort of that way, but it still doesn't give us all the personal Stuff, but there it is. There's the 1101 and so we're gonna say alright. Let's enter a journal entry for that one That's what we get to deduct and so we're gonna say alright. This is gonna be