Import data

In this article

Banana Accounting is a very suitable companion for business solutions that do not provide an integrated accounting solution. Banana Accounting software offers different advantages, therefore many software houses, independent or in house solutions developers offer an integration mechanism and market their solution with Banana:

  • Solutions developers can provide a complete business solution, without the need to develop a new accounting module. 
  • Banana Accounting is very versatile, easy to use, provides many functionalities and it is also affordable. 
  • In Banana Accounting Importing is a primary function, that is very much advanced.
    • It supports different formats. 
    • Once the data imported has been imported it can still be verified and changed by the users.
      Implementing the export is much easier, special cases or errors due to incorrect configurations, can be modified by the users. 
      Users can fix the problem directly and the developer can later provide a new patch release. This approach makes supporting the export to Banana much easier and less stressful.
    • Import can be undone and repeated, later.
      During the import one sometimes happens to see error in the original data. The user undoes the import, fixes the data and repeats the export and import. 
  • Banana Accounting includes a Web server and an API that can be used to retrieve information. Prior to exporting the data it is possible to verify the status of the accounting.

Currently, the only way to integrate data from other solutions is to use the import function. Due to the flexibility and possibility for users to check and modify the imported data, this has been proven to be a better solution.
Therefore, we did not make available an API for integrating data. Kindly let us know user cases where this would be a better solution.

For the development needs you can download the Banana Accounting software version available on our web site. You can use all functionalities and save up to 70 transactions. This version is normally sufficient for the development and testing process.

User cases

Generally the integration is related to: 

  • CRM with invoicing or Online Web shop.
    Customer sales are exported in TXT format and imported in Banana Accounting.
    • Customer information is exported as an accounts data and imported into the Accounts table
    • Invoice information or payments are exported as transactions and imported into the Transactions table.
  • Payroll and Salary
    End of month's summary data is exported as transactions and imported into Banana Accounting.
  • Accounting data from another accounting software is integrated in Banana Accounting.

Other documentation

How to proceed

If you are a developer and do want to test if the import file is correct:

  • Download and install the Banana Software. In Starter Edition mode you can Create a new accounting file, use the import into accounting function and operate all tests you need. 
  • In case you are an independent software developer and need full functionalities we can provide a time-limited full license.
    Request must come with a link to the developer web site.

How to for

  • How to read the balance for an account / customer / supplier
    Use the Web API.
    Replace the "1000" with the account number.
    "/v1/doc/accounting.ac2/table/Accounts/row/Account=1000/column/Balance"
  • How to get about Accounts, VatCodes
    Use the Web API.
    Replace the "Accounts" with the table you need to query.
    "/v1/doc/accounting.ac2/table/Accounts?format=json"
  • How to add a customer or supplier
    • Create and export file in format TXT for the Accounts table, with the customers and suppliers.

Import Extensions

An import Extension is a javascript program that is executed internally by Banana (when the user wants to import data) and usually converts data from a proprietary format to a Banana "Text file with columns header".

You can create an Import Extensions that does more sophisticated things like:

  • Applying an account number based on the content .
    For example set the ContraAccount to "3000" if the amount is positive and the "Description" starts with "Revenue from "
  • Use data contained in another Banana table to complete the transactions.
    • Create a table with (Tools->Add new functionalities->Add simple table) where you list text to look for in the transactions texts and the corresponding account to use.
    • Assume you invoice data using a customer number that is different from the account number in the Account table.
      Add a new column in the Account table and then use the content to retrieve the appropriate account number.
    • Adding a prefix to the supplier invoice number, so that you can easily distinguish incoming and outgoing invoices.

Import "Text file with columns header"

The Banana import format is of type "Text file with column headers".

  • Fields and column name separator is to be tab separated "\t"
  • Each line (after a "\n") is a new record
  • Character code preferably UTF8 or else the local one.
  • The first line contains the columns header name
    • You can use any column name existing on the table
    • Names are case sensitive and must correspond to the Banana NameXml (English) of the column. You can find the NameXml of a column by clicking on the header of the column and moving under Settings, like in the example:

    XmlName

 

 

  • Starting from line 2 it contains the data to be imported
    • The format for the Date fields is yyyy-mm-dd
    • The decimal separator is the decimal point "."
    • Amount should not have any thousand separator

Two commands for import

  1. Through the Command in Menu Actions->Import in Accounting.
    This is a specialized import for accounting data, with post-processing of that suitable for the accounting data.
  2. Through the command Data import. Import from txt.
    You can import data in any table. For accounting data, prefer option 1.

 

Import Accounts

For creating new accounts, customers, suppliers, cost centers. See Chart of accounts documentation for the list of columns available.

Menu Actions->Import into accounting->Accounts

The type of file to be used is a "TXT with headers.

  • You can use any column name existing on the table
    • Account.
      The account number.
    • Description
      A brief text, organization or customer name
    • BClass
      Required (1,2,3,4).
    • Gr1
      Obligatory. It is also used to order the data when it is imported.
    • Address fields.

When importing the user can choose to import only the new lines.

 

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