Ledger Account

From NEOSYS User Support Wiki
Jump to navigationJump to search

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.

Additional Options

Additionally the following filters are available

  • Period or Dates: Leave the "Use financial period from settings" checkbox ticked, or uncheck and enter from and to periods to filter transactions
  • Format: Choose one format – detailed or simplified
  • Columns: Tick the the "Due Date" and "Dispatch Date" checkboxes if you wish to view the Due date and Dispatch Date columns. The due date and the dispatch date is picked from the voucher file.
  • Billing Analysis columns: Billing Analysis columns will appear automatically on Open Item accounts and Income/Cost accounts (although they are balance forward accounts). Choose Yes to force it on all other Balance Forward accounts and No to suppress it on reports of all account types.
  • Paging: Tick "Per A/c" checkbox if you want printout of each account on a different page. This options forces printing of header after each account.
  • Stationery: Choose stationery – Either pre-printed option which suppresses the header or blank option which forces the printing of header
  • Due Date: Choose due date. This is required if Account type "Overdue items only" is selected.
  • Subtotal by month: Tick the “Outstanding” checkbox if you wish to view the outstanding subtotaled by month
  • Contra Accounts: Choose contra accounts to include/exclude in the report
  • Journal Types: Choose a specific journal type to filter transactions that use it or leave it blank for all journal types
  • Include: Tick the "Unposted Vouchers" checkbox to include unposted vouchers in the report
  • Grouping: Tick the “By company ”checkbox to create a consolidated ledger account of multiple companies but transactions grouped by companies
  • 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.