Process Bank Transactions

Form ID: (CA306000)

On this form, you can import transactions from multiple bank statements for a particular cash account, which corresponds to the account in a bank. Transactions imported from multiple statements are displayed in the table as one list. To view transactions for each imported statement, you use the Import Bank Transactions (CA306500) form, where you can select a cash account and the reference number of the imported statement.

You can then manually match or perform automatic matching of the transactions listed on the form to documents in the system over the same date range, resulting in the clearing of documents. You clear documents as a preliminary step before the actual reconciliation. You can also specify the details of a payment the system should create to match a transaction for which a match was not found.

Note:

Payments that the system creates during the processing of the matched transactions are not subject to approval, even if the process of approval is set up.

You can also navigate to this form from the Process Bank Transactions (CA501000) form, where you can auto-match transactions on a bank statement for any number of cash accounts to transactions in the system. The results of the matching are saved automatically and need to be processed on the current form.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.


Button	Description
Auto-Match	Initiates the process of matching transactions from the bank statement to documents in the system by using the settings specified in the Transaction Matching Settings dialog box (which opens when you click Match Settings on the form toolbar of this form) when the current cash account is selected on this form. If no settings were modified and saved previously in the Transaction Matching Settings dialog box when the current cash account was selected on this form, the system uses the default settings specified on the Bank Statements tab of the Cash Management Preferences (CA101000) form. If you have configured rules for document creation on the Bank Transaction Rules (CA204500) form, 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.
Process	Initiates the processing of matched transactions and transactions for which details of a new document were specified, resulting in clearing of the documents. The processing takes place on all lines, in spite of any filters set on table.
Match Settings	Opens the Transaction Matching Settings dialog box.
Upload File	Opens the Statement File Upload dialog box, which you can use to upload a new file or import the contents of an existing file from the file storage. The following formats are supported: OFX (Open Financial Exchange) QBO (QuickBooks Online) QFX (Quicken File eXchange) Note: Before you upload the file, make sure that the numbers of the bank accounts are associated with the appropriate cash accounts in the system. To do this, on the Cash Accounts (CA202000) form, for each cash account, specify the bank account number as the External Ref. Number. This button is displayed on the form toolbar if the cash account in the selected row is not mapped to a bank account in an active bank feed on the Bank Feeds (CA205500) form.
Retrieve Transactions	Retrieves transactions for one account or for all accounts of the bank feed, depending on the state of the Import Bank Statement for Single Cash Account check box on the Bank Statements tab of the Cash Management Preferences (CA101000) form. If the Mapping of Multiple Accounts for Bank Feeds feature is enabled on the Enable/Disable Features (CS100000) form, and the Map Multiple Bank Accounts to One Cash Account check box is selected for the bank feed on the Bank Feeds (CA205500) form, the system does the following before retrieving transactions: Checks whether a bank statement exists with a suitable Statement Start Date and Statement Period. If the dates of the transactions fall within the range of the Start Balance Date and End Balance Date of the bank statement, adds these transactions to the statement. If no statement with a suitable date is found, creates a new bank statement and adds the transactions to it. Thus, if Statement Start Date or Statement Period on the Bank Feeds (CA205500) form for a bank account is different from this setting of other bank accounts mapped to the same cash account, the system will create a separate bank statement for this bank account. Once the retrieval is complete, in the table in the left pane, the system displays an updated list of unmatched bank transactions for the selected account or a list of matched bank transactions if expense receipts were created for these bank transactions. This button is displayed instead of the Upload File button if on the Cash Accounts (CA202000) form, Bank Feed: PLAID or Bank Feed: MX is selected in the Statement Import Source box for the cash account of the selected row.

Table 1. Transaction Matching Settings Dialog BoxIn this dialog box, you can specify your preferences for matching and for relevance calculation; these preferences will be used solely for the selected cash account. By default, the system uses the settings specified on the Bank Statements tab of the Cash Management Preferences (CA101000) form.
Element	Description
Matching Settings Tab
Disbursement Matching Section
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. The maximum possible value that you can specify in this box is 365.
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 disbursement. The system considers the disbursement a matching one if the difference falls within the specified date range. The maximum possible value that you can specify in this box is 365.
Allow Matching to Credit Memo	A check box that indicates (if selected) that the system will automatically match disbursement bank transactions to Accounts Receivable credit memos by the reference number prior to matching them to Accounts Payable bills. If the check box is cleared (the default value), disbursement bank transactions are matched to Accounts Payable bills.
Receipt Matching Section
Days Before Bank Transaction Date	The maximum number of days allowed between the date of a 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. The maximum possible value that you can specify in this box is 365.
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. The maximum possible value that you can specify in this box is 365.
Invoice Matching Section
Match by Cash Account	A check box that indicates (if selected) that the system will match bank transactions to AR invoices with the same cash account or an empty account. That is, the system will select only invoices with the same cash account or an empty cash account, and the same branch. The check box is cleared by default.
Match by Discount and Due Date	A check box that indicates (if selected) that the system will match bank transactions to AR invoices by the discount and due date. The check box is cleared by default.
Days Before Discount Date	The number of days before the discount date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected. The maximum possible value that you can specify in this box is 365.
Days Before Due Date	The number of days before the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected. The maximum possible value that you can specify in this box is 365.
Days After Due Date	The number of days after the due date based on which invoices are selected for matching. This box becomes available if the Match by Discount and Due Date check box is selected. The maximum possible value that you can specify in this box is 365.
Other Matching Settings Section
Skip Voided Transactions During Matching	A check box that you select to make the system skip voided transactions during the reconciliation process.
Auto-Match Thresholds Section
Absolute Relevance Threshold	The absolute relevance threshold the system will use when finding the best match. The default (recommended) value is `75`.
Relative Relevance Threshold	The relative relevance threshold the system will use when finding the best match. The default (recommended) value is `20`.
Relevance Calculation Tab
Payment and Expense Receipt Relevance Section
Ref. Nbr. Weight	The relative weight (as a percentage) of the evaluated difference between the reference numbers of the bank transaction and the cash transaction, payment, or expense receipt.
Consider Empty Ref. Nbr. as Matching	A check box that specifies (if selected) that a bank transaction with an empty reference number is considered as matching a cash transaction, payment, or expense receipt 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 (as a percentage) of the evaluated difference between the dates of the bank transaction and of the cash transaction, payment, or expense receipt.
Doc. Payee Weight	The relative weight (as a percentage) of the evaluated difference between the names of the customer (or vendor) on the bank transaction and on the cash transaction, payment, or expense receipt.
Amount Weight	The relative weight (as a percentage) of the evaluated difference between the amount of the bank transaction and of the cash transaction, payment, or expense receipt. This box appears in the dialog box for cash accounts that have the Use for Corporate Cards check box selected on the Cash Accounts (CA202000) form.
Amount Difference Threshold (%)	The relative threshold (as a percentage) of the difference between amounts the system will use to find the best match. This box appears in the dialog box for cash accounts that have the Use for Corporate Cards check box selected on the Cash Accounts (CA202000) form.
Payment Clearing Average Delay	The average number of days for a payment to be cleared with the bank.
Estimated Deviation (Days)	The number of days before and after the average delay date during which 50% of payments are generally cleared.
Invoice Relevance Section
Invoice Nbr. Weight	The relative weight (as a percentage) of the evaluated difference between the reference numbers of the bank transaction and of the invoice.
Doc. Date Weight	The relative weight (as a percentage) of the evaluated difference between the dates of the bank transaction and of the invoice.
Doc. Payee Weight	The relative weight (as a percentage) of the evaluated difference between the names of the customer or vendor in the bank transaction and in the invoice.
Average Payment Delay	The average number of days for an invoice to be paid.
Estimated Deviation (Days)	The number of days before and after the average delay date during which 50% of invoices are generally paid.
This dialog box has the following buttons.
Reset to Default	Resets the settings that have been specified in this dialog box when the current cash account is selected on this form to the default cash management settings, which are defined on the Bank Statements tab of the Cash Management Preferences (CA101000) form.
Save & Close	Saves the matching settings that have been specified in this dialog box, and closes the dialog box.

Table 2. Statement File Upload Dialog BoxIn this dialog box, you can select a file to upload or import transactions from an existing file.
Element	Description
Upload file	An option that you select if you want to upload a file that contains transactions.
Link to existing file	An option that you select if you want to import an existing file with transactions.
Choose File	The box that you can use to select a file for uploading. The box is displayed if the Upload file option is selected.
Existing File	An external link to the file that contains transactions you want to import. The box is displayed if the Link to existing file option is selected.
Comment	The brief description of the file.
This dialog box has the following buttons.
Upload	Uploads the selected file to the file storage and imports the file content to the form.
Cancel	Closes the dialog box without uploading the selected file.

Selection Area

You use this area to select a particular cash account to match imported transactions to transactions available in the system.


Element	Description
Cash Account	The cash account specified on the bank statement. When you select a cash account on this form, the system will use for matching any settings that have been specified (by any user) in the Transaction Matching Settings dialog box while this cash account was selected on the current form. You can use the dialog box to change these settings or to cause the system to revert to the default system settings instead of those that have been specified previously with the cash account selected.

Left Pane: Bank Transactions To Match Table

This table contains the transactions that have been imported from multiple bank statements by using this form and the Import Bank Transactions (CA306500) form. You can select a transaction here and view matching transactions or specify the details of a new document in the tabs of the right pane.

Note:

On the bottom of the table, you can see a brief description of the status of the selected transaction.

The system sorts transactions (possible matches) by the match relevance value calculated for the available transactions (on the Match to Payments, Match to Invoices, and Match to Expense Receipts tabs) by using either the criteria you have specified in the Transaction Matching Settings dialog box on the current form or the default criteria on the Bank Statements tab of the Cash Management Preferences (CA101000) form.

For transactions with no match, you can create a new document of the type, which is determined by the part of the system where the transaction originated and the type of transaction (receipt or disbursement), on the Create Payment tab. To create a new document or a transaction for a bank transaction with no match, select the Create check box and specify the required information. For cash management transactions, you can create a document with an unrecognized payment type.

Table 3. Table Toolbar
The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Unmatch	Clears all of the following: The check box in the Matched column of this pane for the selected row Any selected matches on the Match to Payments, Match to Invoices, and Match to Expense Receipts tabs The Create check box (if selected) on the Create Payment tab
Unmatch All	Clears all of the following: All check boxes in the Matched column of this pane Any selected matches on the Match to Payments, Match to Invoices, and Match to Expense Receipts tabs The Create check box (if it is selected) on the Create Payment tab This action also affects the rows that the system is not displaying in the table because a filter has been applied on any of the table columns.
Hide	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 form toolbar). You can then clear the Processed and Hidden check boxes for the transaction by clicking Unhide Transaction on the Import Bank Transactions (CA306500) form to be able to view and process the transaction again.

Table 4. Table Columns
Column	Description
Matched	A check box that indicates (if selected) to the system that this bank transaction is ready to be processed. Namely, the transaction has been matched to a document in the system, or details of a new document (to match this transaction) were specified.
Ext. Ref. Nbr.	The external reference number of the transaction. This column is required if the Require Document Ref. Nbr. on Entry check box is selected on the Cash Management Preferences (CA101000) form. If you are processing bills with or without charges and invoices with charges and this column is empty for a transaction on the Import Bank Transactions (CA306500) form, the system will not process the document on the current form and will display an error message.
Tran. Date	The bank transaction date. For bank transactions received from the bank feed, this is the Posted Date (the date when the transaction affected the account balance, but not the date when the transaction occurred). If you match the bank transaction to an unreleased payment document, the system will set this date as the document date in case the payment method specified for the document has the Set Payment Date to Bank Transaction Date check box selected in the Summary area of the Payment Methods (CA204000) form. The system automatically updates the date of the payment document to match this date when processing the bank transaction.
Receipt	The amount of the receipt.
Disbursement	The amount of the disbursement.
Card Number	The card number the transaction has been paid with.
Tran. Desc.	The description of the transaction.
Bank Feed Account	The description of the bank feed account from which the transaction was received. This value consists of the Account Name and Account Mask values specified for the bank feed in the respective columns of the table on the Bank Feeds (CA205500) form. This column is filled in for a transaction only if the Map Multiple Bank Accounts to One Cash Account check box is selected for the bank feed account on the Bank Feeds (CA205500) form. The column is populated automatically by the system and you cannot override this value. This column appears on the form if the Mapping of Multiple Accounts for Bank Feeds feature is enabled on the Enable/Disable Features (CS100000) form.

Right Pane: Match to Payments Tab

The tab provides a list of payments that the system has evaluated as matching the transaction selected in the table on the left pane. If you have manually selected a particular bank transaction in the table, you will see the payments that have the same amount and are matched by the date range specified in one of the following places:

The Transaction Matching Settings dialog box with this cash account selected on the current form
The Bank Statements tab of the Cash Management Preferences (CA101000) form if no user has specified and saved matching settings in the dialog box with this cash account selected on the current form.

For the matching document you choose among the listed ones, you select the check box in the Matched column.

If you have invoked automatic matching and the system has found more than one matching document, you need to manually specify the match.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.


Button	Description
Match to Multiple Payments	A check box that you select if you need to match one bank transaction to multiple documents. This check box is cleared by default. When you select this check box, the system fills in the table in the Detail area of the tab with the outstanding payments that you can match to the selected bank transaction. These payments include the ones whose amounts are less than or equal to the bank transaction amount and that are made in the same direction as the transaction (for example, a receipt transaction can be matched to an AR payment, a refund, and a CA receipt transaction).
Match to Receipts and Disbursements	A check box that you select if you need to match a bank transaction to receipts and disbursements. The check box is only available if the Match to Multiple Payments check box is selected, and it is cleared by default. When you select this check box, the system adds the available receipts and disbursements to the list of the documents that you can match to the bank transaction and displays them in the Detail area of the tab. With both the Match to Multiple Payments and Match to Receipts and Disbursements check boxes selected, documents of any amounts and directions are available for matching. The system displays a plus sign for the documents with the same direction as the bank transaction and the minus sign (–) for the documents with the opposite direction.
Transaction Amount	The bank transaction amount.
Matched Amount	The amount of the selected matched documents. The matching is successful only when the sum of the matched document amounts (Matched Amount) equals the amount of the bank statement transaction (Transaction Amount). Otherwise, the system cannot process the bank transaction.
Unmatched Amount	The amount of the bank transaction that has not been matched yet—that is, the amount that you are have not yet matched to the bank transaction.

Table 5. Table Columns In the table, you can view detailed information about the documents matching the transaction selected in the left table.
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 100 and is calculated automatically for the selected transaction on the bank statement and this document.
Orig. Doc. Number	The identifier of the document, as assigned by the corresponding numbering sequence.
Doc. Date	The date of the document. If the document is not released and the payment method specified for the document has the Set Payment Date to Bank Transaction Date check box selected in the Summary area of the Payment Methods (CA204000) form, the system automatically updates the date of the payment document to match the date of the bank transaction when processing the bank transaction.
Document Ref.	The number of the corresponding external document, if one exists.
Module	The part of the system in which the document was entered.
Tran. Type	The type of a document, which is related to cash transactions. The type can be one of the following: From AP module: Refund, prepayment, or payment From AR module: Payment or prepayment From CA module: Cash entry, transfer, or transfer expense
Description	A detailed description of the document.
Amount	The document amount or transaction amount if it is a receipt. A negative value indicates that the amount is a disbursement.
Business Account	The vendor or customer associated with the document, by its account identifier.
Business Account Name	The name of the vendor or customer associated with the document.

Right Pane: Match to Invoices Tab

The tab provides a list of invoices, credit memos, and debit adjustments that the system has evaluated as matching the transaction selected in the table on the left pane. If you have manually selected a particular bank transaction in the table, you will see the invoices and debit adjustments that have the same amount and are matched by the date range specified in one of the following places:

The Transaction Matching Settings dialog box with this cash account selected on the current form
The Bank Statements tab of the Cash Management Preferences (CA101000) form if no user has specified and saved matching settings in the dialog box with this cash account selected on the current form.

If the Enable Early Payments check box is cleared on the Accounts Payable Preferences (AP101000) form, the system lists only bills that meet the following selection criteria:

The date of a bill is earlier than or the same as the date specified in the Tran. Date column in the left pane of the current form.
The financial period of a bill is earlier than or the same as the financial period of the transaction specified in the Ext. Ref. Nbr. column in the left pane of the current form.

If the Use Credit Terms in Debit Adjustments check box is selected on the Accounts Payable Preferences (AP101000) form and debit adjustments with cash discounts have been created in the system, these debit adjustments are shown with cash discounts on the current tab.

Tip:

You can match debit adjustments to Disbursement bank transactions. This is required if the company pays the vendor's bills and debit adjustments at the same time and the total amount of the bills exceeds the total amount of the debit adjustments.

If the Use Credit Terms in Credit Memos check box is selected on the Accounts Receivable Preferences (AR101000) form and credit memos with cash discounts have been created in the system, these credit memos are shown with cash discounts on the current tab.

Tip:

You can match credit memos to Receipt bank transactions. This is required if the company receives payments for invoices and credit memos together and the total amount of the invoices exceeds the total amount of the credit memos.

If you choose a matching document among the listed ones, you select the check box in the Matched column.

Note:

If an invoice or bill is paid by line, it appears on the current tab as one row and is matched to a bank transaction as a whole document. The invoice or bill is paid by line if the Pay by Line check box is selected for it on the Invoices and Memos (AR301000) or Bills and Adjustments (AP301000) form, respectively.

If you have invoked automatic matching and the system has found more than one matching document, you need to manually specify the match.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 6. Summary Area
Button	Description
Match to Multiple Documents	A check box you select if you need to match one bank transaction to multiple AR documents (invoices and credit memos) or AP documents (bills or debit adjustments). This check box is cleared by default. When you select this check box, the system fills in the table of the tab with outstanding AR and AP documents that you can match to the selected bank transaction. These invoices and credit memos, which belong to the same customer or bills and debit adjustments, which belong to the same vendor, include the ones whose amounts are less than or equal to the bank transaction amount and that are made in the same direction as the transaction. However, one transaction can be matched to multiple AR and AP documents only from the same customer or vendor. When you select the Matched check box in the row of an AR or AP document in the list, the system refreshes the table with the AR documents for the same customer or AP documents for the same vendor, and you cannot select documents of any other customer or vendor for matching.
Business Account	The business account identifier of the customer or vendor referred to in the selected document. If the Match to Multiple Documents check box is selected and a customer is selected in this box, the bank transaction can be matched to multiple invoices and credit memos of this customer. If the Match to Multiple Documents check box is selected and a vendor is selected in this box, the bank transaction can be matched to multiple bills and debit adjustments of this vendor.
Location	The business account location associated with the document.
Payment Method	The payment method associated with the document.
Charge Type	The entry type with which a cash transaction will be created for the charge. If the selected charge type has a different direction from the bank transaction direction (receipt or disbursement), invoices with any amount will be selected. This box is displayed if the Match to Multiple Documents check box is selected.
Card/Account Nbr.	The account number or card number of the document.
Transaction Amount	The bank transaction amount.
Matched Amount	The amount of the selected matched invoices. The matching is successful only when the sum of the matched invoice amounts (Matched Amount) equals the amount of the bank statement transaction (Transaction Amount). Otherwise, the system cannot process the bank transaction.
Charge Amount	The amount of the charge, including tax. This box is displayed if the Match to Multiple Documents check box is selected. This box becomes available for editing when you fill in the Charge Type box.
Charge Tax Amount	The amount of tax in the charge amount. The system calculates this value based on the tax zone specified for the entry type in the cash account settings and the default tax category of the tax zone. This box is displayed if the Match to Multiple Documents check box is selected. This box is read-only.
Unmatched Amount	The amount of the bank transaction that has not been matched yet—that is, the amount that you are yet to match to the bank transaction.

Table 7. Table Columns In the table, you can view detailed information about the documents matching the transaction selected in the left table.
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 100 and is calculated automatically for the selected transaction on the bank statement and this document.
Module	The part of the system in which the document was entered.
Type	The type of a document, which is related to cash transactions. The type can be one of the following: From AP module: Bill From AR module: Invoice
Reference Nbr.	The reference number of the document. Click the link to view the details of the document.
Ext. Ref. Nbr.	The external number of the document.
Doc. Date	The date of the document.
Amount	The document amount.
Business Account	The vendor or customer associated with the document, by its account identifier.
Business Account Name	The name of the vendor or customer associated with the document.
Description	A detailed description of the document.
Branch	The branch with which the document is associated.

Right Pane: Match to Expense Receipts Tab

The tab provides a list of expense receipts that the system has evaluated as matching the transaction selected in the table on the left pane. If you have manually selected a particular bank transaction in the table, you will see the expense receipts that have the same amount and are matched by the date range specified in one of the following places:

The Transaction Matching Settings dialog box of the current form with this cash account selected on current form
The Bank Statements tab of the Cash Management Preferences (CA101000) form if no user has specified and saved matching settings in the dialog box with this cash account selected on the form.

For the matching expense receipt you choose among the listed ones, you select the check box in the Matched column.

If you have invoked automatic matching and the system has found more than one matching expense receipt, you need to manually specify the match.

The tab is shown on the form if the selected cash account has the Use for Corporate Cards check box selected on the Cash Accounts (CA202000) form.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 8. Table Columns In the table, you can view detailed information about the expense receipts matching the transaction selected in the left table.
Column	Description
Matched	A check box that you select to match the expense receipt 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 100 and is calculated automatically for the selected transaction on the bank statement and this expense receipt.
Receipt Number	The identifier of the expense receipt, as assigned by the corresponding numbering sequence.
Description	The description of the expense receipt.
Doc. Date	The date of the transaction or expense receipt.
Amount in Claim Currency	The expense receipt amount in the claim currency.
Claim Currency	The claim currency.
Amount Difference	The difference between the amount of the bank transaction and the amount in the claim currency.
Card Number	The number of the corporate card the expense receipt has been paid with.
Employee	The employee associated with the expense receipt.
Employee Name	The name of the employee associated with the expense receipt.
Ref. Nbr.	The reference number of the expense receipt.
Paid With	The way the expense receipt has been paid. One of the following options is available: Personal Account: The company's expenses that are paid with a personal card and will be reimbursed by the company Corporate Card, Company Expense: The company's expenses that are paid with a corporate card Corporate Card, Personal Expense: The employee's personal expenses that are paid with a corporate card

Right Pane: Create Payment Tab

By using this tab, for transactions with no match, you can create a new document of a type that is determined by the part of the system where the transaction originated and the type of transaction (receipt or disbursement). To create a new document or transaction for a bank transaction with no match, select the Create check box and specify the required settings. For cash management transactions, you can create a document with an unrecognized payment type or split the transaction amount into multiple documents by adding lines in the table and specifying different offset accounts and subaccounts (if applicable) for each line.

Note:

You can attach a file to the new document or the transaction by dragging the file to the Create Payment tab area or clicking Attach File > Add file... on the tab to open the Upload File dialog box.

Also, on this tab, you can apply AP and AR payments that you want to create to match the bank transactions to the documents available in the system. After you have specified the information about the new payment and have selected in the table the documents to apply, click Save on the form toolbar. The payment will be created and applied when you click Process on the form toolbar.

Table 9. Payment Creation Area
Column	Description
Create	A check box that indicates (if selected) that a new payment will be created for the selected bank transactions. Clear the check box to delete any information you have specified for the new document. If a Receipt bank transaction is selected in the left pane, you can link it to a debit adjustment with a cash discount. When you are processing records on this form, the system will create an AP refund and apply it to the debit adjustment. If the application date is within the cash discount period of the debit adjustment, the cash discount will be applied. Tip: If you have selected this check box and have not entered any cash transaction details, you can click Create Rule to create a rule to be applied to the new transaction and to other transactions to which the rule can be applied. If a Disbursement bank transaction is selected in the left pane, you can link it to a credit memo with a cash discount. When you are processing records on this form, the system will create an AR refund and apply it to the credit memo. If the application date is within the cash discount period of the credit memo, the cash discount will be applied.
Applied Rule	The identifier of the rule applied to create a new document. You configure rules by using the Bank Transaction Rules (CA204500) form. Rules are configured and applied for only documents originating on cash management forms.
Clear Rule	A button you click to clear the applied rule and the settings the system has entered by using the applied rule.
Create Rule	A button you click to open the Create Rule dialog box, where you enter the identifier of the new rule. You then click Create to navigate to the Bank Transaction Rules (CA204500) form, where you can view and modify the details of the rule and save it for future use.
Module	The part of the system where the document originated. Available options are AP (accounts payable), AR (accounts receivable), and CA (cash management).
Entry Type ID	The identifier of the entry type that is used as a template for a new cash transaction to be created to match the selected bank transaction. The box is displayed if the CA option is selected in the Module box.
Tran. Desc.	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).
Payment Date	The date on which you want to create a payment in the system. The default value is the bank transaction date specified in the Tran. Date column in the left pane, but you can override this value. The payment date can be earlier than the transaction date, but not later. You can enter only a date that corresponds to a financial period that has been generated on the Master Financial Calendar (GL201000) form. If the date that you enter belongs to a financial period that has not yet been generated in the system—for example, for a date in the distant future or past—the system will display an error message, and you will not be able to save the document.
Fin. Period	The financial period of the new payment. The default value is the period of the bank transaction, but you can override this value.
Business Account	The vendor or customer associated with the document, by its business account ID. This box is displayed if the AP or AR option is selected in the Module box. The list of values may be restricted based on the current branch. You can select a customer or vendor whose settings permit the use of the branch—that is, a customer or vendor for which the following settings are specified: For a customer, the Restrict Visibility To box on the Financial tab of the Customers (AR303000) form is empty or contains the branch to which you are signed in, the company that contains this branch, or the company group that contains the branch. For a vendor, the Restrict Visibility To box on the Financial tab of the Vendors (AP303000) form is empty or contains the branch to which you are signed in, the company that contains this branch, or the company group that contains the branch.
Location	The location of the vendor or customer. This box is displayed if the AP or AR option is selected in the Module box.
Payment Method	The payment method used by a customer or vendor for the document. The box is displayed if the AP or AR option is selected in the Module box.
Invoice Nbr.	The reference number of the document (invoice or bill) generated to match a payment. This box is displayed if the AP or the AR option is selected in the Module box.
Amount	The amount of the document calculated by the sum of the Detail Total and exclusive Tax Total amounts. This box is displayed if the CA option is selected in the Module box.
Detail Total	The total amount of the document lines. This box is displayed if the CA option is selected in the Module box.
Tax Total	The amount of the tax calculated for the document. This box is displayed if the CA option is selected in the Module box. If you click this link, the system opens the Tax Details dialog box.
Discrepancy	The balance of the transaction for which you can add the documents. The amount is calculated as `Transaction Amount–Amount`. This box is displayed if the CA option is selected in the Module box.
Total Amount	The total amount of the document. This box is displayed if the AP or AR option is selected in the Module box.
Application Amount	The amount of the application for this payment. This box is displayed if the AP orAR option is selected in the Module box.
Unapplied Balance	The unapplied balance of the document. This box is displayed if the AP or AR option is selected in the Module box.
Write-Off Amount	The total amount of write-offs specified for documents to be applied. This box is displayed if the AR option is selected in the Module box.

Table 10. Tax Details Dialog BoxThis dialog box is opened if you click the link in the Tax Total box on the current tab. In this dialog box, you can specify a tax zone and tax calculation mode for the taxes to be applied to the document line. If you specify values in the boxes, the taxes associated with the selected tax zone appear in the table. For taxes that have been applied automatically, you can change their settings in the table of the dialog box, as well as add a new tax or remove an automatically added tax.
Element	Description
Summary Section
Tax Zone	The tax zone specified for the selected cash account and entry type on the Entry Types tab of the Cash Accounts (CA202000) form. You can override this value.
Tax Calculation Mode	The tax calculation mode specified for the selected cash account and entry type on the Entry Types tab of the Cash Accounts (CA202000) form. You can override this value. Note: If the Gross settings is selected in this box, you cannot override the tax amount in the Tax Amount column. This box appears in the dialog box if the Net/Gross Entry mode feature has been enabled on the Enable/Disable Features (CS100000) form.
The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Tax ID	The tax ID of the tax associated with the selected tax zone.
Tax Rate	The tax rate of the tax associated with the selected tax zone.
Taxable Amount	The taxable amount of the line.
Tax Amount	The amount of the tax calculated automatically by the system based on the tax ID or specified manually by the user. Note: If the Gross settings is selected in the Tax Calculation Mode box in the Summary section, you cannot override the tax amount in the current box.
Deductible Tax Rate	The percent of deduction that applies to the tax amount paid to the vendor for specific purchases.
Expense Amount	The non-deductible tax amount that is recorded as an expense.
This dialog box has the following button.
OK	Saves the settings applied in the dialog box and closes the dialog box.

Table 11. Bank Transaction Rules Dialog BoxIn this dialog box, you create a rule to be used to create new payments for imported bank transactions for which matching documents were not found in the system.
Element	Description
Summary Area
Rule 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 on the Process Bank Transactions form.
Matching Criteria Tab
General Section
Debit/Credit	The type of a transaction: Disbursement or Receipt. By default, this value is copied from the bank transaction type.
Cash Account	The identifier of the cash account, which corresponds to the account in the bank. By default, this value is copied from the bank transaction.
Currency	The currency of a transaction. The box is disabled and displays the currency of the selected cash account.
Tran. Code	The code of the transaction.
Description Section
Tran. Description	The description of the transaction. By default, this value is copied from the description of the selected bank transaction specified in the Tran. Desc. column in the left pane.
Match Case	A check box that indicates (if selected) that the font case of a transaction description should match the font case in the Tran. Description box.
*Use Wildcards (, ?)**	A check box that indicates (if selected) that you can use wildcard characters—`*` or `?`—in the Tran. Description box.
Payee/Payer Section
Payee/Payer	The payee or payer of a bank transaction, which will be used as a criterion so that a cash transaction with a certain entry type can be created for bank transaction.
*Use Wildcards (, ?)**	A check box that indicates (if selected) that you can use wildcard characters—`*` or `?`—in the Payee/Payer box.
Amount Section
Matching Mode	The mode of the transaction amount matching. The following options are available: None: The amount criterion is not used. Equal: The transaction amount must be equal to the number specified in the Amount box. Between: The transaction amount must be in the range of the numbers specified in the Min. Amount and Max. Amount boxes.
Amount	The number used to compare a transaction amount. This box appears on the form if Equal has been selected in the Matching Mode box.
Min. Amount	The minimum number used to compare a transaction amount. This box appears on the form if Between has been selected in the Matching Mode box.
Max. Amount	The maximum number used to compare a transaction amount. This box appears on the form if Between has been selected in the Matching Mode box.
Output Tab
Action	The action that is performed by the system when the rule is applied. The following options are available: Create Document: The system creates a new document to match the imported bank transaction (that meets the specified criteria) for which a match was not found in the system (by using the entry type specified in the Resulting Entry Type box). Hide Transaction: The system hides the imported bank transaction (that meets the specified criteria) from the list and marks it as processed. Note: You can then clear the Processed and Hidden check boxes for the transaction by clicking Unhide Transaction on the Import Bank Transactions (CA306500) form to be able to view and process the transaction again.
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) form. The box is displayed if the Create Document option is selected in the Action box.
This dialog box has the following buttons.
Apply to All	Saves the created rule, searches for transactions to which the rule can be applied, and applies the rule to all of them and to the selected transaction.
Apply	Saves the created rule, applies it to the selected transaction, and closes the Bank Transaction Rules dialog box.

Table 12. Table for Documents that Originated on Cash Management Forms
In this table, you can add the documents to which you want to split the transaction amount. The splitting is not available for documents that originated on accounts receivable and accounts payable forms.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.
Column	Description
Branch	The branch that created the document.
Description	The description of the document. The bank transaction description is displayed by default.
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 box, but you can change this account. The box 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 box, but you can change this account.
Description	A description of the account.
Offset Subaccount	The corresponding subaccount to be used for the document.
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 on the Projects Preferences (PM101000) form. The box is available if the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) form and the CA check box is selected in the Visibility Settings section on the General tab of the Projects Preferences (PM101000) form. Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
Project Task	The particular task of the project with which this document is associated. The column is available if the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) form and the CA check box is selected in the Visibility Settings section on the General tab of the Projects Preferences (PM101000) form. Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
Cost Code	The cost code with which this document is associated. The column is available if the Cost Code feature is enabled on the Enable/Disable Features (CS100000) form and the CA check box is selected in the Visibility Settings section on the General tab of the Projects Preferences (PM101000) form. Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.
Tax Category	The tax category of the document. The system inserts a default category automatically when a line is added, although you can override the default category. The system selects the tax category as follows: From the corresponding Tax Zone if no item is selected for the line and the selected offset account does not have a tax category From the Offset Account if no item is selected for the line and the offset account has a tax category From the item if it is selected for the line and has a tax category specified in the Tax Category box on the General tab of the Non-Stock Items (IN202000) form

Table 13. Table Toolbar for Documents that Originated on Accounts Payable or Accounts Receivable Forms
In this table, you can add the documents to which you want to apply the new payment. Application is not available for documents that originated on cash management forms.

The table toolbar includes standard buttons and buttons that are specific to this table. For the list of standard buttons, see Table Toolbar. The table-specific buttons are listed below.
Button	Description
Load Documents	If AP is selected in the Module box, loads the vendor documents for which you want to apply the new payment, starting with the oldest documents. If the Enable Early Payments check box is cleared on the Accounts Payable Preferences (AP101000) form, the system loads only bills that meet the following selection criteria: The date of a bill is earlier than or the same as the date specified in the Payment Date box in the Payment Creation area of the current tab The financial period of a bill is earlier than or the same as the financial period selected in the Fin. Period box in the Payment Creation area of the current tab If AR is selected in the Module box, opens the Load Options dialog box, where you can specify the criteria for adding a list of open documents of the customer selected in the Business Account box.

Table 14. Load Options Dialog BoxYou use this dialog box, which opens when you click Load Documents on the table toolbar, to add to the list of the customer's open documents the documents that meet the criteria you specify.
Element	Description
Company/Branch	The company and branch for which the documents are to be displayed.
From Date	The earliest date for the documents to be displayed.
To Date	The latest date for the documents to be displayed. The current business date is selected by default.
From Ref. Nbr.	The document reference number to start with.
To Ref. Nbr.	The document reference number to end with.
Max. Number of Rows	The maximum number of records to be selected from the database. The default value is 100. That is, the system selects 100 records from the database that match the specified criteria, applies additional filters, if needed, and displays the resulting list of records.
Sort Order	A group in which you can define in which order the listed documents should be displayed. You can select one of the following options: Due Date, Reference Nbr.: The system loads the list of the documents sorted in ascending order first by due date and then by reference number. This option is selected by default. Doc. Date, Reference Nbr.: The system loads the list of the documents sorted in ascending order first by document date and then by reference number. Reference Nbr.: The system loads the list of the documents sorted in ascending order by reference number.
The dialog box provides the following buttons.
Load	Loads the customer's documents that meet the specified criteria to the table and closes the dialog box. If the table already contains any documents, they will be kept in the table and new ones will be loaded according to the selected criteria.
Reload	Removes the previously loaded documents from the table, loads documents to the table according to the selected criteria, and closes the dialog box.
Cancel	Closes the dialog box without loading any documents.

Table 15. Table Columns for Documents that Originated on Accounts Payable or Accounts Receivable Forms
Column	Description
Document Type	The type of the document to which the payment selected in the upper table can be applied.
Reference Nbr.	The reference number of the AP or AR document to which the payment selected in the upper table can be applied.
Customer	The parent or child customer associated with the document, by its business account ID. This box is displayed if the AR option is selected in the Module box.
Amount Paid	The amount that will be paid for this document. This amount is displayed in the currency of the payment to be created.
Balance	The amount of the document after the amount specified in the Amount Paid column is paid.
Balance Write-Off	The amount to be written off. The box is displayed if the AR option is selected in the Module box.
Write-Off Reason Code	The 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. This box is displayed if the AR option is selected in the Module box.
Date	The date when the AP or AR document was created.
Currency	The currency of the document to be paid.
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 Multicurrency Accounting feature is enabled on the Enable/Disable Features (CS100000) form.
Invoice Amount	The original invoice amount of the document whose identifier is specified in the Reference Nbr. column. Note: This column is hidden by default. You can display this column in the table by using the Column Configuration dialog box. For details, see Table Layout: Process Activity.