---
title: "Match Bank Transactions to Customer Accounts Automatically"
description: "How bank transactions in Turkey match to customer accounts and open invoices automatically: MT940, open banking, matching rules and daily bank reconciliation."
url: "https://pragmaticgrowth.com/guides/bank-transaction-matching"
language: "en"
alternate: "https://pragmaticgrowth.com/tr/guides/bank-transaction-matching"
---

# Matching Bank Transactions to Customer Accounts Automatically

Finance

Automatic matching collects bank transactions on a schedule, from statement files, the bank's own service or open banking, and links each collection or payment to the right customer or supplier account and its open invoices: first by exact keys such as an invoice number, tax number or IBAN, then by amount and date. Anything it is unsure of goes to a person, and approved matches post to your accounting software as collections or payments.

By [Serkan Haşlak](https://pragmaticgrowth.com/about) · Published 2026-09-24 · Updated 2026-09-24

## In Short

- Transactions arrive through internet banking exports, MT940 statements, the bank's web service or open banking.
- Matching runs in order: exact keys first (invoice number, tax number, IBAN), then amount and date.
- Partial payments, one transfer for several invoices, withholding and exchange differences get their own rules; the rest goes to an exceptions queue.
- Reconciliation happens every day, not at month-end, and any difference between bank and books shows with its reason.

## Why Does Posting Customer Payments Take So Long?

The customer writes the transfer description. Some write the invoice number, some a shortened company name, some nothing at all. One customer pays three invoices in one transfer, another pays short, and a group company settles its sister company's debt.

The result is familiar: the statement goes into Excel next to the customer ledger, and for every line someone answers "whose is this, and which invoice?" by hand. Left to month-end, overdue receivables are noticed late and customers get the wrong reminders.

Bank statement: free-text descriptions, split amounts, checked against the ledger by hand → Every transaction linked to an account and its open invoices, with the reason for any difference

## How Do Bank Transactions Reach the System?

The right route depends on your banks and your volume. Most companies run more than one side by side.

For open banking, the framework in Turkey is Law No. 6493 and the payment services regulation of 1 December 2021, overseen by the Central Bank (TCMB). An account information service provider may offer only the services the customer has approved and may access only the accounts the customer designates. TCMB sets the technical requirements; the Interbank Card Center (BKM) checks compliance and registers the providers that pass. Before working with a provider, check that it has TCMB permission and BKM registration, and that the service is offered for your company accounts.

**Ways to receive bank transactions**

| Route | How it arrives | When it fits | Watch for |
| --- | --- | --- | --- |
| Internet banking export | Excel or CSV downloaded by hand | Getting started, few accounts | Layout differs from bank to bank |
| MT940 / MT942 | Email, FTP, SFTP, SWIFT or web service | Company accounts, daily or intraday | Needs a separate request to the bank |
| Bank web service | Account activity pulled by a service | Intraday tracking | One connection per bank |
| Open banking | Authorised provider through BKM's gateway | Several banks, one channel | You give consent and choose accounts |
| Accounting software's bank tool | Logo Online Account Statement, Paraşüt bank link | If you already run that software | Rules limited to what the tool offers |

## Matching Rules: Exact Keys First, Then Amount

Rules run in order and stop at the first exact match. Guessing comes only after the exact keys run out, and always with a confidence level.

The order matters because an invoice number or a saved IBAN points to one account, while an amount often points to several. For a customer with two open invoices of the same amount, the amount alone decides nothing; the transaction is suggested against the invoice due soonest and waits for approval. The more complete the tax numbers and IBANs on your account cards, the more transactions close on an exact key, so cleaning the account cards is one of the first jobs.

1. **Clean the Transaction**: Date, value date, amount, currency, counterparty IBAN and name, description and bank reference are split into fields.
2. **Exact Key**: The description is searched for an invoice number, tax number or account code; the counterparty IBAN is checked against account cards.
3. **Amount and Date**: The account's open invoices are searched for a matching amount and a nearby due date.
4. **Combined and Partial**: One transfer can close several invoices; a short payment closes one in part. *No single candidate goes to a person*
5. **Post and Close**: An approved match posts as a collection or payment and the invoices it covers are closed.

## The Hard Cases: Partial Payments, Bulk Transfers, Withholding, Exchange Differences

The cases that make matching hard look much the same in every company. We follow a month-end with your finance team and write a clear rule for each:

- Partial payment: the invoice closes in part and the remaining balance is tracked with its due date.
- Several invoices in one transfer: numbers in the description are parsed; if there are none, a set of invoices that adds up is suggested and a person approves it.
- Invoices with VAT withholding: the buyer does not pay the withheld VAT to the seller, so the transfer comes in below the invoice total by that amount. Matching uses the amount actually payable.
- Foreign-currency invoices: under Article 24/c of the Turkish VAT Law, exchange differences are part of the VAT base. If the rate on the day of payment differs from the invoice rate, an exchange-difference invoice (kur farkı faturası) may be needed. The system calculates and flags the difference; your accountant sets the rule.
- Card and direct debit collections: card (POS) amounts arrive net of commission and batched; with direct debit (DBS) collections, some banks send the invoice number as its own field.
- Internal transfers and fees: a transfer between your own accounts (virman) is not a customer movement; bank fees and commissions go to an expense account.

## The Exceptions Queue: What Stays With People

Rules close the routine; transactions that need judgement gather in one queue. It is the same team, spending its time on that queue instead of searching Excel rows. Every decision records who made it and why.

Each transaction in the queue says why the system could not decide: no candidate, several candidates, or an amount above the open balance. The person reads the reason and matches, splits or marks it as an advance.

Repeated decisions become rules. When a person matches a payment from a new IBAN to an account, that IBAN is added to the account card once approved, and the next payment from it matches on its own.

AI does one job here: it reads free-text descriptions, finds invoice numbers written inconsistently or company names shortened, and suggests an account. A person approves the suggestion.

- A collection with no description whose amount fits several invoices
- An IBAN not saved on any account card
- A payment above the open invoices: advance or overpayment
- A payment from a group company instead of the debtor
- An exchange difference above the agreed threshold
- A refund to a customer or a returned payment

## How Matches Post to Logo, Mikro, Netsis and Paraşüt

An approved match posts as the software's own document: a collection, a payment or a bank voucher, and the invoice closing. Posting always uses the software's official route, never direct writes to its database tables.

- Logo: Online Account Statement transfers bank transactions into the ERP; Logo Objects is the route for entries from outside systems.
- Mikro: the collection and payment (tahsilat-tediye), voucher (dekont) and account endpoints of the Mikro API.
- Netsis: NetOpenX and the Netsis REST API for entries from outside systems.
- Paraşüt: API v4 covers collections and payments on contacts, payments on sales invoices and cash and bank transactions. Paraşüt's own bank link also recognises the payer by IBAN or national ID number and matches the account.

The entry carries the story behind the match: which bank transaction it came from, which rule matched it and who approved it sit in the voucher description or a linked field. Anyone looking at a collection in the accounting software sees which statement line it came from without searching.

If your software's own bank tool covers what you need, use it first. A separate system earns its place where your rules go beyond that tool: bulk transfers, withholding, exchange differences, group companies or more than one accounting system.

## Daily Reconciliation: What the Report Should Show

Bank reconciliation proves that the balance at the bank agrees with the bank account in your books. When matching runs every day, so does reconciliation, and month-end becomes a check rather than a project. The daily report should show four things:

- For each account: bank balance, book balance and the difference
- Unmatched transactions and how long each has waited
- Open and overdue invoices by customer
- Exceptions in the queue and who owns each one

Statements carry individuals' names, IBANs and sometimes national ID numbers, so Turkey's data protection law (KVKK) applies. The system runs on your servers or your own cloud account, access is given by role and every action is logged.

## Process First, Then Software: Where to Start

We start by mapping today's flow. We sit with the finance team through a month-end and note who looks at what from the moment a collection hits the bank to the moment the account is closed: which file comes from which bank, how descriptions are read, which spreadsheet holds which list, and who gets asked about the unclear lines.

Then we start with the busiest bank account and the collections side. In the first weeks the system only suggests matches; the team posts as usual, compares, and we write every difference back into the rules. Once the suggestions agree with the team's decisions, the system is allowed to post, and then we add payments and the other banks.

Your banks, your accounting software and your chart of accounts stay as they are. The code, the rules and the log are yours, and another team or firm can take them over.

## Questions

### Do Turkish banks provide MT940 statements?

Many do for company customers. Ziraat Bankası, for example, sends MT940 and MT942 statements by email, FTP, SFTP, SWIFT or web service. Ask your bank's cash management team; for banks that do not, an internet banking export or the bank's web service is used.

### What does open banking require?

An account information service provider with TCMB permission and BKM registration, your consent, and your choice of which accounts to share. Ask the provider and your bank whether the service is offered for company accounts.

### Our accounting software already connects to our banks. Do we still need this?

Perhaps not. Logo Online Account Statement and Paraşüt's bank link handle basic matching. A separate system makes sense when your rules go beyond those tools, or when you run several companies or accounting systems from one place.

### Are supplier payments matched the same way?

Yes. Outgoing payments are linked to the supplier's account and open purchase invoices with the same rules. For bulk payment orders, the bank's bulk transfer reference ties each payment to its line in the order; Ziraat Bankası, for example, shows that reference as its own field in the statement.

### What happens if a match is wrong?

Nothing posts silently. Every match is logged with the rule that made it and can be reversed; low-confidence matches wait for approval.

## Sources

- [Official Gazette: Regulation on Payment Services and Electronic Money Issuance and Payment Service Providers (1 Dec 2021)](https://www.resmigazete.gov.tr/eskiler/2021/12/20211201-1.htm)
- [Official Gazette: Communiqué on Data Sharing Services in the Field of Payment Services (1 Dec 2021)](https://www.resmigazete.gov.tr/eskiler/2021/12/20211201-3.htm)
- [Ziraat Bankası: MT940/942 statement integration](https://www.ziraatbank.com.tr/tr/kurumsal/nakit-yonetimi/hesap-hareketleri-entegrasyonu)
- [Logo: Online Account Statement](https://www.logo.com.tr/en/product/online-account-statement)
- [Logo: Logo Netsis 3 Enterprise](https://www.logo.com.tr/en/product/logo-netsis-3-enterprise)
- [Mikro API: collections and payments (Tahsilat Tediye)](https://apidocs.mikro.com.tr/apis/tahsilat-tediye)
- [Paraşüt API V4 documentation](https://apidocs.parasut.com/)
- [Paraşüt: connecting bank accounts](https://www.parasut.com/kullanim-kilavuzu/banka-hesaplarinin-baglanmasi)
- [Paraşüt: bank reconciliation](https://www.parasut.com/kullanim-kilavuzu/banka-mutabakati-yapmak)
- [GİB: VAT General Implementation Communiqué](https://www.gib.gov.tr/mevzuat/kanun/436/teblig/9047)

## The System We Build

[Finance Operations](https://pragmaticgrowth.com/services/finance): E-invoices and reconciliations, imported by your rules.

[Explore the service](https://pragmaticgrowth.com/services/finance)

## Related Guides

- [Importing Turkish E-Invoices Into Logo, Mikro, Paraşüt and Netsis](https://pragmaticgrowth.com/guides/e-invoices-into-accounting-software): An incoming Turkish e-invoice is already a machine-readable UBL-TR file. Automatic import fetches it from your e-invoice integrator, links the supplier to its account by tax number, maps each line to stock, expense account and cost centre by rules you agree, separates VAT and withholding, and posts it through the accounting software's supported route; anything the rules cannot place waits for a person to approve.

[All guides](https://pragmaticgrowth.com/guides)

## Show Us How Your Team Works Today

In 45 minutes we find the process worth building first.

[Book a Call](https://cal.com/serkanhaslak/pragmatic-growth)