Skip to main content

Balance

Accounting Output – Balance in ABRA Flexi: How Documents Are Grouped by Matching Symbol, Which Accounts Are Included, How to Print It, and How It Differs from Other Accounting Outputs.

Written by Lenka Haringerová

The balance (saldo) is an accounting output used to determine the open-item status of documents. It provides a slightly different perspective on account movements and is primarily used when reviewing open receivables and payables and during financial closing. You can find it in the Accounting module under Accounting Outputs.

ℹ️ An overview of all accounting outputs is available in the overview guide. The balance can also be generated via API — see the article Balance in REST API.


How the balance groups documents

For a given balance account, the application groups all source entries and payments by their matching symbol. A group whose total is zero is considered settled and will not appear in the unpaid balance.

The matching symbol is derived from the variable symbols of the document and its payment — it is not a separately editable field on the document. When a single payment is matched to a single document, the payment adopts the variable symbol of the paid document, so both entries fall into the same group.

⚠️ If one payment covers multiple documents with different variable symbols, all paid documents will share a single matching symbol derived from the payment. As a result, documents may end up under a symbol that does not match their own variable symbol and remain in the unpaid balance even after being paid. The cause and resolution are described in the article Matching symbol in the balance.

Which accounts are included in the balance

Only accounts that have the Balance flag checked in the chart of accounts are included in the balance. By default, these are the open-item accounts for receivables and payables, typically 311, 315, 321, 325, 314, and 324.

Other accounts will not appear in the balance even if there are movements on them. This most commonly applies to account 261 (cash in transit) and the clearing account used for mutual offsets. If you need to track such an account in the balance, enable the Balance flag for it in the chart of accounts.

Documents in foreign currency

For foreign-currency documents, the group must net to zero both in the domestic currency and in the document's currency. If the payment does not have a corresponding value in the document currency, the group will remain open in the balance even if it balances in the domestic currency.

When reviewing, always add the columns Debit amount in currency, Credit amount in currency, and Currency code. Specific matching procedures are described in the articles Matching a foreign-currency document with a domestic-currency payment and Matching a foreign-currency document with a payment in another foreign currency.


Balance creation wizard

You can find the balance in the top navigation of the Accounting module under Accounting Outputs. Clicking Balance opens the Balance Creation Wizard, where you can specify the parameters for displaying the balance.

💡 For large databases, generating the balance may take some time. Limit your selection by posting date and the specific accounts you need to work with, rather than generating the balance for the entire period and all accounts.

Modules and payment status

Selected modules

Use the list selection to choose which modules the balance should cover. We recommend not filtering by module and always displaying all modules, especially when the payment status is set to "Unpaid".

Payment status

Use the drop-down list to select which payment status the balance should cover. You can choose between paid, unpaid, and all.

⚠️ If you select a payment status, it is better not to select specific modules to display, because some documents may be linked to, for example, an internal document (exchange rate difference). Selecting only received invoices, for instance, would cause those documents to be excluded from the results.

Document identification and dates

Internal number

Restricts the balance to a specific document by its internal number.

Variable symbol

Restricts the balance to documents with the specified variable symbol.

Matching symbol

Restricts the balance to a single group by matching symbol. This is the fastest way to view an entire business transaction including payments and verify whether it nets to zero.

Posting date from–to

You can enter the desired posting dates manually or select them using the calendar button.

Document issue date from–to

You can enter the desired issue dates manually or select them using the calendar button.

Note: If you are not looking for a specific document, it is better to enter either only the posting date or only the issue date. It is also recommended to enter only the TO date. In this case, all paid/unpaid documents in the selected module or across all modules will be displayed according to your selection.

Accounts and contra accounts

Accounts

Enter the accounts or a range of accounts here, separated by commas, or select them from the list.

Contra accounts

Enter the contra accounts or a range of contra accounts here, separated by commas, or select them from the list.

Selection type "List"

When defining the filter condition for accounting outputs, the List type is used by default. Clicking the Select button opens a dialog where all available values are shown in the left panel. Double-click or use the arrows to move values to the right panel. Clicking OK closes the dialog and transfers the values to the condition preview. The resulting filter includes records that match any of the conditions in the list. You can use the arrows to move all values from the left panel to the right and vice versa.

Cost centers and amounts

Selected cost centers

Use the list selection to choose which cost centers the balance should cover.

Debit amount from–to and Credit amount from–to

Restricts the balance to entries whose amount in the domestic currency falls within the specified range.

Debit amount in currency from–to and Credit amount in currency from–to

The same as above, but for amounts in foreign currency.

Jobs, companies, and description

Selected jobs

Use the list selection to choose which jobs the balance should cover.

Selected companies

Use the list selection of business partners to choose which companies the balance should cover.

Description

When filtering by description, pay close attention to diacritics and uppercase/lowercase letters.

OK – posted

Here you can choose whether the displayed documents should be posted or not.

Close the wizard by clicking the Finish button.


List of fields in the balance

  • Account

  • Matching symbol

  • Posting date

  • Module name

  • Posted

  • Document internal number

  • Variable symbol

  • Debit (CZK)

  • Credit (CZK)

  • Contra account

  • Due date

  • Payment date

  • Cost center

  • Job

  • Activity

  • Company name

📝 The company name displays the name as it appears on the document, not the current name from the address book. For documents entered via data capture, the same business partner may therefore appear under several different name variations. This does not affect grouping in the balance, which is governed by the matching symbol.

💡 If you need to find out why a document remains in the unpaid balance, display the Variable symbol and Matching symbol columns side by side and compare the documents of a single business transaction. A detailed description of how the matching symbol behaves in the balance can be found in this article.


Balance and similar accounting outputs

ABRA Flexi offers three outputs that display unpaid documents, and each of them works from a different basis. Their results may therefore legitimately differ.

Output

Where to find it

What determines document inclusion

Balance

Accounting, Accounting Outputs

matching symbol and the total of the entire group

Accounting, Accounting Outputs

document payment status, broken down by number of days past due

invoices, other receivables and payables agenda

document payment status as of the selected date

Simply put: the balance answers the question of which accounting entries on an open-item account have not been offset against each other. The other two outputs answer the question of which documents do not have a payment status of "paid." During closing, both views are compared together with the trial balance; the procedure for tracing discrepancies is described in the article Checking for differing balances.

Balance and account movements

The balance and Account Movements are two distinct records with the same tabular structure. They differ in their print outputs and filtering options.

Account Movements is a specialized view of the accounting journal and can only be filtered by period and accounts. The balance additionally offers filtering by modules, specific documents, companies, cost centers, jobs, amounts, and payment status, and — most importantly — groups entries by matching symbol.

Note: You can verify the shared structure of both records in the demo company: account movements and balance.


Other factors that may affect which documents are included in the balance

Manually marked as paid flag

Manually marking a document as paid does not replace actual matching with a bank or cash transaction. The document therefore has no link to a payment, its group does not net to zero, and it remains in the balance. Conversely, it will drop out of reports that work with the document payment status. The result is that the receivables overview looks clean, but the balance diverges from the trial balance. Details are described in the article Document status: Paid (manually).

Exclude from balance flag

When checked, the document is excluded entirely from the balance. However, this does not affect the account balance, so the balance will diverge from the trial balance. This flag is intended primarily for transfer and opening documents; we do not recommend using it to clean up the operational balance.


Print reports and export

The print dialog primarily contains the following elements: Report language and Available reports (see below). Other buttons and their purposes are described in the printing documentation.

Balance

A landscape report with the widest selection of columns. It includes account, matching symbol, posting date, module, posting status, document internal number, variable symbol, amounts in both the domestic currency and the document currency, currency code, due date, cost center, job, and company name. Use this report when you need to see foreign-currency amounts and a breakdown by cost center and job.

Balance (portrait)

A condensed portrait variant. It includes module, matching symbol, posting date, document internal number, variable symbol, amounts in the domestic currency, due date, and company name. It does not include foreign-currency amounts, cost centers, or jobs, making it more readable for routine review and easier to print.

Balance (grouped) and Balance (portrait, grouped)

These reports contain the same information as the previous two, but additionally group balance items by account, variable symbol, and document internal number. They are useful when a single document has multiple accounting entries and you need to see one summary line instead of individual items.

All four reports include subtotals per matching symbol and show a Difference [CZK] and Difference [currency] for each group. A non-zero difference means the group has not been settled. At the end of the report you will find a total for the entire account.

ℹ️ In addition to the default reports, the list also displays custom print reports prepared specifically for your company. If you need the balance in a different format than the default reports provide, contact us at podporaflexi@abra.eu and we will discuss your options.

For more detailed information about printing, see the help page Printing.


Frequently asked questions

How do I generate a balance as of a specific date?

In the wizard, fill in only the Posting date to field and leave the from field empty. The balance will be generated as of the selected date and will reflect the state as of that day. Follow the same approach for the issue date, but do not combine both date fields.

Why don't I see account 261 or the offset account for mutual offsets in the balance?

These accounts do not have the Balance flag enabled in the chart of accounts by default, so they are not included in the output. Enabling the flag will make them visible in the balance.

Can I manually match items in the balance?

No. The balance does not allow manual matching of items against each other. Settlement occurs exclusively when entries share a matching symbol and their total is zero. If a document is incorrectly remaining in the balance, you need to correct the way the payment was matched, or settle the remainder through a mutual offset.

Why does a foreign-currency document remain in the balance even though it balances in the domestic currency?

The group must also net to zero in the document's currency. Add the currency amount columns and check whether the payment has a corresponding foreign-currency value against it.

Which print report should I use?

For routine review, use the Balance (portrait) report — it is more readable. If you need to see foreign-currency amounts, cost centers, or jobs, use the Balance report. The grouped variants are suitable when a single document has multiple accounting entries.

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

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

💡 If the balance does not match the trial balance or the unpaid receivables report and you are unable to trace the discrepancy, book an individual consultation with us. We will be happy to help you identify the issue.

Did this answer your question?