5.6 Allocation Processing & Periodic (Recurring) Journals

5.6 Allocation Processing & Periodic (Recurring) Journals

Quick Summary: Running an allocation rule produces either a draft journal for review or a posted journal, and the choice is made on the allocation request. This section also covers periodic journals — the recurring-entry template used for fixed monthly postings — and when to reach for each tool.

---

1. Step-by-Step Configuration & Processing Workflow

Executing allocation rules in Dynamics 365 Finance follows a structured end-to-end operational lifecycle.

+---------------------------------------------------------------------------------------+
|                      Ledger Allocation End-to-End Processing Workflow                 |
+---------------------------------------------------------------------------------------+
|  Step 1: Configure Allocation Journal Name (Type: Allocation)                         |
|  Step 2: Define Ledger Allocation Rule (Source, Destination, Offset, Method)          |
|  Step 3: Assemble Rules into Ledger Allocation Rule Sets (Sequential Execution)       |
|  Step 4: Execute 'Process Allocation Request' (Proposal Batch)                        |
|  Step 5: Review & Post Generated Voucher in Allocation Journals Workspace             |
+---------------------------------------------------------------------------------------+

Step 1: Journal Name Setup

• Navigate to General ledger > Journal setup > Journal names.
• Create a new record: Name = ALLOC-MO, Journal type = Allocation, Voucher series = VCH_ALLOC.

Step 2: Rule Configuration

• Navigate to General ledger > Allocations > Ledger allocation rules.
• Configure Header, Source, Destination, and Offset parameters as detailed in Section 1.

Step 3: Ledger Allocation Rule Sets (Chained Execution)

• Path: General ledger > Allocations > Ledger allocation rule sets
• When multiple allocation rules must execute in a strict chronological sequence (e.g., Rule 1: Allocate IT costs to Administration and Operations; Rule 2: Allocate total Administration costs across product lines), group the rules into a Rule Set and define their sequential line order.

Step 4: Processing the Allocation Request

• Path: General ledger > Allocations > Process allocation request
• Enter processing parameters:
  • Rule or Rule set: Select the target allocation rule or set.
  • From date & To date: The date range used to calculate the source pool balance.
  • Total allocation date (Transaction date): The accounting date stamped on the generated allocation journal vouchers.
  • Proposal options:
    • Proposal only (Recommended): Generates an unposted draft Allocation Journal for accountant review.
    • Post only: Automatically posts the generated vouchers directly to the General Ledger without user intervention.

Step 5: Review and Post

• Navigate to General ledger > Journal entries > Allocation journals.
• Open the generated journal lines, verify calculated debits and offset credits, and click Post.

---

2. Periodic Journals (Recurring Entry Master Templates)

While Ledger Allocation Rules calculate variable distributions, Periodic Journals manage static, predictable recurring transactions (e.g., monthly prepaid software amortizations, equipment lease accruals, insurance expense distributions).

Navigation & Template Setup

• Path: General ledger > Periodic tasks > Periodic journals
• Create a Periodic Journal header and enter recurring lines (Account, Offset Account, Amount, Description). Periodic journals do not post directly to the ledger; they serve strictly as recurring master templates.

+-----------------------------------------------------------------------------+
|                   Periodic Journal Template: PJ-PREPAY                      |
+-----------------------------------------------------------------------------+
| Line 1: Main Account: 620500 (Software Amort) | Debit:  $2,500.00           |
|         Offset Account: 140100 (Prepaid Exp)  | Credit: $2,500.00           |
+-----------------------------------------------------------------------------+
                                      |
                      [ Month-End Journal Processing ]
                                      |
                                      v
+-----------------------------------------------------------------------------+
|                  General Journal Entry: JB-000600 (August Close)            |
+-----------------------------------------------------------------------------+
| Click: 'Period journal > Retrieve journal'                                  |
| - Selected Periodic Journal: PJ-PREPAY                                      |
| - Operation: [ Copy ] (Preserves template) vs. [ Move ] (Deletes template)  |
| - Recurrence: Unit = Months, Count = 1                                      |
| - Expiration Date: 2027-12-31                                               |
+-----------------------------------------------------------------------------+

Retrieving Periodic Journals into General Journals

1. Create a standard General Journal (General ledger > Journal entries > General journals) and open Lines.
2. In the Action Pane, click Period journal > Retrieve journal.
3. Configure retrieval parameters:
   • Periodic journal: Select the master template ID (e.g., PJ-PREPAY).
   • Operation:
     • Copy (Best Practice): Copies the template lines into the current general journal while keeping the periodic journal template intact for future months.
     • Move: Transfers the lines into the general journal and permanently deletes them from the periodic journal template.
   • Recurrence Unit & Count: Sets the frequency interval (e.g., Unit = Months, Count = 1 for monthly recurrence).
   • Expiration date: The date after which the template can no longer be retrieved.

3. Exam Traps & Real-World Best Practices

[!WARNING] Exam Trap: Periodic Journal 'Copy' vs. 'Move' When retrieving lines from a Periodic Journal into a General Journal, selecting Move transfers the lines and instantly deletes them from the periodic journal template. Candidates answering MB-310 scenario questions regarding recurring monthly expenses must select Copy so the periodic template remains available for subsequent months.

[!IMPORTANT] Consultant Pro-Tip: Dedicated Allocation Offset Accounts When configuring the Offset FastTab on a Ledger Allocation Rule, avoid crediting the original operational expense account directly. Instead, credit a dedicated Allocation Offset Account (e.g., 620199 - Rent Allocation Offset). This preserves the gross debits on the primary expense account for audit transparency and managerial variance reporting.

4. Periodic Journals in Depth

A periodic journal is a stored journal template that is retrieved into a working journal each period. It is the standard tool for entries whose amount and accounts do not change: prepaid amortisation, fixed monthly accruals, standing rent charges.

Configure at General ledger > Journal entries > Periodic journals.

The Retrieve Workflow

1. Create a new general journal for the period.
2. On the journal lines, choose Periodic journal > Retrieve journal.
3. Select the template number and confirm the posting date.
4. The template's lines are copied into the working journal, where they can still be edited.
5. Post. The template's last posting date advances and the next posting date rolls forward.

Because the lines are copied, editing them in the working journal does not change the template — a common source of confusion when someone adjusts one month's amount and expects it to stick.

5. Periodic Journals vs. Allocation Rules vs. Accrual Schemes

The distinguishing question on the exam is always does the amount change? A fixed repeating amount is a periodic journal. A split that must follow shifting actuals is an allocation rule with the Basis method. A one-off amount that must be spread forward from a single journal line is an accrual scheme.

Exam trap: Retrieving a periodic journal does not post it. The retrieved lines sit in an unposted journal and are still subject to journal control, posting restrictions, and validation. A scenario in which "the recurring entry did not appear in the general ledger" is usually an un-posted retrieved journal, not a broken template.