➕ Totals in the Document Table View

The top toolbar of the document table view contains a Totals button, which is used to summarize documents.

clicking the button will sum all documents currently displayed in the list,
if you select only certain documents using the selection feature, the sum will be calculated for that selection only.

ℹ️ Meaningfulness of the Totals

Just as the nature of documents varies (e.g. invoices, bank statements), so does the informational value of the individual summary dialogs.

The result is always a quick overview of key information, not a detailed breakdown.

💰 Usage by Document Type

Cash and Bank Documents

For cash and bank documents, the Totals feature provides the quickest way to check the current balance of:

a cash register,
a bank account
as of a given date.

Inventory Cards

In inventory cards, this is the quickest way to find out the value of goods in a specific warehouse.

📑 Breakdown of Totals by Document Type

In the displayed dialog, the total is always split into:

accounting documents
– documents intended for posting (this does not mean they have already been posted),
non-accounting documents
– documents marked as non-accounting at the time of creation
(most commonly advance invoices).

💼 Receivables and Payables – Total Structure

When calculating totals for receivables and payables, the following amount is always computed:

Total = The total amount of all accounting and non-accounting documents including advances, further broken down into:

Already paid – the amount that has been paid,
Remaining to pay – the amount that has not yet been paid.

🧾 Issued and Received Invoices

For issued and received invoices, an additional total is displayed:

Total excluding advances
– the total amount of accounting and non-accounting documents excluding advance payments.

🧮 Breakdown by VAT Rate

For accounting documents in receivables and payables, the amount is further broken down by VAT rate:

Total base – standard rate
Total VAT – standard rate
Total base – reduced rate
Total VAT – reduced rate
Total base – second reduced rate
Total VAT – second reduced rate
Total exempt

For accounting documents in receivables/payables, the above values are also summed up as:

Total excluding VAT
Total VAT

🏦 Bank and Cash Documents – Account Balances

For bank and cash documents, the following is always displayed:

opening balance,
closing balance,

broken down by:

individual cash registers,
or bank accounts.

For cash documents, amounts are additionally broken down by payment method:

cash,
payment card.

Opening Balance Date

This balance is always calculated as of the first date based on the selection in the table.

Examples:

with a filter set to year 2025, month unrestricted, first document dated 15 January 2025
→ balance as of 15 January 2025,
with a filter set to 4 February 2025 – 8 February 2025
→ balance as of 4 February 2025.

Balance as of Date

If no other selection is set in the filter:

this is the balance as of today's date,
i.e. the last known balance from the recorded documents.

📊 Additional Totals for Bank and Cash

The following totals are also displayed:
- Total accounting documents
  – income minus expenses,
- Total income,
- Total expenses.
All of these values are further broken down into:
- Total excluding VAT,
- Total VAT.

The Totals feature is of course also available for other document types, and the underlying principle remains essentially the same.

FAQ

Does the split into accounting and non-accounting documents mean that the documents have been posted?

No.
The split into:

accounting documents – documents intended for posting,
non-accounting documents – documents marked as non-accounting (e.g. advance invoices),

does not mean that the accounting documents have actually been posted. It refers only to their nature.

2. What does the "Balance as of Date" item mean?

Balance as of Date represents:

the current balance of a bank account or cash register,
the last known balance based on recorded documents,
if the filter is not restricted, it refers to the balance as of today's date.

3. Is the Totals feature available for document types other than invoices, bank, and cash?

Yes. The Totals feature is available for other document types as well.
The calculation principle remains the same; only the following differ: