Pass-through spend stops distorting the picture
Separating media and production costs from agency fee income gives a true margin figure. Without it, a low-margin media-heavy account can look like your best client for years.
A practical look at what an ERP does for an agency, where the value sits, and how to choose a platform that handles retainers, project work and large volumes of pass-through media spend.
Agencies sell time and ideas, then spend a lot of other people's money on their behalf. Media, production, freelancers and print all flow through the agency's books, which makes revenue look enormous and margin look mysterious.
An ERP (enterprise resource planning system) puts jobs, costs, purchase commitments, billing and reporting in one place, so you can see what a campaign actually earned rather than what it turned over.
It does not replace your creative or media planning tools. It covers the commercial layer around them - estimates, budgets, supplier costs, invoices and margin.
For most agencies, an ERP is where the following live:
The value in an agency is rarely in the accounting itself. It is in knowing which work makes money and catching the jobs that don't while you can still act.
Separating media and production costs from agency fee income gives a true margin figure. Without it, a low-margin media-heavy account can look like your best client for years.
Costs posted against the job as they are committed, not when invoices arrive, means you know a campaign is running hot in week three rather than after the final reconciliation.
Recorded time against retained scope shows which clients are consuming twice the hours they pay for. That is a renewal conversation with numbers behind it rather than a feeling.
Purchase orders raised before work is commissioned mean the cost is visible at the point of decision, which is the only point at which anyone can still say no.
Fee income, gross income, utilisation and pipeline in one place gives leadership a monthly pack that comes out of the system rather than out of three people's evenings.
Staged billing, media invoicing and recharges run to a schedule, so cash arrives on time rather than whenever someone gets round to raising the invoice.
Data taken from a survey we commissioned in December 2024. Click here to view
of businesses are utilising an ERP
businesses are dissatisfied with their current ERP
of businesses say using an ERP has contributed to achieving business outcomes
Six everyday situations where one connected system changes the outcome.
The approved estimate becomes the job budget, with phases, rates and billing stages already set. Nobody starts work against a number that only exists in a PDF someone emailed.
Agencies have a distinctive cost structure and a lot of money moving through on someone else's behalf. These are the questions worth asking before you shortlist.
Finance, purchasing, stock, projects and reporting should sit in one system. Anything left in a spreadsheet quickly becomes the version everybody argues about at month end.
A system designed for a different sector rarely suits advertising agencies. The platform should reflect your real processes, approvals and cost structures rather than forcing a rewrite of how you operate.
Consolidation, reconciliation and management reporting should be routine rather than a fortnight of manual work. Ask to see a month end demonstrated, not described.
Role-based permissions, approval workflows and a complete audit trail should be built in, so compliance is a by-product of daily work rather than a separate exercise.
Cloud platforms with standard processes go live in weeks rather than years. A long implementation is usually a sign the system is being bent into shape.
New sites, entities, currencies or product lines shouldn't need a replacement system. Check licensing and functionality for where you expect to be in five years.
Once you know what an ERP should do for an agency, the question becomes which platform fits how your teams already work. Microsoft Dynamics 365 Business Central brings finance, jobs, purchasing and reporting into one cloud system connected to the Microsoft tools you already use.
For agencies that means job costing and purchase commitments as standard, multi-entity and multi-currency consolidation for group structures, and Power BI dashboards showing margin by client and campaign without a monthly rebuild.
It is modular, so you can start with finance and job costing and add projects, service or Dynamics 365 CRM later - without another migration when the agency grows or acquires.
It isn't just an accounting package. These are the capabilities teams tell us make the biggest difference day to day.
Ledgers, budgets, cash flow and management reporting run from the same data, with Power BI dashboards leadership can open themselves rather than waiting for a pack.
AI drafts descriptions, reconciles bank entries, chases anomalies and answers questions about your data, taking a chunk of routine admin off the finance team.
Approvals, quotes and reports work inside Outlook, Teams and Excel, so people use the tools they already know instead of learning another interface.
Approvals, alerts and handovers can be automated with Power Automate using low-code tools your own team can maintain.
Role-based access, approval limits and full traceability protect the financial and operational data advertising agencies are accountable for.
Start with finance and operations, then add supply chain, projects, service or Dynamics 365 CRM as you grow - without another migration.
No. Traffic, briefs and creative workflow can stay where they are. The ERP owns budgets, costs, purchase commitments, billing and margin, and connects to the delivery tools your teams already use.
Yes, and it should be a requirement on your shortlist. Reporting on gross income as well as billings is the only way to see real agency margin.
No. Multi-entity, multi-currency and intercompany recharges are standard in a mid-market ERP, and consolidation runs as part of the normal close.
A single-entity agency on standard processes is usually live within weeks. The longest part is agreeing your job structure and reporting hierarchy, which is worth the time.
Yes. It is licensed per user per month and designed for small and mid-sized organisations, so you are not paying enterprise pricing for enterprise features you will not use.
Tell us how the agency prices, costs and bills work today and we will talk through what an ERP would change, which capabilities matter most and where to start. No obligation, just a straight conversation.