By popular demand, here is a copy of my Profit and Loss Statement spreadsheet that I use at my offices. I track my income and expenses very diligently and this has made applying for programs such as PPP loans and COVID relief grants easier since I can compare changes in revenue year by year. In addition, tax preparation time is much quicker as I am able to easily reference income and expenses with quickbooks as well.
We advise to keep track of what goes in and out of your business monthly and pay attention to key metrics, including:
- Average % monthly income
- your monthly cash flow
I have done this since opening my first office in 2015 and I have now been able to look back and easily see the growth of each office. In addition, by knowing my expenses, I am able to increase my earnings by reducing unnecessary expenses. Lastly, I like to see a prediction of my yearly income by seeing the trend in my monthly cash flow, so quarterly tax payment estimation is more accurate.
I love seeing my businesses grow and being able to see the growth based on numbers in an organized format. This allows me to set clear goals on what I want to achieve the following year. I hope this will help you keep track of your metrics and allow you to stay focused and meet/exceed your business financial goals.
See below for a downloadable link to the Google sheet template for your reference.