Import into accounting

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 Importing data from other programmes.

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.

Banana Accounting Plus reads the transactions in different formats. See the Import transactions page.
Thanks to the customised Import Extensions, you can import data from various bank statements and other standard programmes. Some extensions are only available in the Advanced plan.

dialogo importa in contabilità

Import parameters

File name

  • Indicate the name of the file of which the data need to be imported. 

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

In case error messages appear during an import operation, update, first of all, the Import Extension.

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