Calculate Balances
Important
Information and features vary according to the roles to which you belong and the permissions associated with those roles. For more information, contact your module manager or your campus support team.
Use this window to view and download transactions and account balances. You can search General Ledger transactions by selecting GL account components and current day or fiscal period dates.
Once you enter the search criteria and click Get balances to begin the process, the transactions matching the criteria you selected will appear in the Transaction Sheet section with balance summaries and transaction details.
Tip
Use the GL Account Component options to limit the number of transactions that will appear to 30,000. If you do not select any components the Transaction Sheet will take a long time or return an error of too many records.
![]() |
In order to access the Calculate Balances page, you'll need to have the Can calculate balances permission from the General Ledger Accounting GL Transaction Access role.
In J1 Desktop, the Calculate Balances page covers the features in the Lookup GL Transactions and GL Inquiry windows.
Transaction Criteria
In the top section of the page, you will select the type(s) of components to include in the calculations. There are four component options: Fund, Department, Object, and Subobject.
Tip
If you do not narrow down the transactions by selecting specific components, the results will be larger and may take longer to calculate.
After selecting the components to include, select a date:
As of Today: automatically updates to the current date
Fiscal Period: choose a start and end time range using the drop-down field
Transaction Sheet
Based on your selections in the Select Transaction Criteria, when you click Get Balances the Transaction Sheet section will populate with the results.
At the top of the Transaction Sheet, you will see calculated amounts for the following:
Beginning Balance
Posted Balance
Unposted Balance
Current Balance
Encumbrance Balance
Suspended Activity
Inactive Activity
The list that appears at the bottom of the section, will display transactions from the selected components and date. You can choose view GL Transaction, Encumbrance Transactions, or both.
At the beginning of the transaction row, if your school uses User-Defined Fields, you can click the green UDF button to add, update, or remove UDFs from the transaction.
While you can determine the order and columns listed for each transaction using the Column Selector, when visible, the Batch Number and GL Account Number columns will contain links where you can work with transaction details. Messages can also be viewed and added to the transaction from this list.
Tip
Any comments added to a transaction will be visible on the Batches and GL Accounts pages.
From the Calculate Balances page, use the component fields to select transactions needed for balance calculation.
Fund
Department
Object
Sub-Object
Tip
If no account components are specified, it may take longer to retrieve balances.
Choose a date. You can pick from As of Today or choose a range for the Fiscal Period.
Click Get Balances to run the recalculation process.
Results will appear in the Transaction Sheet.
Tip
The spreadsheet will not display transactions associated with a project code.
The recalculation process is complete. You can use the spreadsheet options to download, change column views, display GL transactions, display encumbrance transactions, and search for specific transactions.
If historical budget information exists, this feature can be used to add or remove columns with historical budget information.
Tip
Reviewing historical information can aid in determining what caused spending to be over or under budget in previous years, what a budget should be in a future year, or whether to approve a current year budget.
Click the Column Selector icon above the worksheet.
Select the checkboxes of the columns to be added. The columns are automatically added window.
You can remove columns by deselecting the checkboxes next to the columns you wish to remove.
When you are finished, you can click the X button to close the Column Selector menu.
Select the checkboxes next to the rows you want to export.
From the Options drop-down, select Download to Excel. The Download to Excel pop-up opens.
Select options for the Excel format and data columns.
Click Download. Your .xlsx or .zip file is saved in the file location that you have set in your browser settings.
Yes. The maximum number of transactions for any calculation of balances is 30,000.
We added a Suspended Activity bucket to show the suspended amounts to the Calculate Balances page, but it’s not included in the current balance amount.
Suspended transactions/activity is not included in the Trial Balance.