Transactions income & expense accounting

Documentation •
In this article

Income and expense transactions are entered into the Transactions table, which is the central hub for accounting purposes. In this table, transactions are always visible and in perfect order, providing a clear overview and keeping everything under control. Additionally, all entered data can be modified and corrected at any time.

The columns of the Transactions table

The main columns of the Transactions table are listed below. The display of the columns changes according to the selected View.

You can add additional system columns as well as your own columns via Data > Columns setup.

Income / Expense transactions

Date
Enter the date of the incoming or outgoing transaction

Doc
A Doc number is entered. Usually, the document number identical to the paper document is assigned; this allows you to easily retrieve the documents after some time.

Description
Enter a description to identify the incoming or outgoing transaction.

Income
Enter the incoming amount.

Expenses
Enter the outgoing amount.

Account
Enter the estate accounts (cash, bank, post office, customers, suppliers ..)

  • If it is an income the amount should be recorded as a positive on the account.
  • If it is an expense the amount should be recorded as a negative on the account.

Category
Enter the reason for the income or expense; it can be an income or expense category, defined in the Categories table, or an account present in the Accounts table.

  • Entering a category:
    This is used to attribute income or expense to an item. The sign of the Category follows the sign of the account.
    • If it is an income, the amount should be recorded as a positive.
    • If it is an expense, the amount should be recorded as a negative.
  • Entering an account:
    It is used to transfer amounts from one asset account to another (e.g., withdrawals, deposits, ...). On the account entered in the Category column the amount is then entered the opposite way. The transaction functions as in double-entry accounting:
    • If it is an income, the amount should be recorded as a negative.
    • If it is an expense, the amount should be recorded as a positive.

Category Description
In this column, the description of the category, inserted in the Categories table, is automatically taken.
If in the Categories table the description of a category is modified, in order to visualize the new text in the Category Description column of the Transactions table, it is necessary to recalculate the accounting.

Entering Transactions

For every transaction, enter the date, document number, description, income or expense, the account and the category. There are different columns for entering transaction data:

  • Date: the date of the entry.
  • Doc.: the document number.
  • Description: the description of the transaction.
  • Income/Expenses: enter the amount coming in or going out.
  • Account: enter one of the Estate accounts (cash, bank, post, clients, suppliers...).
  • Category: the reason for the income or expense is entered, which could be a revenue or expense category or a contra account for asset movements.

After each entry, the amount is shown automatically in the account and category tab. In the category column, an account from a category or also an account from the Accounts table can be entered:

  •  If a category is entered in the Category column, the amount is recorded in the category as income and expense. 
  •  If an account is entered in the Category column, the amount is recorded in reverse (with the sign reversed). If it is outgoing instead as positive. In this way, transactions can be made between two asset accounts (as in the case of a transfer).
  • On the other hand, it is not possible to make transactions in and out of two categories with one entry.
    It is necessary to use two lines of entry, without using the Account column, with the first line in and the second line out.

It is also possible to record compound transactions, exit from an account with several categories. In this case, several lines are used: on the first line the account without category is recorded and on the following lines the categories and without account are recorded.

The Income and Expense Accounting allows to manage operations in a similar way to the Double-entry accounting, except for movements between two Categories that require two entry rows.

Speeding up the recording of Transactions

In order to accelerate the recording of the Transactions, you can use the following functionalities:

Recording expenses or income

When recording a movement, the Account column should indicate:

  • in the Account column, the account from which the amount enters or exits;
  • in the Category column, the expense or income category.

In the Account/Category card, the amount will be recorded in positive if it is an income and in negative if it is an expense.

Movements between estate accounts

In the Category column it is possible to enter an estate account as well, present in the Accounts table.

For example, in order to record an income in the Cash from a withdrawal on the bank, the transaction is done as follows:

  • In the Income column, the incoming amount is entered.
  • In the Account column the Cash account is entered.
  • In the Category column the Bank account is inserted.

The program will record the amount in positive into the Cash account and in negative into the Bank account.

Thanks to this recording mode, you can record on a single row any direct movement between two estate accounts, as for double entry (see example in the image above, first transaction).

Transactions between asset accounts

In the Category column, it is also possible to enter an asset account, present in the Accounts table.

For example, to record an entry into the cash account from a bank withdrawal, the entry is made as follows:

  • Enter the incoming amount in the Income column.
  • Enter the Cash account in the Account column.
  • Enter the Bank account in the Category column.

In this case, the program will record the amount positively in the Cash account (which increases) and negatively in the Bank account (which decreases).

Thanks to this recording method, any direct movement between two asset accounts can be recorded on a single registration line, as in double-entry bookkeeping (see example in the image above, first transaction).

Transactions with multiple movements

When you need to record a transaction that is to be split across multiple accounts or categories, you must enter multiple rows of transactions.

Below we show an example (see registration Doc. 11).
Multiple bills are paid through the bank.

multiple income / expense transactions

  • Enter the same date and document number in all the rows that affect the same transaction. This allows you to easily locate a transaction with multiple entries.
  • In the first row, enter the total amount in the Expenses column if it is a payment, or in the Income column if it is deposit.
  • In the Account column, enter the liquidity account (account through which you pay or collect). The Category column in the first row remains empty.
  • In the following rows, enter the amount of the invoice paid or collected on each row (the Expenses column or the Income column),
    Each invoice will be entered on a separate row.
    The Account column remains empty.
  • In the Category column, enter the category for each row to identify the entry or entry of the movement.

 Examples of transactions with VAT

In order to manage transactions with VAT, it is necessary to have set up an Income / Expense template with VAT options.

Income / Expense transactions with VAT

Additional columns for VAT

Depending on the type of Income / Expense accounts setup (with or without VAT) there are additional columns where VAT data is entered.

VAT Code
Enter the VAT code referring to a sale or a cost. There must be a code in the VAT Codes table.

Refer to the Transactions with VAT page for explanations of VAT codes and further information.

Account and category card

In the account or category card, the presentation of the transactions is very similar to the ones of the Transactions table.

If you enter further transactions or make changes (always operated in the Transactions table), you can update the account/category card by clicking the Refresh icon on the right side of the screen.

Income/Expense a count card

help_id
incomeexpense::transactions
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.

Share this article: Twitter | Facebook | LinkedIn | Email