General Ledger Standard Report - Balance Sheet and Income Statement 

The General Ledger Standard Report is your basic financial statement report and includes both a Balance Sheet and an Income Statement. Horizon does not recommend using this report in detail format. For a detail report, use the General Ledger Trial Balance Report.

  1. Balance Sheet
    1. The first part of the report contains the Balance Sheet section. In the first section, each GL Account Type will be subtotaled.  
    2. Assets will be listed first with an asset total. Liabilities will be next followed by Equity Accounts.
    3. After equities is a line called Current Year Net Income. This line is the total of all Income and Expense accounts.
    4. Next is an Equity Total that includes the Current Year Net Income. Listed last is the Liabilities and Equity Total.
    5. For the Beginning and Ending Balance columns; the Liabilities and Equity Total should match the Asset Total line.  If they do not match the General Ledger may be out of balance or some general ledger accounts may be setup incorrectly.
    6. If you need assistance in determining why these totals do not match, please call the Horizon Help Desk.
  2. Income Statement
    1. The second part of the report contains the Income Statement section.
    2. Each GL Account Type on the report will be subtotaled.  
    3. Revenues will be listed first with an Income/Revenue Total.
    4. Expenses are next with an Expense Total.
    5. This will be followed by the Current Year Net Income line.  This line should match the Current Year Net Income from the Balance sheet section.

To create custom designed financial reports, use the Financial Statement Setup options, available under the Maintain menu.

NAVIGATION: REPORTS menu > General Ledger Reports > Standard Report

  1. Check Segments to Summarize
    1. Depending upon account setup there may be one to nine segments available for summarization.  
    2. Segments that are checked, beginning with the last segment, will be summarized up to the preceding segment.  No detail will print for the checked segment.
    3. All segments are dimmed, except the segment that is available to select.
    4. As segments are checked, the preceding segment will become available.
  2. Dates: enter or select one of the following:
    1. This Month
    2. Last Month
    3. This Quarter
    4. Last Quarter
    5. 1st Quarter
    6. 2nd Quarter
    7. 3rd Quarter
    8. 4th Quarter
    9. This Year
    10. This Year to Date
    11. Last Year
    12. Last Year to Date
    13. Custom  (allows you to select your own dates)
    14. All  (the from date is blank and the ending date is the current date)
  3. Start Date and End Date: Based on the date criteria selected, the start and end date will automatically fill in with a date range with the following exceptions:  
    1. If Custom is selected the start and end dates will be blank allowing the user to enter a "custom" date range.
    2. If All is selected, the beginning date is left blank and the ending date will be the current date.
    3. Displayed dates for any selection may be edited.
  4. Filtering
    1. Enter or select a general ledger account segment value, into the appropriate segment field, to generate a trial balance with all occurrences of that segment value within the other options selected.
    2. For example: If your first segment had numerical values in the general ledger account structure of 01 - 99.  You could choose to enter the numerical value of 22 in the first segment filter field.  All account numbers that began with 22 would be included on the report.
  5. Subtotal Preferences: Check one or several of the following subtotal options for the report.
    1. Subtotal by Account Types: If this field is checked, a subtotal will be generated in the report for each account type code.  Account type codes are setup and maintained by the user in the Account Type Master.
    2. Assets: Check this field to have the report generate a subtotal for all assets.  Account Type codes are tied to the Asset account type classification in the Account Type Master.
    3. Liabilities: Check this field to have the report generate a subtotal for all liabilities.  Account Type codes are tied to the Liability account type classification in the Account Type Master.
    4. Equity: Check this field to have the report generate a subtotal for all equity accounts.  Account Type codes are tied to the Equity account type classification in the Account Type Master.
    5. Income: Check this field to have the report generate a subtotal for all income accounts.  Account Type codes are tied to the Income account type classification in the Account Type Master.
    6. Expenses: Check this field to have the report generate a subtotal for all expenses.  Account Type codes are tied to the Expense account type classification in the Account Type Master.
  6. Level of Detail: Select one of the following levels for the trial balance:
    1. Summary - The trial balance will only print the balances for each account number listed.  Detail will not be included.  This is the best option for this report.
    2. Detail (Memo)- When the source is AP the report will show the accounts payable distribution reference information.
    3. Detail (Desc) - When the source is AP the report will show the accounts payable vendor.
    4. Detail (Both) - When the source is AP the report will show both the accounts payable distribution reference information, the accounts payable vendor, vendor number and line number..  (Note:  The report will have more pages as each AP source will show two lines of information)
    5. Expanded - For compressed mode of posting, expanded will print out a line for every entry posted to an account.
  7. Print Accounts with No Activity: Place a check mark in this field if you want accounts that have no activity for the date range selected to print on the report.
  8. Include Memo Closing Entries: When this field is checked, memo closing entries will be included on the trial balance report.
  9. Print, preview, or save the report (see Report Preview, Print and Save Options).
  10. The classifications you see on this report come from the GL Account Master where each account is assigned to an Account Type.
    1. If you would like to change Account Types or add additional Account Types, please contact your Horizon Support Representative for assistance.
  11. SAMPLE

See Also: Financial Statements Process

12/2023

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388