Documentation 9 (English only)

Following you find documentation that is only mantained in English:

 

Excel Reports Add-in (Beta)

With this add-in there will no longer need to make "copy and paste" of the values each time you update your accounting file.

You create worksheets with formulas, charts, formatting and more in Excel, and the add-in will retrieve for you the data from the accounting file.

Just click on the update button and your Excel worksheet will be automatically filled with the new values from Banana Accounting, and the results of  formulas and charts will be updated accordingly.

See Documentation Banana Accounting Excel Add-in.


Example of a Balance sheet report created with the Excel Reports add-in

 


Example of a report with charts created with the Excel Reports add-in

Characteristics

  • This add-in is hosted on our server.
    Once you have installed the manifest on your computer, your will automatically use the last version.
  • The add-in are secure.
    Unlike Excel-macros the Add-in are secure and cannot compromise your computer.
  • The add-in is currently in Beta Test.
    • Please check everything and report any problem.
    • You can use for free, but It is also possible that it will be made available with a cost.

 

Installation Banana Accounting Excel Add-In

The steps below walk you through all the setup to run the Banana Office Add-ins for Microsoft Office 2016.

Minimum requirements:

  • Banana Accounting 9.
  • Microsoft Office 2016 (Word, Excel, PowerPoint, Outlook).

Get Banana Accounting 9

  1. Download Banana Accounting for Windows or Mac.
  2. Install it on your pc.

Activate Banana Accounting web server

  1. Start Banana Accounting.
  2. On Menu bar click Tools → Program options and select the Interface tab
  3. Check the Start Web Server and Start Web Server with ssl options.


     
  4. Click OK.

Load the Add-in

  1. Open Microsoft Excel 2016.
  2. Click on Insert tab.
  3. Click on the Store icon to open the Office store.


     
  4. In the Office store page search for Banana add-in.


     
  5. Click on the Add button to add the Banana Accounting Excel Reports add-in.
  6. As soon as the add-in is added in Excel, on the Home tab of the main ribbon is loaded the Banana Accounting add-in command.


     
  7. Click on the Banana Accounting icon to use the add-in.

 

Once the add-in has been added from the Office store it is saved into My Add-ins section.
To load an add-in previously added from the office store:

  1. Click on Insert tab.
  2. Click on the My Add-ins icon.


     
  3. Select the Banana Accounting add-in.


     
  4. Click on the Add button.

 

Windows users

For Windows users, please follow the Troubleshooting for Windows guide to complete the installation of the add-in.

macOS users

For macOS users, please follow the Troubleshooting for macOS guide to complete the installation of the add-in.

 

 

Troubleshooting Excel add-in for Windows

The guide below walk you through the Windows troubleshooting step by step.

  1. Download and install the latest version of Banana Accounting 9 for Windows.
     
  2. Update Windows and Excel.
     
  3. Open Excel and check you are logged in with your Microsoft account (File → Account → User Information).
     
  4. Start Banana Accounting web server:
     
    • Open Banana Accounting.
    • Click on menu ToolsProgram Options.
    • Select the tab Interface.
    • Check the options Start Web Server.

      banana accounting web server activation

       
  5. Add a local loopback exemption to Microsoft Edge Web Viewer (see Microsoft documentation for more information):
     
    • In the search box enter cmd.


       
    • On the right side select Run as administrator.


       
    • Confirm with Yes.


       
    • Copy and paste the following command:

      CheckNetIsolation LoopbackExempt -a -n="microsoft.win32webviewhost_cw5n1h2txyewy"
       
    • Press enter to run the command.


       
    • Close the command prompt.
       
  6. Change the server URL on the Add-in settings:
     
    • Start Excel and Banana Accounting Add-in.
    • Click on the Options tab of the Add-in.
    • Select Other as Server information.
    • In the Server URL field enter http://localhost:8081.
    • Click OK to confirm and save the changes.
    • On the Setup tab of the add-in refresh the files list.

      banana excel add-in server url

 

Note: in case you don't want to use the Excel add-in anymore, you can remove the local loopback exemption at any time with the command:

CheckNetIsolation LoopbackExempt -d -n="microsoft.win32webviewhost_cw5n1h2txyewy"

 

Messages

  • Cannot connect to local web server. Incorrect URL server or Banana Accounting/web server are not running.
    The connection between Banana Accounting and Excel add-in did not occur. Please follow step by step the Troubleshooting for Windows guide on this page.
  • No file is open in Banana Accounting.
    Banana Accounting is working but no file is open. Open at least one file in Banana Accounting.
  • File not selected.
    No file is selected from the files list. Refresh the files list and select one of them.

 

Troubleshooting Excel add-in for macOS

The guide below walk you through the macOS troubleshooting step by step.

  1. Download and install the latest version of Banana Accounting for Mac.
     
  2. Start Banana Accounting web servers:
     
    • Open Banana Accounting.
    • Click on menu ToolsProgram Options.
    • Select the tab Interface.
    • Check the options Start Web Server and Start Web Server with ssl.
       
  3. Open Safari and insert the url https://127.0.0.1:8089
     
  4. When the dialog appears, insert your system password and click on always button.


     
  5. Start Excel 2016 and load the Add-in.
     
  6. Click on the Refresh file list button.
     
  7. If a dialog window appears, click always allow button on the left.

 

Messages

  • Cannot connect to local web server. Incorrect URL server or Banana Accounting/web server are not running.
    The connection between Banana Accounting and Excel add-in did not occur. Please follow step by step the Troubleshooting for macOS guide on this page.
  • No file is open in Banana Accounting.
    Banana Accounting is working but no file is open. Open at least one file in Banana Accounting.
  • File not selected.
    No file is selected from the files list. Refresh the files list and select one of them.

 

Documentation Excel Add-in

Introduction

With this add-in you can create Excel sheet that are filled with Banana Accounting data. Once you have added transactions to the accounting file you just need to click on the Update Button of the add-in and your spreadsheet content will be updated with the new data.
Your existing formatting and formula will be preserved.

  1. Create an Excel sheet with headers information
    This information allows the add-in to retrieve data from Banana Accounting.
    There are information relative to the file, column and account or group to be retrieved.
    The add-in help you add the necessary information to retrieve the data.
  2. Click on the Update button
    The add-in will retrieve the values from Banana Accounting software.
    It mantains the format or formula you enter.


Example of a Balance sheet report created with the Banana Accounting Excel add-in

In the example above we can see:

  • The data part
    Here is where the data is synchronized, based on the QueryAccount and QueryColumns.
    • Accounting data (Green)
      Filled with the information coming from Banana Accounting
    • Header data (Yellow)
  • QueryColumns (Red)
    The file name, columns names and type to retrieve.
    If the column is empty no data in this column will be retrieved. You can use the columns to enter formula.
  • QueryAccounts (Orange)
    The accounts or groups to retrieve.
    If the row is empty no data in this row will be retrieved. You can use the row for entering formula o text that is not overwritten.

By clicking on the update button the Data part is updated with the new data of the accounting file, and all the previously settings like fonts, colors, formulas will remain.

Download and installation

See documentation on how to Download and install the Add-in

Example files:

Add-in Command

As soon as the add-in is added in Excel, on the Home tab of the main ribbon is loaded the Banana Accounting add-in command.


Banana Accounting Add-in command

When the Banana Accounting button is clicked, it loads the start screen of the add-in. The start screen provides additional information describing the functionalities of the add-in.

Click on the Let's Begin! button to start using the add-in.


Banana Accounting Add-in start screen

Add-in general overview

The add-in is a task pane add-in type. This means that the add-in is loaded in a pane on the right side of the Excel worksheet.

It is composed by three tabs, each of them has one specific task:

  • The Setup tab contains all the tools needed to add information to your sheet so that the add-in can fill the data part with the accounting data. Typically it is used every time you want to create something new, like for example the very first time you use this add-in.
  • The Update tab is used to update the content of the Excel worksheet with the accounting data. It is used after the header section and some accounts/groups has been added.
  • The Messages tab shows some messages about the add-in and the operations it does. For example when you update the sheet a message is displayed telling you that the update is completed.
  • The Options tab is used to set some settings like the language and the server's Url.
     

Update of the worksheet

The Update tab is composed only of one button: Update current worksheet.

When clicked, this will start the updating process of the current Excel worksheet. Combining Header, QueryAccount and QueryOptions information, the add-in retrieves all the data directly from the Banana Accounting file and writes them in the Excel worksheet.


Retrieve data from Banana Accounting and update the worksheet

Setup of the worksheet

These features will add the necessary information to the current worksheet to retrieve data from Banana Accounting.

In the Setup tab there are four sections:

  • Accounting file selection
  • Set Header
  • Set QueryColumns
  • Set QueryAccounts


Setup of the worksheet tab

Select an opened Banana file

The first section of the setup page lists all the currently opened Banana Accounting files.
When the Refresh file list button is clicked, the add-in checks for all the opened Banana Accounting files and lists them.

Click the button, select a file, then go to the next setup section.

If you cannot see any file on the list and an error message is displayed, please follow the Troubleshooting for Windows or the Troubleshooting for macOS documentations.


Example of file selection

Set Header

The second section of the setup page inserts, on the top of the current worksheet, the header that allows the user to insert information that will be used by the add-in to retrieve data from the accounting file.

Add an header

The first step is to select from the list a type of header. There are two options:

  • Predefined header with columns to insert an header with default values for columns and options
  • Empty header to insert a blank header. In this case you must manually add columns and options values.

When the button Add Header is clicked, the selected type of header is inserted in the worksheet. It is then possible to modify it by changing the values of QueryColumns and QueryOptions.

Add header options

The second step is to define some options for the Currency, Header Left and Header Right values using the QueryOptions column. The options are:

  • Repeat to repeat the values in each column
  • Do not repeat to avoid repeated values. Only when the file name changes the values are entered again.

When the button Add options is clicked, the selected options will be inserted in the related cells.


Example of predefined header

Set QueryColumns

This section guides step by step the user to modify the header by adding QueryColumns to the worksheet.

The QueryColumns information allows the user to define exactly which data the add-in has to retrieve from the accounting file and in which column of the worksheet insert them.

Each QueryColumn consists of six information:

  • The Column of the worksheet is used to define in which column of the worksheet all the QueryColumns values will be inserted.
  • The File name is used to define the accounting file to use when retrieving data.
  • The Type value is used to define the type of data of the accounting file.
  • The Column value is used to define the accounting file data for the given type.
  • The Segments (OPTIONAL) is used to have a more detailed classification of the costs. It is optional, if not specified none segments are added.
  • The Periods (OPTIONAL) is used to define a period of the accounting. It is optional, if not specified all accounting period is automatically used.

When the button Add values to column is clicked, all the information are automatically added to the selected column of the worksheet.

You must repeat this process for each column you want to add to the worksheet.


Set QueryColumns section

Select a column of the worksheet

Use this to define in which column of the worksheet all the values of the QueryColumns are inserted. Possible values are:

  • Current selected to use the colum of the cell selected on the worksheet (ex. if the cell D8 is selected, D column will be used).
  • From C to Z.

The list shows only columns from C to Z, but it is also possible to use columns until AZ by adding them manually.

Select a filename

Use this to define the file name for a QueryColumn. When a file name is specified it is used until a new file name is inserted.

The possible values are:

  • Current to use the selected file from the list on the top.
  • Current (void) to use the previously inserted file but let the cell empty. It works only if in previous columns there is a specified file name.
  • 1 previous year (p1) to use the previous year file of the last file inserted (example: if current year is "2019.ac2", p1 refers to "2018.ac2").
  • 2 previous years (p2) to use two previous years file of the last file inserted(example: if current is "2019.ac2", p2 refers to "2017.ac2").
  • 3 previous years (p3) to use three previous years file of the last file inserted(example: if current is "2019.ac2", p3 refers to "2016.ac2").


Filename selection

Notes:

  • Remember to always open in Banana Accounting all the files specified in the header.
  • The p1, p2 and p3 abbreviations always refer to the last file specified in the header.
  • Use p1, p2 and p3 only if in the accounting file is used the File and accounting properties → Options → File from previous year.


Example of more file insertion

On the image above we can see there are three different files defined, each of them using different columns.

  • The columns from C to G refer to the 2019.ac2 file.
  • The columns from H to I refer to the 2018.ac2 file.
  • The coumns from J to K refer to the previous year file of the 2018.ac2 file. This file must be specified in the File and accounting properties → Options → File from previous year of the 2018.ac2 file.

Select a Type and a Column value

Use Type and Column rows to define the data you want to retrieve from the accounting file.

  • Type specify the type of data of the accounting file.
  • Column specify the data of the accounting file for the given Type.

Enter the values using the add-in or writing them directly into the worksheet cells.

List of possible Type-Columns combinations (not Case-Sensitive) you must enter into the related Type and Column rows of the header:

  • column
    • Group, Account, Description, Disable, FiscalNumber, BClass, Gr, Gr1, Gr2, Opening, Debit, Credit, Balance, Budget, BudgetDifference, Prior, PriorDifference, BudgetPrior, PeriodBegin, PeriodDebit, PeriodCredit, PeriodTotal, PeriodEnd, NamePrefix, FirstName, FamilyName, OrganisationName, Street, AddressExtra, POBox, PostalCode, Locality, Region, Country, CountryCode, Language, PhoneMain, PhoneMobile, Fax, EmailWork, Website, DateOfBirth, PaymentTermInDays, CreditLimit, MemberFee, BankName, BankIban, BankAccount, BankClearing, Code1
  • current
    • amount, amountcurrency, balance, balancecurrency, bclass, credit, creditcurrency, debit, debitcurrency, enddate, opening, openingcurrency, periodstring, rowcount, startdate, total, totalcurrency
  • budget
    • amount, amountcurrency, balance, balancecurrency, bclass, credit, creditcurrency, debit, debitcurrency, enddate, opening, openingcurrency, periodstring, rowcount, startdate, total, totalcurrency
  • columnvat
    • Group, VatCode, Description, Gr, Gr1, IsDue, AmountType, VatRate, VatRateOnGross, VatPercentNonDeductible, VatAccount
  • currentvat
    • taxable, amount, notdeductible, posted, rowcount
       

Below some examples of queries that can be entered in the header:

  • Example 1: return from the Accounts table the value of the column description for the account specified in the QueryAccount column.
    Type: column
    Column: description
     
  • Example2: return the amount of debit transactions for all the accounting period for the account specified in the QueryAccount column.
    Type: current
    Column: debit
     
  • Example 3: return the opening + debit-credit from the 01.01 to 10.01.2022 for the account and segment specified in the QueryAccount column.
    Type
    : current
    Column: balance
    Segment: :S1
    Start date: 01.01.2022
    End date: 10.01.2022
     
  • Example 4: return the difference between debit-credit for the 6th month for the account specified in the QueryAccount colum.
    Type: current
    Column: total
    Start date: M6
     
  • Example 5: return the difference between debit-credit for the second quarter for the account specified in the QueryAccount column.
    Type: current
    Column: total
    Start date: Q2
     
  • Example 6: return from the Vat Codes table the value of the column description for the vat code specified in the QueryAccount column.
    Type: columnvat
    Column: description
     
  • Example 7: return the amount of the taxable column for the vat code specified in the QueryAccount column.
    Type
    : currentvat
    Column: taxable
     

Select a Segment (optional)

If the selected file has segments they will appear in the list.

Use this to define a segment to have a more detailed classification of the costs.

Select a period (optional)

Use this to define the accounting period that will be used to retrieve data from the accounting file.

Possible values are:

  • All (void) to use all the accounting period.
  • Custom date to specify a custom period (example: Start date "04.02.2022",  End date "12.03.2022").
  • Month 1 (M1) ... Month 12 (M12) to specify a single month (example: M1 for 1st month, M2 for 2nd month, etc.).
  • Quarter 1 (Q1) ... Quarter 4 (Q4) to specify a single quarter (example: Q1 for the 1st quarter, period from 01.01 to 31.03).
  • Semester 1 (S1) ... Semester 2 (S2) to specify a single semester (example: S2 for the 2nd semester, period from 01.07 to 31.12).
  • Year 1 (Y1) ... Year 10 (Y10) to specify a single year (example: Y1 for the 1st year).

Set QueryAccounts

This section provides to insert:

  • QueryAccounts to specify all the desired accounts, groups, cost centers, segments or vat codes that will be used with the data specified in the header to retrieve the accounting data.
  • QueryOptions (OPTIONAL) to specify an option for a specific QueryAccount. Just select a cell next to the account and insert the option. It is optional, if not specified none options are added.

Add accounts

When an option is selected, the add-in loads the appropriate check box list with all the elements taken from the selected accounting file. It is possible to choose between six options:

  • Accounts to load a list of all the accounts/categories codes taken from the table Accounts/Category of the accounting file.
  • Groups to load a list of all the groups codes taken from the table Accounts/Category of the accounting file.
  • Cost centers to load a list of all the cost centers codes taken from the table Accounts/Category of the accounting file.
  • Segments to load a list of all the segments codes taken from the table Accounts/Category of the accounting file.
  • All to load a list of all the accounts/categories, groups, cost centers and segments codes taken from the table Accounts/Category of the accounting file.
  • Vat codes to load a list of all the VAT codes taken from the table VAT codes of the accounting file.


Type of account selection

For example, choosing the All option, the add-in loads a list containing all the accounts, groups, cost centers and segments respecting the order in which they appear in the accounting file.


Example of accounts and groups selection

Select the desired elements and click the Add accounts button to add them to the worksheet under the QueryAccount (column A) starting from the selected cell. By default the add-in starts the insertion immediately after the QueryAccount title (row 16).


Add the selected accounts and groups to the Excel worksheet

Add option

The QueryOptions column is designed to add some options to the query. It is optional, if not specified no options are used.

The possible values are:

  • invert to invert the sign of the current and budget balances.
  • budget to get the budget balances of the selected QueryAccount.
  • budgetinvert to get the budget balances of the selected QueryAccount and also to invert the sign.


QueryAccounts options selection

Header settings

The purpose of the header is to let you to choose which data to import from Banana Accounting and on which columns in the Excel file to display them.
You must manually set column by column indicating, for each of them, the data that you want to import and display. It is possible to use the columns from C to AZ.
 
Notes:
  • Do not add or delete rows in the header.
  • Do not add or delete columns before the column B.
  • From column C forward, it is possible to add or remove columns. Columns A (QueryColumn) and B (QueryOptions) must always exist.
  • Added columns can also be empty.
  • If columns from AA to AZ are used, plese re-enter the file name at least on the AA column, even if it is the same used in the previous column.

To better understand how exactly the header works and how to properly modify it, below there are some explanation about the most important things.


Editable header parts

On the image above we highlighted in yellow all the header's parts that can be modified by adding information when creating a report.

Everything else will be automatically filled by the add-in when the Update current worksheet button is clicked.

Period Begin

A conversion of the start date to be easily read.
This is automatically filled for each column by the add-in when the worksheet is updated.

Period End

A conversion of the end date to be easily read.
This is automatically filled for each column by the add-in when the worksheet is updated.

Currency

The accounting basic currency.
This is automatically filled for each column by the add-in when the worksheet is updated.

Header Left

One of the information property of the accounting.
This is automatically filled for each column by the add-in when the worksheet is updated.

Header Right

One of the information property of the accounting.
This is automatically filled for each column by the add-in when the worksheet is updated.

QueryAccount

As already said, in this column are listed all the chosen accounts, each on a different row.

Instead of insert an account, is also possible to add a custom regroup using a particular accounting column.
The custom regroup QueryAccount syntax is $column=value, where:

  • $ indicates that a custom regroup is used.
  • column is the Xml name of the column. It can be a user created column (for example "Abc") or a column that already exists in the accounting (for example the "Gr").
  • value indicates the regroup.

If we insert something like "$Abc=1" in the QueryAccount cell, this means that the add-in takes and sums together all the accounts/groups balances that have the 1 value in the "Abc" column of the accounting.

Messages

The Messages tab shows some information about the add-in and the operations that it does.


Example of messages

Settings

The Settings tab allows to change some settings of the add-in:

  • the Server information allows to define the URL where Banana Accounting is hosted, to avoid to have Banana Accounting installed locally. By default it is defined the local Banana Accounting web server https://127.0.0.1:8089.
  • the Connection token at the moment should be left empty.
  • the Language to define the language of the Banana Excel Add-in. Available languages are english, french, german and italian.
  • the Development is used only by developers for testing purposes, and users cannot access it.

Click on the Ok button and accept to reload the add-in in order to use the new settings. The settings are saved for future use of the add-in.


Settings tab

 

Release History

  • 2017-06-12 First release
  • 2017-07-07
    • Added Add-in Commands functionality.
    • Added a start screen that provides additional information describing the functionalities of the add-in.
    • Added the settings tab to allow the user to change the Port of the URL.
  • 2017-09-29
    • Changed the name of the add-in to "Banana Accounting Excel Reports".
    • Changed some texts.
    • New add-in design.
    • Added new functionalities that allow the user to set and insert all the required information more easily.
    • Added localization language for english, french, german and italian.
  • 2017-11-24
    • Added new functionality that allows to set the parameters for the connection.
  • 2018-04-04
    • Settings options are now saved.
    • Changed the appearance of the error messages.
    • Changed some texts.
    • Other minor changes.

 

 

 

Local installation

The steps below walk you through all the setup of the environment required to run the Banana Excel add-in from a local installation and not from the Office store.

In order to do that, you will have to:

  • Download all the add-in files.
  • Save them to specific folders on your computer.
  • Add a trusted add-in catalog in Excel.
  • Load the add-in in Excel.
  • Set the server URL in the add-in.

Minimum requirements: Microsoft Excel 2016 for Windows or macOS.

Get Banana Accounting 9

Install Banana Accounting 9 for Windows or Mac on your pc.

Start Banana Accounting web server

In order to use the add-in you have to start the Banana web server first:

  1. Start Banana Accounting 9.
  2. On menu bar click Tools → Program options and select the Interface tab.
  3. Check the Start Web Server option. The web server with ssl is not needed.
  4. Click Ok.

Banana Accounting web server

Download the add-in files

The next step is to download all the required files of the add-in.

  • Download the BananaAccountingExcelAddin.zip file.
  • Extract the content:
    • BananaAccountingExcelAddin: folder containing all the add-in files.
    • BananaAccountingExcelManifest: manifest file of the add-in.

      Banana Accounting Excel addin files

 

Install the add-in files

The files extracted from the zip must be copied to specific directories.

Add-in files for Windows

On Windows you need to copy the BananaAccountingExcelAddin folder in the directory C:\Users\{user_name}\AppData\Local\Banana.ch\Banana\9.0\WWW.

  • In the search box insert %LocalAppData% and press enter. The AppData\Local folder will open.
  • Navigate through the folders Banana.ch\Banana\9.0.
  • If it doesn't exists yet, create a folder named WWW (all in capital letters).
  • Copy in the WWW folder the BananaAccountingExcelAddin folder extracted from the zip file.

appdata excel addin files

Add-in files for macOS

On macOS you need to copy the BananaAccountingExcelAddin folder in the directory /Users/{user_name}/Library/Application Support/Banana.ch/Banana/9.0/WWW.

  • Open the Finder.
  • From the menu select Go and then Go to folder.
  • Insert here the path /Users/{user_name}/Library/Application Support/Banana.ch/Banana/9.0 and click Go.
  • If it doesn't exists yet, create a folder named WWW (all in capital letters).
  • Copy in the WWW folder the BananaAccountingExcelAddin folder extracted from the zip file.

Install the Manifest file

Each Office add-in has its own manifest file. The manifest is an XML file that defines various settings, including description and links to all the add-in files.
Manifest file must be copied to a specific directory.

Manifest directory for Windows

On Windows you need to create a directory to save the manifest of the add-in.
The directory needs to be a shared directory.

  1. Create a folder for the add-ins manifests on a network share:
    1. Create a folder on your local drive (for example, C:\Shared\OfficeManifest).
    2. Right click on the folder, select properties.
    3. Click on Sharing tab.
    4. Click on Advanced Sharing...
    5. Check the Share this folder box.
    6. Click Apply and then Ok.
    7. Copy here the BananaAccountingExcelManifest file extracted from the zip file.

      excel addin manifest shared folder
       
  2. Tell Excel to use the Manifests directory as trusted app catalog:
    1. Launch Excel and open a blank spreadsheet.
    2. Choose the File tab, and then choose Options.
    3. Choose Trust Center, and then choose the Trust Center Settings button.


       
    4. Choose Trusted Add-in Catalogs.
    5. In the Catalog URL box, enter the path to the network share you created, and then choose Add Catalog.
      To see the path of the network share folder: right click on the shared folder → Properties Sharing Network Path.
      You can copy the path from here.


       
    6. Select the Show in Menu check box, and then choose OK.
      A message appears to inform you that your settings will be applied the next time you start Office.


       
    7. Close Excel and restart it.

Manifest directory for macOS

On Mac you need to create a folder to save the manifest of the add-in.
Go to one of the following folders and copy here the BananaAccountingExcelManifest file extracted from the zip file.
If the wef folder doesn't exist on your computer, create it.

  • For Excel: /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Documents/wef
  • For Word: /Users/<username>/Library/Containers/com.microsoft.Word/Data/Documents/wef
  • For PowerPoint: /Users/<username>/Library/Containers/com.microsoft.Powerpoint/Data/Documents/wef

Note: <username> is your name on the device.

Load the add-in in Excel

Once all the setup and installations are done, it is possible to run and use the add-in.

  1. Open Microsoft Excel 2016.
  2. Click on Insert tab.
  3. Click on the My Add-ins button.


     
  4. Click on the Shared folder.


     
  5. Select the Banana Accounting Excel add-in.
  6. Click Add.

The add-in is added

Set the server URL setting

In the add-in make sure to change the server URL to http://localhost:8081.

  • Start Excel and the Banana Accounting add-in.
  • Click on the Options tab of the Add-in.
  • From the server information select Other.
  • In the Server URL field,  insert http://localhost:8081
  • Click OK to confirm and save the changes.

    Banana Accounting Excel add-in web server"

 

 

Other Resources

For more and detailed information about the developing of the Office Add-ins, please visit https://github.com/BananaAccounting/General/tree/master/OfficeAddIns.

Introduction to Excel 2016 Add-ins

Office 2016 Add-ins are extentions of Word, Excel, PowerPoint, and Outlook.
Add-ins are composed of:

  • Manifest file.
    An XML file that defines various settings, including description and links to all the add-in files.
    It is used by Word, Excel, PowerPoint, and Outlook to locate the Add-in resources.
    The manifest file can reside on a local directory or is published on the Office Store.
  • Webpage files.
    Files that compose the web app (HTML pages, JavaScript code and images).
    All the files need to reside on a web server.

Add-in Examples

These examples have been made available for programmers that want to create specialized add-ins to retrieve information from Banana Accounting.
You need to insall the add-ins on a web server.

 

 

ExcelSync functions

With ExcelSync your accounting data is available in Excel.  No more need to copy and paste or to export and import.

You add new transactions and your Excel Sheets are instantly updated and calculated. For Apple/Mac this feature is not available.

ExcelSync uses VBA Macros. This technology has been replaced by the more recent Excel Add-in.
We invite you to use the Excel Report Add-in (Beta).

Example costs divided among co-owners or customers

The ExcelSync functions are used to retrieve from Banana in Excel the current accounts balances. 
The costs are then divided among customers using normal Excel Formulas.
You could use the example to create a division of the apartment costs.

Example with the current and last year difference

In this example we take the data from the two years and create a graphic.

Example with segments subdivision

The amount of the segments are diveded also by segments.


Introduction to Banana ExcelSync User defined functions

Introduction

ExcelSync are Excel User defined functions that allow to synchronize in real time your Excel spreadsheet with the data from Banana Accounting.
You update you accounting file, adding new transactions, and instantly you get your Excel Sheets updated.

Excel has the ability to integrate documents and data that are made available throught the internet protocol. Banana includes a web server, and a RESTful API, that can be accessed through http protocol. ExcelSync uses the Banana integrated web server to retrive data on real time.

Using Excel formula

Banana ExcelSync are functions, with the name that start witht the "B", that you can use within the cell to retrive accounting data.
Here some example:

// return the opening balance of the account 1000 for all the period
=BOpening("1000")  
// return the description of the account 1000
=BAccountDescription("1000")
// return the end balance of the group 10
=BBalance("Gr=10")
// return the opening of the account 5000 for the period 3. month 
=BOpening("2000", "2017-03-01/2017-03-31")
// return the total debit minus credit of the account 5000 for 3. month of the year
=BTotal("5000", "M3")
// return the total debit minus credit of the group 50 for 3. quarter of the year
=BTotal("Gr=50", "Q3")  

The advantage of the Excel Sync functions :

  • You can dynamically retrieve the take data from Banana Accounting.
  • No more need to retype data in Excel (or import, copy and paste)
  • When the accounting file is changed, the spreadsheet is populated with the new values
  • Easy to use formulas that let you calculate values for periods and create powerful spreadsheets for evaluating, presenting accounting data or creating graphics.

Tecnical details

Banana ExcelSync are Excel User defined functions (UDF), small Visual Basic Programs that extend Excel allowing to insert formula within the cell.

  • Banana ExcelSync requires a recent version of Excel, and due to the Excel Mac limitations works only on Windows versions.
  • In order to use the ExcelSync UDF you need an Excel file with the extension *.xlsm.
  • The Banana ExcelSync UDF are provided according the Apache License (open source software. See: /www.apache.org/licenses/LICENSE-2.0
  • Development and latest version of the function are available on github.com/BananaAccounting/General/
  • Banana ExcelSync UDF make use of the Banana web server.
  • You can extend the ExcelSync by adding other functionalities.

For more information on the formula used see the Banana API regarding the Accounting functions


Using the examples

  1. Download the Excel spreadsheet with examples files.
  2. Unzip the content
  3. Start Banana Accounting
  4. Activate the Webserver (Tools -> Program options -> Interface -> Start web server)
  5. Open the Banana accounting files "company_2019.ac2" and "company_2020.ac2"
  6. Open the "BananaSync.xlsm" file and activate the Macro
    If the macro are automatically disabled by Excel you should change your macro security setting
    Eventually follow this instructions to show the developer tab in the ribbon
  7. Recalculate the Spreadsheet with the Macro “RecalculateAll”  (Ctrl+R)

Excel does not react

If you open a file and Banana or the Banana Web Server are not running, Excel will wait until it can contact the Banana Web server.

Start the Banana and the Banana Web Server.

 

How to create your spreadsheet

  • Save as the "BananaSync.xlsm" file with another name
  • Open your accounting files in Banana Accounting
  • In your Excel spreadsheet, replace the file name (yellow highlighted cells) with your accounting file name
  • Change the spreadsheet according to your needs
  • Recalculate with the "Recalculate" button or the "Ctrl+R" shortcut


Functions use

Argument file name

Most ExcelSync functions require, as first parameters, a name of a Banana Accounting file.

  • The file must be openened in Banana.
  • You use only the file name without the directory. 

DO NOT use the file name directly in the fuctions. Instead use a reference to a cell, that contains the file name.

  • You can use the same spreadsheed also for differrent years. You only need to change the file name in on cell.
  • If Banana Accounting is not open of the Banana webserver is not active you don't have to wait.

The best way is the one used in the example file.

  • The file name of the current year is taken from the cell named "File0" .
  • The cell File0 contains a function =BFileName(DisableConnection).
    This function checks if the file is open in Banana.
    • If the file is not open the content of the cell is set to an empty string.
      The other Banana Sync functions will not make any call to Banana, to retrive data.
    • If the file is open it will insert the name of the file.
  • The cell B6 contain the name of the file to be used. Insert the file name in cell B6.
    =BFileNameF(File0, DisableConnection).
  • The file name of the current year is taken from the cell named "File0" .
  • The file name of the last year is taken from the cell named "File1" .

Argument period

Many functions use the optional argument period. This can be:

  • An empty string. The start and end date of the accounting are used.
  • A start date and end date in the form of yyyy-mm-dd/yyyy-mm-dd
    example “2015-01-01/2015-01-31”
    In order to create a period from two Excel dates use the function BCreatePeriod.
  • An abbreviation
    With the abbreviation you can easily use the same spreadsheet for accounting file of different periods.
    The start and the end date will be determined based on the date of the accounting file
    • M + the month number M1, M2, ..
    • Q + the quarter number Q1, Q2,
    • Y + the year number Y1, Y2, ....

BananaSync Functions description

Most function are available

  • Without the parameter FileName.
    In this case the File0 (Current Year) is used
  • With the paramenter FileName.
    • The function is the same but end with "F"

BAccountDescription(account[, column]) and BAccountDescriptionF(fileName, account[, column])

Retrieve the account description of the specified account or group.
With argument column you can indicate to retrieve another column instead of the Description column.
Examples:

=BAccountDescription("1000")           // Description of account 1000 current year
=BAccountDescription("Gr=10")          // Description of Group 10 current year
=BAccountDescription("1000", "Gr1")    // Contet of column "Gr1" relative to the account 1000 current year
// Last year
=BAccountDescriptionF(File1, "1000") // Desctiption of account 1000 
=BAccountDescriptionF(File1, "Gr=10")       // Description of Group 10 

BAmount(account, [,period ]) and BAmountF(fileName, account, [,period ])

Retrieve the normalized amount based on the BClass.
Only work for double entry accounting only. For Income and expenses accounting use BBalance or BTotal.

  • for accounts of BClass 1 or 2 it return the balance (value at a specific instant).
  • for accounts of BClass 3 or 4 it return the total (value for the duration).
  • For accounts of BClass 2 and 4 the amount is inverted.

You can use this functions also with groups provided you assign a BClass also to a group.

BBalance( account [, period]) and BBalanceF(fileName account [, period])

Retrieve the Balance at the end of the period of the indicate account, cost center, groups, segments
The BBalance result is the sum of the BOpening + BTotal
It is used for retrieving accounting data for the Balance Sheet accounts (Assets, Liabilities)

  • Single account number  ("1000")
  • Several accounts summed toghether.
    Enter the accounts numbers separated by the character “|” ("1000|1001).
  • You can specify normal accounts, cost centers or segments.
  • You can also use wild cards and also use “Gr=” followed by the accounting group.
  • For more information see the Javascript function description for currentBalance
  • Example
BBalance( "1000")              // Balance of account 1000  
BBalance( "1000|1010")         // Balance of account 1000 and 1010 are summed together
BBalance( "10*|20*")           // All account that start with 10 or with 20 are summed toghether
BBalance( "Gr=10")             // Group 10
BBalance( "Gr=10| Gr=20")      // Group 10 or  29
BBalance( ".P1")               // Cost center .P1
BBalance( ";C01|;C02")         // Cost center ;C01 and C2
BBalance( ":S1|S2")            // Segment :S1  and :S2
BBalance( "1000:S1:T1")        // Account 1000 with segment :S1 or ::T1
BBalance( "1000:{}")           // Account 1000 with segment not assigned 
BBalance( "1000:S1|S2:T1|T2")  // Account 1000 with segment :S1 or ::S2 and ::T1 and ::T
BBalance( "1000&&JCC1=P1")     // Account 1000 and cost center .P1
// Last year 
BBalanceF(File1, "1000")        // Balance of account 1000 (last year)
BBalanceF(File1, "1000|1010")   // Balance of account 1000 and 1010 are summed together (last year)

 

BBalanceGet( account, cmd, valueName [,period ]) and BBalanceGetF(fileName, account, cmd, valueName [,period ])

This function allows to easily access all other data made available by the REST API as “balance”, “budget”
Examples:

=BAmount( “1000”, “balance”, “currencyamount”)
=BAmount( “1000”, “balance”, “count”)
=BAmount( “1000”, “balance”, “debit”)
// Last year
=BAmount( File0, “1000”, “budget”, “debit”)

BBudgetAmount(account [, period]) and BBudgetAmountF(fileName account [, period])

Same as BAmount but use the budget data instead of the accounting data.

BBudgetBalance(account [, period]) and BBudgetBalanceF(fileName account [, period])

Same as BBalance but use the budget data instead of the accounting data.

BBudgetInterest( account, interestRate [, period]) and BBudgetInterestF(filename, account, interestRate [, period])

Same as BInterest but use the budget data instead of the accounting data.

BBudgetOpening(account [, period]) and BBudgetOpeningF(fileName account [, period])

Same as the BOpening but use the budget data instead of the accounting data.

BBudgetTotal(account [, period]) and BBudgetTotalF(fileName account [, period])

Same as the BTotal but use the budget data instead of the accounting data.

BCellAmount( table, rowColumn, column) and BCellAmountF(fileName, table, rowColumn, column)

Retrieve the content of a table cell as an amount.
Examples:

=BCellAmount(“Accounts”, 2, “Opening”)
=BCellAmount(“Accounts”, “Account=1000”, “Balance”)
=BCellAmount(“Accounts”, “Group=10”, “Balance”)
// Last year
=BCellAmountF(File1, “Accounts”, 2, “Opening”)

BCellValue( table, rowColumn, column) and BCellValueF(fileName, table, rowColumn, column)

Retrieve the content of a table cell as a text.
Examples:

=BCellValue(“Accounts”, 2, “Description”)
=BCellValue(“Accounts”, “Account=1000”, “Description”)
=BCellValue(“Accounts”, “Group=10”, “Description”)
// Last year
=BCellValueF(File1, “Accounts”, 2, “Description”)

BCreatePeriod( startDate, endDate)

Take two cell dates and create a string period
=BCreatePeriod(D4, D5)

BDate(isoDate)

Convert an Iso Date to an Excel date.

BFileName(fileName [, disable connection])

Return the FileName or an empty string if there is no connection with the web server or if the file is not correct.
If the value of disableConnection is not void the function returns an empty string.
Use the cells that contain the result of this function as the file name parameter when using the other functions. If Banana is not open only one query is made and Excel will not wait for a long time.

BFunctionsVersion()

Return the version of the function in the date format.

BInfo( sectionXml, idXml) and BInfoF(fileName, sectionXml, idXml)

Retrieve information regarding the file properties.
Examples:

=BInfo(“Base”, “HeaderLeft”)
=BInfo(“Base”, “DateLastSaved”)
=BInfo(“AccountingDataBase”, “OpeningDate”)
=BInfo(“AccountingDataBase”, “BasicCurrency”)
// Last year
=BInfoF( File1, “Base”, “HeaderLeft”)

 

BInterest( account, interestRate [, period]) and BInterestF(filename, account, interestRate [, period])

Calculate the interest for this account for the specified period

account can be any account as specified in BBalance

interestRate in percentage

  • > 0 calculate the interest on the debit amounts
  • < 0 calculate the interest on the credit amount

BOpening( account [period]) and BOpeningF(filename, account [period])

Retrieve the Balance for balance of period start for the indicated account.

BQuery(fileName, query)

Return the result of a free defined query.
Examples:

=BQuery(File0;"startperiod?M1”)
=BQuery(File0;"startperiod?M1”)

BTotal( account [,period]) and BTotalF(filename, account [,period])

Retrieve the movement for the period.
Should be used to retrieve the data for the Profit and Loss accounts (Cost and Revenues).

BVatBalance( vatCode, vatValue [, period]) and BVatBalanceF(filename, vatCode, vatValue [, period])

Return a value regarding the specified VatCode (or multiple VatCodes).
“vatValue” can be “taxable”, “amount”, “notdeductible”, “posted”
Examples:

=BVatBalance(“V10”, “taxable”)
=BVatBalance(“V10|V20”, “posted”)
//Last year
=BVatBalanceF( File0, “V10”, “taxable”)

Additional function explanation 

The retrieve the exact content of the cells

If you wanto to retrive the content of a cell you can use:

  • BCellValue
    The content of a cell, useful for text.
  • BCellAmount
    The content of a cell is converted to a number so that you can use it for calculation.
    With this you will retrive the exact content of a column "Balance" for the row where Account is 1000.
    If the Balance is credit the amount is negative.
=BCellAmount(File0, “Accounts”, “Account=1000”, “Balance”)

Accounting Period calculation

You have different formula that allow to retrieve the amount.

  • BBalance.
    This is equivalent to the above. It retrieve the Balance of the whole accounting period.
    But BBalance allow you to use also a period.
    As a period you can use the date being, date end of an abbreviation. M3 means the first month of the accounting period.
    If you use abbreviation instead of date your sheet will automatically adapt to file of different year.
BBalance( "1000")  //Balance end of year
BBalance( "1000", "2017-03-01", "2017-03-31")  //Balance end of March
BBalance( "1000", M3);   // Balance and of March if accounting period start on 1. of January 
  • BTotal
    It retrieve the total movement (Debit - Credit) for the period.
    Use BTotal to the amount for income and expenss account.
    Cedit amounts are retrieved as negative numbers.
BTotal( "1000")  //Total movement end of year
BBalance( "1000", "2017-03-01", "2017-03-31")  //Total end of March
BBalance( "1000", M3);   // Total and of March if accounting period start on 1. of January 
  • BAmount
    BAmount put the sign in positive based on the BClass of the account. 
    The amount retrieved depend on the BClass of the account or the group.
    For Balance accounts (bclass 1 and 1) retrieve the Balance.
    For Income and expenses accounts (bclass 3 and 4) retrieve the Total.
    It also invert the sign in case of BClass 2 and 4.
    So if you use BAmount for the Account revenues (BClass 4) you will have the total sales for the period in positive.

Your are free to use the most appropriate function.

  • BAccountDescription.
    It is the same as GetCellValue but it deal automatically with accounts or groups.
    Is usefull to retrieve the description of an account or group, in combination with BBalance, BTotal or BAmount.

=BAccountDescription( "1000")           //Retrieve the column Description of the account 1000
=BAccountDescription( "1000", "Notes")  //Retrieve the column Notes of the account 1000
=BAccountDescription( "Gr=10")          //Retrieve the column Descrition of the group 10 

Recalculate

The automatic recalculation does not update the data from the accounting file.
In order to have the data updated it is necessary to call the macro RecalculateAll() that call the method Application.CalculateFullRebuild

The example files contain a button “Recalculate” that call the macro RecalculateAll.

Banana host name and port

Web server data is retrieved from “localhost:8081”

You can specify a different host by entering a value in a cell named “BananaHostName”

Modify the functions or add your owns

Functions are defined in the Visual Basic module “Banana”.
If you add your function it would be better to add to your module.

To access the Visual Basic Macro Functionalities you should activate the macro.

In order to see and edit the functions your nedd to show the Developer tab in the Excel ribbon.

Use a new version of the Banana functions

In order to see and edit the functions your nedd to show the Developer tab in the Excel ribbon.

  • Download on your computer the latest version
  • Open your file in Excel
  • Open the file "BananaSync.xlsm" in Excel
  • Go to the Developer Tab
  • Click on "Visual Basic"
  • Copy the content of the "BananaSync.xmls - Banana (Code)"
  • Paste the content in the Modules->Banana of your file.

Compatibility

Banana ExcelSync functions have been tested with Excel 2013 and 2016 for Windows.

Excel for Mac is not ready yet.

In Excel for Mac is not possible to call the http.
Any contribute to solve this problem is welcome.

Release History

  • 2014-07-24 First release
  • 2015-02-28 Updated for new version with new functionalities
  • 2015-05-12 Call to webserver now require v1
  • 2015-05-12 Development moved to github
  • 2015-05-25 Changed BAmoount function to use BClass
  • 2015-10-04 Added BDate function
  • 2015-11-12 Renamend ExcelSync
  • 2015-11-28
    • Added example for cost division
    • Started working on Mac support
  • 2016-04-26 Added BCellAmount
  • 2016-04-28 Fixes in some case rounding amount to zero
  • 2017-02-01 New Version 2 (Functions without the file parameters)

 

 

 

 

How to report a bug

Send us full details of the issue, giving as much detail as possible, this can include:

  • For bugs:
    • Steps to Reproduce:
      Minimized, easy-to-follow steps that will trigger the described problem. Include any special setup steps;
    • Actual Results:
      What the application did after performing the above steps;
    • Expected Results:
      What the application should have done, if there was no bug;
    • The accounting file:
      An example of an accounting file where the problem occur;
    • The system informations
      The dialog system informations display the information to attach to the request;
    • The system event log
      If he application has stopped working or disappears attach a copy of the system event log related to the crash;
       
  • For feature requests:
    • A description of what you would like to achieve, and why.
      A user story is an effective way of conveying this;

You can submit your issue through our contact form.

Rare Cases

Computers configurations can be quite different.
Banana Accounting is known to work seamleassy on most system, but in rare cases there may be some problems.

If you are experiencing a problem starting or using the application follow these steps:

  • Install the latest version of the application
  • Install the latest version of the graphics driver:
    Visit the manufacturer website, download the driver file and install it
  • Install the latest version of the printer driver.
    Visit the manufacturer website, download the driver file and install it

Bug reporting

Rare cases troubleshooting pages

How to retrieve the event log in Windows

If the application crashes (the application has stopped working or disappears) please send us an event log file to help the development team to troubleshoot the problems.

Follow the steps below to find and send us the event logs:

  • Click Windows Start button > Type event in Search programs and files field.
  • Select Event Viewer.
  • Navigate to Windows Logs > Application, and then find the latest event with “Error” in the Level column and “Application Error” in the Source column.
  • Copy the text on the General tab.
  • Attach the text in the contact form or in a email.

Banana 9 under Mac OS 10.15 Catalina - adjustment of date

Problem

After updating to Mac OS 10.15 Catalina, the Banana 9 program displays dates as follows, everywhere a date is being used:
6/10/y ; 7/10/y ; 8/10/y - showing a "y" instead of the short indication for the year, such as "19" (2019), "20" (2020).

System

Mac OS 10.15 Catalina

Solution

  • Click on the Apple symbol in the upper left corner of the screen
  • System Preferences —> Language & Region —> Advanced -> Dates;
  • In the "Short" field, change the setting for the year and reopen the Banana program.

Banana 9: The menu bar is hidden, the window of Banana is misplaced

Problem

The menu bar is hidden, the window of Banana is misplaced (similar to what is shown in this first image)


System

Affected OS: Windows 10


Solution

Update the driver of the Graphic Adapter

  1. Update driver using Windows Update
    • click on start
    • search for Computer Management
    • click on "Run as Administrator"


       
    • select "Device Manager"
    • Expand "Display adapters"
    • right click on every adapter and select "Update driver"


       
  2. Check your system with "Intel Driver & support Assistant"
    https://www.intel.com/content/www/us/en/support/intel-driver-support-assistant.html
  3. Visit the support page of the manufacturer of your computer to download the latest driver.

 

Banana9 hangs on startup on a system with two monitors

Banana9 hangs on startup on a system with two monitors

Problem

Banana 9 stops working on startup.

System

The computer has an ATI Display card with two attached monitors.

Affected OS: Windows 10, Windows 8, Windows 7

Solution

Resources

Anoniem (niet gecontroleerd)
product

Banana9 hangs on startup with the message "LoadLibrary failed with error XX: Wrong parameter."

Problem

Banana 9 stops working on startup. After the crash the message "LoadLibrary failed with error XX: Wrong parameter." is displayed.

System

The system is an old notebook where windows 10 was installed afterwards. 
The notebook's discrete graphic card is not officially supported by windows 10.

Affected OS: Windows 10

Solution

  • Update the graphic card driver

or

  • Rename in folder C:\Windows\System32 the file "atig6pxx.dll" to  "atig6pxx.dll.bak"

 

 

Banana9 hangs on startup with the message "dll is missing" or "error 0xc000007b"

Problem

Banana Accounting 9 does not start and a message stating one of the following texts appears:

  • The program can't start because a dll is missing from your computer.
  • The application was unable to start correctly accompanied by an error code (0xc000007b)

System

Usually this error occurs on Computers running Windows 7 or Vista, sometimes it also occurs on Windows 8 and 8.1.

Cause

Probably your system is not up to date.

Solution

Run Windows update and reinstall Microsoft Visual C++ redistributable

  1. Run windows update
    1. Select Start > Control Panel > System and Security > Windows Update.
    2. Select "Check for updates." Wait as the Windows Update tool scans checks for updates that you have not installed
    3. If you see a message that says, "Updates are available for your computer" or "Install updates for your computer," click the button labeled "Install updates."
    4. Wait as the updates install. Restart your computer when prompted to complete the updating process.
  2. Reinstall Microsoft Visual C++
    1. Open Programs and Features
    2. Uninstall all items with the name of "Microsoft Visual C++ 2*** Redistributable"
    3. Download the latest Microsoft Visual C++ redistributable packages
      1. Click here for 32 bit systems
    4. Run the file vcredist.exe that you just downloaded
  3. If the problem persists, force Windows Update to install missing components:
    1. Go to this Microsoft Support webpage
    2. Scroll down in the "Method 2" section.
    3. Download and install the package for your Operative System

Banana9 hangs some seconds after the main page of the program is showed

Problem

Banana 9 stops working a few seconds after the main page of the program is showed.

System

The system is running on a Acer notebook

Affected machines: Acer aspire es 17
Affected OS: Windows 10, Windows 8

Solution

  • Open in Explorer the folder C:\Program files\Banana90

  • Create a new folder 'backup_dll'

  • Move the files 'libeay32.dll' and 'ssleay32.dll' to the folder 'backup_dll'

  • Restart the application

 

Banana9 hangs when the Open File Dialog or the Save File Dialog is opened

Problem

Banana 9 stops working as soon an Open File Dialog or a Save File Dialog is opened.

System

The system is running on a Dell computer or notebook.
The software Dell Backup and Recovery (from Softthink) is installed and running on the system.

Affected OS: Windows 10, Windows 8, Windows 7
Affected systems: Dell computer

Solution A (recommended)

  • Update Dell Backup and Recovery tools to version 1.9.2.8 or greather
  • Check Dell User's Guides and Support pages on how to update your system

Solution B

  • Download the Autoruns for Windows - TechNet - Microsoft utility;

  • Expand the file Autoruns.zip;

  • Run the application Autoruns.exe as Administrator;

  • Select the "Explorer" tab;

  • Deselect all "DBRShellOverlay" entries from Softthinks SAS Publisher

  • Close Autoruns;

  • Restart Banana 9.

Notes

  • In one case, after the changes in the registry, the customer had some problems running Internet explorer.
    Those problems could be resolved by restoring the changes in the registry.
  • The number of "DBRShellOverlay" entries to be disable can be on some systems more than two, those entries have to be searched in all sections listed in the tab Explorer. 

Resources

  • Dell Forum page "Backup and Recovery causing applications using Qt5 DLLs to crash": http://en.community.dell.com/support-forums/software-os/f/3526/t/19634253

 

Banana9 hangs when trying to print

Problem

Banana 9 hangs the first or second time the print dialog is opened.

System

The  'Devices and Printers' configuration contains printers no longer attached to the system.

Affected OS: Windows 10, Windows 8, Windows 7

Solution

  • Open Start and select 'Devices and Printers'

  • Remove all printers no longer used or attached to the system