Reconciling Credit Card Statements With or Without Importing Charges

You can use Credit Card Reconciliation with or without importing charges from a credit card company.

Using the Credit Card Reconciliation Application With the Import Feature

The following table lists the steps that apply if you import credit card charges from a credit card company into a statement in Vision. You specify whether or not to import charges for each primary credit card in Credit Card Configuration. You can pay the credit card company at any time during this process.

Step Action in Vision Description
1 An Accounting employee creates a credit card statement in Vision. You create a credit card statement in Accounting > Credit Cards > Credit Card Reconciliation.
2 An Accounting employee imports credit card charges into Vision. You import credit card charges to a statement using the Import > Import Charges option on the toolbar of the Credit Card Statement Reconciliation form in Accounting > Credit Cards > Credit Card Reconciliation.

Frequency of importing could be daily, weekly, bi-weekly, semi-monthly, monthly, or as needed.

The imported charges prefill:
  • On the Charges tab in the Credit Card Reconciliation application.
  • In the Credit Card pane on the Expense Report form in the Expense Report application.
3 Alerts can be sent automatically to employees to notify them when a charge from their company-issued credit card has been imported into Vision from a credit card statement; it is now ready to add to an expense report. You set up the New Credit Card Transaction Available alerts in the Expense folder in Configuration > General > Company Alerts.

You can also set up a past due alert to send to employees (and optionally, their supervisors) when a certain number of days has passed and the imported charge has not been added to an expense report.

4 Employees add the imported charges to their expense reports. Expense reports are posted. Employees add imported charges to their expense reports from the Credit Card Charges pane on the Expense Report form in Time & Expense > Expense Report.
5 AP disbursements are entered and posted to record vouchers paid by credit card instead of a paper check or electronic payment. When you create the AP Disbursement transaction file in Transaction Center > Transaction Entry, select Credit Card in the Payment Method field on the New File dialog box. Only the secondary credit cards that have the Available to AP check box selected in Credit Card Configuration are available for payments in AP Disbursement Transaction Entry.
6 An Accounting employee reconciles the credit card statement.

You clear and reconcile credit card charges on the Charges tab in Accounting > Credit Cards > Credit Card Reconciliation. You can automatically or manually clear the charges that have both an imported and posted amount.

On the Summary tab, enter any credit card finance charges or monthly fees in the Additional Balance field.

If you use cash-basis reporting, on the Create Journal Entry tab, create a cash-basis journal entry for all the company-paid charges on a credit card statement.

After all charges are cleared and the statement is completely reconciled, on the Main tab, you specify that the statement reconciliation is closed.

Using the Credit Card Reconciliation Application Without Using the Import Feature

You can use the Credit Card Reconciliation application without importing charges from credit card statements into Vision. In this scenario, the posted expense report and AP disbursement transactions that are associated with a credit card automatically display for a statement on the Charges tab in the Credit Card Reconciliation application. You compare these with your paper credit card statement and manually select the Cleared check box for any Vision charge that has a matching item on the credit card statement.