Adding credit card transactions to Sage 100 Contractor

When imported transactions are displayed in the 4-7-7 Import Credit Card Transactions grid, you can choose which transactions to add to your company data.

Important! If multiple card holders share an account number, you should not add imported payments to the credit card company. Say, you pay off the credit card using the 4-7-6 Pay Credit Cards window. The payment is now included in your company records. If you include the payment again when you import credit card transactions, you will create a duplicate payment record. You should, instead, remove the payment transaction from the import grid (using the [Remove] button) so that you will not import the payment again, or at least do not select Include for the payment.

To add imported credit card transactions to Sage 100 Contractor:

  1. For each transaction you want to add:

    1. Identify the credit card subaccount that incurred the expense or cost.

    2. Double-click in the Include column, or select the row and then click [Include].

      To remove the checkmark from the Include column, double-click again in the column, or select the row, and then click [Exclude].

    3. Add distribution details for the transaction, as follows:

      1. Enter the account or the account and subaccount to charge in the grid.

      2. If you need to keep detailed information about the transaction (for example, the vendor, job cost allocations, use tax, whether it is PO- or subcontract-related) or if you need to save the transaction to multiple ledger accounts, click [Add Detailed Receipt for Row#], and then enter and save transaction information as you would for any credit card receipt.

        If the account you entered is a direct expense account, you can enter the Job, Phase, Work Order Number, Job Cost Code, and Job Cost Type.

        If the account you entered is an equipment expense account, you can enter the Equipment, Equipment Cost Code, and Equipment Cost Type.

    4. When you finish selecting transactions to include, click [Save].

For each Included transaction, Sage 100 Contractor creates separate general ledger transactions and any required job and equipment cost records.

Important! If you enter credit card receipts or payments manually, these transactions may be duplicated when you import transactions using Bank Feeds.

You can remove duplicates using the Match Credit Card Transactions window in 4-7-5 Reconcile Credit Card Accounts or the 4-7-7 Import Credit Card Transactions window—or you can choose not to include them in the 4-7-7 Import Credit Card Transactions window.

To avoid duplication, either import transactions using Bank Feeds or enter them manually.