Plan the costs of a short film, documentary or freelance production with these free film budget templates for Excel and Word. Organize personnel, equipment, travel and post-production costs, then adapt the categories to your script, schedule and delivery requirements.
The collection includes three Excel workbooks (.xlsx) and three Word documents (.docx), supplied in ZIP files. The Excel files contain limited formulas and need checks or corrections before use. The Word files provide manually completed layouts.
Extract the ZIP file and save a working copy before editing. Replace all sample amounts with your own estimates. These files are starting layouts, not complete production accounting systems or automatically reliable cost calculators.
01. Film Budget and Actual Cost Worksheet
Format: Excel (.xlsx), inside a ZIP file.
Includes script and rights, producer, director, cast, production, post-production and marketing categories, with cost, tax, budget and actual-cost columns.
Before use: Several subtotal ranges are incorrect, grand-total fields lack formulas and the sample contingency is not calculated automatically. Use the correction notes below.
Groups personnel, equipment, travel, accommodation, food, post-production, insurance and administration, with quantity, day, rate and total fields.
Before use: Line totals are sample values rather than quantity/rate calculations. Personnel subtotals are misplaced or incomplete, and the final “Total” only covers insurance and administration.
A grant-request table for equipment and locations, petrol, on-site filming needs, music, software, translation and miscellaneous costs, plus financial and in-kind support details.
Before use: A grant-oriented presentation layout. Add any missing personnel or other costs and follow the funder’s actual budget instructions; this is not a verified submission form.
Lists production details and categories such as rights, cast, travel, camera, sound, art, insurance, editing and contingency, with budget and actual-cost columns.
Before use: A manual summary for comparing planned and recorded costs. Correct repeated account numbering and calculate the section and grand totals separately.
Includes freelancer and fixer days, equipment, travel, accommodation, per diems, post-production, insurance and administration.
Before use: Contains section sums but no quantity × days × rate line formulas. The bottom “TOTAL” only sums the insurance/admin section rather than the full budget.
Combines personnel and contact fields, duration and cost entries, a category summary and a begin/complete project timetable.
Before use: A compact manual planning form. Clarify headings such as “Distribute,” “Posts,” “Shoots” and “Product Manager,” and define the units used in the duration column.
Build your estimate from the work required rather than assuming a template contains every cost. A short film with one location may need a different breakdown from a documentary with travel, translation and archive material.
Development and preparation: Script work, rights, research, casting, location scouting and planning.
Cast and crew: Preparation, filming, travel and wrap time, plus applicable agreed employment and payroll costs.
Equipment and locations: Rental periods, collection and return, accessories, expendables, site fees and relevant permissions.
Production support: Transport, accommodation, meals, art, wardrobe, administration and appropriate insurance.
Post-production: Editing, sound, color, music rights, captions or subtitles, storage, backups and delivery versions.
Release costs: Agreed promotion, festival submissions or distribution deliverables where they are within scope.
Contingency: A separately identified allowance with a stated basis and approval process.
Use current quotes and agreed rates. Check what packages include so crew, kit, editing or transport costs are not counted twice. These documents do not determine applicable pay rates, insurance coverage or contractual obligations.
How to Build Your Production Estimate
Set the scope. Record the film type, intended length, locations, shooting days and required delivery formats.
Break down the work. Identify people, equipment, services and materials needed for preparation, filming and completion.
Define units. Distinguish a person-day, rental day, room-night, journey and fixed fee. Match each quantity to the correct rate.
Document assumptions. Record quote dates, included hours, rental periods, travel arrangements and treatment of taxes or other charges.
Calculate and verify. Check line totals, category sums, contingency and the overall total independently.
Track changes. Keep the approved budget separate from actual spending, outstanding commitments and the current estimate to finish.
Use an expense report to organize submitted purchases and supporting receipts. A daily time sheet can support a record of hours worked; apply the relevant agreed pay arrangements separately.
Excel Formula Checks Before Using the Workbooks
The following references match the original downloads. Update them if you move or insert rows. The notes describe changes to make in your working copy; the original downloads remain unchanged.
Template 01: Correct Subtotals and Add Grand Totals
K31: The existing production actual subtotal omits travel in row 14. Use =SUM(K14:K30) if that remains your production section.
J35: The post-production budget subtotal includes earlier production lines and the production subtotal. For the existing post-production rows, use =SUM(J32:J34).
K35: For the corresponding post-production actual subtotal, use =SUM(K32:K34).
Overall budget: Add a clearly labeled summary using =SUM(J13,J31,J35).
Overall actual: Add a clearly labeled summary using =SUM(K13,K31,K35).
The original grand-total areas are not connected by formulas. The cost and tax columns also need a defined calculation approach. The contingency text says “10% of production costs,” but its amount is a sample input; define the intended calculation base and exclude the contingency itself from that base. Do not treat an unused contingency reserve as an actual expense.
Templates 02 and 05: Build the Line Calculations
The detail totals are entered sample figures. When C is quantity, D is days and E is a rate per unit per day, a suitable line formula is =C9*D9*E9 in F9. Use it only on rows with those units. A fixed fee or one-time purchase needs a different basis, such as quantity × unit price.
In Template 02, F14 currently equals only F9, while the personnel sum appears in the equipment heading at F15. After setting up the detail calculations, put =SUM(F9:F13) in the personnel subtotal F14 and clear the misplaced F15 total. Add a separate overall total using =SUM(F14,F21,F32,F39,F44). F44 alone covers only insurance and administration.
In Template 05, F47 covers only insurance and administration. Relabel it accordingly and add a separate overall total using =SUM(F16,F24,F34,F41,F47). Do not add the rate-column sums to the budget: adding unit rates does not produce a meaningful total project cost.
Simple Short Film Budget Example
The figures below are illustrative inputs, not market rates or a recommended spending level. They use one currency and exclude any charges not explicitly stated.
Illustrative small-production estimate
Item
Basis
Amount
Crew
3 people × 2 days × 200
1,200
Equipment package
1 package × 2 days × 250
500
Location
Agreed fixed fee
300
Transport and meals
Itemized allowance
250
Editing and sound
Agreed scoped fee
750
Base estimate
Sum of listed costs
3,000
Illustrative contingency
10% × 3,000
300
Total planning allowance
3,000 + 300
3,300
This example is not a complete production budget. Add omitted work, rights, insurance, preparation, delivery or applicable charges as required by the project. The 10% contingency is an example assumption, not a universal standard.
Keep the Budget Separate from Funding and Cash Flow
The budget estimates what the production will cost. A funding plan identifies where resources will come from. A cash forecast shows when money arrives and when payments fall due. A fully funded total can still leave a timing gap before a deposit or crew payment.
A cash budget worksheet can support that timing view. Record promised funding, confirmed funding and in-kind support distinctly. Donated equipment or time can have a stated value without providing cash for other bills.
Frequently Asked Questions
Which film budgets are Excel files?
Templates 01, 02 and 05 contain .xlsx workbooks. Templates 03, 04 and 06 contain .docx documents. Each download is packaged in a ZIP file.
Do the Excel workbooks calculate everything automatically?
No. They contain limited formulas, manual detail amounts and issues described above. Complete and test the calculations before relying on the totals.
Can I use these for a short film or documentary?
Yes, as starting layouts. Adapt the categories to the script, schedule and deliverables. Template 03 is grant-oriented and includes financial and in-kind support fields.
Do the files calculate revenue or profitability?
These are cost-planning layouts. They do not provide a complete revenue, financing or profitability model.
Is contingency the same as spending?
No. An allowance for uncertainty is not evidence that the money has been spent. Track approved use and actual expenses separately.
Can I export a PDF?
Yes. Check print areas, page breaks, formulas and readability first, then export a PDF for review. Keep the editable master and a dated version of the approved budget.
