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.

Note: 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 standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Create Deposit Creates a bank deposit on the Bank Deposits (CA305000) form that includes 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 processing of the batch should be repeated.
  • Processing: Transactions are being imported from the processing center or matched to transactions in MYOB Advanced.
  • 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 Advanced or have been hidden.
  • Deposited: A bank deposit based on the settlement batch has been released, 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 status 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.
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.
Void Count The total number of voided transactions for all card types.
Decline Count The total number of declined transactions for all card types.
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.

All Transactions Tab

This tab lists all transactions in the selected settlement batch.

Table 1. Table Toolbar

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed 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 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.
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 Advanced or has been hidden.
  • Missing: The transaction was recorded in the processing center, but is missing in MYOB Advanced.
  • 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 in MYOB Advanced. This number is a link you can click to open the document in a pop-up window on the form on which the document was created.
Doc. Status The status of the document in MYOB Advanced.
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 standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed 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 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 form so you can create a new document.
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, which can be one of the following: Settled Successfully, Refund Settled Successfully, Settlement Error, Pending Settlement, Expired, Unknown, or Voided.
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 includes only standard buttons. For the list of standard buttons, see Table Toolbar.

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 assigned by the processing center, which can be one of the following: Settled Successfully, Refund Settled Successfully, Settlement Error, Pending Settlement, Expired, Unknown, or Voided.
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 Advanced (AR payment or cash sale). You can click this link to open the document in a pop-up window on the appropriate form depending on the document type.
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 includes only standard buttons. For the list of standard buttons, see Table Toolbar.

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.