Thank you! That’s a great suggestion, thank you. I’ll add it to my list to make. If you haven’t already, you may want to subscribe/turn on bell notification so you don’t miss it :).
@@gaty79co Thanks for the feedback! stay tuned... hoping to do another P&L video that shows quarterly and annual summaries/rollups as well soon. If you haven't already, you may want to subscribe and hit notification icon so you don't miss it. Should be by the end of the year.
I love this is there a way to have dynamic services that autofill based on the tables of revenue and expenses. I think right now you have to manually enter them?
Thank you! Just to clarify, you are wondering if there is a way to have expenses and revenue automatically filled, right? If so, there are ways to significantly reduce the manual entry required. We have set up automation for importing csv files outputted from financial institutions as well as more advanced automation using Zapier and/or api calls.
Thank you and great question! By watching this video 😁: Excel Profit & Loss Tutorial: Add automated monthly and quarterly summaries ua-cam.com/video/ZR4T5ui9bow/v-deo.html
@@CustomExcelSpreadsheets Thank you! I found that AFTER I asked, my apologies. I did attempt to find the link to the completed spreadsheet and wasn't able to figure out how to get to it though. Forgive me, I am looking for this spreadsheet to help with my small business portion of taxes (FY2023) and the deadline is fast approaching so I'm pressed for time and kinda freaking out. LOL
Hey! That’s my fault actually- been so busy I haven’t had a chance to fix this missing link yet. Send me an email and I’ll shoot the excel file to you first thing tomorrow morning! Email: colton@customexcelspreadsheets.com
Thanks for the feedback! Here’s a tip that might help: On UA-cam you can change the playback speed to slow it down so it’s easier for you to follow along.
This was really helpful. Im just having trouble saving all the sheets.
Thank you! This helped me alot I very much appreciate this video!
You’re welcome! Thanks for the positive feedback and I’m glad it was helpful!
Thanks for the information you provided in this video.
You’re welcome! I’ll be putting out a lot more helpful Excel videos geared towards business applications in 2024 :).
I love the illustration
Thanks, Anne!
Thank you for this video! I found it super helpful. Could you provide some tips or a video on how to sort the p&l by quarter or year?
Thank you! That’s a great suggestion, thank you. I’ll add it to my list to make. If you haven’t already, you may want to subscribe/turn on bell notification so you don’t miss it :).
I also want to know this
@@gaty79co Thanks for the feedback! stay tuned... hoping to do another P&L video that shows quarterly and annual summaries/rollups as well soon. If you haven't already, you may want to subscribe and hit notification icon so you don't miss it. Should be by the end of the year.
Thank you!!! Very helpful!
You’re welcome! Thanks for the feedback, Reece
Super helpful! Thank you
Glad it was helpful!
Thank you so much!
You’re welcome! Glad it was helpful. Let me know if there are any other videos you’d be interested in and they just might make it onto my queue!
I love this is there a way to have dynamic services that autofill based on the tables of revenue and expenses. I think right now you have to manually enter them?
Thank you! Just to clarify, you are wondering if there is a way to have expenses and revenue automatically filled, right?
If so, there are ways to significantly reduce the manual entry required. We have set up automation for importing csv files outputted from financial institutions as well as more advanced automation using Zapier and/or api calls.
Thank you so much.
You're welcome, Stuart! Glad it was helpful.
Thanks a lot for sharing!
You’re welcome, Tammy! Thanks for watching.
Thank you❤
You're welcome 😊!
Super Helpful but...question, how do you make the profit and loss by month?
Thank you and great question! By watching this video 😁:
Excel Profit & Loss Tutorial: Add automated monthly and quarterly summaries
ua-cam.com/video/ZR4T5ui9bow/v-deo.html
@@CustomExcelSpreadsheets Thank you! I found that AFTER I asked, my apologies. I did attempt to find the link to the completed spreadsheet and wasn't able to figure out how to get to it though. Forgive me, I am looking for this spreadsheet to help with my small business portion of taxes (FY2023) and the deadline is fast approaching so I'm pressed for time and kinda freaking out. LOL
Hey! That’s my fault actually- been so busy I haven’t had a chance to fix this missing link yet. Send me an email and I’ll shoot the excel file to you first thing tomorrow morning! Email: colton@customexcelspreadsheets.com
@@CustomExcelSpreadsheets Will do now. :)
good job sorry you can make me budget of computer shopping
You explained the video too fast
Thanks for the feedback! Here’s a tip that might help: On UA-cam you can change the playback speed to slow it down so it’s easier for you to follow along.