To create a new File, go to the File menu and click the New command

The appearing window will allow you the possibility to create a new file in three different ways:

1. Using an existing Template
2. Copy data from an existing File
3. Use a New empty File

Start with one of our templates adapted to your business

This will generate a new File based on one of the existing templates.

• File Menu, New command
• Select your country
• Select your language
• Select your category
• Select your Accounting template
• From the dropdown list of templates that will display in the dialog box, select the template that most closely matches your needs.
  Clicking on the file will automatically open it and can then be saved with the name you wish. 

All the files with the VAT option have the VAT codes table adjusted to the new rates.
The Chart of Accounts can be adapted to your requirements (change of account description, insert or delete groups, sub-groups, etc.)

You can search for a template by entering a keyword in the search box.

Save the file with a name

Once you have opened the template with Banana you need to use the Save as command from the File menu

• Chose the destination folder
  It might be useful to create a separate folder for each year, so you are able to store documents, other than the accounting file that are related to that year.
• Chose a file name containing the company name and the accounting year, for example smith_company_2018.
• The software will add the .ac2 extension, typical for the Banana files
• Chose a file name containing the company name and the accounting year, for example smith_company_2018.
  The software will add the .ac2 extension that distinguishes the Banana files.

Adapt the template

1. Edit the File properties
   • Enter the headings and the accounting period
   • Enter the address
2. You can now adapt your Chart of accounts
   • Enter your bank accounts.
   • Enter or edit the chart of account to fit it to your requirements.
     While going along with your work, you will still be able to add or edit, if new needs arise.

Start with an existing File

Starting from an existing file or template, without modifying the existing file.

There are several possibilities to copy data:

• Open the File that is to be your template via the Browse button and indicate the path to locate your file.
• Create a copy of the open file, using the Save As command from the File menu
• Else, you may create a copy of the open file via the Tools menu, click on the Create File Copy command, the window that will appear allows you to choose which data to keep. If none of the three options are activated, a file is created with the Plan of Accounts only.

Save the file in the folder where you wish to keep the data (normally in the documents folder)

• Enter the company name and the accounting year as file name, for example smith_company_2018.
• If you are taking over an existing accounting file, you will also need to enter the opening balances in the Opening column.
• If you are working in a multi-currency file, you need to update the opening exchange rates.

Starting from a New empty File

You will be starting from scratch, so you will need to set up the basic accounting data and the entire Plan of Accounts (not recommended).

• File Menu, New command
• Click New empty
• Select your language
• Select your category
• Select your Accounting template
• From the dropdown list of templates that will display in the dialog box, select the template that most closely matches your needs.
  Clicking on the file will automatically open it and can then be saved with the name you wish. 
• Setup the  Outline to create new file

• Setup the File and accounting properties
• Save with File Name.
• Create the Plan of Accounts structure

Related documents

• Start a new Income and expenses accounting and Cashbook file
• Start a new Double-entry accounting file
• Start a new Double-entry accounting with multicurrency file
• Utilities documents

Transferring to a new year

When transferring to a new year, there is a specific procedure to follow, in order to create a new year's file and automatically carry forward the opening balances.

New file settings

When the program creates a file with new characteristics, you need to setup the outline of the new file.

Opening a file

• Accounting files can be opened in Banana Accounting if they are on the local computer or if they are accessible through a network.
  If they have been sent by email, before opening them you need to move them in a computer folder
• Only one user at a time can edit a file
  If you edit a protected file or a file already in use by other users, you need to save the file with another name in order to save your changes.
• The Banana Accounting program, notifies that you have opened a read-only file in the following cases:
  • the file is located on a non-writable disk (CD-ROM)
  • the file is located on a temporary non-writable folder
  • the file is protected or the user doesn't not have rights to edit it
  • the file has already been opened by another user
  • the file has already been opened from the same user but in another session

How to look for *.ac2 files

If you don't remember in which directory your accounting files are located, you can use the search Windows Explorer box or the Mac finder search tool.

Find your accounting file on a Windows computer

Banana Accounting files have an .ac2 or .sba extention. The Windows search tool will vary depending on your Windows version.

• Windows 10: click on the search icon on the Applications bar and enter "ac2" or "sba" or your file name and click on the Documents arrow.
• From the Explorer File Manager enter the "*.ac2" extension, the "*.sba" extension or your file name and let Windows look for it.
• When in Banana you get to the Open file dialog window (File menu -> Open), enter the "*.ac2" or "*.sba" extension in the top right search box and then click on the look in the whole PC icon, or select the directory where you want Windows to look for your file.

Find your accounting file on a Mac computer

• When in Banana you get to the Open file dialog window (File menu -> Open), enter "ac2" or "sba" or a word that is part of the file name in the top right search box. With the icons, select where you want to look for your file (in the entire computer or in selected folders).
• Open the Finder and enter "ac2" or "sba"or a word belonging to the file name in the search box.
• Right click on the Finder icon, then click on Search, and then enter "ac2" or "sba" or a word belonging to the file name.

Saving a file

With the Save or Save as... command, the data are saved onto the hard disk. Pre-existing disk data are replaced with the new ones.

• A single file can be saved by one user at a time
  The file can be saved by the user only if it is not also being used by other users
• Files can be saved anywhere.
  You can enter the file name and destination when saving it for the first time or when using the Save as command from the File menu
  As a first option, Banana Accounting suggest the Documents folder as destination folder for the .ac2 files, but it can be changed with the Browse button.
• If you are managing different accounting files, we suggest you to create a separate folder for each company and for each accounting year.
• Each file can be password protected.
   

Accounting files (*.ac2, *.sba)

• Files created with Banana Accounting have an ".ac2" or ".sba" extension, regardless the operating system used.
• The file with the extension "sba" is completely similar to ac2. The sba extension is used for the Dutch and Chinese version of the program. When referring to the file type "ac2" it also applies to the file type "sba".
• The .ac2 file format is specific for Banana. When saving, all data are compacted and saved in bulk.
• Ac2 files are compatible between different operating systems (Windows, Mac and Linux)
  You can save a file with Windows, then open it and edit it on a Mac, and then reopen in on a Linux or Windows computer.
• Each file can be sent as an email attachment, edited on different operating system and resent to the sender.
• Accounting files are completely separated from the software Banana itself, that has an .exe extension for Windows,
• The installation files for Mac have a .dmg extension and a .deb, .rmp .run or .tgz extension for Linux.

Automatic saving

Banana Accounting automatically creates and saves your work in a temporary file that ends with ".autosave" . When you press the Save button or you exit the program, this temporary file is deleted. In case your computer should crash or turn off in the middle of your work, it would be possible to recover your data by opening this file.

In order to have the program automatically create this temporary autosave file, the corresponding option should be active (it usually is by default) in the Program Options (you can access them from the Tools menu).

How to copy or move your accounting files

Banana can save your files on any unit seen by the operating system or on a rewritable disc.
From non-rewritable discs (CDs or DVDs) Banana can open the files on a "read only" mode.

All .ac2 files can be moved in different ways:

from one directory to another:

• using Windows Explorer or Mac Finder to locate the directory where your files have been saved
• copying and pasting them in the new destination directory (once you pasted them you can delete from the original directory)

from one computer to another:

• saving the files on a memory stick and then saving them on the new computer:
  • open the file to be moved
  • from the File menu choose the Save as command, choosing the memory stick as destination unit
  • this copy can also be made from Explorer by dragging the accounting file into the memory stick unit
• by sending them as email attachments and then saving them on the new computer

DropBox, Google Drive and other synchronization systems

Banana is compatible with systems such as DropBox and Google that keep files synchronized with cloud storage services.
Banana overwrites *.ac2 files and deletes the *.ac2.bak files. In the deleted files list you will find all *.ac2.bak files previous versions.

Viewing changes

Banana Android works directly with Dropbox servers. If you make changes on your PC, usually you have to wait a few seconds before you see the changes on the server, so also on Banana.

To ensure that the file is properly synchronized with the server, the file on your PC must be marked with the green check mark.
If you do not see the sync symbols (green, red, blue), you have to update the Dropbox application installed on your PC.

Another way to check the synchronization status from your PC, is to click on the Dropbox icon in the bottom bar:

In addition, Android synchronization does not occur while you are working with the app. You must close and reopen it.

Attention: Banana cannot realize if some files are opened simultaneously on more than one computer. It could thus happen that someone erases some data or that someone else adds some new data. Only the more recent copy of the saved file is kept. For this reason we strongly advise to avoid working at the same time on the same file.

Security copies (backup)

We strongly advise you to create external backup copies of your accounting files, in order to prevent a possible data loss, due for example to a computer crash or other causes.

• if you have a Mac computer you can use "Time Machine"
• if you have a Windows computer you can use the "File history" function

You can find other programs on the market that allow you to automatically create a backup of your data.

Saving and .bak files

When saving, Banana Accounting replaces the contents of the existing file, with the more recent data, only if the saving process is successfull:

• Data are saved on a temporary file
  Only if the saving process is successfull the data on your disk are replaced to the existing ones.
• If the Create backup copy (.bak) option is activated (Tools menu -> Program options command -> Avanced tab) the program renames the pre-existing file with the same name, adding the .bak extension.
  A new file named "filename.ac2.bak" is created, containing the data before the saving process.

If an error occurs during the saving process, if for example the network disk is no longer available, choose another file name for saving your data.

Recover your data from a .bak file

When for a number of reasons you cannot find your accounting file, you can recover your data from the backup copy automatically created by the program. Here is how to proceed:

• open the directory where your accounting file was located
• open the file with a .bak extension. If it is not shown in the dialog window, you need to select the "show all files (*.*)" option at the bottom right of the window
• once the file is opened, save it with a name. Usually the same name as the lost file is chosen.

Damaged .ac2 files

Sometimes a computer crashes due to technical problems or viruses. Sometimes data received by email are compromised or damaged. For these reasons we strongly suggest you to make copies of your files.
If, for technical reasons you have a damaged file, our support team can verify, for a fee, if there are data that can be recovered.

When a new file is created, the basic data need to be entered in the File menu, using the File and accounting properties command.

The file properties can vary depending on the chosen accounting type.

For the explanations of the different tabs please visit the pages hereunder.

In order to create a Pdf file choose the Create Pdf dossier from the File menu (or click on the corresponding icon on the Toolbar).

File Name
In this area you need to enter the name of the new file that the program will create to export the data. If, however, an existing file is selected by using the Browse button, the program will overwrite it with the new data.

Display file immediately
As soon as the Pdf file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately. It is best to remember that browsers like Mozilla and MS Explorer use a cache mechanism for files. When the export is made for a second time, it is possible that the user will see the previous version until the browser Reload button is pressed.

Table creation options
Headers 1, 2 and 3
These are the table headers.

Page options
By activating the page options it is possible to include:

• page numbers
• page progressive numbering
• date

Page size
You can select the page format

Other Tabs

For the explanations of the other tabs, please visit the following pages:

• Include
• Period
• VAT
• Composition

Dieser Befehl im Menü Datei öffnet das Dateiverwaltungsprogramm Ihres Betriebssystems (Windows Explorer, Finder Mac) und zeigt den Ordner an, in dem sich die Datei befindet, an der Sie gerade arbeiten. Hieraus kann die gewünschte Datei kopiert, verschoben, umbenannt oder gelöscht werden (rechte Maustaste).

• Menü Datei
• Befehl Speicherort öffnen - Öffnet das Dateiverwaltungsprogramm um die Dateien zu verwalten.
• Zum umbenennen, verschieben oder löschen, muss die Datei zuvor in Banana Buchhaltung geschlossen werden.
  Manchmal bleibt die Datei gesperrt, auch wenn Sie sie geschlossen haben. In diesem Fall muss auch das Programm beendet werden, um die Datei vollständig freizuschalten.
• Kehren Sie zum Dateiverwaltungsprogramm zurück.
   

These commands display the list of recently used files and the favorite files.

In order to eliminate the list of recently used files, click on the File menu, Recent files, and on Clear list recent files.

In order to remove just one single file from the Recent Files list of the Favorites (Start page), position the cursor on the file name, proceed with a right mouse click and select Remove (Mac users should use the key combination Ctrl + right mouse button).
 

To make a file Favorite:

• Open the desired file
• Click on Favorite files
• Click on Add to list

To edit the list of favorites, click on:

• Favorite files
• Edit list..
• In the window that appears, edit the favorites, by using the buttons: Add, Remove, Open folder.

The text to be searched and the text to be used as a replacement should be inserted in the same format as the one displayed in the input field. For example, the amounts should be inserted without the separator for the thousands.

Search text
Enter the text to be searched.

Replace with
Enter the replacement text.

Options

Whole words only
If this box is activated, the program will find whole words only. For example, if the word being searched is Tot, it will not find Totals.

Match case
If this box is activated, the program will make a distinction between capital letters and small letters.

Selected area only
If this box is activated, the program will only search the information in the selected area.

Replace all
This key will replace the desired data throughout the whole document at once. When you need to change data that are being repeated in the Accounts, Categories, Transactions and VAT codes tables (for example, an account number or a VAT code), you can also use the Rename function.

Replace
This key will replace one data at a time.

Find all
Looks for all the information, according to the entered keyword, and displays it in the Information window in the lower part of the screen.

Find next
Looks for the following information item.

Search text
Enter the text to be searched. Amounts must be entered without separators.

Options

Whole words only
If this box is activated, the program will find whole words only. For example, if the word being searched is Tot, it will not find Totals.

Match case
If this box is activated, the program will make a distinction between capital letters and small letters.

Selected area only
If this box is activated, the program will only search the information in the selected area.

In order to begin the search, click on the Find button. The first piece of information corresponding to the request will be selected. To continue the search and find the next piece of information, select the Search next command from the Data menu, or else use the F3 key.

This command allows the user to change the account or category number (accounts or categories table) and the VAT code (VAT Codes table), without having to enter the necessary modifications in the transactions.

In order to rename, you need to:

• position yourself with the mouse on the cell that has to be changed (account/category number, VAT code);
• click on the Rename command from the Data menu;
• enter the new name in the appearing window.

Then, the software operates as follows (for example if you rename an account):

• verifies that there is no other account or group with the same number; if there is it the software will alert and ask if you want to proceed anyway. Please note that it is not possible to have to identical account numbers in the accounting plan;
• verifies where the account to be renamed has been used and makes sure that the rows are not protected or blocked; if they are it will alert that the rename operation cannot be carried forward;
• substitues the account number wherever it has been used, in the tables and in the File properties, with the new account number.

The software does not recalculate any total, simply renames the account number.

Select the Go to... command from the Data menu to open a window allowing the user to move to a desired row. When a selection table is active (for example, an account card), by using the Go to original row command, the program automatically takes the user to the corresponding row of the Transactions table.

The Extract and sort rows command is available from the Data menu. This command is different from the Sort rows command, since it creates a new table where the result of the extraction or the sort is shown. The rows of the original table will not be changed.

Extract

In the Extract table you can click on the row number (underlined) to return to the row of the original table.

Column
You need to select the column you wish to extract the data from.

Condition
You need to select the condition for the extraction (ex. Greater, less, contains text, starts with, ends with, ...)

Value
In this field you must enter the text you want to use as comparison in relation to the condition (for example, if the condition is = Equal, entering 25.01.2015 as value, the program will extract all transactions with date January 25, 2015).
The value is a date if the selected column was Date, a numeric value if the selected field was Amount, a text if the selected columns was Description.

Add
This button allows you to add new fields for the extraction.

Clear all
This button allows you to clear all the settings you have entered for the extraction.

Sort selected rows only
This option is only available when rows have been pre-selected. If activated, only the selected rows will be sorted.

Total row
If this option is activated, the program will show the total row for the extracted rows with an amount.

Sort

The sorting columns are being indicated. The options are the same as for the Sort rows command.

Composition

The explanations of this window are available on the following web page: Composition.

Example accounts list

It happens sometimes that you want to have a list with only the accounts.

• Put yourself in the Accounts table.
• Impart the "Extract and Sort" command
• In column, choose "Account"
• Under condition, indicate "Not empty"

In case you wish to have accounts sorted by description

• Put yourself on the "Sort" section
• In the "Sort by" box, indicate the "Description" column

If you want to display only certain columns, you can create a new view with the Tables setup command.

The Extract and sort rows command is available from the Data menu. This command is different from the Sort rows command, since it creates a new table where the result of the extraction or the sort is shown. The rows of the original table will not be changed.

Sort by
You can choose the desired sorting criteria.

Then by
The program allows you to choose two other sorting criteria other than the main one.

Ascending
The rows sorting is done in an ascending order, taking into consideration the selected sorting criteria (date, doc, ...)

Descending
The rows sorting is done in a descending order, taking into consideration the selected sorting criteria (date, doc, ...)

Number
If the column chosen as sorting criteria only contains numbers, you need to check this option.

Clear all
This button allows you to clear all the settings you have entered for the extraction.

 

The Sort rows command is available from the Data menu. Please take note of the fact that the Sort rows command is different from the Extract and sort rows... command, since it changes the order of the rows in the table you are currently working on, according to the sort keys you entered. We advise you to be very careful before pressing the OK button, especially if you are working in the Accounts Table, because you might completely change your accounting plan structure.

The rows on the table can be sorted according to the content of the columns. It is possible to enter up to three sorting keys:

Sort by
From the dropdown list choose the desiderd sorting key

Then by
You can here choose an additional sorting key other than the first one

Ascending
The rows sorting will be in an ascending order, according to the selected sorting key (date, doc, ...)

Descending
The rows sorting will be in a descending order, according to the selected sorting key (date, doc, ...)

Number
You need to activate this option if the sorting key you chose only contains numbers

Clear all
This button allows your to clear all settings previously chosen as sorting criteria

Selected rows only
This option is only available when rows have been pre-selected. If activated, only the selected rows will be sorted.

New columns

In the new version Banana Accounting Plus, in the Transactions table, we have added new columns for the integrated Invoicing and the new Balance column that identifies on each row, any differences so you can immediately correct them.

The command Columns setup command can be found in the Data menu. With this command, columns can be displayed, hidden, renamed or moved left or right in the various tables.

Display Tab

Header
This is the column header.

Header 2
This header is used by the program for only a few fields (e.g. Amount column).

Description
This is the description of the field. This description will be shown as a tooltip.

Format
This is the format to show numbers, date and time (see chapter at the end of this page).

Width
This section defines the horizontal size of the column.

Column Style
This is a drop-down menu that indicates the style to be used (Format, menu, see sub chapters). This style has priority over the style of the row.

Alignment
The user can choose whether to align the text right, left or center in this drop-down menu.

Wrap text
This option allows the user to view the input text on more than one line.

Protected
This option allows the user to protect the entire column so that no data can be input or edited.

Exclude from printing
When this option is activated, the field will be excluded from printing.

Visible
This option allows the user to make column visible.

The tables can be altered. Fields can be added, headers can be changed, and column sizes and the order in which they are shown can be altered.

Move up, Move down
The fields are listed in the order in which they appear on the table being used. The visible fields are the ones with a checkmark.
In order to alter the order in which they appear simply select the field you wish to move and drag it up or down.

Add
This button adds new fields (columns) to the current table. Field added by the user are just information fields; the program does not make any calculation on numeric data.

Delete
This function is used to delete a field (column) from the list. A system field, however, cannot be deleted.

Settings Tab

Field name
This is the name of the active field and it is automatically inserted by the program. It cannot be modified.

Field name Xml
This is the name of the active field in the Xml format and it is automatically inserted by the program. It cannot be modified.

Data type
It is possible to choose between the following predefined types: Text, Number, Amount, Date, Time.

Max and Min length
Maximun and minimum field length.

Max and Min Value
It is possible to enter minimum and maximum values (numbers or characters).

Decimal points
It is possible to define the field decimal points

Field number
This is a number automatically given to the field, and has uniquely a technical purpose.

All caps
By clicking this options all fields data will be shown in caps characters.

Date, hour and number format

When the format is modified, the way the date, time and numbers are shown, changes.

If no specific format is specified, the default format of your operating system will be used (date, time and numbers as indicated on the control panel).

In the Format area of the Set up fields/Edit attributes command (Data menu) the user can use other formats. Types of formats, with some examples, are listed below:

This command allows you to manage Tables and Views:

• The Tables:
  These are the elements that contain the data in a format or rows and columns.
   
• The Views:
  Indicated under every table.
  These are the elements that define the way in which the columns of the table are displayed.
  Thanks to the views, one can define which columns need to be visible, the sequence of the displayed columns and the way in which they are displayed. 

View's Settings

In order to add tables, please go to the Add new functionalities command.

For each table, you can define:

• Name
  The name of the table in the file language. This field cannot contain spaces or special characters.
  It can only be changed for added tables.
• Xml name
  The name this is being used for the programming. This field cannot contain spaces or special characters.
  It can only be changed for added tables.
• Header
  The name that appears in thetables list
• Visibile
  Indicates whether the table is visible or not.

Manage Views

Name
It is possible to enter a new name for the selected View.

Xml name
This is the View name for the Xml export. For system Views this name cannot be changed.

Number
This is a number automatically given to the View by the program.

Visible
When selecting this checkbox the View will be visible.

System
If this checkbox is selected the View is a system View and cannot be deleted or edited.

Columns setup...
Displays the Columns setup page that allows to edit them, both in displaying them as well as in setting them up.

Page setup...
This button leads to the page format settings.

Add...
This button adds a new View to the active table.

Delete...
This button deletes a View.

Set as default

Defines the View that is being used.
 

In order to highlight the rows:

• Select the rows to be highlighted and on the icon , click on the first symbol if you want to color the background, and on the second one if you want to color the text.
   
• In order to deactivate the color, select the row(s) and click on No color (present in the menu of each color).

The File info command, from the Tools menu, displays the characteristics of a file.

Columns

By activating the Complete view also the Xml columns are displayed, through which it is possible to transfer the values automatically when exporting the table.

• Section: the Group name of the values
• ID: the specific and explicit identification of the value
• Description: contains an explanation of the value
• The rows in bold print are the section titles that group the different elements together
• Value: the formatted value
• Section XML: The name of the section in English
• ID XML: the identification in English
• Value Xml: the field contents in Xml format.

The Section XML and the ID Xml identify the value unambiguously.

The Add new functionalities command is in the Tools menu. ff

The available option may differ according to the file type.

Add a new simple table

It allows you to add tables completely manage by the user.
Once is added, the table cannot be removed anymore.

You need to indicate the table's name.

The table will have two predefined columns:

• Id column - to indicate a selection group
• Description column - to enter a text

Inside the table you can add new columns with the Columns setup command from the Data menu.

New Documents table

Information are available at the Documents Table page.

Add addresses columns in the Accounts table

For accounting files.

This functions allows you to add, in the Accounts table, specific columns to enter clients, suppliers, or members addresses.

The program will add in the Accounts table the following items:

• the Addresses view, where the addes columns are visible
• the columns that allow you to enter addresses data and other information
  • In order to make one or more of these columns visible also in other views, you need to use the Columns setup command from the Data menu.
  • In order to create views with specific columns, you need to use the Tables setup command from the Data menu.

Add Budget table

For accounting files.

This function adds a Budget table, where you can enter budget transactions.
The program will do the following operations:

• Add the budget table, that will show the budget data indicated in the Accounts table (if present)
• Lock the budget column in the Accounts table
  From now on, the amounts contained in this column, will be calculated based on the budget transactions and on the period defined in the File and accounting properties.

More information are available at the Budget page.

Edit the VAT Amount type column in the transactions

For accounting files with VAT management.

This function allows you to edit the Amount type (VAT amount type) in the Transactions table.

This column allows you to enter, for each transactions, when it is necessary, one of the following VAT amount types:

0 (or empty cell) -  it means VAT included (with VAT/taxes)
1 = VAT excluded - it means VAT excluded (without VAT/taxes)
2 = Tax amount - the transaction amount is considered 100% VAT/taxes amount
For each transaction, the programs automatically fills in the data as setup in the VAT Codes table (for each code). If however, exceptionally, this needs to be changed, you can manually enter 1 or 2 in the Amount type column.

Dank Befehl Kopie Datei erstellen aus Menü Werkzeuge wird sofort eine Kopie der geöffneten Datei erstellt.
Die neue Datei ist unter neuem Namen (Menü Datei → Befehl Speichern unter...) zu speichern.

Diese Funktion ist sehr nützlich, wenn man versuchen möchte, Änderungen an der aktuellen Datei vorzunehmen, jedoch jederzeit wieder auf die bestehende zurückkehren kann.

Kopieren oder verschieben von Buchhaltungsdateien

Banana Buchhaltung ist in der Lage, auf jedem beliebigen Laufwerk zu speichern, welches vom Betriebssystem als eine wiederbeschreibbare Disk anerkannt wird.
Von nicht beschreibbaren Datenträgern (CD oder DVD) kann Banana Buchhaltung Dateien ausschliesslich lesen.

*.ac2-Dateien können verschoben werden:

Von einem Verzeichnis (Ordner) in einen anderen:

• Mit Hilfe von Windows-Explorer oder Finder (für Mac) das Verzeichnis (Ordner) suchen, in dem die Dateien gespeichert sind
• Datei/en in das neue Zielverzeichnis (Zielordner) kopieren oder verschieben. Nach dem Einfügen können allenfalls nicht mehr benötigte Datein aus dem Ursprungsverzeichnis (Ursprungsordner) gelöscht werden.

Von einem Computer auf einen anderen:

• Auf einem Memorystick (USB-Speicherstick) oder externen Laufwerk speichern und dann auf dem neuen Computer speichern:
  • zu speichernde Datei öffnen
  • aus dem Menü Datei den Befehl Speichern unter ausführen und die Einheit mit dem Memorystick (USB-Speicherstick) oder externen Laufwerk auswählen.
  • Die Kopie kann ebenfalls durch Starten von Windows-Explorer oder Finder (für Mac) und Ziehen der Datei mittels Maus in die Einheit des Memorysticks (USB-Speichersticks) oder externen Laufwerks erstellt werden.
• Durch Senden per Email (als Beilage/n) und Speichern auf dem neuen Computer.
   

Buchhaltungsdateien löschen oder umbenennen

Das Programm Banana Buchhaltung hat keine Funktion zum Löschen oder Umbenennen der Datei. Es ist die dafür entsprechende Funktion des Betriebssystems (Windows-Explorer oder Finder (für Mac) zu verwenden.

Dropbox, Google Drive und andere Synchronisierungssysteme

Banana Buchhaltung ist kompatibel mit Systemen zur Synchronisierung der Dateien mit Cloud-Speicher Diensten wie Dropbox und Google Drive.
Banana Buchhaltung überschreibt die *.ac2-Dateien und löscht die *.ac2.bak-Dateien. Im Verzeichnis der gelöschten Dateien können die vorhergehenden Versionen der *.ac2.bak-Dateien gefunden werden.

Die Änderungen anzeigen

Banana Android greift direkt auf dem Dropbox-Server zu. Werden Änderungen am eigenen PC angebracht, muss man in der Regel ein paar Sekunden warten, bis diese auf dem Server bzw. in Banana ersichtlich sind.

Um sicherzustellen, dass die Datei ordnungsgemäss mit dem Server synchronisiert ist, muss die Datei auf dem eigenen PC mit einem grünen Visum versehen sein.

Wenn keine (Sync) Synchronisierungs-Symbole (in grün, rot, blau) erscheinen, ist die auf dem PC installierte Dropbox-Anwendung zu aktualisieren.

Der Synchronisationsstatus auf dem eigenen PC kann auch überprüft werden, indem man unten in der Taskleiste das Dropbox-Symbol anklickt:

Ausserdem findet die Android-Synchronisation nicht statt, wenn die App geöffnet ist. In diesem Fall die Applikation schliessen und neu starten.

Achtung:

Banana Buchhaltung bemerkt nicht, wenn mit Synchronisierungssystemen verwaltete Dateien gleichzeitig auf mehreren Computern geöffnet und bearbeitet werden. So könnte zum Beispiel vorkommen, dass eine Person Daten löscht oder eine andere neue Daten hinzufügt und nur die zuletzt gespeicherte Version der Datei beibehalten wird bzw. die übrigen Änderungen verloren gehen.
Aus diesem Grunde ist höchste Aufmerksamkeit angebracht, um unbedingt zu vermeiden, dass dieselbe Datei gleichzeitig von mehreren Arbeitsplätzen aus bearbeitet wird.

Sicherheitskopie (Backup)

Wir raten unseren Benutzern, auf jeden Fall externe Sicherheitskopien (Backups) zu erstellen, um einen möglichen Datenverlust, infolge z.B. eines Computerabsturzes oder anderer Ursache, zu vermeiden.

• Auf Mac die Funktion "Time Machine" verwenden
• Auf Windows die Funktion "Datei-Chronik (History)" verwenden.

Im Handel sind auch andere Programme erhältlich, die erlauben, automatische Backups Ihrer Daten zu erstellen.

Speichern und *.bak-Datei

Wird gespeichert, so ersetzt Banana Buchhaltung den Inhalt der vorhandenen Datei mit den neuesten Buchhaltungsdaten; dies jedoch nur, wenn der Speichervorgang erfolgreich verläuft:

• Die Daten werden in einer temporären Datei gespeichert.
  Nur wenn der Speichervorgang korrekt abgeschlossen wird werden die gespeicherten Daten mit den zuvor vorhandenen ersetzt.   
• Wird die Option Backup Datei (*.bak) erstellen (Menü Werkzeuge -> Basiseinstellungen -> Erweitert) aktiviert, benennt das Programm die vorhandene Datei mit dem gleichen Namen und fügt die Erweiterung ".bak" hinzu.
  Dadurch wird eine neue Datei "Dateiname.ac2.bak" erstellt, die die Daten vor dem Speichern enthält.

Tritt während des Speichervorgangs ein Fehler auf, z.B. das Netzwerklaufwerk ist nicht mehr verfügbar, ist ein anderer Dateinamen anzugeben, unter welchem die Daten zu speichern sind.

Daten mittels *.bak-Datei wiederherstellen

Kann aus irgendwelchem Grund die Buchhaltungsdatei nicht mehr verwendet werden, so kann auf die Sicherheitskopie zurückgegriffen werden, welche das Programm automatisch erstellt.

So vorgehen:

• Verzeichnis (Ordner) auswählen, in welchem die Buchhaltungsdatei gespeichert worden ist.
• Datei mit der Ausdehnung .bak öffnen. Falls die Datei nicht im Verzeichnis aufgeführt ist, ist unten im Fenster im Feld "Dateityp" Alle Dateien (*.*) auszuwählen.
• Die Datei nach dem Öffnen mit Namen speichern (Menü Datei, Befehl Speichern unter...), wobei die Ausdehnung .bak zu löschen ist.
• Normalerweise wird die Datei gleich wie die verlorene Datei genannt.

Beschädigte *.ac2-Dateien

Computer sind anfällig für Defekte aufgrund technischer Probleme oder Viren. Es kann ausserdem vorkommen, dass per E-Mail gesendete Dokumente beschädigt ankommen.
Deshalb ist es immer ratsam, Sicherheitskopien zu erstellen.
Wurden Ihre Dateien aufgrund eines technischen Fehlers beschädigt, kann unser technischer Support gegen Bezahlung  gerne versuchen, die Daten wiederherzustellen. Bitte stellen Sie uns hierzu Ihre Datei oder Dateien per E-Mail zu und bestätigen Sie uns, dass Sie bei erfolgreicher Wiederherstellung bereit sind, den Unkostenbeitrag gemäss Preisliste zu übernehmen. Bitte vergessen Sie nicht, Ihre Adresse (für die Rechnung) zu vermerken.

This command converts an existing file (which will not be modified) into another one with different characteristics:

• Change language
• Change the roundings
• Change the file type. For example:
  • Pass from an accounting without VAT to one with VAT
  • Pass from a Double-entry accounting to a Multi-currency accounting

It is as if you have created a new blank file and then have manually transferred the data.

The existing file characteristics can be consulted by executing the command Tools -> File Info
 

Creation and data transfer

The Convert to new file command, from the Tools menu:

1. Creates a new file of the specified type with the predefined columns setup
2. Transfers the data into the new file, proceding with the necessary conversions
3. Saves and indicates the name of the new file.

When converting a file with more options into one with fewer options, part of the data will be lost during conversion. If, for example, an accounting file with VAT/Sales tax is converted into an accounting file without VAT/Sales tax, all data in the VAT columns will be lost during conversion.
 

Passing from a Double-entry accounting to a Multi-currency accounting file

• Make sure that in the File and accounting properties the currency symbol is being specified (which will become the basic currency)
• Choose the Multi-currency accounting as destination
• The program creates a Multi-currency accounting, recovering the existing data:
  • The Transactions table includes the columns for managing the Multi-currency accounting, as a currency the basic currency and the exchange rate 1.000
  • The existing accounts in the Accounts table are being completed with the basic currency symbol
    • You have to add the predefined accounts for exchange rate profit & loss.
    • In the File and accounting properties, you have to indicate the predefined accounts for exchange rate profit & loss.
  • The Exchange rate table will be empty; it is therefore necessary to add the currencies and exchange rates used in the transactions
  • In the Accounts table, the accounts in foreign currency have to be added.

In order to change the currency of an accounting file, see the Accounting tab of the File and accounting properties.

Passing from an accounting without VAT to one with VAT

• Choose the desired type of accounting with VAT as the destination 
• The program creates an accounting with the VAT columns, recovering the existing data:
  • Add the VAT accounts into the Chart of accounts
  • The File properties regarding the VAT need to be completed, and the default acccount on which the VAT must be recorded needs to be indicated
  • The VAT Codes table has to be completed with the necessary VAT Codes
    With the Import to accounting command -> VAT codes, the VAT codes table of an existing accounting can be imported (for example it can be imported from a default VAT acccounting template).

Dialog

• The file type, in which the user is working, is being indicated
• For more information on the language, roundings and decimals, go to the File and accounting properties (from the File menu)
• A list with different options appears

Outline to create new file

For more information, please consult the specific page.

Il is possible to merge two files, but they have to belong to the same group (for example two double-entry accounting files). It is not possible to merge files belonging to different groups (for example one double-entry accounting file and one simple accounting file).

In order to successfully merge two files, it is crucial that they have the same accounts numbering. Proceed as follows:

• Open the file which will contain the data of both files
• Select the Merge File command from the Tools menu
• Select the path and the name of the file to be merged
• Confirm the merge operation
• If the files are not the same, even though they belong to the same group, (for example, accounting with VAT/Sales tax and accounting without VAT/Sales tax), a message will appear advising the probable loss of data.

In the Program options window, several technical options are possible for the accounting file.

In the following pages you will find more detailed information.

This dialog window allows you to install, modify settings and uninstall Banana Extensions.
Install an Extension in order to be able to use it.

Installing a new Extension

To install an Extention, proceed as follows:

• Choose the 'language' and 'country'
• From the left menu, select Online
• Select the Extension type (e.g. productivity)
• Look for the desired Extension among those listed; or in the Search box, type the name of the Extension you want
• Click on the Install button
• Click on the Close button

Below are the available Extensions :

The installed Apps will be visible in the Extensions menu.

List of Extensions

This list shows the installed Banana Extensions and those available for installation.

• The check sign will indicate that the App is installed.
• The App denomination
• Information on the Banana Extension.
  • Description
  • Link for main information, will open the relative internet page
  • Last update
    Banana Extension date and hour
    Local Banana Extension date and hour (as per imported file)
  • Category
    Typology of the Banana Extension
  • Nation
    Nation where Extension can be used. International will indicate that Extension can be used in several nations
  • Install button
    Download Banana Extension for local use
• Information on installed Extensions
  • The ">" symbol preceding a packet will designate a Banana Extensions packet, that contains several commands.
  • Enable
    If the enabled box is not checked, the Extension will not figure in the menu. For a packet, single commands may me deactivated.
  • Automatic update.
    When a new version is made available, it will download automatically.
  • Required properties.
    For an Extension to function properly, the Extension properties must be set up in the File and accounting properties (from the File menu - Other tab). 
  • "Apply properties" button
    Will apply new properties for your file
  • "Execute" button
    Will execute the specific command.
    This button will only highlight if the App is applicable in the context of your current file.
    For example, a multi-currency function will only be applicable if the file has been created as a multi-currency accounting file.
  • "Settings" button
    Certain Extensions allow you to set the settings for execution of your task. They will be related to your currently open file. If you use the same App with another file you must redefine the settings.
    In the invoice reports, for instance, we indicate the elements necessary for printing.
  • "Uninstall"button
    Will uninstall the App or the packet.

Search Extensions

Extensions are listed according to the following selection criteria:

• Language
• Nation
• Text
• Installed
  Displays locally installed Apps.
• Online
  List of online available Apps.
• System.
  List of preinstalled Apps. You may enable or disable via the check box.

Help (bottom button)

It links to this page.

Add from file

Let's you add a Banana Apps from a local file. Indicated especially for development of new Apps..

• The file needs to always remain in the same directory.
• If the App is modified, the program will always use the last version.

Add fro URL

Allows you to install Apps present in the list of Apps available on the www.banana.ch website. 

Update Extensions

Downloads the filter's most recent version from Banana Accounting's server.
The downloaded Extension should not be modified because they will be overwritten when updated.
If there are new Extensions , they will be added to the list. The imported filters will not be modified.

The Extensions will be installed in the user folder. Thus only the user who imported the new Extensions or updated the available ones will see them. To install Extensions for all users or at a system level, a manual procedure for installing the Extensions would need to be followed. 

In order to install an App in an offline mode proceed as follows:

• connect yourself to our Apps webpage, using a different computer connected to the internet
• download the App that you need (a .js or .sba file ) and save it on a USB key or other device
• copy the App on the computer without internet connection
• Open Banana Accounting from your computer without internet connection and open your accounting file
• from the Apps menu, choose the Manage Apps command
• click on the Add from file button and select the path were you saved the App
• the App will now be included in the installed Apps and in the Apps menu

From the Labels -> Print command from the Apps menu, you can print the addresses. In the different tabs you can choose different settings, from the label format to le selection of the addresses to be sorted and printed. Each setting can be saved with the Compositions.

For the explanations of the different tabs, please consult the following pages.

• Options
• Label
• Extract
• Sort
• Composition

From the Apps menu, Labels command, Formats option, you can access the labels setup.

The program already offers many predefined label formats; it is however possible to setup personalized parameters through the Default command.

The program already offers many predefined label formats; it is however possible to setup or edit the default parameters, as well as your customized ones, through the Composition (Default) command.

Compositions are saved personalized settings that can be used at a later date.

It is possible to create Compositions for the following accounting data:

• Account cards
• VAT report
• Enhanced Balance Sheet
• Enhanced Balance Sheed by groups
• Reports
• PDF dossier
• File export
• Extract and Sort rows
• Addresses / Labels

How to obtain Compositions

Compositions can been obtained mainly through the Account1 menu when it is about the Accounting cards, the Enhanced Balance sheet, the Enhanced Balance sheet with groups, the Reports and the VAT report, and from the File menu for the compositions concerning Create Pdf dossier and Export file. 

• Once the document to be created has been chosen, start from the corresponding menu (Ex. Account cards or Enhanced balance sheet by groups...) and click on Default
• from the dialog windows that appears click on Composition and on the New button
• enter the name of the new composition
• check the desired options
• click on the Apply button

Each composition, once created, will appear in the menu of the corresponding command and can be edited, renamed, duplicated or deleted.

Name
Enter a name to identify the composition (for instance, Quarterly Report).

Description
Enter the description for the composition.

Show this window every time
If activated (default), when selecting a composition from the menu, the dialogue for editing the settings will be shown. If not activated, the preview of the requested report (Balance sheet, report, etc.) will be shown directly.

Show in menu... (depending on the menu/command in which one is being positioned)
If this option is activated, the composition will appear in the menu of the command.

Show in 'Favorites' menu
If this option is activated, the composition will appear in the Favorites menu.

Read only
If this option is activated, it will not be possible to edit the settings.

New
This button allows you to create a new composition.

Delete
This button allows you to delete an existing composition.

Duplicate
This button allows you to duplicate a composition.

Import
This button allows you to import a composition from another Banana Accounting file.

Apply
This button allows you to save the chosen settings for the new composition.

Display in the starting menu

According to the menu you are in, the Default composition and your personal saved compositions will be shown.

Composition (Default)
This is the composition used by default from the program, if no other composition has been created.

In the following example the menu of the Accounting reports is shown.

Direct access to the compositions

In the tables where the compositions are being shown and in the previews, the composition menu and the settings icon are being displayed. These make it possible to easily move from one composition to the next and provide rapid access to the settings in case you want to edit these. 

You can also consult the list of keyboard shortcuts directly from the program, by choosing Keyboard shortcuts from the Help menu.

Short-cut Keys

List of messages

• Complete list of error messages
• For further information on the Message Error window refer to the Interface page.

If the program displays error messages

• revert to the the help page for the reported error: in the 'Info' and 'Messages' (where the error messages appear), next to the error message, the  symbol will show. By clicking on this symbol, you will be connected directly to the online page corresponding to the error, containing the possible causes and solutions.
• If the error persists:
  • Update your software to the latest available version, by downloading it at the following page Download.
  • Check Accounting.
  • In Multi-currency Accounting, ensure that Exchange Rrate differences have been generated and applied.

Deactivate and Reactivate Error messages

• Deactivate visualisation of error messages: 
  • Checking the box "Don't warn" in the dialogue
  • Unclick Warning Messages (Window Menu)
• Reactivate visualisation of error messages: 
  • Click Warning Messages (Window Menu)
  • With the Check Accounting command

New import extensions

In the new version Banana Accounting Plus, you will find new extensions for importing data from SmartBusiness and also files in .zip format.
We advise you to switch now to Banana Accounting Plus and take advantage of the many new features.

Supported import formats

With Banana, one can import from whatever format (see the list of current supported formats). In case you should need to import from other file types that are not included in the list, specific Banana Import Apps can be developed.

The Import to accounting command

The Import to accounting command from the Account1 menu makes it possible to import the following data:

• Transactions - to transfer the transactions from another Banana file or from the bank statement
• Accounts - to transfer the accounts from another Banana or a text file
• VAT codes - to transfer the VAT codes from another Banana file or from a text file
• Files - to transfer a complete file in order to convert the Chart of accounts

In order to transfer data just one single time, please consult Transferring data from other accounting software.

Procedure for importing

1. Choose the destination table of the data
2. Choose the file type from which to import
3. Indicate the file name
4. Choose the transactions to be imported

Destination table

For each data type, there are specifique pages

• Import transactions
• Import accounts
• Import VAT codes
• Import exchange rates

Import formats

According to the type of destination table, different import formats are availbale.

However, the following formats are available for all options:

• Text file with column headers
  These are files that are especially created with other programs (for example, a program that creates invoices) so that the data can be transferred into Banana Accounting.
  Technical indications on how to prepare these type of files can be found here.
• There are also other file types for which a specific import filter exists or has been created.

File name

• The name of the file of which the data need to be imported needs to be indicated here. 

Manage apps...

• To add or to update import filters.
  Scripts that decode file types can be created.

Ok Button

• Starts the import.

Error messages

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

Das Transferkonto (auch Interimskonto, Durchlaufkonto oder Geldtransitkonto genannt) ist ein Zwischenkonto oder Hilfskonto. Buchungen werden auf diesem lediglich für eine bestimmte Zeit „geparkt“. Es wird insbesondere in den folgenden Fällen eingesetzt:

• Erfassung von MwSt/USt-Selbstauferlegung und Rückforderung der Vorsteuer (Bezugssteuer auf Dienstleistungen aus dem Ausland).
• Import von Kassenbuch- oder Kreditkartendaten in die Hauptbuchhaltungsdatei.
• Buchen von den von der Bank belasteten Nettolöhnen bis zur vollständigen Erfassung der Bruttogehälter mit den verschiedentlichen monatlichen Abzügen.

Verwendung des Transferkontos beim Import

Wenn Bewegungen einer Kreditkarte, einer separaten Kassendatei oder andere Datei importiert werden, wird das Transferkonto benutzt, um Überschneidungen mit bereits ausgeführten Transaktionen zu vermeiden.

Bei Einzahlungen vom Bank- (oder Postkonto) auf die Kreditkarte oder Kassendatei, welche separat von der Hauptbuchhaltungsdatei ist, muss in beiden Dateien registriert werden:

• In der Datei der Kasse oder Kreditkarte wird der Geldeingang gebucht (die Kasse oder das Kreditkartenkonto nimmt zu).
• In der Hauptbuchhaltungsdatei wird der Ausgang vom Bank- oder Postkonto und die Erhöhung der Kasse oder Kreditkarte gebucht.

Beim Importieren von Kassen- oder Kreditkartendaten in die Buchhaltungshauptdatei, können Überschneidungen der Datensätzen erfolgen, welche zu falschen Salden führen.

Um dieses Problem zu lösen, ist ein Transferkonto als Gegenkonto zu verwenden. Dies gilt für die Erfassung der Auszahlung der Bank (Hauptbuchhaltung) als auch der Bareinlage in die Kasse (separate Kassendatei).

Mit dem Import der Kassen-Bewegungen in die Hauptbuchhaltung, gleicht sich das Transferkonto aus bzw. geht auf Null:

• Die aus der Kassen- oder Kreditkartendatei importierten Daten befinden sich auf der Soll-Seite des Transferkontos.
• Die bereits registrierten Einlagen-Bewegungen mit Belastung auf dem Bank- oder Postkonto, befinden sich auf dem Transferkonto auf der Haben-Seite.

Weitere Details zum Import mit Transferkonto finden Sie auf der Webseite Daten aus der Kasse importieren.

On the page web filter for PayPal transactions you will find the information about the new feature that makes it possible to import all the Paypal transactions directly into Banana Accounting and the instructions on how to proceed (see below).

We have also prepared specific predefined templates for double-entry or multi-currency accounting that you can look at as an example or use as a separate accounting file just for the accounting transactions from Paypal.

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

• BananaApp for importing Paypal transactions - how to proceed
• examples for the Double-entry accounting
• examples for the Multi-currency accounting
   

Learn more

• Double-entry accounting
• Multi-currency accounting
• Import filters - complete list

In order to import the rows, click on the Import Rows command of the Data menu.

Activate the options of your choice in the following window:

File name
Using the Browse button, select the file from which to extract the data. By clicking on the OK button, confirm the options selected.

Format
This area contains the list of formats with which it is possible to import the data to the table. These include: ASCII format, Text, CSV.

Options

Import data from clipboard
By selecting this box, the user can import data from the Windows clipboard.

Autocomplete values
It is advisable to select this function when it is necessary to import rows from a less complex accounting file into a more complex one. In this case, in the imported rows, some columns will stay blank. By selecting this function, the program will automatically complete the missing values with those from the current accounting.

Fields header 
By selecting this box, not only data, but field headers will be included in the import.

Unicode (Utf-8)
By selecting this box, all the data will be imported in a format readable by Unicode programs.

New import extensions

In the new version Banana Accounting Plus, you will find new extensions for importing data from SmartBusiness and also files in .zip format.
We advise you to switch now to Banana Accounting Plus and take advantage of the many new features.

Recurring data importing from other programs

It can often happen to be regularly needing to import data from other programs.

For example:

• 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).

In these cases you can proceed in two different ways:

• make sure that your application exports the data in a txt file format specifically set to be imported in Banana.
  For more information please consult the technical information on how to create a file to be imported in Banana;
• create an import script that will transform data exported from another program so that they can be imported in Banana; depending on the installed import filters (see the Manage filters page), many formats can be available. See also how to create filters (Banana App)

One time data importing from other programs

If you are starting to work with Banana for the first time and you need to import your data from another software, you can easily transfer data from any accounting program, passing through MS-Excel.

1. With your old accounting software, export the data in a format that can be read by Excel (CSV, txt, ...)
2. Open the exported file with Excel
3. In Excel, organize the data (columns) in the same order as they appear in the Banana tables (Accounts, Transactions)
4. Open your new accounting file in Banana
5. In the Accounts or Transactions table, add as many empty rows as there are rows to transfer from Excel.
6. In Excel, select the data to be copied and use the Copy command
7. Go in Banana and execute the Paste command.

This method is useful to transfer data from MS-Money, Intuit Quicken and Quickbooks, and from most other accounting programs.

Developers, please also see our webpage Import data.

Export selection only
When activating this option, the program exports only the selected area.

File Name
In this area it is necessary to insert the name of the new file that the program will create to export the data. If, however, an existing file is selected by using the Browse button, the program will overwrite it with the new data.

Display file immediately
As soon as the MS Excel file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately.

Options

Create cell names
This option will automatically give a name to each cell as the file is exported. For example, the cell that contains the balance for account 1000 will receive the name: "Accounts_1000_Balance" in Excel. This means the user can univocally identify each cell independently from its position on the sheet and thus create Excel reports that don't have to be corrected if the account plan is changed. The user thus saves having to manually carry forward any accounting data to Excel. However, inserting the names of the cells does slow down the opening of the Excel file.

Create table names
With this option, the program will automatically give a name to the whole area of the cells belonging to a table, at the moment the file is exported. For example, the area formed by the cells belonging to the Accounts table will be identified by the name DB_Accounts. This option is necessary if, when creating reports in Excel, database functions are used.

Use names Xml (English)
The cell names can either be defined in their original accounting language, or with their English name. In the original language, the names will be understandable to someone who speaks that language, but they will not be universally understood like a name in English would be. By selecting this option the user would have, for example, "Accounts_1000_Balance" instead of "Conti_1000_Saldo".

Protect tables
The entire content of cells is locked when selecting this option so that it is only possible to edit the format. This prevents the possibility of making any unintentional changes to the exported data. The user can remove this protection at any time by using the appropriate command in Excel.

Export selection only
If this cell if activated, only the selected area is exported.

Other Tabs

For the explanations of the other tabs, please visit the following pages:

• Include
• Period
• VAT
• Composition

Export result

Each accounting table is displayed in a different sheet in the Excel file

Use the cell names instead of the row/column references:

• The names return the desired value even when a new row or column is being entered.
• The names are easy to use and understand
  "Accounts_1000_Balance" refers to the balance of the 1000 account
  "Accounts_1000_Description" returns the value of the cell that contains the description of the 1000 account
• The names can be used in the formulas
  "=Accounts_1000_Balance" returns the value of the cell that contains the balance of the 1000 account
  "=Accounts_1000_Balance/1000" divides the balance of the 1000 account by 1000
• By using the names, it is possible to create links to various files.

A link to a cell is being composed of:

• File name
• Table name
• Cell name

Recheck accounting
By ticking this box, the accounting will be rechecked before it is exported.

Include

By ticking the different boxes, the user can export in MS Excel Xml the various tables and/or all the account cards and the VAT/Sales tax Report.

View
It is possible to select the view where the data are to be imported. This option is available for the export in PDF, Html and Xml format.

Periods

This function lets the user export the accounting data subdivided by period.

Accounts/Categories by period
This option allows to export the accounts and categories balances according to the selected period.

VAT/Sales tax report
This option allows to export the VAT/Sales tax report according to the selected period.

Create periods for the whole year
By selecting this function, the partial balances for the whole year will be exported, and not only the ones of the specified accounting period or the selected export period.

Max number of periods
The maximum possible number of periods.

File Name

In this area, the user must insert the name of the new Html file that the program will create to export the data. If however the user selects an existing file through the Browse button, the program will overwrite it with the new data.

Display file immediately

As soon as the Html file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately. It is best to remember that browsers like Mozilla and MS Explorer use a cache mechanism for files. When the export is made for a second time, it is possible that the user will see the previous version until the browser Reload button is pressed.

File creation options

Headers 1, 2 and 3

These are the file headers.

Other Tabs

For the explanations of the other tabs, please visit the following pages:

• Include
• Period
• VAT
• Composition

File Name
In this area it is necessary to insert the name of the new file that the program will create to export the data. If, however, an existing file is selected by using the Browse button, the program will overwrite it with the new data.

Display file immediately
As soon as the file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately.

Style sheet XSLT
In this area, the user can select the style sheet according to which the program should organize the graphic display of the accounting data. Thanks to the style sheets, the user can input his/her own data and conform to the print-outs required by the authorities. On the www.banana.ch various examples and further information on style sheets are available.

Options

It is possible to choose between the following options:

• Export visible columns only
• Include view list

Export selection only
If this option is activated, only the selected area will be exported.

Other Tabs

For the explanations of the other tabs, please visit the following pages:

• Include
• Period
• VAT
• Composition

In order to export rows, please select the Export rows command from the Data menu. Different options are available:

File name
Enter the file name or select an existing one using the Browse button

Format
Select the desired format.

Display file immediately
As soon as the file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately. Please notice that browsers such as Mozilla or MS-Explorer have a documents cache mechanism. It is then possible that, when exporting a second time, you will still see the previous version if you don't use the Refresh browser's button.

Options

If activated, different options will allow the export of:

• selected rows only
• visible columns only
• columns header
• unicode (Utf-8)

This window is shown when you need to create a PDF file, export in Html or Excel format, or copy into the clipboard.

File Name
In this area it is necessary to insert the name of the new file that the program will create to export the data. If, however, an existing file is selected by using the Browse button, the program will overwrite it with the new data.

Display file immediately
As soon as the file has been created, the software to view it will be launched. In this way, the result of the export can be seen immediately.

Adding the ${...} field

The ${...} field allows the user to add dynamic text to the document, for instance an account's balance or a Banana table. The Banana API interface is available at the following web address https://www.banana.ch/doc9/en/node/4714
The command can be added manually or through the command Edit - Add script

Printing the current balance of account  1020

${Banana.Converter.toLocaleNumberFormat(Banana.document.currentBalance('1020','','').balance);}

Output of the Accounts table, columns:  Account, Group, Description, Balance (command not yet available)

${HTML Banana.document.table("Accounts").toHtml(['Account','Group','Description','Balance'],true);}

It is possible to write the javascript code in a separate document and include the script through the command Banana.include.
The scripts can be saved in the Documents table or in a local file.

${Banana.include("documents:myscript1");rtnValue}
${Banana.include("c://temp//myscript16.js");rtnValue}

Adding a page break

The command can be added manually or through the comand Edit - Add page break

Text in the first page
${PAGEBREAK}
Text in the second page

The command ${PAGEBREAK} is not yet available, the current command to add a page break is:
<!--pagebreak-->

You can access the page numbering feature by clicking on the icon on the Print Preview toolbar.

In this dialog box are set the options for page numbering. The printing of the page number is enabled or disabled by using the settings of page setup or report.

Start with
The starting number for page numbering.

Add prefix
The prefix to insert to the page numbering.

Allows to define the Printing properties.
Each View of the table has its own own print setting. The name of the view is indicated in the dialogue title.

Header left

This is where the title for the current view is shown. The title can be edited to appear at the top left of the printed page.

Header right

It is possible to enter a different text that will be printed at the top right-hand side of the page.

Logo

Press the Change button on the right and then select Add, as we also explain in the Setup a logo page; add your own logo.
Back to the Page setup window, choose Logo instead of none.

Margins

It is possible to input the page margins here: Left, Right, Top, Bottom. Measurements are in centimeters.

Shrink page to printable area

This function makes it possible to adapt the printable area when the print goes past the earlier defined page margins.

Include in print

When these functions are being activated, they allow to display the following data:

File Headers

This is the text that is being entered in the File and Accounting properties found in the File menu.

Page Headers

The page header will also be included in the printout.

Table Name

The table header (f.i. Accounts, Transactions, etc.) is also being included in the printout.

Column headers

These are the headers for the various table columns.

Large font

The program prints the headers using a slightly larger font.

Page break

When activated, this option maintains the entered page breaks; if not, they will be ignored, even if they are present.

Page numbers

Activate this option to request that the pages be numbered.

Print time

Activate this option to include the hour when the page was printed.

Print date

Activate this option to include the date when the page was printed.

Row number

Activate this option if a progressive number is to be given to each row.

Grid

The grid can be printed just as it is viewed on screen.

Layout

The program automatically adapts the page dimension.

Font size %

This allows the increase or decrease, on a percentage basis, of the size of the font to be printed.

Reduce to page width

If some columns exceed the width of the page, the program reduces the columns or reduces the zoom so that all the columns will be printed correctly on the page.

As on screen

The print-out will be carried out exactly as presented on the screen.

In case the contents goes past the page dimension:

• If the option "Reduce to page width" is being activated, the font size will be reduced;
• If the option "Reduce to page width" is not being activated, the part that goes past the paper will not be printed.

Print black and white

All colors will be converted in grey scales.

Print landscape

To print in landscape format which makes the page read horizontal.

This tab appears in many dialogs (for example the Account card) and can specify the period to be show or to be calculated.
If for example a quarter is selected: in the account card only the transactions of the selected quarter will be shown, and in the balance sheet only the results for the selected quarter will be calculated.

All
If this option is selected, the entire accounting period is included.

Period selected
If a specified period is desired, indicate the start and end dates.

Transactions with no date
If there are transactions with no date, they will be considered only if you chose the whole period (All...)
If however you enter the initial and final dates January 1sr and December 31, the transactions with no date will not be included in the report.