Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Columns for Account Analysis Report

The following columns are available for this report.

Field Description
Account Number This column displays the number associated with the account.
Amount This column displays the net change in the account balance for the reporting period: Total debits – Total credits.
Closing Balance This column displays the balance of the account at the end of the reporting period. If you generate a report for the current period or for the year to date, this column displays the balance on the day that you generate the report. If you generate a report for a range of past periods, this column displays the balance at the end of the last accounting period in the range.
Company This column displays the active company that was used when the transaction was posted.
Department This column displays the department associated with the transaction.
Description This column displays the description of the transaction entered during transaction entry.

If you use multiple companies and 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, and it is not available for tax-related journal entries.)

Description 1, Description 2 If you select Transaction Detail as a sorting/grouping option, these columns display the descriptions for each transaction detail line.

Vantagepoint stores the following types of descriptions for each transaction:

  • Description 1 is a general description of the transaction (for example, the name of the vendor for an accounts payable voucher).
  • Description 2 is a more specific description of the transaction (for example, the description entered during transaction entry for a single item on a voucher).
Due To/From Company If you select Transaction Detail as a sorting/grouping option and the transaction is an intercompany transaction, this column displays the name of the other company involved.
Fiscal Year and Period If you select Transaction Detail as a sorting/grouping option, this column displays the fiscal period in which the transaction was posted.
Opening Balance This column displays the balance of the account at the beginning of the reporting period. For example, if you generate a year-to-date Trial Balance, Opening Balance displays the balance on the first day of the fiscal year.
Organization If you select Transaction Detail as a sorting/grouping option, this column displays the organization associated with the transaction. If your enterprise does not use organizations, this column is not available.
Phase If you select Transaction Detail as a sorting/grouping option, this column displays the phase number associated with the transaction.
Posting Date This column displays the date that the transaction was posted.
Posting Sequence

If you select Transaction Detail as a sorting/grouping option, this column displays the posting sequence number of the transaction. Vantagepoint assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on.

If you preview the report, you can click the link in this column for a transaction to drill down to the Posting Log report.

Project If you select Transaction Detail as a sorting/grouping option, this column displays the project number associated with the transaction.
Reference Number If you select Transaction Detail as a sorting/grouping option, this column displays the reference number for the transaction.
  • If the transaction is an implicit posting or an automatic posting, this column displays Auto.
  • If the transaction is historical, this column displays History.
  • If the transaction is related to revenue generation, this column displays REVGEN.
Row Count This column displays the total number of detail lines for each group, based on the sorting and grouping selections. If the report groups data at more than one level, this column displays row counts for all grouping levels.
Task If you select Transaction Detail as a sorting/grouping option, this column displays the task number associated with the transaction.
Total Credits This column displays the total credits posted to the account during the reporting period.
Total Debits This column displays the total debits posted to the account during the reporting period.
Transaction Amount This column displays the total amount of the transaction, expressed in the transaction currency.
Transaction Closing Balance This column displays the balance of the account at the end of the reporting period, expressed in the transaction currency.
Transaction Currency Code This column displays the code for the transaction currency. This code applies to the amount in the Transaction Amount column.
Transaction Date This column displays the date on which the transaction was posted.
Transaction Opening Balance This column displays the balance of the account at the beginning of the reporting period, expressed in the transaction currency. This amount will be different from the amount in the Opening Balance column if the transaction currency and functional currency are not the same.
Transaction Type If you select Transaction Detail as a sorting/grouping option, this column displays a two-letter abbreviation for the type of transaction (for example, CD for cash disbursements).