| Element | Description |
|---|---|
| Cash account | The cash account for which you want to view available transactions or enter new ones. |
| Currency | The currency that is used for the cash account. |
| Start date | The earliest date for the transactions to be shown in the list. |
| Column | Description |
|---|---|
| Trans. date | The date of the cash transaction. |
| Disb./receipt | The type of the transaction: Disbursement or Receipt. |
| Description | The description provided for the cash transaction. |
| Amount | The amount of the cash transaction. |
| Button | Description |
|---|---|
| Validate manually | When you click this button, in the Status column, the status changes to Manually validated and the |
| View document | In the table, select the incoming payment you want to view. Click the View document button. In the AutoPay inbox details (CA40300S) window that opens, view your incoming payment. |
| Process | In the table, select the check boxes for the incoming payments you will process. Click the Process button. In the Status column, the status changes to Validated and |
| Process all | If you want to process all the lines in one go, click the Process all button without selecting the check boxes. |
| Inquiries |
|
| Schedules | In the drop-down list you have the following options:
This opens the Automation schedules (SM205020) window as a pop-up. Here you can create and add automation schedules. For more information, see: Schedule processing.
|
| Element | Description |
|---|---|
| Message type | In the Message type field, select one of the following options in the drop-down list:
|
| Inbox status | In the Inbox status field, select one of the following options in the drop-down list:
|
| Cash account | In the Cash account field, click |
| Up to date | Select the date until which you want to include documents. |
| Column | Description |
|---|---|
| Message type | The type of the message. |
| Action | The following options are available:
Note
If you have selected the check box Automatic split of batch payment from customers into payments per customer and choose the action Import from AutoPay, the system will not create a customer payment and match the invoices that are paid. These must be matched manually. Use the column Invoice list under Process incoming payments to get information about which invoices that are paid. If you have selected the check box Automatic split of batch payment from customers into payments per customer and choose the actions Import from AutoPay and match or Import from AutoPay and process, the system will create a customer payment and match the invoices that are paid for that customer. |
| Status | The status of the payment:
|
| Account | The payment account of the transactions in the payment message. |
| Cash account | The cash account of the transactions in the payment message. |
| Reference number | The reference number of the payment. |
| File ID | The unique reference number for Account Statement and Incoming Payment, which is displayed and named Ref in AutoPay. |
| Split no | A number indicating part of file. A payment file can be split into several files to ensure faster handling of automatic scheduling. Each file will have the same File ID and a sequential Split no added to it. To initiate this feature, go to window Cash management preferences (CA101000). |
| Number of transactions | The number of transactions included in the payment message. |
| Processed transactions | The number of processed transactions included in the payment message. |
| Bank date | The date when the payment was handled in the bank. |
| Debit amount | The debit amount of the payment. |
| Credit amount | The credit amount of the payment. |
| Process date | The processing date of the payment message. |
| Processed by user | The user who has processed the payment message. |
| Status reason | The reason why the processed message ends up with an error status. Some of the possible status reasons are:
|
| Received status | The received status of the message:
|
| Created date | The date when the payment message was created. |
| Button | Description |
|---|---|
| Back | Navigates you back to the AutoPay inbox (CA50400S) window. |
| Element | Description |
|---|---|
| Batch status | Select one of the following options in the drop-down list:
|
| Payment status | Select one of the following options in the drop-down list:
|
| Cash account | In the Cash account field, click |
| Date | Select the date until which you want to include documents. |
| Bank date | The date when the payment was handled in the bank. |
| Message type | In the Message type field, select one of the following options in the drop-down list:
|
| Column | Description |
|---|---|
| Workspace | The workspace in which the document has been created. |
| Batch ref. no. | The reference number of the payment batch. |
| Batch status | The status of the batch, selected in the top part:
|
| Cash account | The cash account of the transactions in the payment message. |
| Base currency | The base currency of the transactions in the payment message. |
| Payment reference number | The reference number of the payment. |
| Payment status | The status of the payment, selected in the top part:
|
| Paid amount | The amount paid on the document. |
| Charged fee amount | The charged amount of fees on the payment. |
| Paid date | The date when the document amount has been paid. |
| Payee name | The payee to whom the payment was made. |
| Message | The message connected with the payment. |
| Created date | The date when the document was created. |
| Document due date | The due date of the document. |
| Document ref. no. | The reference number of the document. |
| Last modified by | The user who has last modified the payment. |
| Last modified date | The date when the payment was last modified. |
| Button | Description |
|---|---|
| Release | Releases the selected deposit. |
| Void | Navigates to the Journal transactions (GL301000) window, where you can view the details of the batch. |
| Reports | Includes the following menu command, which you can click for quick access to the report: Print deposit slip: Navigates to the Deposit slip (CA656500) report. |
| Element | Description |
|---|---|
| Trans. type | The type of deposit. The available types are Deposit and Void deposit. |
| Ref. no. | The unique identifier assigned to the deposit in accordance with the number series, which is specified in the ( Cash management preferences (CA101000) window. |
| Status | The status of the deposit, which is automatically assigned by the system. The available values are On hold, Balanced, and Released. |
| Hold | A check box that indicates (if selected) that the deposit is on hold, which means it may be edited but cannot be released. You can clear the Hold check box for a balanced deposit only. |
| Deposit date | The date of the deposit. |
| Period | The financial period to which the deposit should be posted. |
| Cash account | The cash account (usually a bank account) to which the deposit will be posted. |
| Currency | The currency of the deposit. |
| Document ref. | The external reference number of the deposit. |
| Cash drop account | The cash account (usually a Cash on hand account) from which you want to also deposit some amount on the bank account. |
| Cash drop amount | The total amount of cash to be deposited through this deposit. |
| Description | A detailed description of the deposit. |
| Deposit total | The line total amount of the deposit. |
| Charge total | The total amount of any charges that apply to the deposit. |
| Total amount | The total amount of the deposit, including the cash amount minus the charge total amount. |
| Control total | The control total of the deposit, which should be equal to the Total amount. |
| Column | Description |
|---|---|
| Doc. module | The workspace of origin, Customer ledger or Supplier ledger, for the payment. |
| Type | The type of the payment included in the deposit. |
| Ref. no. | The reference number of the payment. |
| Customer/supplier | The customer or supplier, by its ID, whose payment is included in the deposit. |
| Account name | The name of the customer or supplier whose payment is included in the deposit. |
| Location | The location of the customer associated with the payment. |
| Account | A clearing cash account associated with the bank account. |
| Currency | The currency of the payment. |
| Deposit amount | The amount of the payment to be deposited. |
| Payment method | The payment method used to record the payment. |
| Status | The status of the payment, which is one of the following options: On hold, Balanced, or Released. |
| Payment ref. | The external reference number of the payment. |
| Payment date | The date of the payment. |
| Charge type | The entry type of the charges that apply to the payment included in the deposit. An entry type is a type of entered cash transaction that your site uses to classify the transactions for appropriate processing. |
| Original amount | The original amount of the payment. |
| Element | Description |
|---|---|
| Clearing account | The clearing cash account where unknown payments were recorded. |
| Payment method | The payment method used for recording unknown payments. |
| Start date | The start date of the time period for which you want to view payments. |
| End date | The end date of the time period for which you want to view payments. |
| The table has the following elements | |
| Doc. workspace | The workspace of origin, Customer ledger or Supplier ledger, for the payment. |
| Type | The type of the payment, which is one of the following options: Payment, Credit note, Prepayment, or Customer refund. |
| Ref. no. | The reference number of the payment as assigned by the system. |
| Customer/supplier | The customer or supplier, by its ID, specified on the payment document. |
| Account name | The name of the customer or supplier specified on the payment document. |
| Location | The location of the customer associated with the payment. |
| Payment ref. | The reference number of the payment as specified by the customer. |
| Payment date | The date of the payment. |
| Currency | The currency of the payment. |
| Payment amount | The amount of the payment. |
| Cash account | The cash account to hold the payment. |
| Description | The description of the cash account. |
| Payment method | The payment method used by the customer for the payment. |
| Charge amount | The amount of the charges. |
| Gross payment amount | The gross amount of the payment. |
| Add and close (buttons) | Adds the selected payments to the deposit and closes the dialog box. |
| Cancel (buttons) | Discards the selections made on the dialog box and closes the dialog box. |
| Column | Description |
|---|---|
| Charge | The entry type of the bank charges that apply to the deposit. The entry types can be configured in the Entry types (CA203000) window. |
| Payment method | The payment method of the deposited payment to which this charge rate should be applied. If the field is empty, the charge rate is applied to deposited payments, regardless of their payment method. |
| Charge rate | The rate of the bank charges. |
| Chargeable amount | The amount to be used as a base for the charges. |
| Charge amount | The amount of the charges. |
| Account | The expense account to which the charges are recorded. |
| Clearing subaccount | The subaccount to be used with the expense account. |
| Element | Description |
|---|---|
| Batch number | The number of the batch generated to implement the cash transaction. By clicking the number, you can navigate to the Journal transactions (GL301000) window, where you can view batch details. |
| Work group | The work group to which the deposit is assigned for processing. Select a work group from the company tree. |
| Owner | The owner of the deposit, which is the employee who controls the processing. Select an owner from the list of employees. |
| Clear date | The date when the deposit has been cleared with the bank reconciliation statement. |
| Cleared | A check box that indicates (if selected) that the deposit was cleared with the bank. |
| Separate charges | A check box that indicates (if selected) that the charges for the deposit will be specified by a separate transaction. If the check box is not selected, charges will be deducted from the deposit amount. |
| Element | Description |
|---|---|
| Rule | A unique identifier for the rule. The alphanumeric string may contain up to 30 characters. |
| Description | A detailed description of the rule. This alphanumeric string may contain up to 256 characters. |
| Active | A check box that indicates (if selected) that the rule is available for use in the Process bank transactions (CA306000) window. |
| Element | Description |
|---|---|
| Debit/Credit | The type of transaction: Disbursement or Receipt. |
| Cash account | The identifier of the cash account, which corresponds to the account in the bank. |
| Currency | The currency of a transaction. The field is disabled and displays the currency of the selected cash account (if any). |
| Trans. code | The code of the transaction. |
| Description | The description of the transaction. The application of this criterion depends on the value of the Use wild cards check box:
The field is filled with a transaction description when you have been navigated here from the Process bank transactions (CA306000) window. If you do not want to use a description as the criterion, make sure the field is cleared. |
| Match case | A check box that indicates (if selected) that the font case of a transaction description should match to the font case in the Description field. |
| Use wild cards | A check box that indicates that you can use wild card characters (* or?) in the Description field. This is selected by default. |
| Use name from bank | A check box that indicates (when selected) that the name from the bank can be used in the Description field. |
| Bank account number | The IBAN/BBAN number to be used on the rule. The IBAN/BBAN will be updated from the bank transaction when creating a rule. The bank transaction rules will be picked in alphabetical order, so when there are several hits, the first matching rule will be used. |
| Amount matching mode | The mode of the transaction amount matching. The following options are available:
|
| Amount | The number used to compare a transaction amount. Note: This field is only available if you have selected the options Between or Equal in the Amount matching mode field. |
| Max. amount | The maximum number used to compare a transaction amount. Note: This field is only available if you have selected the option Between in the Amount matching mode field. |
| Element | Description |
|---|---|
| Action | The action that is performed by the system when the rule is appslied. The following options are available:
|
| Resulting entry type | The identifier of the entry type that the system will use as a template to create a cash transaction to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system. You can create entry types by using the Entry types (CA203000) window. The field is displayed if the Create document option is selected in the Action field. |
| Default offset account | The account that is used as the offset account for transactions being created. The account is copied from the selected entry type. You can override this account on the bank transaction rule. The bank transaction being made will inherit the account from the rule. If no account is set on the rule, the transaction will inherit the account from the entry type. |
| Default offset subaccount | The corresponding subaccount. The subaccount is copied from the selected entry type. You can override this subaccount on the bank transaction rule. The bank transaction being made will inherit the subaccount from the rule. If no subaccount is set on the rule, the transaction will inherit the subaccount from the entry type. |
| VAT zone | The VAT zone that applies to the transaction. |
| VAT calculation mode | This field has a read-only value that always shows Gross. Gross: The amount in the document detail line includes a tax or taxes. |
| VAT category | A list of taxes associated with a product or a service when it is purchased or sold. |
| Branch | The branch that applies to the transaction. |
| Element | Description |
|---|---|
| Cash account | The cash account for which you want to view transactions. |
| From date | The start date of the date range for which you want to display transactions. |
| To date | The end date of the date range. |
| Statement no. | The reference number of the imported bank statement for which you want to view transactions. |
| Column | Description |
|---|---|
| Statement no. | The reference number of the bank statement from which the transaction was imported. Click the link to view the details of the bank statement. |
| Ext. ref. no. | The external reference number of the transaction. |
| Match type | The status of the bank transaction, which can be one of the following:
|
| Trans. date | The date of the bank transaction. |
| Trans. descr. | The description of the bank transaction. |
| Receipt | The amount of the receipt. |
| Disbursement | The amount of the disbursement. |
| Invoice no. | The number of the invoice to which the bank transaction was applied. |
| Name from bank | The name of the bank that processed the transaction. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Entry type ID | The identifier of the entry type that was used to create a document to match the bank transaction. |
| Applied rule | The identifier of the rule that was applied to the bank transaction. You can view the list of available rules in the Bank transaction rules (CA204500) window. |
| Workspace | The workspace in which the document was entered. |
| Type | The type of the document. |
| Reference no. | The reference number of the matched document. Click the link to view document details. |
| Customer/supplier no. | The business account (customer or supplier) referred to in the selected document. |
| Customer/supplier name | The name of the business account (customer or supplier). |
| Payee name | The name of the person/company to which the payment has been made. |
| Payment method | The method used in payment of the transaction. |
| Trans. ID | The transaction ID of the transaction. |
| Location | The payment location of the transaction. |
| Trans. code | The code of the transaction. |
| Button | Description |
|---|---|
| Actions | Provides the Change ID menu command, which gives you the ability to change the ID of the currently selected cash account. When you invoke this menu command, the Specify new ID dialogue box opens, where you specify the new cash account identifier in the Cash account field and click OK. |
| Element | Description |
|---|---|
| Cash account | The cash account identifier. To create a new cash account, type its code in accordance with the Segment keys (CS202000) window. |
| Active | A check box that indicates (if selected) that the account is active. |
| Account | The account on the chart of accounts to which this cash account is linked to trace transactions in the General ledger. You can select an account of the needed type from the list of accounts available on the chart of accounts. |
| Subaccount | The subaccount to be used with the account on the chart of accounts to which this cash account is linked. |
| Branch | The branch to which this cash account belongs. This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Currency | The currency used for the selected account. The field is filled automatically by the system as follows:
|
| Currency rate type | The currency rate type to be used for the cash account. If the field is empty, the system will use a value specified in the Currency management preferences (CM101000) window. |
| IBAN | The IBAN number of the bank account that is associated with this cash account. |
| BIC | The BIC number of the bank account that is associated with this cash account. |
| Element | Description |
|---|---|
| Clearing account | The clearing account to be used for the cash account. |
| Restrict visibility with branch | A check box that indicates (if selected) that this cash account is visible only to a user signed in to the branch that is associated with this cash account.
Note
that if visibility of the account is restricted, the documents connected to this account will not be payable in the Process payments (AP50301S) window. This field is available only if the Inter-branch transactions check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Payment message length | The length of the payment message that is associated with this cash account. |
| Bank ID | The supplier number of the bank associated with this cash account. Note: In Visma Net, banks are defined as suppliers. |
| Upload files manually | Click this to upload files manually. When you select this account in the Import incoming payments (AR305500), Payment info from AutoPay (AP50550S) and the Import bank transactions (CA306500) windows, the Upload file button will be active. |
| Element | Description |
|---|---|
| Requires reconciliation | A check box that indicates (if selected) that reconciliations are required for this cash account. |
| Reconciliation number series | The number series to be used to generate reference numbers for reconciliations performed for the cash account. |
| Match bank transactions to batch payments | A check box that indicates (if selected) that during the processing of the imported bank transactions, the system should search for a match among supplier ledger |
| Element | Description |
|---|---|
| Default action bank statements | For AutoPay inbox (CA50400S), you can choose an action for import of bank statements. You can set the default action here.
|
| Default action incoming payments | For AutoPay inbox (CA50400S), you can choose an action for import of incoming payments. You can set the default action here.
Note
If you have selected the check box Automatic split of batch payment from customers into payments per customer and choose the action Import from AutoPay, the system will not create a customer payment and match the invoices that are paid. These must be matched manually. Use the column Invoice list under Process incoming payments to get information about which invoices that are paid. If you have selected the check box Automatic split of batch payment from customers into payments per customer and choose the actions Import from AutoPay and match or Import from AutoPay and process, the system will create a customer payment and match the invoices that are paid for that customer. |
| Process incoming payment transaction date | The date from the AutoPay that will be the transaction date for the imported transactions. In the AutoPay file there are two dates:
Here you can choose which date should be the transaction date, determining the general ledger period. |
| Manual file format | To import bank transactions manually, you have to select a manual file format here. |
| Column | Description |
|---|---|
| Payment method | The payment method associated with this cash account. |
| Use for suppliers | A check box that you select to indicate that this method can be used in the Supplier ledger workspace. |
| Default account | A check box that you select to indicate that this is the default payment method for use in Supplier ledger for this branch. |
| Suggest next supplier ledger no | A check box that means (if selected) that the system automatically generates the next number (as the last number incremented by 1) in the Payment ref. field in the Supplier payments (AP302000) window when a user creates a new payment of this payment method using this cash account. If this option is not selected, the user can enter the next reference number manually; the system will not allow the user to save the payment if the entered reference number has been used before. |
| Last reference number suppliers | The most recently used reference number for the payment of the method when the method is used for this cash account in this branch. Initially, this number incremented by 1 will be used for the first payment made by this method from this cash account in this branch if the Suggest next supplier ledger number check box is selected. |
| Last reference number batches | The most recently used reference number for batch payments. |
| Use for customers | A check box that indicates (if selected) that this method is used in Customer ledger. |
| Default | A check box that indicates (if selected) that this is the default payment method in Customer ledger for this branch. |
| Default for refund | A check box that indicates (if selected) that this payment method is used as the default one for returns made for this cash account in this branch. |
| Suggest next customer ledger no. | A check box that means (if selected) that the system automatically assigns the next number (as the last number incremented by 1) in the Payment ref. field in the Supplier payments (AP302000) window when a user enters a new payment of this payment method using this cash account. If this option is not selected,you can enter the next reference number manually; the system will not allow the user to save the payment if the entered reference number has been used before. |
| Last reference number customers | The most recently used reference number for the payment made by this method for this cash account when the method is used in this branch. Initially, this number incremented by 1 will be used for the first payment associated with this cash account if the Suggest next customer ledger no check box is selected. |
| Column | Description |
|---|---|
| Clearing account | The cash account used to record customer payments that will later be deposited to the bank. |
| Payment method | The payment method of the deposited payment to which this charge rate should be applied. If the field is empty, the charge rate is applied to deposited payments, regardless of their payment method. |
| Charges type | The entry type of bank charges that apply to the deposit. |
| Charge rate | The rate of the specified charges (expressed as a percent of the deposit total). |
| Column | Description |
|---|---|
| Entry type ID | The entry type, selected by its identifier. |
| Disb./receipt | The basic type of cash transaction designated by this entry type: Receipt or Disbursement. |
| Workspace | The way the entry type is used in the system. For entry types used as charges for outgoing and incoming payments, select CA. |
| Default offset account branch | The branch to which the default offset account belongs. This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Default offset account | The account that is used by default as the offset account for this entry type. |
| Default offset subaccount | The corresponding subaccount. |
| Reclassification account | The cash account that is used to temporary hold payments that came to the bank account but cannot be entered as valid payments because the customer or supplier is unknown. The parameter is used together with the Use for payments reclassification check box. |
| Business account | The supplier account, if the entry type is used to record transactions that involve a particular supplier, or the customer account, if the entry type is used to record transactions that involve a particular customer. |
| Entry type description | A detailed description of the entry type that is used as a transaction description by default. |
| Use for payments reclassification | A check box that you select if this entry type is used to record unknown payments that need to be reclassified later. |
| Reclassification account override | The account that should be used instead of the reclassification account specified as the default one in the Entry types (CA203000) window. |
| Override offset account branch | The branch to which the overriding offset account belongs. This field is available only if the Multi-branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Offset account branch override | The account that should be used as the offset account for this entry type with this cash account instead of the default offset account specified in the Entry types (CA203000) window. We recommend that for the Disbursement type of transaction, you specify an expense account. For the Receipt type of transaction, specify an asset account. |
| Offset subaccount override | The subaccount for this entry type to be used with this cash account instead of the default offset subaccount specified in the Entry types (CA203000) window. |
| VAT zone | The VAT zone to be used by default with this entry type. |
| VAT calculation mode | The VAT calculation mode to be used by default with this entry type: Select one of the following options:
|
| Column | Description |
|---|---|
| Payment method | A payment method that is linked to the cash account and has the Require remittance information for cash account check box selected in the of the Payment methods (CA204000) window. Select a payment method to update remittance information for it. |
| Column | Description |
|---|---|
| Description | The element name for the remittance information. |
| Value | The value of the element for the remittance information. |
| ID | The system-generated identifier of the element. |
| Payment method | The payment method linked with the Remittance information. |
| Element | Description |
|---|---|
| Name | Enter a name for the signature. |
| Signature | The file name of the selected image to be uploaded. The file name only appears after you have browsed for the file. |
| Browse | Select a cash account in the Cash account field to activate this button. By clicking this button, the Open pop up window appears. Here you browse for the image to upload, select the image file and then click the Open button. |
| Upload | By clicking this button you upload the image to the system. |
| Drag and drop the image here to upload it | Drag and drop your image. |
| Button | Description |
|---|---|
| Release | Releases the selected transactions or those for which you have selected the unlabelled check box in the table. |
| Clear | Marks selected transactions in the table as cleared. If you click this button, in the table below, the Cleared check box will be selected and the Clear date field will be filled with the current date. You can clear a transaction regardless of its status. The clearing step is optional in cash transaction processing, and whether you use it depends on your company policy. |
| Element | Description |
|---|---|
| Cash account | The cash account for which activity is displayed. |
| Start date | The start date of the date range for which you want to view information. By default, the start date is the first date of the current month, week, or financial period, depending on the option specified as the Default date range in the Cash management preferences (CA101000) window. You can select any date that is earlier than the End date. |
| End date | The end date of the date range for Default date range which you want to view information. By default, it’s the last date of the current week, month, or financial period, also depending in the in the Cash management preferences (CA101000) window. |
| Show summary | A check box that you select if you want the system to group transactions in the list as receipts and disbursements as well as by day. If it is not selected, you will see the detailed view of the transactions listed. |
| Include unreleased | A check box that indicates (if selected) that the unreleased transactions will also be displayed on the list. |
| Currency | The currency of the selected cash account. |
| Element | Description |
|---|---|
| Beginning balance | The cash account balance at the start of the specified period for the applicable transactions. |
| Total debit | The total amount of receipts calculated for the applicable transactions. |
| Total credit | The total amount of disbursements calculated for the applicable transactions. |
| Ending balance | The cash account balance at the end of the specified period for the applicable transactions. |
| Button | Description |
|---|---|
| Create transaction | Opens the Quick transaction dialog box. Here you can create a supplier ledger, customer ledger, or cash management transaction, depending on the selected entry type. The transaction gets its ID in accordance with the number series used in the appropriate workspace for documents. |
| Element | Description |
|---|---|
| Cash account | The cash account to be updated by this transaction. |
| Entry type | The user-defined type of cash transaction. |
| Doc. date | The date of the transaction. |
| Period | The financial period to which the transaction is posted. |
| Currency | A read-only column that shows the currency of the cash account. |
| View base / View currency | For the documents with amounts in foreign currency, the Currency toggle button switches the currency of the amounts between the base currency and the selected foreign currency. The label on the Currency toggle button depends on the currently selected currency of the amount:
The Currency toggle button does not affect the documents with amounts in the base currency only. |
| Document ref. | The reference number of the corresponding external document. |
| Amount | The amount of the transaction in the specified currency. |
| Description | A detailed description of the transaction. The field is filled by default with the description of the selected entry type. |
| Status | The status of the transaction. |
| Cleared | A check box that you select to indicate that this transaction has been cleared. |
| Offset account | The general ledger account that is used by default as the offset account for transactions. The field is visible if the Entry type ID is set to Cash management on the Create payment tab in the Process bank transactions (CA306000) window. |
| Offset subaccount | The offset subaccount used with the account selected. The field is visible if the Entry type ID is set to Cash management on the Create payment tab in the Process bank transactions (CA306000) window. |
| Save (button) | Creates a transaction with the specified details and closes the dialog box. |
| Cancel (button) | Clears the dialog box elements and closes it without saving the transaction. |
| Column | Description |
|---|---|
| Doc. date | The document date. |
| Day of week | The day of the week that corresponds to the date. |
| Receipt | The total amount of receipts entered for the specified date. |
| Disbursement | The total amount of disbursements entered for the specified date. |
| Ending balance | The cash account balance at the end of the day. |
| Column | Description |
|---|---|
| Doc. date | The date of a transaction or a document. |
| Post period | The posting period of the transaction. |
| Workspace | The workspace where the transaction was entered. |
| Orig. doc. number | The identifier of the document. Click the link to navigate to the appropriate window so you can view the details of the transaction. |
| Document ref. | The reference to an external document, if one exists. |
| Trans. type | The cash-related document type, which can be any of the following:
|
| Batch no. | The reference number of the batch (generated for the transaction). Click the link to navigate to the Journal transactions (GL301000) ../../accounting/gl301000-ref.html window so you can view batch details. |
| Status | The status of the document. The status depends on the processing workflow defined for the particular document ( Trans. type ). |
| Receipt | The document amount if it is of the Receipt type. |
| Disbursement | The document amount if it is of the Disbursement type. |
| Ending balance | The cash account balance, as updated by this transaction. |
| Deposit no. | The number of the deposit that includes this transaction. |
| Description | A detailed description of the transaction. |
| Customer/Supplier no. | The supplier or customer associated with the document if it is a supplier ledger or customer ledger document. |
| Account name | The name of the customer or supplier. |
| Day of week | The day of the week when the transaction was created. |
| Clear date | The date of the clearing. |
| Cleared | Marks selected transactions in the table as cleared. If you click this button, the Cleared check box will be selected and the Clear date box will be filled with the current date. You can clear a transaction regardless of its status. The clearing step is optional in cash transaction processing, and whether you use it depends on your company policy. |
| Reconciled | A check box that you select to indicate that this transaction has been reconciled. |
| Reconciled number | The identification number of the reconciliation statement. |
| Button | Description |
|---|---|
| View as a report | Opens the Cash flow forecast (CA658000) report, which is generated for the selected data. |
| Element | Description |
|---|---|
| Start date | The start date for the 30-day forecast. |
| Cash account | The cash account for which you want to view the cash flow forecast. |
| Include supplier and customer documents without cash account | A check box that you select to include in the forecast calculation the documents with no cash account specified. The system attempts to assign a cash account to each such document based on supplier or customer default settings, and for the specified cash account, the system shows the document only if the assigned default account matches the selected account. If no account was assigned, the document is shown on the selected cash account. If you have selected no cash account, specify the Default cash account to include all the documents with no cash account specified. |
| Default cash account | The cash account for which you want to view the forecast. |
| Convert to currency | The currency to which you want to convert the forecast. |
| Convert currency rate type | The exchange rate to be used for conversion. |
| Include unreleased documents | A check box that you select to include unreleased documents in the forecast calculation. |
| Include unapplied payments | A check box that you select to include unapplied payments in the forecast calculation. |
| Include scheduled documents | A check box that you select to include the recurring documents that should be generated during the 30-day period of the forecast. |
| Show summary only | A check box that you select to view only the beginning and ending balances for the 30-day period and the 30-day totals, where applicable. |
| Column | Description |
|---|---|
| Type | The type of cash forecast detail shown in the row. Select one of the following options:
|
| Cash account | The cash account for which the forecast details are calculated. |
| Description | The user-provided description of the cash account. |
| Customer/supplier | The business account of the customer or supplier associated with the cash forecast detail. |
| Account name | The name of the customer or supplier associated with the detail. |
| Forecast transactions | The amount of the anticipated cash transactions that were manually entered for the cash account. |
| Summary amount | The summary amount. The type of amount shown depends on the row type. |
| 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. |
| 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. |
| 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. This means all your cash accounts will be shown in the table of that window, unless you manually select a default account. 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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: 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.
Note
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. |
| 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. |
| 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. |
| 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. |
| 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.
Note
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. |
| Button | Description |
|---|---|
| Reverse | Releases the selected transaction and creates a batch. |
| Reversing cash entries | Redirects you to a report that shows the details of cash entries which are created by reversing a cash entry. |
| Element | Description |
|---|---|
| Ref. no. | The unique identifier assigned to the cash transaction in accordance with the number series. |
| Trans. date | The date of the transaction. |
| Period | The financial period to which the transaction should be posted. |
| Document ref. | The external document reference number. |
| Description | A detailed description of the transaction. |
| Cash account | The cash account that is a source account for the transaction. |
| Currency | The currency of the cash account. |
| Exchange rate | The amount corresponding to the Currency field, and the name of the field is only visible if you hover over the field. By clicking the field, the Rate selection dialog box opens. See description below. |
| View base (button) | When you click View base the following happens:
Click View currency again to return to the original view. |
| Entry type | The user-defined transaction type. Select the appropriate type from the list of entry types defined for the selected cash account. |
| Disb./receipt | The basic type of the transaction:
|
| Amount | The amount of the transaction. |
| VAT taxable total | The document total that is subjected to VAT. The VAT taxable amount will be displayed in this field only if the Include in VAT taxable total check box is selected for the applicable tax in the VAT (TX205000) window. If the check box is cleared, this field will be empty. If the document contains multiple transactions with different taxes applied and each of the applied taxes has this check box selected, the taxable amount calculated for each line of the document will be added to the VAT taxable total field of the document. This field is available only if the VAT reporting functionality is enabled in the Enable/disable functionalities (CS100000) window. |
| VAT total | The total amount of tax paid in the document. If a used VAT has been applied to the document, the used VAT amount is not included in the VAT total amount. You can view the used VAT details on the VAT details tab of the current window. |
| Element | Description |
|---|---|
| Currency rate type ID | The currency rate type specified for the selected currency pair. |
| Effective date | The date on which the currency rate in this row becomes effective. |
| Currency unit equivalents | View the currency conversion. |
OK (button) |
Closes the dialog box. |
| Column | Description |
|---|---|
| Branch | The branch that created the transaction. |
| Item ID | The ID of the non-stock item specified as the transaction subject. |
| Description | The description provided for the item. |
| Quantity | The quantity of the item. |
| UoM | The unit of measure of the item. |
| Price | The unit price for the item. |
| Amount | The total amount for all units or items. |
| Offset account | The account to be updated by the transaction. By default, it is an offset account defined with the entry type selected for the cash account, but you can change this account. |
| Account description | A description of the account. |
| Offset cash account | The account to be updated by the transaction. By default, it is an offset account defined with the entry type selected for the cash account, but you can change this account. |
| Offset subaccount | The corresponding subaccount to be used for the transaction. |
| Project | The project with which this transaction is associated, or the code indicating that this transaction is not associated with any project; the non-project code is specified in the Project accounting preferences (PM101000) ) window. This column appears only if the Projects workspace has been enabled in your system and integrated with the Cash management workspace. |
| Line no. | The functionality is not available to the customers. |
| Project | The project with which the item is associated. Or, the non-project code, if the item is not intended for any project. The non-project code is specified in the Project accounting preferences (PM101000) ) window. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Project task | The particular task of the project with which this transaction is associated. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Non-invoiceable | A check box that indicates (if selected) that this transaction is non-invoiceable in the project. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| VAT category | A list of taxes associated with a product or a service when it is purchased or sold. |
| Column | Description |
|---|---|
| VAT ID | The VAT that applies to the cash transaction. |
| VAT rate | The rate of the VAT. |
| Taxable amount | The taxable amount of the transaction. |
| VAT amount | The VAT amount calculated for the transaction. |
| Deductible VAT rate | The percent of deduction that applies to the VAT amount paid to the supplier for specific purchases. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Expense amount | The percentage that is deducted from the VAT amount paid to the supplier for specific purchases. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Pending VAT | A Pending VAT (sometimes called a suspended VAT) is applied to those documents whose VAT amounts should be recognised later than the document has been released. Once a document to the pending VAT is released, the system records its VAT amount to an intermediate account (such as the Pending VAT payable account or the Pending VAT claimable subaccount, where the VAT amount is kept until you initiate the process of recognising the VAT). Suspended VAT information is not added to the VAT report until the taxes are recognised. |
| Include in VAT exempt total | A check box that indicates (if selected) that this value-added VAT has a zero rate, and is used to calculate a document subtotal that is actually exempt from VAT. The calculated amount will be displayed in the VAT exempt total field in the documents (such as invoices). Only available for VAT type VAT. |
| Statistical VAT | A check box that indicates (if selected) that the VAT on documents will be calculated only for statistical purposes. Or, will be reported only, but not actually paid. Only available for VAT type VAT. |
| Reverse VAT | A check box that indicates (if selected) that this is a reverse VAT. A reverse VAT is a type of VAT used in some countries of the European Union (EU). When this type of VAT is applied to a company that supplies goods or services to other EU countries, the liability of the reporting VAT is reversed and goes to the customer rather than to the supplier. Only available for VAT type VAT. |
| VAT type | The types of VAT:
|
| Element | Description |
|---|---|
| Batch no. | The number of the batch generated to implement the cash transaction. It appears automatically after the transaction is released. Click the number to view the batch details. |
| Element | Description |
|---|---|
| VAT zone | The VAT zone that applies to the transaction. |
| VAT calculation mode | The VAT calculation mode, which defines which amounts (VAT-inclusive or VAT-exclusive) should be entered in the detail lines of a document. One of the following options can be selected:
|
| Button | Description |
|---|---|
| Close periods | Initiates the process of closing the financial periods you have selected (by using the check boxes in the unlabelled column). |
| Unreleased documents | Opens the Unreleased cash management documents report so you can view and print the open documents for the selected financial period. |
| Column | Description |
|---|---|
| Period | An ID of the financial period. |
| Description | A description of the financial period. |
| Active | A check box that indicates (if selected) that the financial period is active. |
| Column | Description |
|---|---|
| Entry type ID | The unique ID for the entry type. An alphanumeric string of up to 10 characters can be used. |
| Disb./receipt | The type of a transaction this entry type is based on: Receipt (money in) or Disbursement (money out). |
| Entry type description | The detailed description for the entry type. The description is used as default description of a transaction. You can use an alphanumeric string of up to 30 characters. |
| Workspace | The workspace, which defines whether the system creates a document that affects the balance of a customer or a supplier as a result of the transaction or whether balances of general ledger accounts affected only:
For the charges that a bank may apply to outgoing and incoming payments, select Cash management. |
| Business account | The supplier account ID, if the entry type is used to record transactions that affect balances of suppliers (Supplier ledger), or the customer account ID, if the entry type is used to record transactions that affect balances of customers (Customer ledger). The value is used by default when you create a transaction on the fly. |
| Default offset account | The general ledger account that is used by default as the offset account for transactions of this entry type. If this entry type is based on the Disbursement type of transaction, specify an Expense account. If this type is based on the Receipt type of transaction, select an Asset account. You need to specify default offset account for entry types that affect balances of general ledger accounts ( workspace set to Cash management ) only. You can override this account when you enter a transaction in the Cash management workspace. Do not specify the offset account or subaccount if you use this entry type for recording unknown payments. |
| Default offset subaccount | The subaccount to be used by default for transactions of this entry type. |
| Reclassification account | The cash account that is used to temporary hold payments that came to the bank account but cannot be entered as valid payments because the customer or supplier is unknown. The parameter is used together with the Use for payments reclassification check box. |
| Use for payments reclassification | A check box that indicates (if selected) that the entry type is used for recording unknown payments and involved in the payments reclassification process. |
| Deduct from payment | The check box that indicates (if selected) that the entry type is to be used as bank charges whose amounts are deducted from customer payments on the cash account (and on the bank statements). Clear this check box if the bank records charges as separate transactions on its bank statements. For details on using entry types as bank charges, see: About the registration of finance charges. |
| Button | Description |
|---|---|
| Add all cash accounts | Click this to add all active cash accounts to the table. |
| Column | Description |
|---|---|
| Cash account | The number of the cash account connected with the entry type. |
| Description | The description of the cash account |
| Reclassification account override | The reclassification account override on the cash account. |
| Offset account override | The offset account override suggested from the cash account. |
| Offset subaccount override | The offset subaccount override suggested from the cash account. |
| VAT zone | The VAT zone mode connected with the account. |
| VAT calculation mode | The VAT calculation mode connected with the account. |
| Button | Description |
|---|---|
| Release | Releases the selected transaction. |
| Element | Description |
|---|---|
| Transfer number | The transfer number, as assigned by a numbering series. The numbering series for transfers is defined in the Cash management preferences (CA101000) window. |
| Status | The status of the transfer, which is one of the following options:
|
| Hold | A check box that, if selected, indicates that the transfer is on hold. You can clear the Hold check box only for balanced transfers. |
| Description | A detailed description for the transfer transaction. An alphanumeric string of up to 30 characters may be used. |
| RGOL | A read-only field that displays the difference between the amount in the base currency specified for the source account and the amount in the base currency resulting for the destination account, for cases when the source and destination currencies are different. |
| Element | Description |
|---|---|
| Account | The account from which the funds are transferred. |
| Transfer date | The date of the transaction. |
| Cleared | A check box that indicates (if selected) that this transaction has been cleared. |
| Currency | The currency of denomination for the source cash account. |
| Document ref. | The reference number of the transfer in the bank. |
| Amount | The amount of the transaction in the specified currency. |
| Batch number | The identification number of the batch that updates the source and cash-in-transit accounts. |
| Clear date | The date when the transaction was cleared in the process of reconciliation. |
| General ledger balance | A read-only field displaying the balance of the source account recorded in the General ledger for the financial period that includes the transfer date. |
| Available balance | A read-only field displaying the balance of the cash account calculated in accordance with the options selected in the Receipts to add to available balances and Disbursements to deduct from available balances sections in the Cash management preferences (CA101000) window. |
| Base currency amount | The amount of the transfer in the base currency. If the source account is denominated to a foreign currency, the default exchange rate associated with the account is used. You can specify another rate by using the currency controls. |
| Element | Description |
|---|---|
| Account | The account to which the funds are transferred. |
| Receipt date | The date of the transfer receipt. |
| Cleared | A check box that indicates (if selected) that this transaction is cleared. |
| Currency | The currency of denomination for the destination account. |
| Document ref. | The reference number of the transfer in the bank or other financial entity. |
| Amount | The amount of the transaction in the currency of the destination account. |
| Batch number | The identification number of the batch that creates related journal entries to update the cash-in-transit and destination accounts. |
| Clear date | The date when the transaction was cleared in the process of reconciliation. |
| General ledger Balance | The balance of the target account, as recorded in the General ledger. |
| Available balance | The actual balance of the target account. |
| Base currency amount | The amount of the transaction in the base currency. You can specify another exchange rate by using the currency controls. |
| Column | Description |
|---|---|
| Cash account | The cash account to be updated by this transaction. |
| Document ref. | A reference to an external document related to the transfer, the charges, or both. By clicking this reference number, the document details window opens. |
| Doc. date | The transaction date. |
| Description | A detailed description of the charge or expense. |
| Entry type | The entry type of this charge or expense. |
| Offset account | The general ledger expense account that will be updated by this charge or expense. |
| Offset subaccount | The corresponding subaccount. |
| Amount | The amount of the charge or expense. |
| Currency | The currency of the charge or expense. |
| Cleared | A check box that indicates (if selected) that this transaction has been cleared. |
| Element | Description |
|---|---|
| Cash account | The cash account to be updated by this transaction. |
| Entry type | The user-defined type of cash transaction. |
| Doc. date | The date of the transaction. |
| Fin. period | The financial period to which the transaction is posted. |
| Currency | A read-only column that shows the currency of the cash account. |
| Document ref. | The reference number of the corresponding external document. |
| Amount | The amount of the transaction in the specified currency. |
| Description | A detailed description of the transaction. The field is filled by default with the description of selected entry type. |
| Status | The status of the transaction. |
| Cleared | A check box that you select to indicate that this transaction has been cleared. |
| Offset account | The general ledger account that is used by default as the offset account for transactions. The field is displayed if the entry type is set to Cash management. |
| Offset subaccount | The offset subaccount used with the account selected. |
| Save (button) | Creates a transaction with the specified details and closes the dialog box. |
| Cancel (button) | Clears the dialog box elements and closes it without saving the transaction. |
| Element | Description |
|---|---|
| Cash account | The cash account specified on the bank statement for which you want to upload bank transactions. |
| Ref. no. | The reference number of the imported bank statement, which the system generates automatically in accordance with the numbering series assigned to statements in the Cash management preferences (CA101000) window. |
| Statement date | The date of the bank statement specified in the file. |
| Start balance date | The start date, as indicated in the bank statement file (if any). |
| End balance date | The end date, as indicated in the bank statement file (if any). |
| Beginning balance | The balance of the cash account at the start of the date range the bank statement spans, if specified in the file. |
| Ending balance | The balance of the cash account at the end of the date range of the bank statement, if specified in the file. |
| Calculated balance | The balance of the uploaded bank statement, which is calculated as the sum of its lines. Verify that the calculated balance for the statement is equal to the ending balance of the account displayed in the Ending balance field. |
| Button | Description |
|---|---|
| Unhide transaction | Clears the Processed and Hidden check boxes for the selected transaction. The transaction becomes available for processing in the Process bank transactions (CA306000) window. |
| Unmatch | Does the following for the selected bank transaction: Clears the check boxes in the Clears the following for the matched document: The Cleared check box and the Clear date field on the Financial details tab in the Customer payments (AR302000) window for the document. If a document was created to match the transaction, this document should be handled (for instance, voided or matched) manually. |
| View matched document | Navigates to the respective window where you can view details of the matched document or batch for the selected transaction. The button is available only for the matched transactions (for which a check box is selected in the |
| Column | Description |
|---|---|
| Processed | A check box that indicates to the system (if selected) that either this bank transaction has been matched to a document in the system, or a document was created in the Process bank transactions (CA306000) window to record the transaction in the system. |
| Hidden | A check box that indicates to the system (if selected) that this bank transaction has been hidden from the statement on the Process bank transactions (CA306000) window. To make the transaction available for further processing, click Unhide transaction. |
| Trans. ID | The external identifier of the transaction. |
| Ext. ref. no. | The external reference number of the transaction. |
| Trans. code | The bank transaction codes are used to define which types of transactions are reported in the bank statement. |
| Trans. date | The transaction date. |
| Trans. descr. | The description of the transaction. |
| Receipt | The amount of the receipt. |
| Disbursement | The amount of the disbursement. |
| Applied rule | The rule applied to clear a transaction in the Process bank transactions (CA306000) window. |
| Invoice no. | The reference number of the document (invoice) generated to match a bank transaction in the Process bank transactions (CA306000) window. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Archive code | The code of the transaction in the archive. |
| Business account | The supplier or customer associated with the document, by its account identifier. |
| Business account name | The name of the supplier or customer associated with the document. |
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. This field is displayed if you in the Process bank transactions (CA306000) window click Create and then select Cash management in the Module field. |
| Location | The location of the supplier or customer. This field is displayed if you in the Process bank transactions (CA306000) window click Create and then select Supplier ledger or Customer ledger in the Module field. |
| Additional info | Additional information, in free text form, to complement the structured remittance information. |
| Mandate ID | The ID number for the direct debit agreement with a customer and the customer’s bank. |
| Workspace | The workspace the transaction was created in. |
| Name from bank | The name of the bank that processed the transaction. |
| Rejection message | If the import of the transaction is rejected, you can write a message connected with the rejection in this column. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Payment ref. no | The reference number of the payment. |
| Element | Description |
|---|---|
| Payment method ID | The unique identifier of the payment method. An alphanumeric string of up to 10 characters can be used. |
| Active | A check box that indicates whether the payment method is active in the system. |
| Means of payment | One of the system’s built-in payment templates. The following options are available:
|
| Bank account type | The selection for setting the type of payment method, that will determine if the sender’s (the company sending the e-invoice) bank account should be collected from the Payment method details table on the Settings for Customer ledger tab. If this field is empty, it will collect the bank accounts from the Payment settings tab in the Organisations (CS101500) window. The following options are available in the drop-down list:
|
| Payment type code | A list of supported Danish payment types is displayed, the value selected is used for the identification of payment type. |
| Description | A description of the payment method. Use an alphanumeric string of up to 30 characters. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Use for suppliers | A check box that indicates whether the payment method will be used in Supplier ledger. If you select this check box, the Settings for supplier ledger tab appears in this window. |
| Use for customers | A check box that indicates whether this payment method will be used in Customer ledger. If you select this check box, the Settings for customer ledger tab appears in this window. |
| Require remittance information for cash account | A check box that indicates to the system whether the cash account requires remittance information for the payment method. Note: When the Payment method ID and this check box are selected and linked to a cash account, the Remittance settings tab appears in the Cash accounts (CA202000) window. |
| Column | Description |
|---|---|
| Cash account | The cash account linked to the payment method. |
| Description | The description of the cash account. |
| Branch | The branch to which the cash account belongs. This field is available only if the Multi-branch support check box is selected in the Enable/disable functionalities (CS100000) window. |
| Use for supplier | A check box that indicates whether the payment method is used in the Supplier ledger workspace for this branch. |
| Default account | A check box that indicates whether this is the default cash account for this method when it is used in Supplier ledger. If there are multiple branches, one default account can be defined per branch for this payment method. |
| Suggest next supplier no. | A check box that means (if selected) that the system automatically generates the next number (as the last number incremented by 1) in the Payment ref. field in the Supplier payments (AP302000) window when a user creates a new payment of this payment method by using this cash account. If this option is not selected, the user can enter the next reference number manually; the system will not allow the user to save the payment if the entered reference number has been used before. |
| Last reference number suppliers | The number used for the last payment associated with this cash account in Supplier ledger. Initially, this number incremented by 1 will be used for the first payment associated with this cash account if the Supplier ledger - Suggest next number check box is selected. |
| Last reference number batches | The number used for the last batch of payments generated for this method in Supplier ledger. Initially, this number incremented by 1 will be used for the first batch generated for a payment made by this method in Supplier ledger. This value is used only for batch payments in Supplier ledger. |
| Use for customers | A check box that indicates whether the cash account will be used with the selected payment method in the Customer ledger workspace for payments from customers. |
| Default | A check box indicating whether this is the default cash account for this method when it is used in Customer ledger. If there are multiple branches, one default account can be defined per branch for this method. |
| Default for refund | A check box that you select to use this cash account as the default one for returns made for this payment method in the branch associated with the payment method. |
| Suggest next customer ledger no. | A check box that, if selected, means that the system automatically assigns the next number (as the last number incremented by 1) in the Payment ref. field in the Supplier payments (AP302000) window when a user enters a new payment of this payment method using this cash account. If this option is not selected, the user can enter the next reference number manually; the system will not allow the user to save the payment if the entered reference number has been used before. |
| Last reference number customers | The number used for the last payment associated with this cash account in Customer ledger. Initially, this number incremented by 1 will be used for the first payment made by the method associated with this cash account if the Suggest next customer no. check box is selected. |
| Element | Description |
|---|---|
| Integrated processing | A check box that indicates (if selected) that the payment method requires processing through a processing centre. If this check box is selected for the method, the Processing centres tab appears. |
| Requires account number | A check box that indicates, if selected, that this payment method requires a card number or other unique identifier each time the method is used. Such methods as cash or checks do not require any identifiers, while a credit card method requires card numbers as identifiers and a wire transfer method requires bank account numbers. |
| Void on clearing account | A check box that indicates, if selected, that a payment voided after the appropriate deposit (the one that contains the payment) has been released should be voided on the respective clearing account instead of on the bank account. For more information about using the options, see: About the preparation of deposits |
| Has invoice information | A check box that indicates, if selected, that customer remittance information is required for this payment method. If this check box is selected, the Invoicing information tab will appear in the Customer payment methods (AR303010) window. |
| Default void date to document date | A check box that indicates, if selected, that the date of document voiding is to be set to the origin document date by default. Otherwise, the date of document voiding is set to the current business date if the business date is later than the document date. If the current business date or the date that you specify in the Application date field (that is, the date when the document is supposed to be voided) is earlier than the date of the origin document, then the system uses the origin document date as the date of document voiding. |
| Create batch payment (common for customer and supplier ledgers) | A check box that indicates, if selected, that the system creates a batch payment from the selected payments. |
| Element | Description |
|---|---|
| Direct debit | Select this check box if the payment method can be used for direct debit payments. This will activate the Execution days first/one-off and Execution days recurrent fields. |
| Business to business | The direct debit is paid from one company to another. |
| Combine the first and the following direct debits | Both FIRST and RCUR mandates will be created in the same payment batch. |
| Execution days first/one-off | The number of execution days for a first or one-off payment. |
| Execution days recurrent | The number of execution days for a recurrent payment. |
| Element | Description |
|---|---|
| IBAN | The bank’s IBAN number. |
| Bank account no. | The main bank account number for the bank. |
| Bank account no. 2 | The second bank account number for the bank. |
| Bank account no. 3 | The third bank account number for the bank. |
| BIC (SWIFT) | The BIC or SWIFT code of the bank. |
| Element | Description |
|---|---|
| Factoring company name | The name of the factoring company |
| Assignment note | Assignment note used for factoring |
| Column | Description |
|---|---|
| ID | The system-generated identifier of the payment method element. |
| Banking detail type | The structure of the bank account. |
| Description | The name for the payment method element. An alphanumeric string of up to 10 characters can be used. |
| Required | A check box you select if the user must specify a value for this payment method element. |
| Encrypted | A check box that you select if the values of the element should be stored encrypted. |
| CVV code | The credit card or the debit card’s security code (Card Verification Value). |
| Sort order | The integer that defines the order of this element in the list of elements. The element (row) with the smallest number will appear at the top of the list. |
| Entry mask | The ASCII string to be used as an input mask for the element. |
| Validation reg. exp. | The regular expression to be used for element input validation. |
| Element | Description |
|---|---|
| Require unique payment ref. | A check box that indicates (if selected) that the unique payment reference number is required for each payment document created with this payment method. |
| Element | Description |
|---|---|
| Print payments | A check box that indicates (if selected) that this method involves printing payments. The system requires and validates the uniqueness of each payment reference number entered (manually or automatically) for printed documents. |
| Create batch payment (common for customer and supplier ledgers) | An option that indicates (if selected) that this method involves creating batch payments. The system requires and validates the uniqueness of each batch reference number. |
| Not required | An option that, if selected, indicates that payment documents created with this payment method does not require additional processing. With this option selected, you can additionally specify whether the system must require and validate the uniqueness of each payment reference number, by selecting or clearing the Require unique payment ref. check box in the Payment settings section. |
| Element | Description |
|---|---|
| Export scenario | Select this check box if the scenario can be used for foreign currency payments. |
| Upload payment files manually (the Netherlands only) | Select this check box to upload payment files manually. |
| Express payment | Select this check box if the payment is an express payment. |
| Column | Description |
|---|---|
| ID | The identifier of the payment method element. |
| Banking detail type | The banking detail for the payment method. |
| Description | The user-defined name for the payment method element. An alphanumeric string of up to 10 characters can be used. |
| Required | A check box that you select to indicate that a value must be specified for this payment method element. |
| Sort order | The integer that defines the order of this payment method element in the list of elements. The element (row) with the smallest number will appear at the top of the list. |
| Entry mask | The ASCII string to be used as an input mask for the payment method element. |
| Validation reg. exp. | The regular expression to be used for element input validation. |
| Column | Description |
|---|---|
| ID | The system-generated identifier of the element. |
| Banking detail type | The banking detail for the payment method. |
| Description | The user-defined name for the element. An alphanumeric string of up to 10 characters can be used. |
| Required | A check box that you select if the user must specify a value for this payment method element. |
| Encrypted | A check box that you select to indicate that the values of the element should be stored encrypted. |
| Sort order | The integer that defines the order of the element in the list of elements. The element (row) with the smallest number will appear at the top of the list. |
| Entry mask | The ASCII string to be used as an input mask for the element. |
| Validation reg. exp. | The regular expression to be used for input validation. |
| Column | Description |
|---|---|
| Heading | The heading of the reporting code. |
| Code | The code of the reporting code. |
| Description | The description of the reporting code. |
| Default | Select this check box if the code will be used as the default code for the payment method. |
| Button | Description |
|---|---|
| Match automatically | Initiates the process of matching transactions from the bank statement to Cash management transactions by using settings you have specified in the Settings for matching dialog box (which opens when you click Settings for matching on the window toolbar). If you have not opened this dialog box and specified settings, the system applies the default settings specified on the Bank statement settings tab of the Cash management preferences (CA101000) window. If you have configured rules for document creation in the Bank transaction rules (CA204500) window, the process will try to apply all the active rules to the transactions for which a match was not found. The process ignores any filters set on the table columns. To avoid a match on a different bank account to happen, go to the Cash management preferences (CA101000) window and select the Match only documents with the same bank account number check box on the Bank statement settings tab. You enable the customer and supplier recognition for bank transaction by the same bank account number. |
| Process | Initiates the processing of transactions with the Ready to process check box selected. The processing takes place on all lines that are ready for processing, regardless of any filters set on the table. After processing, in the first column, a |
| Settings for matching | Opens the Settings for matching dialog box. |
| Extract invoice numbers | Initiates the re-processing of the invoice and payment recognition (with prefix) on all open transactions that are not yet matched. For more information, see: Extract invoice numbers |
| Process rejected | Initiates the processing of rejected direct debit payments. The processing takes place on all lines, despite any filters set on the table. |
| Element | Description |
|---|---|
| Days before bank transaction date | The maximum number of days allowed between the date of a cash management transaction (disbursement) and the date of the selected transaction on the bank statement. The system considers the disbursement a matching one if the difference falls within the specified date range. |
| Days after bank transaction date | The maximum number of days allowed between the date of the selected transaction on the bank statement and the date of a receipt. The system considers the disbursement a matching one if the difference falls within the specified date range. |
| Allow matching to credit note | A check box that (if selected) indicates that the system will automatically match the receipt bank transactions to credit notes by the reference number prior to matching them to the purchase invoices. If the check box is cleared (the default value), the receipt bank transactions are always matched to the purchase invoices. |
| Element | Description |
|---|---|
| Days before bank transaction date | The maximum number of days allowed between the date of cash management transaction (receipt) and the date of the selected transaction on the bank statement. The system considers the receipt a matching one if the difference falls within the specified date range. |
| Days after bank transaction date | The maximum number of days allowed between the date of the selected transaction on the bank statement and the date of a receipt. The system considers the receipt a matching one if the difference falls within the specified date range. |
| Ref. no. weight | The relative weight of the evaluated difference between the reference numbers of the bank transaction and the cash management transaction. |
| Consider empty ref. no. as matching | A check box that (if selected) specifies that a bank transaction with an empty reference number is considered as matching to a cash transaction with an empty reference number. If this check box is cleared (the default value), 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 management 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 management transaction. |
| 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. |
| Skip voided transactions during matching | A check box that you select to make the system skip voided transactions during the reconciliation process. |
| Save and close (button) | By clicking this button it saves the settings during your working session and closes the dialog box. |
| Element | Description |
|---|---|
| Cash account | The cash account specified on the bank statement. |
| Branch | The name of the branch associated with the cash account. |
| Status description | The status description contains explanations of the five error types that can be displayed in the Status field in the table. |
| Button | Description |
|---|---|
| Unmatch | Clears all of the following: the check box in the |
| Unmatch all | Clears all of the following: all check boxes in the |
| Hide selected | Rolls back all changes to the selected bank transaction, hides it from the list, and marks it as processed (to confirm the action, click Save on the window toolbar). To be able to hide multiple transactions, you should first add the Hide column to your column view by clicking the You can then clear the Processed and Hidden check boxes for the transaction by clicking Unhide transaction in the Import bank transactions (CA306500) window to be able to view and process the transaction again. |
| Undo split | Click this to undo the splitting of the selected split line. If you have processed one or more of the split lines, you will not be able to undo the split on the not processed lines. |
| Column | Description |
|---|---|
| Ext. ref. no. | The external reference number of the transaction. |
| Ready to process | A check box that, if selected, indicates to the system that this bank transaction is ready to be processed. Namely, the transaction has been matched to the transaction in the system or details of a new document (to match this transaction) were specified. |
| Name from bank | The customer/supplier of the transaction. |
| Trans. date | The transaction date. |
| Trans. descr. | The description of the transaction. |
| Status | Shows the error code for the select bank transaction. There are 5 type of errors codes displayed:
|
| Disbursement | The amount of the disbursement. |
| Receipt | The amount of the receipt. |
| Trans. code | The code of the transaction. |
| Account from bank | The bank account or IBAN from which the payment was paid for the customer transactions. In some formats, it contains the IBAN or bank account from which you have paid to the supplier. |
| Archive code | The code of the document in the archive. |
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Customer/Supplier name | The name of the customer or the supplier associated with the document. The name is created in the Customers (AR303000) or the Suppliers (AP303000) window. |
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. The field is displayed if the Cash management option is selected in the Workspace field. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. The system uses this column to make a lookup against the reference number on the purchase invoice if it is a disbursement and on the sales invoice if it is a receipt. |
| Location | The location of the supplier or customer. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Mandate ID | The ID number for the Direct debit agreement with a customer and the customer’s bank. |
| Match type | The available match types are:
|
| Orig. disbursement | The amount of the original disbursement. |
| Orig. receipt | The amount of the original receipt. |
| Payee name | The payee name, if any, specified for a transaction. |
| Payment method | The payment method that was used for the transaction. |
| Payment ref. no. | The reference number of the transaction. |
| Rejection message | The message describing the reason for the rejection of the payment. |
| Trans. ID | The ID of the transaction, |
| Trans. entry date | The entry date of the transaction. |
| Workspace | The workspace in which the document was entered. |
| Hide | A check box which you can select for each transaction you want to hide. After you have made your selection, click the Hide selected button. |
| Column | Description |
|---|---|
| Matched | A check box that you select to match the document in this row to the transaction selected on the bank statement. |
| Match relevance | The coefficient of the match relevance, which is less than or equal to 1 and is calculated automatically for the selected transaction on the bank statement and this document. |
| Orig. doc. number | The ID of the document, as assigned by the corresponding numbering series. |
| Doc. date | The date of the transaction or document. |
| Document ref. | The number of the corresponding external document, if one exists. |
| Workspace | The workspace in which the document was entered. |
| Trans. type | The document type to which the selected payment from the left part can be applied. |
| Description | A detailed description of the document. |
| Post period | The post period of the payment. |
| Amount | The document amount or transaction amount if it is a receipt. A negative value indicates that the amount is a disbursement. |
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Customer/Supplier name | The name of the customer or the supplier, associated with the document. The name is created in the Customers (AR303000) or the Suppliers (AP303000) window. |
| Element | Description |
|---|---|
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Location | The business account location associated with the document. |
| Payment method | The payment method associated with the document. |
| Account no. | The account to which the payment has been made. |
| Update bank account | You can update the IBAN/BBAN from the imported bank payment line. In the Cash management preferences (CA101000) window under Bank statement settings, select the check box Update bank account on customer/supplier from Process bank transactions. When 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. If the customer’s/supplier’s bank account is empty or different, the button Update bank account will appear. If you click the button the customer/supplier is updated with the account from the bank. |
| Column | Description |
|---|---|
| Matched | A check box that you select to match the document in this row to the transaction selected on the bank statement. |
| Match relevance | The coefficient of the match relevance, which is less than or equal to 1 and is calculated automatically for the selected transaction on the bank statement and this document. |
| Workspace | The workspace in which the document was entered. |
| Type | The document type to which the selected payment from the left part can be applied. |
| Ref. no. | The reference number of the document. Click the link to view the details of the document. |
| Ext. ref. no | The supplier’s reference number. |
| Doc. date | The date of the document. |
| Amount | The document amount. |
| Customer/Supplier no. | The number of the customer or the supplier account. |
| Customer/Supplier name | The name of the customer or the supplier, associated with the document. The name is created in the Customers (AR303000) or the Suppliers (AP303000) window. |
| Description | A detailed description of the document. |
| Branch | The branch on which the document is created. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Create | Select this check box to initiate creating a new payment for the selected transaction. Clear the check box to delete any information you have specified for the new document. |
| Clear rule | A button that clears the applied rule and the settings the system has configured by using the applied rule. |
| Create rule | By clicking the button it navigates to the Create rule dialog box, where you enter the ID of the new rule. Click Create to navigate to the Bank transaction rules (CA204500) window, where you can view and modify the details of the rule and save it for future use. |
| Cash account details/ Customer details/ Supplier details | Click this button to open the cash account, supplier ledger or customer ledger window as a pop-up to see the details of the selected document. The name of the button changes depending on the selected workspace. In the Cash management preferences (CA101000) window you can define which window will be opened for the different workspaces. If no window has been selected, the following windows will be opened:
|
| Workspace | The workspace where the document originated. Select one of the following workspaces:
|
| Entry type ID | The ID of an entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. The field is displayed if the Cash management option is selected in the Module field. To create a new entry type, click the Edit button next to the field to open the Entry types (CA203000) window. |
| VAT zone | Change or specify the VAT Zone or VAT category that applies to the transaction if necessary. The VAT calculation mode is set to Gross by the system, and the VAT category field is updated with the default value when the VAT zone is selected. |
| VAT calculation mode | This field has a read-only value that always shows Gross. |
| Tran. descr. | The description of the selected transaction that can be modified. These changes affect the transaction description in the new document only; the description of the imported bank transaction remains unchanged (in the Bank transactions to match table). |
| Customer/Supplier | The name of the customer or the supplier, associated with the document. The name is created in the Customers (AR303000) or the Suppliers (AP303000) window. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Location | The location of the supplier or customer. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Payment method | The payment method used by a customer or supplier for the document. This field is visible if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Invoice no. | The internal reference number for the invoice/credit note that has been paid. The system uses this column to make a lookup against the reference number on the purchase invoice if it is a disbursement and on the sales invoice if it is a receipt. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Total amount | The total amount of the document. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Amount used | The amount of the transaction for which the documents (to match the bank transaction) are added. This field is displayed if the Cash management option is selected in the Workspace field. |
| Remaining balance | The balance of the transaction for which you can add the documents. This field is displayed if the Cash management option is selected in the Workspace field. |
| Application amount | The amount of the application for this payment. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Unapplied balance | The unapplied balance of the document. This field is displayed if the Supplier ledger or Customer ledger option is selected in the Workspace field. |
| Write-off amount | The total amount of write-offs specified for documents to be applied. This field is displayed if the Customer ledger option is selected in the Workspace field. |
Split (button) |
Click this button to split the selected line in the left table into different lines. The button only appears when there is a remaining amount to match. To read more about this functionality, go to Match a bank transaction or incoming payment line to different documents. If the Automatic split of batch payment from customers into payments per customer check box is selected, on the Bank statements settings tab in the Cash management preferences (CA101000) window, payments will be automatically split on bank statements import. |
| Allow unapplied balance | Select this check box to process payments in situations where you need to overrule the setting Do not create payment when bank payment amount is not fully applied. This check box is available only if the setting Do not create payment when bank payment amount is not fully applied is marked in the Cash management preferences (CA101000) window and the unapplied balance is different from 0. |
| Update bank account | You can update the IBAN/BBAN from the imported bank payment line. In the Cash management preferences (CA101000) window on the Bank statement settings tab, select the check box Update bank account on customer/supplier from Process bank transactions window. When 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. If the customer’s/supplier’s bank account is empty or different, the Update bank account button will appear. Clicking the button will update the customer/supplier with the account from the bank. |
| Column | Description |
|---|---|
| Branch | The branch that created the document. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Description | The description of the document. By default, this is the description in the Trans. descr. field in the top part of this tab, and you can edit it. |
| Quantity | The quantity of the item. |
| Price | The price for the item. |
| Amount | The total amount for all items. |
| Offset cash account | The cash account to be updated by the document. By default, it is an offset cash account defined with the entry type selected in the Entry type ID field, but you can change this account. The field is displayed if the selected entry type is used for payments reclassification. |
| Offset account | The account to be updated by the document. By default, it is an offset account defined with the entry type selected in the Entry type ID field, but you can change this account. |
| Description | A description of the account. |
| Offset subaccount | The corresponding subaccount to be used for the document. |
| Item ID | The ID of the non-stock item used as a transaction subject. |
| VAT category | The default value is based upon what you selected in the VAT zone field. |
| Non-invoiceable | A check box that indicates (if selected) that this document line is non-invoiceable in the project. This column appears only if the Projects module has been enabled and integrated with this workspace |
| Project | The project with which this document is associated, or the non-project code indicating that this document is not associated with any project. The Non-project code is specified in the Project accounting preferences (PM101000) window. The Project accounting check box is enabled in the Enable/disable functionalities (CS100000) window. That is, the Cash management check box must be selected in the Visibility settings section on the General information tab in the Project accounting preferences (PM101000) window. The column is hidden by default. |
| Project task | The particular task of the project with which this document is associated. The column is available if the Project accounting check box is enabled in the Enable/disable functionalities (CS100000) window. That is, the Cash management check box must be selected in the Visibility settings section on the General information tab in the Project accounting preferences (PM101000) window. The column is hidden by default. |
| Button | Description |
|---|---|
| Select documents | By clicking the button, the Select documents pop-up window appears. Here you can select multiple documents using the date and branch filters on the top and the Select all documents option. You need to select a Customer/Supplier no. in the top part of this tab for documents to be displayed in this pop-up window. If you click the button and there is no conversion rate between the cash account’s currency and none of the documents’ currencies of the selected Customer/Supplier no., a message appears. It notifies that you need to define the exchange rate for the currency of this cash account in the Currency rates (CM301000) window. |
| Load documents | By clicking the button, the customer or the supplier documents will load in the table, until the sum of their amounts reach the Total amount in the top part, starting with the oldest documents. If you click the button and there is no conversion rate between the cash account’s currency and none of the documents’ currencies of the selected Customer/Supplier no., a message appears. It notifies that you need to define the exchange rate for the currency of this cash account in the Currency rates (CM301000) window. |
| Element | Description |
|---|---|
| Up to due date | The last due date up to which you want to filter the documents. |
| Branch | The branch on which you want to select the documents. By default the cash account’s branch is selected. |
| Currency | The cash account’s currency. |
| Total amount | The total amount of the transaction selected in the main window. |
| Application amount | The total value of the selected documents. This amount is always less than or equal to the Total amount. |
| Unapplied balance | The difference between Total amount and Application amount. |
| Trans. descr. | The transaction description of the transaction selected in the main window. |
| Button | Description |
|---|---|
| Select all documents | Click this to select all documents until the sum of their amounts reach the Total amount in the top part. |
| Column | Description |
|---|---|
| Select document | Check box for selecting the documents. |
| Branch | The branch on which you want to select the documents. By default the cash account’s branch is selected. |
| Document type | The type of the document to which the payment selected in the left table can be applied to. |
| Ref. no. | The reference number of the Supplier ledger or Customer ledger document to which the payment selected in the left table can be applied to. |
| Date | The date when the Supplier ledger or Customer ledger document was created. |
| Post period | The financial period in which the document is posted. |
| Due date | The date when the Supplier ledger or Customer ledger document is due to be paid. |
| Amount in cash account currency | The document amount converted in the cash account’s currency. |
| Balance in cash account currency | The document balance converted in the cash account’s currency. |
| Customer/supplier | The customer or supplier number from the customer/supplier document. |
| Description | The description from the supplier or customer documents. |
| Amount | The document amount paid in the original currency. |
| Balance | The document balance amount in the original currency. |
| Currency | The currency of the document. |
| Customer order/supplier ref. | The document’s original customer order/supplier reference as assigned by the customer/supplier (for informational purposes). |
| External reference/buyer’s order no. | The external reference number/buyer’s order number of the transaction. |
| Customer name/supplier name | The customer name/supplier name associated with the document. |
| Location | The customer or supplier location. |
| Column | Description |
|---|---|
| Document type | The type of the document to which the payment selected in the left table can be applied. |
| Ref. no. | The reference number of the Supplier ledger or Customer ledger document to which the payment selected in the left table can be applied. |
| Customer order | The original reference number or ID assigned by the customer to the customer document (for informational purposes). |
| Customer name | The customer name associated with the document. |
| Customer | The parent or child customer associated with the document, by its customer number. The Parent-child customer relationship can be enabled in the Enable/disable functionalities (CS100000) window For more information about parent-child relationship, see: Manage parent-child relationships - overview |
| Invoice text | The text from the customer documents. |
| External ref. | The external reference number of the transaction. |
| Amount paid | The amount paid for this document. |
| Balance | The amount of the document after the specified amount was paid. |
| Date | The date when the Supplier ledger or Customer ledger document was created. |
| Currency | The currency of the document. |
| Balance write-off | The amount to be written off. |
| Branch | The branch on which the document is created. This column is only available if the Multi-Branch support check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Cash discount balance | The unused amount of the available discount, if any. |
| Cash discount taken | The amount of cash discount taken due to prompt payment. |
| Cross rate | A cross rate that you can optionally modify between the currency of the payment and currency of the original document. The column is hidden by default and available if the Multi-currency accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Post period | The financial period in which the document is posted. |
| With. tax | The amount of tax withheld (if withholding taxes are applicable). |
| With. tax balance | The difference between the amount of the tax to be withheld and the actual withheld amount (if any withholding taxes are applicable). |
| Write-off reason code | A reason code that defines an account and subaccount to be used for writing off balances. You must select a reason code if the balance write-off amount is non-zero. |
| Description | The description from the supplier documents. |
| Supplier ref. | The document’s original reference number as assigned by the supplier (for informational purposes). |
| Button | Description |
|---|---|
| Process | Processes the listed payments that you have selected. |
| Process all | Processes all payments on the list. |
| View resulting document | Navigates to the applicable form (which depends on the type of the document) so you can view the details of the selected payment. |
| Element | Description |
|---|---|
| Entry type | Required. The entry type that is reserved for unknown payments. |
| Cash account | The cash account used for unknown payments. |
| Start date | The date starting the range for which you want to view transactions. |
| End date | The date ending the range for which you want to view transactions. |
| Show reclassified | A check box that you select to display only payments reclassified during the specified date range. |
| Column | Description |
|---|---|
| Cash account | The cash account to which the payment was initially recorded. |
| Document ref. | The reference number of an external document, if applicable. |
| Trans. date | The payment document date. |
| Ref. no. | The identification number of the payment, as assigned by the system when the payment was saved. |
| Currency | The currency of the payment. |
| Reclassify cash account | The offset cash account to which the unknown payment was recorded. |
| Offset account | The offset account for the payment. |
| Offset subaccount | The offset subaccount for the payment. |
| Amount | The amount of the payment in the specified currency. |
| Trans. amount | The amount of the transaction. |
| Module | The workspace of origin, Supplier ledger or Customer ledger, for the payment. |
| Customer/supplier no. | The customer or supplier associated with the payment document. |
| Account name | The name of the customer or supplier. |
| Location ID | The location of the customer or supplier associated with the payment. |
| Payment method | The payment method used for the payment. |
| Account no. | The identifier of the payment method, if required by the type of payment method. |
| Description | A detailed description of the payment document. |
| Cleared | The cleared date of the payment entry. |
| Disb./receipt | The type of the payment. |
| Period | The period of the payment entry. |
| Button | Description |
|---|---|
| Create reconciliation | Creates a new reconciliation statement (that is, a list of documents that have not been reconciled with a bank statement). |
| Element | Description |
|---|---|
| Cash account | The cash account for which you want to view reconciliation statements. |
| Start date | The start date of the date range for which you want to display statements. |
| End date | The end date of the date range. |
| Column | Description |
|---|---|
| Status | The status of the reconciliation statement. |
| Cash account | The cash account for which the reconciliation was performed. |
| Description | A description of the cash account. |
| Ref. number | The reference number of the reconciliation statement, which is displayed as a link. You can click this link to view this statement in the Reconciliation statements (CA302000) window. |
| Reconciliation date | The date of the reconciliation statement. |
| Last reconciliation date | The date of the most recent reconciliation statement. |
| Beginning balance | The balance of the cash account before the reconciliation. |
| Reconciled receipts | The total amount on the receipts marked as reconciled. |
| Reconciled disb. | The total amount on the disbursements marked as reconciled. |
| Statement balance | The balance of the cash account, according to the bank statement. |
| Receipt count | The number of receipts included in the reconciliation statement. |
| Disb. count | The number of disbursements included in the reconciliation statement. |
| Currency | The currency of the cash account. |
| Button | Description |
|---|---|
| Release | Releases the reconciliation statement you are viewing. The status of the reconciliation statement changes to Closed. The documents with the Reconciled check box selected are included in the reconciliation statement. |
| Void | Voids the reconciliation statement, changing the status to Voided and clearing the Reconciled check boxes for all documents. If a document had the Cleared check box selected, it will still be selected. |
| Element | Description |
|---|---|
| Cash account | The cash account under reconciliation. |
| Currency | The currency of the cash account. |
| Ref. number | The identification number of the reconciliation statement, which the system assigns when you save the statement. |
| Status | The current status of the statement, which the system sets to one of the following values:
|
| Hold | A check box that you can clear to indicate that the reconciliation statement is no longer On hold (that is, you are done editing it) and can be released. |
| Last reconciliation date | The date of the most recent reconciliation for this cash account, if one exists. |
| Reconciliation date | The date when the reconciliation statement was released and closed. You can change the date up to the release. |
| Load documents up to | The latest date for documents to be loaded to the list. It allows you to temporary limit the number of displayed documents. |
| Element | Description |
|---|---|
| Beginning balance | The balance of the previous reconciliation statement. The system uses the reconciled balance of the previous statement to populate this field. |
| Reconciled receipts | The first column: The total amount of reconciled receipts on the statement. The second column: The number of cleared receipts. |
| Reconciled disb. | First column: The total amount of reconciled disbursements. Second column: The number of cleared disbursements. |
| Reconciled balance | The beginning balance of the statement plus the cleared receipts minus the cleared disbursements. |
| Statement balance | The balance of the current bank statement, which you enter manually for the current reconciliation statement. |
| Difference | The difference between the reconciled balance and the statement balance. |
| Voided transactions are skipped | A check box that indicates the value of the Skip voided transactions check box in the Cash management preferences (CA101000) window at the moment when a user saved this reconciliation statement for the first time. The element is displayed only if the value of the setting has been changed since the reconciliation statement was first saved. |
| Bank transactions are matched to batch payments | A check box that indicates the value of the Match bank transactions to batch payments check box of the cash account (in the Cash accounts (CA202000) window) at the moment when a user saved this reconciliation statement for the first time. The check box is displayed if the value of the setting has been changed since the reconciliation statement was first saved. |
| Document count | The number of receipts and disbursements included in the statement. |
| Button | Description |
|---|---|
| Toggle reconciled | Toggles the value of the Reconciled check box for all displayed records in the table. If the records are filtered, the check box value is toggled for only displayed records. The process takes the check box value from the first displayed row, inverts it, and changes the check box value to the new one for all displayed records. |
| Toggle cleared | Toggles the value of the Cleared check box for all records displayed in the table that have the Cleared check box available for editing. If the records are filtered, the check box value is toggled for only displayed records. The process takes the check box value from the first displayed row, inverts it, and changes the check box value to the new one for all displayed records. |
| Reconcile processed | Selects the Reconciled check boxes in the table for all released documents that were processed in the Process bank transactions (CA306000) window. |
| Create adjustment | Opens the Quick transaction dialog box so you can add an adjustment on the fly. |
| Column | Description |
|---|---|
| Reconciled | A check box that you select to indicate that the document is included in the reconciliation statement as a reconciled one. |
| Cleared | A check box that you select to indicate that the document was cleared with the reconciliation source, generally based on preliminary information. If you perform reconciliation of the bank account, a selected check box may indicate that the document was matched to the transaction on the imported bank statement. |
| Clear date | The date when the document was cleared. |
| Incoming payment | The amount of the document, if it is an incoming payment. |
| Disbursement | The amount of the document, if it is a disbursement. |
| Document ref. | The reference number of the corresponding external document. |
| Workspace | The workspace where the transaction or the document originated. |
| Trans. type | The type of transaction or document, or the entry type of the transaction. |
| Orig. doc. number | The ID of the document in the system. By clicking this number, you can navigate to the appropriate window (which depends on the type of the document) so you can view the details of the selected document. |
| Status | The status of the document in the system. |
| Doc. date | The date of the transaction or document. |
| Business account | The ID of the supplier or customer associated with the document. |
| Business account name | The name of the supplier or customer. |
| Description | A detailed description of the document. |
| Element | Description |
|---|---|
| Cash account | The cash account to be updated by this transaction. |
| Entry type | The user-defined type of cash transaction. |
| Doc. date | The date of the transaction. |
| Fin. period | The financial period to which the transaction is posted. |
| Currency | A read-only column that shows the currency of the cash account. |
| Document ref. | The reference number of the corresponding external document. |
| Amount | The amount of the transaction in the specified currency. |
| Description | A detailed description of the transaction. The field is filled by default with the description of selected entry type. |
| Status | The status of the transaction. |
| Cleared | A check box that you select to indicate that this transaction has been cleared. |
| Offset account | The general ledger account that is used by default as the offset account for transactions. The field is displayed if the entry type is set to Cash management. |
| Offset subaccount | The offset subaccount used with the account selected. |
| Save (button) | Creates a transaction with the specified details and closes the dialog box. |
| Cancel (button) | Clears the dialog box elements and closes it without saving the transaction. |
| Button | Description |
|---|---|
| Release | Releases the transactions you have selected in the table. |
| Release all | Releases all of the listed transactions. |
| Button | Description |
|---|---|
| View document | Navigates to either the Funds transfers (CA301000) window or the Transactions (CA304000) window, depending on the type of the transaction. |
| Column | Description |
|---|---|
| Transaction type | The type of the cash transaction, which is one of the following: Cash entry, Transfer in, Transfer out, or Expense entry. |
| Transaction number | The ID of the transaction, which the system assigns in accordance with the transaction numbering sequence. |
| Cash account | The cash account the transaction is associated with. |
| Currency | The currency of the transaction. |
| Amount | The amount of the transaction. |
| Description | A detailed description of the transaction. |
| Doc. date | The date when the transaction was performed. |
| Period | The financial period of the transaction. |
| VAT total | The total amount of tax paid in the document. |
| Button | Description |
|---|---|
| Release | Releases the selected transaction and creates a batch. |
| Actions | Provides the following menu commands:
|
| Inquiries | Provides the following menu command, which you can click for quick access to a pop-up window:
|
| Button | Description |
|---|---|
| Add task | Clicking this option will open the Task (CR306020) window where you can add and view the tasks connected with the selected transaction. |
| Add event | Clicking this option will open the Event (CR306030) window where you can add and view the events connected with the selected transaction. |
| Add email | Clicking this option will open the Send (CR306015) window where you can add and view the emails connected with the selected transaction. |
| Add activity | Clicking any of the options in this drop-down will open the Activity (CR306010) window where you can add and view the different types of activities connected with the selected transaction. |
| Column | Description |
|---|---|
| Type | The type of the activity. |
| Summary | The summary (description) of the activity. |
| Status | The status of the activity. The options are:
|
| Start date | The date when the activity was started. |
| Work group | The work group to which the activity belongs. |
| Time spent | The time spent on the activity. |
| Owner | The owner of the activity. |
| Created by | The user who has created the activity. |
| Released | Indicates if the activity has been released. |
| Element | Description |
|---|---|
| Trans. type | The type of cash transaction. You can create transactions of the Cash entry type. |
| Ref. no. | The unique identifier assigned to the cash transaction in accordance with the numbering series |
| Status | The status of the transaction, which is automatically assigned by the system:
|
| Hold | A check box that, if selected, indicates that the transaction is on hold, which means it may be edited but cannot be released. You can deselect the Hold check box if the transaction is balanced. If this check box is deselected, the transaction status changes to Balanced. |
| Trans. date | The date of the transaction. |
| Period | The financial period to which the transaction should be posted. |
| Description | A detailed description of the transaction. |
| Cash account | The cash account that is a source account for the transaction. |
| Currency | The currency of the cash account. |
| Exchange rate | The amount corresponding to the Currency field, and the name of the field is only visible if you hover over the field. By clicking the field, the Rate selection dialog box opens. See description below. |
| View base (button) | When you click View base the following happens:
Click View currency again to return to the original view. |
| Entry type | The user-defined transaction type. Select the appropriate type from the list of entry types defined for the selected cash account. |
| Disb./receipt | The basic type of the transaction:
|
| Document ref. | The external document reference number. |
| Owner | The user who created the cash transaction. |
| Reversing cash entries | The number of cash entries which are created by reversing the current cash entry. This field is visible when the cash transaction is reversed on the original entry. |
| Original cash entry | The field shows the ID of the cash entry that was reversed by the current cash entry. This field is visible when the cash transaction is reversed on the reversed entry. |
| Amount | The amount of the transaction. |
| VAT taxable total | The document total that is subjected to VAT. The VAT taxable amount will be displayed in this field only if the Include in VAT taxable total check box is selected for the applicable tax in the VAT (TX205000) window. If the check box is deselected, this field will be empty. If the document contains multiple transactions with different taxes applied and each of the applied taxes has this check box selected, the taxable amount calculated for each line of the document will be added to the VAT taxable total field of the document. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| VAT exempt total | The document total that is exempt from VAT. This total is calculated as the taxable amount for the VAT with the Include in VAT exempt total check box selected in the VAT (TX205000) window. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| VAT total | The total amount of VAT paid in the document. If a used VAT has been applied to the document, the used VAT amount is not included in the VAT total amount. You can view the used VAT details on the VAT details tab of the current window. |
| Control total | The control total of the transaction. A user enters this amount manually. This amount should be equal to the sum of amounts of all detail lines of the transaction. This field is available only if the Validate control totals on entry check box is selected in the Cash management preferences (CA101000) window. |
| VAT amount | The VAT amount to be paid for the document. A user enters this amount manually. This field is available only if the Validate VAT totals on entry check box is selected in the Cash management preferences (CA101000) window. To use the validation function, you must have the Net/gross entry mode check box selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Element | Description |
|---|---|
| Currency rate type ID | The currency rate type specified for the selected currency pair. |
| Effective date | The date on which the currency rate in this row becomes effective. |
| Currency unit equivalents | View the currency conversion. |
| OK (button) | Closes the dialog box. |
| Column | Description |
|---|---|
| Branch | The branch that created the transaction. |
| Item ID | The ID of the non-stock item specified as the transaction subject. |
| Description | The description provided for the item. |
| Quantity | The quantity of the item. |
| UoM | The unit of measure of the item. |
| Price | The unit price for the item. |
| Amount | The total amount for all units or items. |
| Offset account | The account to be updated by the transaction. By default, it is an offset account defined with the entry type selected for the cash account, but you can change this account. |
| Account description | A description of the account. |
| Offset subaccount | The corresponding subaccount to be used for the transaction. |
| Line no. | Used to count the number of lines in a cash transaction. |
| Project | The project with which the item is associated. Or, the non-project code, if the item is not intended for any project. The non-project code is specified in the Project accounting preferences (PM101000) ) window. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Project task | The particular task of the project with which this transaction is associated. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Non-invoicable | A check box that indicates (if selected) that this transaction is non-invoiceable in the project. This column is available only if the Project accounting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| VAT category | A list of taxes associated with a product or a service when it is purchased or sold. |
| Column | Description |
|---|---|
| VAT ID | The VAT that applies to the cash transaction. |
| VAT rate | The rate of the VAT. |
| Taxable amount | The taxable amount of the transaction. |
| VAT amount | The VAT amount calculated for the transaction. |
| Deductible VAT rate | The percent of deduction that applies to the VAT amount paid to the supplier for specific purchases. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Expense amount | The percentage that is deducted from the VAT amount paid to the supplier for specific purchases. This field is available only if the VAT reporting check box is selected and enabled in the Enable/disable functionalities (CS100000) window. |
| Pending VAT | A Pending VAT (sometimes called a suspended VAT) is applied to those documents whose VAT amounts should be recognized later than the document has been released. Once a document to the pending VAT is released, the system records its VAT amount to an intermediate account (such as the Pending VAT payable account or the Pending VAT claimable subaccount, where the VAT amount is kept until you initiate the process of recognizing the VAT). Suspended VAT information is not added to the VAT report until the taxes are recognised. |
| Include in VAT exempt total | A check box that indicates (if selected) that this value-added VAT has a zero rate, and is used to calculate a document subtotal that is actually exempt from VAT. The calculated amount will be displayed in the VAT exempt total field in the documents (such as invoices). Only available for VAT type VAT. |
| Statistical VAT | A check box that indicates (if selected) that the VAT on documents will be calculated only for statistical purposes. Or, will be reported only, but not actually paid. Only available for VAT type VAT. |
| Reverse VAT | A check box that indicates (if selected) that this is a reverse VAT. A reverse VAT is a type of VAT used in some countries of the European Union (EU). When this type of VAT is applied to a company that supplies goods or services to other EU countries, the liability of the reporting VAT is reversed and goes to the customer rather than to the supplier. Only available for VAT type VAT. |
| VAT type | The types of VAT:
|
| Element | Description |
|---|---|
| Batch no. | The number of the batch generated to implement the cash transaction. The number appears automatically after the transaction is released. Click the number to view the batch details. |
| Branch | The branch that initiated the transaction. |
| Cleared | A check box that indicates (if selected) that the transaction was cleared. |
| Clear date | The date when the transaction was cleared. |
| Element | Description |
|---|---|
| VAT zone | The VAT zone that applies to the transaction. |
| VAT calculation mode | The VAT calculation mode, which defines which amounts (VAT-inclusive or VAT-exclusive) should be entered in the detail lines of a document. One of the following options can be selected:
|
| Button | Description |
|---|---|
| Validate | Recalculates the balances for the accounts that you have selected. |
| Validate all | Recalculates the balances for all listed accounts. |
| Column | Description |
|---|---|
| Selected | A check box that you select to include the cash account for validation if you click Validate. |
| Cash account | The cash account. |
| Description | The description provided for the cash account. |
| Element | Description |
|---|---|
| Cash account | The cash account for which bank statements will be listed. |
| Start date | The start date of the date range. By default, the current business date is selected. |
| End date | The end date of the date range. By default, the current business date is selected. |
| From ref. no. | The first reference number of the reference number range. You can leave this field blank to view a broader range of data. |
| To ref. no. | The last reference number of the reference number range. You can leave this field blank to view a broader range of data. |
| Element | Description |
|---|---|
| Company | The company the report will cover. Select a company, or leave the field blank to view information about all branches. By default, the current company is selected. |
| Branch | The branch the report will cover. Select a branch, or leave the field blank to view information about all branches. |
| Ledger | The ledger for which you want to display data. You must select a ledger. By default, the actual ledger is selected. |
| From period | The first financial period of the period range the report will cover. You must select a period. By default, the current financial period is used. |
| To period | The last financial period of the period range the report will cover. You must select a period. By default, the current financial period is used. |
| Created by | The user who created a batch for whom you want to view information. |
| Last modified by | The user who last modified a batch for whom you want to view information. |
| Include unposted transactions | A check box that you select to include information about unposted transactions in the report. |
| Element | Description |
|---|---|
| Company | The company the report will cover. Select a company, or leave the field blank to view information about all branches. By default, the current company is selected. |
| Branch | The branch the report will cover. Select a branch, or leave the field blank to view information about all branches. |
| Ledger | The ledger for which you want to display data. You must select a ledger. By default, the actual ledger is selected. |
| From period | The first financial period of the period range the report will cover. You must select a period. By default, the current financial period is used. |
| To period | The last financial period of the period range the report will cover. You must select a period. By default, the current financial period is used. |
| Created by | The user who created a batch for whom you want to view information. |
| Last modified by | The user who last modified a batch for whom you want to view information. |
| Include unposted transactions | A check box that you select to include information about unposted transactions in the report. |
| Element | Description |
|---|---|
| From date | The start date of the date range the report will cover; a start date must be specified. By default, the first date of the current period is selected. |
| To date | The end date of the date range; an end date must be specified. By default, the current business date is selected. |
| Cash account | The cash account whose activities will be included in the report. Select an account to see its details. |
| Include not cleared | A check box you select to include transactions not cleared by the reconciliation. |
| Include not released | A check box you select to include transactions that were not released during the specified date range. |
| Element | Description |
|---|---|
| Company | The company the report will cover. Select a company, or leave the field blank to view information about all branches. By default, the current company is selected. |
| Branch | The branch the report will cover. Select a branch, or leave the field blank to view information about all branches. |
| From date | The start date of the date range for which you want to obtain information. By default, the first date of the current period is selected. |
| To date | The end date of the date range. By default, the current business date is selected. |
| Cash account | The cash account for which the report will display information. Leave the field empty to obtain information on all cash accounts. |
| Include not cleared | A check box you select to include transactions not cleared by the reconciliation. |
| Include not released | A check box you select to include transactions that were not released during the specified date range. |
| Hide details | A check box you select to display only summary lines for cash accounts and hide the details of the cash transactions. |
| Element | Description |
|---|---|
| Period | The financial period the report will cover. The list of available periods contains all periods, including closed ones, and a period must be specified. By default, the current financial period is used. |
| Element | Description |
|---|---|
| Document type | The document type, which can be Transfer out, Transfer in, Expense entry, Cash entry, or Deposit. Select a type, or leave the box blank to display documents of all types. |
| Ref. no. | The reference number of the specific document. Leave the field blank to display all the documents of the specified type (or of all types). |
| Period | The financial period the report will cover. All periods, including closed ones, are available for selection, and a period must be specified. By default, the current financial period is used. |
| Element | Description |
|---|---|
| Document type | The type of deposit you want to view. Select Cash deposit or Voided cash deposit. |
| Reference no. | The reference number of the deposit. |
| Element | Description |
|---|---|
| Deposit date | Select any date to view payments that were not deposited as of the date. By default, the current business date is selected. |
| Payment method | Select a payment method to view undeposited payments made by this payment method. Leave the field blank to view non-deposited payments made by all payment methods. |
| Element | Description |
|---|---|
| Original reference no. | The number of a cash entry for which you want to view reversed cash entry. You must select a cash entry. |
| Element | Description |
|---|---|
| From date | The start date of the date range. By default, the first date of the current period is selected. |
| To date | The end date of the date range. By default, the current business date is selected. |
| Cash account | The cash account for which reconciliations will be listed. Select a cash account, or leave the field blank to view a broader range of data. |
| Element | Description |
|---|---|
| From date | The start date of the date range. By default, the first date of the current period is selected. |
| To date | The end date of the date range. By default, the current business date is selected. |
| Cash account | The cash account for which reconciliations will be listed. Select a cash account, or leave the field blank to view a broader range of data. |
| Reference number | The reference number assigned to the reconciliation. You can leave this field blank to view a broader range of data. |
| Element | Description |
|---|---|
| Period | The financial period the report will cover. The list of available periods contains all periods, including closed ones, and a period must be specified. By default, the current financial period is used. |
| Cash account | The cash account for which the report will display information. Leave the field blank to obtain information on all cash accounts. |
| Element | Description |
|---|---|
| From period | The first financial period of the period range the report will cover. By default, the current financial period is used. |
| To period | The last financial period of the period range the report will cover. By default, the current financial period is used. |
| Element | Description |
|---|---|
| Cash account | The cash account whose documents will be included in the report. Leave the field blank to request information on all cash accounts. |
| Include transactions on hold | A check box you select to include transactions with the On hold status. |
| Element | Description |
|---|---|
| Cash account | The cash account whose documents will be included in the report. Leave the field blank to request information on all cash accounts. |
| Include transactions on hold | A check box you select to include transactions with the On hold status. |