A P&L model serves as the basis for your financial reporting and forecasting needs. This guide explains how to build a customizable P&L off of your General Ledger data
+
next to any item in the sidebar
Level 1: Income Statement by Vendor
edit
In the database configuration menu and choose the following inputs:
IS Data
transaction date
for datesVendor
Class
GL Account Name
Parent Account
Account Type
GL Account Names
with a Reporting Category
dimension.
Add a lookup column in the Level 1: Income Statement by Vendor
database
Reporting Category
from **Lookup Table **using GL Account Name
Reporting Category
items populate the lookup column.Value is Autofilled
or if you click into the Dimension name column header and the menu says Edit Lookup+
next to any item in the sidebar
GL Account Name
and Class
Parent Account
or Account Type
again, as well as the Reporting Category
lookup columnGL Account Name
Parent Account
or Account Type
and Reporting Category
Level 4: Reporting Category
and Level 5: Account Type
Your final database will be home to your top-level drivers by Account Type which are the aggregation of all underlying databases. Usually these are Revenue, Other Revenue, COGS, Expense and Other Expense
It’s helpful to organize the sidebar using Sections for Income Statement Data and nest the databases to visually remind yourself of their hierarchy