Recurring General Journals are designed to simplify the posting of regularly recurring transactions. Unlike Standard Journals, which copy journal lines into a batch when selected, recurring journals retain transaction lines in the journal and automatically prepare them for future postings.
Common uses include:
- Monthly rent entries
- Prepaid expense allocations
- Month-end accruals
- Other regularly recurring accounting transactions
Recurring journals can significantly reduce data entry and improve consistency for repeatable transactions.
Understanding key recurring journal fields
Several fields control how recurring journals behave:
Recurring method
The recurring method determines how amounts are handled after posting. Common options include:
- Fixed: Keeps amounts unchanged after posting.
- Variable: Clears the amount field after posting so a new amount can be entered.
- Balance: Allocates entered amounts across predefined lines.
- Balance by Dimension: Allocates amounts while considering dimensions.
Each option also includes reversing versions that automatically create reversing entries on the following day.
Recurring frequency
Recurring frequency determines how often the journal recurs using date formulas such as:
- D = Day
- M = Month
- Q = Quarter
For example, "1M" advances the journal to the same point in the following month after posting.
Document numbers
Document numbers can use shortcuts such as "%4" to automatically insert the month name into the document number, making recurring transactions easier to identify and filter.
Expiration date
An expiration date can be assigned to stop recurring entries after a specific date, preventing unintended postings beyond a defined period.
Example 1: monthly rent journal
A rent payment is a common example of a fixed recurring journal. In this scenario:
- The rent amount remains the same each month.
- The recurring method is set to Fixed.
- The recurring frequency is set to 1M.
- After posting, all journal lines remain unchanged.
- The posting date automatically advances to the next month.
Business Central automatically adjusts month-end dates appropriately. For example, a posting date of January 31 advances to February 28 and then March 31.
Example 2: expense allocation journal
Variable recurring journals are useful when the total amount changes each month, but the allocation percentages remain the same. In this example:
- A total expense amount is entered.
- Allocation lines distribute the amount using predefined percentages.
- After posting, the amount field is cleared.
- Allocation percentages remain in place for future use.
For example, if a $5,000 expense is allocated 40% to a department, the system automatically calculates a $2,000 allocation. If the next month's expense is $10,000, the allocation automatically updates to $4,000 using the same percentage.
Example 3: month-end accruals
Month-end accruals often require automatic reversals. Using a reversing variable method:
- The accrual posts at month end.
- The reversing entry automatically posts the following day.
- Amounts are cleared after posting so new values can be entered for the next period.
A recurring frequency formula can be configured to ensure:
- Accruals always post on the last day of the month.
- Reversals always post on the first day of the following month.
Reviewing posted activity
After posting recurring journals, users can review transactions through General Ledger Registers and posted entries. This allows users to:
- Verify original postings
- Confirm allocation calculations
- Review reversing entries
- Validate recurring journal behavior across accounting periods
Key takeaways
Recurring General Journals help automate frequently posted transactions while maintaining flexibility for changing amounts and allocations. By leveraging fixed, variable, allocation, and reversing methods, organizations can reduce manual data entry, improve consistency, and streamline recurring accounting activities in Business Central.
