Maintaining your budget while in production is a stressful but necessary endeavor. We're going to provide you with a free Film Budget Cashflow & PO Log template to help you better manage and actualize your film budget while shooting.
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 (-).
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?
All Cash, Credit Card, Checks, and Wire Transfers should be recorded here as generated. You can list out Petty Cash amounts here so you can reconcile them later.
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.
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!
Latest posts by Darya Danesh (see all)
- The Only Shot List Template You Need — with Free Download - July 29, 2016
- Top 10 Storyboard Software of 2016 (with free Storyboard Templates) - July 17, 2016
- 8 Websites to Find & Hire a Storyboard Artist - June 11, 2016