Contents of the Credit Card Review Form

Use the fields to search for and review credit card transactions.

Search Panel

Use the fields in this panel to determine the credit card transactions that display in the Credit Card Charges grid on this form. Some of the fields that display in the filter section vary, based on whether or not the credit card that you enter in the Credit Card field imports charges from a credit card statement into Vantagepoint. The variable fields are noted in the descriptions below.

Field Description
Date Range Enter a beginning and ending date for the range of credit card transactions that you want to display in the grid. For expense report and AP disbursement charge transactions posted in Vantagepoint, the date is the transaction date. For charges imported from a credit card statement, the date is the date imported with the charge. To select a single date rather than a range of dates, specify the same date in both fields.

Posted expense report and AP disbursement credit card charges that do not have a matching imported charge in Vantagepoint are included on a statement based on the dates that are entered in the Date Range field on the header of the Credit Card Reconciliation form for the selected statement.

Statement Date Range Enter beginning and ending statement dates from the drop-down list in the two fields. This allows you to review credit card data from one or multiple statements that are entered in Credit Card Reconciliation. To select one statement, select the same statement date in both fields.

A credit card statement in Vantagepoint is defined by the date entered in the Statement Date on the header of the Credit Card Reconciliation form (Cash Management > Credit Card Reconciliation). Imported charges with or without matching posted expense report or AP disbursement credit card charges are associated with a specific statement.

Credit Card Use the lookup to select a credit card with transactions that you want to display in the grid.

If your enterprise has multiple companies, you can only select credit cards for the companies that you have access to.

Transactions to Include From the drop-down list, select All, Cleared, or Uncleared to determine whether only cleared, only uncleared, or both types of charges display in the grid. This refers to whether or not a charge is cleared on the credit card statement as specified on the Charges tab of the Credit Card Reconciliation form.
Account Use the lookup to select one or more general ledger accounts by which to filter the credit card transactions in the grid. This looks at the accounts that were entered for posted employee expense report and AP disbursement transactions.

Although an Account field does not display in the Credit Card Transactions grid, you can view the account for a charge by selecting a charge in the grid and then clicking Details on the grid toolbar to open the Details dialog box.

Search Click this button to display the search results based on the parameters set in the search panel.

Credit Card Transactions Grid

This grid displays credit card transactions that are determined by the criteria that you enter in the Credit Card Transaction Filter section on this form.

A row in the grid includes all transactions that are associated with an imported credit card transaction ID. This includes the imported credit card charge and any posted expense reports or AP disbursements with the same transaction ID.

A row in the Credit Card Transactions grid could represent only one portion of a charge. This scenario occurs, for example, when a charge has been split between two different general ledger accounts on an expense report, and you have filtered the grid to display only one account. In this case, you can see the complete information for the full amount of the charge on the Details dialog box by clicking the Details option on the grid toolbar.

The fields that display in the grid vary based on whether or not the credit cards for the transactions in the grid are set up to import credit card statements into Vantagepoint. When there are transactions from imported charges in the grid, fields related to the imported information are included. When the transactions in the grid are from only credit cards that do not import statements, the fields in the grid are related to posted information.

Field Description
Credit Card This field displays a charge transaction's primary credit card code and secondary credit card code.
Transaction ID This field displays if there are credit card transactions in the grid whose credit cards are set up to have statements imported into Vantagepoint. This field displays the transaction ID that was imported from the credit card statement into Vantagepoint. You must include transaction IDs in the import file for the ID to display in this field.

This field is blank when an expense report is posted with a charge before the charge is imported from a statement into Vantagepoint (the imported charge was not added to the expense report). This field is also blank for credit card transactions whose credit card is set up not to have statements imported into Vantagepoint.

If a charge is split between multiple projects or general ledger accounts, it is possible for only one line item that makes up only part of the total charge to display in the Credit Card Transactions grid. This would depend on what you enter for filter criteria. You can view all lines for the charge on the Details dialog box when you hover over the grid row entry and click Details.

Transaction Date This displays the transaction date entered for the expense report or AP disbursement for the charge.
Expense Report/Voucher If a charge is from an expense report, the employee name and expense report name display in this field. If the charge is from an AP disbursement, the vendor name, invoice number, and invoice date display in this field. This applies for posted or in-progress expense reports.

Regardless of how many line items make up an expense report or AP disbursement, only one row displays in the grid for the expense report or AP disbursement. Click the Details option on the Credit Card Transactions grid to open a dialog box to see the information for each AP disbursement line item.

If an imported credit card charge is split between multiple expense reports, each expense report displays as a separate row in the grid.

Account This field displays the general ledger account that is entered for the expense report or AP disbursement.

If an expense report has multiple line items that have different general ledger accounts, the Account field displays Multiple Records. To see the specific information for each line item, click the Details option on the Credit Card Transactions grid.

Merchant Description This field displays if there are any credit card transactions in the grid whose credit card is set up to have statements imported into Vantagepoint.

If an imported charge has a matching posted Vantagepoint charge for it, this field displays the name or description of the merchant from the imported charge from a credit card statement. If a posted Vantagepoint charge does not have a matching imported charge for it, this field displays the description from the posted Vantagepoint record.

Currency This field displays only if you use multiple currencies. It displays the currency in which you pay the credit card. This currency is specified in Credit Card Settings for a credit card.
Imported Amount This field displays if there are credit card transactions in the grid whose credit cards are set up to have statements imported into Vantagepoint. The field displays the amount from the imported Amount field for a charge. If you use multiple currencies, this field displays the amount from the imported Payment Amount field.

This field is blank if an expense report was posted with the credit card charge before the charge was imported into Vantagepoint (the posted transaction is not linked to an imported credit card transaction). The field is also blank for credit card transactions whose credit cards are set up not to import statements into Vantagepoint.

A total of the imported amounts displays in the grid below the Imported Amount field. If you use multiple currencies and the charges in the grid have a mix of currencies, the total will be blank.

Posted Amount This field displays the credit card charge amount from a posted Vantagepoint employee expense report or AP disbursement. The field does not display in-progress, submitted, or approved transaction amounts. The field is also blank for imported credit card transactions for which an employee has not yet added the imported charge to an expense report.

For credit card transactions that are imported into Vantagepoint that have an expense report posted for them, the amount in the Posted Amount field could be less than the amount in the Imported Amount field if the expense is split into multiple line items on multiple expense reports and only some portion of the total amount has been posted on an expense report.

Click the blue, underlined amount in this field to view more information about the charge in the Details dialog box. This is the same Details dialog box that opens if you select a charge and then click Details on the grid toolbar.

A total of the posted amounts displays in the grid below the Posted Amount field. If you use multiple currencies and the charges in the grid have a mix of currencies, the total will be blank.

Transaction Description This field displays only if all the credit card transactions in the grid are from credit cards that are set up not to have statements imported into Vantagepoint. This displays the description from a line item entered on an expense report or AP disbursement for the charge.
Document This field applies for expense report charges. If Vantagepoint has been configured to allow you to upload supporting documents, click the icon in this field to open the Supporting Document dialog box to view any supporting documents, such as sales receipts, for a credit card charge for an expense report. The documents were previously uploaded when the expense report was entered.

If there are no supporting documents uploaded, or Vantagepoint has not been configured to allow you to upload supporting documents, the icon displays a +. If there are documents attached to the charge, the icon shows a check mark.

Cleared The checkbox in this field is selected if a charge has been cleared on the Charges tab in Credit Card Statement Reconciliation. The checkbox is cleared if a charge has not been cleared on the Charges tab in Credit Card Statement Reconciliation.
Transaction Status This field displays if there are credit card transactions in the grid whose credit card is set up to have statements imported into Vantagepoint. It does not display if all transactions in the grid are from credit cards that are set up not to import statements into Vantagepoint.

If an imported charge has a matching charge entered on an expense report, this field displays the status of the expense report. Possible statuses are: Posted, In Process, Submitted, or Approved.

If a credit card transaction in the grid is from a credit card that is set up not to have statements imported into Vantagepoint, this field displays Posted. Only posted expense report charges display in the grid.

Click the blue, underlined status in this field to view more information about the charge in the Details dialog box. This is the same Details dialog box that opens if you select a charge and then click Details on the grid toolbar.

User-defined Columns These columns display only if you selected the Display in Review/Reconciliation checkbox in the Import Detail grid of the Import tab in Settings > Cash Management > Credit Cards.
Details This option displays when you hover over a grid row entry. Click this option to open the Details dialog box and review the details for a selected transaction.