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	The special multicurrency asset account used (when necessary) as an intermediate account for currency conversions performed during funds transfers.
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 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 users must fill in the Document Ref. box for new cash transactions and deposits.
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.

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 AR credit memos by the reference number prior to matching them to AP bills. If the check box is cleared (the default value), disbursement bank transactions are matched to AP bills or payments.

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 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 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 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.