Upcoming webinar: How to make your Power BI reports run up to 10x faster

September 8th

Zebra BI Live Product Demo: Start creating truly insightful Power BI reports and dashboards

February 22nd

Back to Templates for Excel

Last update: September 25, 2023

Income Statement in Excel (PY-AC) and (AC-PL)

A profit & loss statement template that enables you to compare your actual values with the ones from the previous year.

0

409

Income statement template Excel - with comparisons to previous year or plan - AC PY and AC PL

Overview

This Excel template allows you to visualize your profit & loss data and compare your actual values with previous year's, using vertical waterfall charts (with features such as formula manager and custom calculations). It also displays absolute and relative variances that are calculated automatically.

Features used

Present your finances in the form of an actionable story. Enjoy the preview of how Zebra BI for Office turns your data into concise and compelling insights.

Download this template

More professionally-designed templates to use

Intermediate

Cost Analysis and Reporting Excel Template

EBITDA Split by Location Analysis Excel Template

Hospital Occupancy Rates Excel Template

Hospital Monthly Closing P&L Excel Template

Contribution Margin Analysis Excel Template

Gross Sales vs Net Sales Excel Report Template

Basic

Financial Forecasting and Planning: Profit & Loss Overview Excel Template

Adjusted EBITDA template and adjusted income statement example created with Zebra BI for Excel

Basic

Adjusted EBITDA Template & Adjusted Income Statement Example for Excel

Basic

Long-Term Assets and CapEx Report Excel Template

Basic

Cash Flow Statement from Pivot Table (Hierarchical)

Intermediate

Break-Even Analysis Template for Excel

Intermediate

Working Capital Analysis Template in Excel

Intermediate

Sales variance analysis report templates for Excel

income statement template excel afi

Intermediate

Basic

Income statement templates for Excel

Advanced

Consolidated financials dashboard in Excel

Intermediate

Sales variance report with multiple levels

Intermediate

Sales overview report in Excel

Advanced

Sales dashboard in Excel

Intermediate

Revenue-cost-profit analysis

Intermediate

Inventory report

Intermediate

Quarterly income statement

Basic

Income statement with multiple levels

Basic

Balance sheet template for Excel

Basic

Subscription business model analysis in Excel

Basic

Marketing budget variance analysis in Excel

Basic

Income statement (bridge chart) in Excel

Intermediate

Price-Volume-Mix variance analysis in Excel

Basic

EBIT contribution analysis in Excel

Basic

Cash Flow Statement template

Basic

Income statement in Excel (PY-AC-PL-FC)

Basic

Income statement in Excel (PY-AC-PL)

Basic

Income Statement in Excel (PY-AC) and (AC-PL)

Basic

Cost Variance Table in Excel (PY-AC-FC-PL)

Basic

Cost Variance Table in Excel (PY-AC-PL)

Basic

Cost Variance Table in Excel (PY-AC and AC-PL)

Intermediate

Monthly Sales Variances in Excel (PY-AC-FC-PL)

Intermediate

Monthly Sales Variances in Excel (AC-FC-PL)

Intermediate

Monthly Sales Variances in Excel (AC-PY-PL)

Intermediate

Monthly Sales Variances in Excel (PY-AC and AC-PL)

Basic

Sales Variance Table in Excel (PY-AC-FC-PL)

Basic

Sales Variance Table in Excel (PY-AC-PL)

Basic

Sales variance table in Excel (PY vs. AC and AC vs. PL)