3 Signs It’s Time to Up Your Allocation Game and Get True Performance Insights with Dynamic Allocations

Gain a fuller picture into your organization to fuel informed decision-making

Allocating, or attributing, revenue and expenses across dimensions helps you better understand the whole operational picture of your organization. It provides clearer insight into the performance of business units, departments, products, projects, funds, and more, since you can derive the complete picture of revenue and costs, both direct and indirect. For instance, you can see the full cost of employees attributed to a department beyond just their salary when you factor in indirect expenses, such as fringe benefits. With a more comprehensive view of operations, organizational leaders can make better informed decisions.

Many companies turn to spreadsheets for their allocations. However, there are significant limitations to calculating your allocations outside of Sage Intacct, including high effort, potential for errors, and incomplete or delayed insights.

Here are some signs that it might be time to look into automation for allocations.

Sign 1: You spend half a day or more to calculate and record allocations

Performing manual allocations is time-consuming and carries the risk of spreadsheet error. It usually means you have to apply a complex model within a spreadsheet—often by using a tedious process that has multiple steps.

Something as seemingly simple as splitting the cost of a shared service like IT might need to be split 12 different ways to account for different departments—first by department square footage, then by headcount. This single expense may mean you need to take the following steps:

  1. Run a report
  2. Manually extract data
  3. Manually calculate bases
  4. Manually input bases into Excel
  5. Manually import data into the spreadsheet
  6. Extract data and record entry into the general ledger

Since you have 2 layers of allocations, you would need to run through these steps twice. Not only are you introducing many opportunities for manual error, but you also need to ensure you’re calculating your allocations in the correct order.

Any post-period adjustments in headcount, timesheets, or other allocation basis factors, mean you also need to take time to incorporate corrections. A post-period adjustment can be a recipe for a pounding headache and a late night at the office.


Solution: Run multiple layers of allocations in minutes, not hours or days

Dynamic Allocations allows you to generate allocations without the spreadsheet gymnastics. So, when splitting IT costs, you can now begin by allocating facilities costs to the IT department based on square footage. Next, you could allocate IT personnel fringe benefits using direct salaries as the basis. Once all costs have been allocated to the IT department, you can then allocate to other departments based on headcount or another basis measure, all while preserving the views of IT departmental costs.

Dynamic Allocations pulls source balances automatically and distributes them across dimensions based on chosen parameters. You have the flexibility to specify source accounts, set up allocation splits, and target accounts. You can even set up layers of allocations and group allocations to run in specific orders.

Allocations can be set to run automatically. That means you don’t need to lift a finger to run your allocations after the initial setup. You simply monitor them to make sure they’re running correctly and update with any changes to your accounts, dimensions, or allocation strategy. A process that used to take hours or days can be streamlined into minutes, allowing you to allocate more frequently for accurate insight when you need it—even as often as bi-weekly payroll.


Sign 2: You’re spending extra hours troubleshooting your allocations

In a process with multiple manual steps, you’re opening the doors for the potential of human error, as well as issues with replicability. Complex allocations can be difficult to apply consistently.

This can get even more difficult when knowledge of allocation methods and rationale ends up siloed in one or two team members. Often, allocation methodology and rationale are not clearly documented, so it can feel impossible to consistently apply allocations—especially if those people move on from your organization and leave behind nothing but inscrutable spreadsheets.

If there’s a late change to allocation basis factors, like headcount, labor hours, or a late timesheet submission, it means you have to go back to make manual corrections. And, if you accidentally apply the incorrect allocation method, do something in the wrong order, or miss a step, it may take a long time to troubleshoot, especially if it means changing the source content.

Finally, when the time to audit or prove compliance comes around, without consistent application or a traceable audit trail to follow, it can be difficult to explain the methods used or show accurate documentation to auditors, especially if your inputs are subject to change.


Solution: Consistently apply allocations every time

Automated allocations are applied consistently every time, even the most complex. Eliminating manual processes means you’re likely spending less time going back to correct errors. Further, true-ups automatically pick up those late changes to headcount, labor hours, or other allocation basis factors.

So, a late timesheet no longer requires you to perform a manual adjustment to your allocations. The automatic reversal and the correction in Dynamic Allocations happens at the same time. That means you get continuous adjustments, so your year-to-date indirect costs are always based on the most accurate amounts available.

With centralized storage of allocation methodology, including source accounts, split accounts, groupings, and order, you can consistently apply allocations, every time.

Further, Dynamic Allocations also allows users to document rationale, so anyone can see why an allocation occurred and how it was done, making it easy for anyone in the company to replicate allocations. It also provides auditors with validation to quickly handle audits. A verification page, unique to Sage Intacct, provides complete transparency with a snapshot of parameters at the time of the allocation run.

A consistent, documented process also helps organizations prove compliance. If, for example, you’re a non-profit that needs to comply to FASB 958, you can set up a recurring allocation that allocates indirect expenditures based on cumulative activity. The automation ensures that the allocations are splitting consistently, and the documented rationale ensures that you’re able to disclose the allocation method as necessary.


Sign 3: Your insights are incomplete or delayed

When allocations end up taking hours or days of tedious steps and lengthy journal entries, you may be left with the choice of allocating less or doubling down on effort. The first two options result in a less-than-accurate picture of performance across the dimensions you’re tracking, which means you may be limiting management insights and missing opportunities.

Doubling down on effort results in you spending time calculating and manipulating data in spreadsheets. If allocations are taking half a day or more to complete, you may be delaying reports or extending the close. This can lead to downstream consequences of insights and decisions made without real-time data.

However, when you take advantage of automated allocations, you don’t need to make a tough decision on trade-offs and potential consequences.


Solution: The insights you need when you need them

Dynamic Allocations gives a timely, more accurate view into the true performance of your organization. With automated allocation entries, you can now produce reports quickly and accurately, helping you get your information when you need it, and ultimately streamlining your close.

Multi-book functionality allows you to preserve pre-allocation insights, which can even allow you to compare basis methods. You can easily build reports to see the allocation impact, so you can, for example, see fully loaded department costs.

This means you have full performance visibility across any reporting element you need to track against. Empower decision makers by providing a full and accurate portrait of where your organization stands.


Dynamic Allocations Value

Having a more accurate view into your organization’s true performance gives you the insight you need to make informed, strategic decisions. With a better understanding of cost and revenue structures, the finance team is better equipped to make optimal decisions that help achieve business goals.

It also doesn’t stop there. The detailed rationale makes automated allocations apply consistently, providing easy audits. And beyond just that, Dynamic Allocations is also fully equipped to handle allocations like investment mark to market entries or shared-ownership investments.

Further, Dynamic Allocations represents a significant milestone in Sage Intacct’s move towards the continuous close. They’re now 100% automated—saving organizations with complex allocations up to three days of time each month. That’s time that can be spent on activities that deliver more value for the organization, like oversight, analysis, and strategic advice.

All this gives finance the opportunity to move out of an operational role of digging through spreadsheets to providing guidance that matters.


Interested in learning more about Dynamic Allocations and what it can do for your organization?

Visit this webpage and contact DeRosa Mangold Consulting to learn more.

To learn more about how Sage Intacct can help you achieve your mission more efficiently, fill out the following information and DeRosa Mangold will be in touch.

DMC team

DeRosa Mangold Consulting is a trusted team dedicated to partnering with you in a logical fashion to help you make the best decision for your company’s future growth. On average throughout multiple industries, startups to mid-sized organizations begin to see a return on investment in about 6 months. We will personally sit down with you and crunch the numbers, so you know when to expect your own ROI. We won’t tell anything but the truth so that you can make the best decision for your organization.

To learn more about DeRosa Mangold Consulting or Sage Intacct visit:


If you would like to take a quick look at the software, you can take part in one of the daily Coffee Break Demos we offer.

Leave a Comment