To import data from a Banana Accounting File, proceed as follows:
- From the Actions→ Import to accounting menu → select File in the Import box .
- Select the * .ac2 file type to import the data.
- With the Browse button, choose the file from where you want to import the data.
The below dialogue box will be displayed with several options that allow you to determine which data to import from the file.
This is the file from the which the data are being taken.
The file that is to receive the data.
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 table.
- 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.
This option is used when switching from one chart of accounts to another, and when you need to convert accounts from one numbering to another.
For more information on converting the chart of accounts, see the page transfer data to a new accounting plan.
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.