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 in the green cells only to dynamically flow into P&L Trend and P&L comparison sheet

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 current year and last year

You can find the full instruction in the instruction sheet

Please message me for any inquiry

Reviews Add a review
No reviews yet

More From ECF Consultancy

Browse our top rated business templates. See All
Startup Business Plan - Coffee Shop
General overview It is not secret that starting any business plan from scratch is not easy. If you dream of…
Financial Reporting Checklist Excel Template
 Looking for a working checklist that you can use as a template when conducting a financial report? If you are,…
Balance Confirmation
 Download balance confirmation letter 
Executive Financial Summary Excel with Power Point Template
 Overview The template provides a short financial description of the business that allow the reader to understand the highlights of…
Payback Period
 What is payback period? The payback period helps to determine the length of time required to recover the initial cash…
Authority Matrix Excel Template
 Authorities and Responsibilities Matrices   Authorities and Responsibilities Matrices are considered important to organizations due to their role in identifying…
See All