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 eCorporateFinance

Browse our top rated business templates. See All
Dynamic Profit & Loss Comparison
General overview   This is most important tool to understand and identify the variance.   It will help the business…
Monthly Financial Model
The template has been constructed for monthly financial reporting for general trading industry, It is incredibly simple to use that…
Startup Business Plan for General Trading with Scenario Analysis
This model is startup business plan for general trading. It is very practical model to measure the financial performance over…
Startup Business Plan
This model has been constructed for startup business plan to support general trading. This model is very simple to use…
Heavy Machinery Trading Startup Business Plan
This model is startup business plan for heavy machinery trading to support 3 main industries, construction, mining and agricultural. It…
Cash Flow Projection for Rental Heavy Machinery - Excel Template
Rental machinery business is very critical business therefore the cash flow projection is necessary to keep your business moving This…
See All