Post

Recurring General Journals in Business Central: Rent, Accruals and Reversals

How recurring general journals work in Business Central: recurring methods, recurring frequency, expiration dates and reversal dates, with a monthly rent line and an electricity accrual that reverses the next day.

Recurring General Journals in Business Central: Rent, Accruals and Reversals

Some journal entries come back every month with the same accounts and often the same amount: rent, subscriptions, insurance, a month-end accrual for a bill that hasn’t arrived yet. Typing them in every month is slow and easy to get wrong. A recurring general journal lets you set them up once and post them again and again.

This post explains the fields that make a journal recurring, then posts two entries in a CRONUS UK company on Business Central 29.1: a fixed monthly rent and an electricity accrual that reverses itself the next day.

What a recurring journal is

A recurring journal is a general journal with a few extra fields. The difference is what happens after you post. In a normal general journal, posted lines are deleted. In a recurring journal, the lines stay. The accounts, descriptions and dimensions remain, and the posting date moves forward to the next period, ready for next time.

Search for Recurring General Journals to open one. The extra fields are Recurring Method, Recurring Frequency, Expiration Date and, if you add it, Reverse Date Calculation (Microsoft Learn calls it Reversal Date Calculation).

Recurring Method

Recurring Method decides what happens to the line’s amount after posting, and whether a reversal is posted.

MethodWhat happens after posting
F FixedThe amount stays on the line. Lines with an amount of zero stay in the journal but aren’t posted
V VariableThe amount is deleted. You enter a new one next time
B BalanceThe balance on the line’s account is allocated to the accounts on the Allocations page, and the account is set to zero
RF Reversing FixedLike Fixed, plus a reversing entry the next day
RV Reversing VariableLike Variable, plus a reversing entry the next day
RB Reversing BalanceLike Balance, plus a reversing entry the next day
BD Balance by DimensionAllocates a G/L account’s balance by dimension. You set dimension filters to say which part of the balance to allocate
RBD Reversing Balance by DimensionLike Balance by Dimension, plus a reversing entry

The pattern is simple. Fixed, Variable and Balance decide what happens to the amount. The R versions add a reversal.

Use Fixed when the amount is the same every time, like rent. Use Variable when the accounts are the same but the amount changes, like an electricity bill. Use a reversing method for accruals: you book the cost at month end, and the reversal clears it at the start of the next month, so the real invoice doesn’t double-count it.

Recurring Frequency

Recurring Frequency is a date formula, and it’s required. After each posting, Business Central adds it to the line’s Posting Date to get the next one.

FormulaMeaningFrom 30-11-2026 gives
1MSame day next month30-12-2026
1D+1M-1DLast day of next month, if you start on a month end31-12-2026
1M+CMOne month, then to the end of that month31-12-2026
CMEnd of the current month30-11-2026

Watch the first row. 1M keeps the day of the month, so a line started on 30 November posts on 30 December, not 31 December. If the entry must land on the last day of every month, use 1D+1M-1D (start on a month end) or 1M+CM (start on any day). CM on its own doesn’t move a month-end date forward, so it’s not a useful frequency for a line that’s already on the last day.

Expiration Date

Expiration Date is the last date the line can be posted. After that, the line isn’t posted, but it isn’t deleted either, so you can extend the date and use it again. Leave it blank and the line posts every time until you delete it.

Set it to the end of a contract. A lease that ends on 31-12-2027 gets an expiration date of 31-12-2027, and nobody has to remember to stop posting the rent.

Reversal Date Calculation

For the reversing methods, the reversing entry is posted the next day by default. Reverse Date Calculation changes that:

ValueReversal is posted on
BlankThe day after the posting date
A date formula, for example 5DThe posting date plus that formula

The field is hidden by default. To use it, personalize the Recurring General Journals page and add the field to the lines.

Allocations

The Allocations action on a line lets you split its amount across several accounts or dimension values, using an Allocation % on each allocation line. The allocation acts as the balancing side of the recurring line. A typical use is rent split by department, by floor space. Allocations stay in place after posting, just like the journal lines.

You need allocations for the Balance methods, since they spread an account’s balance. This post doesn’t use them.

Set up the journal

The scenario: post November’s office rent, and accrue November’s electricity because the bill won’t arrive until December.

One thing surprised me. In this version the Recurring General Journals page has no Bal. Account Type or Bal. Account No. columns, and they aren’t hidden columns you can add back. So each entry needs its own balancing line, with the same document number so the two lines post as one transaction. Two entries make four lines:

Recurring general journal batch BLOG with four lines: F Fixed office rent 2,000.00 to 30110 and -2,000.00 to 78400 on 30-11-2026 with expiration 31-12-2027, and RV Reversing Variable electricity accrual 350.00 to 30220 and -350.00 to 86700 on 29-11-2026 Recurring general journal batch BLOG with four lines: F Fixed office rent 2,000.00 to 30110 and -2,000.00 to 78400 on 30-11-2026 with expiration 31-12-2027, and RV Reversing Variable electricity accrual 350.00 to 30220 and -350.00 to 86700 on 29-11-2026

FieldOffice rent (2 lines)Electricity accrual (2 lines)
Recurring MethodF FixedRV Reversing Variable
Recurring Frequency1M1M
Posting Date30-11-202629-11-2026
Document No.RENT-2611ACCR-2611
Account No.30110 Rent / Leases: 2,000.00
78400 Other bank accounts: -2,000.00
30220 Electricity for Property: 350.00
86700 Other Accrued Expenses and Deferred Income: -350.00
Expiration Date31-12-2027Blank
Reverse Date CalculationNot usedBlank, so it reverses the next day

The rent is the same every month, so it’s Fixed. The electricity accrual is an estimate that changes every month, and it has to come off again once the real bill is posted, so it’s Reversing Variable. The balancing line of each pair uses the same method, so it behaves the same way: the rent’s bank line keeps its amount, and the accrual’s liability line is cleared and reversed too.

Two practical notes:

  • Clear Gen. Posting Type. Account 30220 has Gen. Posting Type Purchase on the account card, so the line picked it up. On a pure G/L accrual you don’t want VAT, so I cleared it on the line.
  • The accrual is dated 29-11, so the reversal lands on 30-11. In a real company you’d usually accrue on the last day of the month and let the reversal post on the 1st. The mechanics are the same either way: the reversal is always the posting date plus one day, unless Reverse Date Calculation says otherwise. Make sure that reversal date is also inside your allowed posting dates (Allow Posting From / Allow Posting To in General Ledger Setup or User Setup), or the whole journal won’t post.

Choose Post and confirm. Business Central says The journal lines were successfully posted.

After posting: the journal

The lines are still there:

Recurring general journal after posting: rent lines still 2,000.00 and -2,000.00 with posting date 30-12-2026; electricity accrual lines with amount 0.00 and posting date 29-12-2026 Recurring general journal after posting: rent lines still 2,000.00 and -2,000.00 with posting date 30-12-2026; electricity accrual lines with amount 0.00 and posting date 29-12-2026

LinesAmount after postingNext posting date
Office rent (F)2,000.00 / -2,000.00, unchanged30-12-2026
Electricity accrual (RV)0.00, cleared29-12-2026

All four lines moved forward by 1M. The rent lines are ready to post again as they are. The electricity lines need next month’s estimate first. A line with a zero amount stays in the journal but isn’t posted.

Note the date: 30-12-2026, not 31-12-2026, because of how 1M works. If you want December’s rent on the 31st, set the posting date to 31-12-2026 by hand now, and change the frequency to 1D+1M-1D so it stays on the last day from then on.

After posting: the G/L entries

Search for General Ledger Entries and filter Document No. on RENT-2611|ACCR-2611:

General Ledger Entries 4489 to 4494: on 29-11-2026 ACCR-2611 30220 350.00 and 86700 -350.00; on 30-11-2026 RENT-2611 30110 2,000.00 and 78400 -2,000.00, and the ACCR-2611 reversal 30220 -350.00 and 86700 350.00 General Ledger Entries 4489 to 4494: on 29-11-2026 ACCR-2611 30220 350.00 and 86700 -350.00; on 30-11-2026 RENT-2611 30110 2,000.00 and 78400 -2,000.00, and the ACCR-2611 reversal 30220 -350.00 and 86700 350.00

EntryPosting DateG/L AccountDebitCreditWhat it is
448929-11-202630220 Electricity for Property350.00 November electricity, accrued
449029-11-202686700 Other Accrued Expenses 350.00Liability for the unbilled electricity
449130-11-202630110 Rent / Leases2,000.00 November rent
449230-11-202678400 Other bank accounts 2,000.00Paid from the bank
449330-11-202630220 Electricity for Property 350.00Accrual reversed
449430-11-202686700 Other Accrued Expenses350.00 Accrual reversed

The rent is two entries, like any journal posting. The accrual is four: the accrual itself, and the reversal the next day that Business Central posted by itself, under the same document number.

With a month-end accrual posted on the 30th and reversed on the 1st, November’s income statement carries the 350.00 of electricity even though the bill hasn’t arrived. The reversal on the 1st puts a 350.00 credit on utilities at the start of December. When the real bill is posted in December, say for 362.00, it lands on utilities expense and the net cost in December is only the 12.00 difference. The accruals account is back to zero.

Summary

You want toUse
Post the same amount every monthF Fixed
Post to the same accounts with a new amount each timeV Variable
Accrue a cost and clear it the next dayRV Reversing Variable or RF Reversing Fixed
Clear an account and spread it to othersB Balance with Allocations
Spread a balance by dimensionBD or RBD
Post on the same day each monthFrequency 1M
Post on the last day of each monthFrequency 1D+1M-1D or 1M+CM
Stop posting at the end of a contractExpiration Date
Reverse on a day other than the nextReverse Date Calculation (add it via personalization)

References

This post is licensed under CC BY 4.0 by the author.