Maintaining your budget while in production is a stressful but necessary endeavor. In this post we’ll provide a free Film Budget Cashflow & PO Log template to help you actualize your film budget during production.
Before We Begin, Download the Cashflow Template
Before we begin, download our free film budget sheet template for tracking Cashflow.
Just click the button below, and on the Google Sheets page.
Make sure your are logged into gmail then click the ‘make a copy’ button.
1. The Anatomy of the Film Budget Cashflow
The cashflow document is structured to allow tracking of expenses day by day. The rows represent accounts such as the cost of talent, crew, locations, etc. The columns represent the cost per day for those accounts. By default we breakdown the days by prep, shoot and wrap, though you are welcome to customize them any way you like (i.e. by departments, locations, etc).
Film Cashflow document. Follow along below for an explanation.
1. Code (Column A)
Add account numbers in this column. Number taxonomies are usually determined by your production accountant or the studio you’re working with. If your project is director/artist funded, account numbers can follow whatever standard the production prefers.
2. Description (B)
Add a title or description of the account in Column B.
3. Budget (P)
If you have a budget total for this account, enter it here. If you don’t have a budget yet or program to create it, the cashflow document could be modified for this use.
4. Difference Variable (Q)
This is where we calculate what was spent vs. what was budgeted. This is a fast way to see what is remaining account-by-account, in real time. Money saved by account is positive (+) and money overspent is negative (-).
"Managing cashflow during a shoot can be tricky. Here's a template to help." #filmmaking #filmmakers
2. Gain more visibility on expense details using comments
If you’re using Google Drive, adding comments are a helpful way to record expense details, especially when you’re sharing your sheet with a team. We often add notes to break down the cost of a single figure by its line items (i.e. rental packages). To add a Google Sheets comment follow these steps:
- Click on the cell you want to associate with a comment.
- Go to Insert > Comment > Type out your comment.
- You (and your team) can hover over the cell to view or edit the comment.
3. What’s a PO Log, and why do we need it?
This is where you list payments that are due at a future date so you can quickly create a list of upcoming payments for production approval or as a reference for cutting checks later.
Voided, Deposits, Returned:
Any money returned, cancelled or credited back should be listed here.
Like this post? Share it!
How to Manage Your Film Budget Cashflow & PO Log (with Free Template) #filmmakers #filmmaking
The Film Budget Cashflow and PO Log template helps you actualize your expenses during production shooting. Any suggestions or questions? Did we miss anything in our template? Let us know in the comments below!
Film production software
• Organize talent and crew details
• Create shooting schedules & breakdowns
• Create, send & track personalized call sheets
Latest posts by Darya Danesh (see all)
- A Better Film Crew List Template & Booking Sheet - May 15, 2017
- The Only Shot List Template You Need — with Free Download - July 29, 2016
- Top 10 Storyboard Software of 2017 (with free Storyboard Templates) - July 17, 2016