Profit and Loss (P&L)
Part 1: Building a P&L Model
The Profit & Loss statement (also called the Income Statement) is the core of most financial models. It tracks revenue, expenses, and profitability over time, forming the foundation for operational planning and forecasting.
What Is the P&L Used For?
The P&L helps you answer questions like:
How much are we making and spending each month?
Are we profitable—or when will we be?
How do our margins change as we scale?
It’s a forward-looking planning tool, but also a performance dashboard. When combined with real accounting data, the P&L becomes a powerful report for Budget vs. Actual (BvA) analysis, board reporting, and decision-making.
Actuals vs. Forecasted P&L
In Pluvo, your P&L model includes both actuals (historical data) and forecasts (forward-looking projections). Each variable has two sides: one for actuals, and one for forecasts—kept together in the same row so you can track performance over time in one place.
Setting Up a P&L in Pluvo
Step 1: Create a New Model
In the sidebar, click + New Model
Name it something like
P&L
orIncome Statement
(Optional) Place it in a folder (e.g. “Core Statements”)
You’ll now see a blank grid.

Step 2: Add Core Variables
Click + Add Variable and create key rows such as:
Revenue
Cost of Goods Sold (COGS)
Gross Profit
Operating Expenses
Salaries
Marketing
Software
Other Expenses (Interest, Taxes, etc.)
Operating Income
Net Income (after interest, taxes, etc., depending on how detailed you need)

Step 3: Add Detail
You can break down any variable into sub-variables for more granularity. For example:
Revenue
Sales
Services
Salaries
Engineering
Sales
Customer Support

Simply drag variables into folders or nest them under a parent variable to build this structure. You can create as many levels as needed (even sub-sub-sub-sub-sub variables).
Most detailed P&Ls mirror the structure of your chart of accounts, but you might also want to analyze by:
Department
Region
Vendor
Customer type
Step 4: Define Actuals
Each variable in Pluvo supports its own actuals definition. This tells Pluvo where to pull real data from.
For your P&L, you’ll typically map actuals using your accounting software:
Click into the actuals definition for a variable
Select the GL accounts to pull in (e.g. all income accounts for Revenue)
Repeat for each line item (e.g. map
Payroll Expenses
to Salaries)
Note that not all variable actuals should be pulled from GLs. Some should be calcluated from other variables. These are generally what are considered the model "outputs". In this case the rows that need to be calculated are:
Gross Profit
(revenue - COGS)
Operating Income (
Gross Profit - Operating Expenses)
Net Income
(Operating Expenses - Other Expenses)
Once this is set up, your P&L will update with the latest accounting data each time you click Sync on your integration. No more manual exports or spreadsheet copy-pasting.

Step 5: Define Forecasts
With actuals flowing in, you can now set up forecasts for each variable.
Click into the forecast definition column
Add a static value, manual entry per month, or a dynamic formula
e.g.
=headcount * average_salary
or
=revenue * 0.35
for a gross margin assumptionIn this example, we will be using using an average of the last 3 months, multiplied by a 5% growth rate every month for revenue and COGS accounts.

Forecasts can reference other variables, dimensions, models, and even entire folders. You’ll use these to model growth, spending, and strategy over time.
Step 6: Review & Iterate
Use sparklines to quickly visualize each row’s trend
Toggle columns in the toolbar to focus on actuals, forecasts, or formulas
Add scenarios to test different versions of your P&L (e.g. conservative, base, aggressive)
Next up: the Balance Sheet.
Last updated
Was this helpful?