Fast Entry

Documentation •
In this article

In Banana Accounting Plus several practical functions allow you to speed up and automate entry

Here are the most frequently used functions for fast data entry:

Copy, Cut and Paste

Use these functions to copy, cut and paste data from one cell to another, one row to another, one table to another, Excel to Banana, etc. See the functions in the Edit menu.

Texts, accounts and amounts auto-completion

Auto-completion makes data entry much easier and faster. As soon as you type the first few characters, the programme suggests how to complete based on already existing data (accounts, VAT codes, dates or texts you have already entered).
In the menu ToolsProgram OptionsEditor, you can limit the number of values that are suggested or even deactivate the functionality.
You can use one of the following keys to accept the value that is proposed:

  • Enter key, accept the choice and move to the next editable cell, either to the right or below, depending on the settings you have chosen.
  • Ctrl+ Down Arrow key, accepts the chosen value and moves to the cell below.
  • Tabulator key, accepts and moves to the cell to the right.
  • Shift+Tabulator key, accepts and switches to the cell to the left.
  • F6 key (or Cmd+6 for Mac) accepts the text and executes the associated command (see explanation below).
Text Auto-completion in Banana Accounting Plus

To deactivate auto-completion of the previous year, the Smart fill with previous year's records option must be deactivated, from the menu FileFile and accounting properties → Options.  

Input and shortcut keys

You can speed up your text entry with several shortcut keys. Here are the most common ones:

  • On a Date column, the dot "." inserts today's date.
  • On a Time column, the dot '.' inserts the current time (e.g. in the Time Sheet).
  • F4 key (or Cmd+4 on Apple computers): copies data from the cell above.

You can find the complete list of keyboard shortcuts in the menu Help Keyboard Shortcuts.

Recurring transactions

Do you have registrations that keep on repeating or almost the same every month? You can write them in the Recurring transactions table and automatically recall them in the Transactions table when you need them. See how to enter Recurring transactions.

Import bank statements

Automatically import data from bank, postal, credit card, or PayPal statements. See all available options

Integrated calculator

The calculator is no longer needed: you can quickly enter formulas in unprotected cells, then press the Enter key and the programme performs the calculation and enters the final result. This function allows you to make immediate calculations, for example when you need to quote a value from a paper document or need to calculate a percentage. The integrated calculator is useful in all tables and in all columns of the type Amount.

Integrated Calculator in Banana Accounting Plus

Execute Command (F6 key)

Some columns are associated with actions that are activated with the menu Edit → Execute Command, or with the corresponding key (F6 or Cmd+6 on Apple computers) indicated in the information window. This function makes it possible to retrieve data or rows quickly without having to retype the contents. Examples of actions:

  • Doc column: resumption of recurring transactions or sequence number.
  • Description column: resumption of similar row data.

Wrap text

When the text of a line is very long, the Calculate Line Height command from the Format menu allows you to display it completely, adjusting the line height. For more information see the Format Menu page.

Here are the most frequently used functions for checking and detecting possible errors:

The Balance Column

In Banana Accounting Plus the possibility has been introduced to activate, in the Transactions table, the Balance column, which verifies in real time the difference between Debit and Credit accounts and immediately shows any differences.

Watch the Balance Column Video
The Balance column page

Check accounting and recalculate accounting command

The Check Accounting command from the Actions menu, rechecks all transactions and immediately reports any errors or differences.

Totals Table

The Totals table gives you a concise overview of how your business is doing, as it shows the totals of the main groups and is used to check the balancing of accounts. See the explanations on the Totals table.

Display Filter and Sort

It allows to filter and sort the rows displayed. It helps find and edit rows quickly.
The sort and filter effect only the visualization, they don't change the table content.

This is a new feature that is currently in development and is available only to a selected number of customers.
Kindly give us feedback on how to improve the filters.

Display Sort

Currently you have to click on the icon on the column header.

  • First click will sort the row ascending based on the column content.
  • Second click will sort the row ascending based on the column content.
  • Third click will remove the sort.

Display Filter features and syntax

  • Text is searched by finding the different words you specify in the input box .
  • The space is considered as a separator.
  • The search is case insensitive.
  • "!" when the token starts with the exclamation point "!" it is considered as a command.
    In this case show all line that do not includes invoice.
  • When more than one elements exist all should be present on the line.
    mario !-invoice

Special syntax :

  • !
    starts a command sequence
  • !-
    excludes content, can be used with any other operator
    !-mario !-1000 !-=1000 !-^payment !-~10
  • !=
    Find exact, the cell must contains exactly the specified text. Useful for accounts.
  • !^
    Starts with. The cell text must start with the specified text.
  •  !~
    Ends with. The cell text must end with the specified text
  • !~mario
  • !description!
    Column search. Search only within the column specified in between the two exclamation point. In description.
    It looks for the first column header that match the entered text.
    It search for mario only in the column description
  • !CO! or !COLOR!
    Color search. Upper case. Show all lines that have a color.
  • !FO! or !FORMAT!
    Format search. Show all rows with formats


Help us improve the documentation

We welcome feedback on how to improve this page.

Tell us what theme needs a better explanation or how to clarify a topic.

Share this article: Twitter | Facebook | LinkedIn | Email