Managing Your Film Budget Cashflow & PO Log (Free Template)

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

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

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.

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!