Multiple tabs on this window provide detailed information about a selected GL account. You can use this window to:
· Review and update general information about a GL account
· View monthly posted, unposted, and encumbrance balances for the current and next fiscal year
· View monthly historic and encumbrance history balances for the two previous fiscal years
· Review user(s) and group(s) with assigned security access to the account and easily access the Setup Account Security and Group Definition windows
· Find contact information for users with account security access and send them email notifications
· Review detailed budget information for various budget periods associated with the GL account
· Review reports (set up on the Financial Reporting window) containing the selected GL account and easily access the Manage Report Line Items window to make needed updates to the reports
· Update report cells, which are not part of the financial reports on this window, by easily accessing the Define Report Cells Manually window
· Access and customize user fields associated with the GL account
· Add and review feedback associated with the GL account
· Export security, budget, and report information associated with the GL account to an Excel spreadsheet
If your system is configured to operate with foreign currencies, the following features are also available:
· Foreign denominated accounts will be designated with a Currency Code column in the lower right-hand corner of the G/L Master tab.
· Foreign balances will be displayed on the respective balance tabs.
Use this tab to select, review, update, and delete (when applicable) G/L accounts. You can also add a selected account or account details to a report cell by right-clicking and selecting Add Account to Cells.
Non-Budget module users can view supporting information for budget details by right-clicking in a budget column and selecting Supporting Information, and access the Budget Control window by right-clicking in a Budget % Month column and selecting Budget Control.
|
For J1 Desktop and JICS Budget module users, the columns on this window are displayed in a different order and the Supporting Information and Budget Control right-click menu options are unavailable. |
Displays the type of GL account.
Displays the description of the account number.
Use this drop-down list to define an account as Unrestricted, Temporarily Restricted, or Permanently Restricted.
When a fund's status is Unrestricted, the fund is available for withdrawal. Temporarily Restricted funds are currently unavailable, but will become available in the future. However, Permanently Restricted funds are unavailable and cannot be used.
This code identifies the security officer responsible for a particular account.
This code identifies the security officer responsible for a particular account.
This code identifies the state
account associated with this GL account. You can click the
lookup
icon to view or modify codes in
the State Account
Code Definition window.
This code identifies the Oklahoma state revenue code associated
with this GL Account. You can click the lookup
icon to view or
modify codes in the State
Revenue Code Definition window.
This drop-down list is populated based upon the Account Type selected. Click the Account Types below to view associated Fixed Asset Account Types.
When account numbers are assigned Fixed Asset Account Types, personnel using the Fixed Assets module are able to find specific accounts easily.
You must have a valid license to use the Fixed Assets module of the Business Office in order for this drop-down list to appear on your screen.
A - Asset
-
(N) Not an FX Account - Default
(F) Fixed Asset
(A) Accumulated Depreciation
(C) Cash or AR
(D) Debt
E - Expense
-
(N) Not an FX Account - Default
(E) Depreciation Expense
(G) Gain or Loss
F - Fund
Balance -
(N) Not an FX Account
I - Income
-
(N) Not an FX Account - Default
(G) Gain or Loss
L - Liability
-
(N) Not an FX Account - Default
(A) Accumulated Depreciation
(D) Debt
M - Not
Active ( Balance Sheet) -
(N) Not an FX Account - Default
(F) Fixed Asset
(A) Accumulated Depreciation
(C) Cash or AR
(D) Debt
X - Auxilliary
-
(N) Not an FX Account - Default
(E) Depreciation Expense
(G) Gain or Loss
(F) Fixed Asset
(A) Accumulated Depreciation
(C) Cash or AR
(D) Debt
N - Not
Active (Income/Expense) -
(N) Not an FX Account - Default
(E) Depreciation Expense
(G) Gain or Loss
Select this checkbox to allow the G/L account to be used for budgeting purposes.
Select this checkbox to allow the G/L account to be used for purchasing purposes.
|
If this checkbox is not selected, it cannot be used when entering a requisition or purchase order. |
Current Year Balances
Displays the amount that has been posted to the General Ledger, which includes all transactions with a status code of C (current) indicating they are free of errors, have been posted, and contribute towards the posted balances in the General Ledger Master table.
Displays the amount that has not yet been posted to the General Ledger, which includes all transactions with a status code of U (unposted) indicating they are free of errors, have not been posted, and contribute towards the unposted balances in the General Ledger Master table.
Displays the amount that has not yet been applied to the designated account but has been anticipated and is used to establish budgets, variances, and future projections.
Displays balances for the previous five fiscal years.
|
The current fiscal year and beginning month are set up on the General Configuration window. |
This group box defines the Part, Line Number, and Column of the Internal Revenue Service Form 990 on which the General Ledger account number should be reported.
Displays the account number for the associated fund.
|
To select an account number from the GL Master Account Codes window, select Account Number List from the Options menu or by right-clicking on the column. |
This column contains the previous number for this account, if any.
|
This account may have had a different number before your system was converted. |
Selecting this checkbox indicates that summaries of transaction details are to be displayed/printed.
|
This value defaults from the Default Summarize checkbox on the Account Number Defaults window. |
Displays the account's budget balance history for the past three fiscal years.
Displays the budget amount from the beginning of the fiscal year.
|
Supporting Information is a right-click option from some of the budget columns. |
Displays the budget amount according to the current date. Budget transactions will cause this figure to change.
|
Supporting Information is a right-click option from some of the budget columns. |
Displays the percentage of the annual budget amount that is allocated to each fiscal month.
|
To access the Budget Control window, right-click from a Budget % Month column and select Budget Control. |
|
Supporting Information is a right-click option from some of the budget columns. |
Displays projected budgets for the next five years.
|
Supporting Information is a right-click option from some of the budget columns. |
*A valid license to use the Fixed Assets module is required for this column to be available.
**Only available for traditional G/L module budgeting capabilities.
***Only available for Budget module users.
****Only available for state reporting users.
· Balances
The following sub-tabs appear under this tab:
o Posted
This tab displays the monthly amounts posted to the General Ledger. The balances represent all transactions with a status code of C (current) indicating they are free of errors, have been posted, and have contributed towards the posted balances in the General Ledger Master table.
o Unposted
This tab displays the monthly amounts that have not yet been posted to the General Ledger. The balances reflect all transactions with a status code of U (unposted) indicating they are free of errors, have not been posted, and have contributed towards the unposted balances in the General Ledger Master table.
This tab tracks current year and future year encumbrance balances. An encumbrance is an amount that has not yet been applied to the designated account but has been anticipated and is used to establish budgets, variances, and future projections.
o History
This tab shows the monthly balance for every month within the past two fiscal years.
This tab tracks the history of encumbrance balances. An encumbrance is an amount that has not yet been applied to the designated account but has been anticipated and is used to establish budgets, variances, and future projections.
· Security
Use this tab to review existing user(s) and group(s) with security access to the GL account. You can also view specific users' contact information and send them e-mail, export security details to Excel, and access the Setup Account Security and Group Definition windows.
· Budget (this tab is only available with the J1 Desktop Budget module)
Use this tab to review current and historical budget information related to the selected G/L account. One budget-checking budget displays per budget period. You can view GL accounts associated with a line item, adjustment details, actual balance details including transaction details and batches, and available budget summaries. You can also export budget information to an Excel spreadsheet and easily access the Setup and Manage Budgets activity to update budget worksheets.
Displays the name of the budget in which the account is included.
Displays the period of the budget in which the account is included.
Displays the status of the budget in which the account is included.
Displays the hierarchy of the worksheet in which the budget is included.
Displays the status of the worksheet in which the budget is included.
Displays any existing line item codes associated with the selected account number.
Displays the line item code definition.
Displays the initial amount entered in the budget.
Displays any transfer or modification amount applied to the budget.
Displays the current year's operating budget amount. This includes approved adjustments.
Displays the actual amount incurred during the budget period.
Displays the budget amount available. This calculated amount includes approved adjustments, unposted and posted transactions, and any encumbrances.
· Report
Use this tab to view the reports with which the GL account is associated and any report line items associated with the account that are not included in a report. You can also export report details to Excel, make needed updates to the reports by accessing the Manage Report Line Items window, or access the Define Report Cells Manually window to update or define report cells.
|
Report details shown on this tab come from the Excel financial reporting functionality (Financial Reporting window and Manage Report Line Items window), so reports containing report cells and not using report line items are not reflected here. |
This tab displays any personalized information that has been added to the G/L Master User Defined table. Right-click any empty space on this tab and select Customize Form to enter InfoMaker and design this tab.
Review and Update General GL Account Information
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to review or update general information.
|
You can also access and open an account in the G/L Accounts window via the Search and Update GL Accounts window by clicking on the account number in your search results. |
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. On the GL Master tab, review and update general account information.
|
If your school does not use the Budget module, the Budget tab will be disabled; however, additional budget data will appear for you on the GL Master tab. |
|
The Fixed Asset Account Type column appears only if you have a valid license to use the Fixed Assets module. |
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account you want to delete.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
|
You can also access and open an account in the G/L Accounts window via the Search and Update GL Accounts window by clicking on the account number in your search results. |
3. On the GL Master tab, click the Delete button to delete the account.
4. If the Delete button is inactive, hover over it to view the reason the account cannot be deleted. The hover message lists the reasons this particular account cannot be deleted.
|
An account cannot be deleted if it is associated with one or more of the following: · Transaction entry · Budget · Expense/income account · Financial line item · Due to/due from account · Student/vendor transaction · Subsidiary account (vendor) |
View Balance Information for GL Accounts
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view balance information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Balances tab. The Posted, Unposted, Encumbrance, History, and Encumbrance History sub-tabs appear.
4. Click the applicable balance tab(s) to view balances.
|
The Posted, Unposted, and Encumbrance tabs show monthly balances for the current and next fiscal year. The History and Encumbrance History tabs show monthly balances for the two previous fiscal years. |
Review Users and Groups With Security Access to the GL Account
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to review security access.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Security tab. User(s) with existing security access to the account are listed in the Users column, and the group(s) to which they are assigned are listed in the Group column.
Contact Another J1 Desktop User With Access to the GL Account
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to review security access.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Security tab.
User(s) with existing security access to the account are listed in
the Users column, and the
group(s) to which they are assigned are listed in the Group
column.
4. To review a user's contact information:
a. Click
the Contact Info
icon. The user's Contact Information window appears.
|
A red Contact Info |
b. To review or update additional information about the user, click the View more information about me hyperlink. The user's Contact Information window closes and the Name Entity window appears displaying the user's information.
|
If you do not have the appropriate account security permissions, this option may not be available. |
c. When you are done reviewing or updating the user's information, click the Close button. The Name Entity window closes, and the G/L Accounts window reappears.
5. To send a user an e-mail:
a. Click the Send E-mail icon. The Send Email window appears with the user's e-mail address in the To field.
|
A Send E-mail |
b. Enter the appropriate information, attach a file if necessary, and click Send. The Send Email window closes, and an e-mail is sent to the user.
Perform Additional GL Security Tasks
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to review security access.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Security tab.
4. To update or apply additional security settings by component or account security officer, click the Setup Account Security link. The Setup Account Security window appears.
|
If you do not have the appropriate account security permissions, this option may not be available. |
5. To update user groups or user group permissions, click the Group Definition link. The Group Definition window appears where you can add a new user to a group, remove a user from a group, or create a new group specifically for the account.
|
If you do not have the appropriate user group permissions, this option may not be available. |
Export Security Access Details to Excel
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to export security information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Security tab.
4. From the bottom of the window, click the Export to Excel button. The Export Status window appears.
5. Once the export is complete, the exported file opens in Excel.
View GL Accounts Associated with a Line Item
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view budget line item information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. From the Line Item Code column, click on the line item hyperlink for which you want to see all accounts associated with the line item. The GL Accounts Associated with Line Item window appears.
5. To close the GL Accounts Associated with Line Item window, click the Close button.
Add the GL Account to a Budget Worksheet
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account you want to add to a specific budget worksheet.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. Click the Setup & Manage Budgets hyperlink. The Setup and Manage Budgets window opens with the selected GL account information displayed in the Setup Worksheets tab.
5. From the Build Your Budget Hierarchy panel, select the worksheet to which you want to add the GL account. The available GL accounts and lines items display on the right side in the Available GL Accounts & Line Items panel.
6. To view by available GL accounts, select the Display GL Accounts option.
|
Only those accounts that have been identified as available for budgeting in the General Ledger (G/L Accounts window) are available to add to the worksheet and any of its component worksheets. |
7. From the Available GL Accounts section, select the checkboxes next to the GL accounts to be added to the worksheet.
|
To quickly locate accounts, enter account numbers or descriptions in the browse row at the top of the list. |
|
To add all the accounts, select the Select All checkbox. |
8. Click the Assign to Worksheet button.
9. Click the Save icon. The GL account(s) are added to the worksheet.
View Adjustments, Adjustment Details, and Line Item Allocations to GL Accounts
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view adjustments, adjustment details, and/or line item allocations.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. From the Adjustment column displayed, click on the amount hyperlink for which you want to view adjustments. The View Adjustments window appears displaying the approved adjustments for the amount.
5. To view adjustment details, click on the adjustment name hyperlink. The Adjustment Details window appears.
6. To view how adjustments were allocated across line items, click a budget increase or budget decrease amount hyperlink. The Line Item Allocation window appears.
7. Once you are done reviewing the line item allocations, click the Close button. The Line Item Allocation window closes, and the Adjustment Details window reappears.
8. Once you are done reviewing the adjustment details, click the Close button. The Adjustment Details window closes, and the View Adjustments window reappears.
9. Once you are done viewing the adjustments, click the Close button. The View Adjustments window closes.
View Actual Account and Transaction Information for GL Accounts
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to actual account and transaction information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. From the Actuals column displayed, click on the amount hyperlink for which you want to view actual account and transaction information. The G/L Inquiry Details window appears displaying account information.
5. To view transaction information, select Transaction Details from the Viewing drop-down list.
6. To view the batch of transactions, click the Display Transaction Batch button. The View Transactions window appears.
7. Once you are done reviewing the batch of transactions, click the Close button. The View Transactions window closes, and the G/L Inquiry Details window reappears.
8. Once you are done reviewing the account and/or transaction details, click the Close button. The G/L Inquiry Details window closes, and the G/L Accounts window reappears.
View Available Budget Summaries for GL Accounts
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view an available budget summary.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. From the Available Budget column displayed, click on the amount hyperlink for which you want to view an available budget summary. The Available Budget Summary window appears.
5. To view approved budget adjustments or pending adjustments associated with the budget, click on the amount hyperlink. The View Adjustments window appears displaying the approved/pending adjustments for the amount.
6. To view adjustment details, click on the adjustment name hyperlink. The Adjustment Details window appears.
7. To view how adjustments were allocated across line items, click a budget increase or budget decrease amount hyperlink. The Line Item Allocation window appears.
8. Once you are done reviewing the line item allocations, click the Close button. The Line Item Allocation window closes, and the Adjustment Details window reappears.
9. Once you are done reviewing the adjustment details, click the Close button. The Adjustment Details window closes, and the View Adjustments window reappears.
10. Once you are done viewing the adjustments, click the Close button. The View Adjustments window closes, and the Available Budget Summary window reappears.
Export the Budget Balances to Excel
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to export budget information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Budget tab.
4. From the bottom of the window, click the Export to Excel button. The Export Status window appears.
5. Once the export is complete, the exported file opens in Excel.
View Reports and Report Line Items Containing the GL Account
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view report information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Report tab. The financial report(s) and line item(s) that contain the account display.
|
If any report line items associated with the account are not included in a report, the Associated Report Line Items Not in a Report hyperlink appears. Click the link to view the report line items. |
Update Reports Containing the GL Account
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to view and update report information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Report tab. The financial report(s) and line item(s) that contain the account display.
|
If any report line items associated with the account are not included in a report, the Associated Report Line Items Not in a Report hyperlink appears. Click the link to view the report line items. |
4. To update the report(s) associated with the GL account, click the Manage Report Line Items hyperlink. The Manage Report Line Items window displays in modify mode with the selected GL account and its report information displayed.
5. When you are done modifying the report, click the Save button and close the Manage Report Line Items window. The G/L Acco unts window reappears. Changes are reflected on the Report tab.
|
You may need to refresh the Report tab (select another tab and then select the Report tab again) to see the updates. |
Export Report Details to Excel
1. Access the G/L Accounts window.
2. From the Account Num column, enter or select the G/L account for which you want to export report information.
|
To quickly locate an account number, right-click and select account number components or select Account Number List to access a full list of accounts. |
3. Select the Report tab. The financial report(s) and line item(s) that contain the account display.
4. From the bottom of the window, click the Export to Excel button. The Export Status window appears.
5. Once the export is complete, the exported file opens in Excel.
1. Click the Add Feedback
icon or Review
Feedback
icon. The Review/Add Comments and
Attachments window appears.
2. To add a comment, enter it in the Comment box and click the Add button.
3. To edit a comment:
a. Hover
over the comment and click the Edit
icon. The Edit Comment window
appears.
b. Make your update and click the Update comment button. The Edit Comment window closes and the comment automatically appears on the Review/Add Comments and Attachments window.
|
You can only edit comments you have added and before they have been read by other users. This helps maintain the overall conversation as comments are often made referring to a previous comment. |
4. To delete a comment,
hover over the comment and click the Delete
icon. The comment is deleted.
|
You can only delete comments you have added and before they have been read by other users. This helps maintain the overall conversation as comments are often made referring to a previous comment. |
5. To e-mail the author of another comment:
a. Click
the E-mail
icon. The Send
Email window appears.
b. In the From column, enter your e-mail address.
c. Use the remaining e-mail options to enter your message.
d. To
include an e-mail attachment, click the Attachment
button. The Select File window
appears. Locate the file, select it, and click the Open
button. The Select File window
closes and the file is attached.
e. To
remove an e-mail attachment, click the Remove
Attachment
button. The attachment is automatically removed.
f. Click the Send button. Your e-mail message is sent.
6. To add an attachment:
a. Click
the Select a file to attach
button. The Select the File to Attach
window appears.
b. Locate the file and select it.
c. Click the Open button. The Select the File to Attach window closes and the file is selected.
d. Click the Add button and the selected attachment appears on the Review/Add Comments and Attachments window.
7. To print the comments:
a. Click
the Print
button. The Print
window appears.
b. Select the appropriate printer and settings.
c. Click the Print button. The comments are printed.
d. To close the Print window, click the X icon.
8. To close the Review/Add Comments and Attachments
window, click the Close button
or X
icon.
Working with Financial Reporting
Common Functionality for Data Entry Windows