Reconciling Customer Credit Card Payments

Use the Credit Card Payment Reconciliation Queue to tie the credit card payments made by customers to actual bank deposits. You can reconcile the bank’s file to the credit card payments made and review when deposits have occurred by checking and changing the status and creating miscellaneous cash receipts to account for the payments.

Note: To display  the Credit Card Payment Reconciliation Queue information for at all times, add a widget to your Solar Eclipse main window. For more information, see Widgets and Menu Shortcuts Overview.

To reconcile credits card payments:

  1. From the A/R menu, select Credit Card Payment Reconciliation Queue to display the window.

  2. Set the parameters for the queue to display the transactions you want to review and reconcile:

Field

Description

Branch/Tr/All

Select the branch, branches, or territories for which to populate the queue.

Deposit Status

Select how you want to filter the queue by credit card process status:

  • Processed - Indicates the payment has been received but not yet deposited into an account.

  • Deposited - Indicates the payment has been received and deposited into the appropriate account.

Credit Card Type

Select which credit card you want to reconcile. You can select more than one.

Starting Date

Select the date range for the payments you want to review.

Ending Date

  1. Click Update to populate the queue.

  1. Use the Approve check box in one of the following ways to process transactions, as needed:

To...

Do this:

to reprocess selected transactions

One of the following:

  • Select the Approve check box for the transaction that you want to reprocess.

  • Select Approve > Approve Item to process a single transaction

  • Select Approve > Approve All Selected Items to process all the transactions with the Approve check box selected.

approve all declined transactions

From the Approve menu, select Approve All Declined to reprocess all transactions with a status of Declined.

Use this option if you have researched the declines and updated the credit card information as necessary for all the cards in the queue..

  1. Use the Deposit Status column for each transaction to indicate the process status for the payment: Processed, Deposit In Progress, and Deposited.

  2. Create cash receipts, if needed.

  3. Save your changes and exit the queue.

Creating Miscellaneous Cash Receipts for Credit Card Payments

After taking credit card payments, you can tie the credit card payments to your actual bank deposits and reconcile your bank file to the credit card payments received. In this way, you can track when the payments have been deposited.

After receiving your bank statement confirming deposits, you create cash receipts to reconcile the payments that you have received. Use the Credit Card Reconciliation Queue Defaults control maintenance record to define at the branch level the parameters for cash receipts are created for credit card payments through the Credit Card Payment Reconciliation Queue.

To create cash receipts for credit card payments:

  1. Display the Credit Card Reconciliation Queue and set the parameters for which you want to view credit card payments.

  2. Use the Select check box to choose the orders for which you have received payment.

  3. From the File menu, select one of the following:

  4. Create Cash Receipt - Creates a receipt for the line you are on.

  5. Create Cash Receipt for Selected Items - Creates a single cash receipt for all the items you have more selected.

The system uses the first branch if finds with set system defaults for the comment, deposit branch, and the bank on the Miscellaneous Cash Receipts window.

Note: If you select Create Cash Receipt without any lines selected, the system...

  1. Post the miscellaneous cash receipt for the items selected.

  2. Create more cash receipts for credit card payments or exit the window.

See Also:

Reviewing and Processing Failed and Declined Credit Card Charges

Running the Credit Card Summary Report