G/L Account Inquiry


General Ledger Menu -> Account Inquiry

This program is the basic General Ledger account inquiry. Activity can be reviewed for one account at a time.
The source posting function name is included on the spreadsheet output and the expanded detail output using the "Paging" option. For more information on the source posting functions, refer to G/L Activity By Posting Source.

To view detailed postings by a transaction or transaction group, refer to the Account Inquiry by Transaction # utility instead.

The prompts by account are:

ACCOUNT NUMBER
Enter the account number to be displayed, or select it from the G/L Account Search window.

DIVISION, ALL, OR SEL
  • Type ALL to include all divisions in the report.
  • To print the report for a single division, leave this field blank for the Head Office Division, or enter a specific division code, or select a division from the drop-down list.
  • Type SEL to select several specific divisions or divisions by accounting region to include in the report, as outlined in Division Select By Region.

Note: This report respects the Divisional Restricted Views designated for the operator.


YEAR START DATE
Enter your fiscal year start date.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.

PERIOD START DATE
Enter the date to begin the inquiry.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.

PERIOD END DATE
Enter the end date for the inquiry.
This defaults to the date previously defined when the GL account totals were last summarized, and can be over-typed as required.

PRODUCT
This field can be left blank to include all transactions in the selection range.
A product number can be enter to select only transactions relating to that specific product in the selection range. An Inventory Search window is provided to search for the product number.

ACCUMULATE PRIOR BALANCE
Uncheck this box to restrict the total balances of the Debits and Credits, and the balance difference that are displayed, to just the transactions in the date range selected.
This could be faster as the software is not required to calculate the balance forward.

Check this box to include the sum of prior entries to produce a balance forward for Debits, Credits, and the balance difference.
This may take longer processing time depending on the volume of data history.

Note: When Accumulating Prior Balances the General Ledger accounts are totalled as follows:
Asset or Liability: Balance forward is from beginning of time.
Revenue or Expense: Balance forward is from Fiscal Year Start selected above.

REPORT OPTIONS
Select one of the following output options:
  • Select Paging to generate the information in a detailed paging screen format providing the ability to move through the transactions and to drill down to document and G/L details, as outlined in G/L Transaction Details.
  • Select Print to generate the output according to the reporting selection currently defined for this session in the Printer Selection window, accessible from the Printer -> Set Printer option located on the menu bar at the top of the screen.
    Output can be in summary or detail.

  • Select Excel to export the output the G/L transaction Detail to a spreadsheet.
    The ability to email the spreadsheet or display it on the screen is controlled by the Prompt to Email Spreadsheets flag set in Company Miscellaneous Parameters.

    Note: Report totals are not generated on the spreadsheet format.


OUTPUT TYPE
This field applies only when the Report Option is for the Display format.
Select one of the following output type options for the display:
  • Select Summary to view only totals for that date range.
    This option is not available for the Paging or Excel output options.
  • Select Detail to view each transaction for that account for that date range.


Finished?
Click ACCEPT to generate the output, or click CANCEL to abort.

Example of Detailed Display Inquiry:
(with no paging screen & accumulating prior balance)

        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

        G/L ACCOUNT INQUIRY FOR: 4000   RENTAL REVENUE
        DIVISION: HEAD OFFICE
        FROM: 10/01/20XX  TO: 10/31/20XX

        TRANS# DIV   DATE      SOURCE  REFERENCE      DEBIT       CREDIT  PRODUCT/SERV TAX DETAILS
        ------ ---   ----      ------  ---------      -----       ------  ------------ --- -------
        101015  1  10/01/20XX  573328  SWANSON ELEC.             3000.00      1901-01
        101017  1  10/01/20XX  573329  CASH SALES                 450.00         S007
        101020  1  10/05/20XX  573330  CASH SALES                 200.00         S008
        101023  1  10/20/20XX  573331  FORD CORP.                4500.00      2301-03
        101025  1  10/31/20XX  573332  CASH SALES                1000.00      1401-00
        101030  1  10/31/20XX  573333  CASH SALES                1043.00       S003-A
        101036  1  10/31/20XX  573334  CASH SALES                 105.00        SERV1

                                                        0.00    11243.00

                                      BALANCE:                  56124.56-


        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Topic Keyword: GLGL15
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)