Collaborate on Shopping Bill in Excel for Finance with Ease Using airSlate SignNow

Shopping bill in excel for Finance

in this video i'm going to share the exact details of how i create a grocery shopping budget to keep track of my grocery expenses using my special excel spreadsheet template right after this hey everyone i'm antoinette and welcome back to my channel at frog courage i like to make videos on travel food and lifestyle and if you saw my last video where i talked about how i paid off over 60 thousand dollars worth of student loans four years early i mentioned that one of the things i had to do was get control of my spending in particular i needed to get control of my grocery shopping budget you all know at frog encourage on this channel i love to cook delicious meals i have a whole playlist of delicious meals and i like to eat whenever i travel abroad or just in general so it was really hard for me to get control of my finances in that area it wasn't until i took dave ramsey's financial peace university that i fully understood the power of having a focused budget that you stick to prior to that i would just wander into the grocery store hungry and just pick up whatever i thought i wanted and whatever i thought i needed and then at the end of the month i would look at all of my bills and wonder why i was so broke and why i wasn't paying off debt sooner look that was because i was blowing all of my money at the grocery store so i decided to create a grocery shopping excel file to keep me focused in the grocery store as well as on track with my financial goals and for real for real i decided to share my grocery shopping excel spreadsheet with you all because somebody actually gave me a comment and said hey where can i get this excel spreadsheet and i never thought about sharing it before until that person actually commented so please continue to comment i love reading your comments and your suggestions so now let's go through the exact details of how i create a grocery shopping budget using my grocery shopping excel template the number one thing i do before anything is i check my finances i get paid on a bi-weekly basis so i go grocery shopping on a bi-weekly basis the first thing i do is calculate what i'm bringing in what i'm making for the month and all those bills i need to pay so i take an inventory of what's coming in and then what's going out i list all of my fixed expenses like our mortgage electricity bill gas all those things whatever i have left that's what i use to go grocery shopping with and you guys definitely want to stay tuned because in my next video i'm gonna give you the full monthly strategy and we're gonna break that down too so click that subscribe button that's in the bottom corner i believe it's bottom this bottom corner here that little icon that says fnc subscribe click that little button to subscribe and click the notification bell so you won't miss that video once i have all of my expenses listed down i then look to see how much money i have to spend on grocery shopping for the next two weeks so as you're looking to go grocery shopping the first thing you want to do is figure out how much money you have for groceries and you need to figure out are you going to go grocery shopping on a weekly basis a bi-weekly basis every three days whatever it is that's what your budget should be based on once i've determined how much my grocery budget is going to be i then navigate to my grocery budget and meal prep excel spreadsheet the bundle comes with two spreadsheets the first is this grocery budget and meal prep excel spreadsheet template for you to create multiple grocery budgets as you see fit the next is a sample file that i'll show you in a minute and that file is meant for you to play around with so let's keep moving so the next thing i do is enter my grocery budget in my excel spreadsheet let's just say my budget is 175 it automatically updates our left to spend categories and our actual and our planned budget expenses i can change the color by clicking this fill bucket and choosing whatever color i need to i can also change the currency by clicking in the cell and switching to whatever currency i want at the moment and you can also highlight cells e and f by holding the command key and changing the format to whatever currency you would like there are so many currencies available it really is a universal template so i'm going to switch this back to english and keep moving so after i've entered in my grocery shopping budget the next thing i do is go to my meal prep calendar this meal prep worksheet also known as a meal planning worksheet helps me figure out what i'm going to prepare all the days of the week for a particular month all i have to do is enter in the month in this cell right here let's just say this is for january and i enter in the days of the week where there are number signs so i can meal plan for one week i can meal plan for two weeks three weeks four weeks the entire month or even multiple months by just going back down to my meal prep tab right clicking selecting move or copy create a copy and okay i can double click on the tab to change the name to a new month and year i can then move the tab wherever i want in my spreadsheet and continue to meal plan i can enter in any breakfast lunch dinner snack or dessert by just typing in the cell this will help me to determine what grocery items i need and for further assistance you can click on the ingredients tab type in the dish as well as a list of ingredients and the time it takes to cook the time it takes to cook is a cell that you can control and that you can customize for whatever time lengths you desire once i have my calendar and my ingredients list sorted out that's when i go back to my grocery budget spreadsheet and start entering in items for instance if i would like to purchase eggs i type in the item the quantity categories are the locations in the grocery store so eggs are a dairy i can also customize this entire list of categories with whatever categories i want to as well as customize this list of stores by clicking on the customize tab and either replacing these existing stores or just adding my own store and my own category and when i go back to my grocery budget spreadsheet and click the drop down arrow scroll down and i can select my new categories it's 100 customizable after i've selected my category and store i'll then enter in the planned expense let's just say i think this is going to cost 1.99 and the note i just want one dozen large eggs you'll notice that for my planned expenses it automatically calculated for me and now my new left to spin total that i have for my planned expenses is 173 dollars and one cent i'll continue to enter in each of my items and the plan category will automatically populate and y'all i never go grocery shopping without first checking to see what i have so i am not buying stuff i don't need as i'm entering in information in my meal prep worksheet tab i know that i want primo wheat for breakfast so i'm gonna go in my cabinet and see do i have enough cream of wheat to last me for the two weeks that i need and judging by this yes i do and i can see that this is not going to expire i do the same thing for each croutons walnuts do i have enough garlic do i have enough pasta i'm looking through my cabinets to see if there's anything that i need that is going to be a part of my meal same thing with the soups any additional ingredients i need like sauces for marinades do i need seasonings what is it that i actually need to go grocery shopping for definitely check your cabinets in advance so that you're not paying for stuff that you already have and in addition to cabinets check your fridge and freezer too for anything that is expired anything that is no longer good and anything that you don't have that you need for the upcoming weeks and don't be surprised if you have to do a little digging and check your quantities so here we have a little bit of vegetables this may be something to add on my list if it's part of my meal prep here i may need to get an additional bag of mixed vegetables and it also helps if you just eat the stuff in your freezer before you go grocery shopping that can also save you money i know dave ramsey recommends this before you go grocery shopping try eating everything in your fridge and freezer first you can see that i just went grocery shopping today so we have a full house here i do not need to go for another two weeks at least then we can go back through our grocery budget spreadsheet and eliminate things off this list you'll get to the point to where you'll just take your phone or your tablet or even your computer come to the kitchen and just start typing things automatically because you'll know instantly what you need to buy so what does this actually look like filled out i will show you here is a sample grocery shopping spreadsheet already filled out you can zoom by clicking the zoom buttons on the bottom right corner or you can zoom out as you can see here i've pre-populated some items their quantities and selected the category store and the planned expenses if i want to add a new item i'll just scroll down to the bottom of the sheet and enter my new item here and let's just say i want to those new items and they are baking and i want to pick them up at harris teeter and these two new items if i want to enter in the individual price for two items i will select the cell go up to the formula bar hit equal sign select the quantity for that item hit the asterisk key which is shift 8 to multiply the quantity times the anticipated price and there we have it and i can continue to enter in new items here if i get to the bottom of my list you'll see this little corner arrow down here all i have to do is select that and hit tab to create a new row if for some reason i overspend in a category my left to spend planned section turns red so that lets me know i need to make an adjustment somewhere in this spreadsheet so that i don't go over when you're in the grocery store you'll enter in the actual expenses for each item this spreadsheet is compatible with pcs and mac products so you can use this with google sheets you can use this with numbers it is created in microsoft excel it is very compatible so as i'm in the grocery store i will enter in every expense whether it's over or under and our totals calculate in our actual column if we go to our sample meal prep calendar we can see all of our meal planning for a month's end with anything that i don't plan on eating marked as not applicable it's beautiful because i can stop on january week four see the days of the week and see exactly what i'm going to eat for that time period or leave it blank if i so choose if i go to the sample ingredients list i can filter by just clicking this filter button in the data tab and you'll notice these little drop down arrows appear if i wanted to find anything to add to my meal planning calendar that's between 5 and 10 minutes i can just select the 5 and 10 minutes boxes and it automatically filters for me i can clear the filter to see my entire list or i can go back to the ingredient section and search for anything such as lettuce to see all of my dishes that require lettuce it is truly phenomenal and while i'm grocery shopping because this is an excel spreadsheet i have excel downloaded on my phone i save my spreadsheet to the cloud so that i can make updates to it on my computer as well as on my phone and if you guys have google sheets or numbers and sync your devices you can do this too so as i'm actually going to the grocery store if i go back up to my data tab and select filter i can filter through all of the expenses that i have planned by unchecking the blanks folder this only shows me those expenses that i have planned if i want to see the entire list i'll just uncheck this blank section here not only can i filter out items based on whether i've planned for them or not i can also go to the store and while i'm shopping at say aldi i can only see the items i need to pick up at aldi furthermore if i go to my category i can filter out by category or i can sort it in alphabetical order so that as i'm going to the grocery store if i'm in the dairy section i'll see only the dairy items at aldi that i have planned for after i pick up the dairy item i can then go to the meat section and pick up everything i need to get in that meat section this is how i stayed laser focused in the grocery store and on track as i entered in my actual expenses so i did not go over my overall grocery budget whenever i left the store i'd go back to the filter button and i'd clear it so i can see everything i need or i can refilter it based off of the next door i went to and i went on and on until i went through every store and purchase everything i need in the planned expenses and typed in my actual expenses to see how much money i had left to spend in the overall categories the grocery budget tracker excel spreadsheet is also printable so if you would like to print let me just set you guys down right here here we go you're all set so if you want to print any of the sheets you can do so just by going to file print make sure your printer settings have it fitting to the page and not blown up to any other page size it is really a dynamic sheet and you can copy the template over and over and over again so you can use multiple times so if there's the month of january where you really liked how you meal prepped for january copy the january sheet over to february or if it's november and you're looking to host thanksgiving then create a separate thanksgiving sheet it's something that you can reuse year after year you can take it with you on your phones and your tablets it is truly a lifesaver for me so i'm really glad that one of you suggested that i share this spreadsheet with you i'm so excited for you guys and the financial journeys that you're taking y'all this is going to be such an incredible moment in your financial journey like the moment you feel you have it together and you're walking through that grocery store like i felt when i got my finance together like you couldn't tell me nothing i was sorting things i was focused i was in and out in like 10 15 minutes i kid you not so yeah if you guys follow so far give this video a thumbs up you can truly make this spreadsheet your own which is why i'm so excited for it again the link is in the description box down below it's really super cheap to buy very inexpensive but a small purchase that will save you so much time and money in the future is totally totally worth it