Visma Net
Cash management preferences (CA101000)
This topic gives you information about the elements that you find in this window in Visma Net, such as fields, field values, buttons, and check boxes.
You use this window to specify the settings for the Cash management workspace.
Element | Description |
---|---|
Batch number series | The number series to be used for the IDs of batches originating in the Cash management workspace. |
Transactions number series |
The number series to be used for the IDs of cash adjustments or direct cash transactions. |
Transfer number series | The number series to be used for the IDs of transfers. |
Payment batch number series | The number series to be used for the IDs of batches of payments. |
Bank statement number series | The number series to be used for the IDs of bank statements. |
Payments import number series | The number series used during import of payment transactions. |
Element | Description |
---|---|
Unrecognised receipts type |
The entry type (configured for processing unrecognised payments and for payment reclassification) to be used by default in the Reclassify payments (CA506500) window. For more information on processing unrecognised cash transactions, see About the reclassification of unknown payments |
Cash-in-transit account | The special multi-currency asset account used (when necessary) as an intermediate account for currency conversions performed during funds transfers. |
Cash -in-transit subaccount | The corresponding subaccount. |
Reopen bank transactions when voiding payment |
The options are implemented for the Customer payments (AR302000) , Supplier payments (AP302000), and Transactions (CA304000) windows. In the drop-down field you can select between the following options:
When a new row is created, the new line will get a prefix Re-opened or Unmatched + Ref. no + Original description, depending on the setting. Now, you can match this to another customer, supplier, or cash transaction. Note! We recommend you to use the Copy original or create new bank transaction option, else you will lose the connection to the voided payment in the Import bank transactions (CA306500) and Import incoming payments (AR305500) windows. If a payment is created by the Direct debit function, it will not create any new, or unmatch existing bank transaction at all. |
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 more information, see: About the reconciliation process |
Skip reconciled transactions |
A check box that you select to make the system skip reconciled transactions during the reconciliation process if both the original and the reconciled transactions are registered in the same financial period. |
The options 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 calculations. |
Unreleased cleared | A check box that you select to include unreleased and cleared receipts in calculations. |
Released - uncleared | A check box that you select to include released and uncleared receipts in calculations. |
The options 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 calculations. |
Unreleased cleared | A check box that you select to include unreleased and cleared disbursements in calculations. |
Released - uncleared | A check box that you select to include released and uncleared disbursements in calculations. |
Element | Description |
---|---|
Default payment method for process payments |
By default, this field is empty. The Payment method field is empty in windows in the Cash management, Supplier ledger, and Customer ledger, and you must manually select which cash account you want to view or use. If you select a payment method in this field, this will be the default payment method for payments and bank transactions. |
Default cash account |
By default, this field is empty. If you do not select a default cash account, the Cash account field in other windows will be empty. If you select a cash account in this field, this will be the default cash account for the incoming payments and bank transactions. The Cash account field is used in the following windows: |
Override payment method for bank processing | By using this option, you override the payment method when creating payments in the Process bank transactions (CA306000) window. |
Element | Description |
---|---|
Do not automatically release supplier payments | If you select this check box, you indicate that payments from suppliers should not be automatically released. |
Automatically post to general ledger on release | If you select this check box, you indicate that cash transactions are automatically posted to the general ledger on release. |
Element | Description |
---|---|
Release supplier ledger documents from cash management | If you select this check box, you indicate that supplier documents can be
released from the Cash management workspace.
If this option is not selected, supplier documents can be released only from the Supplier ledger workspace. |
Release customer ledger documents from cash management | If you select this check box, you indicate that customer documents can be
released from the Cash management workspace.
If this option is not selected, customer documents can be released only from the Customer ledger workspace. |
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 field to the top part of the Transactions (CA304000) window, so you can enter the transaction amount manually. This amount will be validated when you enter transactions. |
Validate VAT totals on entry | A check box that (if selected) adds the VAT amount field to the top part of the Transactions (CA304000) window, so you can enter the VAT amount manually in the transaction. |
Require document ref. no on entry | A check box that indicates (if selected) that you must fill in the Document ref. field 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. |
This section is available only if the Approval workflow functionality is enabled in the Enable/disable functionalities (CS100000) window.
Element | Description |
---|---|
Require approval | A check box that indicates (if selected) that cash transactions should be approved before they can be released. |
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 Notification templates (SM204003) window. |
The system uses the settings on this tab as the default settings in the Process bank transactions (CA306000) window for finding relevant cash transactions for manual matching or auto-matching. Some settings apply to the Process incoming payments (AR305000) window as well.
The 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 categorise 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. |
Days after bank transaction date |
For the system to categorise 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. |
Allow matching to credit note | A check box that (if selected) indicates that the system will automatically match receipt bank transactions to credit notes by the reference number prior to matching them to purchase invoices. If the check box is cleared (the default value), receipt bank transactions are always matched to purchase invoices. |
Here you specify the default settings for manual matching of transactions.
Element | Description |
---|---|
Days before bank transaction date | For the system to categorise 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. |
Days after bank transaction date |
For the system to categorise 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 system uses these settings as the default settings in relevance calculation for auto-matching of transactions and for validation of manual matching.
Element | Description |
---|---|
Ref. no. weight | The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction. |
Consider empty ref. no. as matching | A check box that (if selected) specifies 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 supplier) on the bank transaction and the cash transaction. |
The system uses these settings as the default settings in relevance calculation for auto-matching of transactions and for validating manual matching.
Element | Description |
---|---|
Average delay payment clearing | 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. |
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 perform import. |
Allow empty FITID | A check box that indicates (if selected) that the system ignores the empty FITID value (the value, which is uploaded to the Ext. trans. ID column in the Import bank transactions (CA306500) window when you import the bank statement file. |
Import bank statement 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. You can import the data only after you have selected the cash account in the Import bank transactions (CA306500) window. |
Allow matching to unreleased batch payments |
A check box that indicates (if selected) that unreleased batch payments are available for matching to bank transactions in the Process bank transactions (CA306000) window. When you initiate processing of the matched transactions (by clicking Process on the mentioned above window), the system releases matched batches. For more information, see:About batch payment matching |
Automatic split of batch payment from customers into payments per customer |
A check box that (if selected) handles the splitting of a batch payment from several customers into payments per customer. When selected, the system will create the payment with all multiple invoices applied before processing the payment (clicking the Process button). When clicking the Process button, the application will be done. If the check box is not selected, invoices must be applied manually and splitting of payment, creation of payment and application of invoices will only take place when clicking the Process button.
|
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 option is PX.Objects.CA.OFXStatementReader. The service supports importing bank statements in the following formats: OFX (Open Financial Exchange), QBO (QuickBooks Online), and QFX (Quicken File eXchange). |
Element | Description |
---|---|
Match against bank accounts after invoice matching | If you select this check box, you enable customer/supplier recognition for bank transaction by the bank account number. For example, when you click the Match automatically button in the Process bank transactions (CA306000) window. |
Match only documents with the same bank account number | If you select this check box, you enable customer and supplier recognition for bank transaction by the same bank account number. For example, when you the Match automatically button in the Process bank transactions (CA306000) window. |
Update bank account on customer/supplier from Process bank transactions |
When this check box is selected and the payment line contains a bank account from the bank and you select a customer/supplier, a lookup against the default IBAN/BBAN will be done in the Process bank transactions (CA306000) window.
If the customer's/supplier's bank account is empty or different, the button Update bank account will appear in the Process bank transactions (CA306000) window. Clicking the button will update the customer/supplier with the account from the bank. |
Do not create supplier prepayments | When you select this check box, auto-matching will not create supplier prepayments automatically. The purpose is to avoid processing a bank transaction that is not fully applied since that would lead to an inbalance between bank and account payable. You will get the warning Remaining balance available on the supplier transactions, and the Ready to process check box will not be checked in the Process bank transactions (CA306000) window. |
Do not create payment when bank payment amount is not fully applied |
When you select this check box, no payment will be automatically created if bank payment amount is higher than invoice amount. The purpose is to avoid processing a bank transaction that is not fully applied since that would lead to an inbalance between bank and account receivable/general ledger.
You will get the warning Remaining balance available if bank payment is higher than invoice amount or invoice is closed. In the Process bank transactions (CA306000) and Process incoming payments (AR305000) windows, the Ready to process check box will not be checked before manual action is taken. |
Auto load documents |
Select how or if documents will be automatically loaded in the Process bank transactions (CA306000)
window for matching:
|
Element | Description |
---|---|
Suppliers | Select the window that will be opened for supplier document details. |
Customers | Select the window that will be opened for customer document details. |
Cash management | Select the window that will be opened for cash account details. |
The system uses the settings on this tab as the default settings in the Process incoming payments (AR305000) window for finding relevant cash transactions for manual matching or auto-matching.
The 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 categorise 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. |
Days after bank transaction date |
For the system to categorise 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. |
Allow matching to credit note | A check box that (if selected) indicates that the system will automatically match receipt bank transactions to credit notes by the reference number prior to matching them to purchase invoices. If the check box is cleared (the default value), the receipt bank transactions are always matched to the purchase invoices. |
Here you specify the default settings for manual matching of transactions.
Element | Description |
---|---|
Days before bank transaction date | For the system to categorise 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. |
Days after bank transaction date |
For the system to categorise 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 system uses these settings as the default settings in relevance calculation for auto-matching of transactions and for validation of manual matching.
Element | Description |
---|---|
Ref. no. weight | The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash transaction. |
Consider empty ref. no. as matching |
A check box that (if selected) specifies 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 supplier) on the bank transaction and the cash transaction. |
The system uses these settings as the default settings in relevance calculation for auto-matching of transactions and for validating manual matching.
Element | Description |
---|---|
Average delay payment clearing | 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. |
Element | Description |
---|---|
Automatic split of batch payment from customers into payments per customer |
A check box that (if selected) handles the splitting of a batch payment from several customers into payments per customer. When selected, the system will create the payment with all multiple invoices applied before processing the payment (clicking the Process button). When clicking the Process button, the application will be done. If the check box is not selected, invoices must be applied manually and splitting of payment, creation of payment and application of invoices will only take place when clicking the Process button.
|
Split incoming payment files from AutoPay (inbox) into smaller files for faster processing |
A check box that (if selected) splits the payment XML file from AutoPay into a set of smaller files for faster handling of automatic scheduling. When selected, the system will split, import and display the XML file into separate files in the window AutoPay inbox (CA50400S). The File ID will be the same for each split file and each file will have a Split no displayed in a separate column numbered sequentially. Example: A payment file with File ID 4021 and with 6000 payments will be split into 3 files with 2000 payments each. The files will have the same File ID and the Split no will show 1 to 3. |
Related concepts
About the reclassification of unknown payments
About cash transaction processing
About cash transaction monitoring
About cash account configuration
Related tasks
Enable customer and supplier recognition for bank transactions
Set up transaction matching settings
Set default cash account for payments and transactions
Disable the automatic creation of supplier prepayments during auto-matching
Disable the automatic creation of customer payments when bank payment amount is not fully applied