How to post creditors with Vertec

Entering third-party invoices as creditors

Third-party invoices can be entered in Vertec and assigned to a project. A Creditor is entered for each invoice. If desired, these entries can be transferred directly to accounts payable. Third-party invoices only need to be entered once.

Reimburses expenses to employees. Expense refunds are directly payable.

Enter a creditor

You can create a creditor via the menu button New > Creditor:

The detail view appears.

Now you can either enter the values manually or import a receipt.

Import receipt

Click on the button Import receipt.... A file selection dialog appears (or in the Web App an “Upload file” dialog) where you can select the invoice receipt. Support Formats are .pdf, .png, .jpeg, .jpg and from Vertec 6.7.0.16 .xml (utf-8 encoded).

Automatic creditor recognition

As of Vertec 6.8.0.18. If the system setting Use creditor entry is activated (default), the imported data of the importing receipt are presented in the form of a dialog window. Without automatic creditor recognition, the data are processed according to the section Import receipt (without automatic creditor recognition).

The feature extracts the data from the posting using the following sources, if available:

  • QR code (Swiss QR or EPC QR code)
  • E-invoice (ZUGFeRD or XML)

In the case of automatic creditor recognition, the following dialog window appears after reading the posting:

The data found are displayed to the user.

If there is more than one source and the data found differ from each other, the user is provided with a selection. The corresponding fields are marked with a warning icon and the user can select the desired source from the drop-down menu.

If no data is available for a field or postings are imported without a QR code or e-invoices, the text No data found is displayed.

Field Description
Supplier recognized

If the supplier is found in the address list, it is entered in the field.

: If no supplier is found or the user wants to apply to another supplier, this can be done using this button.

: If there is no address entry for the supplier yet, it can be created directly via the button. If the supplier is already entered, this button remains deactivated.

Supplier selected

If a different supplier has been selected than previously detected by the automation, it will be shown here.

Project
Here, the project can be assigned to the creditor.
Text 

Here, the recognized document text is shown.

Date

Here, the recognized document date is shown.

Currency
Here, the recognized currency is shown.
Amount incl. VAT
Here, the gross amount recognized is shown.
Account
Here, the recognized account number is shown.
Outlays

​In the case of e-invoices, it is possible to select whether and how the invoice lines should be entered as outlays. 

There are the following options

  • Do not create outlays: As of Vertec 6.8.0.21. No outlays are created. Any outlays already existing on the creditor remain in place.
  • E-invoice items: One outlay is created for each invoice line
  • E-invoice VAT rate: One outlay is created for each different VAT rate

In the system setting Creditor entry: Create outlays (default value), this option can be preset as of Vertec 6.8.0.21. It is then preselected in each case, but can be overridden in the dialog if necessary.

Receipt

Here, the imported receipt is displayed. This can also be opened in the editor by clicking the button Open document.

Apply
With the button Apply, the data is entered definitively in the creditor view.

Reread receipt

It is also possible to reread the same receipt again in order to return to the dialog window. This allows you to adjust the data again. To do this, navigate to the Actions Menu or right-click on the Creditor and select the Reread receipt. The receipt already stored is used and does not have to be selected again. Alternatively, the entire process can be started again via Import receipt....

All data in the creditor will be rewritten. Data that are not present on the receipt will be overwritten as blank. Existing outlays will also be overwritten, unless the Do not create outlays is selected in the dialog. Therefore, we recommend that you first import the receipt and then make manual adjustments in the creditor.

If you only want to replace the receipt without changing any data, then this can be done by Load image/receipt from Vertec 6.8.0.21.

Note: A receipt cannot be reread or imported on posted creditors.

Import receipt (without automatic creditor recognition)

Receipts can also be imported without automatic creditor recognition, but only those with QR code (Swiss QR or EPC QR code), no e-invoices.

If the imported receipt contains a QR code, this information is processed as follows:

Receipt with Swiss QR code

If the imported receipt contains a Swiss QR code, the following creditor details are automatically entered:

  • Account: QR-IBAN number
  • Reference: reference number
  • Currency
  • Amount
  • Supplier: If there is already a company in Vertec with an exact name and ZIP code, this company is assigned. If no suitable company is found, a dialog appears asking if a supplier should be created.
  • If you are not authorized to create companies, an error message appears. This is the case, for example, with project supervisors without address administrator user rights. The QR codes can only be read if the addresses already exist in the system.
  • If the creditor has already assigned a supplier and your search results in another one, a dialog appears indicating an error. The current supplier is not overwritten.
  • External number: invoice number, if encoded in the QR code
  • Due date, if encoded in the QR code
  • Date: Date of invoice, if encoded in the QR code
Receipt with EPC QR code

If the imported receipt contains an EPC QR code, the following creditor information is automatically set:

  • Payee
  • IBAN number
  • Reference number
  • Currency
  • Amount
Receipt with QR code not supported by Vertec

If the imported receipt contains a QR code that is not supported by Vertec, the receipt image is saved but no credit data is written (as of version 6.5.0.18).

Receipt without QR code

If the imported receipt does not contain a QR code, the existing information remains on the creditor.

(In versions prior to 6.5.0.11, the receipt is saved, but no creditor information is entered. Import the receipt first and then fill in all the information, as importing the receipt deletes what was previously entered.)

If a receipt is imported even though a receipt already exists, a dialog appears asking whether the existing receipt should be overwritten. If yes, all data will be reset for a receipt with a QR code according to the above listing.

Manually filling out the creditor

You can also fill out creditors manually. These are the fields in the creditor detail view:

Date
Date of creditor entry. Usually, the date of receipt of the third-party invoice.
External number
Open item number of the supplier, i.e. usually the invoice number specified on the third-party invoice. You can search for this number in the root data in the Creditors folder.
Posting number
The posting number is generated by accounts payable from the creditor posting and is output here. You can also search for this number in the root data in the Creditors folder.
Internal number
This is the number that you want to give to the creditor internally. For example, if incoming invoices are stamped with sequential numbers, this number could be entered here. You can search for the internal number in the root data in the Creditors folder. If the internal number is to be sequential, the use of a number generator can be considered.
Currency
Specify the currency of the third-party invoice. The amount is converted accordingly.
Personal account
The personal account corresponds to the personal account of the supplier in accounts payable. In Vertec, this value is defined in the supplier address on the Settings page.
Supplier
Select the supplier here. This enables you to transfer the creditor entry to accounts payable. By default, the addresses in Vertec that have a creditor personal account assigned to them are available as suppliers. If you wish you can adjust this setting in the system settings via Project > Selection of suppliers only with creditor personal account so that all the addresses are available.
Text
Any text that identifies the creditor entry. This text can be written to accounting or used on Office reports. If no text is specified, the text of the first assigned outlay is copied into the Text field.
Account
Account or participant number where the creditor invoice is to be paid in.
Reference

If required, enter a reference number here. This can be, for example, the reference number on the third-party invoice.

If you are working with an external accounting system, the reference number may be limited by that system. For example, in the case of Abacus Web Creditor, the reference number (including spaces) may not exceed 35 digits. 

Payment terms
Select one of the payment terms defined in the system settings.
Due date
This value is calculated based on the payment terms. Alternatively, you can enter a due date manually here. You can show this value in lists or filter in expression folders.
Charging type

The charging type determines how to proceed with the creditor item:

  • Charge: The third-party invoice is invoiced to one or more customers. Onward charging takes place by means of outlays or expenses created on the creditor, which appear on the customer’s invoice.
  • Forward: The third-party invoice is entered in Vertec only for control purposes and is forwarded to the customer for direct payment. The outlays created on the creditor do not appear on a customer invoice. Invoices that are only forwarded are not posted in accounting. Only outlays can be forwarded, not expenses (since expenses must already be paid when they are incurred; therefore, they cannot be forwarded, but must appear on the customer invoice).

The default value for the charge type is determined as follows:

  1. Explicitly set charging type (forward).
  2. Charging type of the first outlay attached.
  3. Charge default value if no outlays.
Forwarded

If the Forwarded checkbox is activated, the creditor behaves as if it were posted (without already being posted in accounting). This means:

  • Values on the creditor can no longer be changed.
  • Outlays and expenses that are located on the creditor are also fixed and cannot be deleted. They also no longer react to adjustments of the values from the business logic (UpdateRate).
  • The SQL folder Root data > Creditors in progress shows only creditors that have not been posted and have not been forwarded.
Amount

Here, you can enter the gross amount (incl. VAT) of the third-party invoice.

The assignment of the creditor to the project is based on the assigned outlays or expenses. This means that you can also assign outlays and expenses from different projects to a single creditor. This is useful, for example, if you want to distribute the costs of a third-party invoice to several projects of a customer.

Assign outlays and expenses

Outlays can be entered directly in the folder Outlays of the creditor. Existing outlays can be assigned by drag & drop or via the button Assing outlays... on the creditor.

If you create a new expense or a new outlay on the creditor (using the corresponding icon in the toolbar or via the menu button New), it is assigned directly to the creditor.

Already existing outlays and expenses can be assigned to the creditor via drag & drop.

If there is exactly one outlay, at the same time the amount is written into the outlay and the quantity is set to zero (same functionality as via button Amount on outlay, see below).

Allocated outlays and expenses must meet the following conditions:

  • The sum of the purchase prices of the outlays and expenses must be equal to the total amount of the creditor
  • All outlays and expenses must be in the same currency
  • The projects of the allocated outlays and expenses must have the same FAR clients
  • All outlays must be of the same charge type. If you want to both forward and charge outlays, you need to enter multiple creditors.
  • If the outlays are to be forwarded, they must all belong to the same project.
  • Expenses cannot be forwarded. A creditor to be forwarded must not include expenses
  • all outlays and expenses must be approved (this behavior can be configured in the system settings)

If one of these conditions is violated, this will be shown on the creditor in the Problem report field.

Amount on outlay

The button Amount on outlay is active if there is only one outlay on the creditor. In this case, the purchase price of the outlay can be set via this button.

As soon as several outlays are assigned to the creditor, this button is inactive and cannot be used.

Block project allocation of outlays for posted accounts payable payable

The creditor interface offers the possibility to obtain the client information of the creditor about the projects of the outlays. In this case, it is important that the project does not change in the case of such outlays. To prevent this, there is the system setting Block project assignment of posted outlays and expenses

Load image/receipt

On the Receipt document page, a receipt can be loaded via the right mouse button > Load image/receipt....

If there is already a document there, it will be overwritten. Please note the following:

  • As of Vertec 6.4.0.14, the Import receipt with QR code recognition is automatically started if it is a QR invoice.
  • As of Vertec 6.8.0.18 the automatic creditor recognition is started if it is a QR or an e-invoice.
  • As of Vertec 6.8.0.21, a process is no longer triggered, but the document is simply assigned to the creditor, even if it is a QR or e-invoice. With this, an existing receipt can be replaced without changing data. From this version, the automatic creditor recognition must always be done via the Import receipt... button.

Accounting

With the help of an Accounting extension, creditors can be posted directly into your accounts payable.

The necessary configurations can be found in the respective extension description as well as in the System Settings - Accounting.

Opening a creditor address

Unless otherwise specified in the respective extension description, the opening of an accounts payable address in accounting takes place on the address via the menu button Actions > Accounting > Create new address in accounts payable.

The following information should be entered in Vertec:

  • The personal account creditors on the address (on the settings tab). If the option System settings > Project > Supplier selection is set to YES with account payable PersonalAcc only, this address will now appear as a supplier for selection.

Post a creditor

Once all the information has been entered correctly, you can post the account payable on the Accounting page. On this page you will also find a detailed list of the postings:

When posting creditors, the VAT code and the VAT rate for the outlay as well as the expense account are fixed.

Creditor posts with blank collective account

In some Accounting programs, e.g. in the Infoniqa ONE 50 Creditor Extension, the transfer of an empty collective account allows the use of the FAR’s own configuration. When posting, an empty collective account can also be transferred if this is configured in the accounting program.

Standard texts on creditor postings

In System settings - Accounting, there are two settings:

  • Text for creditor collective postings
  • Text for creditor detail postings

The texts can be combined with OCL expressions (in % bordered) and plain text.

If these system settings are empty, the following default texts are used:

  • For collective postings (on posting.text and in the text of the first posting):
supplier.asstring, <text of creditor>
  • For detail postings (on all other postings):
    • Expenses:expense.text, expense.project.asstring, expense.phase.asstring
    • Outlays:outlay.supplier.asstring, outlay.project.asstring, outlay.phase.asstring

Post without data transfer

You would like to set a creditor to posted in Vertec without transferring any data to accounting. This can be useful, for example, if a account payable should appear as posted in Vertec afterwards, but the accounting period has already completed. Use the Script: set creditor to posted / canceled.

Netherlands

United Kingdom