Financial Statements Form
Click Financial Statements, the following form displays:
Field Name | Field Type | Description |
| From Fiscal Year | Number | Enter or select fiscal year from drop down options. |
| From Period | Number | Enter or select applicable period from drop down options. |
| Thru Fiscal Year | Number | Enter or select fiscal year from drop down options. Allows for different fiscal year to be selected for through year. |
| Thru Period | Number | Enter or select applicable period from drop down options. |
| Report Date | Date/Time | Enter or select date from calendar. Date displays in Header area of selected financial report. The date selected will not impact the data included in the reports. |
| Include Subsidiary Journals? | Yes/No | Check box to include entries in the subsidiary journals, not yet updated to the General Ledger. Only available when generating the Income Statement or Balance Sheet. |
| Summary? | Yes/No | Check box to generate a report without posting account detail. Report would show only accounts classified as subtotals or totals (TRAN CODE 3 or 6 defined via Chart of Accounts Setup). |
| Print Account #’s | Yes/No | Check box to include General Ledger Chart of Account numbers on reports. |
| Consolidation? | Yes/No | Check box to generate a consolidated report. (See below). |
| Report Division | Alpha/Numeric | Select report division from the drop down options. These options have been setup to generate a summarized report. A Target Report Division will have general account descriptions, (not specific to any division). The Target Report Division must also be selected in the Source Division list. |
| Print Zero Balances? | Yes/No | Uncheck box to omit accounts with zero balances from the reports. |
| All Divisions? | Yes/No | Check box to include data from all divisions on selected report. Leave box unchecked to select specific divisions. Utilizing the Division button on right side task bar. |
| Report Name | Alpha/Numeric | Enter or select report name from the drop-down list. (See below) |
| Report Title | Alpha/Numeric | Auto populates based on Report Name selected. See Financial Statement Builder section of this manual for information on customizing the Report Titles. |
| Report Group | Alpha/Numeric | If Report Groups have been previously setup. Enter or select the group from the drop-down options. |
| Source Divisions | Yes/No | Check the applicable boxes to indicate which Divisions are to be included on the report. |
| Report Sort Order | Number | If consolidation fields were created select the order that data will appear on the selected reports. |
| Report Data Range | Number | Enter a starting and ending consolidation field number. |
Report Options
Period Reports - Reports can be generated for range of periods within a fiscal year or from one fiscal year to another by utilizing the From & Thru Fiscal Year and From & Thru Period.
Include Subsidiary Journals? - Include Subsidiary Journal option is only available on the following reports: Income Statement & Balance Sheet. When selected the report will include entries not yet updated to the General Ledger.
Summary Reports - When selected and General Ledger Chart of Accounts numbers have been identified as suppressed, the report generated will only show the dollar values in Subtotal and Total format.
Print Account #’s - Reports default to generate NO Account #’s on reports. If Account #’s are required, select this option.
Consolidated Report - The Consolidated Report lists the total for each account number regardless of the Division. For example, if in every Division the expense account for FICA is 5020100000, the Consolidation Report will list that account number once; the amount listed would be the sum of every instance of that account number.
Report Division - The Report Division option is used in conjunction with the consolidation fields. The division must be set up and defined in Chart of Accounts setup prior to being available for selection.
Print Zero Balances - Reports default to show all account numbers and balances even if the balance is $0.00. To eliminate the accounts with zero balances, select this option.
Reports
Click Balance Sheet to review and/or print a balance sheet for the selected division(s). Balance Sheet is a result of prior period (beginning balance) totals plus postings updated via Journal Update.
Closing entries must be made to income summary account(s) and retained earnings (via Auto Post Closing), each month or the Balance Sheet will not be in balance and Month End Closing will not be permitted.
Check the summary box, to print balance sheet totals without posting account detail. Balance sheet would show only accounts classified as subtotals or totals (TRAN CODE 6 defined via Chart of Accounts Setup).
Click Budget Analysis Report to review, print or export to Excel, a budget analysis report. Data included on the report: actual and budgeted dollars for current period and actual amount for the same period in the previous fiscal year as well as year to date comparisons for the same categories.
Click Budget Master Listing to review, print or export to Excel, a budget master listing for each account by periods, quarters and annual budget total.
Click Budget Projection to review, print or export to Excel, a budget projection report which will list the current period’s actual, budget, balance of budget remaining, and percentage spent figures. Year-to-date actual, annual budget, balance of budget remaining, and percentage spent figures also print.
Click Budget Variance to review, print or export to Excel, a budget variance report comparing actual and budget and variance figures for the current period as well as year-to-date comparisons.
Click Budget Variance by Consolidation Fields Report to review, print or export to Excel, a budget variance report comparing actual and budget and variance figures for the current period as well as year-to- date comparisons. This report also includes the annual budget amount for each account. This report is based on Consolidation Fields and Report Divisions being set up prior to running.
Click Budget Variance with Annual Budget to review, print or export to Excel, a budget variance report comparing actual and budget and variance figures for the current period as well as year-to-date comparisons. This report also includes the annual budget amount for each account.
Click Chart of Accounts to review, print or export to Excel, a chart of accounts for the selected division(s).
Click Comparative Balance Sheet to review, print or export to Excel, a balance sheet (detail or summary) showing figures for current year-to-date, last year-to-date, and the variance between the two.
Check the summary box, to print a comparative balance sheet report without posting account detail. Report would show only accounts classified as subtotals or totals (TRAN CODE 6 defined via Chart of Accounts Setup).
Click Comparative Balance Sheet Last Period to review, print or export to Excel, a balance sheet (detail or summary) showing figures for current period, last period, and the variance between the two.
Check the summary box, to print a comparative balance sheet report without posting account detail. Report would show only accounts classified as subtotals or totals (TRAN CODE 6 defined via Chart of Accounts Setup).
Click Comparative History Report to review, print or export to Excel, a report that includes an analysis between current period for current year and current period for previous year as well as comparisons year- to-date for current and previous years.
Click Comparative History Multiple-Year Report to review, print or export to Excel, a report that includes an analysis between current period for current year and other multiple year periods.
Click Encumbrance Ytd to review, print or export to Excel, a year-to-date Expense/Encumbrance vs Budget Report. The report lists the following data for each account: Annual Budget Amount, Current Month Actual Amount, Year-to-Date Actual Amount, Year-to-Date Encumbrance Amount, Year-to-Date total of Actual plus Encumbrance, Year-to-Date Amount Over/Under Budget and Year-to-Date Percentage of Budget expended. Encumbrance amounts will only be available if the budget division and general ledger account fields are completed in Purchase Order entry.
Click General Ledger to review, print or export to Excel, a general ledger report that includes all entries (except those made via Prior Period Adjustments) posted to the current G/L accounting period for the selected division(s). Click Division select either all division or individual divisions. Click Printer Icon. Enter or select the range of General Ledger Account # to be included on the report. This is the only report that allows for the entry: From and Thru Account #’s.
Click Income Statement to review, print or export to Excel, an income statement for the selected division(s). The Income Statement is a result of prior period (beginning balance) total plus postings updated via Journal Update.
Click Income Statement Approved Budget to review, print or export to Excel, an income statement that includes amounts for current period and year-to-date as well as the approved annual budget amounts.
Click Income Statement Budget Remaining to review, print or export to Excel, an income statement that includes amounts for current period/current fiscal year, current period budget, variance in dollars, variance by percentage, current period/last fiscal year and variance in dollars between current period/current fiscal year, current period/last fiscal year and year-to-date/current fiscal year, year-to-date budget, variance in dollars, variance by percentage, year-to-date/last fiscal year and variance in dollars between year-to-date/current fiscal year and year-to-date/last fiscal year.
Click Income Statement by Period to review, print or export to Excel, an income statement that includes amounts for each account for each period in the selected fiscal year.
Click Statement of Expenses to review, print or export to Excel, a statement of expenses report (detail or summary) listing current period, year-to-date totals and the percentage of each.
Click Statement of Revenue to review, print or export to Excel, a statement of revenue report (detail or summary) showing current period, year-to-date totals and the percentage of each.
Click Trial Balance to review, print or export to Excel, a trial balance for the selected division(s). The report lists account numbers, titles, beginning balances, current period and ending balances. At the end of each division, the trial balance totals each column and displays a division total.
Click Trial Balance with Fiscal Year Starting Balance to review, print or export to Excel, a trial balance for the selected division(s) with opening balances. The report lists account numbers, titles, beginning balances, current period and ending balances. At the end of each division, the trial balance totals each column and displays a division total.
Click Working Trial Balance to review, print or export to Excel, a working trial balance for the selected division(s). The report includes data for the selected period that can be used to reconcile accounts, providing columns for noting adjusting entries.
Printer
Click Printer Icon (Right Task Bar) to generate the selected report, for viewing/saving/printing. The following form displays.
Click View Icon to review reports prior to printing.
Click Printer Icon to print selected reports, the preview view will not be generated, report will go directly to the printer.
Division
Click Divisions to populate a list of the divisions. Select a Division if the report being generated should only include one or a selected group of divisions.
Export
Click Export to create a Word, Excel or PDF file of the selected report. Program requires Path To Export Data field has a location prior to exporting the documentation. The following form displays.
Click the Word Icon to create a Word document.
Click PDF Icon to create a PDF document.
Click the Excel Icon to create an Excel Spreadsheet.
Report Group
Click Report Group to set up and define the reports to be generated together for that Group.
| Field Name | Field Type | Description |
| Report Group Id | Alpha/Numeric | Enter or select the Report Group Id. Click Green Checkmark to create a new group. |
| Report Name | Highlight/Click Reports to be included in Group Id for preparing multiple documents for the selected group. |
Encumbrance Inquiry
Navigate to Encumbrance Inquiry to display the monthly activity against current fiscal budget amounts.
Inquiry is populated based on selected account number. Encumbrance amounts are updated when line items are entered on Purchase Orders.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Division | Enter or select division from drop down options. |
| Account | Enter or select GL Account # from drop down options. |
| Fiscal Start | Auto populates based on fiscal year selected. |
| Fiscal End | Auto populates based on fiscal year selected |
| Current Period | Auto populates current period. |
| Division Description | Auto populates based on division selected. |
| Account Description | Auto populates GL Account # description from Chart of Accounts. |
| Month | Auto populates months in period order based on fiscal year setup. |
| Budget | Auto populates budgeted amounts for Division and GL Account # selected by month. |
| Encumbrance | Auto populates dollar amounts from open Purchase Orders posted to selected Division and GL Account #. |
| Subsidiary Journals | Auto populates funds updated to subsidiary journals for the Division and GL Account # selected. |
| Remaining | Auto populates remaining total budget balance. |
Financial Graphs
Navigate to Financial Graphs to generate pie or bar charts based on criteria selected, utilizing consolidation fields and values defined via Chart of Accounts Setup.
Pie Chart
Click Pie Chart to generate a pie graph based on selected criteria. This graph requires the following items to be selected prior to generating: Fiscal Year, Period, Revenue or Expenses, Divisions (either All or Specific Divisions), selection of a consolidation field previously defined in the Chart of Accounts Setup, selection of number of items to chart and sort order, either ascending or descending.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Period | Enter or select period from the drop down options. |
| Revenue or Expenses | Check either box for the desired graph. |
| All Divisions | Check box to generate chart to include all divisions or select specific divisions by checking box (es) to the left of the division number. |
| Year To Date | Check box to generate a year-to-date chart. |
| History | Check box to generate a consolidated chart for the previous year. If Year-to-Date box is also checked, Historical chart will contain Year-to-Date figures for previous year. If only history box is check, historical chart will contain revenue/expenses for same period for previous year. |
| Budget | Check box to generate a consolidated graph for amounts budgeted for selected period. |
| Annual Budget | Check box and leave Budget box checked to generate a consolidated graph for annual amounts budgeted. |
| Consolidation Fields | Select one of the five consolidation fields defined in Chart of Accounts Setup |
| From Value | Enter a beginning consolidation value for range or leave blank to include all values |
| To Value | Enter an ending consolidation value for range or leave blank to include all values |
| Number of Items to Chart | Select number of items to be include in graph from the drop down list. i.e. If 5 is selected, the chart will display top 5 account balances. |
| Ascending or Descending Sort | Check box to select sort order |
| Amounts Over/Under | Enter minimum and maximum amounts to be included in the graph or leave blank to include all amounts. |
| Pie Chart Options | Select chart options from the drop down list. (See examples below) |
The following confirmation message will display.
Click OK to create selected options graph or Cancel to return to Financial Graph Form. If OK is selected, the graph will preview on the screen. Click Print to print the graph.
Show Nothing
Show Value
Show Percent
Show Labels
Show Labels and Percent
Bar Chart
Click Bar Chart to generate a bar graph based on the selected criteria. This graph requires the following items to be selected prior to generating: Fiscal Year, Period, Revenue or Expenses, Divisions (either All or Specific Divisions), selection of a consolidation field previously defined in the Chart of Accounts Setup, selection of number of items to chart and sort order, either ascending or descending.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Period | Enter or select period from the drop down options. |
| Revenue or Expenses | Check either box for the desired graph. |
| All Divisions | Check box to generate chart to include all divisions or select specific divisions by checking box(es) to the left of the division number. |
| Year To Date | Check box to generate a year-to-date chart. |
| History | Check box to generate a consolidated chart for the previous year. If Year-to-Date box is also checked, Historical chart will contain Year-to-Date figures for previous year. If only history box is check, historical chart will contain revenue/expenses for same period for previous year. |
| Budget | Check box to generate a consolidated graph for amounts budgeted for selected period. |
| Annual Budget | Check box and leave Budget box checked to generate a consolidated graph for annual amounts budgeted. |
| Consolidation Fields | Select one of the five consolidation fields defined in Chart of Accounts Setup |
| From Value | Enter a beginning consolidation value for range or leave blank to include all values |
| To Value | Enter an ending consolidation value for range or leave blank to include all values |
| Number of Items to Chart | Select number of items to be include in graph from the drop down list. i.e. If 5 is selected, the chart will display top 5 account balances. |
| Ascending or Descending Sort | Check box to select sort order |
| Amounts Over/Under | Enter minimum and maximum amounts to be included in the graph or leave blank to include all amounts. |
| Pie Chart Options | No selection is required for Bar Charts. |
The confirmation message displays.
Click OK to create selected options graph or Cancel to return to Financial Graph Form. If OK is selected, the graph will preview on the screen. Click Print to print the graph.
Monthly
Click Monthly to generate a bar graph for selected criteria. This graph requires the following items to be selected prior to generating: Fiscal Year, Period, Revenue or Expenses, Divisions (either All or Specific Divisions), selection of a consolidation field previously defined in the Chart of Accounts Setup, selection of number of items to chart and sort order, either ascending or descending.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Period | Enter or select period from the drop down options. |
| Revenue or Expenses | Check either box for the desired graph. |
| All Divisions | Check box to generate chart to include all divisions or select specific divisions by checking box (es) to the left of the division number. |
| Year To Date | Check box to generate a year-to-date chart. |
| History | Check box to generate a consolidated chart for the previous year. If Year-to-Date box is also checked, Historical chart will contain Year-to-Date figures for previous year. If only history box is checked, historical chart will contain revenue/expenses for same period for previous year. |
| Budget | Check box to generate a consolidated graph for amounts budgeted for selected period. |
| Annual Budget | Check box and leave Budget box checked to generate a consolidated graph for annual amounts budgeted. |
| Consolidation Fields | Select one of the five consolidation fields defined in Chart of Accounts Setup |
| From Value | Enter a beginning consolidation value for range or leave blank to include all values |
| To Value | Enter an ending consolidation value for range or leave blank to include all values |
| Number of Items to Chart | Select number of items to be include in graph from the drop down list. i.e. If 5 is selected, the chart will display top 5 account balances. |
| Ascending or Descending Sort | Check box to select sort order |
| Amounts Over/Under | Enter minimum and maximum amounts to be included in the graph or leave blank to include all amounts. |
| Pie Chart Options | No selection is required for Monthly. |
The following confirmation message displays.
Click OK to create selected options graph or Cancel to return to Financial Graph Form. If OK is selected, the graph will preview on the screen. Click Print to print the graph.
Annual Chart
Click Annual Chart to generate a bar graph illustrating previous years as selected by user. This graph requires the following items to be selected prior to generating: Fiscal Year, Period, Revenue or Expenses, Divisions (either All or Specific Divisions), selection of a consolidation field previously defined in the Chart of Accounts Setup, selection of number of items to chart and sort order, either ascending or descending.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Period | Enter or select period from the drop down options. |
| Revenue or Expenses | Check either box for the desired graph. |
| All Divisions | Check box to generate chart to include all divisions or select specific divisions by checking box(es) to the left of the division number. |
| Year To Date | Check box to generate a year-to-date chart. |
| History | Check box to generate a consolidated chart for the previous year. If Year-to-Date box is also checked, Historical chart will contain Year-to-Date figures for previous year. If only history box is checked, historical chart will contain revenue/expenses for same period for previous year. |
| Budget | Check box to generate a consolidated graph for amounts budgeted for selected period. |
| Annual Budget | Check box and leave Budget box checked to generate a consolidated graph for annual amounts budgeted. |
| Consolidation Fields | Select one of the five consolidation fields defined in Chart of Accounts Setup |
| From Value | Enter a beginning consolidation value for range or leave blank to include all values |
| To Value | Enter an ending consolidation value for range or leave blank to include all values |
| Number of Items to Chart | Select number of items to be include in graph from the drop down list. i.e. If 5 is selected, the chart will display top 5 account balances. |
| Ascending or Descending Sort | Check box to select sort order |
| Amounts Over/Under | Enter minimum and maximum amounts to be included in the graph or leave blank to include all amounts. |
| Pie Chart Options | No selection is required for Annual Chart. |
The following confirmation message displays.
Click OK to create selected options graph or Cancel to return to Financial Graph Form. If OK is selected, the graph will preview on the screen. Click Print to print the graph.
Financial Statement Builder
Navigate to Financial Statement Builder to allow users to create customized reports.
Report Names
Enter or select fiscal year from the drop down options.
Click Report Names to populate a list of reports that can be generated. The following form displays. Go to the last record on the form to add a new report.
| Field | Description |
| Report Name | Enter a report name. This is the name that will display in the drop down selection list. |
| Report Title | Enter a report title. The title will appear at the top of the printed report. |
| Report Format | Enter one of the four available report formats (See Below). |
| Standard Format | Leave the box unchecked. |
The following Report Formats are available for use in creating customized reports:
- FNGL_FinancialAssetLiabilityReport
- FNGL_FinancialRevExpByPeriodReport
- FNGL_FinancialRevenueExpenseReport
- FNGL_FinStmtBldrBudgetVarianceReport
Print Names
Click Print to generate a report for view/print. All standard reports are listed on this form.
Report Format
Click Report Format define the setup for view/printing selected customized report. The following form displays.
Enter or select a Report from the Report Name drop down options.
A Total Level 2 account will display the total of all of the accounts listed above it with a Total Level 1.
A Total Level 3 account will display the total of all of the accounts listed above it with a Total Level 2, if there are none, it will display the total of all accounts with a Total Level 1.
A Total Level 4 account will display the total of all of the accounts listed above it with a Total Level 3, if there are none, it will display the total of all accounts with a Total Level 2 or 1 if there are no Total Level 2 accounts.
To assign general ledger accounts to the Financial Statement Builder accounts (only accounts with Tran Code 1 are eligible for general ledger account assignment), double click in the Sequence # field, the following form displays.
Field | Max Field Size | Field Type | Description |
| Sequence # | 10 | Number | Enter a sequence number. This number will determine order the ‘accounts’ are listed on this form. Duplicate numbers are not allowed. |
| Account # | 20 | Alpha/Numeric | Assign an account number. This number determines order the accounts are listed on the report. If accounts include letters the data is sorted first by number, then by letter. |
| Title | 50 | Alpha/Numeric | Enter account title as it will appear on financial reports. |
| Tran Code | 1 | Number | Select type of transaction applicable for the GL account from the drop-down options. |
| 0 | Heading account (non-posting). | ||
| 1 | Acquire total from account balances. | ||
| 3 | Combined Revenue/Expense from total level. | ||
| 6 | Subtotal/Total from total level. | ||
| Acct Type | 1 | Alpha/Numeric | Identifies type of account for posting and financial reporting. |
| 1 | Asset | ||
| 2 | Liability | ||
| 3 | Capital/Equity | ||
| 4 | Revenue | ||
| 5 | Expense | ||
| 6 | Revenue percentage calculation. | ||
| Print Column | 1 | Alpha/Numeric | Specify column (1 thru 3) for balance sheet printing (See Note below). |
| Space | 1 | Alpha/Numeric | Specify one of the following to determine vertical print line space between accounts on Balance Sheets and Income Statements (See Note below). |
| 1 | Skip 1 Line (print on next line) | ||
| 2 | Skip 2 Lines (double space) | ||
| 3 | Skip 3 Lines (triple space) | ||
| 4 | Skip 4 Lines (skips 3 lines – prints on 4th) | ||
| 5 | Skip 5 Lines (skips 4 lines – prints on 5th) | ||
| 6 | Skip 6 Lines (skips 5 lines – prints on 6th) | ||
| 7 | Skip 7 Lines (skips 6 lines – prints on 7th) | ||
| 8 | Skip 8 Lines (skips 7 lines – prints on 8th) | ||
| 9 | Force new page | ||
| Total Level | 1 | Alpha/Numeric | A total level code number (1-9) determines where subtotals and totals print on financial reports. The total level code used for heading accounts with Tran Code 0 will not impact the reports (See Note below). |
| Bold Print | Yes/No | Select the checkbox to print the account number, title and amount in bold print on financial reports. | |
| Underline | 1 | Alpha/Numeric | Select single or double to underline the amount on financial reports. |
| Font Color | Number | Select the palette icon to choose a font color to print the account number, title and amount on financial reports. | |
| Sup Print | Yes/No | Select the checkbox to suppress the printing of the account on financial reports when the Summary Option is selected. | |
| Sub Amt | Yes/No | Select the checkbox to subtract the amount from the total. | |
| Rev Sign | Yes/No | Select the checkbox to show credits as positive numbers and/or debits as negative numbers. | |
Field | Max Field Size |
Field Type |
Description |
| Record # | 10 | Number | Enter a record number. This number will determine order the accounts are listed on this form. Duplicate numbers are not allowed. |
| Fiscal Year | Number | Enter or select fiscal year from drop down options. Fiscal year is used to validate general ledger account numbers only. | |
| Division | Number | Enter or select division from drop down options. | |
| From Account | Number | Select first account number that will be grouped under Financial Statement Builder account number from the drop down options (See below) | |
| Title | Alpha/Numeric | Auto populates based on general ledger account # selected in previous step | |
| Thru Account | Number | Select last account number that will be grouped under Financial Statement Builder account number from drop down options. (See below) |
Print Setup
Click Print Setup to generate a report listing report specifications.
Print Report
Click Print Report to generate final report, the following form displays.
Field | Field Type | Description |
| From Fiscal Year | Number | Enter or select starting fiscal year from drop down options. (See Below) |
| From Period | Number | Enter or select first accounting period that will be included on the report from drop down options. |
| Thru Fiscal Year | Number | Enter or select ending fiscal year from drop down options. (See Below) |
| Thru Period | Number | Enter or select last accounting period that will be included on the report from drop down options. |
| Report Date | Date | Enter or select date from calendar that will be displayed at top of the report. |
| Print Account #’s | Yes/No | Check box to include GL account numbers on the report. Account Numbers that will display are those that were created on Report Format form. |
| Print Zero Balances? | Yes/No | Check box to include GL account numbers with zero balances on the report. Unchecking the box will exclude accounts with zero balances. |
| Summary? | Yes/No | Check box to generate a report that excludes GL account numbers set up as suppressed print, which were checked Sup Print. |
Account Balance Inquiry
Navigate to Balances to display and/or print an account balance and transaction listing for a specific account number.
Totals
Click Totals to view transaction totals by month, current period, YTD, LTD and Debit & Credits for selected Period.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down options. |
| Division | Enter or select division from drop down options. |
| Account | Enter or select GL account number from drop down options. |
| Period | Enter or select period from drop down options. |
| Fiscal Start | Auto populates based on fiscal year selected. |
| Fiscal End | Auto populates based on fiscal year selected. |
| Current Period | Auto populates based on current period in General Ledger. |
| Period | Enter or select period from drop down options. |
Transactions
Click Transaction to display/and or print the account balances by month. The following form displays.
Click OK to continue or Cancel to cancel. If OK is selected the following form displays.
Click Print to display/and or print the account balance inquiry report for the selected account. The following reports display.
GL Transaction Inquiry
Navigate to Transaction Inquiry to view GL Transactions.
The inquiry can be general or refined to include one or more selection criteria. The only required field is the fiscal year.
Refresh
Click Refresh to refresh the screen to view selected options. Highlight a selected field.
Click the Binocular Icon to open the Find and Replace form.
Field | Description |
| Fiscal Year | Enter or select fiscal year from the drop down options – Mandatory field. |
| Period | Enter or select period from the drop down options – Optional field. |
| Posting Date | Enter or select posting date from the drop down options – Optional field. |
| Batch # | Enter or select batch number from the drop down options – Optional field. |
| From Posting Date | Enter a starting date or select it from the calendar – Optional field. |
| Thru Posting Date | Enter an ending date or select it from the calendar – Optional field. |
Excel Icon
Click Excel Icon to export inquiry screen data into an Excel spreadsheet.
Excel Spreadsheet:
Quick Balance Inquiry
Navigate to Quick Balance Inquiry to display current fiscal period balance information by division number.
To ensure that you are in balance, run periodically and prior to month end or year end.
| Field | Description |
| Fiscal Year | Enter or select fiscal year from drop down option. Totals will accumulate automatically. |
| Current Period | Auto populates based on fiscal year selected. |
| Start Date | Auto populates based on fiscal year selected. |
| End Date | Auto populates based on fiscal year selected. |
| Debits | Auto populates after balances are accumulated. |
| Credits | Auto populates after balances are accumulated. |
| Balance | Auto populates after balances are accumulated. |
| Balance Sheet | Auto populates after balances are accumulated. |
| Income Statement | Auto populates after balances are accumulated. |