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.

Download Circle Blue

First, Download Your FREE Film Budget Cashflow and PO Log

Cashflow StudioBinder Free Download

Download your FREE film budget sheet template for tracking cashflow.
Just enter your email address and we'll instantly send it to you!

the Film Budget Cashflow & PO LOG

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

THE FILM BUDGET CASHFLOW & PO LOG

2. Gain more visibility on expense details using comments

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

Adding Comments and Details to Film Budget Cashflow Template 

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.

THE FILM BUDGET CASHFLOW & PO LOG

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

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.

up next

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

Easily plan and schedule shooting days

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

Learn More ➜

Tags:
  • Focused on the intersection between Entertainment and Technology. Grew up in Silicon Valley, now resides in Silicon Beach. Also an animal lover, avid reader and futurist.

8 comments

  1. Hi,

    I’ve left my email a few times over the past weeks but I never received a follow up email asking to verify my address.

  2. Hi Sal,

    We updated our page to make it easier for readers to download the template to their Google Drive. Just click the link below, and on the Google Sheets page, click File > Make a Copy to save it to your Google Drive. Cheers!

    Download Film Budget / Cashflow Template here: https://bit.ly/1Vn7hYU

  3. Pingback: Moviemaking budgeting forms
  4. Hi Alisha,
    You can rename those columns if you like, but if you leave them as “Wrap” then you would put there any costs incurred for that department after wrap. Hope that helps!

  5. Quid with the link to receipts & invoices?
    You mention PO & PO log, is that possible with different people?
    Quid link with accounting?

  6. If the project is artist-funded, where can I find a good standard to follow for the Codes in Column A?

Leave a comment

Your email address will not be published. Required fields are marked *

31 Shares
Copy link