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 Construction Business Plan
General overview   Running a successful construction business isn’t easy. There are so many risks and challenges in the industry…
Financial Reporting Checklist
The checklist is a great tool to assist in ensuring compliance with all relevant requirements
Cash Flow Projection for Project Contracting
General overview   The importance of steady fund income is crucial in construction projects. Cash flow can procure material, pay…
Cash Flow Projection for FMCG
General overview   Certainly, as confidence in the economy struggles to catch-up to growth, many healthy firms can end up…
Construction Work in Progress Calculator
General overview   For construction companies that perform contact work, the work in progress (WIP) is an essential financial tool…
NPV, IRR & Payback Calculator
General overview   The template is constructed to evaluate potential major projects or investments that would require capital budgeting before…
See All