Episode 9
How to Track Actual Spending Against Your Budget
Log expenses against budget lines with who was paid, attach invoices and proof of payment, read the variance, plan payments on the Payment schedule, and add income on Cashflow.
Recorded against The Long Way Home. To build the same project as you watch, download the project files (5 MB).
In this episode
- 0:00 Introduction
- 0:18 The Actuals page
- 0:42 Logging an expense
- 2:34 When a line goes over
- 3:42 The Payment schedule
- 6:34 Summary and next steps
Once you start paying deposits, you need to know what you have actually spent and what is still to pay. In this episode we log expenses against the budget lines of The Long Way Home, read the variance, and plan payments on the Payment schedule. For the wider picture, see the film budgeting software page.
Step 1: Read the Actuals Page
- Click Budget in the top navigation bar and select Actuals.
It is the same budget with two more columns. The grid shows Code, Description, Estimated, Actual and Variance, and a totals footer shows Estimated, Actual, Variance and Remaining for the whole budget.
- Estimated is what the budget says.
- Actual is what you have spent.
- Variance is the difference, Estimated minus Actual.
A negative variance means a line is over budget, and it shows in red.
Step 2: Log an Expense
We have paid the deposit on Beverly, the camper van.
- Click Expenses in the toolbar (tooltip “Toggle expense panel”). The expense panel opens on the right.
- Expand Transport & Catering and select the Beverly line. The expense panel shows the line’s ESTIMATED, SPENT and LEFT, a spend bar, and “Nothing spent on this line yet.”
- Click Add expense. A new expense form opens with Description, Paid to, Amount, Date, Status, Method, Due date, Category, Documents and Notes.
The expense belongs to the line you selected, so it counts against the right part of the budget straight away.
- Type
Camper van hire depositinto Description. - In Paid to, type
Copper Bend Classic Campers.
Paid to records who received the money. Pick one of the project’s contacts, or type a supplier’s name for a one-off payment, like the camper rental company here. It prints on the Proof of payments report and in the expense exports.
- Type
800into Amount and set Date to Nov 16, 2026. - Click Paid in the Status switch. The Due date field becomes Paid on and takes the expense date, Nov 16, 2026.
Status runs from Pending to Approved, Invoiced and Paid.
Step 3: Attach the Paperwork
- Under Documents, click + Invoice and choose the supplier’s invoice,
Invoice - Copper Bend Classic Campers.pdf. - Click + Proof of payment and choose the proof, such as a bank transfer confirmation. Ours is
Payment confirmation.pdf. - Click Add expense, pinned at the bottom of the panel below the form.
The expense joins the Paid group as a single row, with the date, who was paid, the amount and a chip for each document. The panel’s header now shows $800 spent. You can also drop a file onto the panel to start a new expense with it attached. A paid expense with no proof of payment says so on its row, and the Paid heading counts how many are missing until the proof is attached, so missing paperwork is easy to spot.
- Click the row to open it again. Under Documents in the form, click the invoice to open the file, then scroll down and click Done.
Step 4: See What Over Budget Looks Like
Day 1’s catering came in higher than the line allows. In Episode 7 we gave the Catering & Craft line a rate of 1200, so its estimate is $1,200, and the expense below is $1,400. Both PDFs and these numbers are in the project files on the series page.
- Select the Catering & Craft line and click Add expense.
- Type
Day 1 cateringinto Description andPellham Falls Cateringinto Paid to. - Type an amount larger than the line’s estimate, set Status to Invoiced, Due date to Dec 3, 2026 and Category to Catering, and click Add expense.
The expense goes under To pay, and the panel shows how much is still due. The line’s variance turns negative and red. The Transport & Catering category above it is still positive, because Beverly’s line has money left, and the totals footer shows the variance and what is left to spend for the whole budget.
- Click the expand and collapse button at the left of the toolbar to collapse the tree, then expand only Transport & Catering to see it on its own.
When a line turns red, find out why, or move money to it from another line before more lines go over.
Step 5: Check the Summary Page
- Click Summary in the Budget sidebar.
The Summary page shows TOTAL BUDGET, TOTAL SPENT and VARIANCE side by side, an Estimated vs actual chart that compares spending by category, and Budget alerts, which lists any category that has gone over as a whole. Ours reads All on track, because the catering overrun still fits inside Transport & Catering. It is a good page to open at the start of every production meeting.
Step 6: Read the Payment Schedule
- Click Payment schedule in the Budget sidebar.
The Payment schedule lays payments out over time, with a row for each budget line and a column for each month, week or day. Four cards across the top show PAID SO FAR, DUE IN THE NEXT 30 DAYS, OVERDUE and BIGGEST WEEK. The toolbar has Month, Week and Day, Today, a From and To range, All, Scheduled and Paid, Overdue labels and Export.
- Click Week, then Today.
- Find the Beverly deposit in the week of November 16 and the Day 1 catering in the week of November 30.
A paid expense sits on the day it was paid, and an unpaid one on its due date. Paid amounts are green, scheduled ones have an amber outline, and anything overdue turns red, so you can see at a glance what is still to be paid. Weeks start on the day set in Settings, under Project, Region and format, which is Monday unless you change it.
Step 7: Plan a Future Payment
- Right-click the Camera Package row in the week of December 7. The cell is empty, so the menu shows only Add expense.
- Choose Add expense. The same expense form opens, with the date taken from the column you clicked.
- Type
Camera package depositand3600, leave Status on Pending, and click Add expense. An amber-outlined amount appears in that column.
On a cell that already holds a payment, the same menu also has Mark as paid, which records the payment as made. Undo takes it back if you click it by mistake.
- Click the catering amount. The payment details card lists the payments behind it, each unpaid one with a Mark paid button. Close the card.
- Click Export to see the export options: a date range and the choice of month, week or day columns. The schedule exports as a PDF or a spreadsheet, which is usually what a production accountant or a bank asks for. Close the dialog.
Step 8: Add Income on Cashflow
- Click Cashflow in the Budget sidebar.
Cashflow uses the same payments to show the money in the bank. The cards show EXPECTED CASH TODAY, the LOWEST POINT ahead and the NEXT MONEY IN, above a chart of money in and money out with the running balance as a line.
- Click Add source, type
Film fund grantinto Name and20000into Total planned, and click Add source. - Double-click the grant’s cell in the week of December 7, type
10000, leave it Expected, and click Add income.
The running balance turns red below zero, so you see a shortfall before it arrives.
The Long Way Home now has a paid deposit on Beverly with its invoice and proof of payment, an over-budget catering line, a planned payment for the camera package, and a grant on the Cashflow. In the next episode, Exporting and Sharing, we export the reports that producers, financiers and the crew need, and send the whole production to the people who need it.
Common questions
What does a negative variance mean in a budget?
Variance is the estimated amount minus the actual amount spent. A positive variance means a line still has money left, and a negative variance means it has gone over budget. In FilmBase, a negative variance shows in red on the Actuals page.
What is the Paid to field on an expense?
Paid to records who received the money. In FilmBase you can pick one of the project's contacts or type a supplier's name for a one-off payment, such as a rental company. It prints on the Proof of payments report and in the expense exports, so it is clear who was paid.
What is a proof of payment in production accounting?
A proof of payment is a record that the money went out, such as a bank transfer confirmation or a receipt. In FilmBase you attach it to an expense with + Proof of payment, next to + Invoice for the supplier's invoice. The expense row shows a chip for each document, and a paid expense with no proof of payment says so on its row.
Try it on your own production
FilmBase runs on your own computer, and your projects stay there as files you own.
Mac · Windows