Import transactions

In this article

Import procedure

  1. From the drop down menu, choose Import transactions
  2. Choose the file type from which to import (Cash book transactions, Double-entry accoutning transactions)
  3. With the Browse button, choose the file from which to import the transactions

More information about all types of import filters can be found on the Banana Apps page.

File types that can be imported

  • Import transactions from an Income & Expenses accounting file
    In order to import transactions from an Income & Expenses accounting file into a double-entry accounting file, it is necessary that the categories of the Income & Expenses file correspond to the accounts of the Double-entry accounting file.
  • Import Cash book transactions
    Apart from importing the transactions, an import summary per month or quarter can also be obtained. 
    See the specific page Import Cash book transactions.
  • Import Double-entry accounting transactions
    In order to import transactions from a Double-entry accounting file into another Double-entry accounting file, it is necessary that the accounts correspond.
  • Import transactions from Bank statement ISO 20022 or MT 940
    See page Bank Statement ISO 20022
  • Import data in Txt / CSV
    This format must be used by those who want to export data from another software and import them into Banana Accounting.
    See also the technical information on how to create an import file for Banana Accounting.
    This file type is being used to import data from other programs, such as:
    • in order to import monthly transaction from your salaries software
    • in order to import the invoices issued with a invoicing software
    • in order to import the payments made with your invoicing software
    • in order to import your sales transactions from your online shop
    • in order to import data from another accounting software
    • in order to import data from another cashbook management software (for example a restaurants or a hotel).
  • BananaApps for importing
    Allows you to transform data exported by another program (proprietary format), in the import format required by Banana Accounting.

Choice of rows to be imported

After having elaborated the rows to be imported, the program displays a dialog, in which the user can indicate further options.

Destination account

This option is present when data of the bank account (or postal account) statement, or an account's income & expense transactions in a text format, are being imported.
Insert the bank account number of the chart of accounts, related to the imported statement.

Select transactions

Start date, End date

Insert the start and end dates of the period related to the transfer of the transactions. The period can also be selected automatically in the boxes under the dates area.

Don't import if exists same ExternalReference, Date, Amount 

If activated, this function allows the user to not import already entered transactions, in order to avoid recording transactions twice. This option can only be activated when the column "ExternalRef" is present in the transactions that are going to be imported. If not, this option will be deactivated.

Complete the transactions with

Autocomplete values

The option is only necessary for accounting with VAT/Sales tax and multi-currency. If activated, it allows the automatic completion of values that are missing in the imported data (for example, the exchange rate in the exchange rate table).

Initial document number

This option is present when data of the bank account (or postal account) statement, or an account's income & expense transactions in a text format, are being imported. This is the document number assigned to the first imported transaction.

Group transactions by invoice number

If the import file contains values in the "DocInvoice" column, it is possible to indicate in the dialogue:

  • Group transactions by invoice number
    In this case, the rows of the same invoice are being grouped in such a way that there is only one transaction for the same account and the same VAT code. Please check the explanation Import invoice data.
     
  • Destination account for balance differences
    When VAT codes are being applied, there may be rounding differences of just a few cents.
    In this case, Banana creates an additional transaction for every invoice into which this difference can be recorded.
    Of course, it is necessary to pay attention that the data to be imported obtain a balance between debit and credit. If not, the transaction row will contain the difference between debit and credit. 

Edit the imported transactions

The program creates some transactions and adds them to the Transactons table.
Transactions can be edited or deleted.
In a double-entry accounting file, the program adds some symbols in the Debit/Account and Credit/Accounts columns, where in an income and expenses file, the program adds them in the Account and Category columns.

Symbols should be replaced with the appropriate account or category.

  • [A]
    This symbol is indicated when no account has been indicated in the dialog.
    You need to replace the [A] with the appropriate bank account.
    [CA]
  • When ths symbol appears, you need to replace it with the appropriate contra-account, so that the Credit transactions will be balanced with the Debit transactions.

In rows with only one contra-account, you will find both the [A] and the [CA] symbols in the same row.
In rows with multiple contra-accounts, each row will have its own [CA] symbol. Without the [CA] symbol, it would be impossible to understand if the transactions is a Debit or Credit one.

Frequently Asked Questions

I see don't see the format for the bank statement of my bank
Click on "Manage apps...", followed by "Update apps" and enable the filter for the desired format.

I see don't see the format for the Xml account statement of the Postfinance (file .tgz)
This format is no longer supported. Please contact the Postfinance and ask to receive the statements in ISO 20022 format.

The following message appears 'This ISO 20022 file doesn't contain a bank statement (camt.052/053/054)'
This error message is being displayed when the ISO 20022 file doesn't contain a bank statement. The ISO 20022 format is a generic format that can contain different types of information, like the bank statement and the payment confirmations In Banana Accounting, only the bank statements can be imported (camt.052/053/054).

My bank is not in the list of supported formats
It is possible to create apps for formats that have not yet been implemented. We have also paid support available for the implementation of customized formats.

I can only import collective orders and I cannot see the details (the individual orders)
When executing a payment in the e-banking (for example in the Raiffeisen bank), you need to choose the option 'individual order' instead of the 'collective order' Only by doing so you will be then be able to import the payments as individual orders.


 

help_id
DlgImportaMov

This documentation is outdated

The most complete and up-to-date documentation is the one of Banana Accounting Plus: Try it now

Share this article: Twitter | Facebook | LinkedIn | Email