Reconcile Credit Card Statements that Do Not Contain Import Charges

Compare your credit card statement charges to the charges that have been entered in Vision through employee expense reports and AP disbursements to reconcile discrepancies and any missing charges.

Prerequisites: These instructions apply only if you do not import charges from a credit card statement into Vision for a credit card. Before you reconcile a credit card statement, you must post expense reports that contain credit card charges and post AP disbursements that pay a voucher by credit card.

To reconcile a credit card statement that does not contain imported charges, complete the following steps:

  1. From the Vision Navigation menu, click Accounting > Credit Cards > Credit Card Reconciliation.
  2. On the Credit Card Statement Selection dialog box, complete the fields to enter a new statement, or select an in-progress statement, and then click Select.
  3. If this is a new statement, on the Main tab of the Credit Card Statement Reconciliation form, enter the range of dates that determines the charge transactions that will be included in this reconciliation.
  4. On the Charges tab of the Credit Card Statement Reconciliation form, compare the charges in the Credit Card Charges grid with the credit card statement from your credit card company. The grid displays the posted expense report transactions that are associated with the credit card charges and AP disbursements that paid a voucher by credit card.
  5. Select the Cleared check box for any charge in the grid that has a matching charge on the credit card statement.
  6. Insert any missing charges that display on your credit card statement but do not have a corresponding posted charge in Vision. You track these missing charges, and then clear both the missing charge and the posted expense report after the card holder enters the transactions.
  7. On the Summary tab of the Credit Card Statement Reconciliation form, complete the following tasks:
    1. Enter any finance charges or monthly fees for a credit card statement in the Additional Balance field.
    2. Review the cleared and uncleared totals to determine whether entries are missing in Vision.
    3. Verify that there is no difference between the statement ending balance (from the credit card statement) and the cleared balance plus the additional balance amount. A difference of 0 means your credit card statement balanced with the entries in Vision.
  8. After all records on the Charges tab have been cleared, if you use cash-basis accounting, you can create a journal entry for the company-paid expenses on the Create Journal Entry tab.
  9. After all records on the Charges tab have been cleared and the reconciliation is complete, click the Closed check box on the Main tab of the Credit Card Statement Reconciliation form. The statement date no longer displays in the list of in-progress statements on the Credit Card Statement Selection dialog box when you click Accounting > Credit Cards > Credit Card Reconciliation. You can re-open a closed statement by selecting Closed in the Statement Status field on the Credit Card Statement Selection dialog box, and then clearing the Closed check box on the Main tab of the Credit Card Statement Reconciliation form.
  10. Click Save on the toolbar.