Recurring journals in Business Central are a game-changer for finance teams dealing with transactions that happen regularly, like monthly rent, regular accruals, or scheduled allocations. Instead of re-typing the same entries each period, you can set up a recurring journal once and let the system do the work, ensuring accuracy and efficiency every time.
Save time and reduce errors by implementing Recurring General Journals to handle your regular postings automatically.
Start by searching and opening the Recurring General Journal in Business Central and creating a dedicated batch for regular postings. Recurrent Journals operate similarly to the regular GL Journals, with a few exceptions: there are several special fields like “Recurring Method”, “Recurring Frequency”, and “Expiration Date”.
These fields determine how the recurring journal lines will be posted, at what date, and their shelf life.
The options selected in the Recurring Method field determine how the lines and the amounts are treated on the journal line after posting.
Recurring Method Options
F Fixed – The amount on the journal line remains after posting, and the posting date is updated based on the Recurring Frequency.
This method is best used to register entries where the amount is always the same, such as rent invoices
V Variable – After posting, the lines are kept, and the posting date is updated. However, the amount on the journal line is deleted.
This method is best used to register entries where the transaction frequency is known, but the amount could differ, such as electricity invoices.
B Balance – The amount is taken directly from the account on the line and is allocated among the accounts specified for the line in the Gen. Jnl. Allocation table. The balance on the account is set to zero.
This method is used for various suspense or expense accumulation accounts that must be allocated at the end of the period (e.g. allocate office supply expenses to each department based on a predefined allocation key_
RF Reversing Fixed – The amount on the journal line remains after posting, and a reversal entry is posted on the next day.
RV Reversing Balance – The amount on the journal line is deleted after posting, and a balancing entry is posted on the next day.
RB Reversing Balance – The posted amount on the account on the line is allocated among the accounts specified for the line on the Allocations page. The balance on the account is set to zero at the end of the period, and a reversed entry is posted on the next day.
BD Balance by Dimensions – The journal line allocates costs based on a G/L account’s balance by dimension. You’re prompted to set the dimension filters to be used to calculate the source G/L account’s balance by dimension from which you want to allocate costs.
RBD Reversing Balance by Dimension – The journal line allocates costs based on a G/L account’s reversing balance by dimension. You’re prompted to set the dimension filters to use to calculate the source G/L account’s balance by dimension from which you want to allocate costs.
Set your desired frequency with a formula, such as “1M” for monthly postings. Business Central then automatically adjusts posting dates, so the workflow stays consistent and accurate.