Small and medium business | Business Central, N...

Using Business Central for Film Project Management/Accounting

(16) Share

Report

Posted on by Roger Noden

Need some advice on how to setup the following use case in Business Central:

We will be creating short films that we will promote; so they are not associated with a specific customer
We would like to track expenses against a budget for each film
We want to be able to report on each film individually (Profit/Loss, Budget vs Actual, etc.)
We also need to account for Film Cost Capitalization, Amortization, and Impairment.
This basically means that the project costs incurred in the ‘research phase’ are expensed as incurred, while costs incurred in the ‘development phase’ are capitalized once the recognition criteria are met.

I'm struggling on how to setup Job/Project Management in Business Central to handle this. Any suggestions?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (10)

Answers (0)

Suggested answer

JAngle 133 on at

Like (5)

Report

Might be worth looking at progressus psa appsource.microsoft.com/.../pubid.progressussoftware|aid.progressuseu|pappid.131f85d1-48f2-481c-8d5a-849b16e388e6

Covers more than standard does for project accounting. Easier to push through ideas/suggestions than it is with Microsoft (terms of speed)

The part where you don’t associate with a specific customer for instance. PSA let’s you have multiple customers per project so when you can record revenue you can add a new customer to that project

Was this reply helpful? Yes No
CU12121108-0 12 on at

Like (5)

Report

Hello Dynamics Community,

Business Central is well-suited for managing film projects with these requirements. Set up each film as a Job in Business Central to track expenses, budgets, and report on Profit/Loss or Budget vs Actual. Use Job Task Lines to differentiate between research and development phases, aligning costs with capitalization or expense requirements. For Film Cost Capitalization and Amortization, configure Fixed Assets or General Journals to handle recognition criteria and impairment tracking. A specialized add-on like magis tv english alternative can complement your setup for advanced content-specific management, ensuring seamless workflows tailored for the film industry.

Best Regards!!!

Was this reply helpful? Yes No
Ramesh Kumar 7,529 Super User 2025 Season 2 on at

Like (2)

Report

Ho Roger,

Based on the requirement I think standard Business central should be good to setup and process the project account. Please find the below link from Business central documentation which might help you

https://learn.microsoft.com/en-ca/dynamics365/business-central/projects-how-setup-jobs?tabs=current-experience

Thanks

Ramesh

If this helped you, please check the box Does this answer your question?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,763 Super User 2025 Season 2 on at

Like (3)

Report

I think there is nothing wrong with using the standard Project module, you just need to add a dummy customer in the Customers section.

Hope this can give you some hints as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,962 Super User 2025 Season 2 on at

Like (4)

Report

hope this helps as well:https://learn.microsoft.com/en-us/dynamics365/business-central/projects-manage-projects

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (4)

Report

May this can help : https://www.youtube.com/watch?v=92Tu3J6kNQ8

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,390 Most Valuable Professional on at

Like (4)

Report

Hi, good day
I hope this can help you, and give you some hints.

Jobs - Dynamics 365 Business Central

Project management - Business Central | Microsoft Learn

Best Regards
Gerardo

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,760 on at

Like (4)

Report
Hi,

BC’s Jobs module can handle this setup well, even without a customer tied to each film. The key is to treat each film as a standalone job and use task lines to separate phases like research and development.

Here’s how you can structure it:

Create a Job Card for each film. If needed, assign a generic customer (e.g., “Internal Projects”) to satisfy system requirements.

Define Job Task Lines for each phase:

Research Phase → Post expenses directly to P&L accounts

Development Phase → Post costs to a balance sheet account once capitalization criteria are met

Use Job Planning Lines to track budget vs actuals. You can set line types to Budget, Billable, or Both depending on how you want to monitor usage.

For capitalization and amortization, post development costs to a fixed asset or deferred cost account. Use Fixed Assets if you want to automate amortization; otherwise, manual journals work fine.

To track impairment, you can revalue the asset or post a write-down via general journals.

For reporting, use Job Analysis Reports and Dimensions (e.g., Film Title, Phase) to filter by project and phase.

This setup gives you full visibility into each film’s financials while respecting accounting treatment for different phases.

Helpful References
Project Management – Microsoft Learn
Walkthrough: Managing Projects with Jobs – Microsoft Learn
Project Management with BC – WMDYN365
Project Management User Guide – Prodware

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No