Money – Mutual Offset
​

A mutual offset is a fictitious bank statement used primarily to settle receivables and payables on the basis of mutual offsetting. The form contains buttons that allow you to choose how you want to create mutual offsets:

Select the company with which you want to perform a mutual offset

:

Company

Values are drawn from the Business Partners – Company Addresses menu.

Offset Date

The current date is preset automatically — it can be changed.

Currency

Select from the values recorded in the Tools – Code Lists – Currencies menu.

Click the "Next" button.

Select documents for mutual offset

:

Select documents

Receivables and payables from the Accounting module are displayed. Select the relevant payable/receivable here, and the Receivables, Payables, and Offset Amount fields will be pre-filled.

Click the "Next" button again.

Enter the required offset properties

:

Offset Number

Enter the offset number.

Offset Type

Select the offset type from the drop-down list.

Once the fields have been configured, click the "Finish" button. The relevant offset records will be generated.

The Mutual Offsets form will open.

__________________________________________________________________

Tab "Main"
​

Document Type

Required field

Select from the list of offset types.

Transaction Type

Receipt or Expense.

Document Number

The value is automatically filled in after selecting a document series.

You can predefine "your" document series in the logged-in user's settings. This eliminates the prompt asking which series to use, speeds up data entry, and also removes the possibility of entering an incorrect series.

Incoming Number

Offset Number

Variable Symbol

Generated automatically from the document number by removing all non-numeric characters.

Date Issued

For the first document in a series, the date is set from the computer's current date, provided the entered accounting period matches the current calendar year (otherwise, it is set to the last day of the entered accounting period). For subsequent documents in the series, the date is carried over from the previous document.

The posting date value is automatically generated from the date of issue.

If you enter a date that is later than the end of the accounting period, the application will set the last date of the current accounting period as the posting date. This applies to documents created after the end of the accounting period that are substantively within the period — for example, invoices for energy or telephone services that are not issued until the following month.

If the document does not fall within the selected accounting period, this is an error and you must switch to the correct accounting period and create the document there.

Tax Supply Date

Required if you are a VAT payer.

For the first document in a series, it is taken from the date of issue. For subsequent documents, it is carried over from the previous document.

Apply Tax Supply Date

This field is available only for the Expense transaction type.

Enter the date on which the taxable supply is to be applied.

Reference Number

Description

Enter additional details here to help navigate the document list more easily.

__________________________________________________________________

Tab "Note"
​

Note

Any note related to the inquiry. It is not printed on the document.

__________________________________________________________________

Tab "Attachments"
​

On this tab you can archive various documents related to the offset.

The toolbar at the top of the table contains a number of buttons, the meaning of some of which is described in the separate chapter "Program Controls".

Using the "New" button, you can add a new attachment. When adding an attachment, you can choose from the following options:

Each inserted attachment has a folder icon that allows you to view the attachment at any time. You can also use the folder icon to save the attachment to a different location. The scan button is used to scan the document, and the second option allows you to select a scanner and configure the scanning parameters.

__________________________________________________________________

Tab "Company"
​

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, leave this field blank). You can enter an abbreviation or company name (or just part of an abbreviation or name) and select the desired company from the suggested records. You can also open the company list (using the icon on 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 recorded in the business partners' Address Book with the value Customer, Supplier, or Customer/Supplier selected in the Relationship Type field are shown.

Name

Enter the exact company name. The field is filled in automatically when you select a company 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, your web browser will open a search results page in ARES (Administrative Register of Economic Entities) with data from the commercial register, trade register, VAT payer list, etc.

Street

Enter the street address of the company's registered office, 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 the City and Street fields, your web browser will open the Mapy.cz portal with a map of the company's registered office.

City

Enter the name of the city or municipality where the company is registered. When entering a 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 city name including any relevant district based on the letters entered, and will also fill in the corresponding Postal Code value.

Postal Code

Enter the postal code of the company's registered office (or the local equivalent for foreign companies). When a valid postal code is entered, the City field will be filled in automatically. The autocomplete feature can also be used when entering a postal code: 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 districts.

Country

Select the country where the company is registered from the drop-down list. If you selected a city or postal code from the autocomplete, the Czech Republic or Slovakia will have been filled in automatically. To speed up the search, you can type the first letters of the country name and the application will move to the first matching country.

Company ID (IČO)

Enter the business partner's company registration number — a unique eight-digit identification number assigned to a legal entity, self-employed individual, or state organizational unit by the Czech Statistical Office, commercial register, or trade licensing office (older numbers with fewer digits are padded with leading zeros). If you click on the blue underlined Company ID field label when a value for a Czech company is entered, your web browser will open an ARES (Administrative Register of Economic Entities) search results page based on the company ID, with data from public registers. For a Slovak company, a similar page with search results from the Business Register will be displayed.

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 consists of the country abbreviation followed by the digits of their national ID number.

If you click on the blue underlined VAT Number field label when a value for a Czech company is entered, your web browser will open the Czech Ministry of Finance's registered entity search form, where you must enter the partner's VAT number and click the Search button to display information about the VAT payer and their registration. For companies registered in other countries, the VAT number verification result from the European Commission's VIES system will be displayed.

EAN

Enter the International Article Number if you communicate electronically with the business partner or need to include their identification in the form of a barcode on documents (for scanning with a reader).

__________________________________________________________________

Tab "Company Account"
​

Supplier Account

The supplier's bank account number.

Account Number

The company's bank account number.

Bank Code

A four-digit number that uniquely identifies the bank.

Constant Symbol

Identifies the nature and method of payment; it has not been mandatory to fill in since March 2014.

IBAN

International bank account number defined by the international standard ISO.

BIC

Unique identification of the recipient's bank.

Specific Symbol

A number of up to ten digits, such as a national ID number, contract number, company registration number, or account number.

__________________________________________________________________

Tab "Specification"
​

Posting Template

Optional field. Available for accounting documents only.

Simplifies the 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 creation of a new posting template.

Cost Center

Required field for posting the document.

Allows you to assign the document within the cost center structure of the company being accounted for. This field must be filled in to post the document, even if the company does not use cost center classification (in that case, the cost center named "Headquarters" is selected automatically).

Activity

Optional field.

Allows items to be categorized by activity.

The drop-down list displays values from the Tools – Code Lists – Activity code list.

Job Order

Optional field.

You can select the relevant job order from those recorded in the Sales – Job Orders code list. You can enter an abbreviation or job order name (or just part of an abbreviation or name) and select the desired job order from the suggested records. You can also open the job orders code list (using the magnifying glass button or by pressing F2) and search for a job order using filters, or edit an existing one or add a completely new record.

Tags

Optional field.

Used to label documents with tags, which are then displayed in the field and can be particularly useful for filtering.

Clicking the Attach button opens the tag selection form. The left field displays Available Tags, while the right field shows the tags assigned to the current document. You can assign or remove tags using the arrow buttons between the two fields. If you use tags extensively, you can use the Groups drop-down list to display only tags from a selected group. Once you have configured the tags, confirm by clicking "OK".

If you need to add a tag that is not yet in the Available Tags field, use the "Manage Tags" button. The tags code list (menu Tools – Code Lists – Tags) will open, where you can add the required tag.

__________________________________________________________________

Tab "Posting and VAT Line"
​

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 checked in Company Settings, the available options will be limited to relevant countries based on the current document values.

When the company being accounted for 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 and can be changed manually.

VAT Control Statement Line

VAT payers only. Field is not required.

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 control statement lines code list, restricted to lines corresponding to the currently selected VAT country and document type, with lines corresponding to the document's transaction type listed first.

If you are unsure which control statement line to select, leave the field blank — before creating 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, a check will be performed to verify that the total document amount meets the condition for 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

The date on which the accounting transaction took place.

Bank Account

Contra Account

Credit Account

This field is automatically transferred to the document line item in the Credit Account field. When matching an invoice with a bank statement, cash register, or internal document, it is transferred as the "contra account" debit entry to the bank, cash register, or credit account of the internal document, in order to maintain the accounting balance.

Standard VAT

The account is automatically transferred to the document line item in the Credit Account field when the line item carries the "Standard VAT Rate".

Reduced VAT

The account is automatically transferred to the document line item in the Credit Account field when the line item carries the "Reduced VAT Rate".

Place of Supply – Domestic

Displayed for 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 printed reports.

Exclude from Balance

When this flag is checked, the document will not be reflected in the balance.

__________________________________________________________________

Tab "Responsible Person"
​

Responsible Person

The user responsible for the given receipt/issue document; persons from the Tools – People and Users menu are available.

Contact Person

The name of the user to contact regarding the given document.

Name

Phone

E-mail

__________________________________________________________________

Tab "CZK"
​

The tab displaying the home currency (usually labeled "CZK") provides a financial overview of the entire document and a breakdown of amounts by VAT rate. After the first document line item is added, most fields on the tab become read-only and their values are updated with each change to a line item.

For entering a document without line items, amounts are entered directly into the tab's fields (with the exception of the base sum and VAT sum). After changing the amount in one of the fields, the remaining fields are cross-calculated (note, however, that if you manually change the VAT amount, the sum of amounts in the row will be correct, but the amounts will not correspond to the percentage VAT rate). For so-called line-item-free documents, the application automatically creates items of the type "Accounting Item", 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 useful, for example, for accounting firms entering a document brought in by a client.

The remainder of the tab consists of fields in three columns:

The fields are arranged in rows labeled with specific VAT rates:

Calculation and rounding method for amounts on documents without line items:

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 the 21% rate, the base = 0.1736 × total; for the 15% rate, the base = 0.1304 × total).

The rounding defined for the document type is not applied to documents without line items; the calculation described above is used instead. You can adjust the final amount after calculation to suit your needs.

__________________________________________________________________

Tab "Currency"
​

Currency

Determines the currency of the document amounts. The default value is the home (domestic) currency entered in Company Settings; if left as the default, the remaining fields on the tab will be 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 accessible.Exchange RateThe pair of fields allows you to specify the exchange rate for the home currency against the selected currency. After selecting a currency, the exchange rate for the document's date of issue is downloaded from the internet, but it can be edited or entered manually. If the exchange rate cannot be retrieved, the home currency field will be highlighted with a colored border and set to 0.00.

The remainder of the tab consists of fields in three columns:

The fields are arranged in rows labeled with specific VAT rates:

For so-called line-item-free documents, the values in the fields can be edited with the exception of the base sum and VAT sum; the remaining fields are cross-calculated (however, changing the VAT amount will result in the sum of amounts being correct, but not the percentage VAT rate). For documents with line items, the amount fields are read-only and display values based on the document's entered line items.