Money – Bank
This form contains a list of bank statements with all the information relevant to recording non-cash payments. A bank document can be matched with invoices, receivables, liabilities, or you can create an advance tax document from a bank document used to pay an advance invoice.
__________________________________________________________________
Utility Functions
The document list has a top toolbar with function buttons and filter drop-downs. Both are used to quickly launch frequently used functions and apply selections.
__________________________________________________________________
"Links" Function
When documents are created and updated, links are established between individual documents. These include:
Paying document
Issued and received invoices, receivables, and liabilities, once settled, are linked to bank documents and the cash register (internal documents).
Exchange rate differences
When invoices in foreign currencies are paid, exchange rate differences arise due to changes in exchange rates. Internal accounting documents are created to handle these correctly.
Year-end revaluation (if the document is in a foreign currency)
When foreign currency invoices are not fully settled by year-end. Due to exchange rate changes, the price differences must be included in the total invoice amount at year-end. Internal accounting documents are used to post these correctly.
Goods issue notes, goods receipt notes
When an invoice is created with price-list "stock" items, goods issue notes or goods receipt notes are created automatically.
Advances, advance tax documents
The application displays a list of all documents that are "linked" to the current document (where the cursor is positioned). Double-clicking a linked document displays another list containing the target document. A further double-click opens the document window. In this way, you can view the complete history of a document.
Example of how ABRA Flexi maintains links between documents:
First, you record a customer inquiry.
Based on it, you create your quote (or several variants).
You then receive the customer's order.
To fulfil it, you send inquiries to your suppliers.
Based on the most favourable supplier quotes received, you place orders by creating issued purchase orders.
Goods delivered by suppliers will be accompanied by received invoices, which will be linked to several goods receipt notes upon being stocked.
It is time to deliver the goods to the customer: the issued invoice is linked to the warehouse goods issue notes.
The issued invoice is later settled via bank transfer. If it is in a foreign currency, exchange rate differences may arise, or if payment is made in the following year, document revaluation may also occur.
When viewing any document in the middle of the described chain, you can use the Links function to navigate the chain and view related documents. This ABRA Flexi feature makes it easier to search for and review documents.
__________________________________________________________________
"Totals" Function
A button for summing documents is available on the right side of the top toolbar. For more information about this function, see the chapter Documents -> Totals in Document List.
__________________________________________________________________
"Bulk Changes" Function
The bulk change function is designed for quickly changing the value of a specific field across many items at once. A description of its use can be found in the chapter Bulk Changes.
__________________________________________________________________
"Services" Function
Services Function – Create Payment Link
Using this option, you can create or remove a link between a paying document and a document being paid. First, a dialog box "Select receivable/liability for payment matching" is displayed, where you choose the relevant document to be matched with the selected payment. This service offers the same functionality as the "Match" / "Unmatch" button on individual documents.
Services Function – Manual Payment Link Creation
Using this option, you can manually create a link between a payment and the documents being paid. For example, if a customer pays several invoices at once, it is possible to match these invoices to a single bank transaction. After clicking the button, a table opens in which you select which document you want to link to the cash document. If a difference arises after linking the payment, you have the option to post the difference and the overpayment.
Services Function – Automatic Payment Link Creation
This option enables automatic matching of a payment with a received/issued invoice. A notification about the matching is displayed on screen, and the "How Settled" column is populated with information for the user — for example, automatically by variable symbol, meaning that matching was performed based on a matching amount and matching variable symbol.
Services Function – Create/Remove Advance Tax Document Link
This option allows you to create an advance tax document from a payment made against an advance invoice.
Services Function – Create Invoice from Settled Advances
If an advance invoice is fully settled, a final invoice is created immediately, with the advance invoice already deducted. If the advance invoice contains price-list items — which may include items with a serial number — a goods issue note is also created at the same time, and you are prompted to select any applicable serial number.
The prerequisite for this method of invoice creation is that the advance invoice must be fully settled, must not be item-free, must not have a warehouse document linked to it, and must not have already been deducted. The amount in the line items of the final invoice created this way cannot be changed. The invoiced amount must therefore equal the settled advance amount.
Services Function – Create Overpayment
This option allows you to create an overpayment, whereby the unmatched portion of the payment is moved to other receivables or liabilities. After clicking the Create Overpayment button, a window appears for selecting the document type (unless you have this configured in the automatic operations in Company Settings). After selecting and confirming the document, a notification is displayed confirming that the overpayment document has been created.
Services Function – Import Statements
To use this function, your bank account must be set up in the bank accounts list. On the "Electronic Banking" tab, select the format corresponding to your bank. Once the format is selected, the file extension supported by that bank is automatically set, and you can choose the directory (using the folder button) from which statements will be loaded from your computer and where payment orders will be saved.
Services Function – Download Online Statements
This function allows you to download online statements if you use Fio Bank. A more detailed description of the setup required to use this function successfully can be found in the help section under "Bank" – "Automatic Import of Fio Bank Statements".
__________________________________________________________________
"Services" Function on a Document
Only the functions available when a document is open are listed here.
Services Function – Document Allocation
This function can be used on a document that does not contain price-list items. It allows you to allocate the document across individual line items. After clicking the button, a "Document Allocation" form is displayed, where you select: Posting template, Base amount (CZK), Credit of base, VAT lines, VAT control statement line, Cost centre, Activity, and Job order.
You can add another line using the "Add Item" button.
__________________________________________________________________
Filter Drop-Downs
The filter drop-downs allow you to easily and quickly filter the displayed documents. Set the filters according to your current needs; the last used filter will also be applied the next time you open the list. You can filter by the following parameters:
Calendar year (document issue date)
Years are offered in descending order from the next calendar year (based on the computer date) back to 1990.
Date (document issue date)
For the current accounting period only: Last 7 days, last 35 days, current day, current week, current month
Always: 12 calendar months, 4 quarters (in the year of the selected accounting period or the year selected in the filter)
VAT period
12 calendar months, 4 quarters (in the year of the selected accounting period or the year selected in the filter). The decisive date is the date of the taxable supply.
Account
Individual registered bank accounts are offered.
Document type
Individual registered document types are offered.
Transaction type
Receipt, Payment
Matching
Matched documents, Unmatched documents
Manual – 1 document, Manual – multiple documents, Manual – partial payment, Automatic by variable symbol, Automatic by amount, Automatic by customer number, Automatic by internal document number
The filter drop-downs offer an unrestricted item as the first option. You can select exactly one item in each drop-down; for advanced filtering, use the global filter function.
__________________________________________________________________
"Bank Statement Item" Card
Like all other modules, the Bank module shares General Document Properties with them.
For further detailed information, we recommend using the following links:
Bank statement documents usually do not contain line items. They only contain items when allocation is required.
__________________________________________________________________
Bank Statement Item
__________________________________________________________________
Panel 1, "Main" Tab
Document type
Select the required document type from the drop-down list. The options available are those you have registered in the bank document types list.
Transaction type
Select whether this is a receipt or a payment.
Bank account
Select one of your bank accounts from the drop-down list — those registered in the bank accounts list.
Document number
After selecting a bank account, the next number in the document series is automatically filled in.
Received number
The counterparty's document number.
Statement number
Enter the bank statement number. If the bank statement was imported, this value is read-only.
Ref. numberVariable symbol
Enter the variable symbol.
Issue date
Enter the issue date of the bank statement. You can enter the date manually or select it from the calendar, which you open using the calendar icon.
Date of taxable supply
Enter the date of taxable supply. You can enter the date manually or select it from the calendar, which you open using the calendar icon.
Apply taxable supply
This field is available only for the Payment transaction type.
The date you select for the taxable supply, i.e. the date on which you are claiming the right to deduct VAT. You can change the value as needed within the statutory limits; the taxable supply can be claimed no earlier than the date the document is received and no later than 3 years after the end of the tax period in which the right to deduct tax arose.
Description
In this field, you can enter a description of the transaction.
__________________________________________________________________
Panel 1, "Note" Tab
In this tab, you can enter any note related to the bank statement item.
__________________________________________________________________
Panel 1, "Attachments" Tab
In this tab, you can archive various documents related to the given bank document.
The top toolbar of the table contains a number of buttons; the meaning of some of them is described in a separate chapter "Application Controls".
Using the "New" button, you can add a new attachment. When adding an attachment, you can choose from the following options:
File – a file from your local computer is loaded into the database,
Internet link – the application stores a link (URL); the data of the linked source is not loaded into the application,
File link – the application stores a link to a file on the local computer's disk; the file data is not loaded into the application (do not rename, move, or delete the linked file).
Next to the attached file, there is a folder icon that allows you to view the attachment at any time. Using the folder icon, you can also save the attachment to a different location. One button is used to scan the document; the second option allows you to select a scanner and scanning parameters.
__________________________________________________________________
Panel 2, "Company" Tab
Company
You can select a business partner from the Address Book (the following fields will be filled in automatically), or you can enter the partner's details manually (in which case you leave this field empty). You can enter an abbreviation or company name (or just part of it) and select the required company from the suggested records. You can also open the company list (using the icon to the right or by pressing F2) and search for a company using filters, edit the business partner's company before selecting it, or add a completely new record; to select a company from the list, simply double-click its record.
Only companies registered in the Address Book of business partners that have the value Customer, Supplier, or Customer/Supplier selected in the Relationship type field are offered.
Name
Enter the exact name of the company. This field is filled in automatically when a company is selected from the address book; otherwise, fill it in manually.
Note: If you click on the blue underlined Name field label after entering the company name, a page will open in your web browser showing search results in ARES (Administrative Register of Economic Entities) with data from the commercial register, trade register, VAT payers list, etc.
Street
Enter the street of the company's registered address, including the building number, orientation number, or a combination of both.
Note: If you click on the blue underlined Street field label after filling in both the City and Street fields, a page will open in your web browser showing the Mapy.cz portal with a map of the company's registered address.
City
Enter the name of the city or municipality where the company is registered.
When entering the city name, you can use the autocomplete feature: start typing the name of the city, municipality, or district into the field and the application will suggest the full name of the city along with its district, and will also fill in the corresponding value in the Postal code field.
Postal code
Enter the postal code of the company's registered address (or the local equivalent for foreign companies). When a valid postal code is entered, the City field is automatically filled in. When entering the postal code, you can again use the autocomplete feature: start typing the first digits of the postal code or the beginning of the city name and the application will suggest possible cities, municipalities, or their districts.
Country
Select the country where the company is registered from the drop-down list. If you selected the city or postal code from the autocomplete, the Czech Republic or Slovakia will have been filled in automatically. To speed up your search, you can type the first letters of the country name and the application will move to the first matching country.
Company registration number (IČO)
Enter the business partner's company registration number — the unique eight-digit identification number assigned to legal entities, self-employed individuals, or state organisational units by the Czech Statistical Office, the commercial register, or the trade licensing office (older numbers with fewer digits are padded with leading zeros). If you click on the blue underlined IČO field label while a value is entered for a Czech company, a page will open in your web browser showing search results in ARES (Administrative Register of Economic Entities) by registration number, with data from public registers. For a Slovak company, a similar page will be displayed with search results from the Business Register.
VAT number (DIČ)
Enter the business partner's VAT number, if they are a VAT payer. The tax identification number is assigned by the tax authority to every individual or legal entity required to pay taxes. The VAT number of legal entities consists of the country abbreviation + company registration number; the VAT number of individuals is formed by the country abbreviation followed by the digits of the birth certificate number.
If you click on the blue underlined DIČ field label while a value is entered for a Czech company, a search form for registered entities from the Czech Ministry of Finance will open in your web browser, where you need to enter the partner's VAT number and press the Search button to display information about the VAT payer and their registration. For companies registered in other countries, the VIES VAT number verification result from the European Commission will open.
EAN
Enter the International Article Number if you communicate electronically with the business partner or need to include their identification in barcode form on documents (for scanning with a reader).
__________________________________________________________________
Panel 2, "Company Account" Tab
Supplier account
If you have bank accounts entered for the selected business partner, the primary bank account for that partner is automatically selected. To choose a different account, select it from the drop-down list. After selecting an account, the following fields are automatically filled in.
Account number
Bank code, constant symbol
IBAN
BIC
Specific symbol
__________________________________________________________________
Panel 3, "Specification" Tab
Posting template
Optional field. Available for accounting documents only.
Simplifies posting of individual documents by automatically filling in the document description, posting accounts, and VAT line according to the selected posting template. Select a posting template from the drop-down list. Press F2 to open a table view of the list for more advanced selection, editing, or creating a new posting template.
Cost centre
Required field for posting a document.
Allows you to assign the document within the cost centre structure of the company being posted. This field must be filled in for posting even if the company does not use cost centre tracking (in such cases, the cost centre named "Head Office" is selected automatically).
Activity
Optional field.
Allows you to categorise items by activity.
The drop-down list offers values from the Tools – Code Lists – Activity code list.
Job order
Optional field.
You can select the relevant job order from those registered in the Sales – Job Orders code list. You can enter an abbreviation or job order name (or just part of it) and select the required job order from the suggested records. You can also open the job orders code list (using the magnifier button or by pressing F2) and search for a job order using filters, or edit or add a completely new record.
Labels
Optional field.
Used to tag documents with labels, which are then displayed in the field and can be particularly useful for filtering.
After clicking the Attach button, a label selection form opens. The left panel shows Available labels, and the right panel shows labels assigned to the current document. You can assign or remove labels using the arrow buttons between the two panels. If you use labels extensively, you can use the Groups drop-down list to display only the labels belonging to a selected group. Once you have set the labels, confirm with the "OK" button.
If you need to add a label that is not yet in the Available labels panel, use the "Manage Labels" button. The labels code list opens (menu Tools – Code Lists – Labels), where you can add the required label.
__________________________________________________________________
Panel 3, "Posting and VAT Line" Tab
VAT country
Required field for VAT payers on accounting documents.
The country in which value added tax will be remitted.
The value in this field is automatically set to the legislative country specified in Company Settings on the Legislation tab. The value can be changed by selecting from the drop-down list.
If the Restrict VAT country selection option is enabled in Company Settings, the selection will be limited to relevant countries based on the current document values.
When the company being posted is registered for MOSS, the appropriate VAT country may be automatically selected based on the business partner's country and their VAT registration status.
VAT lines
VAT return lines are filled in according to the selected posting template; you can change them manually.
VAT control statement line
VAT payers only. Field is not mandatory.
This field is used to specify the line of the VAT control statement form into which the VAT base amounts and VAT amounts will be loaded. It also serves as the default value for the Control statement line field on the Posting/Details tab of document line items being added.
The VAT control statement line value will be set according to the value defined for the selected document type; the value can be changed using the drop-down arrow. The available values are loaded from the VAT control statement line code list, limited to lines corresponding to the currently selected VAT country and document type, with lines matching the document's transaction type offered first.
If you are unsure which VAT control statement line to select, leave the field empty — before generating the VAT control statement, you will be notified about documents without a selected VAT control statement line and will be able to set the correct line. If the document has no impact on the control statement, select line 0.0. When saving a document with the Czech Republic as the VAT country, the system will verify whether the total document amount meets the condition for the value of the selected VAT control statement line. You will also be notified if the selected control statement line does not correspond to the document's transaction type.
Posting date
:
Cash account
Contra account
Standard VAT
Reduced VAT
Second reduced VAT
Domestic place of supply
Displayed on documents with a foreign business partner.
By checking this box, you indicate that the service was provided domestically, which means the mandatory VAT recapitulation data will be displayed in print reports.
Exclude from balance
When this flag is checked, the document will not be reflected in the balance.
__________________________________________________________________
Panel 3, "Responsible Person" Tab
Responsible person
This field is automatically populated with the user who is creating the document.
Contact person
The name and contact details of the customer's representative. The person listed as primary in the customer's contacts is automatically selected. You can choose from the contact persons listed for the given customer. Selecting a person fills in the following details: name, phone number.
__________________________________________________________________
Panel 4, "CZK" Tab
The tab for the domestic currency (usually labelled "CZK") provides a financial overview of the entire document and a breakdown of amounts by VAT rate. After the first line item is added to the document, most fields on this tab become read-only and their values are updated with every change to a line item.
For entering a document without line items, amounts are entered directly into the tab fields (with the exception of the base total and VAT total). When an amount is changed in one of the fields, the remaining fields are cross-calculated (note, however, that if the VAT amount is manually changed, the sum of the amounts in the row will be correct, but the amounts will not correspond to the percentage VAT rate). For so-called item-free documents, the application automatically creates items of the "Accounting item" type, the number of which corresponds to the number of VAT rates used (or the entry of amounts for VAT-exempt goods and services). A document without line items is suitable, for example, for accounting firms entering documents brought in by clients.
The rest of the tab consists of fields in three columns:
Base
VAT
Including VAT
The fields are arranged in rows labelled with specific VAT rates:
Exempt (0 %)
Reduced rate
Second reduced rate
Standard rate
Total
Calculation and rounding method for item-free documents:
Base
If the base amount is entered first, the corresponding VAT will be calculated exactly.
VAT
If the VAT amount is entered first, the corresponding base will be calculated exactly.
Including VAT
If the amount including VAT is entered first, the corresponding base and VAT will be calculated using a coefficient (for a 21% rate, the base = 0.1736 × total; for a 15% rate, the base = 0.1304 × total).
The rounding defined for the document type is not applied to item-free documents; the calculation described above is used instead. You can adjust the final amount after calculation as needed.
__________________________________________________________________
Panel 4, "Currency" Tab
Currency
Determines the currency of the document amounts. The default value is the domestic currency entered in Company Settings; if left as the default, the remaining fields on the tab remain unavailable. If you want to create the document in a different currency, select a value from the list of available currencies. Once selected, the remaining fields on the tab will become available.
Exchange rate
The pair of fields allows you to specify the exchange rate for the domestic currency against the selected currency. After selecting a currency, the exchange rate for the document's issue date is downloaded from the internet, but it can be adjusted or entered manually. If the exchange rate cannot be retrieved, the domestic currency field will be highlighted with a coloured border and set to 0.00.
The rest of the tab consists of fields in three columns:
Base
VAT
Including VAT
The fields are arranged in rows labelled with specific VAT rates:
Exempt (0 %)
Reduced rate
Second reduced rate
Standard rate
Total
For so-called item-free documents, the values in the fields can be edited, with the exception of the base total and the VAT total; the remaining fields are cross-calculated (however, when the VAT amount is changed, the sum of the row amounts will be correct, but the percentage VAT rate will not be maintained). For documents with line items, the amount fields are read-only and display values based on the entered document line items.
__________________________________________________________________
"Bank Document Item" Card
__________________________________________________________________
"Main" Tab
The VAT classification, accounts, cost centre, and job order are automatically copied from the document header. Each field has the "Copy value from document header" option checked. If you want to change the value on the line item, you must uncheck this option. Checked values will be automatically updated on the line item when they are changed in the document header.
Name
VAT rate
Total price




