Import Credit Card Charges into Vision

You import credit card charges from your credit card company into a statement in Vision using the Vision Credit Card Reconciliation application.

You import charge records for primary credit cards that you set up in Vision. The primary credit card contains charges made with secondary credit cards that have been issued to employees. You import credit card charges from a text file, such as a .txt or .csv file.

Prerequisites: Before you can import charges, you must:

Set up a primary credit card and its secondary credit cards in Configuration > Accounting > Credit Card.
This includes completing the configuration on the Import tab for the import file. You specify the data (fields) to include in the text file and the formatting for the file so that Vision can properly receive the credit card data.
Download the file that contains credit card statement data from your credit card company's website. You must convert it to a text file format that matches the import file configuration that you set up in Vision.
Create a credit card statement in Accounting > Credit Cards > Credit Card Reconciliation in which to import credit card charges.

To import charges from a credit card statement, complete the following steps:

On the Vision Navigation menu, click Accounting > Credit Cards > Credit Card Reconciliation.
On the Credit Card Statement Selection dialog box, enter the information to create a new statement, or select an in-progress statement for the credit card and click Select.
On the Credit Card Statement Reconciliation form toolbar, click Import > Import Charges.
If you previously imported some transactions for a statement, you receive a dialog box that says Table: VisionImport_CreditCard_<Credit Card ID>_Admin already exists. Do you want to overwrite it? Click Yes to proceed.
In the Import New Charges dialog box, click Browse beside the Text File field.
On the Open dialog box, select the text file to import, and click Open.

On the Import New Charges dialog box, click OK. The import process begins immediately.

Option	Description
If no errors are found in the import file	An Import New Charges dialog box displays and identifies the number of valid records in the text file to import. Click Import on this dialog box.
If all the charge records in the import file contain errors, a message displays to say *<x number> error records inserted to table VisionImport_CreditCard_<Credit Card ID>_Admin*	Complete the following actions: Click OK to end the import process. The error records are temporarily inserted into a Vision table in order to provide details on the Import Charges Error report. On the toolbar for the Credit Card Statement Reconciliation form, click Import > Import Charges Error to review a report that identifies the problems. The error report identifies any problems with the format of the imported file (as compared with the required format defined in Credit Card Configuration). The report also identifies any duplicate charges based on transaction ID. Fix the errors in the import file before you try importing again.
If some but not all of the charge records in the import file have errors	An Import New Charges dialog box displays. It identifies the number of valid records and invalid records that have errors. Perform one of the following actions on the Import New Charges dialog box: Click Import to import all the valid records. On the next dialog box that identifies the number of valid records imported and the errors, click OK. The import process finishes, and the imported charge records now display on the Charges tab of the Credit Card Statement Reconciliation form. Click Cancel to stop the import process and not import any charge records from the file. After you select either Import or Cancel on the Import New Charges dialog box, on the toolbar for the Credit Card Statement Reconciliation form, click Import > Import Charges Error. Review the Import Charges Error report to determine how to fix the errors in the import file. Fix the errors in the import file before you try importing it again.

On the next dialog box that informs you that the records were imported, click OK. The imported credit card charges now display on the Charges tab of the Credit Card Statement Reconciliation form. These charges also display in the Credit Card pane on expense reports in Time & Expense for the employees who are assigned to the secondary credit cards.