Downloading Credit Card Statements

This procedure is optional to be sure all transactions on the statement are entered.

  1. Select A/P > Credit Cards > Download Credit Card Statement. The Download Credit Card Statement window appears.

  2. Do one of the following:

    1. If you have created an automatic online connection with your bank for this account, then select the credit card liability account.

    2. If you have not created an online connection with your bank for this account, you need to go to your online banking site and download your statement in an .ofx format. Then, click the Browse button for Input File and select the .ofx file.

  3. Your transactions for the selected time period are listed on one of two tabs: Matched Entries or Unmatched Entries. Matched entries are those entries that are found both on your credit card statement and in Abacus Accounting. Unmatched entries are those that are found on your credit card statement, but cannot be found in Abacus Accounting. The objective is to get all of the unmatched entries matched or removed so that there are no transactions unaccounted for in Abacus Accounting.

  4. On the Unmatched Entries tab, you need to match, add, or delete entries to remove them from the tab.

    1. Match entries if for some reason Abacus Accounting has missed the match. To match an entry, highlight the record and click Match. A list of Abacus Accounting records appears. Highlight the entry that matches the entry on your credit card statement and click Done.

    2. Add entries if the entry on your online credit card statement is correct and you have not entered the transaction into Abacus Accounting. To add an entry, highlight the unmatched entry and click Add. The Credit Card Input window appears populated with the existing record data. From this window, you can enter the transaction into Abacus Accounting.

    3. Delete unmatched entries if they are not valid and should not be in Abacus Accounting. To remove an entry from the list, highlight it and click Delete. (This does not delete the entry from Abacus Accounting – it only removes it from the list.)

  5. On the Matched Entries tab, do any of the following:

    1. Highlight an entry and click Accept to set the selected transaction to cleared for the credit card reconciliation.

    2. Click Accept All to set all transactions on the Matched Entries tab to cleared for the credit card reconciliation.

    3. Highlight an entry and click Unmatch to place the transaction on the Unmatched Entries tab.

  6. Once you have adjusted all transactions to your satisfaction, you can go on to reconcile the account. Click Reconcile Account on the screen and then skip to step 5 in the Reconciling Credit Card Accounts procedure.