 Here we are in our QuickBooks Online test company file using the account view as opposed to the business view. You can toggle between the two views by going to the cog up top and switching the view down below. Duplicating some tabs to put reports in like we do every time. Right clicking the tab up top to duplicate it. Right clicking the duplicated tab to duplicate it again. Back to the tab to the middle as the one to the right is thinking reports on the left hand side. We want to open up one of the favorites that being the balance sheet report of course. Let's tab to the right and then go to the reports again on the left and close and let's open the profit and loss the PNDL. Closing the hamburger changing the range from I'm going to start off from 010123 to 123123. Run it and then I'm going to tab to the left and close up the hamburger and change the range to the same 010123 to 123123 and run that. Now in prior presentations I'm going to go to the tab to the left. We've been working on the mileage tracking feature within QuickBooks and we've been entering data. We entered data for one month of basically miles and we talked about how we might use this data to do an adjusting entry so we can track our information for tax preparation using a mileage method and even enter an adjusting entry possibly into our QuickBooks system so we have a nice little reconciliation right there. So now I'm going to do the same kind of thing for the second month and see how we can basically sort our report that is here when we download the trips if we wanted to sort the reports in a bit more complicated situation where we had possibly multiple months and we want to break it out by month and then we have personal data as well as business data possibly tracking information not just for the miles here but possibly for a charitable deduction that might be helpful for taxes or for medical type of expenses that might be possible for taxes as well. So the main reports that we have is they give you this little summary page up top but the other reports isn't in the reports area it's just going to be this export to a CSV file which you can then convert to an Excel file if you have a more complex type of report that you're going to be dealing with so we'll play with that for a while. Now if I go to the tab to the to the right last time we imagined that we stopped and we entered an adjusting entry at the end of May so let's make this the cutoff then as of 053123 and let's adjust it here we turned on the classes to do that and run this and then we had this nice little breakout using our classes so that we can have our totals not really messed up but then have an adjusting entry to adjust for the fact that we're not using the actual method but the mileage method for our column here that's basically on a tax method and this is kind of like our adjusting entry column over here. All right now let's imagine we do some data input for the next month in June so we have some data that we can export so let's say we're adding our trips which we can do with the mobile app so as you have the mobile app if it's just tracking your miles as it's pulling into the information down here it might be unreviewed or you might have automatically categorized it between the business personal and so on that pulls in or you can use the manual tracking up top we'll enter in manual here so I'm going to go up top and I'm going to say add a trip and then I'm going to say this is happening in June now so we're in June and let's enter a couple of these some of the standard ones we have the office to our client so we go from office to client number one and so there we have it and we have our round trip we'll keep it at the normal Toyota default and we're going to say that it's going to be a meeting that we're going to once again so we'll say save that and there's the calculation notice the calculations here are summing up for the entire year which is perfect for you know taxes but you might want more detail month by month if you're doing you know your information on a month by month breakout and you might want more detail on your personal side of things which could include the the medical and uh and uh say charitable I'm going to add this to the business side of things I'm going to add a meeting let's do another one let's say we have another one that happened once again in the following month let's say the second and let's say this one is going to be from our office once again this time to to client uh to I'm going to put on the round trip and we're going to say it's for a meeting once again boom so we've got that one I'm going to pull this one over to the to the business side of things and so there it is and so well I need a reason a meeting so now we've got this populating kind of automatically so then up top let's imagine we have some other kinds of trips so I'm going to say now that I want to put in my favorite locations and let's do another one another favorite location here it happens to be the 944 let's do so I'm putting in the 1013 North Roxbury Drive and I'm going to say this is going to be for charity let's say this is some kind of charity that I'm going to so I'm going to say that's going to be a charitable kind of item let's save that it wouldn't let me save it because it wasn't coming from google maps so I basically refreshed the screen so it was giving me this nice drop down and then I'm going to say it's charity one let's say so I'm going to say all right let's do that and then maybe if I was using my mileage tracking app I might make a rule for it so I might manage rules down here and say we're going to say this is a mileage rule and the starting point is going to be my office and then we're going to go to charity one and this is going to be on the personal side and we'll say Toyota that's could apply to pass trips no I'm just going to say boom and so hopefully that will pull over automatically when I make trips say with my mobile app to the personal side of things so I'm going to keep that and then if I add a trip and let's say this happened sometime in June let's say 5th and I'm going to say that this is going to be so notice when I manually input it here I still have to put in the points the points so I'm going to say it's from my office to the charity one but if I was using my app and driving around that's when it might automatically pull into this information here and possibly automatically assign it to the purpose which I said was personal now I'd like to put it over to personal and then give it another designation of charity or medical type of of transactions right so I could say it's a charity transaction round trip and then save it and so once again it didn't put the other side of the round trip in here but I'm going to save that on over to personal as well so on the personal side we have those in here so we've got these items on the personal side okay and then let's do another one I'm going to add a trip and we're going to say this one is going to be sometime in June and we'll say the 13th and we went from our office to the end point of the charity one again and let's say that this was personal and I'm going to say it was charity round trip boom and then let's add a medical one as well so let's say I'm going to add another one let's make a rule a mileage rule and I'm going to say another rule this one is going to be the starting point in my office and we're going to go this time to see if this drop-down thing works this time this is 2002 Loma Vista Loma Vista 29 20 30 million dollar place here personal Toyota round trip it so if I was using the app it should do that automatically I'm going to save it and there's another another item and then I'm going to but I'm going to add the trip manually here say this happened on the 15th of June we're going to say starting point office again ending point is going to be uh hold on I didn't the ending point is going to be let's just type it in again I'm going to say it's going to say 2002