Settlement Batches

Form ID: (CA307000)

On this form, you can review a settlement batch and perform operations on transactions within the batch: hide, record, or match them. You can also create a bank deposit that includes the transactions in the batch. For details on creating bank deposits, see Preparation of Deposits.

Attention: This form appears in the system if the Integrated Card Processing feature has been enabled on the Enable/Disable Features (CS100000) form.

You open this form by clicking a link in the Reference Number column on the All Records or Unprocessed Batches tab on the Import Settlement Batches (CA507000) form.

Users with the Administrator, CA Admin, and CA Clerk roles have the Delete access rights to this form; users with the CA Viewer role have the View Only access rights to this form.

Form Toolbar

The form toolbar includes the buttons described below.


Button	Description
Create Deposit	Creates a bank deposit on the Bank Deposits (CA305000) form that consists of the transactions in the selected settlement batch.

Summary Area

This area displays the settings of the settlement batch whose identifier is selected in the Reference Number box. All the other settings in this area are read-only and calculated by the system or copied from the Import Settlement Batches (CA507000) form for the selected settlement batch.


Element	Description
Reference Number	The reference number of the settlement batch.
Status	The processing status of the settlement batch. The status can be one of the following: Pending Import: A batch has been created, and the import of transactions has not yet started or has ended without all the transactions being imported. Pending Processing: The processing of transactions has resulted in an error, and the batch should be processed again. Processing: Transactions are being imported from the processing center or matched to transactions in MYOB Acumatica. Pending Review: Automatic processing has finished, but some transactions are missing. Processed: All transactions in the settlement batch have been matched to transactions in MYOB Acumatica or hidden. Deposited: A bank deposit based on the settlement batch has been created, or there are no payments to deposit. Error: An error has occurred during import.
Proc. Center ID	The ID of the processing center of the settlement batch.
Ext. Batch ID	The batch ID assigned by the processing center.
Settlement Time	The date and time when the batch was settled.
Settlement State	The state of the batch assigned by the processing center. The state can be one of the following: Settled Successfully: The batch has been approved and successfully settled. Settlement Error: An error occurred when trying to settle the batch. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cut-off time. Unknown: The batch settlement status could not be defined by the processing center. Rejected: The EFT transaction in the batch has been rejected by the processing center. Voided: The EFT transaction in the batch has been voided in the processing center.
Bank Deposit	The reference number of the bank deposit that the system created automatically on the Bank Deposits (CA305000) form, which is also a link you can click to view the bank deposit.
Settled Amount	The sum of the settled amounts for all card types.
Settled Count	The number of settled transactions for all card types.
Refund Amount	The sum of the refunded amounts for all card types.
Refund Count	The total number of refunded transactions for all card types.
Rejected Amount	The amount rejected by the processing center. This box appears on the form if an EFT batch is selected.
Rejected Count	The total number of rejected transactions. This box appears on the form if an EFT batch is selected.
Void Count	The total number of voided transactions for all card types.
Decline Count	The total number of declined transactions for all card types.
Net Amount	The net amount of the transactions in the batch—which matches the payout amount in Stripe. This value reflects the actual transfer amount to and from the customer's bank account.
Fee	The fee withdrawn from the payout.
Transaction Count	The total number of transactions in the batch.
Imported Count	The number of transactions that have been imported.
Processed Count	The number of transactions that have the Processed status.
Missing Count	The number of transactions that have the Missing status.
Hidden Count	The number of transactions that have the Hidden status.
Excluded from Deposit Count	The number of transactions that will not be included in the bank deposit.
Adjustment Count	The number of adjustments in the batch. These adjustments are shown on the Adjustments tab.

All Transactions Tab

This tab lists all transactions in the selected settlement batch.

Table 1. Table Toolbar
The table toolbar includes the buttons described below.
Button	Description
Unhide	Changes the status transaction or transactions you have selected (by selecting the Included check boxes in the table) to Pending Review if the status of the settlement batch is Processed, and to Missing if the settlement batch has any other status. If the settlement batch has any status other than Deposited, this button is available if the selected transaction has the Hidden status.

Table 2. Table Columns
Column	Description
Included	An unlabeled check box that you select to include the transaction in processing if you create a deposit.
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction assigned by the processing center. The status can be one of the following: Settled Successfully: The batch has been approved and settled without problems. For a credit card or EFT transaction, the card payment or EFT debit transaction has been settled successfully. Refund Settled Successfully: For a credit card or EFT transactions, the card or EFT refund has been settled successfully. Settlement Error: An error occurred when the system tried to settle the batch. General Error: For a credit card transaction, an error occurred during batch settlement. Expired: For a credit card transaction, the batch transaction has expired. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cutoff time. Unknown: The processing center couldn’t determine the batch settlement status. Declined: For a credit card transaction, the batch transaction has been declined. Voided: For a credit card or EFT transaction, the transaction has been voided. Rejected: For an EFT transaction, the EFT debit transaction has been rejected. Refund Voided: For an EFT transaction, the EFT refund has been voided. Refund Rejected: For an EFT transaction, the EFT refund has been rejected.
Processing Status	The processing status of the transaction. The status can be one of the following: Pending Processing: The processing of the transaction has resulted in an error, and the processing should be repeated. Processed: The transaction has been matched to a transaction in MYOB Acumatica or has been hidden. Missing: The transaction was recorded in the processing center, but is missing in MYOB Acumatica. Hidden: The transaction was imported from the processing center, but should be excluded from processing.
Amount	The transaction amount.
Doc. Type	The document type of the transaction.
Reference Nbr.	The reference number of the document (AR payment or cash sale) in MYOB Acumatica. You can click this link to open the document in a pop-up window on the Payments and Applications (AR302000) or Cash Sales (AR304000) form.
Doc. Status	The status of the document in MYOB Acumatica.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Submit Time	The date on which the transaction was submitted.
Card Type	The card type of the transaction.
Fixed Fee	The amount of a fixed fee applied to the transaction by the processing center.
Percentage Fee	The amount of a percentage fee applied to the transaction by the processing center.
Total Fee	The total fees applied to the transaction.
Fee Type	The fee type specified in the settlement report.

Missing Transactions Tab

This tab lists the transactions that have the Missing status.

Table 3. Table Toolbar
The table toolbar includes the buttons described below.
Button	Description
Record	Creates in the system the transaction or transactions for which you have selected the Included check box in the table. If the settlement status of the transaction is Settled Successfully or Refund Settled Successfully, the system opens the Payments and Applications (AR302000) form in a pop-up window with some of the boxes populated with the corresponding values from the batch transaction. If the settlement status of the transaction is Voided, the system does the following: For an external transaction linked to an AR payment, voids the linked payment and opens the Voided Payment document on the Payments and Applications (AR302000) form. For an external transaction linked to a cash sale, reverses the cash sale and opens the Cash Return document on the Cash Sales (AR304000) form. If an external transaction is not found, opens the Payments and Applications (AR302000) form so you can create a new document. If the transaction’s settlement status is Voided or Rejected, the system creates a voided payment and opens it on the Payments and Applications (AR302000) form, where you can process it further. For details, see Reconciliation of EFT Payments.
Hide	Excludes from processing the transaction or transactions for which you have selected the Included check box in the table and changes the processing status of the transaction or transactions to Hidden.
Match	Restarts the matching process for all transactions listed on this tab, which have the Missing status.

Table 4. Table Columns
Column	Description
Included	An unlabeled check box that you select to include the transaction in processing.
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction assigned by the processing center. The status can be one of the following: Settled Successfully: The batch has been approved and settled without problems. For a credit card or EFT transaction, the card payment or EFT debit transaction has been settled successfully. Refund Settled Successfully: For a credit card or EFT transactions, the card or EFT refund has been settled successfully. Settlement Error: An error occurred when the system tried to settle the batch. General Error: For a credit card transaction, an error occurred during batch settlement. Expired: For a credit card transaction, the batch transaction has expired. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cutoff time. Unknown: The processing center couldn’t determine the batch settlement status. Declined: For a credit card transaction, the batch transaction has been declined. Voided: For a credit card or EFT transaction, the transaction has been voided. Rejected: For an EFT transaction, the EFT debit transaction has been rejected. Refund Voided: For an EFT transaction, the EFT refund has been voided. Refund Rejected: For an EFT transaction, the EFT refund has been rejected.
Amount	The transaction amount.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Submit Time	The date on which the transaction was submitted.
Card Type	The card type of the transaction.

Transactions Excluded from Deposit Tab

This tab lists transactions with the Processed status, which will not be included in the bank deposit created for the settlement batch. For a transaction to be listed on this tab (that is, excluded from a deposit), the document linked to the transaction has to meet at least one of the following criteria:

The Batch Deposit check box for the document is cleared on the form on which the document was created.
The Batch Deposit Nbr. on the creation form of the document is filled in, and the value is different than the value in the Bank Deposit box in the Summary area of the current form.
The payment's cash account is not linked to the deposit account of the processing center as a clearing account.

The table toolbar has only standard buttons.

Table 5. Table Columns
Column	Description
Proc. Center Tran. Nbr.	The transaction number assigned by the processing center.
Settlement Status	The status of the transaction that has been assigned by the processing center. The status can be one of the following: Settled Successfully: The batch has been approved and settled without problems. For a credit card or EFT transaction, the card payment or EFT debit transaction has been settled successfully. Refund Settled Successfully: For a credit card or EFT transactions, the card or EFT refund has been settled successfully. Settlement Error: An error occurred when the system tried to settle the batch. General Error: For a credit card transaction, an error occurred during batch settlement. Expired: For a credit card transaction, the batch transaction has expired. Pending Settlement: The batch has been submitted for settlement and will be settled at the transaction cutoff time. Unknown: The processing center couldn’t determine the batch settlement status. Declined: For a credit card transaction, the batch transaction has been declined. Voided: For a credit card or EFT transaction, the transaction has been voided. Rejected: For an EFT transaction, the EFT debit transaction has been rejected. Refund Voided: For an EFT transaction, the EFT refund has been voided. Refund Rejected: For an EFT transaction, the EFT refund has been rejected.
Submit Time	The date on which the transaction was submitted.
Amount	The transaction amount.
Card/Account Nbr.	The masked card number or bank account number used for the transaction.
Invoice Nbr.	The merchant-defined invoice number associated with the transaction.
Doc. Type	The document type of the transaction.
Reference Nbr.	The reference number of the document in MYOB Acumatica (AR payment or cash sale). You can click this link to open the document in a pop-up window on the Payments and Applications (AR302000) or Cash Sales (AR304000) form.
Cash Account	The cash account specified for the linked document.
Bank Deposit	A link to the bank deposit on the Bank Deposits (CA305000) form that includes the linked document.

Card Type Summary Tab

This tab shows the statistics for the settlement batch.

The table toolbar has only standard buttons.

Table 6. Table Columns
Column	Description
Card Type	The card type of the transaction.
Settled Amount	The settled amount for the card type.
Settled Count	The number of settled transactions for the card type.
Refund Amount	The total refunded amount for the card type.
Refund Count	The total number of refunded transactions for the card type.
Void Count	The total number of voided transactions for the card type.
Decline Count	The total number of declined transactions for the card type.
Error Count	The number of errors for the card type.

Adjustments Tab

This tab shows the adjustments included in the settlement batch.

The table toolbar has only standard buttons.

Table 7. Table Columns
Column	Description
Ext. Transaction ID	The unique ID of the balance transaction for the adjustment.
Source ID	The ID filled in for adjustments, such as manual payouts or disputes. For manual payouts, this is the payout ID. For disputes, this is the dispute ID.
Adjustment Time	The time when the adjustment was made.
Amount	The adjustment amount, which is negative if it was withdrawn from the balance and positive if it was added to the balance.
Fee	The fee applied to the adjustment. A positive amount shows that it was withdrawn from the balance, and a negative amount indicates that it was added to the balance.
Fee Type	The fee type for the adjustment.
Description	The description of the adjustment.