Next step
P&L drilldown
cost line by line
Receivables
money owed in
Vendor bills
money owed out
GST
tax netted both sides
Project finance
Budget, spend, billing, and P&L reconciliation.
How to read this
Money in = what clients owe/paid: invoiced, less applied credits/advances, equals AR outstanding.
Money out = your cost (labor from approved hours + render + expenses + received POs) and what you owe vendors (AP).
Margin = revenue minus actual cost. Every number here is the same source the P&L, receivables, and payables pages read, so they all reconcile.
Reconciles with studio P&L
Budget
INR 3,000
Revenue
INR 45,000
Actual cost
INR 272,650
Margin
INR -227,650 (-506%)
Burn
9088%
PO encumbrance & GST
Committed POs
INR 744,633
INR 744,633
Received POs (in actual)
INR 0
INR 0
GST output (invoices)
INR 0
INR 0
Input tax (vendor bills)
INR 3,240
INR 3,240
Net tax position
INR -3,240
INR -3,240
Budget used (actual + committed POs)
33909%
Money in (receivables)
| Invoiced (sent/paid) | INR 50,000 |
| - Credit notes applied | - INR 5,000 |
| Paid | INR 0 |
| AR outstanding | INR 45,000 |
Money out (cost & payables)
| Committed (open POs) | INR 744,633 |
| Actual cost (labor+render+exp+recv PO) | INR 272,650 |
| AP paid (vendor bills) | INR 0 |
| AP outstanding | INR 21,240 |
Cost breakdown
Labor: INR 256,000
Expenses: INR 16,650
Render: INR 0
Received POs: INR 0
Remaining: INR -269,650
Expenses: INR 16,650
Render: INR 0
Received POs: INR 0
Remaining: INR -269,650
Sources
Budget from approved bid
Bid versions
Purchase orders (4)
Invoices (2)
Vendor bills (AP) · Credits & advances
Bid versions
Purchase orders (4)
Invoices (2)
Vendor bills (AP) · Credits & advances