Account Analysis

Use the Account Analysis report to get a detailed view of all general ledger activity for the reporting period.

The Account Analysis lists the accounts in order by account number. The report displays the following for each account:

  • Account number
  • Account name
  • Opening balance
  • Transactions posted to the account during the reporting period
  • Closing balance

If you print the report for selected organizations, it displays an opening balance, transaction detail, and a closing balance for each organization.

Because this report provides both closing balances and transaction detail, you can use it as an audit trail of general ledger activity. Deltek recommends that you use the Account Analysis and the Trial Balance report to confirm that all transactions were posted, that the transactions were posted to the correct accounts, and that the correct amounts were posted.

Configuration Settings

You can only generate the cash-basis version of this report if the Enable Cash-Basis Reporting option is selected in Configuration.

The Organization Record Access setting for your role on the Roles form (Configuration > Security > Roles) determines the organizations for which you can see data on this report.

Account Groups

You can use account groups to organize accounts on financial reports.

Multicompany

If the report includes journal entries to intercompany accounts receivable or intercompany accounts payable accounts, you can drill down from the Description column in those rows to see supporting detail in the Intercompany Billing Detail report. (This drill-down option is only available if your role security gives you access to the Intercompany Billing Detail report. It is not available from report rows for tax-related journal entries.)

When you drill down from an intercompany accounts receivable transaction, you see complete detail for the intercompany transaction. When you drill down from an intercompany accounts payable transaction, you do not see the Originating Company Cost Amount and Originating Company Journal Entry Amount columns.

If the report includes rows for accounts belonging to companies other than the active company, the same drill-down option is available from those rows.

Multicurrency

If you use the Multicurrency feature, the report may display amounts in different currencies. If the report contains a total for amounts in a mix of currencies, the report displays #### instead of an amount.

If the report displays amounts in different currencies, it is suggested that you also include currency symbols or currency codes. To do that, click the Layout tab in the Options dialog box and click in Currency to open the Format Currency dialog box. You may want to use the currency code in place of the currency symbol when the report includes more than one currency with the same currency symbol. For example, U.S. dollars and Canadian dollars both use $ as the currency symbol. If you use the code, the report displays USD and CAD instead of the symbol.

An alternative to mixing currencies on the report is to select a presentation currency. When you generate the report, Vision converts all amounts to the presentation currency. The advantage of this method is that you can make meaningful comparisons between amounts, and the report can display meaningful totals.

Options Dialog Box

Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.