Journal Entry Profiles
In
My Datasets for Review
, you can create journal entry profiles to create multiple journal entry configurations and assign them to one or more units. By using Journal Entry Profiles, you can set up a Profile Definition, Journal Entry Lines and then Assign Units.- You can create a Classes or a Tags dataset for journal entry profiles.
- Each unit can have either Journal Entry profiles or Unit Journal Entry configurations, not both.
- Journal Entry profiles are located within Data Entry dataset administration.
- A Unit does not have to be assigned to a Journal Entry Profile.
- The Unit Journal Entry configuration page is located in the Data Entry administration for Federal and State.
note
If using a Tag dataset, the Source Classes will not appear.
New Journal Entry Profile (Dataset Level)
To create a Journal Entry Profile:
- SelectMy Datasetsand thenMore.
- SelectJournal Entry Profiles.
- Select the plus sign to add a profile and then type the Code, Name and Description.
New Journal Entry Profile (Unit Level)
To create a Unit Journal Entry Line:
- SelectMy Datasetsand thenUnitsfor a dataset.
- SelectMoreand thenJournal Entry Profiles.
- SelectCreate New.
- Select theJE Typeand thenJE Code.
- Select theJE Summaryand type theDescription.
- Select theDebit GL AccountandCredit GL Account.
- Type theCost CenterandDepartment Code, if needed.
note
If you create a Journal Entry at the Unit level, journal entries are deleted. You will receive a message to confirm the deletion of journal entries.
Edit Journal Entry Profile
To edit a Journal Entry Profile:
- Type the newNameand then the newDescription. The Code cannot be edited.
Copy Journal Entry Profile
To copy a Journal Entry Profile:
- SelectJournal Entry Profile.
- SelectCopyand then type theNew Code(required).
- Type the newNamefor Edit Journal Entry Profile and thenDescription.
- SelectOK.
Delete Journal Entry Profile
To delete a Journal Entry Profile:
- SelectDelete.
- SelectCancelto close without deleting the journal entry profile.
- SelectOKto delete.
Profile Definition
To set up the Profile Definition:
- Select theJournal Entry Profile. To ensure you selected the correct journal entry profile, review theCode,Name, andDescription.
For Datasets with classes:
- SelectInclude All Classesto include all classes in the journal entry profile.
- This function is for datasets created with classes.
- This option includes all new classes.
- To select all Source classes, select the box on the header row.
- To define specific source classes, click the box next to the selected class.
- You can sort and filter the Source Class list byType,Code, orClass Name.
- To select Journal Entry Codes, clickInclude All Classesto remove the check mark.
- To select all Journal Entry Codes, select the box in the header row and then select each Journal Entry Code.
- If you need to exclude a few Journal Entry Codes, select all the Journal Entry Codes and then select each Journal Entry Code, to remove the check mark.
- SelectSave.
Journal Lines
To create new Journal Lines:
- SelectCreate New.
- SelectJE Type.
- This is a required field.
- You will define the jurisdiction type applicable for the new journal entry.
- You can select Federal, State, or both.
- SelectJE Code.
- Each journal entry line must have a uniqueJE Code.
- SelectJE Summary.
- The JE Summary is optional for data entry.
- You create the user defined value for the Journal Entry Summary page within the System folder in Administration.
- You can group multiple Journal Entry lines together.The grouping depends on the JE Summary values created in Administration.The Journal Entry lines are grouped together for Reporting.
- TypeName.
- Enter the journal entry name in the required field.
- Select theDebit and Credit Account.
- The accounts selected appear in the JE reports. If an account value is unavailable:
- SelectAdministration.
- ClickManage Trial Balances.
- SelectTrial Balances Sublines.
- For the JE Post column, select the account to post the JE.
- SelectSave.
- Select theFlex 1-9and type notes.
- Click theShow/Hidebutton to see supplemental information.
- The "Flex" fields are optional and apply to custom reports.
To change the Flex field labels:
- SelectAdministration > System > Manage Configurations > Advanced Functionality > Journal Entries
- Type the newlabel namefor Journal Entry Supplemental Field #1-9.
- SelectSave.
note
To complete the setup for the Journal Entry lines, configure both the Tax and Book entries.
Tax Calculations
To set up the Tax Calculations (These steps configure the Tax journal entries):
- SelectCreate New.
- SelectTax Calc Filterto filter the list of tax calculations.
- SelectTax Calculationto select the tax calculation.
- SelectComponentto separately state a code with a tax calculation in the Difference column.
- Type theFactor.
- SelectSave.
To delete the tax calculations:
- Select theTax Calculationfrom the Tax Calculations list.
- SelectDelete.
- SelectDelete Allto delete all the Tax Calculations from the list.
GL Sources
To set up the General Ledger Sources (These steps configure the Book journal entries):
- SelectCreate New.
- SelectGL Accountto select the GL Account.
- The list is the same for both Debits and Credits.
- Type theFactor.
- Enter a negative Factor to create a difference between the Book and Tax values (most common) in the Journal Entry report.
- SelectSave.
To delete the General Ledger Sources:
- Select theGL Accountfrom the GL Account list.
- SelectDelete.
- SelectDelete Allto delete all the Tax Calculations from the list.
Assigned Units
You assign a Journal Entry Profile to Available Unit(s). A unit can be assigned to multiple journal entry profiles.
important
Journal Entry configurations previously set up at the Unit Journal Entries Details will be permanently removed.
To assign a Journal Entry Profile to selected unit(s):
- In the Available Units list, select theUnit(s).
- To add multiple units to a journal entry profile, press the Ctrl key and then select the units.
- To sort or filter the Available and Assigned Units by code or name, click theCodeorNameheader row.
- Select theRight Arrowto assign the units to the Assigned Units list. You can assign one Journal Entry Profile per unit.
- SelectSave.
- To change the values for a selected unit:
- Select theUnitfrom the Assigned Units list.
- Select theAdd Unit Flex Field Overridesicon.
- Type the newvaluein the flex field.
- SelectSaveto update the unit with the new value.
- SelectCancelto leave the page without saving changes.
- To reset all values, clickClear All Fields.
note
- To change the view of the page layout from vertical to horizontal, select Horizontal or Vertical in the top right corner.
- When you assign a unit to a different profile, a message appears This unit has journal entry configurations defined. These records will be removed(deleted) upon save. Would you like to continue with the assignment of the unit? Select Yes, or Yes to All to assign the profile. Select No to keep the current Journal Entry Configuration.
- The Unit Code and Name are provided in Available Units (Not Already Assigned to this Profile)." The Unit Code, Name, and Override? are provided in Assigned Units.
- You can set up additional Journal Entry options such as rounding, creating groups, and adding supplemental information in Manage Configurations, within the Journal Entries tab.