Matching downloaded credit card transactions with Sage 100 Contractor transactions

If you want Sage 100 Contractor to try to match credit card transactions from your bank with transactions in Sage 100 Contractor, you need to connect the credit card account to your bank using Sage Bank Feeds, and then download the transactions. (See the steps in Connecting your credit card account using Bank Feeds.) Then, you can using the matching feature to reconcile the transactions.

Automatically matching credit card transactions with Sage transactions

After you download credit card transactions, the Match Banking Transactions window appears. Automatically matched transactions are displayed in the bottom portion of the Match Banking Transactions window.

The program automatically matches credit card transactions with existing transactions in Sage 100 Contractor if they:

  • Are unique (very similar or duplicate transactions cannot be matched automatically).
  • Have the same payee and amount.
  • Are dated earlier than the corresponding bank transaction.

If one Sage credit card transaction matches a downloaded credit card transaction, it is moved to the list of matched transactions at the bottom of the window.

If there are multiple potential matches, the Sage transactions remain open (unmatched). You need to match these transactions manually.

Manually matching transactions to finish the reconciliation

To finish the reconciliation, you need to match any transactions remaining in the top part of the window manually, as follows:

  1. Select an unmatched banking transaction on the left side of the window and then click the corresponding Sage 100 Contractor transaction (or transactions) on the right side of the window.

  2. Use the buttons in the window to reconcile the transaction, as follows:

    • Remove. You use this button to remove a selected transaction from the bank transaction list. For example, if you downloaded a credit card transaction that you reconciled previously, it is no longer outstanding, so you can remove it from the transactions to be reconciled.

      Notes:  

      • Removing the transaction from the bank transaction list does not affect your Sage 100 Contractor transactions.

      • Removed transactions will not be imported again.

      If the transaction was matched previously, the Sage transaction appears in the 4-7-5 Reconcile Credit Card Accounts window as a manually matched transaction.

    • Add to Sage. You use this button to add a selected bank transaction to Sage 100 Contractor using the 4-7-3 Credit Card Receiptswindow.

    • Match. When matching bank transactions manually, you can select one or more Sage transactions. (To select several Sage transactions, hold the Ctrl key down as you select transactions from the list.) When the amount of the selected Sage transactions equals the bank transaction, the [Match] button becomes available.

      Clicking [Match] moves the selected transactions to the list of matched transactions.

    • Unmatch. If you make a mistake while matching or if an automatic match is not correct, you can select the matched bank transaction and then click [Unmatch] to remove the bank transaction and the Sage transaction(s) from the list of matches. This operation removes the transactions to the upper part of the window, where you can match them with other transactions.

  3. Repeat steps 1 and 2 for each unmatched transaction, until all the transactions are matched..

  4. Click [Confirm Matches] to add matched transactions to the 4-7-5 Reconcile Credit Card Accounts window and return to the 4-7-5 Reconcile Credit Card Accounts window.

    Sage 100 Contractor marks automatically matched transaction with a double check mark, indicating that they have been cleared through the Bank Feeds reconciliation process.

    If you clear the check marks for a transaction, both the bank transaction and the previously matched Sage transaction are restored to the Match Banking Transactions window, where you will need to match them manually.

  5. Save the reconciliation. You can choose to save the reconciliation as a Trial version or a Final version.

    • If you save a Trial reconciliation, when you next display the account, if you click [Display Items], Sage 100 Contractor shows all previously matched transactions and any new transactions in the 1-5 Bank Reconciliation window.

      Providing you do not do a Final save of the bank reconciliation, you can click Bank Feeds > Match Banking Transactions at any time to return to the Match Banking Transactions window and continue the reconciliation process.

    • If you save a Final reconciliation, previously matched items are no longer available for reconciliation.

If no transaction in Sage 100 Contractor matches a downloaded transaction, you need to determine whether the downloaded transaction is a legitimate charge to your account, and report any errors to the financial institution. You can add any valid transactions (such as bank fees) to your records, as follows: