Skip to content
  • There are no suggestions because the search field is empty.

Managing Allocations

This job aid contains instructions related to managing allocations in MYOB Acumatica.

Creating a Fixed Ratio Allocation Rule

  1. Open the Budgets (GL302010) form.
  2. In the Branch box, select the branch for which you want to prepare this budget.
  3. In the Ledger box, select a ledger of the Budget type for this new budget.
  4. In the Financial Year box, select the year of the budget you want to revise.
  5. Modify the amounts over the financial periods in each budget as follows:
    1. In the Budget Tree (left) pane, select the node for which you want to change the budget.
    2. In the Amount column of the Budget Articles (right) pane, change the amounts for the articles of the budgets you want to modify.
    3. In the Budget Articles (right) pane, click Distribute on the table toolbar.
    4. In the Distribute Year Amounts by Periods dialog box, select Evenly to distribute equal amounts to all periods.
    5. Select the Apply to All Articles in This Node check box to perform distribution for all articles in the selected node.
    6. Select the Apply to Subarticles check box to perform distribution within other nodes of the selected node.
    7. Click OK to close the dialog box and perform the distribution.
  6. On the form toolbar, click Save.
  7. Open the Release Budgets (GL505510) form to release the modified budget articles.

 

Creating an Allocation Rule Using a Dynamic Ratio

  1. Open the Allocations (GL204500) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New.
  2. On the form toolbar, click Add New Record.
  3. In the Description box, type a brief description of the allocation.
  4. Check the Branch box, and change the branch, if needed.
  5. On the Allocation tab, do the following:
    1. Check the Start Period box, which shows the first financial period when you can apply allocation.
    2. Select the End Period box to indicate the last financial period when you may apply the allocation.
    3. Select the Recurring check box if the allocation should apply each year for each of the specified periods.
    4. In the Distribution Method box, select one of the following:
      1. To distribute amounts between destination accounts of the destination branches proportionally to period-to-date balances of the destination accounts in the allocation ledger, select By Dest. Account PTD.
      2. To distribute amounts between the destination accounts of the destination branches proportionally to year-to-date balances of the destination accounts in the allocation ledger, select By Dest. Account YTD.
    5. In the Allocation Ledger box, select the ledger that posts the journal entries generated for the allocation.
    6. In the Source Ledger box, select the ledger from which the amounts to be allocated are calculated based on the accounts specified on the Source Accounts tab.
    7. Select the last date when someone made the revision of an allocation in the Last Revision Date box.
    8. On the Source Accounts tab, do the following for each account to be added to the rule:
      1. On the table toolbar, click Add Row.
      2. Check the Branch column, and change the branch, if needed.
      3. In the Account column, select the account that will be the source of the allocation amount.
      4. If required, in the Subaccount column, select the subaccount that will be the source of the allocation amount.
  6. On the Destination Accounts tab, do the following for each account to be added to the rule:
  7. On the table toolbar, click Add Row.
  8. Check the Branch column, and change the branch, if needed.
  9. In the Account column, select the account that will be the destination of the allocation amount.
  10. If needed, in theSubaccount column, select the subaccount that will be the destination of the allocation amount.
  11. On the form toolbar, click Save.

 

Creating an Allocation Rule Based on Budget or Statistical Data

  1. Open the Allocations (GL204500) form.
    To open the form for creating a new record, type the form ID in the Search box, and on the Search form, point at the form title and click New right of the title.
  2. On the form toolbar, click Add New Record.
  3. In the Description box, type a brief description of the allocation.
  4. Check the Branch box, and change the branch, if needed.
  5. On the Allocation tab, do the following:
    1. Check the Start Period box, which shows the first financial period when you can apply allocation.
    2. Select the End Period box to indicate the last financial period when you may apply the allocation.
    3. Select the Recurring check box if the allocation should apply each year for each of the specified periods.
    4. In the Distribution Method box, select one of the following:
      1. To distribute amounts between destination accounts of the destination branches proportionally to period-to-date balances of the destination accounts in the allocation ledger, select By Dest. Account PTD.
      2. To distribute amounts between the destination accounts of the destination branches proportionally to year-to-date balances of the destination accounts in the allocation ledger, select By Dest. Account YTD.
    5. In the Allocation Ledger box, select the ledger that posts the journal entries generated for the allocation.
    6. In the Source Ledger box, select the ledger from which the amounts to be allocated are calculated by the accounts specified on the Source Accounts tab.
    7. In the Base Ledger box, select the ledger that calculates the allocation proportions.
    8. Select the last date when someone made the revision of an allocation in the Last Revision Date box.
  6. On the Source Accounts tab, do the following for each account to be added to the rule:
    1. On the table toolbar, click Add Row.
    2. Check the Branch column, and change the branch, if needed.
    3. In the Account column, select the account that will be the source of the allocation amount.
    4. If required, in the Subaccount column, select the subaccount that will be the source of the allocation amount.
  7. On the Destination Accounts tab, do the following for each account to be added to the rule:
    1. On the table toolbar, click Add Row.
    2. Check the Branch column, and change the branch, if needed.
    3. In the Account column, select the account that will be the destination of the allocation amount.
    4. If needed, in the Subaccount column, select the subaccount that will be the destination of the allocation amount.
    5. In the Base Branch column, select the branch that will provide account balances to calculate the proportion for distributing the allocation amount between the destination accounts of the destination branches.
  8. In the Base Account column, select the account based on who's current PTD or YTD balances the system will distribute the allocation amount between accounts of the destination ledger.
  9. If needed, select the subaccount in the Base Subaccount column according to who's current PTD or YTD balances the allocation amount will distribute between the subaccounts of the destination ledger.
  10. On the form toolbar, clickSave.

 

Running Allocations

  1. Open the Run Allocations (GL504500) form.
  2. In the Allocation Date box, select the date of the allocation.
  3. In the Post Period box, check the financial period for which you want to view and process allocations, and change it, if needed.
  4. Do one of the following actions:
    1. Select the unlabelled check boxes next to the appropriate allocations in the list and click Process to run allocations.
    2. Click Process All to run all allocations for the period.