Chapter 3. Accounts and Categories

Table of Contents

Assets & Liabilities
Account Creation and Editing
The Ledger
Adjust Balance
Marking an Account as Closed
Categories
Category Creation and Editing
Budget
The Budget Month
The Accounts View

Assets & Liabilities

Eqonomize! does not differentiate between accounts for assets and liabilities, except that they are grouped differently in the account view and that liabilities support some special transactions for convenience.

Account Creation and Editing

To create an account use Add Account in the context menu, AccountsNew Account, or the corresponding button in the toolbar. You can also create a new account by selecting the top item in the accounts list when editing a transaction.

A window will open where you can enter the details of the account. Select the type of account, associated currency, enter a name, and specify the opening balance. The account types debt and credit card are used for liabilities, the rest for assets. The securities type represents special accounts that are the only ones that can be associated with securities and only supports security transactions. The opening balance represents the amount of money present in the account before any recorded transactions. This value should be negative for liabilities. You may optionally also enter a bank (or lender for loan) name and description.

You can also create a debt account using Add Loan. Here you will have the option to create the associated loan transaction at the same time. Notice that a positive debt value here represents a negative opening balance.

You may edit the properties of an account after it has been created by double-clicking the account name, or using Edit in the context menu or the Accounts menu.

The Ledger

The ledger shows all transactions to and from an account in chronological order. The ledger is accessed by double-clicking the change or balance column of an account in the account view, Show Transactions in the context menu, AccountsShow Ledger, or by clicking the corresponding button in the toolbar.

All transactions are shown in falling date order. The balance column shows the accumulated account value ⸺ the amount of money in the account after the transaction occurred. This may not be the exact same value as on the corresponding bank statement if the transaction order does not match exactly. You can edit or create transactions using the buttons to the right or by double-clicking a transaction.

Multiple accounts can not be shown simultaneously in the ledger. Switch between accounts using the drop-down list in the upper left corner of the window. To the right of this menu are buttons for saving the transaction list to a HTML file or a CSV file (can be opened in spreadsheet programs), or print it on paper.

Adjust Balance

If the account balance shown in Eqonomize! differs from the actual balance (in your wallet), and you are unable to find out what is wrong or missing (e.g. by comparing transactions with receipts or bank statements with the ledger), you will have the possibility the adjust the account balance (using Adjust balance in the Accounts menu or in the context menu of an account. When you enter the real value of the account in the dialog, an account balance adjustment transfer to a hidden balancing account is created to match the book value with the real value. This should be avoided, but may sometimes be necessary (usually for cash accounts).

Marking an Account as Closed

An account can be mark as closed using Close Account in the Accounts or context menu, or at the bottom of the dialog for account editing. The account will then be hidden from the account view when the change and balance values for the select period is zero. The closed account will be moved to the bottom section of account lists when editing transactions.

Categories

Incomes and expenses are organised in categories with associated budgets.

Category Creation and Editing

To create an account use Add Category in the context menu, AccountsNew Income/Expense Category, or the corresponding button in the toolbar. You can also create a new category by selecting the top item in the category list when editing an income or expense. Enter a name, and optionally a description, a parent category and/or monthly budget, in the window that appears and click OK.

Eqonomize! supports one level of subcategories (subcategories of subcategories are not supported). Subcategories can be created using Add Category in the context menu of a category or by selecting a parent category in the category edit dialog. Subcategories can also be moved to and from parent categories using drag and drop.

You may edit the properties of a category after it has been created by double-clicking the category name, or using Edit in the context menu or the Accounts menu.

Budget

A monthly budget can be associated with each category. This way you can continuously compare actual and planned expenses, and see how your current budget will affect your future wealth.

A budget is initially asked for when creating a category. Later you can update it from the budget tab at the bottom of the accounts view (affects the category currently selected in accounts list). If the budget has not been set for a month, the budget of the previous month is used.

You can choose to set budgets for only some categories. In the accounts list, budget and remaining budget (budget minus past and planned expenses/incomes) is displayed in the second column. If not all categories have a budget, the total remaining budget only summarises the categories with budget and thus does not include actual expenses or incomes from other categories.

A budget can also be set for each subcategory. If no budget is set for the parent category the sum of the value for subcategories with budgets will be displayed (the transactions of subcategories without a budget are excluded). It is possible to specify a budget for both each subcategory and the parent budget. This can be useful if you want to use a single budget for only some subcategories or if some transactions does not belong to a subcategory, but will be confusing if you set the parent budget to a value that is lower than the sum of the specified budgets of subcategories.

The Budget Month

The budget month by default starts on the first and ends on the last day of the calendar month. This can be changed using SettingsSet Budget Month. Only the first day of the budget month can be selected (the budget month will always be as long as the calendar month of the start date).

This will also affect how statistics are calculated and displayed. Months (and years) in charts and tables refers to the budget month. If the budget day is set to a value greater than 15, the budget month uses the name, and year, of the calendar month of the last the day of the budget month (if the first budget day is set to 25, the budget month that begins on December 25 2017, is referred to as January 2018), otherwise the calendar month of the start day is used.

The Accounts View

The accounts view displays a list of all accounts and categories, sorted alphabetically under assets, liabilities, incomes, and expenses. The rows for the main account/category types displays the sum of all accounts/categories below.

The list has four columns. The first simply displays the name of the account or category. The second does for categories display the budget for the selected period and what is left of the budget. Unless the Show partial budget option is checked, the budget (and remaining budget) is displayed for whole months, thus you can in the default mode see whats left to spend of the current monthly budget. The third column displays the change in value, while the last column displays the total value.

In the bottom of the accounts view, there is a box for period selection. The period controls within which dates statistics will be shown in the list. If the button for the from (start) date is unchecked, all transactions up til and including the to (end) date will be included. The third, Change, column displays the value of all transactions that occurred between the two dates – the change in total value from start to end date. The last column (Total) displays the total value of all transaction up til and including the end date, plus the initial balance for accounts. If from date is unset, change and total will be equal for all categories. For accounts the total represents the actual money present at the end date, and change, the profit (or loss in the case of liabilities) during the period.

By default, the period is set to run from the beginning of the current month to (including) current date. Thus, the current state of accounts and transactions so far during the month are shown. The four buttons to the right of the dates moves the entire period backwards or forwards a month or a year.

Values for future dates are based on budgets and scheduled transactions (whichever is greatest). An account can be designated as budget account (default for current accounts), meaning that budgeted incomes and expenses will be included in the statistics displayed for that account. Otherwise the budgeted amount will only be included in the values of the total assets item (thus it will not necessarily equal the sum of the values of each assets account).

Double-clicking an account or category in the list will result in a different action depending on type and column. The different actions are listed in the table below.

Table 3.1. Double-click actions for the account view

Column

Action for accounts

Action for categories

Account / Category

Edit Account (or expand/collapse list)

Edit Category (or expand/collapse list)

Remaining Budget

Open ledger

Edit budget

Change

Open ledger

Open expenses or incomes view with a filter for selected category

Total

Open ledger

Open expenses or incomes view with a filter for selected category and period


If you press Enter on the keyboard when a row is selected, it will result in the same action as if the last column was double-clicked.