Sales Transactions

Introduction

This is where all sales transactions are added, edited or deleted (hidden). Selling is what businesses are all about. Whether you sell goods (eg. you are in the retail trade and have a shop) or services (eg. you are a business consultant) all the money you receive from work you have done goes into this section.

Table Toolbar

Above the table are the following buttons:

• Select Current View Allows you to change the View that is currently in use by the table
• Toggle View Editor Panel Shows/hides the View Editor Panel
• 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)
• Insert Credit Note based on this sale - Inserts credit note transaction(s) based on the selected sale(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)
• More Actions - Opens a drop down menu of further transaction options (see below)
• 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)

More Actions

The More Actions button enables the user to complete the following actions to the selected transaction row(s):

• Select all rows associated with the same document
• Edit Document - Launches the document for editing
• Show associated Customer/Supplier - Launches the Customer Record for the customer associated with the transaction
• Copy selected transaction(s) - Inserts a copy of the selected transaction(s) into the table
• Insert new Credit(s)based on the selected row(s) - Inserts Credit transaction(s) based on the selected row(s) into the table
• Create invoice document for selected row(s) - creates a new invoice for the selected transaction row(s)
• Create credit note document for selected row(s) - creates a new credit note document for the selected transaction row(s)
• Delete selected transaction(s) - deletes the selected transaction(s)

Default Columns

By default this table displays the following columns:

• Multiple Select - enables the user to select (and therefore copy/delete) multiple transactions
• Tax Date – the date of the transaction for tax purposes
• Customer/Supplier – if this entry is associated with a customer or supplier their name will appear here
• Reference – a reference value for the current transaction/entry
• From Account – where the money came from (a sales account for a sale, a payment account for a purchase or, say, a bank for a transfer)
• To Account – where the money went to (the bank if a sale, some expense account if a purchase or some other monetary account if a transfer, eg. VAT Control if you are paying your VAT Return)
• Total Amount – the full total of the transaction
• VAT Amount – see the previous entry (VAT can be edited manually if it is different from the auto-calculated amount)
• VAT Code – the VAT code associated with this transaction (eg. S for Standard rate VAT), when a code is entered, the VAT is automatically calculated
• Amount less VAT – the net amount after VAT has been deducted
• Amount less VAT – the net amount after VAT has been deducted
• Sales Amount - Shows all sales transactions for this customer which have the ‘Paid’ field unchecked in the Sales Tab
• Description – any descriptive text
• VAT Date - the date used for the relevant VAT return period

Hidden Columns

Below is a list of columns that are hidden by default but are available to be added:

• Cleared (From) – represents the ‘from’ side of the transaction as being cleared or not
• Cleared (To) – represents the ‘to’ side of the transaction as being cleared or not
• Currency Amount - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the equivalent amount to Total Amount in the chosen foreign currency (as defined in the Currency Code column)
• Currency Amount Less VAT - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the equivalent amount to Amount Less VAT in the chosen foreign currency (as defined in the Currency Code column)
• Currency Code - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the 3 character currency code of the chosen foreign currency
• Currency Rate - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the exchange rate to use when converting between the native and chosen foreign currency (as defined in the Currency Code column)
• Currency Unit Price - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the equivalent amount to Unit Price in the chosen foreign currency (as defined in the Currency Code column)
• Currency Unit Price Less VAT - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the equivalent amount to Unit Price Less VAT in the chosen foreign currency (as defined in the Currency Code column)
• Currency VAT Amount - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information – the equivalent amount to VAT Amount in the chosen foreign currency (as defined in the Currency Code column)
• 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
• Delivery – represents the chosen delivery address for the selected Customer
• 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
• Product - This component is only available in the Business Suite version of Business Accountz. Please visit accountz.com for more information - the product item being bought/sold in this transaction
• 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)
• Show Customer - Double clicking this icon takes you to the customer’s entry in the Customer Records Component
• Unit Price - displays/sets the unit price for an item (use in conjunction with the Quantity field)
• Unit Price Less VAT - displays/sets the unit price (excluding VAT) for an item (use in conjunction with the Quantity field)