The chart of accounts can be found in the Accounts section of the Administration menu. The chart of accounts includes profit and loss and balance sheet accounts and, possibly, auxiliary accounts related to reporting or calculation. In addition to these accounts, the chart of accounts contains the system accounts $ SysAccounts $, which are used for standard system reports and calculations.


Description of columns

Account Number column displays the account ID, which is usually the account number or account group name. This column can drilled down to the account group or account level by clicking the + signs. An account number can also consist of letters. However, it should be noted that a chart of accounts cannot have two identical account numbers.


Account Name column displays the account name. The name can be edited by double-clicking on the cell. 


Account Type column defines the account type for an account group or for an individual account. Account type affects grouping in Navita's standard reports.


View factor column determines whether the value of a group of accounts or an account is affected by a view factor on reports and input forms. By default, this setting is on for all profit and loss accounts and balance sheets. With auxiliary accounts (such as number of people or price), the setting can be turned off so that the value of the account remains the same, even if you want the report to show other values at a thousandth.


Operation column defines how the account group or account affects the top-level result. In the chart of accounts, the function of the expense account groups is negative, as they reduce the result for the financial year. Because the functions of the account groups are defined in the chart of accounts, the values of the income and expense accounts are entered on the input forms without a sign. Values entered with a minus sign are transactions that reduce income or expenses. 

  • + increases the account group balance
  • - reduces the account group balance
  • ~ does not affect the calculation of upper levels in any way
  • = subtotal of the rows above

Property column defines what types of values the values in the account group or account are.


Function                   Description

Money

The values are summed monthly, by account group and by organizational level
 

Quantity
 

Synonymous with monetary accounts
 

Amount
 

Values are not summed over time, but at the organizational level. For example, you do not want to add up the number of people each month, but you want to add up the cost centers.
 

Price (old)
 

Values are not summed over time or at the organizational level. The value remains the same until it is changed. The value is only stored at the level at which it was entered
 

Price

Values are not summed over time or at the organizational level and the value remains the same until it is changed. The value entered at the top level is inherited down to the cost centers. The value entered at the lower level is not inherited upwards.

Percent (old)
 

Displays the value as a percentage for both reports and input forms. The value remains the same until it is changed.
 

Percent

Displays the value as a percentage for both reports and input forms. The value remains the same until it is changed. The value entered at the top level is inherited down to the cost centers but the value entered at the lower level is not inherited upwards.
 

Default Values Type column indicates how the values are displayed in the reports by default.


Value type                     Description

Flow

Period change. This is commonly used with income accounts.
 

Closing balance

Shows the values of the closing balance sheet, which takes into account the opening balance sheet and the changes made to it during the financial year. This is commonly used in balance sheet accounts.
 

Opening balance
 

Shows balance sheet values at the end of the previous month.
 

Adjustment
 

The values only affect the result for the current month.
 

Period Cumulative
 

Cumulative values from the beginning of the financial year.
 

Year Cumulative
 

Cumulative values from the beginning of the year.


View Preferences column can be used to specify custom display settings, such as color, size, or font, for an individual account or group of accounts. These settings appear in all reports and input forms. 


Toolbar functions


Function                                                   Description

Add new account / Delete account

Add a new account or delete an old one

Move selected item / Move several accounts

Functions to move accounts in the chart of accounts.

Sort numeric accounts from selected row

Sorts all accounts within the selected row, or account group, in ascending numerical order.

Sort all numeric accounts

Sorts all accounts in the chart of accounts in numerical order.

Import

Function to import a new chart of accounts from an external Excel file to Navita.

Refresh

Refreshes the chart of accounts view.

Collapse All / Expand

Collapses or expands all groups.

Excel and Word icons

Prints the chart of accounts to either an Excel or Word file.

Run Maintenance

Updates changes made to the chart of accounts for Navita reports and input forms. If a maintenance operation is required, an exclamation mark flashes next to it.

Auto Run Maintenance

If this setting is on, the chart of accounts view will automatically update if changes are made to the chart of accounts.

Show system accounts

Shows or hides the $SysAccounts$ account group

Customize account names per organization

If there are multiple companies in the database that have accounts named differently from the default account map, this function can be used to add these names.

View previous conflicts

Displays errors in the chart of accounts.

Search in hierarchy

You can enter the account or group of accounts you are looking for directly in this field.