Post Credit Card and ACH Settlement Amounts

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

Credit card and ACH payment transactions from your customers are not automatically updated to the Bank Reconciliation module. To manually post credit card and ACH payment transactions in Bank Reconciliation, either enter the day-end settlement amount in Transaction Journal Entry, or enter the day-end settlement amount in Cash Receipts Entry.

Note If you do not have the Bank Reconciliation module installed, post the day-end settlement amount in the General Ledger module by entering the settlement amount in Transaction Journal Entry or General Journal Entry.

Use one of the following methods to manually post credit card transactions in Bank Reconciliation:

 

To enter the day-end settlement amount in Transaction Journal Entry

  1. Using the Accounts Receivable Credit Card and ACH Settlement Report, determine the day-end settlement amount.

  2. Select General Ledger Main menu > Transaction Journal Entry.

  3. In the Source Journal field, enter a source journal that will be tied to Bank Reconciliation (if you have not done so, you can create a new one on the fly). For more information, see Transaction Journal Entry - Fields.

  4. In the Entry Number field, enter a number to identify the journal entry.

  5. Click Format.

  6. In the Transaction Journal Format window:

  1. In the Offset Account No. field, select your cash account. For more information, see Transaction Journal Format - Fields.

  2. In the Offset field, select Credit.

  3. In the Transaction Type field, select Deposit.

  4. In the Bank Code field, select the appropriate bank code and click OK.

  1. On the Transaction Journal Entry Header tab, enter the posting date and journal comment.

  2. In the Bank Code field, select the appropriate bank code.

  3. On the Lines tab, enter information in the Doc Refer, Date, and Comment fields.

  4. In the Account No. field, select the asset account that was entered in the Asset Account field in Payment Type Maintenance.

Note If the Asset Account field was left blank in Payment Type Maintenance, the Customer Deposit account entered in Sales Order Options displays in the Account No. field.

  1. In the Amount field, enter the day-end settlement amount and click Accept.

When the Transaction Journal update is performed, the asset account is credited with the deposit amount and the money moves from the asset account to the associated cash account.

 

To enter the day-end settlement amount in Cash Receipts Entry

  1. Using the Accounts Receivable Credit Card and ACH Settlement Report, determine the day-end settlement amount.

  2. Select Accounts Receivable Main menu > Cash Receipts Entry.

  3. In the Cash Receipts Deposit window:

  1. Enter the deposit number, bank code, and deposit date. For more information, see Cash Receipts Deposit - Fields.

  2. In the Cash Deposit Amount field, enter the day-end settlement amount and click OK.

  1. In Cash Receipts Entry, enter the customer number. For more information, see Cash Receipts Entry - Fields.

  2. In the Deposit Type field, select Cash.

  3. In the Check No. field, type DEPOSIT.

  4. On the Header tab, in the Amount Received field, enter the day-end settlement amount.

  5. On the Lines tab, in the G/L Account field, select the asset account that was entered in the Asset Account field in Payment Type Maintenance.

Note If the Asset Account field was left blank in the Payment Type Maintenance, the Customer Deposit account entered in Sales Order Options displays in the Asset Account field.

  1. In the Amt Posted field, enter the day-end settlement amount and click Accept.

When the Cash Receipts Journal update is performed, the asset account is credited with the deposit amount and the money moves from the asset account to the associated cash account.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks