Manage bank statements

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.

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.

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.

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.

Match transactions

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.

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.

Match account statements

Process matched account statements

Process unmatched account statements

Process unmatched bank transactions

Process rejected payments

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.

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.

Write off amounts during a bank transaction processing

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.

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.

Transaction matching settings

In Visma Net, you can tailor the settings of the automatic matching process to suit your company’s needs.

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.