Cash Management Preferences

Form ID: (CA101000)

You use this form to specify the settings for the cash management functionality. These settings include the numbering sequences to be used on cash management forms, the cash-in-transit account and corresponding subaccount to be used for funds transfers, and the options for calculating cash account balances and processing cash-related documents.

Form Toolbar

The form toolbar includes only standard buttons. For the list of standard buttons, see Form Toolbar and More Menu.

General Tab

The general settings that affect cash management include the numbering sequences for cash management transactions that are generated, the GL account (and subaccount, if applicable) to be used for cash in transit, and various options for processing cash transactions.

Table 1. Numbering Settings Section
Element Description
Batch Numbering Sequence The numbering sequence to be used for the identifiers of cash management batches.
Transaction Numbering Sequence The numbering sequence to be used for the identifiers of cash adjustments or direct cash transactions.
Transfer Numbering Sequence The numbering sequence to be used for the identifiers of transfers.
Payment Batch Numbering Sequence The numbering sequence to be used for the identifiers of batches of payments.
Bank Statement Numbering Sequence The numbering sequence to be used for the identifiers of bank statements.
Corporate Card Numbering Sequence

The numbering sequence to be used for the identifiers of corporate cards.

This box is available if the Expense Management feature is enabled on the Enable/Disable Features (CS100000) form.
Table 2. Reconciliation Settings Section
Element Description
Unrecognized Receipts Type The entry type (configured for processing unrecognized payments and for payment reclassification) to be used by default on the Reclassify Payments (CA506500) form.

For details on processing unrecognized cash transactions, see Reclassification of Unknown Payments.
Cash-in-Transit Account A special account used (when necessary) as an intermediate account for currency conversions performed during funds transfers. The system uses this account when the transfer date is earlier than the receipt date in the fund transfer.
Cash-in-Transit Subaccount The corresponding subaccount.
Skip Voided Transactions A check box that you select to make the system skip voided transactions during the reconciliation process if both the original and the voided transactions are registered in the same financial period.

For details, see Bank Reconciliation: Optional Reconciliation Operations.
Table 3. Receipts to Add to Available Balances SectionThe check boxes in this section control how the system uses receipts when calculating the available balances of cash accounts.
Element Description
Unreleased Uncleared A check box that you select to include unreleased and uncleared receipts in calculation.
Unreleased Cleared A check box that you select to include unreleased and cleared receipts in calculation.
Released Uncleared A check box that you select to include released and uncleared receipts in calculation.
Table 4. Disbursements to Deduct From Available Balances SectionThe settings in this section control how the system uses disbursements when it calculates the available balances of the cash accounts.
Element Description
Unreleased Uncleared A check box that you select to include unreleased and uncleared disbursements in calculation.
Unreleased Cleared A check box that you select to include unreleased and cleared disbursements in calculation.
Released Uncleared A check box that you select to include released and uncleared disbursements in calculation.
Table 5. Posting and Release Settings Section
Element Description
Automatically Post to GL on Release A check box that indicates (if selected) that cash transactions are automatically posted to the general ledger when they are released. This check box is selected by default.
Release AP Documents from CA Module A check box that indicates (if selected) that AP documents can be released from cash management forms. If this check box is not selected, AP documents can be released only from accounts payable forms.
Release AR Documents from CA Module A check box that indicates (if selected) that AR documents can be released from cash management forms. If this check box is not selected, AR documents can be released only from accounts receivable forms.
Table 6. Data Entry Settings Section
Element Description
Hold Transactions on Entry A check box that indicates (if selected) that newly entered transactions will by default get the On Hold status on entry.
Validate Control Totals on Entry A check box that (if selected) adds the Control Total box to the Summary area of the Cash Transactions (CA304000) form, so a user can enter the transaction amount manually. This amount will be validated when users enter transactions.
Validate Tax Totals on Entry A check box that (if selected) adds the Tax Amount box to the Summary area of the Cash Transactions (CA304000) form, so a user can enter the tax amount manually in the transaction.
Require Document Ref. Nbr. on Entry A check box that indicates (if selected) that a user must fill in the Document Ref. box with the noted number while creating a record on the following forms:
  • Cash Transactions (CA304000): The external number of a cash transaction (for example, the number of a printed invoice)
  • Bank Deposits (CA305000): The external transaction number of a bank deposit
  • Funds Transfers (CA301000): The transaction number of a funds transfer

If this check box is cleared, the Document Ref. box is optional.
Default Date Range The range (starting with the current business date) to be used by default on cash management reports: Day, Week, Month, or Financial Period.

Approvals Tab

This section is available only if the Approval Workflow feature is enabled on the Enable/Disable Features (CS100000) form.

In the table, you specify the approval map or maps to be used to assign cash documents to employees for approval.

Table 7. Table Columns

You use this table to select the approval map or maps to be used in the approval process.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column Description
Active A check box that indicates (if selected) that cash transactions should be approved before they can be released. The system will use the map specified in the Approval Map column for processing the approval.
Approval Map The approval map that has been configured for cash transactions on the Assignment and Approval Maps (EP205500) form.
Pending Approval Notification

The notification template that will be used for email notifications. You can create new templates or edit existing ones by using the Email Templates (SM204003) form.

Attention:
Only original approvers assigned through an approval map can receive notifications about pending approvals. If an approver has an assigned delegate and approvals are reassigned to this delegate, the delegate will not receive pending approval notifications. For more information about delegates, see Approval Configuration: Delegation of Approvals.

Bank Statements Tab

The system uses the settings on this tab as the default settings on the Process Bank Transactions (CA306000) form for finding relevant cash transactions for manual matching or automatic matching.

Table 8. Disbursement Matching SectionThe system uses these settings as the default settings for the manual matching of transactions.
Element Description
Days Before Bank Transaction Date

For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (disbursement) and the selected transaction on the bank statement.

The maximum possible value that you can specify in this box is 365.
Days After Bank Transaction Date

For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a disbursement.

The maximum possible value that you can specify in this box is 365.
Allow Matching to Credit Memo A check box that indicates (if selected) that the system will automatically match disbursement bank transactions to Accounts Receivable credit memos by the reference number prior to matching them to Accounts Payable bills. If the check box is cleared (the default value), disbursement bank transactions are matched to Accounts Payable bills.
Table 9. Receipt Matching SectionHere you specify the default settings for manual matching of transactions.
Element Description
Days Before Bank Transaction Date

For the system to categorize a cash transaction as matching, the maximum number of days between the date of a cash transaction (receipt) and the selected transaction on the bank statement.

The maximum possible value that you can specify in this box is 365.
Days After Bank Transaction Date

For the system to categorize a cash transaction as matching, the maximum number of days between the date of the selected transaction on the bank statement and the date of a receipt.

The maximum possible value that you can specify in this box is 365.
Table 10. Invoice Matching SectionThis section is used to filter selected invoices as possible matches for bank transactions. Here you specify the default settings for manual matching of AR invoices and AP bills.
Element Description
Match by Cash Account A check box that (if selected) indicates that the system will match bank transactions to invoices with the same cash account or an empty cash account. The check box is cleared by default.
Match by Discount and Due Date A check box that (if selected) indicates that the system will match bank transactions to AR invoices by the discount and due date. The check box is cleared by default.
Days Before Discount Date

The number of days before the discount date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.

The maximum possible value that you can specify in this box is 365.
Days Before Due Date

The number of days before the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.

The maximum possible value that you can specify in this box is 365.
Days After Due Date

The number of days after the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected.

The maximum possible value that you can specify in this box is 365.
Table 11. Other Matching Settings SectionThis section is used to specify other settings for matching bank transactions to documents.
Element Description
Allow Matching to Unreleased Batch Payments

A check box that indicates (if selected) that unreleased batch payments are available for matching to bank transactions on the Process Bank Transactions (CA306000) form. When a user initiates the processing of the matched transactions (by clicking Process on the form toolbar of that form), the system releases matched batches.

For details, see Batch Payment Matching.
Skip Reconciled Transactions in Matching A check box that indicates (if selected) that when bank transactions are imported on the Process Bank Transactions (CA306000) form, the system skips the checks and deposits that have been reconciled and that belong to closed reconciliation statements.
Table 12. Auto-Match Thresholds SectionThis section specifies the settings that the system uses to find the best match during the auto-matching process.
Element Description
Absolute Relevance Threshold The absolute relevance threshold the system will use when finding the best match. The default (recommended) value is 75.
Relative Relevance Threshold The relative relevance threshold the system will use when finding the best match. The default (recommended) value is 20.
Table 13. Import Settings Section
Element Description
Ignore Currency Check on Bank Statement Import A check box that indicates (if selected) that the system ignores the currency check when you import bank statements. Select the check box if you want to import statements that use a currency ID or code that does not match the currency ID associated with the cash account for which you are performing the import.
Allow Empty FITID A check box that indicates (if selected) that the system ignores any empty FITID value—the value that is uploaded to the Ext. Tran. ID column on the Import Bank Transactions (CA306500) form—when you import the bank statement file.
Import Bank Statements to Single Cash Account A check box that indicates (if selected) that importing a bank statement from a file should be performed to only a specific cash account. The user can import the data only after selecting the cash account on the Import Bank Transactions (CA306500) form.
Statement Import Service The service to be used for importing bank statements if the Import Bank Statements to Single Cash Account check box is cleared. The available options are:
  • PX.Objects.CA.OFXStatementReader. This service supports importing bank statements in the following formats: OFX (Open Financial Exchange), QBO (QuickBooks Online), and QFX (Quicken File eXchange).
  • MYOB.AdvancedLive.Core.OFXStatementReader. This service supports importing bank statements in the OFX (Open Financial Exchange) format, addressing any irregularities in the formats provided by various AU/NZ banks.

Relevance Calculation Tab

The system uses the settings on this tab as the default settings in relevance calculation for automatic matching of payments, expense receipts, and invoices.

Table 14. Payment and Expense Receipt Relevance Section
Element Description
Ref. Nbr. Weight The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction.
Consider Empty Ref. Nbr. as Matching A check box that (if selected) indicates that a bank transaction with an empty reference number is automatically matched to a cash transaction with an empty reference number. If this check box is cleared (the default value), the transactions with empty reference numbers are not considered as matching.
Doc. Date Weight The relative weight of the evaluated difference between the dates of the bank transaction and the cash transaction.
Doc. Payee Weight The relative weight of the evaluated difference between the names of the customer (or vendor) on the bank transaction and the cash transaction.
Amount Weight The relative weight of the evaluated difference between the amounts of the bank transaction and the expense receipt.
Amount Difference Threshold (%) The evaluated difference between the amount of the bank transaction and the amount of the expense receipt in the claim currency.
Payment Clearing Average Delay The average number of days for a payment to be cleared with the bank.
Estimated Deviation (Days) The number of days before and after the average delay date during which 50% of payments are generally cleared.
Table 15. Invoice Relevance SectionThe settings in this section are used to calculate the matching relevance for invoices.
Element Description
Invoice Nbr. Weight The relative weight of the evaluated difference between the invoice number of the bank transaction and the invoice number in the system. The default value is 87.50.
Doc. Date Weight The relative weight of the evaluated difference between the dates of the bank transaction and the invoice. The system compares the transaction date to the due date and discount date of the invoice.
Doc. Payee Weight The relative weight of the evaluated difference between the names of the customer on the bank transaction and on the invoice. The default value is 12.50.
Average Payment Delay The average number of days after the due date or discount date.
Estimated Deviation (Days) The number of days before and after the average delay date during which 50% of invoices are paid. The default value is 2.