Use this tab to enter and view basic information for a primary credit card.
Contents
Fields
Field | Description |
Primary Code
|
This field is enabled only after you click
New on the Credit Cards form toolbar and then select one of the options in the shortcut menu.
Enter a code to identify this primary credit card.
After you save the setup information for a new credit card, the
Primary Code field becomes a display-only field. If you would like to change the primary code, you must set up a new credit card and change the status of the existing credit card to
Dormant. You could also delete the existing credit card if it has not yet been associated with any transactions in
DPS.
When you import credit card transactions from your credit card company into
DPS, the import is based on the primary credit card, which is comprised of transactions that are associated with each secondary credit card that is set up for a primary credit card. Within
DPS, the transactions for the secondary credit cards are filtered and made available on expense reports for the appropriate
employees who are associated with the secondary credit cards. In Credit Card Reconciliation, you reconcile statements based on the primary credit card.
Multiple Companies
If you have multiple companies, the primary code must be unique across different companies.
|
Primary Description
|
Enter a description for the primary credit card.
|
Import credit card charges
|
Select this option if you are importing credit card charges.
|
Use to separate import into secondary credit cards
|
From the drop-down list, select the field to use in import files that your credit card company uses on statements to identify a secondary credit card
account. This field must be included in the import (text) file that contains the credit card statement charges to import into
DPS. In the import file, this field identifies the secondary credit card that is associated with a charge.
Options in the list are:
CardholderName,
SecondaryAccountNumber, and any user-defined field that you set up on the Import tab of the Credit Cards form. You can use
CardholderName if your bank masks the
account number in exported files.
Other fields that are related to this field:
-
Import Value field in the Secondary Credit Cards grid on this tab — In this field you enter the value for the field that you selected in the
Use to separate import into secondary credit cards field. This value identifies each secondary credit card for a credit card.
-
Include check box in the grid on the Import tab of the Credit Cards form — You must select the
Include check box for the field that you select in the
Use to separate import into secondary credit cards field so that the field is included in the statement information that you import from your credit card company.
Examples:
If you select
CardholderName in the
Use to separate import into secondary credit cards field, you enter the name of the secondary card holder (for example, William Apple) in the
Import Value field in the grid on the General tab. You must enter the name exactly as it will appear in the file downloaded from your credit card company. You select the
Include check box for the
CardholderName field on the Import tab. When the credit card charges are imported from the bank using the import utility in Credit Card Reconciliation, each record that has William Apple in the
CardHolderName field will be associated with the secondary credit card that defined William Apple as the import value.
If you select
SecondaryAccountNumber in this field, you enter the secondary
account number for the secondary credit card in the
Import Value field in the grid on the General tab. You select the
Include check box for the
SecondaryAccountNumber field on the Import tab. The
account number should be entered exactly as it will appear in the text file downloaded from your credit card company so
DPS can match to the appropriate secondary credit card.
|
Map to expense report description
|
From the drop-down list, select the field that was imported from the credit card statement and will be displayed and posted in the expense report.
Options in the list are:
{None},
MerchantDescription, and any user-defined field that you set up on the Import tab on the Credit Cards form.
|
Company Paid
|
Select this option when the primary credit card is paid by the company. When selected, all credit card charges associated on an expense report for this credit card will be company paid.
|
Employee Paid
|
Select this option when the company-issued primary credit card is paid by the
employee. When selected, all credit card charges associated on an expense report for this credit card will not be company paid. They will instead flow through to
Employee Payment Processing for the
employee to be reimbursed.
If there are unposted expense reports associated with the credit card, you cannot change it from Company Paid to
Employee Paid (or vice versa).
|
Status
|
From the drop-down list, select the status of the primary credit card.
Options are:
-
Active — Select this option if you want the credit card to be available for
employees to use in
DPS.
-
Dormant — Select this option if you no longer want
employees to use the credit card. The card will not display in any drop-down lists in entry fields and cannot be used for new transaction.
|
Currency
|
This field applies if you use multiple currencies in
DPS. From the drop-down list, select the currency for the credit card. This is the currency in which you pay the credit card company. The credit card reconciliation will be in the currency of the credit card.
If the credit card is
employee paid, the credit currency is based on the currency of the imported transaction. The payment currency, however, is based on the functional currency of the
employee set on the Currency Tab on the General Company Settings form.
|
Secondary Credit Card Grid
Use this grid to enter the secondary credit cards that are associated with the primary credit card. You associate the secondary credit cards with the
employees who are authorized to use them. You must enter at least one secondary credit card for each primary credit card.
After you import primary credit card statement information into
DPS from your credit card company, the secondary credit card transactions display on the Expense Report form.
Employees can select the appropriate credit card transaction to add to their expense report. Only the credit card transactions that are applied to the secondary
account that an
employee is authorized to use displays on the Expense Report form for an
employee.
Secondary Credit Card Grid Toolbar
Field | Description |
Secondary Credit Cards Drop-Down
|
Click the drop-down arrow on a grid header to complete any of the following actions:
- To print grid data, click
Print. On the Print Preview form, click
to send the grid data to your default printer.
- To export grid data to an Excel spreadsheet, click
Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally.
- To turn on grouping for a grid, click
Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display.
Not all options are available on all grids.
|
Insert
|
Click this option to insert a new row in the grid and add a new secondary credit card for the primary credit card.
|
Copy
|
Select a row in the grid that you want to copy to create a new secondary credit card record. Then click
Copy. The information from the selected row is copied to a new row below it.
|
Delete
|
To remove a secondary credit card from the primary credit card, select a secondary credit card in the grid to delete. Then click this option to delete the row from the grid.
If transactions are associated with a secondary credit card, you will not be able to delete it. Instead, change the status of the secondary credit card to
Dormant.
|
Secondary Credit Card Grid Fields
Field | Description |
Code
|
Enter a code to identify this secondary credit card. You must enter a unique code for each secondary credit card that you enter for a primary credit card.
|
Description
|
Enter a description for the secondary credit card.
|
Status
|
From the drop-down list, select a status for the secondary credit card.
Options are:
-
Active — Select this option if you want the secondary credit card to be available for
employees to use in
DPS.
-
Dormant — Select this option if you no longer want
employees to use the secondary credit card. The card will not display in any drop-down lists in entry fields and cannot be used for new transactions. For example, you would change the status to
Dormant when an
employee no longer works at your company.
|
Company Paid Credit
Account
|
Click this field to display the
Find icon. Click the icon to open the
Account Lookup dialog box, and select a general ledger credit
account for the secondary credit card. This
account is commonly a liability or an indirect expense
account.
You could enter a liability
account in this field when one of the following applies:
- As soon as an expense is entered, you consider it to be a liability to the credit card company.
- You use multiple currencies and
employees have a secondary credit card in a currency other than their
employee's functional currency. Entering a liability
account for the secondary credit card will allow you to define the
account as foreign-denominated so that
DPS can revalue the balance in the
account as part of the gain and loss processing.
You could enter an indirect expense
account in this field if you consider the expense report postings as a net zero impact on the income statement and you do not expense the expense report transactions until the credit card statement is entered as a voucher.
The company paid credit
account is used in the following ways:
-
For Expense Reports — The company paid credit
account is used in the expense report posting when a record is defined as company paid, and it has a credit card associated with it. Typically, the expense report debits the
project expense that is defined on the expense report. For company paid items that specify a credit card, the company paid
account is credited. For any record that is associated with a credit card, the company paid
account will override the default company paid
account that is defined on the Options tab and the company paid
account defined on the Expense Categories tab in
in the browser application.
-
For AP Disbursements —The company paid credit
account is used in an AP Disbursement transaction when the payment method is defined as Credit Card. Typically, the AP disbursement debits the expense defined in the AP disbursement, and it credits the company paid credit
account when the payment method is Credit Card.
When you enter a transaction to pay the credit card company (for example, through an AP Voucher), you must specify the company paid
account that is defined in the secondary credit card. The only entries to this
account would be the expense report postings, AP disbursement postings, and the payment to the credit card company
|
Project
|
Enter the
project for the company paid credit
account. If the company paid credit
account for the secondary credit card is an overhead
account, the
project defines the
organization. If the company paid credit
account for the credit card is a balance sheet
account, the
project defines the
organization if you have separate balance sheets or have multiple companies.
|
Phase
|
Enter the
phase for the company paid credit
account.
|
Task
|
Enter the
task for the company paid credit
account.
|
Available to AP
|
Select this check box if you want this secondary credit card to be available for data entry in AP Disbursements in the Transaction Center. When this check box is not selected, the credit card will be available only for Expense Report transactions.
|
Expense Report Users
|
Click in this field to display the
Ellipsis icon that opens the
Employee Assigned to Credit Card dialog box. On this dialog box, select one or more
employees who are authorized to use this secondary credit card to pay for company expenses. Entering an
employee in this field allows the
employee to select the credit card transactions that they paid with the secondary credit card when they enter expense reports. These transactions are loaded into Expense when you import credit card statement information from your credit card company into
DPS in the Credit Card Reconciliation application.
One scenario in which you would enter multiple
employees for one secondary credit card is when an
employee who pays for company expenses with a company-issued credit card has an administrative assistant or other staff members enter expense report in
DPS for them.
If you have multiple companies in
DPS, you can select an
employee from any of the companies in this field, even if the company to which the
employee belongs does not have the Credit Card feature enabled.
After you select
employees in the
Employee Assigned to Credit Card dialog box, the
Expense Report Users field displays the name of the one
employee you selected, or it displays
<records selected> if you selected multiple
employees.
|
Import Value
|
Based on what you select in the
Use to separate import into secondary credit cards field on this tab, enter the value to use to identify the transactions for this secondary credit card when you import the transactions for a primary credit card into
DPS (in
).
- If you selected
CardholderName in the
Use to separate import into secondary credit cards field, enter the name of the
employee who is authorized to use this secondary credit card.
- If you selected
SecondaryAccountNumber in the
Use to separate import into secondary credit cards field, enter the secondary credit card code in this field.
When you import charges from a credit card statement into
DPS, you are importing the charges from all the secondary credit cards that make up a primary credit card. The value that you enter in the
Import Value field must exactly match the value in the credit card file that is being imported into
DPS.
|