Skip to main content

Matching Symbol in Balance

How a matching symbol is created, why a document remains in the unpaid balance even after payment, and how to fix the situation.

Written by Petr Pech

The accounting output "balance" (saldo) does not group documents by variable symbol, but by matching symbol. This symbol is calculated automatically and may differ from the variable symbol in certain situations. The following article explains how the matching symbol is determined, why a document may remain in the outstanding balance even after payment, and how to resolve the issue.

ℹ️ For a general description of the output, its parameters, and print reports, see the article Balance (Saldo).


What is the matching symbol

The matching symbol is the key by which the balance groups accounting entries on a balance-tracked account. If the sum of a group is zero, the group is considered settled and will drop out of the outstanding balance.

The matching symbol is not a standalone field on a document. It cannot be entered or overwritten, as it is calculated only when the balance is generated — derived from the variable symbols of the document and its payment.


How the matching symbol is determined

One payment covers one document

When a payment is matched, it adopts the variable symbol of the document being paid. Both the document and the payment therefore fall into the same group, their sum is zero, and they will not appear in the outstanding balance.

One payment covers multiple documents

If a single payment covers several documents with different variable symbols, a single matching symbol must be assigned to the entire resulting group. This symbol is taken from the payment — that is, from one of the documents being paid. The remaining documents are therefore assigned a matching symbol that does not correspond to their own variable symbol.

Example

  • Issued invoice A with variable symbol 2026001 for CZK 1,500

  • Issued invoice B with variable symbol 2026002 for CZK 3,000

  • One received payment of CZK 4,500 used to pay both invoices at once

Both invoices and the payment receive the matching symbol 2026002. As long as the relationship is solely between the invoices and their payment, the balance will be settled and the documents will drop out of the outstanding balance.

A problem arises when one of the documents has a counterpart entry elsewhere — typically a deduction on a billing invoice or an internal document. That counterpart carries its own variable symbol and therefore does not fall into the same group. The group does not balance out, and the documents remain in the outstanding balance even though the accounting state is correct.

⚠️ This is the most common reason why documents remain stuck in the outstanding balance. The matching process itself is described in the article Matching a payment to multiple invoices.


How to identify this as the cause

  1. Generate the balance without filtering by payment status — include paid documents as well.

  2. Display the Variable Symbol and Matching Symbol columns side by side.

  3. Compare the documents that belong to the same business transaction.

If their matching symbols differ, you are dealing with the situation described above. Also check the total balance of the balance-tracked account in the trial balance. It is typically zero, because it is not the accounting state that is broken — only the key by which entries are grouped.


How to resolve the issue

Splitting the payment into individual transactions

Split the combined payment into as many transactions as there are documents being paid, and match each transaction to its document individually. Each individual transaction will adopt the variable symbol of the document it belongs to, so each document receives its own matching symbol and drops out of the outstanding balance. The original payment details, including the variable symbol, are retained in the individual transactions, so the link to the bank statement is preserved.

Going forward, follow this simple rule: one payment corresponds to one document.

💡 For settling advance payments, a free add-on is available: Advance Payment Split. It locates the advance payment by the payment's variable symbol and immediately matches the split payment against it. It splits the payment into two parts, so it cannot be used to split a payment across multiple standard invoices.

Cleaning up historical documents

For documents that have already been matched, the payment must first be unmatched before the matching can be redone. For larger volumes of documents, the free add-on Bulk Bank and Cash Unmatching can help.

⚠️ Before making changes to already posted and closed periods, test the process on a copy of the company and verify the result against the trial balance. The process for identifying discrepancies is described in the article Checking for balance discrepancies.

What we do not recommend

Do not overwrite the variable symbol on a bank transaction just to improve the appearance of the balance. A bank transaction is a record of an actual payment, and changing it will cause a discrepancy with the bank statement. The process for changing the variable symbol on a document that has already been matched is described in the article Changing the variable symbol on a matched document.


Frequently asked questions

Why does a document remain in the outstanding balance even though it has been paid?

Most commonly because its matching symbol does not match the matching symbol of its counterpart entry. This typically happens when a single payment covered multiple documents with different variable symbols.

Can the matching symbol be overwritten manually or via a bulk update?

No. It is not an editable field — it is calculated only when the balance is generated. You can only influence it through the variable symbols on the documents and the way the payment is matched.

What determines the matching symbol for a mutual offset?

A mutual offset is treated by the application as a fictitious bank statement and behaves in the same way as a bank transaction. The matching symbol is derived using the same logic from the linked documents. The offset number does not enter the balance — it is used to link the entries of a single offset in the Mutual Offset Agreement print report. The clearing account through which the offset is posted must be set as a balance-tracked account; otherwise, the balance will not show the complete picture. The process is described in the article manual creation of a mutual offset.

An invoice and a credit note have the same amount and variable symbol. Is that sufficient?

For the balance, yes. Both documents are source documents, each contributing its own variable symbol to the matching symbol, so they fall into the same group with a sum of zero and drop out of the outstanding balance. However, in views that work with the payment status of a document, they will still appear as unpaid. The clean solution is a mutual offset, which reconciles both.

How do I remove an invoice from the balance that will never be paid?

Through a mutual offset, where the invoice appears on one side and the amount is simply posted through on the other. The process is described in the article Removing unpaid invoices from the balance.

Will the "Manually settled" or "Exclude from balance" flag help?

Neither of them addresses the root cause, and both will cause the balance to diverge from the trial balance. How they behave in individual outputs is described in the section Balance and other outstanding document views.

💡 If you are unsure how to adjust the history in your accounting records, please contact our support team. We will be happy to walk you through the process together.

Did this answer your question?