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.

More...

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).

Anatomy of a Film Budget Cashflow Template- Legend - StudioBinder-min

Film Cashflow document. Follow along below for an explanation.

1-blue-circle

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.

1-blue-circle

2. Description (B)

Add a title or description of the account in Column B.

1-blue-circle

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.

1-blue-circle

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 (-).

twitter-bird-bue-gray

"Managing cashflow during a shoot can be tricky. Here's a template to help." #filmmaking #filmmakers

Click to Tweet

2. Gain more visibility on expense details using comments

Adding Comments and Details to Film Budget Cashflow Template - StudioBinder-min

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:

  1. Click on the cell you want to associate with a comment.
  2. Go to Insert > Comment > Type out your comment.
  3. 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?

The PO Log (or “purchase order log”) is a document that tracks payment details on your production (i.e. who was paid, when, how, from what account and for what reason). Some entities may require their prior approval of a purchase order before any payments can go out. We separate our PO Logs into three sections so you can more easily track exactly what is spent to-date and identify what is due next. We also include a Voided section so you can confirm against payments or deposits returned.
PO Log StudioBinder Free Download

Paid:

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.

To Pay:

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!

twitter-bird-bue-gray

How to Manage Your Film Budget Cashflow & PO Log (with Free Template) #filmmakers #filmmaking 

Click to Tweet

Wrapping Up

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!

Solution Icon - Shooting Schedule

Backup your cashflow docs and create better shooting schedules.

Import scripts and reorder scenes to make a schedule. Add day breaks to mark shoot days. Spin-off call sheets when you're done.

Learn More

StudioBinder Stripboard Shooting Schedule Film Scheduling Software