Nominal Ledger

Nominal Ledger is the main tool of an accountant. It shows all transactions during the selected period.

• Date start and end - period of transactions.
• Account start and end - for filtering the accounts. It´s possible to select a list of accounts (with comma list on start field) or a range of accounts (first account on start and last account on end field).

Account start 0 and account end Z shows all accounts in use.

• Project - filters only transactions with selected project.
• + choose project fields - possible to filter by different project fields.

• Corr.Account - correspondent account of the transaction.
• Object - filters only transactions with selected object.
• Type - object level type.
• Language - language selection for the report.

• Change - it is possible to filter transactions by the change entered in the field. Options: is bigger than, is smaller than, equals, does not equal.
• Description - description from transactions headers or rows. It´s possible to use full description or just a keyword.
• Reference - transactions reference.
• Customer - customer code on transaction.
• + choose customer fields - possible to filter by different client fields.

• Sort1 - different ways to sort the report result (Time by default). Options: Type, Number, Time, Date, Debit, Credit.
• Sort2 - different ways to sort the report result, in addition to the first sorting (unsorted by default). Options: Type, Number, Time, Date, Debit, Credit.
  The sorting result may be different for Time + Number and Date + Number, because the time and transaction number may not be in the same order.
• Transaction - selection of transaction types.
• Supplier - supplier code on transaction.
• + choose supplier fields - possible to filter by different supplier fields.

• VAT code - Vat code filtering. Its possible to select one or all codes.
• w/o level(s) - excludes entries that have objects with a certain object level (number of the object(s) level must be entered).
• Currency - possible to filter transactions made in one currency. Exclusion and a comma list of currencies also work (USD,EUR and !USD,EUR).
• Subtotal - subtotals with selected option will be generated. Each subtotal consists of transactions , opening and closing balances. The report also shows unchanged account balances for the selected date range. Options - object, project, customer, supplier, VAT code and currecy.
• Datafield - finance account datafield.

• Show corr. acc. - show correspondent accounts of the accounts in the transactions.
• Only with balance - show only accounts with balance (works only together with “with change” option).
• Only sum - show only total sums (Beginning balance, total Debit, total Credit, total change and closing balance) of the accounts in selected period, without transactions.
• Mixed accounts - the result of the report is displayed by transactions, not by accounts. Accounts are mixed.
• With change - shows only accounts with change in selected period of time.
• Unbalanced - shows only unbalanced accounts.
• Levels - separates objects in entries by levels, that way it is easier to view data, search for errors, or process in excel.
• More info - brings out suppliers code + name, quantity and project code (if it isn't already selected from fine tuning) columns.

Pilt(1)

• Setting - for choosing user's personal settings.
• Excel table shortcut F12 or Alt+E - opens the generated report in Excel.

- It is often necessary to view a general ledger report for a period that contains more data than the user's browser can display. In this case, the data must be exported as a CSV file for post-processing in, for example, Excel or other data processing software.

Video (1)

Picture(2)

• Account start and Account end – allows to open the general ledger with a range of pre-filled accounts. For example start “0” and end “Z” opens a report of all accounts transactions.
• Show in base currency – adds a column to the report that shows the current base currency.
• Show # of attachments – adds the number of attachments attached to transaction to the report.
• PID info - adds PID from transaction to the report.
  An PID is generated for a fiscal transaction if the System settings> Fiscal Transactions have PID is “yes”
• Day last row is underlined – displays an underlined row after each days last row.
• Show object name – it is possible to enter comma-separated object levels numbers, which name will be displayed. Object name is displayed only when “levels” option is also selected in report.
• Show currency sums – shows the amounts under the second tab of the transaction lines.
• Show rate – shows the rate of the transaction line.
• Show indirect rate – exchange rate as provided by banks. It is 1/Directo rate.
• Show currency – shows transactions currency in report.
• Show date without time – shows transactions date in report without time.
• Show project – shows the project of the transactions in report.
• Show project name – shows the projects name of the transactions in report.
• Show subtotal without change – shows all subtotals that have balance (depending on the selection made in reports subtotal filter). Only beginning balance is displayed to those subtotal rows that hasn't got change.
• Show account name – shows account names, when option “mixed accounts” is selected in report.
• CSV file separator – data separator in CSV file. Options: tab or , (comma) or ; (semicolon).
• Currency – it is possible to show the report in EUR or EEK currency.

• Select supplier additional info fields – possible to add information from suppliers register. When additional columns are added, the information will be displayed in the transactions rows. The report cannot be filtered by these fields, but it can be used for post-processing in Excel, for example.

• Select client additional info fields - possible to add information from clients register. When additional columns are added, the information will be displayed in the transactions rows. The report cannot be filtered by these fields, but it can be used for post-processing in Excel, for example.

• Select project additional info fields - possible to add information from projects register. When additional columns are added, the information will be displayed in the transactions rows. The report cannot be filtered by these fields, but it can be used for post-processing in Excel, for example.

Nominal Ledgers fine tuning has show object name setting, where all object levels that names should be displayed in report, can be entered by comma separated list. Object name is displayed only when levels option is also selected in report.

Picture(3)

It is possible to add currency amount and exchange rate columns to the report from fine tuning.

Picture(4)

Those values are displayed only on transactions rows. There are no total values for these columns. If option only sum is selected, those columns wont appear.

Subtotal filter will generate subtotals with selected option. Each subtotal consists of transactions , opening and closing balances. The report also shows unchanged account balances for the selected date range.

Example: Subtotals by customer (partial excerpt from the report):

It is possible to reset balances from the past. To do this, a financial transaction must be created with desired date, for example, at the end of the year.

Example
Nominal Ledger shows project with balance:

Picture(5)

Next step is to generate a report with longer period and with filters such as the ones in the picture 6. The result shows which transactions the final balance consists of.

Picture(6)

Financial transaction resetting the balance:

Picture (7)

The F2 key in the Nominal Ledger window opens a new financial transaction.

If for example an object has been deleted, a warining will be displayed when the financial transaction is saved, but the transaction will still be saved.

If an account has a lot of transactions and there is a need to check only transactions that has closing balance for example by supplier. It is possible to choose Subtotal by Supplier and only with balance, then all suppliers that have closing balance 0 are excluded (only sum filter must also be chosen).

Example
Nominal Ledger with subtotal by Supplier and without only with balance option. Picture(8)

The same report with only with balance option
Picture(9)

Example from Nominal Ledger, account has turnovers with and without objects: Picture(10)

Pilt(11)

Use character thats in System settings > Character to search empty field

Picture(12)

Nominal Ledger report in base currency (EUR) Picture(13)

Option subtotal by currency shows transaction rows with different currencies converted into the base currency. Picture(14)

Option subtotal by currency with Currency filter shows by currencies their beginning balance, turnovers and ending balance in nominal value. Picture(15)