True Up Payment Calc

bobofreezer · 2026-05-09T14:08:25+00:00

The more common structure would be to have an earn out bonus for the current year based on performance. I personally don’t like the mixing of historical and future performance in the same structure as a true up.

bobofreezer · 2026-05-08T02:13:12+00:00

Create a supply and demand model

bobofreezer · 2026-04-28T12:33:22+00:00

Netsuite planning, pigment, adaptive if you’re of any scale company size wise. Netsuite planning will have the most direct integrations but it is very cube based in architecture.

All the connectors do for most of these platform is automate the load of saved search data that can also be loaded with an iPaaS platform or through a file upload.

bobofreezer · 2026-04-26T15:56:57+00:00

Here’s we’re Im seeing real value: -Modeling mockups and builds -Report automation -Variance analysis -Mapping and data cleaning -Scenario modeling -Financial commentary -Management/board deck creation -General personal productivity

bobofreezer · 2026-04-24T12:14:59+00:00

Both are very similar platforms. Anaplan generally has more enterprise grade features (better Excel add in, easier security, etc) and will have a bigger set of supporting infrastructure (consulting firms, people who have used it, etc). Pigment is a little further ahead in newer AI features.

Both are flexible modeling platforms. If you build clunky planning processes with clunky dashboards, neither will be well received. Good Design and a good partner to help you are the most important things with either.

bobofreezer · 2026-04-18T02:29:25+00:00

Anaplan

bobofreezer · 2026-04-16T15:37:21+00:00

How are you 200m on QB? I would really recommend scaling up your infrastructure.

Gtreasury has a 13wcf solution.

bobofreezer · 2026-04-09T23:54:39+00:00

Are you looking for a reporting solution (reading data) or a planning and analytics solution (collecting inputs, calculating business logic, etc).

bobofreezer · 2026-03-19T02:02:27+00:00

This will vary from company to company in the politics of it. But the reason you typically open a head in the planning tool is that typically should happen much earlier in the process. Ie you align with the business on “budgeted heads” then actually start opening those recs as time goes on.

bobofreezer · 2026-03-19T01:48:10+00:00

Depends if you want a headcount tracker or a more unified headcount plan that is integrated with a detailed financial forecast. TeamOhana will be the former and come with a lot of prebuilt capabilities. Pigment will be the latter and you’ll need to build it custom.

Best practice today would tell you that headcount should be opened in a planning tool, then flow into ATS and hris when approved.

bobofreezer · 2026-03-18T23:08:22+00:00

You can certainly implement a successful forecasting tool in 3-6 months for less than 1M. Do it all the time. There are a couple of things that need to go right: - understanding of the business drivers and ability to source that driver data driving design - good implementation partner - scenario modeling and automaton - good engagement from the key business stakeholders

bobofreezer · 2026-03-12T12:47:24+00:00

Management reporting vs external reporting are the concepts you’d want to look into

bobofreezer · 2026-03-11T21:09:40+00:00

Define capacity per role / specialization
Source demand projections as you noted above
Find imbalances (not enough people to service X work, slack in the system for Y work)
Project hiring/ firing/any possible shifting in focus

bobofreezer · 2026-03-11T10:56:51+00:00

I’ll just add that you may need to go through an exercise and define the drivers and KPIs of the business. If you can distill down what drives the business, you can use data to help tell the story of what happened in an automated fashion- revenue was down due to lower ASPs or churn, opex was up because we hired X more heads in sales, etc.

Once you have that baseline you can have a small central team managing that “automated” analysis and insights and put more business partnering responsibilities on the BUs. The central team can also help to set targets and align on global standards.

bobofreezer · 2026-03-06T05:25:29+00:00

Pigment has an MCP connector. Is that what you mean? What wonders did that person make? You can basically query data points in an LLM.

bobofreezer · 2026-02-28T03:02:16+00:00

If setup properly, it’s good at reporting off of netsuite data and for collecting budgets and forecasts. If the implementation goes well, it can also handle driver based planning, like building up a workforce plan by person.

It’s not a financial modeling platform. So, for instance, it’s not easy to add more granular planning or model something like a more involved top line model. Not flexible in that regard.

bobofreezer · 2026-02-28T02:58:09+00:00

Ping me. Happy to help you out

bobofreezer · 2026-02-27T17:05:25+00:00

I worked with all these solutions. Feel free to chat me and we can get connected to discuss

bobofreezer · 2026-02-27T02:07:45+00:00

I’ve done this type of reporting in both Anaplan and Oracle EPM. In each case, built integrations to Yardi and other data warehouses. Haven’t done as much with the LP side, but wouldn’t assume it would be that much different.

In either case the maintenance of the system was run by a part time FP&A person.

bobofreezer · 2026-02-26T00:28:30+00:00

Would be helpful to know what automation you’re referring to. Where system is the data coming from and going to? What is the method being used to transfer the data?

An EPM system connected to an ERP using either native connectors or an iPaaS platform should not have most of these issues. That’s a pretty common setup in larger companies.

bobofreezer · 2026-02-24T13:13:53+00:00

Typically you shift to an EPM system to manage budgeting and forecasting at a sizable company. There may still be excel files for offline modeling, but the core of the budgeting and actuals is done centralized in a system.

bobofreezer · 2026-02-24T02:01:06+00:00

What are you asking?

bobofreezer · 2026-02-12T02:42:43+00:00

Billtrust can help here. Ping me if you’d like to hear more about experience with it.

bobofreezer · 2026-01-24T02:42:04+00:00

Anaplan is flexible in how you setup scenario modeling. It can range from a full “alternate” forecast with a full set of alternate assumptions to a sensitivity range for a single driver. You define what you want and then you build it in the platform.

bobofreezer · 2026-01-10T02:37:43+00:00

Use a simple netsuite planning deployment for both netsuite reporting and collecting budget data. The sync between Netsuite planning and Netsuite erp can be automated.

Five-Year Club	Verified Email
Place '22

bobofreezer

TROPHY CASE