Transactions Tab

Overview

This tab displays two different sets of data depending on what type of account is currently selected:

• When an Account Group is selected (as in the image above) the Transactions tab displays a chart giving you a quick overview of the current balances for the account group’s child accounts or groups.
• When a single Account is selected (as in the image below) the Transactions tab displays the Transactions Table where a user can view, create and edit transactions involving the account currently selected.

In this mode the tab displays all transactions involving the currently selected account in the Accounts Tree Panel (in the image above, the account ‘Bank’ is selected)

Account Balances

Transactions Tab also displays figures for the Current and Statement Balances for the selected account.

• The Current Balance figure reflects all transactions entered against an account.
• The Statement Balance figure reflects all cleared transactions against an account.

Table Tool Bar

The Tool Bar when viewing a single account contains a number of buttons.

• Select Current View Allows you to change the View that is currently in use by the table.
• Toggle View Editor Panel Show/hides the View Editor Panel that allows you to edit the current View or delete a View
• Create New View Creates a New View based on the currently selected view
• Search Shows/hides the table’s Search Panel that allows you to search for key words (or amounts) in the current table.
• Create Transaction – create a new empty transaction
• Copy Transaction – makes a copy of the currently selected transaction(s)
• Create Transaction using Template - lets you pick a predefined Template Transaction from the drop-down menu to auto-insert commonly occurring transactions
• Delete Transaction – hides the currently selected transaction(s) from view (use the default filter drop-down menu option from the Filter Selector to show all deleted transactions again – where you can also un-delete them if you wish)
• Show/Hide Chart – displays and hides the chart for the currently selected view
• Print – opens the Document Designer so you can select or design a suitable template for printing the current table of filtered transactions
• Export as CSV File - opens a filer window so you can export the current table in a format suitable for loading into a spreadsheet (i.e. Comma Separated Values)

Visible Columns

This component has the following columns visible by default:

• Multiple Select - enables the user to select (and therefore copy/delete) multiple transactions
• Date – the date the transaction occured
• Description – any descriptive text
• Payee – Choose the payee involved with this transaction
• Amount From - Indicates money coming from the selected account for this transaction
• Amount To - Indicates money coming into the selected account for this transaction
• Other Account - Specifies the account on the ‘other’ side of the transaction
• Reference – a reference value for the current transaction/entry
• Running Balance – shows the running balance of all the transactions currently displayed in the table.

Hidden Columns

• All Cleared - if selected then both sides of the transaction are cleared, if not selected then either side or both sides of the transaction are not cleared.
• Currency Code – the 3 character currency code of the chosen foreign currency
• Currency From - Indicates the amount of money coming from the selected account in the specified foreign currency for this transaction
• Currency Rate – the exchange rate to use when converting between the native and chosen foreign currency (as defined in the Currency Code column)
• Currency Running Balance – shows the running balance of all the transactions currently displayed in the table in the common foreign currency. NOTE: If the table has transactions that specify different foreign currencies then this field will be empty as you cannot mix foreign currencies together
• Currency To - Indicates the amount of money going to the selected account in the specified foreign currency for this transaction
• Date Created – the actual creation date of this transaction (it may be different from the Tax Date or Paid Date)
• Deleted – signifies if this transaction has been deleted or not. By default you only see non-deleted transactions but you can modify the Current Filter to show deleted transactions as well.
• Error Code – if the transaction is in error (has a red background) this column displays a description of the error.
• Import ID - If the transaction has been imported, this details the source document and time/date of import
• Lock - tick this column to lock an individual transaction
• Notes - a place to record any additional notes about this transaction
• Paid Date – the date on which this transaction was paid
• Payment Completed - Checking this column marks a transaction as ‘paid’ in the Statement table, and removes it
• Quantity - used when a transaction line comprises of multiples of the same item. Use in conjunction with the Unit Price and Unit Price Less VAT fields)
• Transaction Number – an auto-generated number starting from 1 given to each transaction that should be written on to the source document that the transaction came from to aid later identification