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
WACC Calculator
The free excel template help the user to calculates the weighted average cost of capital for the long-term funding used…
Business Review Meeting Excel Template
General overview The temple is a Business Review Meeting to be held monthly or quarterly. A business review meeting is…
Financial Analysis - 5 Years Plan & Valuation
General overview  The main idea of the model is to provide professional and successful financial presentation for the management showing…
Monthly Dynamic 3 Statements & Valuation
General Overview  The template contains the cash flow statement, the income statement, the balance sheet statement as well as ratios,…
Capital Budgeting Decision Model
General overview  The capital budgeting model is constructed to evaluate potential major projects or investments that would require capital budgeting…
Interest on Credit Sales Calculator
General overview   The template is constructed to calculate the credit sales for all industries but mainly used for cars,…
See All