Ledger Account: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
Line 20: Line 20:
===Available Filters :===
===Available Filters :===


*<b>Period or Dates:</b>
=====<b>Period or Dates:</b>=====
 
Choose to display transactions either by a range of dates or use the Period range entered in the Settings. Date range filters by the transaction dates entered in the Voucher file.
Choose to display transactions either by a range of dates or use the Period range entered in the Settings. Date range filters by the transaction dates entered in the Voucher file.


*<b>Format:</b>
=====<b>Format:</b>=====
 
Opt for either a detailed report which is mainly for internal usage or a simplified report for external purposes.
Opt for either a detailed report which is mainly for internal usage or a simplified report for external purposes.


*<b>Columns:</b>
=====<b>Columns:</b>=====
 
Choose to display 'Despatch Date', 'Approval Date' and 'Due Date'. The dates are generated from the Voucher file.
Choose to display 'Despatch Date', 'Approval Date' and 'Due Date'. The dates are generated from the Voucher file.


*<b>Billing Analysis columns:</b>
=====<b>Billing Analysis columns:</b>=====
 
Billing Analysis columns (eg: Client, Supplier, Type etc.) will appear automatically on Open Item accounts and Income/Cost accounts (although they are balance forward accounts). Choose 'Yes' to display on all account types or 'No' to suppress it on all types.  
Billing Analysis columns (eg: Client, Supplier, Type etc.) will appear automatically on Open Item accounts and Income/Cost accounts (although they are balance forward accounts). Choose 'Yes' to display on all account types or 'No' to suppress it on all types.  


*<b>Paging:</b>
=====<b>Paging:</b>=====
 
Tick the 'Per A/c' checkbox to force headers for each account on the report, treating each account as a separate page.
Tick the 'Per A/c' checkbox to force headers for each account on the report, treating each account as a separate page.


*<b>Stationery:</b>
=====<b>Stationery:</b>=====
 
Select the preferred form of output between html (with or without letterhead) and pdf (portrait or landscape).  
Select the preferred form of output between html (with or without letterhead) and pdf (portrait or landscape).  


*<b>Account type(s):</b>
=====<b>Account type(s):</b>=====
 
Choose between options to display required type of transactions.
Choose between options to display required type of transactions.


Line 62: Line 55:
Overdue items: Displays all transactions which are overdue past the Due date entered.
Overdue items: Displays all transactions which are overdue past the Due date entered.


*<b>Due Date:</b>
=====<b>Due Date:</b>=====
 
Enter a due date. A due date is required if Account type 'Overdue items only' is selected.
Enter a due date. A due date is required if Account type 'Overdue items only' is selected.


*<b>Subtotal by month:</b>
=====<b>Subtotal by month:</b>=====
 
View the outstanding subtotaled by month.
View the outstanding subtotaled by month.


*<b>Contra Accounts:</b>
=====<b>Contra Accounts:</b>=====
 
Contra accounts are accounts with an opposite balance to the selected accounts. Enter any contra accounts which is required to be included or excluded in the report.
Contra accounts are accounts with an opposite balance to the selected accounts. Enter any contra accounts which is required to be included or excluded in the report.


*<b>Journal Types:</b>
=====<b>Journal Types:</b>=====
 
Leave blank to display all journal types or choose a specific journal type to filter transactions by it.
Leave blank to display all journal types or choose a specific journal type to filter transactions by it.


*<b>Tax/VAT category(ies):</b>
=====<b>Tax/VAT category(ies):</b>=====
 
Select from list of tax codes to display only transactions that use the selected tax code(s).
Select from list of tax codes to display only transactions that use the selected tax code(s).


*<b>Include:</b>
=====<b>Include:</b>=====
 
Tick the "Unposted Vouchers" checkbox to include unposted vouchers in the report.
Tick the "Unposted Vouchers" checkbox to include unposted vouchers in the report.


*<b>Grouping:</b>
=====<b>Grouping:</b>=====
 
Tick the “By company ”checkbox to generate a consolidated report of the multiple companies selected with all transactions grouped by the Company.
Tick the “By company ”checkbox to generate a consolidated report of the multiple companies selected with all transactions grouped by the Company.


*<b>Show Allocation:</b>
=====<b>Show Allocation:</b>=====
 
Tick the “Show allocation” checkbox to show any allocations (eg invoices paid, receipts etc.) in the voucher details column. This reduces the need to type in details during journal data entry and also provides a wealth of additional information on ledger accounts that could previously only be seen by drilling down to the individual vouchers.
Tick the “Show allocation” checkbox to show any allocations (eg invoices paid, receipts etc.) in the voucher details column. This reduces the need to type in details during journal data entry and also provides a wealth of additional information on ledger accounts that could previously only be seen by drilling down to the individual vouchers.

Revision as of 07:33, 2 August 2021

LedgerAccount 2011.jpg

Ledger Account

NEOSYS Ledger Account is a powerful feature where a list of all transactions/items of an account or ledger for a period range can be generated. This report also provides a wide range of filters such as Account Type, Currency, Output format, Journal Type, Tax Categories etc.

It is a quick method of checking the balance of any account or ledger and also helps to discover any discrepancies in your entries.

A basic ledger printout can be generated following the steps below:

  1. Open the Ledger Account screen (Menu-> Finance-> Ledger)
  2. Click on "Change" button to edit the Finance settings.
    Finance settings.jpg
    • Enter a period range which will act as the default if no other period or date range is entered in the Ledger Account screen.
    • Select only the company/ies that you require. Choosing multiple companies gives a consolidated report.
    • The default option is to convert into base currency or a selected currency but you can also choose to leave it as unconverted.
  3. Enter an account code or a ledger code manually or by searching. Multiple accounts/ledgers can be entered.
  4. Select the type of Account transactions/items that you wish to view. By default, "Movements during the period" and "Outstanding items at the end of the period" are selected.
    Ledger Account - jtypes.jpg
  5. Click OK to generate the printout.

Available Filters :

Period or Dates:

Choose to display transactions either by a range of dates or use the Period range entered in the Settings. Date range filters by the transaction dates entered in the Voucher file.

Format:

Opt for either a detailed report which is mainly for internal usage or a simplified report for external purposes.

Columns:

Choose to display 'Despatch Date', 'Approval Date' and 'Due Date'. The dates are generated from the Voucher file.

Billing Analysis columns:

Billing Analysis columns (eg: Client, Supplier, Type etc.) will appear automatically on Open Item accounts and Income/Cost accounts (although they are balance forward accounts). Choose 'Yes' to display on all account types or 'No' to suppress it on all types.

Paging:

Tick the 'Per A/c' checkbox to force headers for each account on the report, treating each account as a separate page.

Stationery:

Select the preferred form of output between html (with or without letterhead) and pdf (portrait or landscape).

Account type(s):

Choose between options to display required type of transactions.

Movements during the period: Transactions that occur in the date or period range specified. Displays all details of the transactions.

Movements totalled by type of voucher: Same report as above but displays only the type of voucher and the total, suppressing the reference and the details.

Outstanding items at the end of the period: Displays entries/transactions that are pending allocation at the end of the selected period range.

Outstanding items at the beginning of the period: Displays all unallocated entries/transactions from the beginning of the selected period range.

Open items: Displays all transactions that include open item accounts. Provides an item-wise balance showing the transactions in the specified account and it's contra-account.

Open items (current period only): Same as above option but will display only transactions in the current period.

Overdue items: Displays all transactions which are overdue past the Due date entered.

Due Date:

Enter a due date. A due date is required if Account type 'Overdue items only' is selected.

Subtotal by month:

View the outstanding subtotaled by month.

Contra Accounts:

Contra accounts are accounts with an opposite balance to the selected accounts. Enter any contra accounts which is required to be included or excluded in the report.

Journal Types:

Leave blank to display all journal types or choose a specific journal type to filter transactions by it.

Tax/VAT category(ies):

Select from list of tax codes to display only transactions that use the selected tax code(s).

Include:

Tick the "Unposted Vouchers" checkbox to include unposted vouchers in the report.

Grouping:

Tick the “By company ”checkbox to generate a consolidated report of the multiple companies selected with all transactions grouped by the Company.

Show Allocation:

Tick the “Show allocation” checkbox to show any allocations (eg invoices paid, receipts etc.) in the voucher details column. This reduces the need to type in details during journal data entry and also provides a wealth of additional information on ledger accounts that could previously only be seen by drilling down to the individual vouchers.