Recurring journals for repeat entries in Business Central
Recurring journals in Business Central hold entries that you post again and again, such as rent, accruals and overhead splits. So nobody retypes them each period. The lines stay in the batch after posting, and the posting date moves forward by itself. This guide explains the recurring methods, the frequency formula, allocations and a safe posting routine.
Last updated
What recurring journals in Business Central do
Search for Recurring General Journals. The page looks like a general journal with extra columns. These are Recurring Method, Recurring Frequency and Expiration Date. You enter a line once, with its account, amount, dimensions and description. When you post, the entry goes to the ledger, but the line stays for the next period.
After posting, Business Central adds the frequency to the posting date. So a line you post at the end of one month already carries the date for the end of the next. Batches keep related lines together. For example, use one batch for accruals and another for allocations.
Ask about recurring entries →
- ✓Rent and lease charges
- ✓Monthly accruals
- ✓Prepaid expense release
- ✓Overhead splits by department
- ✓Standing intercompany charges
Pick the right method for recurring journals in Business Central
The Recurring Method field decides what happens to the amount. Fixed keeps the amount after posting, which suits rent. Variable clears the amount, so you type a new figure each period. That suits a utility bill. Balance posts the full balance of the account on the line to the accounts you list as allocations.
Each of the three has a reversing twin. Reversing Fixed, Reversing Variable and Reversing Balance post the entry and then post its opposite on the following day. That is exactly what an accrual needs at month end. Newer versions add balance methods that work for each dimension value.
Match methods to entries →- ✓Fixed for steady amounts
- ✓Variable for changing bills
- ✓Balance to clear an account
- ✓Reversing Variable for accruals
- ✓Reversing Fixed for estimates
Frequency, expiry and document numbers
Recurring Frequency takes a date formula. 1M moves the date on by one month, and 1W by one week. For month-end entries, many teams use a formula that lands on the last day of the following month. Then a line dated the end of January does not drift to the twenty-eighth after February.
Expiration Date tells Business Central when to stop. It skips a line whose posting date is past its expiry. That is a tidy way to end a fixed-term lease charge. If the batch has a posting number series, the system assigns document numbers at posting. So you do not renumber lines each period.
Set up your date formulas →- ✓Posting Date of next run
- ✓Recurring Frequency formula
- ✓Expiration Date where needed
- ✓Document number or series
- ✓Description the auditor understands
Allocations in recurring journals in Business Central
Select a line and choose Allocations. On the Allocations page, list the accounts and dimension values that should receive the amount. Give each one a share or a quantity. When the line posts, Business Central creates the balancing entries for you. So one insurance bill can land across five departments.
With a balance method, the line reads the account balance at posting and moves all of it to the allocation lines. That is how you empty a clearing account each month. If you reuse the same split on purchase invoices, an allocation account may be the better tool.
Design your cost splits →- ✓Receiving G/L account
- ✓Department or project dimension
- ✓Share of the amount
- ✓Quantity based split
- ✓Posting groups when required
A posting routine for recurring journals in Business Central
Treat the recurring batches as a checklist item in the close. Open each batch and fill in the variable amounts. Glance at the posting dates. Use Preview Posting to see the entries before Business Central writes them. A person starts the posting, which gives you a natural point of control.
Common mistakes are easy to avoid. Do not change a Fixed amount without telling the person who set it up. Keep dimensions on every line, so reports stay complete. End obsolete lines with an expiration date. If a reversing entry lands in a closed period, check the allowed posting dates in General Ledger Setup.
Tidy up your close →- ✓Enter variable amounts
- ✓Preview before posting
- ✓Check reversing dates
- ✓Expire obsolete lines
- ✓Keep dimensions complete
Common questions on recurring journals in Business Central
How are recurring journals in Business Central different from a standard journal?
A standard journal is a saved template that you load into a general journal when you need it. The lines disappear after posting. A recurring journal keeps its lines for good. It advances the posting date by the frequency, and it can reverse itself or allocate a balance. So use standard journals for one-off sets and recurring journals for repeat work.
Do recurring journals post automatically?
No. The lines are ready for the next period, but a user opens the batch and posts it. Most finance teams prefer this. Variable amounts need entering, and someone should look at the entries before they reach the ledger.
What does the reversing method do on the next day?
It posts the same accounts with opposite signs, dated the day after the original entry. So an accrual that you book on the last day of the month clears on the first day of the next. Then the real invoice can arrive and post without a double count.
Can a recurring line carry dimensions?
Yes. Each line and each allocation line holds its own dimension values, and default dimensions from the account apply as usual. Set them once, and every future posting carries the same tags. That keeps departmental reports consistent from month to month.
Are there recurring journals outside the general ledger?
Yes. Business Central also has recurring versions of the item journal, the fixed asset journals and the project journal. They follow the same idea of kept lines and a frequency. Recurring sales and purchase lines handle repeat document lines separately.
Book a discovery call
Let's talk through your move to Business Central.
A focused call with a senior consultant. We learn how your business runs today, give you an honest view on whether Business Central fits, and outline scope and next steps before you commit to anything.
What happens after you send the form