Customising the Transactions Table

文件资料 •

The Transactions table is the hub of accounting and can be customised to support a multitude of functions, such as entering quantities and prices, VAT, cost and profit centres and much more.

The table can be customised by displaying or adding columns, so that certain functions are only activated when needed.

Tabella Registrazioni

Default settings

The Transactions table is set up with standard columns, such as Date, Description, etc., which are already visible when the file is opened. The user can decide which columns to make visible and customise with the command from the menu Data > Columns setup.
There are specific columns for the type of file opened. For example, in double-entry accounting, there are Debit and Credit columns, whereas in Income and Expense accounting, there are Account and Category columns.

The columns common to all accounts are fully explained on the page Columns of the transactions table - Double-entry, as listed:

Here listed the columns only present in certain types of accounts:

Customising the display

You can adapt the table display to your specific needs, as follows:

Adding additional columns

You can add additional columns according to your needs. The options are:

Additional columns quantities and prices

You can enter quantities and prices directly in the accounting file.

Specific columns are displayed from the menu Tools > Add / Remove Functionality. The following columns are added in bulk:

  • Article identifier
    Which is linked to the Items table
  • Quantity. A numerical value
  • Unit price
  • Descriptive quantity.

If you enter a value in the quantity or price column, the programme automatically calculates the amount by multiplying the two values.

These columns can be used for various purposes:

  • Manage quantities and prices for cost accounting.
  • Specify the elements of an invoice.
  • Enter the movements of items indicated in the Items table or to manage the purchase and sale of securities (see Portfolio extension).

Link to the Items table

The Items table is a kind of mini-warehouse integrated into the accounting , where: 

  • You can enter the list of products, quantities and prices.
  • When you enter an item in a line in the transactions table, the programme automatically takes over the description and sales price.
  • If you enter transactions in the Transactions table by entering quantities, the programme updates the current quantity in the Items table.

Additional Payment Management Columns

They are added from the menu Tools > Add / Remove Functionality
Please refer to the explanation in the Payment Management page.

Additional columns end date, repeat

You can also add specific columns to insert automatic movements in the Recurring Transactions table.

They are added from the menu Tools > Add / Remove Functionalities
Please refer to the explanation Automatic Transactions.

Recurring Transactions table

The Recurring Transactions table has the same columns and arrangements as the Transactions table. If you change the display of columns in the Recurring Transactions table, this will also be changed in the Recurring Transactions table.

Tell us how we can help you better
If the information on this page is not what you're looking for, is not clear enough, or is not up-to-date, let us know.

分享这篇文章: Twitter | Facebook | LinkedIn | Email