Overview
The Budget Tool is the financial backbone of every project. It tracks all revenue, expenses, margins, and vendor payments. Every project uses the standard template — no custom formats. This guide walks through each tab and how to fill it out correctly.
Initial Setup
- Duplicate the 2026 Budget Tool Template into the project's Drive folder
- Fill in project metadata on the Summary tab: Client, Project Name, Client Lead
- Set the PROD/MEDIA/CONTENT/SERVICES sheet names in the Summary dropdown menus
- Set the Budget Manager name and Job Code in the production estimate tab header
Tab-by-Tab Guide
00 SUMMARY
This is the high-level financial dashboard. Do not manually edit formulas here — it pulls from the estimate tabs.
- Estimate Summary: Production, Media, Content, and Staffing estimates with target and forecasted margins
- Hours Estimate Summary: Estimated hours by role and department
- Key metrics to monitor: Production Services %, Total Fee %, Net Revenue %, Freelance Costs
- Use the dropdown menus at top-right to select which estimate sheets feed the summary
- "REFRESH LIST" button updates the data — use it after making changes to estimate tabs
1.0 PROD (Production Estimate)
The detailed production budget. This is where most of your time will be spent. Each line item uses a category code system:
| Code | Category | Examples |
|---|---|---|
| PA | Venue & Venue Logistics | Venue fees, power, security, permitting, safety equipment |
| PB | Design/Fabrication | Scenic build, graphics production, furniture, decor |
| PC | Creative Technology | Interactive installations, hardware, photo booths, websites |
| PD | Production Equipment | Lighting, audio, video screens, staging, truck rental |
| PE | Food & Beverage/Catering | F&B, catering staff, bar staff, branded disposables |
| PF | Talent | Host/emcee, DJ, headlining talent, influencers, H&MU |
| PG | Staffing | Individual employees (TD, PM, PAs) and third-party vendors (siteops, BAs) |
| PM | Logistics & Transport | Shipping, crating, storage, crew catering, travel (airfare, lodging, per diem) |
| PL | Programming & Promotional | Event credentials, programming supplies, giveaways, branded uniforms |
How to fill out each line:
- CATEGORY CODE: Use the assigned code (e.g., PA3)
- CATEGORY: The line item name (e.g., "Power")
- PRODUCTION DETAIL: Detailed description and assumptions (e.g., "Allocation for generator rental x 4 stops for outdoor portion")
- QTY: Number of units (e.g., 4 stops)
- DURATION (DAYS/HRS): Duration per unit
- RATE: Cost per unit per duration
- ESTIMATE: Auto-calculated (QTY x DURATION x RATE)
Rules:
- Only enter lines above the "ONLY ENTER LINES ABOVE THIS ROW" marker
- Use "TBD LINE ITEM - PRODUCER TO FILL OUT" rows for items you know you'll need but haven't priced yet
- The PRODUCTION DETAIL column should explain assumptions — not just name the item
- Category totals auto-calculate at the bottom of each section
1.1 EXP Tracking (Expense Tracking)
Internal worksheet for tracking actual expenses against the budget:
- DO NOT ADD ROWS ABOVE ROW 9 — this breaks formulas
- Select your budget sheet from the dropdown menu to link tracking to the correct estimate
- Complete data entry in columns A-E only: CATEGORY, DESCRIPTION, VENDOR, DATE, AMOUNT
- CATEG. SUB TOTAL column auto-calculates
- Use the ON/OFF COLOR WARNING checkbox to highlight overages
00 OVERAGES
Tracks budget overages with incremental rounds:
- Top section: TOTAL BUDGET LOG with versions (Scoped Budget, V1, V2, V3) and approval dates
- Detail sections: PRODUCTION EXPENSES, CONTENT EXPENSES, IN SERVICES — each broken into incremental rounds (RD1, RD2, RD3)
- Triple-check the subtotal after adding incrementals
- Check/update the total after adding any new incremental round
RECONCILIATION
Used at project closeout to compare estimated vs. actual:
- Columns: Category, Sub-Category, Estimated Budget, Actual Cost, Delta, % of Budget
- Organized by: Production Estimate, Media Estimate, Content Estimate, Staffing Estimate
- Fill in actual costs as invoices are processed
- Review with Finance before final closeout
RATE CARD
Reference tab — defines fee structures and mark-ups:
- IN Standard: 20% Agency Fee + IN Staffing
- IN Content Standard: Standard + 15% built-in mark-up on OOP content line items
- Media (20%): Reference IN's Media SOP for pricing models
- Payment types: ACH/Wire Transfer, IN Credit Card, Personal Reimbursement
- Custom fee structures require approval
INPUTS + LOOKUPS
Master reference tab for formulas. Generally do not edit unless you're setting up a new budget from scratch. Contains program dates, forecast settings, and formula references.
Margin Targets (Quick Reference)
- Production OOP Margin: 25% target
- Services Margin: 60-70% target
- Production Services %: ~12% of production estimate
- Total Fee %: ~23-25% of total estimate
- Net Revenue: ~23-25%
Common Mistakes
- Adding rows in restricted areas (breaks formulas)
- Leaving PRODUCTION DETAIL blank (makes the budget unreadable for anyone else)
- Not updating the expense tracking tab as invoices come in
- Forgetting to refresh the Summary tab after making changes
- Not flagging overages early — the Overages tab exists for a reason