This model is profit and loss statement for general trading including comparison for the current month, year to date, and full-year by choosing the selection boxes in P&L Trend sheet below column O to identify the fiscal year and the current month.
All the data should be entered in the green cells only to dynamically flow into P&L Trend and P&L comparison sheet.
The template is very useful tool for financials, business owners, CEO, also it is useful for
small, medium and large enterprises,
After you fill the green cells you will get the following below:
-Income statement by month
-Actual vs Budget for the current month
-Actual vs LYSP (Last year same period) for the current month
-Actual vs Budget YTD
-Actual vs LYSP YTD
-Actual vs Budget FY (Full year)
-Actual vs LYSP (Last year same period) for the full year
-Income statement for the current year and last year
You can find the full instruction in the instruction sheet.
Conclusion and customization
This is a highly versatile, very sophisticated financial model template, and is also user-friendly.