General Ledger reports

General ledger reports give you the means to collect and share vital information about your company's finances. When your company was set up, it included many standard reports that come ready to use, and you can create other financial and custom reports to provide even more insight.

You can run, view, process, memorize, export, and customize General Ledger reports.

Additionally, you can create financial reports and graphs.

Using the Financial Report Writer, you can create innumerable variations of reports, including income statements, balance sheets, budget variance reports, departmental expense reports, gross margin, statement of cash flows, and so on.

Use a standard report

Sometimes your quickest way to the data you want is to go with the default settings. These predetermined (or default) settings are the ones most often selected by others. For example, you can run a standard report preset to the current period on all records without setting any filters.

Select an application link in the following table to see a list of the standard reports available for that application. You create standard reports by configuring the filters available in the report settings page. Depending on the report, there are between 10 and 30 filters, such as accounting period, custom date ranges, detail level, summary views, sorting, grouping, and dimensional analysis.

Some standard reports are available in more than 1 application, and usually have application-specific variations in filters and format.

Standard GL reports

Report	Description
Account balances	Shows balances of accounts by a single account, a range of accounts or an account group.
Account groups hierarchy	Displays a graphical representation of the hierarchy of your account groups, which includes member account groups and their accounts.
Chart of accounts	Shows a filtered list of accounts.
Comparative trial balance	Use to compare account balances over time by comparing 1 reporting period against another.
Deferred revenue details	Shows the details of customers and transactions for which you have deferred revenue for a specific period. For example, if the current month is March and you want to see revenue recognized as of March 31, running this report shows you any transactions processed in March along with a breakdown of the revenue for the transactions that were deferred, recognized, and paid.
Deferred revenue forecast	Shows how deferred income is recognized as revenue over time. Use this report to forecast revenue by time period, account, customer, and more.
Deferred revenue revaluation	Available to companies that use multiple transaction currencies and revenue recognition, this report enables you to revaluate revenue recognition schedule entries based on the Revaluation As of Date and Revaluation Exchange Rate Type. The system calculates the currency gain/loss for every row of the revenue recognition schedule-entry table.
Department activity	Shows a hierarchical list of department activity across the company. You can view data for 1 department or all departments, and for all accounts, or the data for 1 account group. For example, suppose you want to know the liability position for the manufacturing department company wide. You would choose that department and account group. Display the report by department (or by location within the department, if you have selected that option), date, and then account. You can print a report that contains all departments, or individual departments on separate report pages. You can include statistical accounts as well. Display options include the ability to suppress departments that have had no activity in the period, and detailed or summary modes.
General Ledger	Shows data in your General Ledger accounts. You can adjust the time period, accounts, and other criteria to meet your reporting needs.
Journals	Shows the transactions for a journal for a given reporting period. You can filter on location and department, and elect whether or not to display columns for location and department.
Location activity	Shows a hierarchical list of location activity across the company. You can view data for 1 location or all locations, and for all accounts, or the data for 1 account group. For example, suppose you want to know the liability position for the San Jose location company-wide. You would choose that location and account group. Display the report by location (or by department within the location, if you have selected that option), date, and then account. You can print a report that contains all locations, or individual locations on separate report pages. You can include statistical accounts as well. Display options include the ability to suppress locations that have had no activity in the period, and detailed or summary modes.
Trial balance	View balances of all accounts, including or excluding statistical accounts. You can also select the Retain YTD Balances feature to show accumulated balances for income statement accounts that close into retained earnings at year-end.

GL reports and reporting accounts

Reporting accounts is an optional feature in the General Ledger that lets you generate and display reports using account sets other than your General Ledger accounts. Here are the standard reports that you can use with reporting accounts:

• General Ledger
• Trial Balance
• Comparative Trial Balance
• Account Balances
• Journals

For more about reporting accounts, see Introduction to reporting accounts for alternate Charts of Accounts.