General Ledger Reports

The general ledger reports help you present and monitor financial information. Some reports, such as the Balance Sheet, are standard financial reports. Other reports help you manage your company's finances. For example, the Profit Planning Monitor compares actual performance to corporate budgets.

Settings that Affect General Ledger Reports

You can only generate the cash-basis version of these reports if you select the Cash Basis Reporting option on the General Ledger Options form (Settings > General Ledger > Options).

The Organization Record Access setting for your role on the Overview tab of the Roles form (Settings > Security > Roles) determines the organizations for which you can see data on these reports.

Account Groups

You can use account groups to organize accounts on financial reports. You establish account groups on the General tab of the Accounts form (Settings > Accounting > Chart of Accounts).

You can make financial reporting more flexible if you set up a second level in your account group structure. If you create both summary account groups and detail account groups, you can generate both summarized versions and detailed versions of financial reports.

Drill Down Tab for General Ledger Reports

The Options dialog box for the General Ledger reports contains a Drill Down tab. Use this tab to specify the report values from which you can drill down when you view reports in the Preview window.

Values on which you can drill down appear as underlined links in the Preview window. Click an underlined value to display more detailed information related to that value.

Multiple Companies

If you use multiple companies, you can generate consolidated versions of some General Ledger reports. The consolidated reports combine data from multiple companies in your enterprise.

A general ledger report that contains information from multiple companies displays the following text in the report footer:

*** This report contains data from multiple companies ***

Related Topics:

  • Two Levels of Account Groups for Customizing GL Reports
    If you set up both summary and detail account groups on the Accounts form in Settings, you have formatting options for your general ledger reports. For example, if you set up two levels of account groups, you can generate general ledger reports with the financial statement layouts used in the United Kingdom.
  • Custom Columns for General Ledger Reports
    You can include up to 13 custom columns on the Balance Sheet, Income Statement, and Profit Planning Monitor reports.
  • Drilling Down from GL Reports
    Use the Drill Down tab to select types of data that you need to drill down.
  • Account Analysis
    Use the Account Analysis report to get a detailed view of all general ledger activity for the reporting period.
  • Balance Sheet
    The Balance Sheet displays the distribution of your firm’s assets, liabilities, and net worth as of the current date.
  • Diary Report
    If the active company is set up to assign transactions to diaries, use the Diary report to review general ledger transactions by diary.
  • Income Statement
    The Income Statement provides a detailed statement of your revenue and expense account balances for the current period and year to date. The report also displays the current period and year-to-date operating profit or loss amounts.
  • Profit Planning Monitor
    Use the Profit Planning Monitor to monitor performance against budgets. For each revenue and expense account, the report displays the budgeted and actual amounts for the current period and year to date.
  • Trial Balance
    Use the Trial Balance report to verify that your debits equal your credits for the period.
Parent Topic: Report Descriptions