Project Tracker Summary
Loading from Google Sheets…
Revenue vs Expenses
Monthly — 2026
Revenue
Expenses
Net Profit
Revenue Breakdown
By Stream
Expense Categories
Recent Transactions
| Date | Description | Category | Amount |
|---|
Profit & Loss Statement
RBL Productions — Full Year 2026
Cash Flow Waterfall
Cash Flow Statement
| Category | Q1 | Q2 | Q3 | Q4 | Annual |
|---|
Expense Trend
Expense Mix
Expense Detail
| Category | Jan | Feb | Mar | Apr | May | Jun | Total | vs Budget |
|---|
Quarterly Revenue & Profit
Quarter Comparison
Quarterly Breakdown
| Metric | Q1 | Q2 | Q3 | Q4 | FY Total |
|---|
3-Year Revenue Trend
YoY Growth
Annual Summary
| Metric | 2024 | 2025 | 2026 (YTD) | YoY Growth |
|---|
Budget vs Actual — 2026
Budget Variance Detail
| Category | Budget | Actual | Variance | % Used | Status |
|---|
All Projects
Click a project to view or edit full detail · Not synced
| Project | Date | Status | Income | Expenses | Net Profit | Margin |
|---|
Cover Page
Project Details
Pricing & Breakdown
Total: 0
Quote Summary
—
—
Date
—
Currency
—
Total Amount
0
0
Deliverables
0
Crew
0
Equipment
0
Line Items
Export
📄 Page 1 — Cover
📄 Page 2 — Project Details
📄 Page 3 — Quotation & Contact
📄 Page 4 — Breakdown
| Invoice # | Client | Project | Amount | Issue Date | Due Date | Status | Paid On |
|---|
Employee Roster
Payroll Ledger
Analytics
Loading…
| Name | Role | Type | Since | Base Salary / Rate | Project Wages YTD | Total Cost YTD | Status |
|---|
2026 Financial Forecast
Based on H1 actuals · Adjust assumptions to model H2
%
%
Revenue & Net Profit — Actuals vs Forecast
Revenue (Actual)
Revenue (Forecast)
Net Profit (Actual)
Net Profit (Forecast)
Month-by-Month Breakdown
| Month | Revenue | Expenses | Net Profit | Margin | Bank Balance | Type |
|---|
Client CRM
Auto-built from project history · Ranked by total revenue
Top Clients by Revenue
All Clients
| Client ↕ | Projects ↕ | Total Revenue ↕ | Total Expenses ↕ | Net Profit ↕ | Margin ↕ | Last Project ↕ | Status |
|---|
Tax Tracker
VAT liability, quarterly breakdown & payment log
VAT / Tax Configuration
% on revenue
% on net profit
—
Set aside from bank balance
Quarterly Tax Breakdown (2026)
| Quarter | Revenue | Net Profit | VAT Liability | Corp Tax Liability | Total Liability | Paid | Outstanding |
|---|
Tax Payment Log
| Date | Type | Quarter | Amount | Reference | Notes |
|---|
P&L by Category
Revenue, expenses & profit broken down by project category
Revenue by Category
Net Profit by Category
P&L Table by Category
| Category ↕ | Projects ↕ | Revenue ↕ | Expenses ↕ | Wages ↕ | Net Profit ↕ | Margin ↕ |
|---|
Journal Ledger
All double-entry journal lines — view, search and add entries
Journal Entries
| Date ↕ | Doc ID ↕ | Account | Debit ↕ | Credit ↕ | Description | |
|---|---|---|---|---|---|---|
| Totals | ||||||
Income Statement
Profit & loss derived from double-entry journal entries
Profit & Loss Statement
Balance Sheet
Assets, liabilities & equity from double-entry records
Assets
Liabilities
Equity