Manage bank statements
/visma-net-erp/help/cash-management/manage-bank-statements
section
2026-02-19T17:09:06+01:00
# Manage bank statements
Click the links below to learn more about a topic you are interested in. Use the breadcrumb links in the upper left corner to see your location, navigate backwards or go to the starting point.
Managing bank statements - overview
/visma-net-erp/help/cash-management/manage-bank-statements/managing-bank-statements-overview
page
If you are reconciling your cash accounts, you need quick and accurate tools to track third-party records and ensure that they match the transactions recorded in your system.
2026-02-19T17:09:06+01:00
# Managing bank statements - overview
If you are reconciling your cash accounts, you need quick and accurate tools to track third-party records and ensure that they match the transactions recorded in your system.
If you are reconciling your cash accounts, you need quick and accurate tools to track
third-party records and ensure that they match the transactions recorded in your system.
Visma Net
offers you capabilities that ease the processes of importing, tracking, and matching the
transactions tracked by other means.
If you are reconciling a bank account, you use a bank statement for the comparison.
Because
financial institutions offer a variety of online banking services, you do not need to wait for a
monthly bank statement to track your banking transactions.
You can instead download a list of
recent banking transactions in a suitable format when you need them.
Frequent importing and
matching of bank transactions makes the reconciliation process much easier.
If you are reconciling a cash accounts other than a bank account (for instance, a petty cash account), you can upload the list of amounts confirmed with the cash register receipts or point-of-sale reports and similar reports.
These topics will help you to understand how to import into the system transactions in various formats tracked by other means, and how to process the transactions further to ease the reconciliation process.
## Topics
+ [About processing imported transactions](/visma-net-erp/help/cash-management/manage-bank-statements/about-processing-imported-transactions/)
+ [Import a bank statement in OFX, QBO, and QFX formats](/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-ofx-qbo-and-qfx-formats/)
+ [Import a bank statement in Excel](/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-excel/)
+ [Batch payment matching](/visma-net-erp/help/cash-management/manage-bank-statements/about-batch-payment-matching/)
+ [About processing imported transactions](/visma-net-erp/help/cash-management/manage-bank-statements/about-processing-imported-transactions/)
+ [Set up transaction matching settings](/visma-net-erp/help/cash-management/manage-bank-statements/set-up-transaction-matching-settings/)
+ [Match transactions](/visma-net-erp/help/cash-management/manage-bank-statements/match-transactions/)
About importing transactions
/visma-net-erp/help/cash-management/manage-bank-statements/about-importing-transactions
page
With Visma Net, you can quickly import the list of recent bank transactions or amounts confirmed by other documents, and the periodic statements.
2026-02-19T17:09:06+01:00
# About importing transactions
With Visma Net, you can quickly import the list of recent bank transactions or amounts confirmed by other documents, and the periodic statements.
For each cash account, for which transactions are imported, the system creates a bank
statement (even if you upload just the list of amounts) that lists the uploaded
transactions.
The system assigns a reference number to this bank statement in accordance
with the number series assigned to bank statements in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
In this topic, you will read about the windows used to import transactions, the supported formats of the files to be uploaded, the setup of the import procedure for other file formats, and the manual entry of needed transactions.
## Supported formats
In Visma Net, you can upload transactions in files in the following formats:
+ **OFX (Open Financial Exchange), QBO (QuickBooks Online), and QFX (Quicken File eXchange)**:
Visma Net includes the **PX.Objects.CA.OFXStatementReader** import service, which parses
uploaded files in these three supported formats to create bank statements.
For more information about uploading files in these formats, see: [Import a bank statement in OFX, QBO, and QFX formats](/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-ofx-qbo-and-qfx-formats/)
+ **Excel**: For more information about uploading files in this format, see: [Import a bank statement in Excel](/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-excel/)
> [!NOTE]
> The file format you use defines the preliminary steps you should take and the details of the import procedure.
## The first import of transactions
When you import transactions for the first time, the system creates the first bank
statement.
If you import a file in OFX, QBO, or QFX format, the values for
**Statement date**, **Start balance date**,
**End balance date**, and **Ending balance** fields in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window are imported from the file. You
have to specify the beginning balance of the first statement manually.
If you import transactions from Excel or enter them manually, you have to enter all these values manually.
If a bank statement that you are going to import does not include transaction reference numbers, make sure that the **Require document ref. no. on entry** check box is cleared in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
## Subsequent imports of transactions
You can import files that contain transactions for multiple cash accounts or for one cash
account.
When you upload transactions, for each involved cash account, the system creates a
bank statement that lists the uploaded transactions and assigns the reference number to this
bank statement.
In Visma Net, you can use the following windows to upload transactions:
+ [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/):
You use this window to upload and view transactions for
each bank statement that the system has created.
When you use the window to upload a file
with transactions for one cash account, the system displays the created statement in the
window right away.
When you use the window to upload a file with transactions for multiple
cash accounts, the system does not display any of the created statements.
To view one of
the statements, you need to select the needed cash account and the reference number of
the statement (the last uploaded statement will have the highest reference
number).
Here, too, if you import a file in OFX, QBO, or QFX format, the system imports the values of the **Statement date**, **Start balance date**, **End balance date**, and **Ending balance** fields from the file. The system validates the value of **start balance date** which should be equal to the end balance date of the previously imported statement.
These formats (OFX, QBO, and
QFX) do not provide the beginning balance in bank statements.
The system uses as the
value of **beginning balance** the ending balance of the previous
bank statement.
Also, the system checks whether the beginning balance plus the total
imported receipts minus the total imported disbursements agrees with the imported
ending balance of the bank statement.
If you import bank transactions in Excel
format, you need to manually enter the statement date, end balance date, and ending
balance.
The system uses as the beginning balance the ending balance of the previous
bank statement.
Similarly, as the start balance, it uses the end balance date of the
previous bank statement.
After upload, you can manually edit bank transaction details before continuing to process the transactions in the system (matching and clearing them).
+ [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/):
You use this window primarily to process
transactions from all the created statements for the selected cash account, but you can
upload statements on this window as well.
When you upload a file, the system does not
display the transactions, regardless of the number of cash accounts in the file.
To view
the uploaded transactions, you need to select a cash account; the system then displays
all the transactions uploaded for this cash account that have not been processed
(matched and cleared) yet.
## Setup of import for other formats
Your company may receive statements for cash accounts in formats that are both supported
and not supported by Visma Net formats.
If your company has an import service to parse files in formats that are not
supported, the service can be added to the list of import services in Visma Net.
For details, please consult Visma Net support.
In such a case, you can define to the system an import service that is specific to a
particular cash account.
To do this, you need to select the **Import bank statements to single cash account** check box on the **Bank statement settings**
tab of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
This causes the
**Statement import service** field to be displayed in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/)
window, where you can specify the particular import
service for the cash account.
Also, if the check box is selected, a user can upload a file
only after selecting a cash account in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) or the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window (to make the **Upload file** button
available in the toolbar of the window).
## Foolproof import procedure
If your company always receives separate files (in supported formats), each of which
contains transactions for a single cash account, you can make the upload procedure more
strict.
In this case, by selecting the **Import bank statements to single cash account**
check box on the **Bank statement settings** tab of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window, you can force the user to select a cash account before
uploading a file.
If the check box is selected, a user can upload a file only after
selecting a cash account in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) and the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) windows.
In this case, for each cash account for which you import transactions, in the **Statement import service** field in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/) window, you also need to specify the **PX.Objects.CA.OFXStatementReader** import service.
## Manual entry of transactions
You can manually enter transactions for a specific account directly in the table in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window and save the list as a bank statement with a reference number.
Related pages
Concepts
Tasks
Windows
Import bank transactions
/visma-net-erp/help/cash-management/manage-bank-statements/import-bank-transactions
section
If your bank sends you electronic versions of your bank statements, you can import these statements to Visma Net to make it easier to reconcile the statements.
2026-02-19T17:09:06+01:00
# Import bank transactions
If your bank sends you electronic versions of your bank statements, you can import these statements to Visma Net to make it easier to reconcile the statements.
## Before you start
[Manually import bank transactions](/visma-net-erp/help/cash-management/configure-cash-accounts/manually-import-bank-transactions/)
1. Go to the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
1. In the **Cash account** field, select the bank account for which you want to import the statement. If the statement create method of the cash account is other than **Enter manually**, go to step 9.
> [!NOTE]
> You can use the manual import, when the **Upload files manually** check box is activated for the account in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/) window.
1. In the **Reference no.** field, enter the reference number of the bank statement, as specified by the bank.
1. In the **Statement date** field, either leave the current business date or select another date.
1. In the **Start balance date** field, select the earliest date among the unreconciled document dates.
1. In the **End balance date** field, select the latest date among the dates of the documents listed on the bank statement.
1. In the **Beginning balance** field, specify the balance of the account on the start date.
1. In the **Ending balance** field, specify the balance of the account on the end date. You are not required to fill in the fields in points 2-7.
1. Click .
1. Click  in the toolbar. It opens the **File upload** dialog box. If the statement create method of the cash account is **Import from AutoPay**, click the **Get statements** button that is displayed.
1. In the dialog box, select the file with the statement in the **File path** field.
1. Click **Upload** to upload the file and close the dialog box. The transactions of the selected bank statement are updated to the table in the lower part of the window.
Related pages
Concepts
Tasks
Windows
Create bank transaction rules
/visma-net-erp/help/cash-management/manage-bank-statements/create-bank-transaction-rules
section
You create bank transactions rules mainly for transactions that are not related to any incoming or outgoing payments, for example, fees and interest rates.
2026-02-19T17:09:06+01:00
# Create bank transaction rules
You create bank transactions rules mainly for transactions that are not related to any incoming or outgoing payments, for example, fees and interest rates.
1. Go to the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window.
1. Click  to add a new record.
1. In the **Rule** field, enter a unique identifier for the new bank transaction rule.
1. In the **Description** field, enter a description for the rule.
1. Select the **Active** check box to make the rule available in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. In the **Debit/Credit** field, select **Disbursement** or **Receipt**.
1. In the **Cash account** field, select the cash account that corresponds to the account in the bank. The system fills in the **Currency** field, depending on the chosen cash account.
1. In the **Trans. code** field, enter the transaction code on the account statement. If the **Trans. code** is used, you can see it in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) and [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) windows.
1. In the **Description** field, enter the description of the transaction.
> [!NOTE]
> You can use wildcard characters (\* or?) in the description, if you select the **Use wildcards** check box.
1. Optional: Select the **Match case** check box if you want the font case of the transaction to match the font case in the **Description** field.
1. Optional: Select the **Use name of bank** check box if you want the name of the bank for the transaction to match in the **Description** field.
1. Enter the **Bank account number** (IBAN/BBAN) to be used on the bank transaction rule.
1. In the **Amount matching mode** drop-down list, select one of the following:
1. **None**: The amount criterion is not used.
1. **Equal**: The transaction amount must be equal to the number specified in the **Amount** box.
1. **Between**: The transaction amount must be in the range of the numbers specified in the **Amount** and **Max. Amount** fields.
1. In the **Action** drop-down list, select one of the following:
1. **Create document**: The system creates a new document to match the imported bank transaction that has no match.
1. **Hide selected**: The system hides the imported bank transaction from the list and marks it as processed.
1. In the **Resulting entry type** field, select an [entry type](/visma-net-erp/help/cash-management/configure-cash-accounts/select-and-edit-an-entry-type/) to be used as a template. This template is used to create a cash transaction for unmatched imported bank transaction.
1. 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.
1. If the company has several branches, you can select the branch for which the rule applies in the **Branch** field.
1. Click .
Related pages
Windows
Match transactions
/visma-net-erp/help/cash-management/manage-bank-statements/match-transactions
section
2026-02-19T17:09:06+01:00
# Match transactions
In the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, you can match the transactions imported from a bank statement to transactions recorded to the bank account maintained in your system.
## Before you proceed
To make automatic matching of all transactions more efficient, you may need to review
the settings on the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
For more information, see: [Transaction matching settings.](/visma-net-erp/help/cash-management/manage-bank-statements/transaction-matching-settings/)
Also, you can configure the rules for document creation in the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window, which the system will apply to the transactions for which a match was not found.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. In the **Cash account** field, select the bank account. The **Bank transactions to match** table displays all the not-yet-processed bank transactions that have been uploaded to the selected cash account.
1. Click **Match automatically** in the window toolbar.
The system
performs matching by calculating the relevance factor for pairs of
transactions.
For each transaction in the table, if the system finds a
transaction for which the relevance factor exceeds the built-in threshold,
this transaction will have the **Matched** check box
selected and will be displayed on either the **Match to invoices** tab or the **Match to payments**
tab.
If the system finds multiple transactions with large relevance factors
but none with a relevance factor greater than the threshold, these
transactions will be displayed as possible matches. The system may find no
matching transactions.
If you have configured rules for document creation in the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window, the system will apply all the active rules to the transactions for which a match was not found during the matching process.
1. Review the transactions for which the system has selected the check box in the  column of the **Bank transactions to match** table. If you are not satisfied with the results, you can clear the match for the selected transaction by clicking the **Unmatch** button in the table toolbar.
1. For each transaction in the **Bank transactions to match** table for which the check box in the  column has not been selected (or cleared), do one of the following:
+ If there are matching documents in the table of the **Match to payments** tab, try to find a match for this bank transaction from the suggested payments. Compare the payee name on the transaction, which you can find in the **Payee name** column (which is hidden by default), because the names of the same customer may be recorded differently in the bank statement and in your system. he transaction code, which you can find in the **Trans. code** column (which is also hidden by default) may reveal the payment method. Also, the transaction date may be outside the date range allowed for payment delay due to unexpected factors. Select the **Matched** check box for the payment that is the closest match.
+ If there are matching transactions in the table of the **Match to invoices** tab, try to find a match for this bank transaction from the suggested invoices. Use the matching hints described for matching to payments. Select the **Matched** check box of the document row that you consider to be the best match. You specify the settings to create the payment for the invoice in the system on the **Match to invoice** tab.
> [!NOTE]
> When you process the imported transaction, the system will create the payment based on the specified settings and immediately apply it to the matched invoice.
+ If there are no matching transactions, consider creating a document or multiple documents to match to the transaction in the bank statement, see: [Create a new payment or document](/visma-net-erp/help/cash-management/manage-bank-statements/create-a-new-payment-or-document/). Also, you can specify open invoices which this payment should be applied to.
1. Click .
> [!NOTE]
> You can perform matching in as many sessions as you need. You can save your work at any time and continue later.
1. If you have finished matching transactions, review the results and click **Process** in the window toolbar to initiate the processing of matched transactions and transactions for which details of a new document were specified that result in clearing of the documents.
After you have processed the bank transactions for the selected cash account, you may proceed to reconciliation.
> [!NOTE]
> If your invoices have been registered after import of bank payments or you have updated your prefixes under cash account, it is possible to run recognition by clicking **Extract invoice numbers** in the window toolbar. For more information, see: [Extract invoice numbers](/visma-net-erp/to-be-deleted/help/cash-management/manage-bank-statements/extract-invoice-numbers/)
Related pages
Concepts
Tasks
Windows
Create a new payment or document
/visma-net-erp/help/cash-management/manage-bank-statements/create-a-new-payment-or-document
section
For bank transactions and incoming payments with no match, you can create a new document or payment to match manually.
2026-02-19T17:09:06+01:00
# Create a new payment or document
For bank transactions and incoming payments with no match, you can create a new document or payment to match manually.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) or [Process incoming payments (AR305000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/process-incoming-payments-ar305000/) window.
1. Select a cash account in the top part.
1. In the left pane table, select the line that you want to match.
1. In the **Create payment** tab (in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window) or **Create document** tab (in the [[Process incoming payments (AR305000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/process-incoming-payments-ar305000/)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window), select the **Create** check box.
> [!NOTE]
> If the details of an imported bank transaction or incoming payment include an invoice number in the **Invoice no.** field, the system searches for an open invoice that has the same reference number after you have selected the **Create** check box. If an invoice is found, the system fills in fields on the tab automatically with the data from the invoice and applies the amount to the invoice, and the line is ready for processing. Note that the bank transaction or incoming payment amount may differ from the invoice total.
1. Optional: In [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/), you can attach a file to the new document or the transaction. Drag the file to the **Create payment** tab area or click **Attach file** and select **Add file...** on the tab to open the **Upload file dialog box**.
1. In the **Workspace** field, select the workspace where the document originated.
1. If you in Step 6 selected **Cash management**:
1. Specify the **Entry type ID**.
> [!NOTE]
> Make sure that all needed entry types are listed under the **Entry types** tab of the selected cash account in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/) window.
1. Optional: in the **VAT Zone** field, change or specify the **VAT Zone** that applies to the transaction.
1. Optional: in the **Tran. descr.** field, you can change the transaction description for the new document.
1. Add a row in the table and specify the required fields.
1. If you in Step 6 selected **Supplier ledger** or **Customer ledger**:
1. Select the **Customer/Supplier no.**, **Location** and **Payment method**.
1. Optional: in the **Tran. descr.** field, you can change the transaction description for the new document.
1. You can select documents to be added to the table via the **Select documents** button, load documents to the table via the **Load documents** button, or add a row in the table and specify the required fields.
1. Optional: you can change the cross rate by adding the **Cross rate** column to the table and edit it, if the **Multi-currency accounting** functionality is enabled in the [Enable/disable functionalities (CS100000).](/visma-net-erp/help/common-settings/enable-or-disable-functionalites/enable-disable-functionalities-cs100000/)
1. Click . The system selects the **Ready to process** check box in the left pane table.
1. You can now continue processing the lines.
Related pages
Tasks
Windows
Match a bank transaction or incoming payment line to different documents
/visma-net-erp/help/cash-management/manage-bank-statements/match-a-bank-transaction-or-incoming-payment-line-to-different-documents
section
In the Process bank transactions (CA306000) and Process incoming payments (AR305000) windows, you can split a bank transaction or incoming payment line in the left table into different lines to process them against corresponding, multiple documents.
2026-02-19T17:09:06+01:00
# Match a bank transaction or incoming payment line to different documents
In the Process bank transactions (CA306000) and Process incoming payments (AR305000) windows, you can split a bank transaction or incoming payment line in the left table into different lines to process them against corresponding, multiple documents.
For more information: [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/), [Process incoming payments (AR305000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/process-incoming-payments-ar305000/).
You can match a bank transaction or incoming payment against multiple, different documents, for example, documents from different workspaces.
> [!NOTE]
> You can activate automatic splitting of payments on bank statements and/or incoming payments import by selecting the **Automatic split of batch payment from customers into payments per customer** check box on the **Bank statements settings** and/or **Incoming payments settings** tab in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window. You then only need to process them in the respective windows.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) or [Process incoming payments (AR305000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/process-incoming-payments-ar305000/) window.
1. Select a cash account in the top part.
1. In the left pane table, select the line that you want to match.
1. In the **Create payment** tab (in the [Process incoming payments (AR305000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/process-incoming-payments-ar305000/) window) or **Create document** tab (in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window), fill in the required information and select the first document to match. If an amount is remaining, the **Split** button will appear.
1. Click **Split** and a new line will appear below the original line in the left table, marked with an arrow.
> [!NOTE]
> The original line will be adjusted with a new amount and the **Ready to process** check box will be selected. The new line will have the unapplied amount in the **Receipt** or **Disbursement** field, depending on whether the unapplied amount is positive or negative.
1. Select the new line and perform the same procedure as in Step 4 to match it against a different document.
> [!NOTE]
> You can continue splitting as long as the line has an unapplied amount.
1. Click . The system selects the **Ready to process** check box in the left pane table.
1. You can now continue processing the lines.
Related pages
Tasks
Windows
Match account statements
/visma-net-erp/help/cash-management/manage-bank-statements/match-account-statements
page
2026-02-19T17:09:06+01:00
# Match account statements
## Before you start
After the [statements are processed](/visma-net-erp/help/work-processes/autopay/process-statements-manually-via-the-autopay-inbox/) in the [AutoPay inbox (CA50400S)](/visma-net-erp/help/cash-management/cash-management-windows/autopay-inbox-ca50400s/) window, you need to match them automatically from the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
If you have [defined a default cash account](/visma-net-erp/help/cash-management/configure-cash-accounts/configure-import-settings-for-statements-and-incoming-payments/) for this window, you will see all the statements that have been imported from AutoPay.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. If you have not yet defined a default account, or if you want to match statements from a different account: select the desired account in the **Cash account** field.
> [!NOTE]
> By default, the system displays all imported transactions for the account in the **Bank transactions to match** table. In the filter drop-down list on the table toolbar, you can also choose to view the matched or unmatched transactions.
1. Click **Match automatically**.
The system now tries to match the imported statements with the different transactions. The matching is based on payment references and invoice numbers, or [bank transaction rules](/visma-net-erp/help/cash-management/manage-bank-statements/create-bank-transaction-rules/).
For statements that the system has matched automatically, you see that the **Ready to process** check box is selected.
## What is next?
[Process matched account statements](/visma-net-erp/help/cash-management/manage-bank-statements/process-matched-account-statements/)
Related pages
Concepts
Tasks
Windows
Process matched account statements
/visma-net-erp/help/cash-management/manage-bank-statements/process-matched-account-statements
section
2026-02-19T17:09:06+01:00
# Process matched account statements
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window and select a **Cash account**.
1. Click **Process**. The system now reconciles all matching transactions. After processing, in the first column, a  or  is displayed for each processed line to indicate if the processing was successful or not.
1. Optional: hover over the  icon on each line to read why the specific line could not be processed. Resolve the error and repeat Step 1 and 2.
1. Optional: go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window again and select the same **Cash account** as you did in Step 1. All matched transactions have now disappeared from the table, leaving only the ones that were not successfully processed and had no match.
1. Optional: click **Settings for matching** to match more of the remaining transactions. In the **Settings for matching** dialog box, you can **temporarily** change the settings for matching, for example date settings or the weight settings for the relevance calculation. Click **Process** again.
> [!NOTE]
> The settings you make in the **Settings for matching** dialog box are reset to default when you leave the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
> [!NOTE]
> To set new, permanent settings for matching, go to the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window and click the **Bank statement settings** tab. Here, you can enter common settings for the matching of payments in the customer ledger and the supplier ledger.
Related pages
Concepts
Tasks
Windows
Process unmatched account statements
/visma-net-erp/help/cash-management/manage-bank-statements/process-unmatched-account-statements
section
2026-02-19T17:09:06+01:00
# Process unmatched account statements
## Before you start
After you have run the automatic matching, or when you select option **Unmatched** in the drop-down list on the table toolbar, the unmatched transactions are displayed in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window. The transactions that are not automatically matched will have to be matched manually.
Follow the steps below to create a new document or transaction for a bank transaction with no match.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. On the **Create payment** tab, select the **Create** check box.
1. In the **Module** field, select the workspace you want to edit.
1. If you have selected **Customer ledger** or **Supplier ledger**, select a **Business account**. The rest of the information will be filled in automatically.
1. If you have selected **Cash management**, select an **entry type ID**. The rest of the information will be filled in automatically.
> [!NOTE]
> If no entry type is displayed, you have to create one: [Create an entry type for disbursements or receipts](/visma-net-erp/help/cash-management/manage-cash-transactions/create-an-entry-type-for-disbursements-or-receipts/).
1. Optional:Split the transaction amount into multiple documents by adding lines in the table, and by specifying different offset accounts and subaccounts for each line.
1. Optional:Create supplier ledger or customer ledger documents to match the bank transactions to the documents available in the system.
1. When you have specified the information about the new payment and selected the documents to apply, click .
1. Click **Process matched lines** in the toolbar. The payment or cash transactions will now be created and applied.
Related pages
Concepts
Tasks
Windows
Process unmatched bank transactions
/visma-net-erp/help/cash-management/manage-bank-statements/process-unmatched-bank-transactions
page
2026-02-19T17:09:06+01:00
# Process unmatched bank transactions
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. In the **Cash account** field, select the cash account with the [imported bank transactions](/visma-net-erp/help/cash-management/manage-bank-statements/import-bank-transactions/) you want to process.
> [!NOTE]
> The system displays all imported transactions for the account in the Bank transactions to match table by default. In the filter drop-down list on the table toolbar, you can also choose to view the matched or unmatched transactions.
1. Click **Match automatically** to match the transactions. Matching is based on date ranges, and the weighted relevance of the reference number, document date, and payee.
> [!NOTE]
> During import of banks statements, Visma Net bases its matching on the invoice number. If there is no invoice number, invoices are matched according to the matching settings mentioned below.
> [!NOTE]
> In the matching the system uses the settings you have specified in the dialog box that opens when you click **Settings for matching**. If you have not specified these settings here, the system applies the default settings specified in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window on the tab **Bank statement settings**.
1. The system may find no matching transactions. The transactions that are not automatically matched you have to match manually to an invoice, a payment, or a payment you create.
1. Mark the line of the chosen cash account you want to process.
1. The **Match to invoices** or the **Match to payments** tab show you the possible matches to the transactions. If one of the payments on the list matches with the transaction selected in the table on the left, you select the **Matched** check box. Repeat this for all lines you want to match. Click **Process matched lines** to match them and to post them to the general ledger.
1. For a bank transaction without a match you can also [create a new document or transaction](/visma-net-erp/help/cash-management/manage-bank-statements/process-unmatched-account-statements/).
1. Click **Process** to process the matched transactions.
Related pages
Concepts
Tasks
Windows
Process rejected payments
/visma-net-erp/help/cash-management/manage-bank-statements/process-rejected-payments
section
2026-02-19T17:09:06+01:00
# Process rejected payments
## Before you start
If you have paid the same invoice twice, and you need to undo one of the payments, you must first make a registered payment void.
See: [Create a voided payment](/visma-net-erp/to-be-deleted/help/customer-ledger/customer-payments/create-a-voided-payment/).
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. In the **Cash account** field, select a cash account for direct debit.
1. Click **Process rejected**. when the system has reconciled all matching payments. The matched payments will disappear from the table.
 is displayed
> [!NOTE]
> The invoices and payments in the [Bank deposits (CA305000)](/visma-net-erp/help/cash-management/cash-management-windows/bank-deposits-ca305000/) windows are now closed. See: [View a cash deposit for direct debit](/visma-net-erp/to-be-deleted/online-help/accounting-modules/ca/ca305000-view-cash-deposit-direct-debit-task/).
Related pages
Concepts
Tasks
Windows
Import a bank statement in OFX, QBO, and QFX formats
/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-ofx-qbo-and-qfx-formats
section
If you have bank transactions in a file in OFX, QBO, or QFX format, you can import these transactions by clicking the Upload file button on the window toolbar of the Import bank transactions (CA306500) window.
2026-02-19T17:09:06+01:00
# Import a bank statement in OFX, QBO, and QFX formats
If you have bank transactions in a file in OFX, QBO, or QFX format, you can import these transactions by clicking the Upload file button on the window toolbar of the Import bank transactions (CA306500) window.
For more information: [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/).
During file uploading, the system creates a statement for each bank account listed in the file.
You can also perform this procedure by clicking the **Upload file** button in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
This procedure describes how to import bank transactions from an OFX, QBO, or QFX file.
## Before you proceed
Make sure that the **PX.Objects.CA.OFXStatementReader** import service is specified in the **Statement import service** field; the location of this field depends on whether the **Import bank statements to single cash account** check box, located in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window, is selected:
+ Selected: The import service is specified in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/) window for each cash account for which you will import statements in one of these formats.
+ Cleared: The import service is specified on the **Bank statement settings** tab of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
Also, make sure that the bank account ID specified in the file is associated
with the appropriate cash accounts in the system.
That is, for the cash account for
which you want to upload transactions, specify the bank account ID in the
**External ref. number** field in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/)
window.
For
instance: You can find the bank account identifier in the OFX file under the
<ACCID> tag.
If you forget to specify the bank account ID in the cash account settings
and try to upload transactions, the system gives you a warning.
The warning contains
the bank account ID from the file, which you can copy and paste to the
settings for the cash account.
You can then try to upload the file again.
## Import the bank statement
1. Go to the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
1. Click **Upload file** in the window toolbar. The **Statement file upload** dialog box is displayed.
1. In the dialog box, make sure that the **Upload file** option is selected.
1. By using the **Choose file** field, select the file with the statement. Click **Upload** to upload the file and close the dialog box.
1. Review statement details in the top part of the window and the list of imported transactions in the table.
1. Click .
The system generates a reference number for the list of uploaded transactions in accordance with the numbering series assigned to bank statements in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
The procedure is similar if you use the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window to import the bank statement.
You can review the list of imported transactions and manually edit transaction
details.
You can then process the imported transactions by using the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
Related pages
Concepts
Tasks
Windows
Import a bank statement in Excel
/visma-net-erp/help/cash-management/manage-bank-statements/import-a-bank-statement-in-excel
section
If you have an Excel file with a single statement, in the Import bank transactions (CA306500) window, you can import the bank transactions for this statement by clicking the Load records from file standard button on the table toolbar.
2026-02-19T17:09:06+01:00
# Import a bank statement in Excel
If you have an Excel file with a single statement, in the Import bank transactions (CA306500) window, you can import the bank transactions for this statement by clicking the Load records from file standard button on the table toolbar.
For more information: [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/).
This procedure describes how to import a single bank statement from a Microsoft Excel file directly into the table of this window.
If you have an Excel file that holds multiple statements, you can import these
statements by using a scenario based on the built-in data provider for Excel
files.
To create this scenario, you use the [Manage import scenarios (SM206025)](/visma-net-erp/help/integration/integration-windows/manage-import-scenarios-sm206025/) window.
You can adjust the sample scenario for importing bank
statements, which is available with the demo data supplied with Visma Net.
1. Go to the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
1. In the **Cash account** field, select the bank account for which you want to import the statement.
1. In the **Statement date** field, either leave the current business date or select another date.
1. In the **Start balance date** field, select the earliest date among the dates of the unreconciled documents.
1. In the **End balance date** field, select the latest date among the dates of the documents listed on the bank statement.
1. In the **Beginning balance** field, specify the balance of the account on the start date.
1. In the **Ending balance** field, specify the balance of the account on the end date.
1. Click .
The system creates a blank statement and generates a reference number for it in accordance with the number series assigned to bank statements in the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
1. In the table toolbar, click **Load records from file**. The **File upload dialog box** is displayed.
1. In the dialog box, by using the **File path** field, select the file with the statement. Click **Upload** to upload the file and close the dialog box.
1. In the dialog boxes that the system brings up sequentially, proceed as follows:
1. In the **Common settings dialog box**, in the **Null value** field, type the character that is used as the null value in the source file.
1. In the **Culture** field, select the locale in which the data is presented in the source file. Click **OK** in the dialog box.
1. In the **Columns** dialog box that appears, perform mapping of the columns of the source file (the left column) to the columns available in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window. Click **OK** to close the dialog box and complete the import.
1. Click .
In the table, you can review the list of imported transactions and manually edit
transaction details.
You can then process the imported transactions by using the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
Related pages
Concepts
Tasks
Windows
Write off amounts during a bank transaction processing
/visma-net-erp/help/cash-management/manage-bank-statements/write-off-amounts-during-a-bank-transaction-processing
page
2026-02-19T17:09:06+01:00
# Write off amounts during a bank transaction processing
## Preparation
+ Select the check box for write off in the customer settings: Enable write-offs for customer.
+ Import bank transactions.
Write-offs during bank transactions are only possible for underpaid sales invoices.
1. Go to the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
1. In the **Cash account** field, select the account.
1. In the table, select the **Ready for process** check box for the underpaid invoice you want to write off.
1. Go to the **Create payment** tab.
1. Select the **Create** check box. Additional fields are added.
1. In the **Balance write-off** column, enter the write off amount.
1. In the **Write-off reason code** column, select the reason code for write-offs.
> [!NOTE]
> If no reason code is available: Create reason codes for write-offs.
1. Click **Process matched lines**.
Related pages
Concepts
Tasks
Windows
About processing imported transactions
/visma-net-erp/help/cash-management/manage-bank-statements/about-processing-imported-transactions
section
During each financial period, you periodically import transactions and process the imported transactions or match them with the documents in the system.
2026-02-19T17:09:06+01:00
# About processing imported transactions
During each financial period, you periodically import transactions and process the imported transactions or match them with the documents in the system.
During each financial period, you periodically import transactions and process the imported
transactions or match them with the documents in the system.
This process eliminates
discrepancies between transactions in the system and in the company's bank account or some other
source (if the cash account reflects operations recorded in a third-party system, other than a
bank).
Processing of the imported transactions is the preliminary step before the reconciliation
is performed in the [Reconciliation statements (CA302000)](/visma-net-erp/help/cash-management/cash-management-windows/reconciliation-statements-ca302000/) window.
If the matched document
for the transaction is found, the transaction is linked to the document, which is then marked as
cleared, thus ready to be reconciled.
Also, users can mark documents (cash entries, payments to suppliers, incoming payments from customers, and cash sales) as cleared as they receive confirmation documents from a bank or third-party system by selecting the **Cleared** check box for each document in the window that was used to create the document: [Cash account details (CA303000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-account-details-ca303000/), [Supplier payments (AP302000)](/visma-net-erp/help/supplier-ledger/supplier-ledger-windows/supplier-payments-ap302000/), or [Cash sales (AR304000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/cash-sales-ar304000/). You can select and clear the check box at any time.
Users can even manually clear and reconcile transactions in the [Reconciliation statements (CA302000)](/visma-net-erp/help/cash-management/cash-management-windows/reconciliation-statements-ca302000/) window skipping matching bank transactions in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
Despite being marked as cleared or reconciled, these documents do not have a link to an
imported transaction and are also included in the matching process.
When a document is matched
to an imported transaction, the **Cleared** check box for this document is
selected and becomes read-only.
If you imported a bank statement with transactions that had been already cleared or reconciled in the system and you do not want to process them in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, you can hide these transactions by using the **Hide transaction** button in the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
In this topic, you will read about the steps for matching transactions, the creation of missed documents, and the details of application.
## Steps for matching transactions
In the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, you can match the imported transactions to the
documents in the system.
The goal of the matching process is to find a document in the system: a
payment that is matched to an imported transaction, or an invoice for which a payment will be
created to match to the transaction. When matches are found, the system processes matched
transactions: it creates a link between the document and the imported transaction, and marks the
document as cleared.
To make the matching easier and less time-consuming, we recommend that you perform the following steps:
1. On the **Bank statement settings** tab of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window, specify the parameters the system will use for calculating the relevance rate (a measure of how closely a document matches the selected imported transaction) and for searching for matching documents. Alternatively, you can specify these parameters in the **Settings for matching** dialog box, which opens when in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, you select a cash account and click **Settings for matching** in the window toolbar. [Transaction matching settings](/visma-net-erp/help/cash-management/manage-bank-statements/transaction-matching-settings/)
For more information, see:
1. Optional: In the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window, specify the rules that the system will use to automatically create documents to match those imported transactions for which documents are not found in the system. You can create such rules on the fly when performing manual matching in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window and use the rules for the next imported transactions.
1. Run the automatic matching tool, which performs matching based on the available transaction information, such as amount, payee name, and date. The system uses the transaction information and matching settings that you have specified to calculate the match relevance rate first for each payment in the system that has the **Cleared** check box available for editing, and then for open invoices. If you have configured rules for document creation, the system tries to apply these rules to the transactions for which a match was not found.
1. Validate and save the results of the automatic matching.
1. Perform manual matching for the remaining transactions (if any). If a match was not found in payments and invoices, you can specify the details of a document that should be created to match the transaction on the bank statement. Review and save the results.
1. Validate and confirm the results of the matching.
The system allows automatic and manual matching of a transaction to a payment that is not
released yet (a payment with the **Balanced** or **On hold** status).
If a transaction is
matched to such a payment (manually or automatically), the system performs a check for the
payment amount discrepancy before processing this document.
For example: The system displays an
error if a user first matches the transaction to an unreleased document, then changes the amount
on that document, and then tries to process this line.
You can perform transaction matching in as many sessions as you need. You can save the result at any time to continue to work with it later.
In the following sections, you will read about the steps of the matching process in detail.
## Automatic matching
We recommend that you always start matching with running the automatic matching process, to
save time.
Select the cash account for which you want to perform matching and click
**Match automatically** in the window toolbar to run the process for the imported
transactions.
When you run the process, the system searches for possible matching payments, and
for documents to which the payment could apply.
If no possible matching
payments or documents to apply are found in the system, the system suggests that you create a
payment.
The process uses the following marks to differentiate the current transaction matching status:
+ The check box in the  column is selected: A candidate with high relevance has been found and matched automatically or the **Create** check box is selected and the details of the new payment are filled in automatically (according to the rules configured) on the **Create payment** tab.
+ The check box in the  column is cleared: A list of possible matches has been found, and the transaction is pending your review and decision.
+ The transaction is marked by an exclamation point: No matches have been found and the system suggests that you create the payment, so the **Create** check box has been automatically selected on the **Create payment** tab.
For each imported transaction, the system finds the matching document as follows:
1. To find the matching payments for an imported transaction, the system filters the cash account transactions by the specified matching settings and calculates the match relevance for the possible candidates. The relevance shows how similar the imported transaction is to a cash account transaction (or multiple transactions) in the system. The transactions are compared by three factors: the reference number, the transaction date (document date), and the payee name (if any). The candidates with high relevance are recognised as the best candidates and are matched automatically. If there is no best candidate found, the system displays a list of possible matches with the lower match relevance rate on the **Match to payment** tab of the right pane. In this case, you need to review possible matches and decide whether to match an imported transaction to one of these matches or create a new document by using the **Create payment** tab on the right pane.
1. To find a document to which the payments could apply, the system compares the payment amount with the amount of any outstanding documents with the same transaction sign (receipt or disbursement). The system never matches payments to invoices automatically (on the **Match to invoice** tab). Therefore, after the system has found the invoice, the check box in the  column for the imported transaction remains cleared, which means it hasn't been matched to any document yet and is pending your review and decision. For imported transactions that have no matches, the system suggests that you create the payment, so the **Create** check box has been automatically selected on the **Create payment** tab of the right pane and the transaction is marked by an exclamation point.
After the automatic matching process is done, the matched imported transactions become
excluded from the next run of the automatic matching process.
To run the process for these
transactions again, click **Unmatch** for a certain transaction or click
**Unmatch all** to clear matches for all transactions at once.
## Manual matching
After you have run the automatic matching process, the transactions pending your review and decision may be left. See [Match transactions](/visma-net-erp/help/cash-management/manage-bank-statements/match-transactions/) on how to proceed.
If a match was not found in payments and invoices, you can create a document to match the
transaction on the **Create payment** tab, see also: [Create a new payment or document](/visma-net-erp/help/cash-management/manage-bank-statements/create-a-new-payment-or-document/).
## Payment creation and application
See [Create a new payment or document](/visma-net-erp/help/cash-management/manage-bank-statements/create-a-new-payment-or-document/) and [Match a bank transaction or incoming payment line to different documents](/visma-net-erp/help/cash-management/manage-bank-statements/match-a-bank-transaction-or-incoming-payment-line-to-different-documents/) on how to use this tab.
## Creation of transaction rules
For new payments that originate in the Cash management workspace, you can create a rule the
system will use to automatically create new payments if the details of an imported transaction
meet the conditions of the rule. You can define such rules before you perform the matching
process by using the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window, or you can define the rules on the
fly when you manually match transactions. When you click **Create rule** in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, the system navigates to the [Bank transaction rules (CA204500)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transaction-rules-ca204500/) window.
The system automatically fills boxes in the **Matching criteria** section with the transaction details, and you need to specify output
details only. You can clear or modify values in the **Matching criteria**
section if some of the transaction details cannot be used as criteria.
For example: You can
modify the transaction description by using wild card characters (\* or?) and the **Use wild cards** check box, or clear the **Description** field.
For example: Suppose that you know that the bank charge transactions usually are not greater than €100 per transaction and appear with the **SRVCHG** transaction code in the bank statement. Therefore, you can define a rule to create **BANKCHARGE** cash entries in the system from the disbursement bank transactions that comply with these conditions.
## Confirmation of results
When you have finished matching imported transactions, for transactions that are matched to a
payment or an invoice, the check box in the  column is selected.
Also, for transactions with no match, details of
the new payment are specified and the exclamation point is no longer displayed.
To confirm the
matching results, click the **Process** button on the window toolbar.
During the processing, the system does the following:
+ Sets the read-only **Cleared** check box for the matched payments in the system.
+ Creates and applies payments for the matched invoices, releases the created payments and the applications, and sets the read-only **Cleared** check box for every processed document.
+ Creates the documents based on the imported transactions for which a match was not found, releases the created documents and the applications (if any), and sets the read-only **Cleared** check box for every processed document.
+ Sets the read-only check box in the  column for those imported transactions that are matched to payments or invoices.
+ Sets the read-only check box in the  column and removes the exclamation point for those imported transactions for which new document details were specified.
Payments that the system creates during processing of the matched transactions are not subject for approval, even if the process of approval is set up.
Once processed, the imported transactions are excluded from future processing of matched lines and displayed in the [Reconciliation statements (CA302000)](/visma-net-erp/help/cash-management/cash-management-windows/reconciliation-statements-ca302000/) window marked as cleared and ready to be reconciled. Press **ESC** to refresh the information in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, and the processed transactions no longer appear in the window.
## Review of processing results
You can review the processing result for the transaction in the corresponding bank statement by using the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window. You select a cash account and a reference number of an imported bank statement, the system displays the corresponding list of bank transactions. You can see whether a transaction was processed and its details of processing. For the matched transactions you can click the **View matched document** button on the table toolbar to view details of the matched document or batch.
You can also review processed bank transactions by using the [Bank transactions history (CA402000)](/visma-net-erp/help/cash-management/cash-management-windows/bank-transactions-history-ca402000/) window.
You select a cash account and a date range for which you want to review
processed bank transactions, the system displays the list of corresponding bank transactions.
You can view whether a transaction was matched to an existing document in the system or a new
document was created to match this transaction.
A reference number of the matched document can
be found in the **Reference no.** column, by clicking this number you
navigate to the respective window where you can view document details.
## Reversion of processing results
You can revert the result of processing a transaction by using the
**Unmatch** button on the table toolbar of the [Import bank transactions (CA306500)](/visma-net-erp/help/cash-management/cash-management-windows/import-bank-transactions-ca306500/) window.
You select a cash account and a reference number of an imported bank statement, and the
system displays the corresponding list of bank transactions.
You then select a processed bank
transaction and click **Unmatch**.
The system does the following for the selected bank transaction: clears the check boxes in the
 and
**Processed** columns, and removes the link to a matched document.
The selected bank transaction becomes available for further processing in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
Also, the system clears the following for the matched document:
the **Cleared** check box and the **Clear date** field on
the **Financial details** tab of the document in the [Customer payments (AR302000)](/visma-net-erp/help/customer-ledger/customer-ledger-windows/customer-payments-ar302000/) window.
If a document was created to match the
transaction, you should handle this document manually (for instance, voiding or matching the
document).
About batch payment matching
/visma-net-erp/help/cash-management/manage-bank-statements/about-batch-payment-matching
page
Batch payment processing is a widely used practice, and Visma Net provides this feature for both Supplier ledger and Customer ledger payments.
2026-02-19T17:09:06+01:00
# About batch payment matching
Batch payment processing is a widely used practice, and Visma Net provides this feature for both Supplier ledger and Customer ledger payments.
You can group your supplier payments into a batch and export it for further processing by a money transfer operator.
For more information, see [About payment methods for suppliers](/visma-net-erp/help/cash-management/manage-payment-methods/about-payment-methods-for-suppliers/) and [About the preparation of deposits](/visma-net-erp/help/cash-management/track-cash-payments/about-the-preparation-of-deposits/).
Financial institutions may report a payment batch as a single line on the bank statement or provide a detailed list of the payments included in a batch. Some banks give their customers the option to choose between detailed reporting or not, while others always report in one of the two ways, which may vary for Customer ledger and Supplier ledger.
This topic covers the clearing and reconciliation of batch payments in Visma Net.
## Accounts payable batch payment matching
If your bank delivers a statement in which a Supplier ledger batch payment is reported as a
single transaction, you should indicate to the system that during processing of the imported
bank transactions in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, the system
should search for a match among released Supplier ledger batch payments, as well as among
individual payments.
To do this, you select the **Match bank transactions to batch payments** check box in the [Cash accounts (CA202000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-accounts-ca202000/) window
for the cash account that represents your bank account. Additionally, you may indicate to
the system to search for a match also among the Supplier ledger batches that are not
released yet, by selecting the **Allow matching to unreleased batch payments** check box on the **Bank statement settings** tab
of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
If your bank reports a batch payment as a list of individual payments, make sure that the **Match bank transactions to batch payments** check box is cleared for the cash account that represents your bank account.
With the **Match bank transactions to batch payments** check box selected, when you process imported transactions in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window and match (manually or automatically) a bank transaction to a Supplier ledger batch, the system clears the batch and all payments from this batch.
If you cannot find the particular Supplier ledger batch in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window to match a bank transaction, check whether payments from this batch have been matched already to some other bank transactions. If at least one payment from a Supplier ledger batch has been matched, the system does not display this batch in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window. You can clear the **Matched** check box for such a payment and perform the matching process once again.
Then when you prepare a reconciliation statement in the [Reconciliation statements (CA302000)](/visma-net-erp/help/cash-management/cash-management-windows/reconciliation-statements-ca302000/) window, the system displays this Supplier ledger batch in the list of transactions instead of the individual payments from this batch.
When you save the reconciliation statement for the first time and the system assigns a
reference number to it, the value of the **Match bank transactions to batch payments** check box at this moment is preserved by the system for this particular
statement.
If you change the value of the check box after the reconciliation statement was first
saved, the system will display the **Bank transactions are matched to batch payments** check box in the [Reconciliation statements (CA302000)](/visma-net-erp/help/cash-management/cash-management-windows/reconciliation-statements-ca302000/) window.
This check box will
reflect the value of **match bank transactions to batch payments** at the
moment when the statement was first saved.
The system will handle Supplier ledger batch
payments based on the original setting before you first saved the reconciliation statement.
## Bank deposit matching
If your bank reports a deposit as a list of included payments, you should also record the individual payments in the system, so they can be easily reconciled with the lines in the bank statement.
If your bank reports deposits as a single line, we recommend that you use the bank deposit
processing offered by Visma Net.
After you match (manually or automatically) a bank transaction to a deposit registered in the system and process matched bank transactions in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, the system clears the deposit and all payments it includes.
Then when you prepare a reconciliation statement in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, the system displays the deposit in the list of transactions instead of the individual payments it includes.
Related pages
Concepts
Tasks
Windows
Transaction matching settings
/visma-net-erp/help/cash-management/manage-bank-statements/transaction-matching-settings
page
In Visma Net, you can tailor the settings of the automatic matching process to suit your company's needs.
2026-02-19T17:09:06+01:00
# Transaction matching settings
In Visma Net, you can tailor the settings of the automatic matching process to suit your company's needs.
The automatic matching process uses the available information about imported transactions for searching matching documents and for calculating the relevance rate, which is a measure of how closely a document matches the selected transaction.
As you are working in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, you can specify
the matching parameters that apply to the current user session in the **Settings for matching** dialog box (which opens when you select a cash account and click **Settings for matching** in the window toolbar).
You can modify matching settings in this dialog box and
experiment with the settings to find the best values for relevance calculation in your
organisation.
After that, you can specify the most appropriate values as the default ones on the **Bank statement settings** tab of the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
During the matching process, the system uses the first two sections of the matching
settings,**Disbursement date matching** and **Receipt date matching**, to filter documents in the system by date.
The documents whose dates
fall into the specified range are considered candidates for calculating the match relevance
rate.
Then the system uses the next two sections of the matching settings, **Weights for relevance calculation** and **Date range for relevance calculation**, to calculate the match relevance date for the documents filtered by date.
For each matching document, the system displays the calculated rate in the **Match relevance** column on the **Match to payments** or
**Match to invoices** tab of the right pane.
The match relevance rate is
between 0 and 1.
The best match is the cash transaction with the highest rate or a significantly
high rate (see the details in Best match
selection rules below).
The cash transactions with a rate of 0 do not appear on the
tabs.
In this topic, you will read about how the system calculates the match relevance rate and how it searches for the best match.
## Match relevance rate calculation
The match relevance rate is calculated based on the match settings.
In the match settings, you
specify the relative weight of the three factors from which the likelihood is calculated:
+ Reference number
+ Date of the document or transaction
+ Payee information
In the match settings, for each of these factors, you specify the percent or weight of the
factor in the match relevance rate.
Before the system calculates the rate, it applies to the
document date factor an additional weighting, which you can specify as follows:
+ In the **Payment clearing average delay** field, you specify the number of days after the document date in the system that the payment is usually delayed before it appears in the bank statement.
+ In the **Estimated deviation (days)** field, you specify the deviation, which defines the date range that includes almost all (99.73%) possible dates during which the transaction in the system that could match the transaction in the bank statement. A date that is outside of the range is very unlikely to be the date of the bank transaction.
For example, suppose that you use the following match settings:
Ref. no. weight
: 70.00
Doc. date weight
: 20.00
Doc. payee weight
: 10.00
Payment clearing average delay
: 0.00
Estimated deviation (days)
: 5.00
You have imported the bank transaction with the reference number 1231, the receipt amount
9000€, and the date 1/1/2020.
After you have run the automatic matching process, a possible
match has been found by the reference number and transaction date.
The reference number of the
possible match in the system exactly equals the reference number of the bank transaction.
The
date of the possible match in the system is 12/31/2019, and this date falls within the date
range of 99.73% probable dates of the bank transaction.
The probable date range is 12/31/2019
through 1/5/2020, where the end date of the range is calculated as 12/31/2019 + 5 days =
1/5/2020.
The bank transaction date is one day past the transaction date in the system.
Because
the date is shifted, the additional weighting function for the date is equal to 0.98, which is
the normalised value of the Gaussian distribution with the mean of 0 (**Payment clearing average delay**) and the standard deviation of 5 (**Estimated deviation**).
As the result, the **Match relevance** rate for the
found transaction is 0.7 \* 1 + 0.2 \* 0.98 \* 1 + 0.1 \* 0 = 0.896, where the factors are the
reference number, document date, and payee, respectively.
## Best match selection rules
Based on the calculated match relevance, the system selects the best match according to the following rules:
1. The best match is the transaction with the highest **Match relevance** rate that is greater than 0.75.
1. If there are no transactions with a **Match relevance** rate that is greater than 0.75, the best match is the transaction that is more relevant than the other found transactions for 0.2 or more of the **Match relevance** rate. For example: If two transactions were found, one with relevance of 0.25 and another with relevance of 0.5, the transaction with relevance 0.5 will be matched.
1. If only one transaction is found, it is the best match if its **Match relevance** rate is 0.2 or greater.
1. Otherwise, there is no best match for the transaction in the bank statement.
> [!NOTE]
> If you want to change the match settings and run the automatic matching process again, you need to first clear the results of the previous matching. To do this, in the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window, click **Unmatch all** in the table toolbar, and then click **Match automatically** to re-run the process of automatic matching.
Related pages
Concepts
Tasks
Windows
Set up transaction matching settings
/visma-net-erp/help/cash-management/manage-bank-statements/set-up-transaction-matching-settings
section
By using the Cash management preferences (CA101000) window, you specify the default matching settings to be used by the automatic matching process in the Process bank transactions (CA306000) window, as described below.
2026-02-19T17:09:06+01:00
# Set up transaction matching settings
By using the Cash management preferences (CA101000) window, you specify the default matching settings to be used by the automatic matching process in the Process bank transactions (CA306000) window, as described below.
For more information: [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/), [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/).
Also, to apply matching settings to only the current user session, you can specify them in the **Settings for matching** dialog box, which opens when you select a cash account and click **Settings for matching** in the window toolbar of the [Process bank transactions (CA306000)](/visma-net-erp/help/cash-management/cash-management-windows/process-bank-transactions-ca306000/) window.
## Set up matching settings
1. Go to the [Cash management preferences (CA101000)](/visma-net-erp/help/cash-management/cash-management-windows/cash-management-preferences-ca101000/) window.
1. On the **Bank statement settings** tab, review the settings and change them if needed as follows:
1. For **disbursements**, specify the number of days before or after the bank transaction date (or both) allowed for transactions to be considered matching.
1. For **receipts**, specify the number of days before or after the bank transaction date (or both) allowed for transactions to be considered matching.
1. Specify relative weights for matching payee names, document dates, and reference numbers. Depending on how the payments received from different customers vary, base the weights on the importance of the respective factor in identifying the documents.
1. Specify the average delay for payments and the estimated deviation to be used for relevance calculation.
1. Click .
Related pages
Concepts
Tasks
Windows