User Tools

Site Tools


user:banking

Banking — Bank Transactions

Section: Banking
Updated: 2026-05-05


1) Overview

The Banking module is a separate section in the sidebar (not part of Finance). It shows all bank statement transactions imported from your bank accounts and lets you match, identify, and convert them into payment records.

Navigate to Banking → Bank Transactions.


2) Bank Transactions List

Columns

Column Description
Date Transaction date (DD.MM.YYYY)
Bank Account The NVG bank account this transaction belongs to
Dir Direction badge — Incoming (green) or Outgoing (red)
Counterparty Name of the other party (bank reference or matched partner name)
Reference Payment reference / booking text (truncated; hover for full text)
Amount Transaction amount
Status Current processing status (see below)
Actions Buttons to view, identify, or process the transaction

Transaction Statuses

Status Meaning
Imported Transaction was imported but not yet reviewed
Identified Transaction has been matched to an invoice or payment record
Converted Transaction has been converted to a formal Payment in Finance
Ignored Transaction has been marked as not relevant

Filters (two rows)

Row 1: Search · Status (Imported / Identified / Converted / Ignored) · Direction (Incoming / Outgoing) · Import button (loads latest transactions from the bank API — requires a bank account to be selected first)

Row 2: Tenant · Bank Account · Period (Today, Yesterday, This Week, Last Week, This Month, Last Month, Last 90 Days, Year to Date, Last Year) · Upload button (uploads a bank statement file)

Sorting: click any column header — Date, Bank Account, Dir, Counterparty, Reference, Amount, Status.


3) Getting Transactions into Cockpit

There are two ways to bring bank transactions into the system:

Option A — Import (API)

  1. Select the Tenant and Bank Account in the filter row.
  2. Once a bank account is selected, the Import button becomes active.
  3. Click Import to fetch the latest transactions from the bank connection.
  4. New transactions appear with status Imported.

Option B — Upload (File)

  1. Click Upload to open the file import modal.
  2. Select your bank statement file (the accepted format depends on your bank configuration — typically CSV or MT940/camt.054).
  3. Confirm the upload.
  4. Imported transactions appear in the list with status Imported.

4) Processing Transactions

Once imported, each transaction needs to be reviewed and either matched to an existing record or ignored.

Identifying a Transaction

“Identifying” means linking a bank transaction to an existing invoice or payment already recorded in Finance.

  1. Find the transaction in the list (Status: Imported).
  2. Click the Identify action button.
  3. Search for and select the matching sales invoice, vendor bill, or payment.
  4. Save — the transaction status changes to Identified.

Converting to a Payment

After identification, click Convert (or the equivalent action) to create a formal Payment record in the Finance module. This officially records the cash movement against the invoice.

  1. The invoice's Open amount reduces by the transaction amount.
  2. If fully paid, the invoice status changes to Paid.
  3. The transaction status changes to Converted.

Ignoring a Transaction

For transactions that are not relevant to NVG accounting (e.g. internal transfers you do not need to track):

  1. Click the Ignore action.
  2. The transaction status changes to Ignored and it no longer appears in the default view.

5) Common Tasks — Quick Reference

Task Steps
See today's incoming transactions Banking → Bank Transactions → Period: Today, Direction: Incoming
Import latest bank transactions Banking → select Tenant + Bank Account → Import button
Upload a bank statement file Banking → Upload button → select file → confirm
Match a transaction to an invoice Transactions list → Identify button → search invoice → Save
Convert an identified transaction to a payment Transactions list → Convert button on identified row
Hide an irrelevant transaction Transactions list → Ignore button
user/banking.txt · Last modified: by 127.0.0.1