Allocation tips, notes, and FAQ

Top  Previous  Next

 

In this topic:

 

Allocations Tips & Notes...

Observing allocation "rules"

ManagePLUS Gold puts a few restrictions on "what can be allocated to what", so that your allocation formulas don't attempt to do illogical things. For instance, it doesn't make sense for a profit center to allocate to a cost center. Here's the list of the allocations that are allowed:

Accounts can allocate to cost centers and profit centers.
Cost centers can allocate to profit centers and to other cost centers, but not to their own children (sublevels).
Profit centers can allocate to their own children (sublevels) and to other profit centers.
Profit centers do not normally allocate to other profit centers. ManagePLUS Gold allows it, but only for flexibility. If you have the need to allocate from one profit center to a second profit center which isn't a child of the first one, then consider whether the first profit center should be re-designated as a cost center.

You don't need to give these rules much thought. ManagePLUS Gold makes it easy to observe them by preventing any allocations which don't fit within them.

Understanding how allocation works

Behind the scenes, how does allocation work?

When you add or edit allocation formulas, ManagePLUS Gold creates transactions to represent your allocations. ManagePLUS Gold automatically deletes and recreates these transactions as often as necessary to keep them current with your allocations. So you don't have to give them much thought.
They are included right along with your real transactions. You can view them in the Transactions window:  scroll to the bottom of the window, and you should see them. They are displayed in the allocation columns color so you can easily distinguish them from other transactions:

They accomplish the accounting necessary to distribute allocated amounts among your accounts, cost centers, and profit centers. ManagePLUS Gold understands the required debits and credits so you don't have to!
When you create a Profit Analysis report they are included the same as other transactions. Because they are based on an Other Expense account type, they appear toward the bottom of the report.
Allocation transactions are only included in the Profit Analysis report. They're ignored for other reports.
You may send the allocation transactions to QuickBooks and use them there for reporting or other purposes.

Error and warning colors

Here's a view of the OUT (allocated to others) column from the Classes window, showing the error and warning colors..

Red highlighting indicates a critical error, meaning that ManagePLUS Gold could not finish the allocation calculations. Usually this will be a circular reference error, in which case the cell will also display -CIRC-.
 
See the Circular Reference Error window topic for comments on fixing circular reference errors.
Orange highlighting indicates an error in one of the allocation formulas of a cell. To see details about what's wrong, double-click the cell to open it's Allocated OUT (to others) dialog.

 A bad allocation formula is just a warning condition, not an error, because ManagePLUS Gold ignores formulas that contain errors...except for circular reference errors, described above.

"If ManagePLUS Gold prevents me from entering bad allocation formulas. How could I ever have one?"

While ManagePLUS Gold won't let you enter illegal allocation formulas, they can result from other changes in your accounting data. A common example, is when an allocation formula points to a class name which no longer exists after you've refreshed classes.

Frequently Asked Questions (FAQ)

"Income and expense seem to appear as positive OR negative amounts in the Classes window. Can you explain why?"

Normally, profit centers and cost centers both display positive balances in Allocation Information columns like Available to Allocate. In that normal case a positive amount for a profit center represents income, while a positive amount for a cost center represents expense.

But the amounts displayed for profit centers and cost centers are net amounts, so if the normal income/expense relationship is reversed, amounts will display as negative:  if the expense associated with a profit center is greater than its revenue, its net income will be negative; and so, amounts displayed for the profit center will likewise be negative.

And the reverse is true for cost centers:  if the amount associated with a cost center is positive—implying net income instead of the usual net expense—then the cost center's amounts will be negative (because income is the opposite of the cost center's usual expense balance).

"Amounts in the Allocation Information columns (of the Classes window) keep changing. Why?"

As you work with the allocation features keep in mind that allocation formulas are defined as percentages of the amounts available, never a specific dollar amount. So whenever the amount available to allocate changes for a class, so will the dollar amounts it allocates to other classes. And because those other class may allocate to yet more classes, changes often ripple through quite a bit of the Allocation Information section of the Classes window.

What things can cause the dollar amounts allocated to change?

If you enter new transactions or change the dollar amount of any transaction in QuickBooks, then refresh transactions in ManagePLUS Gold, the amounts available to allocate will change, possibly affecting many columns.
If you change an allocation formula, that change may likewise ripple through many columns.
Think of allocated dollar amounts as only a "snapshot" of allocations based on the current set of QuickBooks transactions in ManagePLUS. Any change in the transactions or your allocation formulas will cause the dollar amounts allocated to change.

"So what are we really allocating here...expense, or income, or both?"

Allocation formulas are essentially based on percentages. They allocate a portion of whatever net amount is available to allocate from the source item (account or class). While this is typically a negative (expense) amount, it can be a net positive (income) amount, which in that case would result in allocating income to the target classes.

"Huh?"

Well, take for example a cost center class like Equipment:Combine. That class normally just accumulates expenses for owning and operating a combine:  fuel, oil, repairs, depreciation, and so on. Allocations from Equipment:Combine to other classes then, will typically be allocating combine-related expense.

But what if you happen to do a lot of custom harvesting with the combine this year? When you enter your custom harvesting income in QuickBooks you will assign the Equipment:Combine class to those transactions, and it's possible that you may earn enough income from custom harvesting to more than offset it's operating costs. The result? The net amount available to allocate from Equipment:Combine will be positive, not negative. So in that case the same set of allocation formulas for Equipment:Combine would be allocating a income amounts to the target classes, not expense.

When a cost center has somewhat taken on the nature of a profit center, should you designate it as a profit center in ManagePLUS Gold? Not necessarily. It all depends on your management goals and perspectives. If Equipment:Combine's usual purpose is to accumulate costs for allocation to profit centers, then you may want to keep it as a cost center. But if the nature of the activity represented by Equipment:Combine has changed so that custom harvesting is now a major focus, then you may want to consider designating Equipment:Combine as a profit center.

"Why do I have to identify classes as cost centers and profit centers?"

You must identify classes as cost centers or profit centers to support ManagePLUS Gold's internal rules for how accounts, cost center classes, and profit center classes can be allocated. These rules (1) help prevent errors on your part, such as circular references, and (2) make allocations simpler for you by allowing ManagePLUS Gold to automate some things—such as automatically accumulating child-level amounts to parent levels for cost center classes.

Here are the basic rules:

Accounts can allocate income or expense to cost centers and/or profit centers.
Cost centers can allocate to other cost centers and/or profit centers, but not to their own sublevels (i.e., their own subclasses, or "children").
Profit centers can allocate to other profit centers and to their own sublevels (i.e., subclasses, or "children"), but not to their parent classes.

The reasons behind some of these rules will become more apparent as you begin using ManagePLUS Gold.

"Once I've set up a class as a cost center or profit center can I change it?"

Yes. Just select a different type for it in the Alloc. Type column of the Classes window. You may select the None type if you no longer want the class to participate in allocations or be used in Profit Analysis reports.

Changing the type of a class can cause allocation formula errors. For instance, suppose you have an allocation formula which allocates expense from an account to a class of the Profit center type. If you change that class' type to None the formula will then be illegal (you cannot allocate to a class of the None type). ManagePLUS Gold helps you find these errors by displaying cells with illegal formulas in the warning color (orange, by default).