Streamline Your Logistics with the Excel Bill Tracker for Logistics

Excel bill tracker for Logistics

hey there it's Aaron with time-saving templates and real quick I want to show you one of my most versatile templates and that is the business expenses tracking template it can be used for any expense category you want so you could delete all of these if you wanted in AB new categories or you could add additional categories below and once you add something here in this column a it will automatically link into the drop down list so I filled in a few examples for you to tell how it works and there's also a summary page that will show the expenses by venue and by category all that you have to do is click on the data refresh all anytime you add new information click yes and then it will populate the summary of the total paid per venue and category the monthly expenses will automatically pull in you don't have to refresh those so let me just run through one more example just so you can see let's say supplies for $100 and okay so I don't have say I think of something and I don't have a category for it come here and we'll put jewelry supplies and then it will appear in the categories and bottom the date what store as you add more this'll total so if we spend some more on office supplies you can also start typing it in and it will automatically populate it's just if you type in something that doesn't match in the drop-down list you'll get a message that it's not the list yet and you need to enter it in column a first cancel out of there so say we buy 50 more office supplies a bullet but we'll just continue to add everything a per category as you can keep scrolling down as much as you need to add so there you go then you just come back here and refresh it anytime you need to add something new so hope that helps and again it's Aaron at time-saving templates thanks