General Ledger Cube Report Tips

Use the General Ledger Cube to create Account Analysis, Trial Balance Sheet, Balance Sheet, and Income Statement type reports.

General Report Information

• Use the Report Type - Group Type - Summary - Detail dimension from the Account Groups dimension group in the General Ledger cube to create a Balance Sheet or Income Statement. This dimension groups related accounts together under common account group types, summary name and/or detailed name headings, allowing a temporary reorder of the chart of accounts for financial reporting purposes.

• To create a Balance Sheet report, use the Balance Closing measure instead of the Amount measure in the General Ledger measure group in the Excel PivotTable Field List.

• Iif you enabled cash-basis reporting on the General tab in Configuration > Accounting > System Settings, you can create cash-basis reports in addition to accrual-based reports.

• You can include account group summary and detail level information on reports.

• The Exclude from Report Total, Show Account Detail, and Group Total settings specified for an account group table on the Detail Account Group tab and Summary Account Group tab in Vision's Info Center > Accounts > Account Group Tables have no effect on reports created with Analysis Cubes.

• In General Ledger reports, you can include subtotals for account types only. You cannot subtotal on the first two digits of an account. Also, you cannot have subtotal or total rows, such as Tolerance, Revenue Less Reimbursable, and Total Profit/Loss Total on reports.

• The Organization folder on the PivotTable Field List dialog box contains organization dimensions that identify the organization for the project, phase, or task (whichever is the lowest Work Breakdown Structure level) at the time a transaction is posted.

• The Employees and Projects folders contain organization dimensions that identify the organization for an employee or project at the time that the report data is compiled.

• When adding certain dimension and measure combinations to a report, be aware that a value may not be returned for all rows and columns because of the way the data is stored. For example, the Fiscal Period dimension (instead of any of the Transaction Date dimensions) is more relevant to use with the Balance Opening or Balance Closing measures. For General Ledger reports, the transaction date is considered drill down information.

• General Ledger budgeting data cannot be included on reports.

Report Examples

• Detailed Income Statement using Account Groups across Fiscal Years

  • In an Excel 2007 worksheet, select the following PivotTable Field List items:

    • Rows (in particular order): Account Group Table, Account Group Income Statement, Summary Account Group, Detailed Account Group, and Account Number - Name

    • Columns: Fiscal Year

    • Values: Amount

• Trial Balance By Office and across Fiscal Quarter

  • In an Excel 2007 worksheet, select the following PivotTable Field List items:

    • Rows (in particular order): Account Number – Name and Office

    • Columns: Fiscal Year, Fiscal Quarter, and Values

    • Values: Balance Opening, Amount, and Balance Closing