Financial Statements

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.

NOTE: Items posted but not updated do not appear on the Financial Reports unless the ‘Include Subsidiary Journals’ box was checked

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/Number	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.

NOTE: All numbers on financial statements (except contra accounts and/or a loss on income statement) appear as positive numbers. If this is not the case when you print financials, account type specified is incorrect.

Print Column Note: Although a number must be entered in this field for all accounts, it only affects printing of Balance Sheet accounts

Space Note: Spacing of financial reports may be changed at any time; this only makes a cosmetic change in printing of financials. If any number except 1 is selected, the added lines will appear above the account.

Total Level Note: If subtotals or totals on financial reports are not correct but posting account figures are, this is only a cosmetic problem. Total level codes must be corrected to remedy this situation.

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.

Print

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.