Study guide
9.3 Recurring General Journals & Allocation Methods
Microsoft Dynamics 365 Business Central Functional Consultant MB-800
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Company Creation & Data Migration
1.1 Creating Companies & Assisted Setup Wizards 1.2 Configuration Packages & RapidStart Worksheets 1.3 Opening Balances & Data Migration Strategies
2 Chapter 2: Security, Profiles & Auditing
2.1 Users, User Setup & Role Center Profiles 2.2 Permission Sets & Security Group Management 2.3 Security Filters, Change Log & Security Auditing
3 Chapter 3: Core System Configuration, Number Series & Copilot
3.1 Company Information, Number Series & Job Queues 3.2 Report Layout Management & Copilot AI Capabilities
4 Chapter 4: Dimensions Architecture & Governance
4.1 Dimension Concepts & Dimension Values 4.2 Global Dimensions vs Shortcut Dimensions 4.3 Default Dimensions, Combinations & Priorities
5 Chapter 5: Workflows & Approvals
5.1 Native Workflow Templates & Approval Hierarchy 5.2 Workflow User Groups & Notification Configuration
6 Chapter 6: Financial Setup, Periods & Currencies
6.1 General Ledger Setup & Accounting Periods 6.2 Payment Terms, Payment Methods & Deferrals 6.3 Multi-Currency Setup & Exchange Rates
7 Chapter 7: Chart of Accounts, Categories & Allocations
7.1 Chart of Accounts Structure & G/L Account Cards 7.2 Account Categories, Subcategories & Financial Reporting 7.3 General Ledger Allocation Accounts & Sharing
8 Chapter 8: Posting Groups & Posting Setup
8.1 Specific Posting Groups: Customer, Vendor, Bank & Inventory 8.2 General Posting Groups & General Posting Setup Matrix 8.3 Inventory Posting Setup & Alternative Posting Groups
9 Chapter 9: General Journals & Recurring Methods
9.1 Bank Account Cards & Posting Setup 9.2 General Journal Templates, Batches & Number Series 9.3 Recurring General Journals & Allocation Methods
10 Chapter 10: Accounts Payable & Accounts Receivable Setup
10.1 Purchases & Payables Setup & Vendor Master 10.2 Sales & Receivables Setup & Customer Master 10.3 Payment Journals, Cash Receipts & Payment Registration Setup
11 Chapter 11: Fixed Assets Setup & Depreciation Books
11.1 Fixed Asset Setup, Classes & Depreciation Books 11.2 Fixed Asset Cards, Main/Component Assets & Depreciation Methods
12 Chapter 12: Inventory Setup, Costing & Locations
12.1 Inventory Setup, Item Types, Categories & Variants 12.2 Costing Methods (FIFO, LIFO, Average, Standard) & Ledger Architecture 12.3 Locations, Transfer Routes & Stockkeeping Units (SKUs)
13 Chapter 13: Logistics Master Data, Pricing & Discounts
13.1 Shipping Agents, Locations & Vendor Lead Times 13.2 Sales Prices, Purchase Prices & Price Lists 13.3 Line Discounts, Invoice Discounts & Thresholds
14 Chapter 14: User Interface, Views, Inspection & Excel
14.1 Personalization, Profile Customization & Designer 14.2 Searching, Advanced Filters, Saved Views & Page Inspection 14.3 Edit in Excel, OneDrive & Data Analysis Mode
15 Chapter 15: Purchase & Sales Order Execution
15.1 Purchase Orders, Receiving, Over-Receipt & Undo 15.2 Purchase Invoicing, Recurring Lines & Blanket Orders 15.3 Sales Quotes, Availability Checks & Order Conversion 15.4 Sales Shipping, Invoicing, Undo & Blanket Orders
16 Chapter 16: Invoices, Credit Memos & Document Corrections
16.1 Direct Invoices, Credit Memos & Document Reopening 16.2 Correct, Cancel & Corrective Credit Memo Procedures 16.3 Combined Shipments/Receipts & Prepayment Workflows
17 Chapter 17: Cash Management, Bank Reconciliation & Ledger Applications
17.1 Processing Payment Journals & Cash Receipt Registrations 17.2 Applying, Unapplying & Reversing Customer/Vendor Entries 17.3 Bank Account Reconciliation & Statement Matching Rules
18 Chapter 18: Operational Adjustments, Inventory & Asset Accounting
18.1 Exchange Rate Adjustments & Dimension Corrections 18.2 Inventory Adjustments, Transfers & Physical Counting 18.3 Fixed Asset Acquisitions, Depreciation Runs & Disposals
9.3 Recurring General Journals & Allocation Methods
Key Takeaways Explain This Topic AI
Recurring General Journals (Page 283) retain journal lines after posting, advancing the Posting Date according to the Recurring Frequency date formula (e.g., 1M, 1Q, CM).
The six Recurring Methods govern line behavior: Fixed (preserves amount), Variable (clears amount), Balance (allocates account balance), and their respective Reversing counterparts (RF, RV, RB).
Reversing methods (RF, RV, RB) post the primary accrual on the designated Posting Date and automatically generate an exact offsetting reversal entry dated Posting Date + 1D.
Dynamic Document No. replacement wildcards (%1 day, %2 week, %3 month name, %4 month number, %5 year) dynamically generate unique document identifiers on recurring postings.
The Allocations subpage (Page 284) distributes recurring amounts across multiple G/L accounts and dimension combinations using either percentage allocation or shares weighting.
Last updated: September 2026
9.3 Recurring General Journals & Allocation Methods
Quick Summary: Recurring General Journals (Page 283) streamline repetitive financial postings, such as monthly rent, prepaid expense amortizations, and payroll accruals. Unlike standard journals, lines in recurring journals are retained after posting, with their Posting Date automatically advanced by a Recurring Frequency date formula (e.g., 1M , 1Q , CM+1D ). Business Central provides six Recurring Methods : Fixed (preserves line amounts), Variable (clears amounts to zero), Balance (transfers full account balances), and three automated reversing methods ( RF , RV , RB ) that post an exact offsetting reversal on Posting Date + 1D . Complex overhead costs can be distributed across multiple accounts and dimensions using the Allocations subpage via percentages or relative shares.
Recurring Journal Architecture & The Template Setup
A recurring journal is a specialized general journal designed for transactions that recur with predictable periodicity. In the underlying application schema, recurring journals utilize the same table as standard journals (Table 81 Gen. Journal Line ), but operate under a General Journal Template where the Recurring field is set to Yes . UI Navigation Path:
Tell Me (Alt+Q) -> Recurring General Journals (opens Page 283)
When Recurring = Yes on the template, Business Central reveals specialized recurring columns on the journal grid:
Recurring Method: Determines how line amounts and reversal entries behave upon posting.
Recurring Frequency: A Business Central date formula controlling how far forward the Posting Date advances after each post.
Expiration Date: An optional cutoff date that terminates recurring posting.
Allocations: An action link opening Page 284 to distribute amounts across multiple accounts and dimensions.
Unlike standard journals—which purge lines from the grid upon successful posting—recurring journals retain all posted rows in the worksheet, updating dates and document numbers in place ready for the next period's processing.
The Six Recurring Methods in Detail
A central focus of the MB-800 certification exam is mastering the operational mechanics of the six Recurring Methods :
Code Recurring Method Name Line Amount Behavior After Posting Automatic Reversal Entry Created? Primary Accounting Use Case
F Fixed Amount is retained unchanged on the journal line. No Constant recurring charges: monthly building rent, fixed software subscriptions, straight-line equipment lease amortizations.
V Variable Amount is cleared to zero (erased) on the journal line. No Periodic expenses with fluctuating amounts: monthly utility invoices, metered cloud infrastructure costs, hourly contractor fees. Accounts and dimensions stay intact; user inputs the new amount next month.
B Balance Amount is dynamically calculated as the full account balance at posting time; line amount is cleared to zero after posting. No Zero-balance account clearing: sweeping accumulated utility expense balances to corporate overhead, or clearing intermediate clearing accounts to retained earnings.
RF Reversing Fixed Amount is retained unchanged on the journal line. Yes (Automated reversal posted on Posting Date + 1D ). Fixed month-end accruals: fixed monthly audit fee accruals, recurring fixed bonus accruals, or standard monthly warranty provisions requiring automatic day-one reversals.
RV Reversing Variable Amount is cleared to zero on the journal line. Yes (Automated reversal posted on Posting Date + 1D ). Variable month-end accruals: estimated freight-in expenses, unbilled vendor receipts, estimated utility accruals where amounts fluctuate each month.
RB Reversing Balance Amount is dynamically calculated as the account balance at posting; line amount is cleared to zero after posting. Yes (Automated reversal posted on Posting Date + 1D ). Balance-driven month-end adjustments: accruals based on end-of-period subledger account balances that must be reversed immediately on the first day of the subsequent fiscal period.
Note
When using B (Balance) or RB (Reversing Balance) methods, the Amount field on the journal line is left blank by the user. At the moment of posting, Business Central evaluates the net cumulative balance of the account specified in Account No. and posts that exact amount to clear or allocate the account.
Recurring Frequency & Date Formula Syntax
The Recurring Frequency field dictates how Business Central updates the Posting Date on the journal line once the transaction is committed. It uses standard Business Central date formula syntax: Date Formula Construction Syntax:
- [Quantity / Multiplier] + [Time Unit Code]
- e.g., '1M' -> Exactly 1 Calendar Month forward
- '1Q' -> Exactly 1 Calendar Quarter forward
- '1Y' -> Exactly 1 Calendar Year forward
- '2W' -> Exactly 2 Calendar Weeks forward
- Advanced Date Formulas for Financial Closes
1M (One Month): If the current Posting Date is 01/15/2026 , posting advances the date to 02/15/2026 . However, if the date is 01/31/2026 , adding 1M advances the date to 02/28/2026 (or 02/29 in leap years). Adding 1M again will advance to 03/28/2026 , which may drift from month-end.
CM (Current Month - End of Month): Resolves dynamically to the final calendar day of the current month. If Posting Date is 01/15/2026 , CM evaluates to 01/31/2026 .
1M+CM (End of Next Month): Guarantees that the posting date always lands on the true final calendar day of the subsequent month (e.g., 01/31/2026 -> 02/28/2026 -> 03/31/2026 ), preventing date drift.
CM+1D (First Day of Next Month): Evaluates to the first day of the following month (e.g., 01/31/2026 -> 02/01/2026 ). Ideal for recurring opening amortizations.
Expiration Date Governance
The Expiration Date field establishes a hard terminal boundary for the recurring line:
If a recurring line has Expiration Date = 12/31/2026 , the line can post up to and including December 31, 2026.
If a user attempts to post the batch when the line's Posting Date exceeds 12/31/2026 , Business Central ignores or blocks the line, preventing expired contracts or completed amortizations from posting into future periods.
Dynamic Document Numbering Wildcard Formulas
Because recurring journal lines post repeatedly across multiple months, hardcoding a static Document No. (e.g., RENT2026 ) would result in duplicate document number violations on subsequent postings. To automate sequential document identification, Business Central provides five dynamic text replacement wildcards in the Document No. field:
Wildcard Date Component Replaced Value Range / Output Example Format String Evaluated Output (for Posting Date 09/30/2026)
- %1 Current Day Number 1 to 31 RENT-%1 RENT-30
- %2 Current Week Number 1 to 53 WAGE-WK%2 WAGE-WK40
- %3 Current Month Name Full text: January to December ACCR-%3-%5 ACCR-September-2026
- %4 Current Month Number 1 to 12 LEASE-%4-%5 LEASE-9-2026
- %5 Current Year (Four Digits) 2026 INS-%4/%5 INS-9/2026
When the journal posts, Business Central evaluates the line's Posting Date , substitutes the wildcards with their real-time calendar values, stamps the generated string onto the resulting ledger entries, and leaves the wildcard formula intact on the recurring journal line for the next cycle.
Reversing Entry Mechanics & Ledger Auditing
Month-end financial closing frequently requires recording accrued expenses (e.g., unbilled legal services or estimated utility usage) to ensure expenses match revenues within the proper accounting period. In the subsequent period, these accruals must be reversed to prevent double-counting when actual vendor invoices arrive.
When a user posts a line using RF , RV , or RB : Reversing Entry Posting Mechanics:
- Journal Line: Method = RV | Posting Date = 09/30/2026 | Amount = $1,200 | Frequency = 1M
- │
- ▼
- [User Clicks Post]
- │
- ┌───────────────────────────┴───────────────────────────┐
- ▼ ▼
- [Primary Accrual Entry] [Automatic Reversal Entry]
- Posting Date: 09/30/2026 - Posting Date: 10/01/2026 (Posting Date + 1D)
- G/L Account: 61100 (Legal Exp) -> Debit $1,200 - G/L Account: 61100 (Legal Exp) -> Credit $1,200
- G/L Account: 20500 (Accrued Liab) -> Credit $1,200 - G/L Account: 20500 (Accrued Liab) -> Debit $1,200
- System Flags: Normal Posting - System Flags: Reversal = YES
- │ │
- └───────────────────────────┬───────────────────────────┘
- ▼
- [Both entries committed under the EXACT SAME G/L Register No.]
- │
- ▼
- [Journal Line Updates in Grid]
- Posting Date advances to: 10/31/2026 (09/30 + 1M)
- Amount resets to: 0.00 (because Method was Variable)
- Auditing the Reversal
Posting Date Calculation: The reversal entry is stamped with Posting Date + 1D (the immediate following calendar day).
Atomic Transaction Integrity: Both the primary entry and the reversal entry are written during the same posting execution and are cataloged under the exact same G/L Register record ( Table 45 G/L Register ).
Audit Flags: In the G/L Entry table, the reversal entry is flagged with Reversal = Yes , maintaining full transparency for external auditors.
The Allocations Subpage: Multi-Account & Multi-Dimensional Distribution
Organizations frequently incur lump-sum recurring costs—such as corporate headquarters rent, building insurance, or software licenses—that must be split across multiple departmental cost centers or operating subsidiaries.
Rather than manually calculating separate journal lines, consultants utilize the Allocations subpage (Page 284 / Table 221 Gen. Jnl. Allocation ). UI Navigation Path:
Recurring General Journal -> Select Line -> Action: Line -> Allocations (opens Page 284) Allocations Distribution Architecture:
- Recurring Journal Line: Corporate Rent Expense ($10,000.00)
- └── Allocations Subpage
- ├── Line 1: G/L 61100 (Rent-Sales) | Dept: SALES | Allocation %: 50% -> $5,000.00
- ├── Line 2: G/L 61200 (Rent-Mktg) | Dept: MKTG | Allocation %: 30% -> $3,000.00
- └── Line 3: G/L 61300 (Rent-Admin) | Dept: ADMIN | Allocation %: 20% -> $2,000.00
- Allocation Calculation Methods
The Allocations subpage provides two mathematical distribution mechanisms:
Allocation % (Percentage):
Users key in exact percentage allocations per line (e.g., 50 , 30 , 20 ).
The sum of the Allocation % column must equal 100.00% before posting.
Business Central calculates each line's dollar share: Line Amount = Total Parent Amount * (Allocation % / 100) .
Shares (Weighting / Ratio):
Used when expenses are distributed based on headcount, square footage, or dynamic ratios.
Users enter relative integers or decimals in the Shares column (e.g., Sales: 5 shares, Marketing: 3 shares, Admin: 2 shares -> Total Shares = 10).
Business Central dynamically calculates each line's percentage: Line Percentage = (Line Shares / Total Shares) * 100 .
This eliminates rounding errors and manual recalculations when headcount or square footage figures fluctuate.
Dimension Assignment on Allocations
Every allocation line can specify independent Dimension Values (such as Department, Customer Group, or Project). When the recurring journal posts, Business Central debits each allocated G/L account and stamps the respective dimension values, ensuring that financial reporting dashboards (such as Financial Reports / Account Schedules) reflect accurate cost center breakdowns.
Common Implementation Pitfalls & Exam Traps
Implementation Issue Root Cause System Impact Corrective Action
Posting Date Drift Across Months Setting Recurring Frequency to 1M on month-end dates (e.g., 01/31 + 1M = 02/28 ; 02/28 + 1M = 03/28 ). After February, month-end recurring entries post on the 28th of every subsequent month instead of the true last day. Configure the Recurring Frequency as 1M+CM to force Business Central to advance to the exact end of every month.
Accidental Over-Amortization Leaving the Expiration Date field blank on lease or loan amortization lines. The recurring batch continues posting indefinitely month after month past the contract termination date. Always enter the contract expiration date in the Expiration Date field on the journal line.
Duplicate Document Number Errors Entering a static text string (e.g., RENT ) in Document No. without wildcard variables. The first month posts successfully; the second month fails with: "Document No. RENT already exists in G/L Entry." Use dynamic wildcard formulas such as RENT-%4-%5 so that document numbers change dynamically each period.
Allocations Percentage Sum Discrepancy The sum of values in the Allocation % column on Page 284 totals 99.5% or 100.5%. Business Central blocks posting with a validation error indicating that total allocations do not equal 100%. Re-adjust percentages to equal exactly 100.00%, or use the Shares method to let Business Central calculate exact ratios.