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.

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

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.

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.

Video Double-entry accounting: video tutorial that shows you how to easily set up a Double-entry accounting, adapt the Accounts table, set a budget, enter the transactions and print reports.

Creating an accounting file, starting from a template

Proceed as follows:

1. File menu, New command
2. Select the region, the language, the category and the accounting type
3. From the list of the templates that appears, select the template that is closest to your own needs.
4. Click on the Create Button

In the Search area, when entering a key word, the program displays the templates that contain the entered key word.

It is equally possible to start from a blank file, by activating the Create blank file option. In any case, in order to facilitate the start and avoid grouping errors, we recommend that you always start from an existing model.

More information on how to create a new file is available on the Create New File page.

Save to disk

With the File-> Save As command, save the data and also assign an name to the file. The typical save dialog of your operating system appears.

• It is advisable to use the name of the company followed by the year  "Company-2020." to distinguish it from other accounting files.
  The program will add the "ac2" extension.
• You can keep as many accounting files as you need, each will have its own name.
• You can choose the folder you want, (for example, Documents -> Accounting) or the support you want like a disk, usb or cloud.
  If you also expect to have documents linked to the current year's accounts, it is suggested that you create a separate directory for each accounting year having to group all the files.

General use of the program

Banana Accounting inspires itself from Excel. The user directions and the commands are kept as similar as possible to the ones of Microsoft Office.
For more information on the general use of the program, we refer to the explanations on our page Program interface.
The accounting is being contained in tables; all of them have the same way of operating.

Customizing the Chart of accounts

In the Accounts table, customize the Chart of accounts and adapt it to your own needs:

• Add new accounts and /or delete existing ones (see Adding new rows)
• Modify the account numbers, the descriptions (for example, enter the name of your own Bank account), enter other groups, etc.
• To create subgroups, please consult our Groups page.

In the Chart of accounts, you can also define Cost centers or Segments, used to attribute the amounts in a more detailed or specific way.

The Transactions

The Transactions have to be entered into the Transactions table; together they compose the Journal.

In the specific columns:

• Enter the Date
• Enter the Document number, manually assigned to the paper document. This makes it possible to easily locate the documents once the accounting transaction has been entered.
• Enter the Description
• Into the Debit account column, enter the destination account
• Into the Credit account column, enter the account of origin.
• Enter the Amount. In the accounting with VAT, enter the gross amount, VAT included. The program will separate the VAT, splitting the net cost or net income.

Speeding up the recording of the transactions

In order to accelarate the recording of the transactions, you can use

• the Smart fill function that allows the automatic autocomplete of data that have already been entered at an earlier date.
• the Recurring transactions function, used to memorize recurring transactions into a separate table.
• importing your bank or postal account statement from the e-banking.

Transactions with VAT

In order to enter transactions with VAT please proceed as follows:

• from the File menu, choose New command and choose Double-entry accounting with VAT/Sales taxes
• Choose one of the existing templates for your nation with double-entry accounting with VAT codes and VAT Codes table.
  In order to enter transactions with VAT, please visit the Transactions page.

Transactions on multiple rows

Transactions on multiple rows or Composed transactions are transactions involving more than two accounts and credits/debits on multiple accounts (for example when you pay different invoices from the bank account). In this case you need to enter the transaction on multiple rows:

• in the first row enter the total amount and the account debited or credited
• when all the individual debit and credit rows are entered there shouldn't be any difference

For more details, consult the page Composed transactions.

Checking customer and supplier invoices

Banana allows you to keep an eye on the invoices to be paid and the receivable, issued invoices. Please consult:

• Customers sub-menu
• Suppliers sub-menu

The Account card

The Account card automatically displays all the transactions that have been recorded on the same account (for example, cash, bank, clients, etc).

To display an account card, just position yourself with the mouse on the account number and click on the small blue symbol that appears.

Account card by period

To display the account card with the balances referring to a specific period, click on the Account1 menu, Account card command, and in the Period section, activate  Period Selected, entering the Start and the End date of the period.

For more details, consult the Period page.

Printing the Account card

In order to print one account card, just display the card from the Accounts or the Transactions table and launch the print from on the File menu.

To print several or all account cards, click on the Account1 menu, Account card command, and select the account cards that need to be printed. By means of the Filter, all the account cards, or only a part of all of them (for example, only accounts, cost centers, segments), that need to be printed can be automatically selected.

For more details, consult the Account Card page.

The Balance Sheet and Profit and Loss Statement

The Balance sheet shows the balances of all the estate accounts, Assets & Liabilities. The difference between the Assets and the Liabilities determines the Share capital. 

The Profit & Loss statement shows all the Expense & Revenue accounts. The difference between the Expenses & Revenue determines the Profit or Loss of the Accounting year.

The display and the printing of the Balance Sheet is being executed from the Account1 menu, Enhanced Balance Sheet and Enhanced Balance Sheet with groups commands.

• The Enhanced Balance Sheet command simply lists all the accounts without distinguishing Groups and Subgroups
• The Enhanced Balance Sheet with groups command lists all the accounts while subdividing Groups and Subgroups; besides, it presents numerous features to customize the presentation, functions that are not provided in the Enhanced Balance Sheet.

Data archiving in PDF format

At the end of the year, when the entire accounting has been completed, corrected and audited, all the accounting data can be archived with the Create PDF dossier command of the File menu.

The Budget

1. Accounts table, Budget column. For each account, the annual budget amount is being indicated.
   In this case, when you set up the Budget from the Account1 menu, Enhanced Balance Sheet with groups command, the Budget column displays the amounts that refer to the entire year.
2. In the Budget table, that can be activated through the Tools menu, Add new functionalities command.
   In this table, you can enter all the budgeted costs and revenue by means of entering transactions. If you activate this table, the column of the accounts table will be automatically deactivated.
   In this case you can set up a detailed budget, taking into account the possible variations over the year and in different periods of the year.

For more details, consult the page Budget.

L'applicativo Contabilità in partita doppia soddisfa i criteri professionali per le società ed enti di qualsiasi genere dove è richiesta per legge la tenuta della contabilità.

• È uno strumento molto potente, ma anche flessibile e facile da usare, perché le diverse funzionalità sono attivabili e disattivabili. Questo ti permette di gestire sia contabilità essenziali, sia altre con piani conti strutturati su più livelli: con IVA, controllo clienti e fornitori, fatturazione, centri di costo e segmenti.
• Puoi sempre modificare, per cui tutti possono avere risultati perfetti. È ideale per il contabile esperto che vuole lavorare velocemente e per chi inizia. Per questo motivo è usato per insegnare la contabilità in molte scuole.

Simile a Excel

Funzionalità e comandi simili a Excel

• Tutti i dati che inserisci nelle tabelle sono sempre visibili e a portata di mano.
• Lavori velocemente perché puoi selezionare, copiare e incollare, su più celle e più righe le registrazioni che si ripetono.
• Se sbagli puoi correggere annullando o ripristinando le operazioni.
• Aggiungi quante righe vuoi senza limiti, o elimina le  righe che non hai bisogno.
• Se hai sbagliato un valore, un conto, un codice IVA, una descrizione, con la funzione Cerca e sostituisci correggi in un attimo
• Non hai bisogno d'inserire formule perché i calcoli vengono aggiornati immediatamente e hai una visualizzazione contestuale (come nei fogli di calcolo).
• Tutto quello che si vede può essere stampato o esportato in pdf o altri formati.
• Puoi impostare il  logo della tua azienda per personalizzare le intestazioni di stampa.
• Le colonne sono personalizzabili, puoi spostarle di posizione, aggiungerne nuove e cambiarne la larghezza.
• Lavora con il formato che ti è più congeniale.
• Colora le righe per individuare subito le registrazioni che devi rivedere o fare vedere al commercialista o da completare.

Basato su tabelle

La gestione della contabilità si concentra in due tabelle, che si usano in modo simile alle tabelle di Excel, ma che sono già completamente impostate e programmate con tutto quanto serve per tenere la contabilità in modo veloce e sicuro. 

• Tabella Conti.
  Imposti tutti i conti della liquidità, dei clienti, dei fornitori, ecc. e inserisci i saldi iniziali senza doverli registrare manualmente nella tabella registrazioni. Puoi raggruppare più conti insieme, come per esempio la cassa, la banca o la posta nel gruppo della liquidità, così in un attimo hai i saldi aggiornati che puoi verificare immediatamente.
• Tabella Registrazioni.
  Il cuore della tenuta contabile, dove si inseriscono o importano i movimenti. Le registrazioni dare e avere, possono essere completate con ulteriori informazioni per gestire clienti e fornitori, emettere fatture, gestire centri di costo/profitto, segmenti, quantità e prezzi e quant'altro si necessita. Scorrendo la tabella si ha una visione completa di tutti gli accadimenti. Si può modificare in modo da avere una contabilità sempre perfetta.
• Tabella Totali.
  Presenta i totali per Gruppo e serve per controllare la quadratura contabile.

Ulteriori tabelle che si possono aggiungere e che supportano ulteriori funzionalità.

• Tabella Preventivo.
  Per allestire previsioni finanziarie, con il metodo della partita doppia. Quindi complete di piano della liquidità,  bilancio e conto economico previsionale, previsioni clienti, fornitori, investimenti, progetti, segmenti per uno o più anni.
• Tabella Codici IVA.
  Per impostare le aliquote e i parametri necessari da usare nella tabella Registrazioni per il calcolo automatico dell'IVA e i rendiconti da presentare alle autorità fiscali.
• Tabella Articoli.
  Per impostare un elenco di articoli da usare per la fatturazione. Il programma tiene nota delle entrate e uscite.
• Tabelle libere.
  Per fare fronte a ulteriori necessità.

Inizio veloce

Modelli

La gestione della contabilità si concentra principalmente su tre tabelle, che si usano in modo simile alle tabelle di Excel, ma che sono già completamente impostate e programmate con tutto quanto serve per tenere la contabilità in modo veloce e sicuro:

• Avvio facile e immediato, creando il file della tua contabilità partendo da un modello.
• Se hai già un modello tuo in Banana Contabilità puoi riprenderlo con tutte le impostazioni e utilizzarlo per una seconda contabilità.
• Oltre 1000 modelli suddivisi per nazione e tipologia di utenza, personalizzabili e con documentazione d'uso.
• Ricerca facile e uso modelli direttamente nel programma.

Impostazione contabile

• Per la tua contabilità imposta liberamente la moneta, la puoi scegliere da un elenco di monete mondiali o impostata liberamente (cripto monete). 
• Imposta liberamente un periodo contabile, anche su più anni e non legato al classico periodo dal 1 di gennaio al 31 di dicembre.
• Intestazioni e dati base contabilità impostate in un'unica finestra di dialogo, facile da visualizzare.
• Inserisci quanti decimali vuoi, da 0 a 27 (scelti al momento della creazione della contabilità).
• Puoi cambiare il numero dei decimali della contabilità durante l'anno senza problemi.

Multi-lingue

• Hai libertà di scelta della lingua della contabilità, quando crei il tuo file. 
• Personalizza le intestazioni delle colonne come desideri.
• Puoi avere contabilità in più lingue contemporaneamente.
• Personalizza le Stampe anche per più lingue.

File e salvataggio dati

• Hai tutti i dati salvati in un unico file, dove trovi facilmente tutto senza perdite di tempo.
• Per ogni anno crei un File separato. Tutti i dati sono riferiti all'anno e non ci sono confusioni.
• Attribuisci al file il nome che desideri.
• Con una sola licenza puoi gestire un numero illimitato di contabilità. 
• I dati rimangono in tuo completo possesso.
• Salva i dati del su qualsiasi supporto, computer, rete, cloud o inviato per email. Puoi accedervi ovunque sei.
• Accesso in contemporanea da più utenti, ma solo una persona può invece aprire il file in modifica.
• Rendi più sicura la tua contabilità inserendo una protezione con password.

Pianifica-Esegui-Controlla

Con lo stesso file e sempre con il metodo della partita doppia, puoi fare la contabilità, oppure le tue previsioni o entrambi. Puoi facilmente usare il potente approccio gestionale Pianifica - Esegui - Controlla.

Metodo contabilità in partita doppia

• Banana Contabilità ti permette di tenere la contabilità con il metodo internazionale della partita doppia, conforme agli standard internazionali.
• Soddisfa i criteri per la tenuta di qualsiasi contabilità.
• Utilizzabile in qualsiasi nazione.
• Registrazioni con colonne Dare e Avere.
• Se nelle registrazioni ci sono degli sbilanci, hai la segnalazione della differenza.
  Nelle colonne hai la visualizzazione degli importi nel formato usato dal tuo computer, senza doverti abituare ad altri formati a te non congeniali.
  • Importi in dare in positivo e in avere in negativo.
  • Calcoli secondo l'equazione Dare - Avere = 0.
• Bilancio, Conto Economico e tutte le tipiche stampe contabili.
  • Stampe tutte personalizzabili.
  • Formato di visualizzazione a scelta.
• Registrazioni secondo il principio di cassa o di competenza .
• Proteggi i tuoi dati con la tecnologia all'avanguardia del blockchain (metodo brevettato).
• Il metodo della partita doppia è usato da molte scuole in tutto il mondo, per insegnare la contabilità.

Piano dei conti

• Piano conti completamente personalizzabile per rispondere meglio alle tue necessità.
• Lo stesso piano conti lo utilizzi per la contabilità e per le previsioni finanziarie, patrimoniali e di reddito.
• Schema di Bilancio e Conto economico adattabili secondo la struttura e i contenuti che hai bisogno.
• Supporta qualsiasi schema di raggruppamento nazionale, internazionale o libero.
• Conti fuori bilancio per la gestione delle partite che non devono essere incluse nel Bilancio, ma che hai bisogno di annotare.
• Scegli tu l'identificativo del conto liberamente (conto numerico o alfa-numerico, fino a 256 caratteri).
• La descrizione del testo puoi inserirla liberamente fino a 256 caratteri.
• Non serve più inserire il bilancio iniziale e finale nelle scritture contabili
  Inserisci i saldi direttamente nella colonna Apertura della tabella Conti e solo la prima volta che usi Banana Contabilità. Negli anni successivi il riporto è automatico.
• Saldo, movimento conto e totali visualizzati contestualmente e sempre aggiornati.
• Ad ogni conto del cliente, fornitore, socio hai le colonne per inserire gli indirizzi e altri dati utili che necessiti.
• Aggiunta di altre colonne per note, raggruppamento o importi.
• Se aggiungi delle colonne di tipo importo, queste sono totalizzate automaticamente.
  Hai così la possibilità di creare delle colonne con dati propri e avere dettagli molto selettivi.

Registrazioni

• Puoi inserire Registrazioni singole o composte.
  Quelle singole le registri su un'unica riga, mentre quelle composte ti permettono di registrare senza problemi operazioni che toccano più conti.
• Puoi registrare sia con il Metodo di competenza o con quello di Cassa.
• Quando registri ti vengono proposti i testi già inseriti. Basta un click per completare la registrazione (auto-completamento).
• Segnalazione immediata di errore e differenze, con possibilità di completarli successivamente.
• Memorizza le operazioni ripetitive per riprenderle quando si ripresentano senza doverle riscrivere.
• In tutte le tabelle hai delle colonne colonne predefinite che può rendere visibili a scelta.
• Colonne quantità e prezzo, per fatturazione o controllo costi.
• Auto-numerazione documenti con numerazioni diverse contemporaneamente.
• Per avere documenti in ordine e sempre a portata di mano, collega ai file i giustificativi digitali (pdf, immagini), e aprili con un click.
• Inserisci testi liberi fino a 256 caratteri e anche su più righe.
• Colora le righe per cercare subito le registrazioni che devi verificare o correggere in seguito, oppure per segnalarle al revisore.
• Aggiunta di colonne per inserire qualsiasi ulteriore informazione. 
• Salva la disposizioni delle colonne (viste) per visualizzare i contenuti per te più importanti.
• Informazioni contestuali circa saldo del conto, differenze o errori.
• Prima delle chiusure periodiche o di fine anno puoi usare le Registrazione di verifica saldo.
  Potrai individuare errori tra i saldi effettivi (es. saldi bancari fornite dall'estratto, e quelli della contabilità). Ti accorgerai subito degli errori e puoi correggere per avere tutto in perfetto ordine.
• Importazione movimenti:
  • Velocizza l'inserimento delle registrazioni importando i dati dagli estratti bancari digitali.
  • Puoi importare i movimenti nei diversi formati bancari.
  • Le righe importate possono essere modificate, completate o rimosse. 
  • Importa anche dati fatture o da altri programmi.

Previsione finanziaria

• Se necessiti di creare un preventivo puoi attivare la funzione aggiungendo la tabella Preventivo.
• Lavori senza difficolta con la stessa metodologia a cui sei già abituato, basata sul metodo della partita doppia.
• Previsioni finanziarie completi di piano della liquidità
• Previsioni di Bilancio.
• Previsioni di Conto economico.
• Proiezioni automatica per più anni.
• Inserimento della pianificazione tramite registrazioni di preventivo.
• Entrate e uscite ricorrenti impostate con una sola registrazione.
• Tutte le funzionalità disponibili in contabilità:
  • Registrazioni semplici o su più conti.
  • Previsioni per clienti
  • Previsioni per fornitori, IVA, Centri di costo e profitto, segmenti.
  • Quantità e prezzi.
• Formule di calcolo in Javascript con accesso ai valori della previsione in corso:
  • Piano crescita della cifra d'affari.
  • Calcolo commissioni e costi in percentuali delle vendite.
  • Calcolo ammortamenti.
  • Calcolo interessi.
  • Utilizzo di variabili.
• Valori di previsioni disponibili nelle stampe contabili:
  • Completamente personalizzabili.
  • Visualizzazioni previsioni per mese, trimestre, semestre, anno.
  • Confronti previsione e attuale.
• Scheda conto con movimenti di previsione per conto o gruppo.

Bilancio e Conto Economico 

• Rendiconti con dati consuntivi, o preventivi oppure con entrambi i dati e con indicazione degli scostamenti.
• Disposizione libera con gruppi e sottogruppi.
• Risultati aggiornati visibili direttamente nella tabella conti.
• Stampe personalizzabili:
  • Aggiunta del proprio logo.
  • Scelta delle colonne da includere.
  • Scelta delle sezioni da includere.
  • Stampa dettagliata o raggruppata.
  • Stampe  per solo un periodo.
  • Colonne con suddivisione per periodo (mese, trimestre, semestre, anno).
  • Valori anno precedente.
  • Valore di previsione confronto.
  • Colonne con suddivisione per segmento.
  • Aggiunta note allegate.
  • Raggruppamento come nel piano dei conti o secondo un proprio schema.
  • Salvataggio della personalizzazione.
• Report tabellare (simile alle stampe personalizzabili, ma con i dati presenti nella tabella).
• Esportazione in pdf per la conservazione dei dati ed esportazione in altri formati per una rielaborazione dati.

Altre stampe contabili

• Contenuto tabelle completamente stampabile o stampa anche solo per selezione.
• Aggiunta del proprio logo per una personalizzazione dei documenti e delle stampe.
• Giornale.
• Schede con movimenti conto e gruppi:
  • Con i movimenti contabili o quelli di previsione.
  • Per periodo.
  • Per Conto, Gruppo, Centro di Costo o Segmento.
  • Dati contabili o di previsione.
  • Disposizione colonne personalizzabile.
• Esportazione in pdf o altri formati.

Grafici

• Contestuali, a piè di tabella.
• Diverse disposizioni.
• Evoluzione dei conti e gruppi.
• Valori contabili.
• Previsione.
• Anno precedente.
• Scelta del tipo di grafico.

Ulteriori gestioni

Il programma ti consente anche di aggiungere ulteriori informazioni alle registrazioni, in modo che gli stessi dati ti servono anche per la gestione IVA, per il controllo dei clienti e fornitori, emissione di fatture, avere rendiconti per progetti o settori d'attività e fare fronte ai diversi adempimenti societari e fiscali.

Gestione IVA

• Funzione attivabile a scelta (quando si crea una contabilità).
• Tabella codici IVA per indicare le diverse aliquote e casistiche IVA.
• Supporta qualsiasi specifica nazionale.
• Può essere usato anche per gestire altri tipi di tasse di vendita (p.es. Sales tax Americana).
• Inserimento in registrazione del Codice IVA.
• Funzionalità di storno IVA (usando il Codice IVA preceduto dal segno meno).
• Calcolo IVA dal netto o dal lordo.
• Scomposizione e registrazione automatica sui conti IVA indicati.
• Rendiconti IVA di controllo:
  • Per periodo o completo.
  • Con o senza movimenti.
  • A scelta con totali per aliquota, codice IVA, conto.
• Estensioni nazionali per rendicontazione IVA in base ai requisiti delle autorità fiscali.

Gestione e controllo clienti

• Funzione attivabile a scelta (aggiungendo i conti nel piano dei conti).
• Controllo fatture e pagamento dei clienti.
• Anagrafica cliente impostata nel piano dei conti.
• Crea gruppi e totali per clienti in gruppi diversi.
• Fatture aperte per cliente o completa.
• Estratto conto movimento cliente e fatture aperte.
• Riconciliazione automatica, fatture aperte.
• Gestione clienti anche come Centri di costo (per principio di cassa).

Fatture ai clienti

• Funzione attivabile a scelta (utilizzando la colonna numero fattura nella tabella registrazione)
• Inserimento fatture direttamente nella tabella Registrazioni.
• Richiede l'impostazione dell'anagrafica clienti.
• Inserimento dei dati fatture come normali righe di registrazioni.
• Vedi emissione e stampa fatture ai clienti.
• Colonna per indicare quantità e prezzi.
• Con o senza IVA.
• Possibilità di modifica, correzione.
• Stampa della singola fattura con un click o di diverse fatture assieme.
• Scelta fra diversi layout di stampa.
• Personalizzazione della fattura in base alle proprie preferenze.
• Esportazioni in formato digitale tramite estensioni.
• Richiami personalizzabili con estensioni.
• Estratti conto clienti personalizzabili con estensioni.

Gestione fornitori

• Funzione attivabile a scelta (aggiungendo i conti nel piano dei conti).
• Anagrafica fornitori impostata nel piano dei conti.
  Possibilità di raggruppare i fornitori in gruppi diversi.
• Controllo fatture e pagamento ai fornitori.
• Fatture aperte per fornitore o report completo.
  Estratto conto movimento fornitore e fatture ancore aperte.
• Riconciliazione automatica, fatture aperte.

Centri di costo e di profitto

• Funzione attivabile a scelta (aggiungendo i conti centri di costo e profitto).
• Per progetti, contabilità costi o di redditività.
• Impostazione dei centri di costo direttamente nel piano dei conti.
• Raggruppamento multi-livello.
• Tre livelli di centri di costo e profitto.
• Numero illimitato di centri di costo per livello.
• Registrazione in negativo (con segno meno).
• Reportistica come i conti di bilancio e conto economico:
  • Saldo costantemente aggiornato.
  • Report personalizzabili.
  • Scheda di tutti i movimenti con saldo progressivo.
  • Grafico contestuale.

Segmenti

• Funzione attivabile a scelta (aggiungendo i conti segmenti).
• Per avere il bilancio e il conto economico di uno o più settori aziendali.
• Impostazione dei segmenti direttamente nel piano dei conti.
• Raggruppamento multi-livello.
• Fino a 10 livelli di segmento.
• Numero illimitato di segmenti per livello.
• Saldo costantemente aggiornato.
• Reportistica come i conti di bilancio e conto economico:
  • Report personalizzabile.
  • Scheda di tutti i movimenti con saldo progressivo.
  • Grafico contestuale.
• Bilancio e Conto economico per ogni segmento.

Tabella Articoli

• Per fatture e con gestione integrata di magazzino o dei titoli.
• Collegamento degli articoli ai movimenti della tabella Registrazioni.
• Aggiornamento automatico movimenti in entrate e uscita.
• Valore iniziale e finale.
• Aggiunta di ulteriore colonne.

Controllo e chiusura

Segnalazioni errori e controllo contabilità

• Comando per controllare la contabilità.
  In un attimo, la contabilità viene ricalcolata come se si inserissero tutte le operazioni nuovamente.
• Segnalazione di eventuali impostazioni sbagliate, differenze o errori.
• Ogni segnalazione è collegata a una pagina di aiuto che spiega le cause e la soluzione.
• Verifica se il saldo del conto corrisponde a quello reale (cassa, banca, IVA).
• Possibilità di correggere.

Protezione delle registrazioni

• Protezione righe.
• Blocco dei movimenti inseriti con tecnologia di certificazione dati digitale (tipo Bitcoin).
• Protezione con password.
• Conforme ai requisiti di legge.
• Invio dati al revisore con la certezza dell'impossibilità di manomissioni.
• Sblocco movimenti con data.

Chiusura e nuovo anno

• Procedura automatica per creare il file del nuovo anno.
• Riporto dei saldi e attribuzione dell'utile.
• Si può iniziare a lavorare sul nuovo anno, anche se non è  stato chiuso il precedente.
• Comando per riprendere i saldi definitivi quando  è stato chiuso l'anno precedente.

Esportazione e archiviazione dati

• Copia e incolla direttamente da e per Excel.
• Esportazione tabelle in pdf e diversi altri formati.
• Archiviazione delle stampe e dei dati contabili in pdf o altri formati.
• Estensioni per creare gli Standard Audit File.
• Salvataggio del file contabile su qualsiasi supporto.

Estensioni e altre funzionalità

Aggiunta funzionalità

• Aggiunta di nuove funzionalità.
• Rimozione di funzionalità non più necessarie.
• Conversione da un tipo contabile a un altro:
  • A contabilità con o senza IVA.
  • A contabilità con multi-moneta o viceversa.
  • Da contabilità entrata e uscite a doppia o viceversa.

Tabella Documenti

• Per memorizzare delle immagini (logo della ditta) o dei documenti di testo (per esempio programmi in Javascript).

Altre Tabelle aggiuntive

• Aggiunta di altre tabelle dove inserire delle note o altre informazioni.
• Le tabelle possono essere personalizzate aggiungendovi colonne.

Estensioni

• Estensioni predefinite per diverse stampe e altre funzionalità.
• Ricerca e istallazione veloce.
• Estensioni personalizzabili.
• Aggiornamento automatico.
• Possibilità di creare e istallare delle proprie estensioni locali.

Documentazione completa

• Ogni dialogo ed errore ha una propria pagina di documentazione accessibile con un click.
• Documentazione aggiornata costantemente.
• Domande e risposte.
• Documentazione disponibile anche in formato Pdf.

This is where the main data of the accounting file are entered, such as the printout heading, the opening and closing dates, the basic currency, the company address, the profit and loss from exchange rate variation account (if you have a multicurrency accounting file), the VAT account (if you have chosen the VAT management option), the password, …

The File and accounting properties window has the following tabs:

• Accounting tab
• Options tab
• Address tab
• VAT/ICMS tab
• Foreign currency tab
• Texts tab
• Password tab
• Other tab

Financial situation under control

You need to setup you chart of accounts in the Accounts table: setup the accounts and the groups where the accounts must be totalized. With this operation you create the accouts that will be used when entering the transactions. The chart of accounts structure is the same that will show in all Balanche sheet and Profit & Loss statement presentations.
In the Accounts table there are also the columns of the initial balances, movements and current balance, which are automatically updated by the program.
The chats of accounts therefore provides an immediate and complete view of your financial situation.

• Liquidity accounts
• Balance sheet
• Profit & Loss statement
• Result of the current year
• Clients and Suppliers register
• Cost and Profit Centers

Different kinds of rows and sections

The Accounts table (charts of accounts) is both the setup tool and the viewing tool for the economic and financial situation.

In the chart of accounts (Accounts table) all data necerrary to group the mouvements are entered:

• Accounts
  They indicate on what account (debit ore credit) the transactions must be registered.
  Each account has a code or number (account number), a description, a class and a group to which it belongs; they also have an opening balance, the current balance, the budget, etc...
• Costs and Profits centers
  They are special accounts whose number is preceded by a full stop ".", a comma "," or by a semi-colon ";". Their purpose is to be able to assign some amounts to special accounts other than the basic accounting accounts.
• Segments
  They are a sort of sub-accounts who's number is preceded by a ":". Their purpose is to be able to assign some transactions to subcategories of the accounting plan.
• Groups
  Their purpose is to create rows where the program adds up the amounts of other rows.
• Sections
  They indicate the accounting plan divisions for the Balance Sheet and Profit and Loss Statement printouts, ...
  • Clients register
  • Suppliers register

Trial Balance sheet

At any time, positioning yourself in the Accounts table and using the Print or Print preview commands (from the File menu), you can view and print the account plan or part of it.
Also from the Accounts table, if you select Movement view, you can view and print your trial balance sheet.

Advanced printouts

• Accounting report
  It is possible to select just the accounts with transactions, to obtain temporary groupings or accounts grouped according to the BClass or an external grouping scheme.
• Enhanced Balance sheet
  Prints all the accounts of the accounting divided by Assets, Liabilities, Expenses and Revenue
• Enhanced Balance sheet by groups
  Allows the user to obtain customized printouts with groups
• Specific advanced printouts are available using the BananaApps
   

Avoid mistakes with Banana Accounting Plus

In order to facilitate checking your accounting work and to immediately find differences, in Banana Accounting Plus, our new version, we added the Balance column in the Transaction table. You can now see potential differences on each row and you can correct them right away. It is a very useful feature when closing the accounting period.
Many of our clients have already tried it and are enthusiastic about it. We advise you to switch now to Banana Accounting Plus and take advantage of the many new features.

When using Banana Accounting for the first time, the opening balances need to be inserted manually in order to create the opening balance sheet.

After having set up the Chart of Accounts, proceed as follows:

1. Place yourself in the Accounts table, Base view, Opening column.
2. Manually enter the opening balances of the Assets and Liabilities accounts. The Liabilities are entered preceded by the minus (-) sign.
3. Check if the total Assets equals the total Liabilities so that your accounting balances. If there are differences in the opening balances you need to check and correct them.

Differences in the opening balances

At the opening of the Accounting year, in the Opening columns the amounts of the Total Assets (positive) should correspond to the Total Liabilities (negative) should arrive at zero.
If the Debit and Credit values do not result in zero, the accounting will not be correct and the program will report an error in the Info window.
Recheck and correct the amounts until the value is zero.

If you have entered and deleted accounts, changed groups or anything else, it is useful to use the Check accounting command. (Account1 menu). This recalculates all the values and lets you know if there are any errors.

In the following example the program shows an error message reporting a difference of 150.- CHF.

It is possible to check the balancing in the Totals Table.

Starting the accounting during the year

If you start a new accounting, you have two options if you resume the work already done:

• Start the accounting from the beginning of the year by entering the opening balances at the beginning of the year and the transactions that have already been recorded previously in other programs (see also Transferring data from other software).
  This way you have all the accounting details in one file.
• Start from when you resume the accounting.
  • Enter the opening balances in the Opening column, taking the values of the other accounting.
    You have to enter the opening balances not only of the Assets and the Liabilities, but also of the Expenses (Debit, amounts in positive) and Revenues (Credit, amounts in negative).
  • The result for the year to date must be entered in the account Profit/Loss carried forward.
    If it is a profit, the opening balance is to be entered in the negative, if it is a loss in the positive.
  • You must verify that the balance of the opening balances results in zero, so that the program does not indicate any differences.
  • You can start entering new transactions in the Transactions table.

Balances of the previous year

If you start a new accounting by taking over an existing accounting and you want the previous year's values to appear on the printouts, it is necessary to enter the previous year's balances in the Previous view, Previous Year column. For the previous year, Balance sheet and Profit/Loss statement balances are usually entered.
The previous amounts are displayed in the printouts of the Enhanced balance sheet in the Previous Year column.

Create new year

When you start the new year, the program automatically carries over the opening balances for the following year.
Consult the lesson Create New Year.
 

Avoid mistakes with Banana Accounting Plus

In order to facilitate checking your accounting work and to immediately find differences, in Banana Accounting Plus, our new version, we added the Balance column in the Transaction table. You can now see potential differences on each row and you can correct them right away. It is a very useful feature when closing the accounting period.
Many of our clients have already tried it and are enthusiastic about it. We advise you to switch now to Banana Accounting Plus and take advantage of the many new features.

The Transactions table

Transactions must be entered in the Transactions table.

Info window

In the Information window at the bottom part of the screen, error messages and extra information about the used accounts and VAT codes are being displayed.
For the accounts, the Account number, the Description, the Amount of the transaction (debit or credit) and the Current balance of the account is being indicated.

The Totals table presents the totals by Group and is used to check the accounting balance.
It is processed automatically by the program and cannot be modified by the user.

In the Totals table it is possible, at a glance, to get an idea of the situation of one's own activity. You see the totals of assets, liabilities, costs and revenues and above all you see if you have a profit or a loss.
The 00 group is very important because it allows you to immediately see if everything is in place or if there are differences in the balances.

In der Tabelle Budget findet die Finanzplanung statt und funktioniert wie die Tabelle Buchungen.
Es gibt Spalten für das Budget je nach Art von Buchhaltung.
Sie können auch Mengen und Preise sowie Berechnungsformeln eingeben.

Mehr Informationen betreffend Budget finden Sie auf der Seite Tabelle Budget.

​

Enhanced Balance sheet with groups - colored columns

This example has been realized with the following features:

• Enhanced Balance sheet with groups
• Columns setup to indicate which columns are to be displayed (in the example the columns of the Current and the Preceding year are being displayed)
• Colors (Column properties) to indicate the color of a column.

Profit & Loss Statement with budget

This example has been realized with the following features:

• Enhanced Balance sheet with groups
• Columns setup to indicate which columns are to be displayed (in the example the columns of the Current year, the Budget and the Preceding year are being displayed)
• Colors (Column properties) to indicate the color of a column.

Enhanced Balance sheet

This example has been realized with the following features:

• Enhanced Balance sheet- Base tab
• Style setup (for this printout the Berlin style has been chosen)

Subdivision by quarter

This example has been realized with the following features:

• Enhanced Balance sheet with groups
• Subdivision -> Subdivision by period in order to set up the subdivsion by period
• Columns setup to indicate which columns are to be displayed
• Colors (Column properties) to assign different colors to the columns.

Subdivision by segment

This example has been realized with the following features:

• Enhanced Balance sheet with groups
• Subdivision -> Subdivision by segment in order to choose the segment level to be displayed.
• Print style
  When printing the segments, it is not possible to set up the colors of the columns.

Pdf dossier with all the accounting data

The file is being created with a summary that gives access to the different printouts in an easy way.

The following data can be saved in Pdf

• Balance sheet and Profit & Loss statement
• Accounts table, Transactions, VAT Codes, Totals
• VAT reports
• Account cards
   

If you save this file on a non-rewritable CD (to keep together with your accounting documents), this satisfies the legal requirements for archiving the accounting data.

This example has been realized with the following features:

File menu, Create Pdf dossier command

Printing an extra column

In order to print, in the Balance sheet, an extra column, the following features have been used:

• Columns setup, Data menu, in order to display or add a new column in the Accounts table
• Enhanced Balance sheet with groups
• Columns - advanced, to make the column visible.