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

Zebra BI for Excel
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.

Get started in 3 steps

1
Download & Open
Download the .xls file and open it in Excel
2
Connect Your Data
Replace sample data with your CRM, ERP, or database source
3
Customize & Publish
Adjust KPIs, colors, and branding, then publish to Power BI Service

Fill out the form and get the Excel template

20,000+ users have downloaded this template

Now that you have it, here's what's next

1

Open in Excel

Download the .xls file and open it in Excel. Replace sample data with your own.
Open in Excel
2

Start your free trial

Don't have Zebra BI yet? Start a 14-day free trial to use all advanced visuals and features.
Start free trial
3

Follow the Tutorial

Don't have Zebra BI yet? Start a 14-day free trial to use all advanced visuals and features.
Watch Tutorial
© 2021 – 2026 Copyright Zebra BI d.d. All rights reserved. Various trademarks held by their respective owners.
cross