Arrow left
Back to templates
Excel Logo
Google Sheets Logo

P&L by Class Template for Google Sheets & Excel

Use this free P&L by Class template to slice and dice your Profit & Loss by department, location, vendor, venues, and any other way you divide your business units.

Get the template for free

No email address required. Download for free.

P&L by Class Template for Google Sheets & Excel

Learn how to create a live P&L by Class

Get started in 4 quick steps

1. In the P&L by Class tab, you will find a P&L aggregating the numbers from theEngineering P&L and Marketing P&L.

2. The Engineering P&L and Marketing P&L are two separate Classes which are pulling real-time data from QuickBooks using LiveFlow.

3. In order to set up your own Classes the same way, install LiveFlow's Google Sheet Add-On.

4. Copy/paste the formulas inside P&L by Class to automate your data flow. Need help with formulas? Book a call below.

How do I get this template?

2 minutes and you'll be up and running!

Templates
STEP 1
Check mark
line

open the template below

Click the "Get the template for free" button to open the template in Google Sheets

STEP 2
Check mark
line

MAKE A COPY

Click on File -> Make a copy to make your own copy of the Google Sheet template

STEP 3
Check mark

save it yo your drive

Save the copied file to your own Google drive and you are ready to go!

Get the template for free

Wasting time on manually importing data?

Join hundreds of accountants and finance teams automating their workflows with LiveFlow and saving hours of work every week

Check out LiveFlow

FAQ’S
Frequently Asked Questions
Is the template free?
FAQ ICON
Who built this template?
FAQ ICON
Can I share this template?
FAQ ICON
Can I get help if I need it?
FAQ ICON