Overview

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
12
0
General overview   Running a successful construction business isn’t easy. There are so many risks and challenges in the industry…
Financial Reporting Checklist
1,052
103
The checklist is a great tool to assist in ensuring compliance with all relevant requirements
Cash Flow Projection for Project Contracting
1,070
0
General overview   The importance of steady fund income is crucial in construction projects. Cash flow can procure material, pay…
Cash Flow Projection for FMCG
1,358
2
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
1,361
2
General overview   For construction companies that perform contact work, the work in progress (WIP) is an essential financial tool…
NPV, IRR & Payback Calculator
1,609
232
General overview   The template is constructed to evaluate potential major projects or investments that would require capital budgeting before…
See All