A Recurring Journal Entry is a Journal Entry template that allows you to create journal entry records that should be repeated during a defined future interval.
Note: If you are using a Consolidations Ledger(s), Recurring Journal Entries can be created for an Eliminations Transactional Ledger(s).
Create Recurring Journal Entry
- Navigate to Accounting Home and click the Setup tab. Then, under the Automations menu, click Recurring Journal Entries.
- Click New.
Note: My Domain in Salesforce must be enabled. To learn more, view the Salesforce My Domain knowledge article.
Note: Setting up a Recurring Journal Entry includes an Owner field that is populated with the login name.
- The following fields are required before the New Recurring Journal Entry can be saved:
- Recurring Journal Entry Name: Any name can be used.
- Status: Determines if the Recurring Journal Entry should still be used (defaults to Active, can be set to Inactive).
- Journal Entry Frequency defaults to Monthly but can be reset to:
- Next Journal Entry Date: Used to specify the creation date of the next journal entry.
- Complete the following optional fields, as necessary:
- End Date: Used to specify the date until which Journal Entries can be created from this Recurring Journal Entry. Immediately after the End Date is reached, the Status on the Recurring Journal Entry will automatically be set to “Inactive.” If an attempt is made to create a Journal Entry after the End Date, a message displays to indicate that “You cannot create a Journal Entry from an inactive Recurring Journal Entry record.”
- Last Journal Entry Date: This field is used for recording the date the last Journal Entry was created from this Recurring Journal Entry template. It is ignored when creating a new Journal Entry.
Note: The Exclude from Automation checkbox is used in conjunction with scheduled jobs. By default, this is unchecked and the Recurring Journal Entry record will be included in a scheduled job. When checked, the Recurring Journal Entry record will be excluded from the scheduled job.
- Exit the New Recurring Journal Entry screen by clicking one of the following:
- Save: Saves the New Recurring Journal Entry.
- Save & New: Saves the New Recurring Journal Entry screen and offers another (blank) New Recurring Journal Entry screen to populate (repeat this process until all required Recurring Journal Entries have been created).
- Cancel: Cancels the current New Recurring Journal Entry.
Create Recurring Journal Entry Lines
Each Recurring Journal Entry requires details that are entered on the New Recurring Journal Entry Line screen. This is the screen where the accounting details are added. This screen is accessed by clicking on the name of a Recurring Journal Entry that appears on the List View of Recurring Journal Entries.
When the name of a Recurring Journal Entry is clicked, a detail screen presents the information about the Recurring Journal Entry. On this screen, click New on the Recurring Journal Entry Lines Related List. Clicking New will open a New Recurring Journal Entry Line screen.
The top portion is labeled Information and contains the Recurring Journal Entry Line parent record and empty fields for the following information:
- Reference: Use this field to contain an external document reference.
The lower portion of the screen is labeled Accounting Information and is used to identify the information pertaining to the specific Recurring Journal Entry identified in the top part of the New Recurring Journal Entry Line screen. The only mandatory field is the General Ledger Account, used to record the transaction to the correct General Ledger Account. The other fields are for optional information.
Note: If you add a Project, the Journal Entry can be posted without having an associated Project Task. The validation rule to require a Project Task whenever selecting a Project on the Recurring Journal Entry Line has been disabled on all new installations. A user may enable/disable according to their business processes.
After creating one or more Recurring Journal Entry Lines, they are collated onto a Recurring Journal Entries List View that shows all the information on a single line (except the Owner data, which is not shown) including Total Debits and Total Credits.
- If the Total Debits and Total Credits are not equal to each other, Accounting Seed prevents posting.
- Accounting Seed restricts the number of Recurring Journal Entry Lines within a single Recurring Journal Entry to 1000 lines to prevent errors based on Salesforce limits when creating records. Additionally, there is also a limit set on how many records can be created at one time using the Create or Create & Post buttons on the Create Journal Entry intermediate screen. The limit is 1,000 records for Recurring Journal Entry.
- With the Magnolia - Home release, a new End Date field has been added to the Recurring Journal Entry screen. This field is used to specify the date until which Journal Entries can be created from a Recurring Journal Entry. Immediately after the End Date is reached, the Status on the Recurring Journal Entry will automatically be set to “Inactive.” This will save time from manually changing the Status on Recurring Journal Entries to “Inactive.” If an attempt is made to create a Journal Entry after the End Date, a message displays to indicate that “You cannot create a Journal Entry from an inactive Recurring Journal Entry record.”
With the Magnolia release, if you are using a Consolidations Ledger(s), Recurring Journal Entries can be created for an Eliminations Transactional Ledger(s).
- The Weekly increment has been added as frequency.