If you're producing an independent film or documentary, your executive producers eventually ask for a cost report — a single document showing how the project's budget was actually spent. For productions with deferred crew payments, this report is the artifact that justifies paying out those deferrals when revenue arrives. ExpenseBot's Production Cost Report generates this from your existing receipts.
What the report includes
| Section | Content |
|---|---|
| Title block | Production name, date range, total cost, prepared date |
| Executive Summary | Above the Line / Production / Post / Other totals + % of budget |
| Year-by-Year Spend | One row per calendar year (essential for multi-year productions) |
| Top Vendors | Top 15 vendors by total spend — Red Digital Cinema, B&H Photo, etc. |
| Refund Pairs Detected | Auto-found purchase/refund pairs (cancelled flights, returned equipment) — review before signing |
| Drift Audit | Personal-tagged rows excluded + unclassified rows flagged for review |
| Driver Declaration | Producer name + signature line + country-specific certification language |
The four AICP phases
The report groups every receipt into the standard AICP topsheet structure that executive producers expect:
Above the Line (ATL) — Creative team negotiated before budget lock: producer fees, director fees, principal cast, story / script rights.
Production (Below the Line) — Crew + gear during principal photography: camera, sound, lighting/grip, art dept, wardrobe/HMU, locations, travel & living, transportation, catering, equipment rental & purchase, expendables.
Post-Production — Finishing work: editorial, sound mix / ADR / foley, music & licensing, VFX, color / DI, archive footage.
Other — Production overhead: E&O insurance, legal, publicity, festival submissions, deliverables.
Documentary-specific categories
When you enable Documentary mode, the report adds four documentary-only buckets:
- Subject Releases — payments to film subjects + location release fees
- Archive Licensing — archival footage + photo licensing (Getty, Shutterstock, AP Archive, network desks)
- Translation — translation + transcription of foreign-language interviews (Rev, GoTranscript)
- Research — research, scouting, development phase, expert consultations
How the bucketing works
The report uses a hybrid approach:
Path A (preferred): if your receipts already carry the Film – ATL / Film – Production / Film – Post / Film – Other tags from the Filmmaker tag bundle, the report buckets them by tag directly.
Path B (automatic fallback): for receipts in your project date range that aren't filmmaker-tagged, the report uses a category-string heuristic to map common categories into AICP buckets:
Equipment,Travel,Meals,Locations,Catering,Transportation→ ProductionSoftware,Music Licensing,Editorial→ PostInsurance,Legal,Marketing,Festivals→ OtherContractor,Payroll,Professional Fees→ ATL
Anything that doesn't match a known category lands in the Drift Audit section — review and re-tag in your main spreadsheet, then re-run the report.
Refund pair detection
Two rows for the same merchant within 14 days with opposite-sign amounts (+$X purchase, -$X refund) are flagged as a likely cancellation pair. Common examples:
- Flight booked then cancelled in 24-hour window, rebooked same trip → 1 cancellation pair per re-booking
- Camera body purchased then returned within store policy → 1 pair
- Equipment rental cancelled and refunded → 1 pair
The report lists every detected pair in its own section so you can review and confirm before signing. It does not auto-delete — you decide whether to remove both rows from the spreadsheet or tag one as "Cancelled — refunded" to preserve the audit trail.
How to generate the report
- Open My Reports → Summaries → Production Cost Report (visible if
roles.filmmakeris active on your account) - Enter your production name (e.g. "NUNS vs. the VATICAN"), date range, and pick documentary / narrative / commercial
- Click Preview — see total spend + phase split + refund-pair count + unclassified rows before generating
- Click Generate report — opens the polished spreadsheet in a new tab
- File → Download → PDF for a printable copy
- Sign & date the declaration row at the bottom
- Keep the signed copy with your production records and hand to your executive producers
Deferred payment justification
For indie productions where crew agreed to deferred compensation (taking lower upfront pay in exchange for a percentage of net revenue), this cost report is the document that proves the budget went to production rather than producer pocket. Executive producers approving deferral payouts will look at:
- Total production cost vs. budget claimed
- Phase breakdown (no surprises in "Other" or unexplained spend categories)
- Top vendors (relationships make sense for the production's scope)
- Year-by-year spend (matches the production calendar you reported)
- Refund-pair audit (proves you didn't double-count cancelled items)
Why we built this
Movie Magic Budgeting ($500+, desktop) and Saturation.io (~$30/month subscription) require you to log expenses against budget lines as you go. Neither starts from the receipts already in your Gmail. ExpenseBot's edge for filmmakers: you get the cost report from receipts you already have, without re-entering anything.
Related ExpenseBot guides
- Freelancer solution — most indie filmmakers file Schedule C / T2125 as sole props; freelancer reports cover the tax-filing side
- Quarterly estimated taxes — pay-as-you-earn for self-employed filmmakers
- Vehicle Deduction Optimizer — if you drove a personal vehicle for production, this pairs with the cost report
- Year-End Tax Workbook — combines the cost report with your Schedule C / T2125 filing