The P&L (Profit & Loss) module tracks your department’s operational budget — planned vs. actual spending, organized by account and month.
What You Can Do
- Enter monthly budget figures for each account
- Record actual spending each month
- Compare budget vs. actual side by side
- View the full year summary in one table
- Export P&L data to Excel
How It Works
P&L is organized by accounts (chart of accounts for your department). For each account, you enter two types of figures each month:
| Type | Meaning |
|---|---|
| Budget | Planned spending for that account and month |
| Actual | What was actually spent |
The system calculates the variance (budget minus actual) automatically.
📸 [Screenshot: P&L monthly table — budget vs. actual columns]
Navigating the P&L Table
- Go to P&L in the left sidebar.
- Use the Year selector to switch between years.
- The table shows all accounts as rows, with months as columns.
- Toggle between Monthly view and Full Year summary.
📸 [Screenshot: P&L full year view]
Entering Budget Figures
- Click the cell for the account and month you want to enter.
- Select Budget from the type toggle.
- Type the amount and press Enter or click away.
- The cell saves immediately.
Budget figures are typically entered at the start of each year or quarter.
Recording Actual Spending
- Click the cell for the account and month.
- Select Actual from the type toggle.
- Enter the amount spent and press Enter.
Account Line Items
For accounts marked as Others, you can break down the total into individual line items (sub-entries with vendor names or descriptions).
- Click the Others cell.
- Click + Add Line Item.
- Enter the description and amount.
- Add as many line items as needed — they sum automatically.
📸 [Screenshot: Others breakdown with line items]
Export to Excel
- Click Export.
- Choose the year and data type (Budget, Actual, or Both).
- The file downloads with the full P&L table.
Permissions
| Permission | Description | Manager | Supervisor | Staff |
|---|---|---|---|---|
| view | See the P&L page | ✅ | ✅ | ❌ |
| create | Enter budget and actual figures | ✅ | ✅ | ❌ |
| edit | Modify existing entries | ✅ | ✅ | ❌ |
| delete | Remove entries | ✅ | ❌ | ❌ |
| export | Export P&L to Excel | ✅ | ✅ | ❌ |
| manage | Configure accounts and chart of accounts | ✅ | ❌ | ❌ |
Next Steps
→ [CAPEX]
→ [Projects]