Skip to main content

Bank

Form containing a list of bank statements with all data relevant for recording non-cash payments

Written by Zuzana Sýkorová

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:

  1. First, you record a customer inquiry.

  2. Based on it, you create your quote (or several variants).

  3. You then receive the customer's order.

  4. To fulfil it, you send inquiries to your suppliers.

  5. Based on the most favourable supplier quotes received, you place orders by creating issued purchase orders.

  6. Goods delivered by suppliers will be accompanied by received invoices, which will be linked to several goods receipt notes upon being stocked.

  7. It is time to deliver the goods to the customer: the issued invoice is linked to the warehouse goods issue notes.

  8. 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

Did this answer your question?