TeamWox HelpAccountingViewImport

Import of Payments

In order to import payments from an external source one should go to the "Payments" tab when viewing a book and press the "Import" button. The following window will be opened as soon as it is done:

Import

The process of importing consist of several stages:

1 Data Source

The following is specified at this stage:

  • Data source — in this field you should specify the format of a file that you're going to import. Only the *.CSV files are supported at the moment.

2. Data Source Parameters

The following parameters are specified here:

  • File — in this field you should choose a file to be imported by pressing the "Browse" button.
  • Encoding — the selection of encoding of the imported file.
  • Skip rows — the number of rows that should be skipped in the beginning of file.
  • Separator — separator that divides different data by products in the file (comma, dot or tabulation character).

3. Additional Settings

Additional parameters are specified at this stage:

  • Data format — the selection of data format in the imported file.
  • Default Supplier/Payer — this field is intended for choosing a paying organization that will be substituted to all payments where this kind of information is absent. If a default payer is not specified then the payments, where this information is absent or unrecognized, will not be imported.
  • Default Recipient/Beneficiary — choice of a beneficiary organization that will be substituted to all payments where this kind of information is absent. If a default beneficiary is not specified then the payments, where this information is absent or unrecognized, will not be imported.

4. Match Fields

At this stage you should match the fields of the file with the fields in the system:

Associating columns

The preview window shows first 10 lines to be imported.  Columns that are matched to a field in the system are green colored, and the ones that are not are blue. To switch between matched and unmatched fields, use the corresponding commands in the upper part of the box.

To match a column with a field, press the Select field button in the upper part of the table. Obligatory fields are marked with the Obligatory field in the list.

It is obligatory to specify the "Number", "Beneficiary" and "Payer" fields when importing payments

The statistics on the imported file is show below — number of listed rows and the total number of rows in the file. The number of rows that cannot be imported due to some reason is shown here as well. The reason of it can the absence of an obligatory field.

Once you've finished checking and matching columns you should press the "Import" button.


← Export Reports →