Import into accounting command

Documentation •
In this article

The import command is activated from the Actions menu → Import into accounting and allows you to import data from files in the following tables:

To import data from other programmes, see the page Retrieving data from other programs.

Import procedure

  1. Choose the destination table for the data.
  2. Choose the file type to be imported.
  3. Specify the name of the file.
  4. Choose the movements to be imported.

Supported import formats

Various import formats are available depending on the type of destination table.

  • Import from other Banana Accounting files (.AC2)
    Prepared to convert data from files.
  • Text files with header (CSV/TXT)
    For files created that export data in the format required by Banana Accounting.
    See the technical instructions on how to prepare these files.
  • Default file formats (generic)
    ISO 20022 (generic).
  • Import via an import extension
    Usually for bank statements.
    The import extension is an additional Banana Accounting program that transforms data from a specific format
    The user must install the appropriate extension.
    Should there be a need to import from other file types not included in the list, a specific Banana Import Extension can be developed.

dialogo importa in contabilità

Import parameters

File name

  • Indicate the name of the file of which the data need to be imported. 
  • For certain types of imports (e.g. bank statements)
    • You can also indicate multiple files together, either by selecting them with the browse dialog or by entering them separately with a semicolon ";".
    • You can indicate a zipper file that contains multiple import files.
    • If you specify multiple files, they must all be of the same type.

Import data from clipboard (Excel)

With this option active, the data, instead of being read from the file, is read from the clipboard.
It is used to import data from files that cannot be directly read by Banana, such as bank statements in Excel format, or from another programme.

The advantage of importing data and not simply using the copy-and-paste function is that the data are converted by the import programme and completed automatically.

Proceed as follows:

  • Open the file with the data using Excel.
  • Select the data to be imported, including eventual header rows.
  • Issue the copy command (Ctrl+C).

This option is shown only for certain import types.

UTF-8

Select whether the data to be imported is in the utf-8 format.
This option is shown only for certain import types.

Manage extensions...

This command brings you to the Mange extensions dialog window.
You can use it to:

  • Look for, add or remove an import extension
  • Edit the extension parameters.

Also use the command to change the extension settings.

Settings

The button allows you to change the settings of the extension.
The button is visible from the Banana version 10.1 and only if the extension allows parameters to be set.

OK Button

It starts the import process.

Error messages

If errors are reported during the execution of an import, the Import Extensions must first be updated.

If errors persist, please send us feedback, it may be that the file format has been updated by the originating bank or institution, and we will update our import filter accordingly.

help_id
DlgImportaFile

Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email