General Ledger Reports

Show dimensions values

To view one or more dimension values to your report, click the Add/edit link in the Show dimensions values field.

1. From the Available items list, you can select individual dimensions by (ID or Name) clicking the right arrow, or you can click Add all.
2. In the Selected items list, you can rearrange the selected dimensions into the order you want them displayed in your report simply by dragging and dropping.
3. Click Done.

Show zero balance accounts

Select how zero balance accounts are presented in your report:

• All: Include all accounts, regardless of their balance.
• Only with activity: Include accounts with zero balances only if they have transaction within the selected timeframe.
• Do not show: Include only accounts with balances not equal to zero.

Show transaction presentation

This specific option will affect how you are able to drill down from the general ledger report to a specific transaction:

• Summary – display the report with summarized columns in landscape mode. This option will allow you to drill down directly into a batch summary as defined in your module configuration (one per bill, daily, month, etc.)
• Details – display the report with line item details—including beginning and ending balance, debits, credits, and adjustments—in portrait mode. This option will allow you to directly drill down into an individual transaction (bill, invoice, etc.)

Doc column value

Select the type of data to use when populating the Doc column:

• Reference Number. Click this option to display the reference number. If there is no reference number entered, the system displays the bill, invoice, or adjustment number.
• Bill/Invoice/Adjustment Number. Click this option to display the bill, invoice, or adjustment number (for example, the check number for the check used to pay the bill). If there is no bill, invoice, or adjustment number entered, the system displays the reference number. This option is available only if you have chosen selected Details as your Show transaction presentation option.

Show department/location with activity

Select to display only departments and locations with some activity in the current period. Departments/Locations with no activity in this period will display only if you deselect this checkbox.

Show net change

Select to determine the net loss on an account without doing the math yourself.

In your report, you will see an additional line that shows the net change for each account for the period on which you are reporting. More specifically, the net change is the account total plus the debits minus the credits. If you selected the prior year as the period, it is the net change for the prior year.

Show transaction number

Select to include the transaction number in the format.

Retain YTD balances

Select to include accumulated balances for income statement accounts for the fiscal year as of the beginning of the period.

Include account on each line for CSV export

Select to repeat account information on each line of the CSV report This selection only applies when you export the report to a CSV file.

Totaling options

Select group by option

Select to group the report results by location, department, or other dimension. Click the drop-down list and click the dimension by which to group the data. 

Show transaction subtotals

Select to make very large reports run faster.

For example, suppose you want to run a 1,000-page report for an entire year with many accounts and transactions. You probably do not need the details on offset accounts. This field summarizes that detail into one number.

Show totals only for offset accounts

Select to show only totals for offset accounts in the report output.

Show monthly/period totals

Select to display totals beneath transactions for a given month or period.

The monthly or periodic transaction total appears beneath the transactions for that month or period. This is similar to a subtotal function in Excel.

This option isn't available for reports exported using the .CSV method.

Print page options

Page orientation

Select how you want your page to print:

• Portrait: display or print the report pages vertically
• Landscape: display or print the report pages horizontally

Fit to one page wide for printing

Select to resize and shrink columns as needed to fit them to a single page wide, which can be useful for wide reports that include columns for multiple dimensions.