Create Recurring/Template Journals
Recurring vs Template
Journal
As a way to eliminate duplicate data entry, PeopleSoft
offers recurring and template types of standard journal entries.
Standard journal entries offer the user the capability
to:
-
Schedule regular, recurring postings for standard journals,
such as weekly postings, or schedule postings for selected dates.
-
Automatically schedule journal entries on pre-determined
dates using template SJEs. Examples include bonus payments and accrued
interest.
-
Create template SJEs for known ChartField combinations without
specific dates or schedules.
Recurring journal entries are used for repetitive
transactions that use the same accounting information and amounts such
as leasing payments, amortization expenses, and monthly rents. Template
journal entries are used for regular, periodic transactions that use the
same accounting information but varying amounts such as monthly
payroll, utility, and telephone expenses.
return to the list of topics
Process a Recurring
Journal
Recurring journals are standard journals that are used to record repetitive
transactions such as lease payments, depreciation, amortization or monthly
rents. In recurring journals the accounting information (cost center,
account code, etc.) is the same and the amounts charged or credited are
the same from one period to another.
The first step in processing a recurring journals is to have a model
journal to use as the standard. A model journal can be a journal
that already exists or you can enter a new journal to use as the model.
To review how to enter a new journal see the Journal Entry Section.
To set up a recurring journal follow the steps illustrated below:
1. Follow the navigation Start > Process Financial Information
> Process Journals > Use > Standard Journal Entry > Standard Journal Entry>
Add
2. The Standard Journal Entry Panel will appear
3. You should fill in the criteria as follows:
-
Business Unit - Will default to UNIV and should not be changed
-
Source - Enter the source code for the Recurring Journal
you are creating
-
Standard Journal - Enter the Journal Id for the Standard
Journal. It must be 10 characters, but does not have to have the
same id as the Model Journal
-
Model GL Journal ID - Enter the Journal ID you are using
as your standard model
-
Model Journal Date - Enter the Journal Date of the journal
you are using as your standard model
4. Click "OK" and the Standard Journal Entry Panel
will appear
5. Fill in the criteria to create your recurring journal
-
Effective Date - Date you want the model recurring journal to be effective
-
Status - Select Active to use the recurring journal
-
Description - This is to describe the purpose of the journal.
-
SJE Type - Select Recurring
-
Schedule - You can define daily, weekly, monthly or annual
schedules for recurring transactions such as closing schedules or user-defined
events. Note that the From Date must be equal or greater than the Effective
Date.
-
Journal Entry Create Options
-
If you select Allow Lines to be Modified, you can:
-
Add or delete lines and modify the detail ChartField values
on recurring SJEs created.
-
Add or delete lines and modify the detail ChartField values
and amounts on created template SJEs.
-
If you leave Allow Lines to be Modified blank, you can:
-
Only modify the amounts on the detail lines on template SJEs
created.
-
Modify nothing on the detail lines on recurring SJEs created.
-
Select Create Journal Entry on Save to create standard journal
entries when you save this panel. The system creates recurring entries
according to the schedule and date range entered.
6. Click on the
Save icon to create the Recurring Journal.
return to the list of topics
Process Template Journal
Template journals are standard journals that are used to record repetitive
transactions such as utility or telephone expenses. In template journals
the accounting information (cost center, account code, etc.) is the same
but the amounts charged or credited may be different from one period to
another.
The first step in processing template journals is to have a model journal
to use as the standard. A model journal can be a journal that already
exists or you can enter a new journal to use as the model. To review
how to enter a new journal see the Journal Entry Section. To set
up a template journal follow the steps illustrated below:
1. Follow the navigation Start > Process Financial Information
> Process Journals > Use > Standard Journal Entry > Standard Journal Entry>
Add
2. The Standard Journal Entry Panel will appear
3. You should fill in the criteria as follows:
-
Business Unit - Will default to UNIV and should not be changed
-
Source - Enter the source code for the Recurring Journal
you are creating
-
Standard Journal - Enter the Journal Id for the Standard
Journal. It must be 10 characters, but does not have to have the
same id as the Model Journal
-
Model GL Journal ID - Enter the Journal ID you are using
as your standard model
-
Model Journal Date - Enter the Journal Date of the journal
you are using as your standard model
4. Click "OK" and the Standard Journal Entry Panel
will appear
5. Fill in the criteria to create your template journal
-
Effective Date - Date you want the model recurring journal to be effective
-
Status - Select Active to use the recurring journal
-
Description - This is to describe the purpose of the journal.
-
SJE Type - Select Template
-
Schedule - You can define daily, weekly, monthly or annual
schedules for recurring transactions such as closing schedules or user-defined
events. Note that the From Date must be equal or greater than the Effective
Date.
-
Journal Entry Create Options
-
Copy Journal Lines tells the system to use the detail lines
of the model journal with the amounts set to zero. Once you know the amounts,
you can then use the Journal Entry Lines panel to enter the amount. The
copy journal line box must be checked, otherwise the SJE will not contain
any journal line entries.
-
If you select Allow Lines to be Modified, you can:
-
Add or delete lines and modify the detail ChartField values
on recurring SJEs created.
-
Add or delete lines and modify the detail ChartField values
and amounts on created template SJEs.
-
If you leave Allow Lines to be Modified blank, you can:
-
Only modify the amounts on the detail lines on template SJEs
created.
-
Modify nothing on the detail lines on recurring SJEs created.
-
Select Create Journal Entry on Save to create standard journal
entries when you save this panel. The system creates recurring entries
according to the schedule and date range entered.
6. For Template SJEs, if you don't indicate a schedule,
the
Template Journal Date field appears in the "Journal Create Entry
Options" section, allowing you to enter a specific creation date for this
entry. The system creates each entry with a journal header status of Not
Yet Edited.
7. Click on the
Save icon to create the Recurring Journal.
8. You can then use the SJE Status inquiry panel
to review the entries created and the Journal Entry Lines panel to make
changes. (See Review Journal or Correct Journal Errors for more information
on modifying journal lines.)
return to the list of topics