Import file

This feature allows you to import data from another Banana accounting file (with ac2 extension) of the same type.
 
It is being used when you go from one chart of accounts to another one and when a conversion of the account numbers is necessary.
 
For more information about the conversion of the chart of accounts, see the page on the accounting data migration to the new accounting plans.
 

Source file

This is the file from the which the data are being taken.

Destination file

The file that "receives" the data.

Options

Import transactions

All the rows of the Transactions table, present in the source file, will be imported.

Import recurring transactions

All the rows of the Recurring Transactions table, present in the source file, will be imported

Import budget transactions

All the rows of the Budget table, present in the source file, will be imported.

Replace amounts in Account table

The amounts of the Opening, Budget and Previous columns of the Accounts table of the destination file are being deleted and replaced with the amounts that are present in the source file.

The accounts need to correspond, thanks to the same account numbers, or when there is a replacement, in that case the option "Convert account numbers" should be used.

Replace accounting properties (basic data)

The File and accounting properties of the destination file will be replaced by the ones of the source file.

Convert account numbers

Using this function, the imported account numbers will be replaced with those indicated in the alternative column.
If you use this function, you must also specify the column that contains the account numbers to be used in the import instead of the existing ones.
Next to the account number column, there should be a column that indicates the alternative number to be used when importing. If no alternative number is specified, the original account number of the source file will be used.

  • The account matches are in the source file
    This option is to be used when for example you keep an accounting file in a country, with a specific number system, and then you need to regularly import your transactions in a different accounting file, that uses a chart of accounts with a different numbering system.
    • You need to add a new text column in the accounting plan (Columns setup command)
    • For each account, indicate the destination account number in the tabel.
  • The account matches are in the destination file
    This option is used when for example you want to switch to a chart of accounts with a new numbering and grouping
    • You create a new accounting file with the new chart of accounts.
    • In the chart of accounts, you create a new column where you indicate the account matches (Columns setup command).
    • In this column, indicate the account numbers of the source file.
      Separate the accounts with a semi-colon "1000;1001" to indicate that several accounts need to be grouped into this account.
  • Column containing the account matches (Accounts table)
    Indicate a column of the chart of accounts that has been added by the user and that contains the account matches.
     

Results and possible errors

The program will have carried forward all the data of the previous accounting, converting the account numbers.

In case the program indicates errors (absence of accounts or other), it might very well be necessary to cancel the import operation, complete the account matches and repeat the import operation.

The program, finding different charts of accounts, cannot automatically execute extended check-ups to make sure that all the data have been imported and grouped correctly.

It is therefore advised to check the result manually, verifying that the totals of the Balance sheet and the Profit and Loss statement are indeed correct.

Advanced import options

For different and more complex and automated conversion needs, we suggest to use the scripts, that allow a total customization of the conversion and the import.

 

help_id
DlgImportaTuttoConverti

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 | Email