Viewing Wisdom: General Ledger History

Related Topics

The GL History – Wisdom window displays the general ledger account history from Wisdom. To access the GL History - Wisdom window, click General Ledger within the Accounting menu on the Portico Explorer Bar. On the General Ledger menu bar, click GL Information, then click Wisdom. The Wisdom option will only appear if your credit union uses Wisdom.

GL History - Wisdom

How do I? and Field Help

You can refine your search criteria for prior day general ledger history using the Selection Criteria group box.

Field Description
Beg/End Branch

To search for a specific branch, enter the branch in the Beg Branch field. To specify a branch range, enter a beginning branch in the Beg Branch field. Then, enter an ending branch in the End Branch field.

Length: 3 numeric

Beg/End GL Account

To search for a specific general ledger account number, enter the general ledger account in the Beg GL Account field. To specify a general ledger account number range, enter a beginning general ledger account number in the Beg GL Account field. Then, enter an ending general ledger account number in the End GL Account field.

Length: 6 numeric

Beg/End Effective Date

To search for a specific effective date, click the Beg Effective Date down arrow to select the effective date from the calendar or enter the date in MM/DD/YYYY format. To enter an effective date range, click the Beg Effective Date down arrow to select a beginning effective date from the calendar or enter the date in MM/DD/YYYY format. Then, click the End Effective Date down arrow to select an ending effective date from the calendar or enter the date in MM/DD/YYYY format.

Beg/End Debit Amount

To search for a specific debit amount, enter the debit amount in the Beg Debit Amount field. To specify a debit amount range, enter a beginning debit amount in the Beg Debit Amount field. Then, enter an ending debit amount in the End Debit Amount field.

Length: 16 numeric including decimal

Beg/End Credit Amount

To search for a specific credit amount, enter the credit amount in the Beg Credit Amount field. To specify a credit amount range, enter a beginning credit amount in the Beg Credit Amount field. Then, enter an ending credit amount in the End Credit Amount field.

Length: 16 numeric including decimal

Beg/End Batch ID

To search for a specific batch ID, enter the batch ID in the Beg Batch ID field. To specify a batch ID range, enter the lowest batch ID in the Beg Batch ID field. Then, enter the highest batch ID in the End Batch ID field.

Length: 5 numeric

Beg/End Teller

To search for a specific teller number, enter the teller number in the Beg Teller field. To specify a teller number range, enter a beginning teller number in the Beg Teller field. Then, enter the ending teller number in the End Teller field. Type two asterisks (**) to select blank teller IDs.

Length: 2 alphanumeric

Click Search to display the general ledger history that meets the selection criteria. Click Reset to clear the fields in the Selection Criteria group box.

Click the export icon to export the information from the General Ledger History - Prior Day grid to Microsoft Excel.

Column Heading Description
Br

The branch corresponding with the general ledger account number.

Length: 3 numeric

GL Account

The general ledger account number. When adding a general ledger account, consult the National Credit Union Association (NCUA) chart of accounts to ensure that the assigned number properly categorizes the account. This number dictates whether the Portico general ledger system classifies the account as income, expense, asset, liability, or capital. Portico does not allow a general ledger account number beginning with 0, 5, or 6.

Length: 6 numeric (XXX-XXX format)

Business Date The business date of the general ledger entry.
Effective Date The effective date of the general ledger entry.
Debit Amount The debit amount of the general ledger entry.
Credit Amount The credit amount of the general ledger entry.
Batch ID The ID for the batch that included the general ledger entry.
TL The teller number associated with the general ledger entry
Description The description of the general ledger entry

The total of the debit and credit columns for the selected activity appear at the bottom of the window. Totals accumulate as you scroll forward and decrease as you scroll back. The printed version has one total for the whole report.