A film’s chart of accounts decides whether your QuickBooks Online reports look like your budget or like a pile of generic expenses. Set it up right and you can compare budget to actual by line item, hand investors a clean cost report, and start the next production in minutes. Here’s how to build a QuickBooks chart of accounts for film production, with an example you can follow.
First: do you own the film, or is it a work for hire?
The answer changes the whole structure, so settle it before you create a single account.
- You own the film. This is typical for an LLC formed to make one feature or documentary. Your budget lines become accounts in the chart of accounts, so your reports read line by line like the budget.
- It’s a work for hire. Commercials, music videos and branded content usually fall here. Keep a short list of Cost of Goods Sold accounts by budget category, put the detailed budget lines in Products & Services, and track each job as a Project.
If you’re unsure about the tax treatment, including whether costs are expensed or capitalized, ask your CPA before you set anything up.
Your budgeting program and QuickBooks work together
Most productions build and track the budget in a program like Movie Magic Budgeting, Showbiz Budgeting or Hot Budget. That’s where purchase orders, commitments and estimated cost to complete belong. Those programs are built for the way budgets change during production: if one department comes in under budget and another runs over, you can easily move money between them.
QuickBooks keeps the books: bills, payments, petty cash, payroll entries and reconciliations. When your QuickBooks accounts use the same numbers as your budget, your actuals line up with the budget line by line, and comparing the two takes minutes instead of days.
Example chart of accounts for an owned film
Use your own budget’s numbering. If your budget isn’t numbered, a simple scheme like the one below works. Each budget category is a parent account, and each line under it is a sub-account, so totals roll up the way your budget does.
| Account | Type | Examples of sub-accounts |
|---|---|---|
| 1100 Story & Rights | Expense | 1101 Rights Purchase, 1102 Screenplay |
| 1200 Producers | Expense | 1201 Producer, 1202 Line Producer |
| 1300 Director | Expense | 1301 Director Fee |
| 1400 Cast | Expense | 1401 Principal Cast, 1402 Day Players |
| 2000 Production Staff | Expense | 2001 Production Manager, 2002 Assistant Directors |
| 2300 Camera | Expense | 2301 Director of Photography, 2302 Camera Rental |
| 2600 Locations | Expense | 2601 Location Fees, 2602 Permits |
| 3000 Editorial & Post | Expense | 3001 Editor, 3002 Color, 3003 Sound Mix |
| 4000 Other Costs | Expense | 4001 Insurance, 4002 Legal, 4003 Accounting |
| 4500 Fringes | Expense | 4501 Payroll Taxes, 4502 Union Fringes |
You’ll also need balance sheet accounts for the production’s money:
- Production Checking, the bank account the production pays from.
- Credit Cards, one account for each production credit card.
- Production Funding (equity), with a sub-account for each investor or member. Investor money is not income.
- Loans Payable for any production loans or gap financing.
- Petty Cash. One account is enough. Your budgeting program tracks each person who received a float and calculates whether they owe money back or need to be reimbursed.
- Deposits (asset) for refundable equipment, location and stage deposits. They come back to you, so they aren’t a cost of the film.
- Payroll Clearing, if your payroll company pulls one lump sum and you record the detail from their reports.
Setting it up in QuickBooks Online
- Turn on account numbers. Go to Settings, then Account and settings, then Advanced, and enable account numbers under Chart of accounts. Without numbers, QuickBooks sorts accounts alphabetically and your reports won’t follow the budget.
- Import instead of typing. Export your budget to Excel, clean it into columns for account number, name and type, and import it into the chart of accounts.
- Make inactive the defaults you won’t use. QuickBooks adds generic accounts like Advertising and Meals. If they don’t fit your budget, make them inactive so nobody codes costs there by mistake.
- Check your account count. Simple Start, Essentials and Plus each allow up to 250 accounts; Advanced has no limit. If your budget has more lines than that, combine smaller lines into one account in QuickBooks, since your budgeting program keeps the full detail, or use QuickBooks Online Advanced.
- Save it for next time. Once it’s working, export the chart of accounts. You can import it into your next production’s file in minutes.
Common mistakes
- Recording investor money as income. It makes the film look profitable on paper and confuses everyone at tax time.
- Running two films in one QuickBooks file. If each film is its own company, give each its own file. If one company produces several jobs, use Projects or classes to keep them separate.
- Building the chart of accounts from scratch instead of from the budget. If the accounts don’t match the budget, your actuals won’t line up with the budget either.
- Coding deposits as expenses. When the deposit comes back, your costs look smaller than they really were.
Skip the setup work
The Film Production Toolkit in the BookkeeperLA Store includes ready-to-import charts of accounts for an owned film and for a work for hire, plus a Products & Services import file, a setup checklist and an 11-page setup guide. For the full setup, from bills to petty cash and payroll, read How to Set Up QuickBooks Online for Film Production Accounting.
Rather have someone do it for you? I set up and manage QuickBooks for indie features, documentaries, commercials and music videos. Learn more about my film production accounting services or book a free 15-minute call.
Frequently asked questions
Should film production costs be expenses or Cost of Goods Sold in QuickBooks?
For a work for hire, production costs are usually Cost of Goods Sold because they’re the direct cost of a job you’re paid for. For a film you own, budget lines are often set up as their own accounts so reports match the budget. If you’re unsure how those costs are treated for taxes, ask your CPA.
Can I use my Movie Magic or other budget as my chart of accounts?
Yes. Export the budget to Excel, keep the account numbers and descriptions, add an account type column and import it into QuickBooks Online. Your QuickBooks reports will then line up with the budget.
How many accounts can a film’s chart of accounts have in QuickBooks Online?
Simple Start, Essentials and Plus each allow up to 250 accounts; Advanced has no limit. Most indie budgets fit within 250 accounts. If yours doesn’t, combine smaller lines into one account in QuickBooks, since your budgeting program keeps the full detail, or use QuickBooks Online Advanced.