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

Summary Tab of the Credit Card Reconciliation Form

Use this tab to review the summary of imported, cleared, and uncleared totals for each secondary credit card.

You can also enter any finance charge or monthly fees for a credit card statement to help determine that there is no difference between the statement ending balance and the cleared balance plus the additional balance amount.

Contents

Field Description
Statement search Use the field next to the form title to search for and select an existing credit card reconciliation to view or edit.
Click the filter drop-down arrow on the left side of the search field, and select one of the following search types:
  • In Progress: Select from a list of all open credit card reconciliations to which you have access.
  • Closed: Select from a list of all closed credit card reconciliations to which you have access.
  • All: Select from a list of all credit card reconciliations to which you have access.
  • [saved custom search filter]: Select a previously saved custom filter to display the credit card reconciliations returned by that custom search.
  • Custom: Display the Custom Search dialog box. You can then create and apply a new custom search filter, which you can save for future use.

For information about creating and using searches, see the Search Vantagepoint help topics.

x of x Use these arrow icons to scroll through the billing labor rate tables and open a different record on the form. The numbers show you which record you are viewing out of the total number of records in the search results.
+ New Statement Click this option to create a new credit card reconciliation.
Click the Switch to List View icon to switch to the list view of the form. In this view, fields are displayed in columns in one grid on the form rather than on separate tabs. Table name records are displayed in each row in the grid. This makes it easy to compare and update multiple records at one time because you do not have to open individual records. You can add, remove, or change the order of the columns in the grid by clicking to the right of the grid. This opens the List View Settings dialog box.

Click to filter the grid contents based on column values. For information about how the filter works, see Filter the Grid Results.

For information about selecting columns, see Select Columns for a Grid.

For more information and instructions on how to use list view, see Use the List View.

After you have switched to list view, click the Switch to Detailed View icon to switch back to the detail view of the form. Detail view is the default view that displays when you open a form for the first time; thereafter, the view that was active when you closed the application will display when you next open it. The detail view is the format that is described in help topics in the Help system.
<Credit Card Name> - <Statement Date>, Date Range, <Active Company> These fields display the credit card name and statement date of the credit card reconciliation, followed by the date range of the statement. If Vantagepoint is set up for multiple companies, the name of the active company also displays.
Import Charges Click this option to import new bank transactions to the bank reconciliation. This option only appears if you select the Enable Credit Card Import check box on the Options tab of the Credit Cards form in Settings > Cash Management > Credit Cards.
Other Actions/Actions If you have the Import function enabled, this displays as Other Actions. Otherwise, it displays as Actions. Choose an option from the drop-down list:
  • Close Statement: This option displays if the current bank reconciliation state is still in progress. When the reconciliation is completed, select this option to mark the reconciliation as closed. Closing a reconciliation removes the statement date from the list of "in progress" statements on the Bank Statement Selection dialog box, to make it easier to select statements in the future. It also disables options on the other tabs on the Bank Reconciliation form. However, you can choose Reopen Statement at any time to reopen the reconciliation.
  • Reopen Statement: This option displays if the current bank reconciliation record is closed. When the reconciliation is closed, select this option to reopen the reconciliation. Reopening a reconciliation moves the statement back to the "in progress" state, which allows you to make changes and view the reconciliation.
  • Import History: Select this option to open the Import History dialog box and view or undo imported credit card charges. You can undo credit card charges if you have imported them into the wrong credit card statement.
  • Errors Report: Select this option to import a report that identifies any errors that were encountered during the last import that you performed for the statement currently open in Credit Card Reconciliation.
  • Create Cash Journal Entry: Select this option to create a cash-basis journal entry for all the cleared company-paid charges on the Charges tab of the Credit Card Reconciliation form for a statement that is completely reconciled.
  • Export All: This option displays if you are in list view. Select this option to export records to a comma-separated values (CSV) file. You have the option of selecting all records (the default) to a .CSV file. This function is disabled if you are in detail view.
  • Export Selected Rows: This option displays if you are in list view and you select one or more records in the grid. Select this option to export the selected records to a .CSV file. This function is disabled if you are in detail view.
  • Print: Select this option to generate the Credit Card Reconciliation report for the currently displayed reconciliation.

Credit Card Transaction Summary Grid

This grid displays a summary of the detailed information from the Charges tab for each secondary credit card that is associated with the statement's primary credit card. Each row in the grid summarizes and displays the total amounts for a secondary credit card that is associated with the statement's primary credit card.

If you use multiple currencies, the amounts display in the currency of the credit card, which is defined in Settings > Cash Management > Credit Cards. This is the currency in which you receive the credit card statement and is likely the currency in which you pay the credit card company. If the credit card currency is different than the functional currency of the credit card company, the Functional Currency Cleared Charges (<currency>) field also displays in the grid.

Field Description
Secondary Account This field displays a secondary credit card that is associated with the primary account for the statement.
Imported Charges This field displays only if you import charges from a credit card statement into Vantagepoint for the primary credit card. This is the total amount of all imported charges that displays on the Charges tab for a secondary credit card. These charges display with an amount in the Imported Amount field on the Charges tab.
Total Charges This field displays only if you do not import charges from a credit card statement into Vantagepoint for the primary credit card. This is the sum of the amounts in the Cleared and Uncleared/Missing Charges columns for a secondary credit card.
Cleared Charges This field displays the total of the charges for a secondary credit card that have been posted in Vantagepoint (via an expense report or AP disbursement) and specified as cleared on the Charges tab.

If you import charges from a credit card statement into Vantagepoint for the primary credit card, the cleared charges total is the total of the amounts in the Posted Amount field on the Charges tab for charges that have the Cleared check box selected.

If you do not import charges from a credit card statement into Vantagepoint, the cleared charges total is the total of the amounts in the Amount column on the Charges tab for charges that have the Cleared check box selected.

Uncleared/Missing Charges This field displays the total of uncleared charges on the Charges tab for a secondary credit card.
If you import charges from a credit card statement into Vantagepoint for the primary credit card, this amount includes both of the following:
  • Uncleared imported charges (including charges that have or do not have an associated posted amount). This is the imported amount from the Charges tab.
  • Uncleared posted Vantagepoint charges that are not associated with an imported charge on the Charges tab. This is the posted amount from the Charges tab.
If you do not import charges from a credit card statement into Vantagepoint for the primary credit card, this amount includes both of the following:
  • Missing charges that you insert in the Charges grid on the Charges tab.
  • Uncleared posted charges on the Charges tab.
Functional Currency Cleared Charges (<currency>) This field displays if you use multiple currencies and the credit card currency (entered in Credit Card Settings and used to pay the credit card company) is different than the functional currency of the credit card company. This field displays the functional currency amount of the original expense report and AP disbursement transactions from the time of the posting.

You can use the amount in this field to calculate the amount for a journal entry to record the gain or loss in the value of an expense amount as the result of exchange rate fluctuation during the time between when an expense report is posted and the credit card voucher is paid. After the statement is reconciled, you can calculate the amount for the manual journal entry by taking the functional currency cleared charges amount less the amount of the voucher in the functional currency that was entered to pay the credit card statement (as seen on the AP Voucher Posting Log). The journal entry would be made to the company paid accounts and the gain/loss account (likely the realized gain/loss account if the credit card company has already been paid).

Totals The totals for each column in the grid display on the last row at the bottom of the grid.

Other Fields

The amounts below the grid show you whether or not the statement is completely reconciled.

Field Description
Statement Beginning Balance This field displays the beginning balance from your credit card statement.
Statement Ending Balance This field displays the ending balance from your credit card statement.
Cleared Balance This field displays the total of all cleared changes from all secondary credit cards for a statement.
Additional Balance Enter any missing amounts, such as finance charges or monthly fees for a credit card statement. If you import charges from credit card statements into Vantagepoint and you would also like to import the finance charges/monthly fees, you could set up a secondary credit card in Credit Card Settings for finance charges/fees to record these charges.
Difference This field displays the statement ending balance less the cleared balance and less the additional balance. A statement with a 0 difference is completely reconciled.
Notes This field displays notes that you enter during the reconciliation process.