The new Estimates and Invoices application is included in Banana Accounting Plus. Creating and printing estimates and invoices becomes quick and easy.

To start, just download for free the Free Plan. You may enter up to a maximum of 20 invoices and 20 offers.

With the yearly plan, you can add an unlimited number of estimates and invoices. 

How to set up estimates and invoices

To create estimates and invoices, just set up your customer data, items or services to be invoiced, unit prices and VAT rates, while the program takes care of everything else.

There are many automations to make your work easy and with immediate professional results.

• Automatic retrieval of addresses from contacts to avoid having to re-enter the data in the invoice.
• Data import from SmallInvoice with specific Banana extension.
• No manual calculation. All calculations are automatic, always accurate and updated.
• Detailed estimates that can be quickly converted into invoices and sent to the customer.
• Invoices created with QR code for Switzerland.
• For every invoice, language, currency, number of decimals and rounding system can be set up.
• Changes and/or duplicates of invoices and offers already made to the customer. You just need to to add quantities and the new invoice is ready to be sent.
• Annotations for memos or other.
• Payment date to check receipts.
• View of overdue invoices to check due dates.
• PDF saving and paper-printable.
• Invoice archiving to have a history that is always organised and ready for possible tax inspections.
• Dark Mode on Mac and Windows.

Excel-like features

To use the Invoice application you must have downloaded and installed Banana Accounting Plus.

For a quick and easy start we recommend the use of one of our templates.

 Create an Invoice file

Create an Invoice file starting with an existing template or by creating an empty file as follows:

• Menu File → New.
• Select Region / language.
• As Type, select Invoices.
• In the section on the right select the required template.
• Double-click on the template name or click the Create button. The program will open the selected file directly.
• Save the file indicating it's name.

 Enter basic data

• Via File → File and accounting properties → Address tab, set the address of your company, which will be included in the header of the invoice.
• If you wish to insert a logo, see the Set up logo page.

Create new Invoice

Via the Invoice → New Invoice ... dialog a new invoice will be created.

1. Enter the basic information of the invoice (invoice no, date, object, initial text and final text).
2. Enter your billing address (customer address).
3. Enter the invoice details (product, description, quantity, amount).
4. Check subtotals and grand totals and enter any discounts.
5. In Settings ... define some basic parameters of the invoice (currency, decimal points, rounding, payment term and VAT mode).
6. Save and print the invoice.

Print an invoice

You can print the invoice via the Invoice menu → Print Invoice command. or by clicking Print in the dialog for creating or modifying an invoice, you access the window for printing the invoice.

On the Print Offers and Invoices page you will find information on how to customise and print invoices.

The tables

The Invoice file consists of the following tables:

• Contacts table where to enter customer addresses.
• Items table where to enter the data for the management of the articles and the warehouse.
• Invoices table where to enter all the data relating to the invoices.
• Estimates table where to enter all data relating to offers.
• VAT Codes table where to enter the VAT codes with the relative rates.

The Contacts table displays the columns where you can enter customer addresses.

Contact addresses will be immediately available in the invoice dialogue when creating or editing the invoice, simplifying data entry.

Changing the data in the Contacts table does not change the data of existing invoices and offers. If you want an existing invoice or offer to be updated  with the new customer data, you must:

• Change the invoice or the estimate in the invoice dialogue.
• You must select the customer again from the list in the customer address section.

The columns

The Contacts table contains many columns, those displayed in the image are those in the Basic view. The complete list is visible in the Complete view. To customise the columns see the Columns Setup page.

Id

The contact number is entered.
The ID should be used only once and must not be repeated, even if multiple years are managed in a file.

Organisation

Enter the name of the company or organisation.

Title (Prefix)

Enter the title of the contact

Name

Enter the name of the contact.

Family name

Enter the surname of the contact.

Street

Enter the address.

Address extra

Enter extra address.
If you require the QR invoice layout, refer to the documentation Common elements for the QR invoice Switzerland for further information.

ZIP

Enter the postcode.

Locality

Enter the location.

Country code

Enter the Country code.

The country code must be formed by two characters conforming to the ISO 3166-1 standard (eg CH, LI, AT, DE, IT, FR).

Language

Enter the customer's language.

Invoice texts are printed in the customer's language, provided that it is set in the corresponding column.
The language is an ISO code, usually 2 lowercase letters (it=Italian, de=German, en=English, fr=French).

If no language is specified for the customer, the language of the file is used. This language is defined in the menu File → File properties (basic data) → Other → Current language.

Tax Code

Enter the customer's tax code

VAT number

Enter the customer's VAT number

Note

Any notes may be inserted.

The Items table presents the columns where to insert the data for the management of the items and the warehouse.

The items will be available in the Invoice Dialogue when creating or editing the invoice, simplifying data entry.

The columns

The items table contains many columns; those displayed in the image are those in the Base view. The complete list is visible in the Complete view. To customise the columns, please refer to the Columns setup page.

All column contents can also be printed on the invoice. See customisation print layout detail CH10.

Links

Link to a product image file or descriptive PDF file

Id

The item number is entered.
The ID should be used only once and must not be repeated, even if multiple years are managed in a file.

Description

The description of the item is entered.

Unit

The type of unit is entered (pieces, hours, etc.).

Unit Price

The unit price is entered.
In the invoice settings dialogue you indicate whether the amounts are VAT excluded or including VAT.
Please note that if you change the setting from VAT excluded to including VAT or vice versa, the program changes the amounts, so that the same invoice can be printed with VAT excluded amounts or amounts including VAT.

Account

Any account is entered as information to be used for manual entry in accounting.
This value serves only as information, it is not used for creating invoices.

Note

Any notes are inserted.

 Import of catalogue

Using the import functions, it is possible to automate the import of data from an existing product catalogue. See Retrieving data from other software.

It is also possible to integrate product catalogues into the invoicing program.

The Invoice table displays the columns where all invoice data that have been entered in the Invoice Dialogue are automatically retrieved.

From this table you can:

• Create new invoices
• Edit existing invoices
• Duplicate invoices
• Delete invoices
• Print invoices
• File invoices

The columns

The Invoices table contains many columns, those displayed in the image are those in the Base view. The full list is visible in the Complete view. To customise the columns, please refer to the Columns setup page.

Id

Enter the invoice number.
The program will automatically resume the value entered in the Invoice dialogue.
The ID should be used only once and must not be repeated, even if multiple years are managed in a file.

Date

Enter the invoice date.
The program will automatically resume the value entered in the Invoice dialogue.

Description

Enter the subject of the invoice.
The program will automatically resume the value entered in the Invoice dialogue
This text will also be used as the title of the invoice. If defined, it overwrites the title entered in the settings.

Contact Id

Enter the contact ID number, as used in the Contacts table.
The program will automatically resume the value entered in the Invoice dialogue

Address

The program will automatically resume the customer's address data, based on the contact id number entered.

Discount Amount

Enter the amount of the discount to be applied to the invoice.
The program will automatically resume the value entered in the Invoice dialogue.

Total Amount

The program will automatically resume the value entered in the Invoice dialogue.

Expiration

The expiration date is entered.
The program will automatically resume the value entered in the Invoice dialogue.

Payment

The payment date is entered.

Notes

Further notes are entered.
The program automatically resumes the text entered in the End Text field of the Invoice Dialogue.

The Estimates table presents the columns where all offer data that has been entered in the Invoice dialogue are automatically taken over.

The columns

The Estimates table contains many columns, those displayed in the image are those in the Basic view. The complete list is visible in the Complete view. To customise the columns, please consult the Columns setup page.

Id

Enter the estimate number.
The program will automatically resume the value entered in the estimate creation dialog.
The ID should be used only once and must not be repeated, even if multiple years are managed in a file.

Date

Enter the estimate data.
The program will automatically resume the value entered in the estimate creation dialog.

Description

Enter the subject of the invoice.
The program will automatically resume the value entered in the estimate creation dialog.

Contact Id

Enter the contact ID number, as used in the Contacts table.
The program will automatically resume the value entered in the estimate creation dialog.

Address

The program will automatically resume the customer's address data, based on the contact id number entered.

Discount amount

Enter the amount of the discount to be applied to the estimate.
The program will automatically resume the value entered in the estimate creation dialog.

Total

The program will automatically resume the value entered in the estimate creation dialog.

Notes

Any notes may be inserted.

The VAT codes table displays the columns where you can enter the VAT codes with the respective rates.

The data must be entered manually. When VAT rates change, the table must be updated by changing or adding the ID codes and percentages of the new tax rates.

VAT Codes will be automatically taken over in the invoice dialogue when creating or editing the invoice, simplifying data entry.

The columns

The VAT Codes table contains many columns; those displayed in the image are those in the Base view. The full list is available in the Complete view. To customise the columns, please consult the Columns setup page.

Id

The VAT code is entered.
The ID should be used only once and must not be repeated, even if multiple years are managed in a file.

Description

Enter the description of the VAT code.

%VAT

The VAT rate is entered.

Notes

Any notes may be inserted.

VAT on the gross or net amount

The setting for calculation on the net or the gross amount is done at the individual invoice level, in the Invoice settings dialogue.

Invoices menu

In the Invoices menu you will find the commands to:

• Create new invoices
• Modify existing invoices
• Duplicate invoices
• Delete invoices
• Print invoices
• Show open invoices
• Show customer's invoices
• Archive invoices

 Create a new invoice

To create a new invoice you have two options:

• From the Invoices menu
  • Use the command Invoices → New Invoice.
  • The invoice dialogue is then opened where the data is entered.
  •  The new progressive invoice number is allocated by the programme. You can change it manually.
  •  Enter the invoice data and save
• Directly from the Invoices table:
  •  Select a new row in the table.
  • In the Id column (invoice number), click on the small 'New Invoice' icon that appears at the top of the cell.

• The invoice dialogue then opens where you enter your data.
• Enter the invoice data and save.

When you create a new invoice, the programme automatically updates the Invoices table. The data of the new invoice are added to a new row in the table.

 Edit Invoice

To edit an existing invoice, you have two options:

• From the Invoices menu:
  • Select the line with the invoice you wish to edit.
  •  Use the command from the menu Invoices → Edit Invoice.
  • The invoice dialogue opens where you can enter and edit data.
  • Make the timely changes and save.
• Directly from the Invoices table
  • Select the row with the invoice you want to edit.
  • In the Id column (invoice number), click on the small 'Edit Invoice' icon that appears at the top of the cell.
    
    
     
  • The invoice dialogue then opens where you can enter and edit data.
  • Make the timely changes and save.

When you edit an invoice, the programme automatically updates the data in the Invoices table.

 Duplicate invoice

To duplicate an invoice, you have two options:

• From the Invoices menu:
  • Select the row with the invoice you wish to duplicate.
  • Use the command from the menu Invoices → Duplicate Invoice.
  •  The new progressive invoice number is allocated by the programme. You can change it manually.
  • Then the Invoice dialogue opens with the data of the invoice you have chosen to duplicate.
  • Make the timely changes and save.
  • The programme automatically updates the Invoices table.
• Directly from the Invoices table:  
  • Select the row with the invoice you want to duplicate. You can also select several rows to duplicate several invoices at once.
  • Use the command from the menu Edit → Duplicate rows.
  • The programme automatically updates the Invoices table by adding the duplicate rows.
  • For each duplicate invoice, you must then manually edit the invoice number and data.

 Delete invoice

To delete an invoice:

• Go to the Invoices table.
• Select the row with the invoice you wish to delete. You can also select several rows to delete several invoices at once.
• Use the command from the menu Edit → Delete rows.
• The invoices are deleted from the table.

 Print invoices

On the Print Offers and Invoices page you will find information on how to customise and print invoices.

To print an invoice you have two options:

• From the Invoices menu:
  • Select the row with the invoice you want to print.
  • Use the command from the menu Invoices → Print Invoice.
• Directly from the Invoices table:
  • Select the row with the invoice you want to print.
  • In the column Id (invoice number), click on the small icon 'Print Invoice' which appears at the top of the cell.

 Show open invoices

You can extract invoices that have not yet been collected into a table:

• Go to the Invoices table.
• Use the command from the menu Invoices → View open invoices.
• The programme extracts all rows of invoices without a payment date.

Each time a new invoice is collected, enter the date of collection in the Payment column of the Invoice table.

 Show customer's invoices

You can extract customer's invoices into a table:

• Go to the Invoices table.
• Under the Contact Id column click on the customer number whose invoices you want to have.
• Right-click on the selected field and select the Extract rows command

The program extracts all rows belonging to the customer.

 Archive invoices

With the Estimates and Invoices application:

• You can enter as many invoices as you want, there are no limits.
• You can keep invoices from several years in one file.
• You do not need to create a new file for each new year.

Invoices from previous years can be archived at any time:

• See how to archive invoices.

The Invoice and Estimate dialog allows invoice data to be entered and edited. 

Open the Dialog

The dialog can be opened via:

• For the Invoice
  • The Invoice menu > New invoice.
  • The Invoice menu > Edit invoice.
  • The Invoice table > Double-click on the invoice line of relevance, in the Address column.
  • The Invoice table > Double-click on the invoice line of relevance, in the Total Amount column.
  • From the ID column, click on the small icon Edit invoice on the right-hand-side of the cell.
• For the Estimate
  • The Invoice menu > New estimate.
  • The Invoice menu > Edit estimate.
  • The Estimate table > Double-click on the estimate line of relevance, in the Address column.
  • The Estimate table > Double-click on the estimate line of relevance, in the Total Amount column.
  • From the ID column, click on the small icon Edit estimate on the right-hand-side of the cell.

Dialog Sections

The dialogue is divided into two sections:

• Invoice
  • In the Invoice section you enter the invoice data.
• Settings
  • In the Invoice settings section, parameters for new documents and interface settings of the invoice dialogue are defined.

With the Estimates and Invoices application you can also manage estimates.

The creation, modification, duplication and printing of estimates are handled exactly as the invoices.
Here is the dialog to create or edit Estimates:

From the Estimates table:

• Create a new Estimate with the menu command Invoices > New estimate.​​​​
• Edit an offer with the menu command Invoices > Edit estimate.
• Duplicate an estimate with the menu command Invoices > Duplicate estimate.
• Print an offer with the menu command Invoices > Print estimate.
• Convert an estimate into invoice:
  • Via the Invoices menu > Create invoice from estimate command.
  • Or using the Create invoice button from the estimate creation / modification dialog (Invoices > Edit estimate)

The dialogue for creating and modifying an estimate is the same as that of the invoice. For more information visit Invoice dialogue.

You can easily customise and adapt invoice printing to suit your needs.

Set your company address (sender)

In the File menu > File and accounting properties (Basic data) > Address , set the address of your company.

Set customer language

You can print invoices in the language of your customers. For each customer set the language in the Contacts table. You can also change it from the Edit Invoice dialog.

Retrieving customer addresses from Excel

When customer data are on an Excel file, they can be easily transferred to the Contacts table.

Proceed as follows:

• Select from Excel the column with the data to be copied and use the Copy (Ctrl+C) command.
• Go to Banana, Contacts table, position yourself in the corresponding column and issue the Paste (Ctrl+V or Paste) command from the Edit menu.
• Repeat this operation for all address columns (Account, First Name, Last Name, Organisation, Street, Zip, Country Code, Language).
  The data corresponding to the mentioned columns are required for printing the invoice.
• If you do not have all the columns mentioned in the Excel file, you must add the missing information manually.

Logo setup position and sender address

To set the logo, you must:

• Upload the logo image in the menu File > Logo setup.
• To use the logo in the invoice, in the Invoice Settings you must activate the Logo box and enter the name of the customisation you used, respecting upper and lower case, in the Logo Name field.

For example, you can place the logo on the left and the address on the right and change the size of the logo.

The address is automatically taken from the file basic data.

The sender's address, if the default settings are not changed, is entered on the right, regardless of the presence of the logo.

If you want to set the sender address on the left without any logo, please see the following page:

• Invoice with no logo and header address on the left.

If you want to enter a different address, via the Invoice Settings:

• Enter the texts you want using the Line 1 Text , Line 2 Text, Line 3 Text, Line 4 Text, and Line 5 Text.

Set the logo without the sender's address

On the Logo setup page you will find information on how to add and place the logo.

Through the Invoice Settings:

• Uncheck the Page header option to exclude the address in the header from printing.
• View the Logo option to include the logo in the printout.

Customise address in invoice header

The style of the sender's address in the invoice header (colour, size, font..) is set by default by the program.

The Advanced Plan of Banana Accounting Plus allows you to customize the style of the address. For more information see the Examples page.

Set invoice information

Invoice information is information about the date, customer number, due date, etc., which is usually located just below the header and next to the customer address.
The CH10 and UNI11 layouts allow you to define which invoice information to include and which to exclude from printing. You can find instructions on the Invoice Settings page.

For the other print layouts (CH01-CH09 / UNI01-UNI08), the information cannot be modified.

Add a new invoice information field

In addition to the default information fields (invoice number, date, customer number, etc.), you can also enter other custom fields.

In the Invoice section of the Invoice dialog:

• Go to the Complete view (top).
• Use the fields Additional info 1... Additional info 8 to add your own additional information fields.
• In the Information section of the Invoice Layout settings, view the Custom fields field.
• The new additional information fields are added at the end. It is not possible to change the order.

In the Settings section of the Invoice Dialog:

• Edit the texts of the Invoice User Fields as you wish.
• You can enter translations for each language.

Set the payment term

The payment term for invoices by default is 30 days.

To change the payment term you have two options:

• Change the default settings for all new invoices.
  • Go to the Settings section of the Invoice dialog.
  • In the New documents > Invoice Payment term(days) section set the value you want (e.g. 10).
  • The invoice due date will be recalculated with the new payment term.
• Change the payment term individually for each invoice.
  • Go to the Invoice dialog.
  • In the Due date field enter the payment deadline date (e.g. 31.12.2022).
  • The invoice due date will be replaced with the new payment term.

Set customer address position and composition

The CH10 and UNI11 layouts allow you to define:

• The location of the customer address.
• The elements of the address.

On the Invoice Settings page > Customer address section:

• In the Address composition field:
  • Choose how to compose the address by entering the XML names of the columns in the Contacts table.
  • You can use only the following columns (XML names):
    NamePrefix, OrganizationName, FirstName, FamilyName, Street, AddressExtra, POBox, PostalCode, Locality, Region, Country, CountryCode.
  • Change the location of the address using the Move horizontally and Move vertically options.

For other print layouts (CH01-CH09 / UNI01-UNI08), the location and composition of the customer address cannot be changed.

If you need more than one line to print your customer's address, see print customer/company address on four lines.

Set title/object

To enter the title/object of the invoice, you have two options:

• Enter the text in the Invoice dialog > Object field.
  • For each invoice you can define a title.
  • If you leave the field empty, the default text is used.
  • This title always has priority over entering the title in the layout settings (see next point).
• With the CH10 and UNI11 layouts, you can enter the text in the invoice Settings > Texts section > Invoice title.
  • The title applies to all invoices printed with this layout.
  • The title applies only if no title has been defined as per the first point.

Set initial text

To enter the title/object of the invoice, you have two options:

• Enter the text in the Invoice dialog > Begin text field.
  • For each invoice you can define a title.
  • If you leave the field empty, the default text is used.
  • This title always has priority over entering the title in the layout settings (see next point).
• With the CH10 and UNI11 layouts, you can enter the text in the invoice Settings > Texts section > Begin text.
  • The title applies to all invoices printed with this layout.
  • The title applies only if no title has been defined as per the first point.

Setting up the invoice details table

The Invoice Details Table is the central table in the invoice where the invoiced items/services appear, with quantities, unit prices, totals, etc.
Use the Invoice dialogue to enter items or other items to be invoiced.

See also pages:

• Invoice details
• Discounts and totals
• Advanced Settings

Set invoice item columns

With the CH10 and UNI11 layouts, you decide which columns to display in the printout. See how to do it in the page Invoice Settings > Invoice Details.

For the other print layouts (CH01-CH09 / UNI01-UNI08), the columns are not editable.

Create a Credit Note

To create a credit note:

• In the Invoices table, add a new invoice for the credit note.
  The invoice can be created as new or you can copy an existing invoice and then modify it.
• Open the newly created invoice for editing.
• Change the title/subject to "Credit Note."
• In the details table, add a row and set the quantity with a negative sign. This way, the total for the row will be negative.
   

Set final texts

To enter the final text of the invoice, you have several options:

1. Enter the text in the Invoice dialog > End Text field.
   • It is applied to any print layout.
   • The text is inserted just below the invoice details.
2. Enter the text in the Invoice Print Dialog > Options section > Final text.
   • It is applied to any print layout.
   • If you have already entered text as per step 1, the new text is added right after the previous one.
3. Enter the text in Invoice Settings > Texts section > End text field.
   • This text has priority over the text entered as per step 2.
   • If you have already entered text as per step 1, the new text is added right after the previous one.

Set bank account number

If you don't use the QR-Code, you need to enter the bank account number as a reference for the invoice payment.

You have three ways to enter the bank account number as the final text:

1. Invoice dialog > End text field.
   • The bank account number appears in the printout only for the invoice you are creating/editing.
   • It is applied to any print layout.
   • The text is inserted just below the invoice details.
2. Print Invoice dialog > Options > Final text.
   • In this case, the bank account is inserted in all invoices you create.
   • It is applied to any print layout.
   • If you have already inserted text as per step 1, in this case the new text is added right after the previous one.
3. Invoice Settings > Texts > End text.
   • In this case the bank account is inserted in all invoices you create using this layout.
   • This text has priority over the text entered as per step 2.
   • If you have already entered text as per step 1, the new text is added right after the previous one.

Set IBAN for Swiss QR-Code printing

If you want to create QR invoices with IBAN account, you need to:

• Set up IBAN account
• Set up the printing of the Swiss QR-Code

On the QR-Invoice with IBAN account page you will find more information for setting up QR-invoices with IBAN account.

Set up QR-IBAN for Swiss QR-Code printing

If you want to create QR-invoices with QR-IBAN account, you have to:

• Set up QR-IBAN account
• Set up Swiss QR-Code printing

On the QR-Invoice with QR-IBAN page you can find more information about the settings of QR-invoices with QR-IBAN account.

Print QR form without amount and address

If you want to print only the QR-bill without amount and customer address, you have to:

• Use the QR-Invoice extension without amount and address.
• Set the currency, address and IBAN account.
• Create the bulletin with QR code.

See also how to print an Invoice without amount.

Set styles and colors

On the Invoice Settings page you will find instructions for defining:

• Font and font size.
• Colors.

Set Bold texts

In the Invoice settings page you will find information on how to apply bold style to invoice texts.

 Add images in Offers or Invoices

The Advanced Plan of Banana Accounting Plus, with the new application Offers and Invoices, allows you to add images to the offers and invoices to be sent to customers.
This functionality makes the invoice even more customisable and the client who receives it has a more complete and direct vision of the invoicing of the items.

See our information pages on how to add images:

• Customise invoice print with Javascript
• Offers and Invoices with product images

 Print customer/company address on four lines

When the addressee is a company with several sectors/departments or a customer living in a housing complex with interiors, it may be necessary to have several lines available for printing the address.
This option is only available with the Advanced Plan of Banana Accounting Plus.

To activate the possibility of printing the recipient address on several lines, proceed as follows:

• Update extensions from the Extensions menu > Manage extensions > Update extensions.
• Open the invoice under Edit and in the Settings dialogue > Address section, make the fields Sector 1 ... 4 visible for the Basic view.
  
  

• Possibly switch from the Basic view to the Complete view without making the fields visible (in the Complete view all fields are visible).
• In the invoice address, enter text in the sector fields.
  
  

• In the print layout settings, add the Sector fields to the customer address composition.
  The content will be as follows:
  <OrganisationName>
  <OrganisationUnit>
  <OrganisationUnit2>
  <OrganisationUnit3>
  <OrganisationUnit4>
  <NamePrefix>
  <FirstName> <FamilyName>
  <Street> <AddressExtra>
  <POBox>
  <PostalCode> <Locality>
  
  

• If you wish to take these fields automatically from the Contacts table, add columns OrganisationUnit2, OrganisationUnit3 e OrganisationUnit4 to the Contacts table.
  
  

Other resources

• Customise invoice print

With the Estimates and Invoices application, included in Banana Accounting Plus, invoice printing is highly customisable and adaptable to all requirements.

Command Print Estimates/Invoices

Invoice printing is done from the menu Invoices → Print Invoice.

This command creates a print preview of the invoice. Directly from the preview, by clicking on the settings symbol (cogwheel) in the toolbar, you access the following dialogue box:

• Print Invoices dialogue. From this dialogue box you can do various things:
  • Set the layout to be used for printing the invoice.
  • Access the layout settings to customise the printout.
  • Change the print settings.
  • Export the invoice in pdf or other formats.

With the Advanced plan of Banana Accounting Plus it is also possible to print several invoices at the same time and obtain single PDFs for each of them! For more information visit the page Print invoices or customer statements as separate PDFs.

Print layout and customisation

The printing of the offer or invoice is highly customisable for several reasons:

• You can choose the Print Layout.
•  You can customise invoice printing by changing the layout settings.
•  Several layouts are available for invoice printing, here are the recommended ones:
  • The CH10 layout for all users in Switzerland.
    With the option to include the Swiss QR-Code in the printout.
  • The UNI11 layout for all users in other countries.
    Same as the CH10 layout, but without the QR-Code.

For more information on customisation, please consult the following pages:

• Customise your invoice print layout
  Find all the information you need to start creating a print-out according to your needs.
• Customise CH10 layout (also valid for UNI11 layout).
  • Activate and customise QR-Code for invoice printing in Switzerland.
• Insert item picture
  This option is only available with the Advanced Plan of Banana Accounting Plus. In the Estimates and Invoices application it is possible to insert the photo or an image of the article.
  For further details consult the page Print Photo.

Print table content

To print the contents of the Contacts, Items, Invoices, Estimates and VAT Codes tables, proceed as follows:

• Position yourself on one of the tables whose data you want to print.
• Go to the menu File → Preview/Print.

A PDF is displayed with a list of the data contained in the various columns of the chosen table.

Banana Accounting Plus, with the CH10 and UNI11 layouts, also allows you to print reminders.

Requirements for using layout preferences:

• Banana Accounting+ (version 10.1.7 or later).
• The Advanced plan

On the basis of the Invoice data entered in the Invoices table, reminders can be printed.

How to print a reminder

In the Invoices table select the row where the invoice for which you wish to print the reminder is located and proceed as follows:

• From the menu Invoices > Print invoices
• Select Layout CH10 or UNI11
• Under Print as, select one of the following options:
  • 1st reminder
  • 2nd reminder
  • 3rd reminder
• Confirm with OK

Print customization

All settings that characterise the CH10 and UNI11 layouts are also retained in the call-out printout.

To change the settings, go to Print Layout Settings.

Under Texts > Reminder you can define the start and end texts in the reminder

Print example:

Banana Accounting Plus, with the CH10 and UNI11 layouts, also allows delivery notes to be printed.

Requirements for using layout preferences:

• Banana Accounting+ (version 10.1.7 or later).
• The Advanced plan

Delivery note data are entered in the Invoices table, as is the case for invoices.

If the data on the invoice match those on the delivery note, the same data can be used for both the printing of the delivery note and the invoice.

How to print a delivery note

In the Invoices table select the row where the delivery note to be printed is located and proceed as follows:

• From the menu Invoices > Print invoices
• Select Layout CH10 or UNI11
• Under Print as, select:
  • Delivery note with amounts
     In this case, amounts in the details and total amount are included in the bulletin.
  •  Delivery note without amounts
    Only the details of the dispatched goods are displayed in the delivery note, without any amounts.
• Confirm with OK.

Print customization

All settings in Layout CH10 and UNI11 are also retained when printing the delivery note.

To change the settings, go to Print Layout Settings.

Under Texts → Delivery Note you can define the initial and final texts in the delivery note.

Print example:

With the Offers and Invoices application you can archive your offers and invoices at any time of the year. The file in which the invoice data is entered remains the same over the years.

Archive invoices individually

If you want to archive one or more invoices individually, proceed as follows:

• From the Invoices table go to the Archive view.
• In the Archive date column, enter the date of when you wish to archive the invoice.
• Archive the invoice with the command Invoices > Archive data > Archive table data.

Archive invoices for the year

To archive invoices for the entire year, proceed as follows:

• From the Invoices table go to the Archive view.
• In the Archive Date column, enter the date 31.12 in the first line and copy and paste on all lines.
• Archive the invoice with the command from the menu Invoices > Archive data > Archive table data.

Invoice archive

In the invoice archive you will find all archived offers and invoices.

Archived invoices are displayed in the Archive (Invoices) table and removed from the Invoices table.

The Archive (Invoices) table:

• Is displayed automatically when archiving invoices.
• If you close the table, use the command from the menu Invoices > Archive data > Show archived data to display it.

Archiving Table Data

This feature is available in Banana Accounting+ Dev Channel.

Data from the following tables can be archived:

• Contacts
• Items
• Invoices
• Estimates

To archive table data:

• Position yourself in the table where there is data to archive.
• Activate the Arch. Date column.
• In the Arch. Date column, enter the date of when you want to archive.
• From the menu Invoices > Archive Data > Archive table data, choose the table with the data to be archived.

The programme creates the Archive table where all archived data (Contacts, Items, Invoices or Estimates) are stored.

Viewing Archived Data

This feature is available in Banana Accounting+ Dev Channel.

Archived data is saved permanently in the Archive table.

To view the tables with archived data

• From the menu Invoices > Archive data > Show archived data
• Choose the table with archived data to display

The programme shows the Archive table where all archived data (Contacts, Items, Invoices or Estimates) are stored.

In the Estimates and Invoices application, it is possible to have all invoices created from one year to the next in a single file, without having to create a new file for the new year.

If, however, you wish to have separate invoices from one year to the next or not display the invoices from the previous year, there are two possible solutions:

1.  Archive the registered invoices to empty the Invoices table

•  From the Invoices menu, choose the option Archive data > Archive table data. More information can be found on the page Archiving Invoices.
• Archived invoices are displayed in the Archive (Invoices) table and removed from the Invoices table.

2.    Create a new file by making a copy of the previous year

•  Start from the current file and from File in the menu, click onto Save As command, naming the new year.
   You can also create a copy of the file from the menu, Tools > Create file copy command.
• In the Invoices table delete all rows where the previous year's invoices appear

For the Estimates and Invoices application, on the topic Create New Year, new developments will be possible in the future.

Estimates and Invoices Tools

Import/Export Estimates and Invoices

You can use the Estimates and Invoices Tools extension to import or export the following data from Banana:

• Invoices
• Offers

The imported/exported file format is described in the Estimates and Invoices Tools .

Import/Export Contacts and Items

You can use the "Data" menu to import or export the following data from Banana: 

• Contacts
• Items

The imported/exported file format follows Text file with columns header.

 Using catalogues for invoicing

It is possible to integrate product catalogues into the Estimates and invoice application. Companies can make catalogues available to their dealers so that they can prepare estimates and invoices more easily.
If you have any questions about this, please contact our customer service.

With the Estimates and Invoices Application, you can quickly create serial invoices from a data list in Excel. It is ideal for sending bulk invoices to clients or members of an association.

• Enter the data in Excel.
• Import it into Banana Accounting Plus using the import functions.
• Create and print the invoices.

Prerequisites

To create serial invoices with the Offers and Invoices Application, you need to:

• Use the following pre-prepared Excel file to enter the contact data.
  • [Download] Excel file for contacts.
• Use the following pre-prepared Excel file to enter the invoice data.
  • [Download] Excel file for invoices.
• Use the Offers and Invoices Tools extension to import the invoice data into Banana.
• Install the Beta version of the 'Estimates and Invoices Dialog Extension' of the Estimates and Invoices application.

Create Serial Invoices

Serial invoices can be created as follows:

1. Install the Offers and Invoices Tools extension.
2. Create the Offers-Invoices file and enter the basic data.
3. Create and import the contacts.
4. Create and import the invoices.
5. Print the invoices.

Install the Estimates and Invoices Tools Extension

Launch Banana Accounting Plus and install the Estimates and Invoices Tools extension.

From the menu Extensions > Manage Extensions, search for Estimates and Invoices Tools among the online extensions and click on Install.

Create the Estimates-Invoices File and Enter the Basic Data

There are two ways to prepare the file:

• Create a new file from the menu File > New, select the region and language, select the type Estimates and Invoices, select the blank template.
• Use your existing Estimates and Invoices file.

In the menu File > File Properties (Basic Data) > Address section, set the address of your association, which will appear in the invoice header.

If you have a logo you want to use, refer to the Logo setup page.

Create and Import Contacts

Contact data can be created using an Excel file. In this file, all the data is entered and then subsequently imported into Banana. There are two ways to do this:

Method 1

The first method is described on the page Retrieving data from Other Programs > One-Time Data Importing using Excel.

• In Excel, arrange the columns exactly in the same sequence as they appear in the Contacts table of Banana accounting.
• Select the data in Excel that you want to copy and use the Copy command (Ctrl+C or Copy from the Edit menu).
• Go to Banana accounting and issue the Paste command (Ctrl+V or Paste from the Edit menu).

Method 2

The second method uses the Import Rows command from the Data menu.

• Download the specific Excel file to enter the contact data.
  • The file is already set up with the necessary columns for entering the data.
  • Row 1 contains the column headers. This row should not be deleted, and the column names should not be changed.
  • The subsequent rows are example contacts.
  • To enable editing of the file, click "Enable Editing" in the yellow bar at the top.
• Open the file and enter the address data of your contacts in the appropriate columns. The columns are as follows:
  • RowId: The unique ID of the contact.
  • OrganisationName: The name of the organization or company.
  • FirstName: The first name.
  • FamilyName: The last name.
  • Street: The street.
  • PostalCode: The postal code.
  • Locality: The place.
  • CountryCode: The country code.
  • LanguageCode: The language of the contact used to create invoices. The invoice texts are printed in the defined language (it=Italian, de=German, en=English, fr=French).
    
    
     
• Save the file
• Select all the rows and use the Copy command (Ctrl+C or Copy from the Edit menu).
• Import the contacts into Banana accounting.
  • In Banana accounting, open the Estimates and Invoices file type.
  • Select the Contacts table.
  • From the Data menu, select the Import Rows command.
  • In the dialog that opens, check the option Import data from clipboard, then confirm with OK.

Create and Import Invoices

Invoice data can be created using an Excel file. In this file, all the data is entered and then subsequently imported into Banana accounting.

• Download the specific Excel file to enter the invoice data.
  • The file is already set up with the necessary columns for entering the data.
  • Row 1 contains the column headers. This row should not be deleted, and the column names should not be changed.
  • The subsequent rows are example invoices.
  • To enable editing of the file, click "Enable Editing" in the yellow bar at the top.
• Open the file and enter the invoice data in the appropriate columns.
  • For more information on the columns, see the Column paragraph of the Estimates and invoices import page.
  • Each row represents an invoice.
  • You can enter an invoice with multiple items. For each item, add a row to the invoice (see example in the image, rows 5-6).
    
    
     
• Save the File.
• Convert the Excel invoice file into one of the two required formats (*.csv or *.txt) to import the data into Banana Plus.
  • Open the Excel file with the invoice data.
  • Click on File > Save As.
  • Choose the option CSV (Comma delimited) if you intend to use the *.csv format; or choose Text (Tab delimited) if you intend to use the *.txt format.
  • Save the file (once the file is created, it's advisable not to open it to avoid making any changes, even unintentional ones, that could compromise the import into Banana Plus).
• Import the Invoices into Banana.
  • In Banana Accounting Plus, open the Estimates and Invoices file type.
  • Select the Invoices table.
  • From the Extensions menu, select Estimates and Invoices Tools > Import Invoices.
  • Select the *.csv or *.txt file you saved.
  • A dialog will show the changes that will be applied to the Banana file. Confirm by clicking OK.
  • In the Invoices table you see the rows with the imported invoices.
    If you do not see the imported invoices (you only see blank rows), use the command from the Invoices > Recalculate All menu.

Print Invoices

See how to print invoices and customize the print settings.

Error Messages and Troubleshooting

Per eventualFor any error messages encountered during the import process, refer to the documentation on Error Messages and Troubleshooting.

Create a new file

To create an Inventory file, you must have installed the Banana Accounting Plus version and take the following steps:

• Menu File → New
• Select Region and language
• Select the Inventory type.

Set the basic data

Via File → File and accounting properties ... (Base data) set up your inventory data.

Set up the Articles table

In the Items table set the list of all your items.

For each item you must enter:

• The Id to identify the item. You can use numbers, letters or both.
• The description.
• The initial quantity.
• Initial price.
• Unit price.

Once the data has been entered, the program automatically updates the values of all the columns of the Items table.

Set up the Locations table

If your company manages several inventories located in different locations, you can manage the incoming, outgoing and transfers of items for all inventories by setting the locations. You will be able to find out how many items with their relative values are in each inventory and evaluate whether it is necessary to transfer the goods from one inventory to another depending on the stock and sales requests.

In the Locations table you must enter:

• the Id to identify the location
• The description

Enter the movements of the articles

In the Transactions table enter purchases, sales and any transfers from one inventory to another.

• Enter the date
• Enter the date
• The quantity in or out

Everything is done! The columns of the values will be updated automatically, at the same time also in the Articles table.

Item cards and reports

From the Report menu, Item cards you can get the cards of each item individually, by selection or for all items.

You can also get reports by item group and also by inventory location. The options are found in the Inventory cards dialog.

In the menu File → File properties (Basic data) set the data of your inventory.

File base data

Enter the inventory header.

Address

Enter the inventory address.

Other

The Other section contains the following options:

Current language
Is the current language of the inventory file.

Creation language
It is the language in which the inventory file was created.

Extensions
Link to any extensions for custom reports.

Password

Enter any password to make the file more secure.

Texts

To make changes to the texts and keys of the inventory application.

In the Items table, enter all the inventory items which need to be managed, along with their respective quantities and purchase values.

Create the items list 

In the Items table, all the available items in the warehouse are recorded. Each item is entered individually on each row. To total the amounts for a group of items, a totalization group must be entered.

The group is defined in the Group column, at the end of the list of items of the same category. The group number must be reported in the Sum in column for each item.
For further information on the grouping system, please refer to the Grouping System page

You can create further groups of items depending on your requirements.

To complete the registration of the items it is necessary to enter:

• The Id to identify the item.
• The description.
• The initial quantity.
• The initial price.
• The unit price.

Items table columns

The command Data > Columns setup allows you to add additional columns as needed (for example, an additional description or product expiration date).

Default columns:

Columns marked with "*" are protected and calculated by the program.

• Links
  Link to a digital document.
• RowGroup
  Column and row to enter the totaling group of a given set of items.
• RowId
  Enter a value (number, letters or both) to identify the item.
  When it is entered in the Transactions table, the item description and unit price are automatically added.
• Description
  Enter a text for the description of the item.
• Sum in (in the arrange columns it is written RowGroupIn)
  Enter the totaling group for each item in this column.
• Notes
  You can insert texts for annotations on items or for other needs.
• Account
  Enter the account present in the main accounting file that refers to the item.
• ReferenceUnit
  Insert an abbreviation to indicate the unit (eg pcs to indicate the pieces).
• QuantityBegin
  Enter the initial quantities referring to the total.
  If you want to manage separate quantities by locations, leave this column blank, and enter the initial quantities as entry transactions, with the corresponding location.
• UnitPriceBegin
  Initial unit price
  If you want to manage separate quantities for locations, leave this column blank and enter initial quantities as entry transactions, specifying the respective location.
• *Valuebegin
  Initial item value calculated by multiplying the Initial Quantity and Initial Unit Price.
• *QuantityPlus
  Total quantity of items resulting from the sum of the Quantity Plus in the Transactions table. Both the positive and negative values are added. The internal movements between two locations are not added up, when there is TransferId indicated.
• *QuantityMinus
  Total quantity of items resulting from the sum of the QuantityMinus in the Transactions table.Both the positive and negative values are added.The internal movements between two locations are not added up, when there is TransferId indicated.
• *QuantityChange
  Difference between the item's inbound and outbound quantities.
• *QuantityBalance
  Quantity of items currently in stock. Sum of the starting quantity and the Quantity change.
• UnitPrice
  Unit price of the item, must be entered manually:
  • When the purchase value of an item changes compared to the initial price, it must be updated in this column.
  • This value is used in the Transactions table to calculate the value of incoming or outgoing goods
  • Updates the total value of the item based on the quantities in stock.
• *AmountTotal
  Amount calculated by the program based on quantities and unit price. (last purchase price)
• ItemQuantityEffective
  For insertion of actual quantity when inventory has been done.
• ItemPriceEffective
  The actual quantity multiplied by the actual price.
• *ItemValueEffective
  The actual quantity multiplied by the actual price

This is the table where the movements of the items are recorded:

• Purchases
• Sales
• Transfers from one warehouse to another, in case you are running several warehouses.

By inserting the movements, the Items table is also automatically updated, in relation to the quantities and corresponding values of the items.

If several warehouses (headquarters and branches) are run simultaneously, the ID codes, set in the Locations, can be recorded, which will refer to the places where the warehouses are located, in order to keep track of the internal movements of the articles.

The ID abbreviations must be entered in the Locations and Transfer columns of the Transactions table. If they are not visible, they can be displayed via the Data → Columns setup menu.

Transactions table columns

• Links
  Link to a digital document.
• Date
  The date of the operation.
• Doc.
  Document number (e.g. delivery note number).
• ItemsId
  Numeric or alphanumeric value to identify the item.
• ItemsDescription
  Text taken automatically from the Id column of the Items table for the description.
• Description
  Text to be entered for the description of the items.
• Notes
  In the column you can enter notes about the items or for any other requirement.
• QuantityPlus
  Value to indicate the quantities of incoming items, purchased or transferred from other inventories.
• QuantityMinus
  Value to indicate the quantities of items that are outbound, sold or transferred to other inventories.
• ReferenceUnit
  Abbreviation to indicate the type of unit.
• UnitPrice
  The price of the item with which the total value of the items is calculated, based on quantities.
• AmountTotal
  Total value of the items purchased, sold or transferred.
• LocationsId
  Identification of the place where the Inventory is located and from which the items enter or leave.
• LocationsDescription
  Name of the place where the inventory is located, from which the items come in or out.
• LocationsTransferId
  Code of the place where the inventory is located for which the items are intended.
  It works the opposite way to the LocationsId.
  • If there is an entry to LocationsId, there will be an exit to LocationTransferld.
  • If there is an exit from the LocationsTransferId there will be an entry.
  • If LocationsTransferId is indicated, but the LocationsId is left empty, the program will still consider it as an internal movement without a specific LocationsId.
• LocationsTransferDescription
  Name of the place where the inventory is located, from which the items arrive or leave, to or from another inventory.

The Locations table is used when the company has more than one inventory in different locations. In order to take into account the total number of items in and out of all inventories, by entering the ID for the locations in the Transactions table, in the columns Location and Transfer all the values of the items are known, also for a single warehouse and the relative movements.

Refer to the Transactions table for further information.

Places table columns

• RowId
  Identification of the location where the inventory is located.
• Description
  Name of the location where the inventory is located.
• Notes
  You can insert text for notes.

Everything you see on video can be printed as a report, since, after each transaction, all values are updated.

You can print the table data from the File menu → Print command. Data can also be exported in PDF, Excel, XML, HTML, TXT and JsonCsv formats.

Reports are run from the Reports menu → Item cards command. You can obtain:

• Journal of a selected item or items.
• Complete journal of all items.
• Journal of items of a particular inventory location, in case there are multiple locations.

Inventory report

Note

To obtain the total of the articles for each location and the final balance of the articles, you need to group by article and by location.
If you want to manage separate quantities by locations, enter the initial quantities as entry transactions, with the corresponding location and don't use the column Quantity Begin in the Items table.

The warehouse application can also be used for very advanced purposes.

Customer / project management

To find out to which customers a product has been sold or given, you can proceed as follows:

• Add a column in the Transactions table, where you enter the name of the customer / project.
• Add a table where you list the customers and assign a code.
  • Add a column in the Transactions table that is linked to the customer.

You can add as many columns / tables as you wish to keep track of projects, suppliers or other.

To filter the transactions carried out by a customer, go to the Transactions table and in the column Customers or Projects, use one of the following commands: Extract and sort rows; right-click on the customer cell and choose Extract rows; use the filter function.

 Online Shop / Virtual Stores

If you operate an online shop, you can use the Locations table to define virtual warehouses, where you can indicate the goods to be shipped, incoming, reserved, etc.

Here some cases:

• Online purchase of goods by a customer.
  • As soon as the order is received, you record a movement between the physical warehouse and the virtual warehouse called "Dispatch".
  • When the goods are then physically dispatched, you record the outward movement from the warehouse called "Dispatch".
•  Ordering goods from a supplier.
  • When you order goods, you record an incoming movement to the virtual warehouse called "Arrivals".
  • When the goods arrive, record the movement from Arrivals to the main warehouse.

By creating other virtual locations, you can also manage more complex workflows.

Importing data

With the import command you can take data from other programmes, in any of the following ways:

• Open the file in Excel and arrange the columns as you have them in Banana and then use copy and paste.
  You can also create a view, setting the columns in which to report movements.
• Prepare extensions that import and convert data from existing formats.

  The Time sheet is the new Free Banana Accounting Plus application that allows you to easily manage your working hours and instantly know the situation of hours worked, overtime, holidays, absences.

To start, just download and install Banana Accounting Plus and, when creating a new file, choose the Time sheet template.

• ▶ Video: Timesheet

Multiple automations to allow for quick and easy management of hours .

• Software available free of charge, to work on any operating system, including mobile.
• Easy to use and implement solutions, no login and password required.
• Each employee keeps the file on their computer or mobile device.
• Fully adaptable to the requirements of the employee and the company.
• Great time savings and calculation errors are avoided.
• File templates available with the calendar of the current year.
• Powerful and automated calculation system.
• Uniformity of calculations. All calculations are based on hours and minutes and this makes it possible to adapt to every case and requirement.
• Balances and totals updated instantly by day, month and year.
• Data entered in predefined columns, for results that are always ordered and clear.
• Forecast for working hours.
• Management of project hours.
• Hours worked and indication of less or more hours worked and progressive balance.
• Indication of the holidays taken and remaining, with carry over to the following year.
• Possibility of coding other useful information for the company (projects, expenses, notes).
• Complies with the regulations of the European Court of Justice and Swiss regulations.

How to keep the hours

The Time Sheet supports different data collection methods:

• Systematic collection.
  Enter the work start and stop times and the program will calculate the hours worked. Display the Start1-Stop1, Start2-Stop2, ... , Start5-Stop5 columns where you can enter the times of beginning and end.
• Simplified collection.
  Indicate the hours worked in a day, 
  Display Work1 and Work2columns to enter the hours worked of the day.
• Mixed collection.
  You can enter both the time of beginning and end, or the time worked.
  Display the Start and Stop columns and the Work columns. 

Accurate and uniform calculations for every use

The time sheet always uses the hour and minute format (for example: 8:15). Holidays and absences are also indicated daily with hours and minutes. This allows for easy and accurate management of situations with irregular working hours, or that are subject to change.

The totals are also always shown in hours and minutes. This uniformity allows an exact overview of one's work situation, fully compliant with legal regulations, and avoids discussions between employee and employer regarding the calculations.

Below is an overview of how data entry and calculations take place.

• Expected working time (hours due)
  For each single day of the week, the exact number of hours and minutes of work expected can be indicated. The program indicates the expected total of hours per week. The working hours can also be changed only temporarily (for example change of hours during only one week).
• Hours worked
  The daily working hours can be entered with taking up work or leaving time(s), or even as a total of hours and minutes or a combination of both. The program then calculates the total number of daily hours worked.
• Extra hours for nightshift or holidays
  They can be specified both as hours and minutes and as a percentage; the program then calculates the total.
• Holidays
  They are indicated in hours and minutes for the entire year. It's simple, just multiply the total hours per week by the number of vacation weeks. The program calculates the remaining holiday balance which will be accurate to the minute, even if the working hours are variable.
• Absences due to illness, military service or any other kind
  They are also referred to as hours and minutes. The program then calculates the total number of absences per day.
• Total hours
  This is the sum in hours and minutes of hours worked, supplements and absences. The program calculates the daily difference between the hours due (expected) and the total. There is also a progressive counter of the differences so that you have an instant view of the hours balance.
• Columns related to time counters
  The program will calculate the monthly and yearly total, displayed in hours and minutes format, so that you have complete control and consistency of calculation.
• Hours in decimal format
  When entering hours, you can also indicate a decimal number (8.50) and the program converts it to hours and minutes (8:30).
• The Time sheet also displays some totals in decimal hour format, so as to simplify the insertion into other programs.
• The monthly report presents the totals of the daily and monthly hours.
• Print extensions allow you to total and view working time in any other format.

File and data saving

• All the data is saved in a single file, where you can easily retrieve everything without wasting time.
• Give the file the name you want.
• You can manage an unlimited number of files.
• Save your data to any media, computer, network, cloud or it can be emailed. You can access it wherever you are.
• Make your Time sheet more secure by using password protection.

Based on columns such as Excel

The Time Sheet has a Journal table with columns already set up, where you can write down your working hours (start and end time), holidays, overtime or any sick leaves, day by day.

• The columns of the Journal table are predefined and can be displayed as desired.
• Predefined columns for many needs:
  • Working hours forecast.
  • Actual hours worked.
  • Difference between hours worked and expected hours. Therefore, the overtime hours or hours to be recovered are reported.
  • Annotations and Refunds.
  • Hours for projects.
• Possibility to add multiple rows for the same working day.
• In the Links column you can add a Link to a document (example medical certificate).
• The Search command allows you to quickly search for data.

Error reporting and control

• Command for recalculating the Time sheet.
• Reporting of any wrong settings, differences or errors.
• Each report contains a link to a help page that explains the causes and the solution.
• Possibility to correct.

Monthly Printouts and Reports

• Printable ledger as seen on the screen, or by selection.
• Monthly Report.

Exporting, Importing and Archiving data

• Copy and paste directly to and from Excel.
• Export tables to pdf and various other formats.
• Archiving of printouts and accounting data in pdf or other formats.
• Saving the accounting file on any backup device.
• Importing time sheet data into other programs.

Comprehensive documentation

• Each dialogue and error has its own documentation page accessible in a click.
• Constantly updated documentation.
• FAQ.
• Documentation also available in Pdf format.

 Features currently not available

These features, although requested by some users, are not available at the moment:

• Possibility to include the logo on the printout of the monthly report, as well as an indication for the signature, and to be able to select the columns to be printed.
• No link with billing. Working hours must be reported manually in the billing

To use the Time sheet, Banana Accounting+  has to be be downloaded and installed. In the free version, the Time sheet is in unrestricted mode.

• ▶ Video: Timesheet

For a quick and easy start of the Time sheet, we recommend opening one of our templates.

Banana Accounting includes three types of template with preset columns:

1. Systematic records - the start and end times of work are indicated, as generally required by law.
2. Simplified registrations - enter the daily hours worked (with due hours setting).
3. Hourly wages - the daily hours worked are indicated (without setting hours due).

Setting up your Time Sheet file

Proceed as follows to set up your file:

• File menu → New
• Select the Region/Language
• Select the Category -> All or Other
• In the Search area, type Time Sheet, or activate under Type -> Time Sheet. The program displays the available templates.
• In the section on the right, select the desired template.
• By double clicking on the name of the selected template or on the Create button, the program will directly open the file.
• Save the file under a new name.

Setting up your data

• Set up your own data from the File menu -> File and accounting properties (Basic data) -> Time Sheet .
• Enter your first and last name, start and end date, work percentage of work and other required data if available.

Set working hours as per contract

• Set the weekly working time via the File → File and accounting properties → Start .
• The cells of the Report are intended for unpaid hours of work and for hours of unused holidays carried over from the previous year.
• Enter working hours for each day and define working days, festive days and holidays. These settings are displayed in the Journal table.

Recording work time

In the Journal table you enter the daily data, the time of start and end of work, the hours of absence due to illness, holidays and leave. The data can be modified and entered as required.

1. Write down the hours of vacation you are entitled to in the current year.
2. Include, edit, add, personalize any holiday if needed.
3. Enter your daily hours of work, sickness, vacation, etc.

• The first row of the Report shows the hours of holidays not taken from the previous year, present in the Start dialog.
• In the Start row of the first day of the month, you enter the hours of annual holidays to which you are entitled, as per contract.
• Non-working days are distinguished in blue, while holidays are in red.
• The program calculates on the basis of the data entered, the daily and monthly totals of the Due, the difference between the hours worked and those due and the progressive.
• In the window below, the balances of the weekly hours due and worked and the balance of the holiday hours are reported automatically.

Printing your end of month report

Using the Reports → Monthly Report...  command, the program calculates and displays a summary report of the selected period with the main columns to be used.

For more detailed information and specific examples of the Time sheet application, please refer to the following pages:

• Time Sheet
• Characteristics
• Setting up the file
• Journal table
• Enter working hours
• Printouts
• Managing project hours

Via the File menu → File and accounting properties ... → Time Sheet tab the following data must be set up:

Enter into the Timesheet tab:

• Name and Surname.
• Start and End date
  You can enter any period of your choice.
• Work percentage
• Any other available data.

In the Journal table you enter the daily data of the Time sheet, which can be modified and entered according to your own requirements.
Thanks to the rows and columns with totals, it allows for an instant overview of the situation.

The Journal table includes several columns to suit all needs. Depending on your needs, the columns of your choice can be displayed.

Typology of rows, colors, and formats

When creating a new file, the rows of the Journal are generated automatically by the program. When using an existing template, they will already be predefined.

Daily rows

Daily rows are used for entering your data.

• Normal rows - refer to rows for working hours.
• Rows in red - refer to official holidays
• Rows in blue - refer to non working days.
• Rows high-lighted in yellow - refer to the current date.

Multiple rows for a day

By duplicating the day row, you can enter additional information about the same day, such as timetables by project, annotations, or other.
To differentiate between the following rows, the Day description is slightly indented.

Carried forward, Start, Total and Balance rows

The Carried forward, Start, Total and Progressive row are indicated in bold character.

• The Carried forward row will automatically display holidays and hours belonging to the previous year, that were entered via File property > Start.
• The Start rows refer to the start of the year and month.  Enter the initial values for holidays and hours.
• The Total rows refer to the end of the year and month. The total of columns are automatically reported and totaled here.
• The Balance rows are automatically calculated by the program and will the progressive value of the columns that contain data.

Journal table view

The Journal table is created with a series of columns that will cover the major part of your requirements.
Predefined columns are displayed, depending on the view you select:

• Base - displays the main principal columns.
• Minimal - displays the columns to enter your data.
• Complete - displays all available columns of the Journal.

Working hours and other data are entered in the Journal table.

In the Carry forward row, the programme reports the holiday hours from the previous year, entered in the File and Accounting Properties > Start dialogue.

In the Journal table, data can be edited and entered as required.

1. Write down the holiday hours to which you are entitled in the current year.
2. Include, edit, add, customise any holidays if required.
3. Enter your daily working hours, sickness, holidays, etc.

Print your monthly report

If you go to the Reports menu > Monthly Report..., you can immediately generate, print and save a complete monthly report.

Useful links

• Journal table
• Salary types (Fixed salary or Hourly salary)

Working with the Banana Accounting Time sheet can be optimized, via different functions in the Reports and Actions menus.

Reports Menu

The Monthly Report command is activated via the Reports menu, to create the monthly report of working time and other data entered in the Journal (holidays, absences, other) month by month.

Actions Menu

The following commands can be activated in the Actions menu:

Go to today

Positions the cursor on today's row.

Recheck all... (F9)

Sort the rows by date.

Check-in or Check-out

Inserts the current time in the selected cell. Alternatively, you may type "." (point without quotes) in the selected start or end cell.

Fill Day (from last week)

Resumes work and absence time of the current day with the values of the day of the previous week.

Fill Week (from last week)

Resumes work and absence time of the current week with the values of the respective days of the previous week.

Add row day

Adds a row successive to the selected one and with the same date. Use this to enter additional daily values.

Add row total day

Adds a row, where daily values will be totaled.

Create rows for period ...

Add rows (daily, start, total, balances and carryovers) based on the selected period. All rows of the Journal will be sorted by date. 

Create New Year

The command creates a new Timesheet file for the following year, transferring the initial values of the vacation balance and hours from the previous year into the new file.
Warning! When creating a new year, public holidays are not flagged. It is necessary to manually modify the days that are marked as holidays.
 

To avoid manually handling holidays, we recommend downloading the template file with the holidays already set according to the country. In this case, you will need to manually enter the vacation and hour balances in the File Properties > Start section (File menu). See How to start.

Import Time sheet

Takes over values from an external time sheet. You indicate the file from which to recover the values and specify which values to recover.

The program searches the imported file for rows with the same date and section, and resumes these values.
If there are multiple rows for the same date in the imported file, these values after the first line are not imported.
The dialog box allows you to choose one of the following options:

Import festive only

It only imports the values from the Festive column.

Import all values

It imports the Festive, Notes, Worked, Absences, Adjustment, Due and Subdivision values.

To create the Time sheet file for the new year, there are two options:

1. Download the Time sheet Template with Predefined Holidays for the New Year.
2. Use the Create New Year Command from the Actions Menu.

New Year Time sheet from Default Template

This is the recommended procedure. The template already includes predefined holidays according to the country.

In this case, you need to:

• Start Banana Accounting
• Go to File > New
• Choose Time sheet as the file type
• Select one of the proposed templates as the Time sheet

There are the following predefined templates:

Time Sheet - Systematic Recording

This model is ideal for those who need to record work hours by specifying the start and end times for all working days defined in the Basic settings (Menu File > File Properties (Basic Data) > Start section).

In the Journal table of this model, there are the following main columns:

• Start, Stop, Due, Difference and Progressive
  By entering the start time and end time in their respective columns, the program automatically calculates and inserts the hours worked, the difference between the hours worked and the hours due, and the balance of hours in the Progressive column. If the balance is negative, the hours worked are less than the hours due; conversely, if the balance is positive.
   

Time Sheet - Simplified Recording

This model is ideal for those who record the total hours worked daily without specifying the start and end times.

In the Journal table of this model, there are the following main columns:

• Work 1, Work 2, Due, Difference, and Progressive.
  Unlike the systematic recording model, the start and end times are not entered; instead, the total hours worked are recorded. The program automatically fills in the Due column (for the hours of work required by the contract), the Difference column (between the hours worked and the hours due), and the Progressive column (for the balance of hours).

Time sheet - Hourly Wage

This model is to be used in cases where work is paid by the hour without a fixed salary. Therefore, in the Basic settings (Menu File > File Properties (Basic Data) > Start section), the Start dialog remains empty without indicating the hours due.

The columns are identical to those in the Time sheet - Systematic Recording and Time sheet - Simplified Recording templates. The difference lies in the Progressive column because, starting from February, the Due Code column contains the code RP (Restart Progressive) to ensure that the Progressive column resets and does not display the balance of hours, as payments are made monthly.

Once the template is saved with a name, it is necessary to manually carry over the balances for overtime and vacations from the previous year.

• Menu File > File Properties (Basic Data) to enter the employee's data.

New Year Timesheet Using the Create New Year Command

This procedure involves creating the new year's timesheet starting from the previous year's file:

• Open the previous year's Time sheet file.
• Menu Actions > Create New Year.
• Save As the new Time sheet.

In this case, the balances for overtime and vacations from the previous year are automatically carried over to File Properties (Basic Data) > Start section (Menu File). The initial data is also carried over to the initial rows of the Journal table, where you need to enter all the hours for the vacation days to which you are entitled in the Start row.

Attention: Public holidays are carried over as they were in the previous year. Therefore, it is necessary to verify all holidays and correct them manually.

Print Journal table

When using the File → Print ... command, you can:

• Print all the rows of the Journal table.
• Print the selected rows of the Journal table.

Monthly report

Using the Reports → Monthly report ... the program will calculate and display a summary report of the selected period including the main columns used

• If you want to change the column headers in the printout, you have to change them in the Journal table. They will be resumed automatically.
• The program prints the default columns.
  For the moment it is not possible to print other columns when printing the monthly report.

With the free Banana Accounting Plus Time Sheet, you can easily start entering work times, your holidays and absences and instantly know the totals and balances of all the data.

According to what is stipulated in the contract:

• Set the due working time (agreed) and include holidays.
• Actual working hours and absences are entered.
• The program calculates the daily and progressive balance.

All values, time due, hours worked, absences and holidays are entered and displayed as hours: minutes (eg 10:30).
This unified approach allows you to enter data quickly and instantly and be in control of the situation.
The values entered are checked by the program. If you enter an incorrect value, it will show instantly. 

Setting up the due time

The Time Sheet, in File Properties - Start, allows you to quickly set up the weekly working time.
If the scheduled time is different or changes during the year, you can adapt it, see Set the working period and times.

Planned Holidays are set directly in the Holidays column instead of the Journal table.

Entry of working times and absences

Enter the daily values in the appropriate columns of the Journal table, relating to the following data:

• Hours of work carried out are entered as follows:
  • Entry and exit times (systematic collection)
    The program calculates the hours and minutes of work.
  • Work hours, Work 1 or 2 columns
    Total hours worked are entered.
  • If you enter both entry and exit values and hours worked, the program adds them.
• Hours of absence (Sickness, Vacation, Service, Other).
  These are the hours that will be deducted from the due hours.
• Adjustments.
  When accounting adjustments are required, enter a positive or negative value in the Adjustments column.
  When extra hours are paid, for example, the hours are entered in negative, so that the progressive is reduced.

How to change the work rate during the year

If the number of working hours due increases or decreases during the year, the new settings must be entered in the Journal table, in the columns Due code and Due.

On the day in which the changes are to be implemented (e.g. from 5 working hours to 8):

• In the Due code column, enter the code WS.
• In the Due column, enter the current due hours (8)

The programme resumes the change of the new due hours for all weeks of the year.

For other customisations, please refer to the explanation of the Due code column .

If the available holiday hours change during the year, the differences must be calculated and changed manually. See Changes during the year.

Multiple rows for the same days

You can manage multiple rows for the same working day, where you can enter different daily values. To make understand that it is the same row of the day, the description is indented in the following rows of the same day .

There are several possibilities to create an additional row for the same day:

• Via the Edit → Duplicate rows... menu
• Via the Edit → Add rows... menu, inserting the date of the day (you have to remove the protection from the date column).
• Via the Actions → Add row Day (only in the Banana Accounting Plus version).

The difference with respect to the amount due and the totals

In the Journal Table, the program displays the following data after each entry:

• The difference between the hours due and the hours worked on the day.
• The progressive balance.
• The total by month, year and grand total of the different hour columns and numeric columns.
  The total for the holidays results as the difference between the holidays set at the beginning of the year and those used, see Holidays page.
• The carry-over to the end of the month and year of the various numerical columns:
  • The carry-over is the total of the position, and also takes into account the values of the previous periods.
  • At the end of the month you will also known how many hours have been done since the beginning of the year.
  • The final total is equal to the carry-over.

Monthly printout

The monthly printout presents all values in summary form.

Adjustments and payment of accumulated hours

The Adjustments column allows you to modify the total hours due / worked.

• If hours are accumulated and these are paid:
  • In the row of the day they are paid
    • Enter the hours paid in negative in the Adjustment column.
    • Indicate "Payment of accumulated hours" in the notes
    • The progressive balance decreases.
• When accumulated holidays are paid:
  • In the row of the day when the holidays are paid.
    • Enter the hours paid in negative in the Holidays column.
    • Indicate "Accumulated holiday payment" in the notes
    • The progressive balance decreases.

With Banana Accounting Plus you can easily start keeping track of the hours dedicated to projects, obtaining instant reports that you can view at any time.

Users who have files created with older versions must convert their file.

To manage working hours for projects, add the required columns in the Journal table.

There are two ways to manage project hours:

1. Work with the Projects table.
2. Work with the Work1, Work2 columns, etc.

Manage projects in the Projects table

You will need to add the Projects table if using this method:

Tools menu → Add new functionalities → Add table → Projects.

The following columns are available in the Projects table:

• Id - enter an id unique for each project
• Description - enter the name/description the project.
• Notes - enter any additionally required notes.

Adding the Projects table will automatically add the Projects Id and Projects Description columns in the Journal table.

Display the following columns in the Journal table via the Data →  Columns display ... menu:

• RowType (Type) column - enter D if you wish to separate the detail of the project hours  from the total of hours worked.
• TimeDetailTotal (Detail) - is a protected column. If D has been entered in the Type column, the program calculates and displays the total project hours projects separately.
• If the Type column is empty, the program calculates and displays the total of project hours in the Total column.

Enter project hours

The hours dedicated to projects can be managed within their own worksheet.

To separate the hours of work done, from the project hours of, it is necessary to:

• Position yourself on the line of the day to which you want to add the project (or projects).
• Via Utilities1 → Add row Day add a new row.
• Enter D in the Type column if you want to separate the detail of the project hours from the total hours worked. Leave blank, if you want the total project hours to be added to the hours worked (Total column).
• Enter the Id of the project, as set up in the Id table. The project description is automatically displayed. 
• Enter the start and end time of the project.

The program calculates and updates the Total, Due, Difference and Progressive columns

Manage projects in the Work1, Work2 (etc) columns

As an alternative to the Projects table to manage project hours, it is possible to use the Work1, Work2 (etc.) columns. 

Each column refers to the hours of a different project. The program includes two predefined columns, but you can add other columns under condition that TimeWork3, TimeWork4... is inserted in the Xml name of the New column window (menu: Data → Columns setup ... → Add).

Via Data → Columns setup, display the following columns in the Journal:

• RowType (Type) column - enter D if you wish to separate the detail of the project hours  from the total of hours worked.
• TimeDetailTotal (Detail) column - is a protected column. If D has been entered in the Type column, the program calculates and displays the total project hours projects separately.
• If the Type column is empty, the program calculates and displays the total of project hours in the Total column.

Enter project hours

The hours dedicated to projects can be managed within their own worksheet.

To separate the hours of work done from the project hours, it is necessary to:

• Position yourself on the line of the day to which you want to add the project (or projects).
• Add a new row via Actions → Add row Day menu.
• Enter D in the Type column if you want to separate the detail of the project hours from the total hours worked. Leave blank,k if you want the total project hours to be added to the hours worked (Total column).
• Enter the Id of the project, as set up in the Id table. The project description is automatically displayed. 
• Enter the start and end time of the project.

The program calculates and updates the Total, Due, Difference and Progressive columns.

Adding Additional Columns

If you need to keep track of instruments used, amounts, kilometers traveled or anything else in the project, you can add additional columns via the menu Data → Columns setup.

These can also be linked with an added table.

Report with project and resource data

You can filter your projects and resources and create a report with data for each of them.

The Time Sheet allows companies, which do not have an automated work time tracking, to easily start with a modern data collection system and have immediate counts and reports, without wasting time.

In order to protect their employees, companies are required by law to set up a system for recording the daily working time, complete with absences and holidays.

• In Europe this principle was reiterated in a ruling by the European Court of Justice. It is up to the member states to regulate this matter.
• In Switzerland there are ordinances in this regard which require the systematic recording of working time, with some exceptions for the simplified recording (only the number of hours worked).

How to implement the Time Sheet for your employees

• Each employee will have to download and install Banana Accounting on their computer, tablet or mobile phone.
• The employee creates his own time sheet for the entire year.
  There are several methods:
  • Use a template emailed to him by his employer.
  • Start the program and via the File → New menu create your own Time Sheet, for the entire year, choosing the most appropriate Time Sheet template.
• Each employee enters their working hours and saves the file on their computer.
• At the end of the month, the employee generates his own Monthly report and sends it to the employer. Alternatively, you can directly send the entire file of your time sheet.

Self-declaration of hours worked

The Banana Accounting Timesheet allows each employee to input their hours individually and to always be in control of their situation.
The month-end report will summarize all the necessary information. You can also create specific reports for specific needs, if required.

Centralized data entry

The Timesheet is also suitable if the employer collects the data of the hours delivered by the employees.
Hours can be attributed to projects or whatever else is needed.

Preparing templates for your company's employees

Each company has different requirements.
To facilitate keeping hours for your employees, it is useful to prepare Time sheet files that serve as templates, with the following presets:

• Annual holidays.
• The columns required for the type of data collection (systematic, simplified, mixed).
• The columns for the type of salary.
• The columns for absences.
• Additional columns for reimbursable expenses, projects and notes on the progress of the work can also be added.

Specific reports

Extensions allow you to create specific reports, tailored to the needs of a company.

Version for employers

We are thinking about developing an application for employers that will allow for the collection and consolidation of the data contained in the files managed by employees, for statistical or other purposes.

Should there be a wider interest in such a tool, please report it to us via the contact form, by also indicating which functionalities would be of interest to you.

  The Fixed Assets Register is a Banana Accounting Plus application to manage your amortisable assets quickly and easily and instantly know their initial value, history, and year-end amortisation.

It is a very flexible, intuitive and powerful tool for calculations.

• You work in tables like with Excel, very intuitive and with all values always visible and updated.
• You have functionalities that automate the calculations, obtaining constantly updated values and balances:
  • Initial purchase value.
  • Book value.
  • Quota and percentage of amortisation.
  • Columns for the date of purchase and the duration of the warranty.
  • Journal
  • Items Report.
• Instant search for amortisable assets
• In case of errors, you can modify and correct, so as to always have order and precision.
• Application usable in any country.

Substitute for Excel tables for amortisation

The Fixed Assets register is a very precise, but also malleable tool that can be adapted perfectly to your requirements. It allows you to automate the calculation of amortisation, but also offers you the possibility to enter amortisation manually, so that, when there are special cases or exceptions, you are not obliged to change formulas and totals.

The application can be used in conjunction with other accounting programs, you are much more flexible and also save on license costs. For each period (month, quarter, semester or year) you can produce a printout of the summary of the amortisation to be recorded in your accounting program. You can export the data as well, if you wish.

• Add as many rows as you want without limit, or you can delete the rows you don't require.
• You don't need to enter formulas because the calculations are updated instantly and you have a contextual view (like in spreadsheets).
• Everything you see can be printed or exported to PDF or other formats.
• The columns are customizable, you can change their position, add new ones and change their width.
• Work with the format that suits you best. 
• Color the rows to immediately identify the items that you need to order or that have been booked.

Based on tables

Fixed Assets Register management focuses on three main tables, which are used in a similar way to those of Excel, but that are already fully set up and programmed with everything needed to manage your inventory in a fast and safe way. 

• Items table
  This is the table where you set up all the assets subject to amortisation. Each item (or amortisable asset) has an identification ID, a description, a group and an account to which it belongs, the counterpart entry and all the calculation parameters for the amortisation. You can freely create groups of items, without any limits. When viewing this table, you immediately have a complete and updated view of all your amortisable assets.

• Transactions table
  This table records all the operations that modify the historical, book or fiscal value of an asset. It is a table with automatic columns: by selecting the type of amortisation, the description of the operation is automatically entered (sale, write-down, revaluation, amortisation ...); via the selection of the article ID the description of the article is automatically inserted. When scrolling the table, you have a complete view of all the events during the year. If you realize that you have made a mistake, you can modify to always have perfect accounting. 

• Amortisation type
  This table where amortisation codes are to be entered so that, when you buy a new asset you can decide which type of amortisation to attribute: on historical value, book value, on a specific amount, full amortisation and no amortisation. Once the codes have been established, they must not be changed to ensure consistency and correctness in the calculations. The column of codes is visible both in the Items table and in that of the Journal, so as to always be in control of which amortisation has been calculated.  

• Transaction type
  This table defines the types of operations to be resumed in the Journal table. Each operation has an identification ID that must not be changed, so that the same description is always used in the journal table. This facilitates and speeds up the insertion of data in the Journal table.

Accounting setup

Fixed Assets Register headers and basic data set up in a single, easy-to-view dialog.

• Company headings and address with free texts.
• Language settings.
• Link to extensions for customizations.
• Password to secure your Amortisation Register file.
• You can have multiple files in different languages.

Easy and precise management thanks to the accounting logic

Unlike Excel spreadsheets, changes in value (amortisation, new purchases, write-downs) are not entered in columns, but in a table of transactions.

• The Items table lists the individual assets, with the date, purchase value, type and percentage of amortisation and other elements.
• The amortisation, revaluations or write-downs for each individual asset are indicated in the Transactions table.
  • It is the history of all the changes in the value of the asset, from purchase to disposal.
  • The Create amortisation rows command calculates the amortisation based on the settings in the Items table and generates transaction rows.
  • Amortisation can be calculated monthly, quarterly, half-yearly or annually.
  • Transaction values can be entered and edited manually. You can thus easily resolve any exception or special case.
  • You can enter transactions for increases in value, special amortisation, tax value adjustments or other.
• Amortisation operations are resumed in the accounting file via the Import into accounting command.

Each item has different values

In contrast to accounting, where only the current book value is generally kept, different values are kept for each item in the Fixed assets register.

• Start from the initial purchase value, which is entered manually in the items table.
• All other values ​​are calculated by the program by adding the variations entered in the transactions table.
• For each type of variation there is a special column In the Transactions table where to enter values.
  • Increases are entered as a positive.
  • The decreases (such as amortisation) are entered as a negative.
• For each value there is the total and the variation in the items table.

This way the program has all the elements to calculate amortisation automatically.

File and data saving

• All your data is saved in a single file, where you can easily retrieve everything without wasting time.
• Give the file the name you want.
• You can manage an unlimited number of files.
• Save data on any media, computer, network, cloud or send it by email. You can access it from wherever you are.
• Simultaneous access by multiple users, where, however, only one person can open the file to be edited.
• Make your accounting more secure by inserting password protection.

Item handling

• In the columns you can see the amounts in the format used by your computer, without having to get used to other formats that are not familiar to you.
• You choose the identifier of the article freely (numeric or alpha-numeric account, up to 256 characters).
• Balance, item movement and totals displayed at the same time and always updated.
• Add more columns for notes, grouping or other.
• In the Links column you can add a digital link for the registered item (receipt, purchase invoice, warranty).
• In all tables you have predefined columns that you can make visible by choice.
• The Search command allows you to quickly search for an item.
• You can sort the rows according to different sorting keys.
• Export to pdf for data storage and export to other formats for data re-processing.
• Importing data from other programs in Text, Ascii and CSV format, with the following options:
  • Import data from the clipboard.
  • Auto completion of values.
  • Column header.
  • Unicode (Utf-8).
• Columns for the archive of products no longer available.

Error reporting and control

• Command to check accounting.
  The accounting is recalculated instantly as if all the operations were entered again.
• Reporting of any wrong settings, differences or errors.
• Each report is linked to a help page that explains the causes and the solution.
• Possibility to correct.

Reports and prints

• Table content completely printable or can be printed by selection only.
• Add your own logo for customization of documents and prints.
• Customizable column arrangement.
• Accounting transactions report
• Journal view (Items cards).

Data export and archiving

• Copy and paste directly to and from Excel.
• Export tables to pdf and various other formats.
• Archiving of printouts and data to pdf or other formats.
• Extensions for creating Standard Audit Files.
• Saving of the accounting file on any medium.

Other features

Added functionalities.

• Removal of features you no longer need.

Extensions

• Predefined extensions for various printing and other features.
• Quick search and installation.
• Customizable extensions.
• Automatic update.
• Possibility to create and install your own local extensions.

Comprehensive documentation

• Each dialog and error has its own documentation page accessible in one click.
• Constantly updated documentation.
• Questions and answers.
• Documentation also available in PDF format.

The fixed assets register is an application included in Banana Accounting Plus. It allows easy management of your amortisable assets and quickly obtains all the values you need, as well as the automatic posting of amortisation at the end of the year.

Criar um novo arquivo

Menu Arquivo, comando Novo, escolha o tipo Registo dos ativos fixos.

Configure a tabela Artigos

Na tabela Artigos configure o elenco de bens e os grupos a que pertecem.

Insira linhas ou crie linhas de depreciação automaticamente

Na tabela Lançamentos insira os registos relativos à variação dos valores dos bens.

Com o comando Criar linhas de depreciação, o programa cria as linhas de depreciação para cada bem, em base aos parâmetros específicados.

Recupere as depreciações em Contabilidade

Com a Impressão de lançamentos contábeis pode ver quais são os valores que serão importantes.

As depreciações podem ser recuperadas em contabilidade:

• Com o comando Importa em Contabilidade → Movimentos (do menu Conta1).
• Recuperando-os manualmente da impressão, isto se se usa um outro programa de contabilidade.

Fixed assets are entered in the Items table, together with their corresponding groups, the parameters for calculating amortisation and other information.

Creation of the assets list

When you buy an asset, you must register the purchase in your accounting file and, at the same time, insert a new row in the Items table with information about the new asset.

• Each item must have an Id identifying it and a description.
• The purchase date, the purchase value, the Amortisation type and the amortisation percentage are then indicated.

Groups

To total the amounts for each article category, a totalisation group is created in the Group column.The group code must be assigned to each article in the same category in the Sum in column.
Multiple group levels can be created.
For more information on the grouping system, please refer to the Grouping System page

It may be useful to create groups to correspond to the accounting accounts. If in accounting there is an "Equipment" account, it is useful to have the Equipment group in the items table. For easier checking, the accounting account number can be indicated as the group number. At the end of the year, you will need to check that the value of the Equipment Group is equal to the balance of the Equipment account.

Groups are equally useful for not having to specify parameters for each individual element. If the parameters (account, counterpart, type and percentage of depreciation, etc.) are not specified at the item level for the calculation of depreciation, the parameters of the sub-group or group are used.

Preset columns

This table contains the following columns; The ones marked with an asterisk (*) are protected and calculated by the program.
You can find more information about adding new columns in the Colums setup page.

• Identifiers, descriptions and groupings
  • Group
    If a value is present it means that the row is a group.
    Items and groups values are added up in this row.
  • Id
    The Item Id.
  • Description
    The item description.
  • In Group
    The group the row belongs to. This must be a value present in the Group column.
  • Account
    The account to which the item is being attributed in the accounting.
    This account can also be a group.
  • Counterpart
    The account on which to post the depreciation.
    The counterpart can also be indicated at group level.
  • DateBegin 
    The item purchase date (or at which the item was entered in the accounting file)
  • DocumentDate
    The date of the item purchase document, if available.
• Value/Amounts
  • Initial amount
    Purchase value.
    Once entered it should not be changed. Any changes should be made via transactions for the change in purchase or historical value.
  • Values calculated by the program
    • Purchase variation *.
      The positive or negative value of the total purchase indicated in the transactions.
    • Purchase Value *
      The initial value plus the purchase variation.
    • Historical Variation*
      The positive or negative value of the historical variation (revaluations or write-downs) indicated in the transactions.
    • Historical Value*
      The purchase value plus historical variation.
    • Accounting variation*
      The positive or negative value of the accounting variation (depreciation or amortisation reversals) indicated in the transactions.
    • Accounting value*
      And the historical value plus the accounting changes.
    • Fiscal Variation *
      The positive or negative value of the fiscal value adjustments indicated in the transactions.
    • Fiscal Value *
      The carrying amount plus fiscal adjustments.
  • Residual value
    Any residual minimum value to be indicated.
    If the residual value is equal to or greater than the book value, no more amortisation rows are generated.
  • Estimate value
    An estimated value of the item.
  • ValueMarket
    Eventual market value.
• Amortisation parameters
  • Amortisation Type
    The amortisation type applied to this item
    The amortisation type can also be indicated for the group.
  • Amortisation Percentage
    The amortisation percentage.
    The amortisation percentage can also be indicated for the group.
  • Amortisation amount
    A possible amortisation amount if the amortisation is not specified as a percentage.
    The amortisation type must be 2.
  • Amortisation Percentage 2
    The additional amortisation percentage to be applied to this item.
    The "Create amortisation rows" command creates an extra amortisation row, the calculation method is the same.
    The extra amortisation percentage can also be indicated for a group.
  • Amortisation Months First Year
    The number of months the item needs to be amortised in the first year.
• Additional information
  • Serial Number
    The item's serial number
  • Warranty Date
    The warranty expiration date.
  • Insurance Value
    The value this item or group is insured for.
  • Insurance name
    The insurance company's name.
  • Insurance number
    The insurance policy number.
  • Insurance expiration
    The insurance policy's expiry date.
  • Insurance cancellation
    The date by which legal notice needs to be given to the insurance company if automatic renewal is not desired.
• Archiving information
  • Archiving date
    A date indicates that the item should be archived.
  • Archiving Notes
    They are used when the object is to be archived.

Adding new columns

If you need more information, you can add additional  columns with the Columns setup command.

Amortisation in the year of purchase of the asset

There are an infinite number of methods for establishing how the amortisation value for the first year is to be calculated.
The program offers these possibilities:

• It normally calculates amortisation for the whole year.
• In the Amortisation month first year (Month 1.Year) column , you can indicate for how many months the amortisation is to be calculated.
  • If in the first year you desire to calculate only 50% of the normal amortisation, you should indicate 6 months.
• Amortisation percentage 2 Column
  Used for an extra amortisation. An extra amortisation row is being created.
• For other situations, let the program create the amortisation row and then adjust the automatically created amortisation transaction.

The Transactions table of the Fixed assets register, contains the operations that modify the historical, accounting or fiscal value of an asset.
Via the Create amortisation row command (from the Actions menu) the program will calculate the amortisation based on the parameters set and creates the transaction rows.

Or you may create entries for amortisation, write-downs, revaluations.

Transactions table Amortisation columns

This is the table where you enter the items variations. It has several columns:

• Date
  The transaction date
• Transaction Type Id
  The transactions type, identical to the one in the Transaction table.
• Transaction Type Description*
  The description from the Items table is displayed.
• Item Id
  The Item Id.
• Items Description*
  The items description from the Items table is displayed.
• Notes
  An additional note concerning the transaction.
• Purchase Variation
  The item (+/-) variation compared to the purchase or sale.
• Historical Variation
  The Item (+/-) variation compared to a item revaluation or write-down.
• Book Variation
  The item (+/-) variation value compared to the book variation.
  This is particularly used for negative amortization
• Fiscal Variation
  This is the fiscal variation amount.
• Amortisation Type Id
  The amortization type code as shown in the Items table.
• Amortisation Type Description
  The amortization code descriptions as per the Items table.
• Amortisation Percentage
  The amortization percentage applied.
• Account
  The Assets account where the operation must be registered
• Contra Account
  Contra account (for example the amortization account) where the operation must be registered.
• Archive Date and Archive notes
  Columns you might use if you need to archive the item.

This table shows the amortisation codes.
Therse are predefined codes that must not be changed.​​​

Columns

• Id
  The amortisation code.
  These codes are fixed and must not be modified.
  If you change the Id number the program will not operate correctly anymore.
  • 00 No amortisation. No amortisation will be created.
  • 01 Full amortisation at once of the item. The item is amortised all at once.
  • 02 Specified amount. The amortisation is calculated, based on the entered amount.
  • 10 On the historical value. The amortisation is calculated as a percentage of the historical value.
  • 11 On the book value. The amortisation is calculated on the book value.
• Description
  The code explanation

In the Transaction Type table there are values that define the type of operation.
The most used type is the "35 Depreciation".
Transactions types must not need to be changed.

Column

• Id
  The transaction type code
  These codes are fixed and must not be modified.
  If you change the Id number the program will not operate correctly anymore.
  • 01    Initial value. Used to enter an initial value, instead of entering the initial value in the Items table
  • 11    Purchase or production
  • 15    Sale or value reduction.
  • 21    Revaluation
  • 25    Devaluation
  • 31    Inverse amortization
  • 35    Amortisation
  • 36    Supplementary amortization
  • 41    Fiscal value increase
  • 45    Fiscal value reduction
• Description
  The code explanation

When a depreciable asset is purchased during the year, it is necessary to set the number of months over which the depreciation should be calculated.

Proceed as follows:

• In the Items table, go to the Amortisation view, column Month 1.Year
  The column can also be activated and then displayed in the Base view from the menu Data > Columns setup ( AmortisationMonthFirstYear).
• In the row where the vehicle purchase is recorded, enter the number of months over which depreciation should be calculated in the Month 1 Year column.

On 31.12, when amortisation is calculated, all depreciable assets that have a value in the Month 1 Year column will be depreciated not for the entire year, but only for the number of months specified in the column.

In order to create the amortisation rows click on Actions menu → Create amortisation rows command.

Indicate:

• The date for the calculation of the amortisation.
• The period of the amortisation calculation (monthly, quarterly, half-yearly or annual).

The program creates the amortisation rows based on the parameters of the items indicated in the Items table.

• If the parameters Amrt. Type, Percentage, Account or Contra account are not entered for a single item, the software will use the group parameters of which the item is a part to create the amortisation transactions.
• If the number of months has been set for the item in the Month 1st Year column, the calculation for the first year is done on a pro-rata basis.
• The amount of depreciation is reduced to ensure that the book value does not go negative or is not less than the Residual value.
• Automatically calculated record values can be adjusted manually.
• Value adjustment records, such as devaluations or revaluations, must be entered manually.

Change the automatically calculated values

The rows that the program has created can be modified or deleted. This flexibility is very useful, as there are situations in which the automatically calculated value needs to be adjusted. This way, it is possible to cover all requirements and unexpected events.

In those cases, the amortisation value will be calculated manually and entered instead of the automatic value, such as:

• First amortisation, calculated according to different methods.
• Rounding adjustments.
• Final amortisation adjustment, to ensure that the amortisation is entire.
• Amortise to maintain an accurate final value.
• Additional amortisation, in this case it is useful to create a new transaction row.

It is also possible to insert transactions that modify the other values.

Change in the type of amortisation

Amortisation is recorded in the Transactions table, so changes in the Items table have no impact on past amortisation.

You can change the amortisation type and percentage by simply changing the relative values for an item or group in the Items table. The next time the new amortisation rows are created, the new parameters will be used.

If necessary, there are two options to adjust the book value:

• Add a new transaction with the adjustment amounts.
• Change the transaction created automatically.

When a depreciable asset is disposed of, certain steps must be followed in accounting to zero out its value both in the Fixed Asset Register and in the Balance Sheet, recording any capital gains or capital losses.

To reverse the value in the Fixed Asset Register

Before proceeding to zero the value in the Fixed Asset Register, the following elements should be considered:

• Disposal date to calculate the periodic depreciation amount (from the beginning of the year up to the date of disposal or sale)
• Residual book value
• Sale value
• The difference between the residual book value and the sale value may result in a capital loss or capital gain.

Below is an example of a vehicle disposal on 31.03.2025, with the following elements:

• Disposal date: 31.03.2025
• Residual book value: 12,000.-
• Sale value: 10,000
• Capital loss: 2,000 (12'000 - 2'000).

 In the Fixed Asset Register application on 31.03.2025, record:

• The depreciation amount up to 31.03.2025 for the asset being disposed of.
  • Enter the date, select "35" in the Type column,
  • Enter the asset number in the Items Id column
  • Enter the description "first quarter depreciation" in the Notes column
  • Enter the depreciation amount for the first quarter in the +/- Book Value column
• The disposal or sale on 31.03.2025
  • Enter the date, select "15" in the Type column
  • Enter the asset number in the Items column
  • Enter the description "disposal or sale" in the Notes column
  • Enter the residual book value in the +/- Book Value column
• The capital loss (or capital gain, as the case may be) on 31.03.2025
  • Enter the date, select "25" in the Type column,
  • Enter the asset number in the Items column
  • Enter the description "capital loss" in the Notes column
  • Enter the difference between the book value and the sale value in the +/- Book Value column

Recording the disposal in the accounting file

When an asset is disposed of in the accounting file, its book value must be removed from the Balance Sheet.

• If there is an accumulated depreciation account related to the asset:
• Reverse the accumulated depreciation up to that point with the asset account
• Reverse the residual book value of the asset
• Recognize the capital gain or capital loss

The main view of the Transactions table displays the change in book value. The full view shows all other available columns, so as to make the change of the other values possible.

Transactions to change of Purchase, Historical or Fiscal value

You can enter transactions that modify the purchase, historical or fiscal value by using the appropriate columns.

• Then add a new row and manually enter the values.
• The amount must be entered manually by the user.
• Use the appropriate Transaction type for the transaction.
• If it is a amortisation, use the Amortisation type code.
• Amount variation columns:
  • +/- Purchase
    • Positive amount for new purchases (Transaction type 11).
    • Negative amount for partial or total sales (Transaction Type 15).
  • +/- Historical
    • Positive amount for revaluations (Transaction type 21).
    • Negative amount for partial or total write-downs (Transaction Type Id 25).
  • +/- Tax
    • Positive amount for the increase in the tax value (Transaction type 41).
    • Negative amount for the reduction of the tax value (Transaction Type Id 45).

Modification of the Initial Value

The initial value in the item table should not be altered. If adjustments are required, postings must be entered that modify either:

• the Purchase value.
• or the Historical value (devaluations or revaluations).

Internal value different to the accounting one

There may be situations where the market value of the asset is higher than the book value, so there will be an internal hidden reserve.

To keep track of these differences you can proceed in two ways:

• In the Items table, display MarketValue column and enter the value.
  With this system, you will always have to update the value each time it changes as a result of actual amortisation.
• Use the FiscalValue column as internal value.
  The assumption is that the tax value column is not already used and therefore that the tax value is equal to the book value.
  • In the Items and Transactions table, replace the column headings, use "Internal Value" instead of "Fiscal Value" and "+/- Internal" instead of "+/- Fiscal".
  • Descriptions of codes 41 and 45 will change in the Transaction type table.
  • Insert the transaction rows with the transaction type 41 and 45 and indicate the difference in positive in the "+/- Internal" column .

Modify Residual Value

When the Create Amortisation Transactions command is used, each item is amortised based on the residual value. For this reason, when an item reaches the end of its useful life, it is recommended to manually record the amortisation. If the entry is not manually adjusted, a value will be carried forward for the item in the next year.

The residual value of items can be viewed in the Items table, in the Book Value column.

How to proceed:

• Take note of the residual value of each item that has reached the end of its useful life.
• In the Transactions table, enter:
  • In the Date column, the amortisation date
  • In the Type column, the number 35 (amortisation)
  • In the Item ID column, the ID code defined in the Items table
  • In the +/- Book Value column, the amount of the residual value to be amortised.

Once the amortisation transactions for the residual values are made, in the Items table, the amortised items will show a value of zero for their residual value.

At the end of the year, the amortisation entries can be automatically imported into the accounting file. Proceed as follows:

• Via the Actions → Import into Accounting → Movements
• Choose Fixed Assets register as file
• Using the Browse button, search for and select the Fixed Assets register file.

Only the rows of the Journal that fall within the accounting period are included.
You can then choose to import only certain data.

As per version 9.04 of Banana Accounting it is possible to group amortisation transactions by account.

The Address Book and Addresses application are included in Banana Accounting Plus. It is ideal for quickly and easily setting up the addresses of your customers, suppliers, partners, family members and instantly access the contacts you need or to print the address lists for labels.

Multiple functions to speed up and make management easy:

• Predefined columns for each type of content.
• Addition of additional user defined columns by the .
• Customizable column positioning.
• Customizable label format setting.
• Ability to print only the selected rows.
• Free setting of the label format.
• Copy / paste addresses from other programs (Excel and Word).
• Ability to color the row to instantly identify the most important contacts.

Based on spreadsheets like Excel

Address management is based on pre-defined columns that can be customized as positioning and as header. The columns are grouped into three main tables:

• Groups Table
  In this table the address groups are set. Each group is identified by an Id which is used to categorize the addresses. Groups can be created for suppliers, customers, partners, family members, friends. This makes searching easier and allows you to set labels even with group selection.
• Contacts Table
  The contacts are entered in this table, with all the relevant information.As in any other table, additional columns for notes or other can be added.Contacts can be updated and synchronized with Google contacts.
• Diary Table
  This table is intended to enter day by day all the annotations relating to the people contacted.

Accounting setup

Address Book headers and basic data set up in a single, easy-to-view dialog.

• Company headings and address with free texts.
• Language settings.
• Link to extensions for customizations.
• Password to secure your Depreciation Register file.
• You can have multiple files in different languages.

File and data saving

• All your data is saved in a single file, where you can easily find everything without wasting time.
• Give the file the name you want.
• You can manage an unlimited number of files.
• Save data on any media, computer, network, cloud or send it by email. You can access it from wherever you are.
• Simultaneous access by multiple users, where, however, only one person can open the file to be edited.
• Make your accounting more secure by inserting password protection.
• In the Links column you can add a digital link for the registered item (receipt, purchase invoice, warranty).
• In all tables you have predefined columns that you can make visible by choice.
• The Search command allows you to quickly search for an item.
• You can sort the rows according to different sorting keys.
• Export to pdf for data storage and export to other formats for data re-processing.
• Importing data from other programs in Text, Ascii and CSV format, with the following options:
  • Import data from the clipboard.
  • Auto completion of values.
  • Column header.
  • Unicode (Utf-8).
• Columns for the archive of products no longer available.

Error reporting and control

• Command to check accounting.
• Reporting of any wrong settings, differences or errors.
• Each report is linked to a help page that explains the causes and the solution.
• Possibility to correct.

Reports and printouts

• Table content completely printable or can be printed by selection only.
• Customizable column arrangement.
• Print labels (from the Extensions menu).

Data export and archiving

• Copy and paste directly to and from Excel.
• Export tables to pdf and various other formats.
• Archiving of printouts and data to pdf or other formats.
• Saving of the accounting file on any medium.

Other features

Added functionalities

• Add new functionalities.
• Removal of features you no longer need.

Extensions

• Predefined extensions for various printing and other features.
• Quick search and installation.
• Customizable extensions.
• Automatic update.
• Ability to create and install your own local extensions.

Comprehensive documentation

• Each dialog and error has its own documentation page accessible in one click.
• Constantly updated documentation.
• Questions and answers.
• Documentation also available in PDF format.

​In the Groups table, one can define an identification code for a Group and enter the corresponding description in the Description column (es. CLI - Clients, SUP - Suppliers, COL - Colleagues, etc.) for each row, in the Id column.

The Contacts table presents the columns where the addresses can be entered.

​The columns

There are different columns. The biggest part of the columns is invisible. The Colums setup command has to be used in order to:

• Display the columns
• Change the order of the displayed columns
• Add other columns
   

• Id is the contact number.
  This is needed when you want to connect a contact to the diary, to the loans or to another table.
  While being on that column and pressing F6, there is an automatic progressive numbering.
• Prefix: you can enter "Mr", "Mrs", etc.
• Family or Company name (if it concerns a company).
  If the contact is a contact person for a company, you can enter the company or entity to which the contact belongs in the Organisation column.
  When pressing F6 on the Name or Family Name column, the program separates or inverts the name and last name.
  If there are more than two names, this feature is not able to distinguish which one are the names or family (last) names.
• LetterStart: is the greeting that is being used at the beginning of a letter. This is being used for a mail merge.
  For example: Dear John or Dear Mr Smith.
  The program suggests possible texts according to the contents that have already been entered into the columns.

Import new Contacts

It is possible to import new contacts also from external sources and it can be done in several ways:

• Importing from Excel or other text programs
• Via the Import rows command.
• Synchronize with Google contacts 

The views

There are different views available and each view distinguishes itself from another one through the presence of specific columns; in this example (Address Book file), we have the Base, Name, Address2, Archive and Complete views. In the Complete view, all the columns are visible.

​ ​

In the Diary table, you can record all kind of notes, day after day and referring to the entered contacts.

Deprecated commands and functionalities

Attention: Google has deprecated the Contacts API used by Banana to access and modify contact data.
The new People API replacement has different purposes and functionalities.
The reading and modification of Google contacts will therefore be available ONLY UNTIL Google keeps the Contacts API in service. After that the synchronization commands will give an error. The data saved in the AC2 file will still be accessible. It is not known how long the Contacts API will still be available. Please do not use these features anymore.

Documentation

Download, view and edit your Google / Android address book contacts in a tabular format. You can update and clean contacts much faster and also print, copy and paste them into Excel.  You can also save the contacts file to your computer as a backup copy.

Manage Google contacts

1.     File->New command creates a New Empty Address Book.
2.     Menu->Actions->Google Contacts->Download Changes.
   • You will be asked to authorize access to the contacts.
   • The Contacts table will be filled with your contacts.
3. Edit and update the contacts as you like.
   • Menu->Data->Column Setup let you also make visible all predefined  columns, like Organization Name, Organization Title.
4. Menu->Actions->Google Contacts->Send Changes.
   The local changes will be saved in Google.

For more information see the explanations below.

Authorize access to your contacts

Synchronizes the contents of your Banana file of the Address Book and Addresses type with the contacts of your Google account.

The first time you issue the command Download and replace existing contacts from the Actions-> Google Contacts menu, to connect to your Google contacts:

• A window appears that displays a page of the Chrome browser integrated in Banana and asks you for your Google login.
• You have to enter the email address and password of your Google account.

Banana only saves the email of your Google account: the session data and the password are not saved in Banana, but are managed by the mechanism of your browser.

Immediately afterwards you must confirm that the Banana software can access and modify your contacts.

Synchronization commands

Download changes

This function imports data from Google and updates the values in Banana.

• If there is already data existing in the table, the program will merge the various data in the tables
  • Groups.
  • Contacts.

Send changes

Send modified data in Banana to Google, updating your Google contacts.

• To be able to send data to Google, you must have previously downloaded it at least once.
  If you have made changes on your mobile, you have will have to first download the data and then activate the command Send Changes.

A window with the elements modified, added or deleted will display.

It is not recommended to use the "GoogleNoSynchronize" column because it will no longer be used in subsequent versions. If Yes, the contact will not be synchronized with Google.

Download and Replace existing contacts

Banana will not always be able to synchronize all changes.
This command will delete the contacts in the Contacts table and replace them with the existing Google contacts.

This command will also delete items marked as "GoogleNoSynchronize"

Conversion of values in the table

Google contacts manages addresses, phone numbers and e-mail in a structured form. In the Contact stable, the data are instead managed via the column.

Telephone numbers and e-mails

Google allows you to define different e-mails and phone numbers. For each one a label and an indication by default is designed.
In Banana you must follow these directions:

• If there are different types of telephone or e-mail, you will indicate them in the appropriate column (work, home, other).
• If for each type there are several telephone numbers or e-mails, indicate them in the column, separated by a semicolon ";".
  Telephone work "+1234567890;+21234567890". E-mail work "example@gmail.com;example@yahoo.com"
• If the phone number or e-mail has a particular label, it will be indicated in the Other column, with the label followed by a colon ":".
  If there are several numbers, separate them with a semicolon ";"
  "Holidays:+1234567890*;Cousin:+1234566777". "Temporary:example@gmail.com;Mama:example@yahoo.com"
• To indicate that the phone is a number by default, mark it with an asterisk "*" after the number.Between the different numbers there can be only one default number.

Addresses

Google allows you to have multiple addresses for the same contact.

Banana Accounting instead allows to synchronize only one address, the "Home" being main one.

Groups

Groups defined in Google are imported into the Groups table and new ones can be added as well.

In the Group Id column of the Contacts table you can insert multiple membership groups by separating them with a semicolon ";".

Create a backup of your Google contacts

1. Create a New empty Address Book file.
2. Utilities1 Menu  -> Google contacts -> Download changes.
3. Save the file on your computer with the day's date in the name.

Manage your Google address contacts

If you have multiple addresses in your address book, it will be easier to use the Banana address book to sort out your addresses. You can quickly correct errors, add information and remove duplicates and much more.

1. Download data from Google contacts
2. Effectuate your changes
   Remember that the F6 key (Mac Cmd-6) has several features (see the Info window below).
   In the Name and Surname column, invert the values.
3. Hit the Send changes command button to send the changes to Google.

Archive and remove contacts that are no longer used 

You can save phone contacts that you no longer use on your computer and delete them from your phonebook.

First time:

1. Create a new Address Book file.
2. Utilities1 Menu-> Google Contacts-> Download Changes.
3. Save the file in your documents, "Folder_Philip_donotcancel_ever", so you remember that it is an important file.
4. Display the Archive view in the Contacts table
5. In the Archive date column, insert the current date (type the dot ".") for all contacts you no longer require
6. Utilities1 Menu -> Archive data -> Archive Table data -> Contacts.
7. Utilities1 Menu-> Google Contacts -> Send Changes.
   Your data will be deleted from the address book.
8. Utilities1-> Archive data -> View Archived data-> Contacts will allow you to access your archived contacts.
   If you want to add them back to your directory, you must copy the line in the Contacts table and delete it from the Archives.

Safe-keep your file. Proceed as follows if you wish to archive unused contacts:

1. Open your Address book file.
2. Utilities1 Menu -> Google contacts -> Download changes or if there are problems Download and replace existing contacts
3. Proceed as indicated above in the Archiving and Sending Changes procedure.
4. Save the changes.

Resume data in Excel

• Download data from Google contacts.
• Select all (upper left corner button)
• Copy
• Paste into Excel.

Synchronization problems and suggestions

The Google address book offers many possibilities and can be used in very different ways. We have tried to make it work better for you , but there may be situations where the program might experience problems with the changes that have been made.
If this is the case, it will be necessary to use the command function. Download and delete existing contacts, to completely realign the two archives.

We are obviously interested in continuously improving the functioning of our software, so send us an e-mail describing the problem and show us how to replicate the problem on our computers. This will allow us to fix the problem.
Any suggestions on how to improve the product are always welcome.

For technical details related to the connection, check the Google API documentation.

• https://developers.google.com/google-apps/contacts/v3/
• https://developers.google.com/gdata/docs/2.0/elements#gdReference

The Address Book application allows you to create and print addresses on labels. Printing can be customized and adapted for various needs.

Printing labels is very simple: Menu Extensions → Print Labels. At the following links you can find detailed information about the various dialogs for printing and the format of the labels:

• Print label
• Labels format
• Print library labels

Library and collections is included in the Banana Accounting Plus version. It is the easy and innovative solution to organize books, loans, contacts and collections and, have all the lists instantly available for effective control. You can monitor loans, expiration dates and return dates or simply to put in place perfect order in your home library.

Multiple functions for a digitized and efficient organization:

• Fast data entry.
• Categorization by user groups.
• Retrieve book details from Google with ISBN.
• Copy and paste book list from Excel.
• Quick searches by title, author, keywords, user or user group.
• Internal planning with the Diary (library shifts, annotations or new orders to be made).
• Loan management.

Other useful commands

• How to register the return of items

• How to archive table data

Crea un nuovo file

È generalmente più semplice iniziare da un modello preimpostato, piuttosto che uno nuovo vuoto.

Pertanto consigliamo di procedere nel seguente modo:

• Menu File → Nuovo→ Biblioteca e collezioni. Scegli il modello che trovi a disposizione e personalizza i conti e i gruppi, secondo le proprie necessità.
• Scarica direttamente il nostro modello dalla pagina seguente: Biblioteca, collezione di libri e gestione prestiti e aprilo col Banana.

Imposta i dati base

Nel menu File → Proprietà file (Dati base) imposta i dati della tua Biblioteca.

Imposta i dati nelle tabelle

• Tabella Gruppi
• Tabella Contatti
• Tabella Articoli
• Tabella Prestiti
• Tabella Diario

Report e Stampe

Scarica l'estensione Report libri biblioteca per ottenere le stampe dei dati e salvarli in *.pdf.

Groups according to which you wish to divide the users are defined in the Groups table. To identify a group, enter an identification code Id (column Id). In the Description column you enter a text describing the group.

For a detailed explanation of the columns in the Groups table, please consult the Address Book page.

You can to enter user data in the Contacts table, divided into several customizable columns (you can make visible only the ones you need and hide all others - you can also add new ones).

For a detailed explanation of the columns, please consult  the Address Book page.

In this table you can enter your items data: they can refer to valuables, books or other.
There are different ways of entering the items data: copy and paste from Excel, automatic data retrieving from the Internet, etc.
See detailed explanations below.

Columns

There are various columns and it is also possible to add new ones.

• Id: the item number that has to be attributed.
  The F6 key assigns the number progressively.
  It is also possible to use a prefix. For example: A-001,  after that, the program suggests A-002.
• ISBN
  The International Standard Book Number.
  When entering the ISBN in the Id column and pressing the F6 key (⌘+6 on Mac), the program automatically completes all the book's data in the other columns, incorporating them from the Google database, provided there is an internet connection available.
  Any already present information will be overwritten.
  For more information see: Google documentation.
  • The data in the Google database are not always complete. For example, the title might be present, but the editor or other data might be missing.
  • In order to know which data are available on Google, please visit the following page:
    https://www.googleapis.com/books/v1/volumes?q=9781906042509, entering after q= the book's ISBN number.
    If you see "totalItems: 0" it means that the book is NOT in Google's database
    If you see a page in a JSon format (programmers format) with the book's data, it means that the book IS in Google's database.
• Title
  Is the title of the work.
• Author
  There can be several authors entered, separating them with semicolon ";".
• Publisher
  There can be several editors entered, separating them with semicolon ";".
• Return date
  The projected return date for this item.
  This column is automatically completed according to the checked out item.

Entering books data

Book data can be entered in different ways:

• Manual insertion - You can manually enter the books data in the Items table (see previous paragraph)
• Retrieve data from Excel - If you already have a list of books from another program or Excel, you can simply copy/paste the data.
  In order to copy / paste the data you need to make sure the columns in Excel as arranged in the same order as in Banana. If the column order is the same in both programs you can copy the data in block, otherwise you need to proceed column by column. The copy/paste operation is possible from Excel or from txt files. 
• Retrieve book data automatically from the internet - The ISBN column is very useful if you have an Internet connection: each book has an ISBN code (internationally recognized and generally written on the back of the cover); If you enter a book's ISBN code on the appropriate column in Banana and press the F6 key (or Cmd + 6 for Mac), the program automatically retrieves the books data from the Internet and inserts all data (title, author, publisher, etc. even a small summary).
• If the book has different authors or publishers, just separate the names with a semi-comma ";" - they will also be found individually in searches (for example if you need to find all the books of a certain author).

In the Loans table you can enter the checked out items, the expiration date and the return date.

Columns

• Date
  The date of the loan.
• ItemId
  The item number. A search can be made based upon the title.
• ContactId
  The contact number. A search can also be made based upon the name, family name, place.
• Expiration date
  The projected date for the item's return.
  If you enter "+30", the program proposes the date that comes 30 days later.
• Return date
  Enter the return date.
   

How to manage the loans 

Loan of a book

• Enter the date. If you click ".", the date of the day is automatically written.
• In the Item Id column, as you start typing the title of the book or library user, the program will display all choices available in your database; just select the right option and press the F6 key: the program will automatically fill the Item Id and Description cells.
• In the Expiration column (date of return for the book) the program automatically uses a date 30 days after your current date, but you can manually change that: you can enter the number of actual days (for example +40) to generate the correct return date (40 days later).

In this table you can enter daily annotations and link them to a specific contact.
For example, you can enter the working shifts of librarians, or add relevant notes or facts, to-do lists, etc.
For each annotation you can enter the date, description, an expiration date and associate a user code.

How to register a book return:

To indicate that a book has been returned, simply enter the date the book was returned in the Return column of the Loans table.

If you have a lot of books on loan, the Items return dialogue lists the books on loan, allows you to search for them and indicate with a check that they have been returned.
Here is how to proceed:

• From the Actions menu, choose Items return;
• This will open a window where you type the name of the library user. This will display all books on loan to this library user.
  • You can now check all returned books
  • Click the Apply button and the program will automatically insert the actual date in the Return date column of the Loans table.
  • In case of error, return to the Loans table and click the Undo command.

How to archive data

The Archive feature avoids the adding up of too many transactions of lent and returned books. Outdated data are being archived in hidden tabs without being deleted. This data can be recalled at any time for statistics or any other use.

Store data of returned books

• Choose Archive data from the Actions menu and then Archive table data → Loans. The program will delete all transactions of already returned books from the Loans table and store them in the Archive table.
• Only books on loan that are not yet returned will be shown in the Loans table.

Store contact information no longer used

As for your books, you can equally archive your old and unused contacts

• Indicate a storage date for all the contacts you wish to archive.
• Choose the Archive data from the Reports menu and then Archive table data and Contacts.

Archive data for Estimates and Invoices application

To archive data for the Estimates and Invoices application, please refer to the Archiving Invoices page.

You can print two different types of labels:

• Small labels (containing the book code) for use on the spine of the book, so that they are visible on the bookshelves
• Larger labels are used on the inside of the cover, mentioning that the book belongs to the library and has to be returned at a specified date

Labels can be printed either on the basis of the Banana file, where you have registered all the books in the library, or from an empty file in case you wish to print a list with codes, that you will then assign to the books.

Creating a file to print library labels

Via the File menu -> New... in the Filter by box : enter the the text "library" and select the Banana Library - printing book labels template (also make sure you have selected English as search language).
You can also find the template directly at this link: Banana Library - printing book labels

Printing labels for the spine of the book

In order to print the labels, you can open a new blank file in Banana, containing no data (File menu -> New), but, as stated, you may wish to start from an existing, as explained earlier.

There is a useful Excel function to generate a large amount of codes in a speedy manner, rather than entering them manually or than using  F6 key. Here is how you do it:

• Open a new Excel file; in cell A1 entere the library code that suited your purpose (any combination of letters followed by numbers will do) - for example B1000.
• Choose the bottom right angle of your cell with your mouse (the point will now be a cross), and, while holding down the right click, drag down along the column; Excel will automatically generate autoprogressive numbers.

• Now copy (Ctrl + C keys) the codes that have been generated into Banana's Items table, in the Id column (Ctrl + V keys).

• You can now create the label. Choose the Labels -> Print command from the Extensions menu. This window will be shown:

• It is important to have the Items table selected as the source for Data
• Now you can define your label by pressing the  Extensions menu -> Labels -> format command.

I

•  In the window now shown, enter the margins and other characteristics of your chosen label, Herma 10001 in this case.

• Before hitting the OK key, open the Customization tab, where you can assign a name to your custom settings (so they can be used in the future). In this case it's Book codes (Spine).
• Hit the OK key

• In the Label section select RowId to indicate the contents of the label (in the example you indicate the book code) and press the Add field button. The RowId appears in the View Labels field.
• Pressing the OK button will generate a preview of your label.

You may now print using your Herma sheets. 
 

Printing labels for the inside cover

Choose your label format. In the example a 70x36mm (Herma 4630 or Avery 3490) format hase been chosen. The steps to follow are identical to the previous example::

• First, choose the Labels -> Print command from the Extensions menu
• Enter the margins for your new label in Extensions -> Labels -> format window.
• Before hitting the OK key, open the Customization tab, where you can assign a name for your new custom settings (Inside Cover label, for example), than hit OK.
• Select Label in the Print label section to add the content of your label.

You may enter text, other than the available fields, as well.

Pressing the OK button will generate a preview of your label.

Note:

The template available in Banana already includes the two mentioned label formats: label for the spine of the book and label for the inside of the cover.

Related features:

Management of yearly membership fees

If you run a library requiring an annual membership fee, or if fees are charged for the loan of individual books, it is useful to use the accounting functions of Banana Accounting.
Please check our page Accounting templates.

Requirements

• Internet connection (necessary to create speech files)
• Banana Accounting Dev Channel Version.
• Subscription to the Advanced Plan.
• FFmpeg executables.
• Subscription to a text-to speech service
  • Azure cognitive API
  • Google text-to- speech service.

Setup the environment

In order to use the Educational Video Maker application.

• For Windows
  • Download and Install ffmpeg tools
    • Download ffmpeg tools for Windows
    • Under "Get packages & executable files" select the Window operating system.
    • Download the essential package.
    • Unpack the file to a directory for example C:\ffmpeg
      Under bin you should have the file ffmpeg.exe and fprobe.exe
  • Make sure your antivirus does not block or slow the execution
    • Search and go to  "Virus Thread and Protection"
    • Manage settings
    • Add Remove Exclusions.
    • Add Exclusion
    • Folder
    • Select the ffmpeg/bin directory
  • Install a video player for mp4 files.
    Video are build in mp4 format, the codec is not preinstalled on Window.
    • Install an alternative Video player like VLC video player.
• MacOS setup (Install Ffmpeg tools)
  • Download the ffmpeg and ffprobe binaries
    • Under "Get packages & executable files" select the Mac operating system.
      Download the
    • ffmpeg
    • ffprobe.
    • Unpack the files and copy them to a new directory.
    • Make sure the ffmpeg and ffprobe are executable file type.
      • Go to the "Get packages & executable files" section of the page.
      • Click on macOS icon.
      • Click on "Static builds for macOS 64-bit".
• Setup Banana Accounting.
  • Install and run the dev-channel version.
  • Run the software
  • Make sure you can open MP4 files
    • Menu Tools → Program Settings.
  • Activate the integrated Screen Capture.
    • Windows-Appearance → Show developer Menus.
    • Developer menu → Activate ctrl+3.
  • Set the default language to English.
    • Menu Tools → Program Settings.
    • File Handling → Extensions of files conisdered secure
    • Add mp4 to the list
• Create an empty video project
  • Create a new directory for the video project.
  • Download and the Empty educational video file and copy it to the video project directory.
• Setup the Global settings
  • Important you need to specify the ffmpeg executable.
• Request the authorization at Banana.ch
  Speech generation only work if you have the authorization.

 In this table you enter the data to generate the video.

Columns

• Chapter (Optional)
  • Enter a chapter number or letter, that help you organize the video in group of video clip.
  • Use [] for automatic chapter numbering (progresssive).
  • During build the chapter number is added to the language Text (for display only) if the build option is active.
  • Chapter rows should also contain a Clip file name
• Clip File.
  • The row that contains a Clip File name will be the start of a Video Clip.
  • The Video clip will contains all the rows up to the next row that contains a Clip File name.
  • The image file (png or jpg) or clip (mp4).
    • If you go in change mode you have the list of files available.
    • If you click on the little icon you see the preview and you can change the image.
  • Empty.
    If the clip file is empty, this row will be added to the previous video clip file.
  • Automatic file renumbering
    Use the file in the specified format to renumber file name based on the chapter number.  When you add a new chapter all the existing file with the automatic file format will be renamed.
    • The automatic file name format is in the form of chapternumber-progressive[-freetext].ext.
      The free text is optional.
      Examples:
      • "01-01.png" "101-101.png"
      • "01-01-freetext.png" "101-101-freetext.png"  
• Effects (default is hidden)
  You can attach effects to the image that will be applied when the video is build.
  For the syntax see the Effects page,
• Text Style
  The style to be used for showing the text.
  • Empty.
    Same as Subtitles.
  • None.
    Text is not shown.
  • Any other you define in the Text Style table.
• Speech Style
  • Empty.
    Default speech style.
  • None.
    Text is not translated to speech.
  • Any other speech style you define in the Speech Style Table.
• Start (Time Start)
  The start time the clip, text or speech start to be shown. Relative to the clip file.
  If the time is empty, the start time is calculated based on the speech duration .
• Duration
  The duration of the clip, text or speech. Relative to the clip file.
• Time command.
  • Empty
    The duration is automatically calculated based on the speech duration.
  • Duration Time Command
    If you specify a Duration command the StartTime of the the next row is ignored.
    • DurationAdd (AddTime).
      The entered duration is added to calculated duration.
    • DurationFixed (FixedTime),
      The entered duration is used. If the speech is longer it will be cut.
      Useful for pause.
    • DurationPause
      Same as FixedTime, but with the option to exclude the pause in the build.
    • DurationPause[XX]
      Same as DurationPause, but if the Duration is empty, the duration of the last Duration[XX] is used. 
      You can create different standard pause "DurationPauseChapter", "DurationPauseImage"
      Pause will not be included in build if the option is activated.
    • DurationSpeech.
      The entered duration is used if the calculated speech duration is shorter.
    • DurationMin (MinTime).
      The entered duration is used if the calculated speech duration is shorter.
  • Time Commands for Title, text or effect rows that have no speech and therefore the duration is zero
    In case the rows have the SpeechStyle set to "none" or there is no text and there is no Duration.
    These commands allow display the text for a duration of the speech o clip..
    • SameNextRow (NextRowTime),
      The text will display at the same same start time and end time calculated for the next row.
      Useful in case you need to use for display and speech different texts.
    • SamePreviousRow (PreviousRowTime),
      The text will display at the same same start time and end time calculated for the previous row.
      Useful in case you need to use for display and speech different texts.
    • SameClip (ClipTime).
      The text will display for all the time the clip duration (from begin to end).
    • SameClipEnd (ClipTimeEnd).
      The text will display for up to the end of the clip.
  • Time Command that takes priority over the speech duration
    • SameClipVideo (ClipVideoTime)
      Only for clip files of type video.
      Takes the same duration as the original video clip.
• Text (language)
  The text to be displayed or for speech creation.
  There is one column for each language.
  Use Action->Add Language to add another language.

Structure and logic of a video

These are the basic elements of a FinalVideo.

• Chapter (optional)
  It is used to group together a series of Video Clip that together form a unit, exactly as youtube.com chapters.
  • VideoClip (Clip File)
    Start with a row that contains a file name in the column ClipFile
    It include all rows up to the next row containing a file name in the column ClipFile
    • Non-Video Clip Row
    • Non-Video Clip Row
  • Video Clip
    • Non-Video Clip Row
    • Non-Video Clip Row
• Chapter
  • VideoClip
    • Non-Video Clip Row
    • Non-Video Clip Row

FinalVideo

Is the result of the process of the command Build Video.

• The FinalVideo is the concatenation of the different VideoClips in the same sequence specified in the table Clips.
• The length of the FinalVideo is the sum of the length of the different VideoClips.

VideoClips

Each VideoClip is build separately and once all the VideoClips have been build they are concateneted to form a FinalVideo.

• A VideoClip is based on a ClipFile specified in the column Clip File
• All the rows before a row that contains a ClipFile are used to create the VideoClip.
• The number of Video Clips correspond to the number of Clip Files specified.

A Video clip file and can be of type.

• Image. jpg or png file.
• A video sequence (mp4 o avi file).

Times columns

The times columns (StartTime, Duration and TimeCommand) are used to determine the length of the VideoClip.

• The Time columns are specific to each VideoClip.
  The VideoClips are concatenated to form a FinalVideo, so the next VideoClip will start exactly after previous one.
• The time of a new VideoClip is not influenced by the times value specified before.
• The duration of a VideoClip is the sum of the duration of the different rows that form the VideoClip.

Start and duration of speech rows

The speech rows are rows that have a text and don't have the SpeechStyle to "none".

• SpeechDuration
  The duration of the row is automatically calculated, based on the length of the speech.
• If the speech duration is longer then the duration specified, the SpeechDuration is used.
• If the next row has a StartTime, the Duration will be expanded so that the next row will start of the StartTime specified. 
• CalculatedStartTime of a row is the the sum of the duration of the previous rows of the VideoClip. 
  The CalculatedStartTime has precedence over the specified StartTime.
• You can change the automatic mode with the Duration TimeCommands ( DurationAdd, DurationFixed, DurationMin, DurationSpeech).

Start and duration of Title rows (non speech rows)

In the VideoClip you can have rows that don't have speech:

• When there is no text
• SpeechStyle "none"
  • When the text is a title.
  • When the speech text need to be different than the speech.

In this case you need to synchronize the appearance of the text with the speech. So you can use the Sync Time Commands.

StartTime for Video Clip Files (Video Segments)

For Clip File that contains a video the StartTime is used to specify at what exact point a subtitles, title and speech should appears. But, if you build a Video in another language, the SpeechTime can be larger than the original one. In order not to have the speech to be cut fit the video, the program will have slow down a sequence of the video for the time necessary too fit all the speech. 

• During the build the Video file is cut in different VideoSegments each one corresponding to the specified StartTime.
• Each segment is than processed separately and the duration adapted to the specific content and time. 
  • If the speech duration is longer than the original one, the duration of the segment is expanded (the video will be slowed down).
  • If there are TimeCommand they will be applied to the row and segment.
• The speech and text are added to each segment so that the speech and titles start always at the original point. 

You can control the duration of the different video segments by using the following TimeCommand:

• DurationSpeech.
  Use if you want to make the segment not longer than the speech duration.
  • If the original video segment duration is shorter, the video will be slow down.
  • If the original video segment duration is longer the video will be speed up.
• DurationAdd
  Add a duration to the DurationSpeech and speed-up or slow-down the video segment.
• DurationFixed
  Extend or cut the original segment duration of exactly the specified duration and and speed-up or slow-down the video segment. 
  If there is a speech that it is longer than the specified duration the speech will be cut.
  Use mostly in case for segments that have no speech. 

Calculated columns

With the command Tools>Add/Remove functionalities you can:

• Add Calculated columns
• Remove Calculated columns

The Add Calculated columns are made available for the developer of the application, but may be interesting also for people creating video.
The command will add the following columns:

• Start Clip
  The time when the row will start relative to the Clip.
• Start Clip
  The time when the row will start relative to the complete Video.
• Calculated Duration
  The duration taking in consideration also the Time command.
• C. Speech
  The Duration of the speech in the processed language.
• Calculated Fill
  The time that will be added to arrive at the specified Start time.

The calculated columns will be updated at the end of the build process.
The change will not change the modified flag of the file, so if you want to save the date you have to modify some text.

 Define the text style to be used for displaying text on clips.

• Size and margins are defined in pixels, relative to an image size of 1920x1080.
• Colors you can use a name (red, blue, etc) or a symbol.

Use different colors for subtitles

Define the styles for any subtitle type you want to use.

Start from the default subtitle style and adapt it according to your needs.

• Id.
  Enter the name of the style.
  Use it in the column Text Style of the Table Clips.
• Font Name.
  Enter the name of the font.
• Size.
  Enter the size of the text.
• Primary Color.
  Enter the color of the text.
• Outline Color.
  Enter teh color of the outline of the text.

You can also change text sizes, bold, outlines, alignments and positions of any text style.

Add new voices in the Table Speech Styles, and combine each voice with a different subtitle style using the Speech Style column of the Table Clips.

Text Style Effects

In the column Effects you can enter commands and element to use in the columns Effects of the Clips table.

You can specify:

• object=RowId
  A command with elements.
  Example: "DrawRect:pos=800:200,size=500:400,border=red:4,opacity=0.9;Arrow:3:3
  The parameters can be modified in the table Clips.
  "Object:id=frect,pos=800:300,size=500:300"
• style=RowId
  Attributes that are used to display a command.
  Example: "border=#ffe01b:3:5,fill=blue,opacity=0.1"

 Create style to use for creating speech.
If you use a style you should specify also for any language you use.

Columns Speech Styles

• Id.
  • default.
    The style to be used in case the speech style is not specified.
  • Any other name for a style.
• Language
  The language code used for the column text in the Clips table.
• Voice Language.
  Language code  and country code.
  It should be the same as the one of the Voice name.
  Example: "en-US".
  For each language and id you should have only one country code. If you have more the program will use the first id it find.
• Voice.
  The voice name that available in your service.
  The software will show to you a list of available voice based on the service you have selected.
  Example: "en-US-AriaNeural"
  • Microsoft  azure voices (click on section Text-To-Speech)
  • Google voices.
• Rate, Pitch and Volume see Microsoft Azure explanations.

Predefined Speech Styles

If not defined the software will use this speech styles.

The Speech service used (Microsoft Azure or Google) will be automatically selected based on the API key you have entered in the global settings.

Azure and Google have different voice name, so once you enter the one that is specific to the service you use.

Microsoft Azure

See. Microsoft  azure voices

Predefined languages for Microsoft Azure Service.

• "de","de-DE","de-DE-KatjaNeural"
• "es","es-ES","es-ES-ElviraNeural"
• "en","en-US","en-US-AriaNeural","cheerful"
• "fr","fr-CH","fr-CH-ArianeNeural"
• "it","it-IT","it-IT-IsabellaNeural"
• "nl","nl-NL","nl-NL-ColetteNeural"
• "pt","pt-BR", "pt-BR-FranciscaNeural"
• "zh","zh-CN","zh-CN-XiaoxiaoNeural"

Google Speech to Text

See available Google voices.

Predefined languages for Google Text to speech Service.

• "de","de-DE","de-DE-Wavenet-A"
• "es","es-ES","es-ES-Wavenet-C"
• "en","en-US","en-US-Wavenet-A"
• "fr","fr-CH","fr-FR-Wavenet-Al"
• "it","it-IT","it-IT-Wavenet-B"
• "nl","nl-NL","nl-NL-Wavenet-B";
• "pt","pt-BR", "pt-BR-Wavenet-B"
• "zh","zh-CN","cmn-CN-Wavenet-B";

This dialog allow to add effects to the image.

Command Syntax

The column Effect support the following syntax (Version 2, from December 2021).

• Levels separated by "|"

Main commands

One per level

• DrawEllipse:
• DrawHtml:
  Print the text specified in the Text column.
  TextStyle and Speech style should be "none"
• DrawImage:
  Draw the specified image file.
  The image is resized.
  Use for inserting a logo.
• DrawMarkdown
  Convert the markdown text specified in the Text column to html and print.
  TextStyle and Speech style should be "none",
  See further explanation below.
• DrawRect:
  Draw a rectangle at the specified position and with specified size.
• DrawText:
  Draw a text. The text is resized to fit the rectangle.
• FFmpeg:
  You can enter an FFmpeg command
  Examples:
  • FFmpeg:drawbox=x=400:y=100:w=300:h=200:color=pink@0.5:t=fill
  • FFmpeg:scale=4*iw:-1,crop=iw/4:ih/4
• ObjectClip:rowid
  It use an object defined in the table Clip column Effects with the RowId specified
  • Example: ObjectClip:id=001,pos=800:300,size=500:300
    Use the object defined, but with a specified size.
• ObjectStyle:rowid
  It use an object defined in the table TextStyle column Effects with the RowId specified
  • Example: ObjectStyle:id=frect,pos=800:300,size=500:300
    Use the object defined, but with a specified size.
  • Use to automate the object creation and styling.
    Create the object in the table Clip and then copy in the TextStyle table.
• Rescale:
• SelectRect:
  It makes the rest of the image darker.
• VideoCut:
• ZoomIn:

Elements (separated by ";")

Are relative the the commands.

• ;Arrow:
  Add and arrow next to the form
  • ,align= 1 to 9, numeric on the keyboard
  • ,dim=1 to 5
• ;Number
  • ,text=
  • ,align=1 to 9 , numeric on the keyboard
  • ,dim= 1 to 5
• ;Grid:numberpixels
  Will display a grid every specified pixels.
  Example: ";Grid:100,fill=yellow" grid every 100 pixels in yellow.

It use the styles of the main command, unless a different style is specified.

Attributes (separated by comma ",")

Attribute are added to the commands or to the elements.

• ,align=[number 0 to 9)
  Used for Elements Number and Arrow.
  The position of the elements is as the key on the numeric keyboard.
• ,Dim=1 to 5
  The size of the Elements Number and Arrow.
• ,border=color:[width]
• ,color=color //text color
• ,endtime=hh:mm:ss.mmm
  for VideoCut
• ,fill=color:[pattern]
• id=RowId
  Use the text at the row with the specified RowId
  For ObjectStyle it retrieve the effect specified in the table TextStyle
• image=filename
  for DrawImage
• ,opacity=number (0 to 1)
• ,pos=x:y
• seconds=seconds
  for ZoomIn
• starttime=hh:mm:ss.mmm
  for VideoCut
• ,size=width:height
• ,style=stylename
  Use the content of the column Effects in the table TextStyles at the line with the id stylename.
  Examples:
  • DrawRect:pos=800:200,size=500:400,style=saa,border=blue:30
• ,text=text
  Use the text that is specified.
•  

Examples

• SelectRect:pos=800:300,size=500:400,border=red:3;Arrow:align=1,dim=3,fill=yellow;Number,text=1,align=7,dim=3
• DrawImage:pos=900:300,size=200:100,image=filename.png,pen=red
• DrawRect:pos=900:300,size=200:100,border=red:3,fill=yellow;Number:1:9:3;Number:6:5:3;Number:3:7:3
• DrawRect:pos=900:300,size=200:100,border=red:3

DrawMarkdown

Markdown is syntax that can be converted easily to html
You can create slides and reuse.

This is an example of markdown text

# Title 1

## Title 2

### Title 3

Proof of **bold** *italic*

* line 1
* line 2
* line 3

This commands allows to use markdown in the text.

• When using this command the columns TextStyle and SpeechStyle should be set to none.
• The markdown text is rendered in html using the style defined in the file _video.css in the table Documents
• Example:
  DrawMarkdown:pos=200:100,size=800:600

With the DrawMarkdown command you can use also this elements:

• ;HtmlSelectLi:2
  A class "selected" is added to the specifiend html tags "li" ;
  This you can display an item with a different style.
• ;HtmlAddClass:classname
  A class "classname" is added to all html tags that belong to the markdowns.
  You can have styles specific to a single markdown.