Allocate recurring costs and income

You can allocate an entry in a recurring general journal to several accounts when you post the journal. To learn more about recurring general journals, go to Work with recurring journals.

The following allocation methods are available:

  • Allocation Quantity: Distribute the amount in proportion to the quantities on the allocation lines.
  • Allocation %: Distribute the amount using the percentage on each allocation line.
  • Amount: Specify a fixed allocation amount in local currency.

Fixed asset transactions also support allocations, which you set up separately through fixed asset posting groups.

The following procedures describe how to prepare to allocate costs in a recurring general journal by defining allocation keys. When you define allocation keys, you complete and post the journal like any other recurring general journal. Learn more in Work with General Journals.

Important


Allocation Accounts aren't supported in recurring journals. While the Allocation Account option is available in the Account Type field on the lines of the journal, this option isn't supported. Instead, use the allocations feature as described in this article.

If you defined allocation accounts in a previous version of Business Central, update the setup to use allocations.

To set up allocation keys

You can allocate an entry in a recurring general journal to several different accounts when you post the journal. The allocation can be a quantity, percentage, or amount.

  1. Select Search (Alt+Q) in the upper-right corner, enter Recurring General Journals, and then choose the related link.
  2. Choose the Batch Name field to open the General Journal Batches page.
  3. Select an existing batch, or choose New to create one. For a new batch, fill in Name, such as CLEANING, and Description, such as Cleaning Expenses Journal.
  4. Close the General Journal Batches page to return to the journal. Select an existing journal line or create a new line and fill in its fields. Allocations apply to the selected line, not to the whole batch.
  5. Choose the Allocations action.
  6. Add a line for each allocation. Fill in Account No. and either Allocation %, Allocation Quantity, or Amount.
  7. To allocate among dimensions, select an allocation line, choose Dimensions, and assign the dimension values.
  8. For percentage or quantity allocations, review the automatically calculated Amount on each allocation line. These amounts have the opposite sign from Amount (LCY) on the recurring journal line.
  9. Choose OK to return to the Recurring General Journals page. Review Allocated Amt. (LCY), which shows the total allocation amount in local currency. For a fully allocated line without a balancing account, this total must offset Amount (LCY).
  10. Post the journal.

To change an allocation key that is already set up

  1. Select Search (Alt+Q) in the upper-right corner, enter Recurring General Journals, and then choose the related link.
  2. In Batch Name, select the batch that contains the journal line.
  3. Choose the line with the allocation, and then choose the Allocations action.
  4. Change the relevant fields, and then choose OK.

Closing Years and Periods
Work with General Journals
Posting Documents and Journals
Work with Business Central

Find free e-learning modules for Business Central here