Reviewing General Ledger Activity
The GL Activity window displays detail information for a specified general ledger account, including:
- Current balance
- Current debit and credit totals
- Month-to-date debit and credit totals
- Prior day ending balance
- Prior period balances for the last 12 months
The GL account can either be in the branch you are logged into or in the branch specified. General ledger information can be displayed at either branch level or credit union level.
To access the GL Activity window, click within the Accounting menu on the Portico Explorer Bar. On the General Ledger menu bar, click GL Information, then click .
General ledger account balances and activity from Wisdom: General Ledger will appear on the GL Activity window. The Wisdom GL balance will only appear if your credit union uses Wisdom: General Ledger. Activity from Portico for the current day will be added to the Wisdom current balance to calculate a current day balance at that point and time when the request is made.
How do I? and Field Help
To view activity of a general ledger account, enter the account number in the Account Number field (Length: 6 numeric (XXX-XXX format) / Reporting Analytics: General Ledger » GL Master » GL ACCT NBR). Then, enter branch corresponding with the general ledger account number (Length: 3 numeric / Reporting Analytics: General Ledger » GL Master » CU BR) and click the green arrow.
To view additional general ledger accounts, select the desired order option (Keyword: OR) and click the left and right arrow buttons.
- Click the Branch Order (BR) option to view the general ledger accounts in branch order.
- Click the General Ledger Order (GL) option to view the general ledger accounts in account number order.
- Click the General Ledger Order - Total (TO) option to view the general ledger accounts in balance order. When the General Ledger Order – Total option is selected...
| GL Description |
The description of the general ledger account.
When the General Ledger Order – Total option is selected, the GL Description field is the description for the GL found in the first branch on file.
Length: 35 alphanumeric
Reporting Analytics: General Ledger » GL Master » GL ACCT NAME
|
| ACH Transactions |
Indicates if the ACH general ledger transactions, 42 for ACH general ledger credits and 47 for ACH general ledger debits, are allowed to post against this general ledger account. The valid values are:
C - Allow ACH GL transactions to post on this general ledger account for credits only.
D - Allow ACH GL transactions to post on this general ledger account for debits only.
N - Do not post ACH GL transactions against this general ledger account. System default.
Y - Allow ACH GL transactions to post on this general ledger account for both debits and credits.
If N, transaction codes 42 and 47 will be processed as ACH exceptions, crediting or debiting ACH suspense.
When the General Ledger Order – Total option is selected, the ACH Transactions field will display ‘Branches have different values’ if the values are different, if they are the same it will display the value.
Reporting Analytics: General Ledger » GL Master » ACH GL TXN IND
|
| Account Code |
A credit union-defined code that you can use as a query item in your Reporting Analytics query.
When the General Ledger Order – Total option is selected, the Account Code field is the value for the GL found in the first branch on file.
Length: 5 alphabetic
Keyword: AD
Reporting Analytics: General Ledger » GL Master » GL ACCT CODE
|
| Transfer Balance to Branch 000 |
When the General Ledger Order – Total option is selected, the Transfer Balance to Branch 000 field will display an ‘*’ if the values are different, if they are the same it will display the value.
If selected, Portico will transfer the balance of this general ledger to the corresponding general ledger account in branch 000 during the back-office cycle.
Balance Information: Portico will transfer the general ledger balance at the beginning of the back-office cycle and prior to any back-office general ledger entries. All entries will have an effective date of the current day. No prior month entries will be made. The maximum transfer amount is 999,999,999.99. If a general ledger account balance exceeds this amount, a partial transfer will occur for the maximum amount. Portico will transfer any remaining balance each night until the general ledger account balance is zero.
Limits: The following general ledger accounts cannot be selected for balance transfer to branch 000:
- Any general ledger account that exists in the share, certificate or loan profiles.
- Any interbranch general ledger account beginning with 998.
- Any general ledger account where the corresponding general ledger account does not exist in branch 000 or is marked for deletion in branch 000.
Reporting Analytics: General Ledger » GL Master » Transfer Balance
|
| Status |
Indicates if the general ledger account is:
A - Active
I - Inactive
D - Delete Pending
When you change a GL account status to Inactive, be sure that the GL is not assigned to an active product code or that it is being used on active share, loan, certificate, ACH, or share draft processing rules. Portico will attempt to prevent online transactions that affect an inactive general ledger directly. There are some online transactions that may bypass the direct affect on a general ledger and, therefore, the transaction will be processed successfully. When an online transaction is attempted using an inactive GL account, the error message “GL Account XXX-XXX, is Inactive in Branch XXX” will appear. All back-office transactions that are setup to use an inactive general ledger will be posted to prevent back-office processing errors.
When the General Ledger Order – Total option is selected, the Status field will display ‘Branches have different values’ if the values are different, if they are the same it will display the value.
Reporting Analytics: General Ledger » GL Master » Acct Status
|
The following general ledger balance and activity information will appear for the selected general ledger account:
| Prior Month Ending Balance |
The general ledger account balance at the end of the prior period. This amount is updated immediately when a general ledger transaction is performed.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » BALANCE LAST MONTH
|
| Month to Date Debits |
The number of all debits applied to this general ledger account during the current month, excluding the current day activity. This count is updated after the back-office cycle is completed.
Length: 9 numeric
Reporting Analytics: General Ledger » GL Master » MTD DEBIT NBR
|
| Month to Date Debits Balance |
The amount of debits posted to this general ledger account this month, excluding the current day activity. This amount is updated after the back-office cycle is completed.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » MTD DEBIT AMT
|
| Month to Date Credits |
The number of credits posted to this general ledger account this month, excluding current day activity. This count is updated after the back-office cycle is completed.
Length: 9 numeric
Reporting Analytics: General Ledger » GL Master » MTD CREDIT NBR
|
| Month to Date Credits Balance |
The amount of credits posted to this general ledger account this month, excluding current day activity. This amount is updated after the back-office cycle is completed.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » MTD CREDIT AMT
|
| Prior Day Ending Balance |
The general ledger account balance at the end of the prior day PM back-office cycle. It will not include any activity from the AM back-office cycle. This balance is not updated by back effective dated transactions.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » LAST CLOSED BALANCE
|
| Current Day Debits |
The number of debit transactions posted to this general ledger account since the last general ledger transaction.
Length: 9 numeric
Reporting Analytics: General Ledger » GL Master » DLY DEBIT NBR
|
| Current Day Debits Balance |
The amount of debit transactions posted to this general ledger account since the last general ledger transaction.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » DLY DEBIT AMT
|
| Current Day Credits |
The number of credit transactions posted to this general ledger account since the last general ledger transaction.
Length: 9 numeric
Reporting Analytics: General Ledger » GL Master » DLY CREDIT NBR
|
| Current Day Credits Balance |
The amount of credit transactions posted to this general ledger account since the last general ledger transaction.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » DLY CREDIT AMT
|
| Current Day Balance |
The current balance in the specified general account. If you click the General Ledger Order - Total option to view the general ledger accounts in balance order, the Current Day Balance field will display the sum for all the branches. This amount is updated immediately when a general ledger transaction is performed.
Length: 14 numeric including decimal
Reporting Analytics: General Ledger » GL Master » CURRENT BALANCE
|
| Wisdom Current Balance |
The current balance in the specified general account from Wisdom: General Ledger.
Activity from Portico for the current day will be added to the Wisdom current balance to calculate a current day balance at that point and time when the request is made.
|
| Wisdom Current Day Credits |
The number of credit transactions posted to this general ledger account since the last general ledger transaction.
Length: 9 numeric
|
| Wisdom Current Day Credits Balance |
The amount of credit transactions posted to this general ledger account since the last general ledger transaction.
Length: 14 numeric including decimal
|
| Wisdom Current Day Debits |
The number of debit transactions posted to this general ledger account since the last general ledger transaction.
Length: 9 numeric
|
| Wisdom Current Day Debits Balance |
The amount of debit transactions posted to this general ledger account since the last general ledger transaction.
Length: 14 numeric including decimal
|
| Wisdom Current Day Balance |
Activity from Portico for the current day will be added to the Wisdom current balance to calculate a current day balance at that point and time when the request is made.
Length: 14 numeric including decimal
|
| Prior Period Balances |
The general ledger account balance in the months prior to the previous balance. This amount is updated immediately when a general ledger transaction is performed.
Length: 14 numeric including decimal
|
Click the maintenance icon button to open the GL Account - Maintenance dialog box and maintain the general ledger account.
Click the general ledger account list icon button to open the GL Accounts - List dialog box and view the general ledger account list.
Click the history icon button to open the GL History - Prior Day dialog box and review prior day history for the general ledger account.
Click the new general ledger account icon to open the GL Account - New dialog box and create a new general ledger account.
Click the print icon button to print the general ledger activity.
General Ledger Effects: none | Related Reports: none
Portico Host: 783
Additional Reporting Analytics Query Items:
Reporting Analytics: General Ledger » GL Master » CURRENT ACTIVITY
Reporting Analytics: General Ledger » GL Master » CURRENT ADB
Reporting Analytics: General Ledger » GL Master » CURRENT PRE CLOSE AMT
Reporting Analytics: General Ledger » GL Master » CURRENT CLOSE DATE
Reporting Analytics: General Ledger » GL Master » ACTIVITY LAST MONTH
Reporting Analytics: General Ledger » GL Master » ADB LAST MONTH
Reporting Analytics: General Ledger » GL Master » LAST CYCLE DATE
Reporting Analytics: General Ledger » GL Master » CLOSE DATE
Reporting Analytics: General Ledger » GL Master » LAST CHG DATE
Reporting Analytics: General Ledger » GL Master » QTD ACTIVITY AMT
Reporting Analytics: General Ledger » GL Master » YTD ACTIVITY AMT
Reporting Analytics: General Ledger » GL Master » CUID
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTHS AGO
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTH END DATE
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTH END BAL
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTH END ACTIVITY
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTH END ADB
Reporting Analytics: General Ledger » GL Master » GL Master Prior Month End Info » MONTH END PRE CLOSE AMT
