The split rule fields
The following table lists the general fields that apply to all split rules and describes their functionality. Some of these fields are mandatory and are marked with an asterisk (*).
Field | Description |
---|---|
Fixed Amount | Defines a specific monetary value to allocate from the bank statement line or payment reconciliation journal line. This field is applicable only when Split By is set to Fixed Amount. |
Percentage | Defines a proportion of the original line amount to allocate. This field is applicable only when Split By is set to Percentage. |
Amount Type | Determines the sign of the split amount relative to the original line:
If the Split By is set to Charges, make sure to set this field when there is no debit/credit indicator in the bank statement. |
Search Text | Specifies the keyword or phrase used to identify the portion of the line to split. This field is used only when Split By is set to Search Text and works in conjunction with a Search Field Template. |
Search Method | Defines how the system matches the Search Text:
|
Search Field Template | Determines the fields in which the system searches for the Search Text. Multiple fields can be included in the template. If a match is found in any of the specified fields, the split rule is applied to the relevant bank statement or payment reconciliation lines. Used only when Split By is set to Search Text. |
Proprietary Charge Type | Assigns a specific charge type to the bank statement or payment reconciliation line when the split rule is applied, allowing precise categorization of fees and charges. For transactions with multiple charge entries where the currency or debit/credit indicators differ, you can create separate split rule lines and specify the relevant charge in the Proprietary Charge Type field along with the appropriate Amount Type. |
Account Type | In the Account Type field, specify to assign to the G/L account, customer, vendor, or employee. |
Account No. | In the Account No. field, specify the balance account to which the entry will be applied. |
Document Type | Defines the type of transaction, such as Payment, Invoice, Credit Memo, or Refund. |
Posting Description Template | The Posting Description Template defines the format for transaction descriptions, particularly when handling amount differences in bank reconciliation. These templates ensure consistency in transaction descriptions. Default templates are available, but you can also create a custom template. |
Department Code | Specifies the department related to the transaction for cost allocation and reporting. |
Project Code | Assigns the payment to a specific project for tracking expenses and revenues related to that project. |
Gen. Posting Type | Select the posting type for the VAT key code. For example, Sales. |
Gen. Bus. Posting Group | Categorizes the type of business (e.g., domestic, EU, export) involved in the transaction. |
Gen. Prod. Posting Group | Categorizes the type of product or service. |
VAT Bus. Posting Group | The VAT Business Posting Group determines how VAT is applied based on the business entity involved in a transaction. It allows for proper tax calculation and compliance by mapping captured amounts to specific VAT setups, overriding default values when necessary. |
VAT Prod. Posting Group | Here you can choose the VAT Prod. Posting Group to use for posting VAT for a payment. |