Ledger Account: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
m (Changed sub headings format)
 
(15 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[image:LedgerAccount_2011.jpg]]
[[image:LedgerAccount_2011.jpg|center]]


==Ledger Account==
==Ledger Account==


NEOSYS Ledger Account screen generates a report listing transactions, filtered by account/s or ledger/s, period and various other filters the user can set on this screen.
NEOSYS Ledger Account is a powerful feature where a list of all transactions/items of an account or ledger can be generated for a period range of your choosing. This report also provides a wide range of filters such as Account Type, Currency, Output format, Journal Type, Tax Categories etc.


To take a quick basic ledger printout follow the steps below:
It is a quick method of checking the balance of any account or ledger and also helps to discover any discrepancies in your entries.


#Goto the Ledger Account screen under Menu>Finance>Ledger
A basic ledger printout can be generated following the steps below:
#Check Finance settings first [[File:Finance settings.jpg|center|frame]]
#*Click on "Change" button to change Finance settings.
#*Choose the period which will act as default if the checkbox under <b>Period or Dates:</b> is ticked.
#*In case of multiple companies in the installation, choose the correct company/companies. Choosing multiple companies gives a consolidated report
#*Check currency conversion settings. By default option is to leave currencies unconverted. You can choose to convert to base currency/1 single currency
#EITHER select single/multiple accounts OR single/multiple ledgers by manually entering account/ledger codes or using the search
#Check type of Ledger account selected for report. By default Movements during the period and Outstanding items at the end of the period is selected.                [[File:Ledger Account - jtypes.jpg|center|frame]]
#Click OK to generate the ledger printout


===Additional Options===
#Open the Ledger Account screen (Menu-> Finance-> Ledger -> Ledger Account)
#Click on 'Change' button to edit the Finance settings. [[File:Finance settings.jpg|center|frame]]
#*Enter a period range which be the default range if no other period or date range is entered in the Ledger Account screen.
#*Select a single or multiple companies, as required. 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 unconverted.
#Enter an account code or a ledger code manually or by Search. Multiple accounts/ledgers can be selected.
#Select the type of Account transactions/items that you want to view. By default, 'Movements during the period' and 'Outstanding items at the end of the period' are selected.
#Click OK to generate the printout.                [[File:Ledger Account - jtypes.jpg|center|frame]]


Additionally the following filters are available


*<b>Period or Dates:</b> Leave the "Use financial period from settings" checkbox ticked, or uncheck and enter from and to periods to filter transactions
===Ledger Account filters===
*<b>Format:</b> Choose one format – detailed or simplified
====Period or Dates====
*<b>Columns:</b> 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.
 
*<b>Billing Analysis columns:</b> Billing Analysis columns will appear automatically on Open Item accounts. Choose Yes to force it on Balance forward accounts and No to suppress it on reports of all account types.
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>Paging:</b> 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.
 
*<b>Stationery:</b> Choose stationery – Either pre-printed  option which suppresses the header or blank option which forces the printing of header
====Format:====
*<b>Due Date:</b> Choose due date  
 
*<b>Subtotal by month:</b> Tick the “Outstanding” checkbox if you wish to view the outstanding subtotaled by month
Choose to display a detailed or a simplified report.
*<b>Contra Accounts:</b> Choose contra accounts to include/exclude in the report
 
*<b>Journal Types:</b> Choose a specific journal type to filter transactions that use it or leave it blank for all journal types
Ledger Account: Used for internal purposes. Includes links to the voucher file.
*<b>Include:</b> Tick the "Unposted Vouchers" checkbox to include unposted vouchers in the report
 
*<b>Grouping:</b> Tick the “By company ”checkbox to create a consolidated ledger account of multiple companies but transactions grouped by companies
Statement of Account: Used for external purposes. Provides an official summary of an account.
*<b>Show Allocation:</b> Tick the “Show allocation” checkbox to show all allocations under the Details column
 
====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)====
 
NEOSYS provides several options for choosing the type of transactions to display.
 
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: Display entries/transactions that are pending allocation at the end of the selected period range.
 
Outstanding items at the beginning of the period: Display all unallocated entries/transactions from the beginning of the selected period range.
 
Open items: Display all transactions that include open item accounts, providing 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: Display 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====
 
Use this filter to either include or exclude any contra accounts from your report. Contra accounts are accounts with an opposite balance to the selected accounts.
 
====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 all companies selected with all the 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.

Latest revision as of 08:15, 4 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 can be generated for a period range of your choosing. 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 -> Ledger Account)
  2. Click on 'Change' button to edit the Finance settings.
    Finance settings.jpg
    • Enter a period range which be the default range if no other period or date range is entered in the Ledger Account screen.
    • Select a single or multiple companies, as required. 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 unconverted.
  3. Enter an account code or a ledger code manually or by Search. Multiple accounts/ledgers can be selected.
  4. Select the type of Account transactions/items that you want to view. By default, 'Movements during the period' and 'Outstanding items at the end of the period' are selected.
  5. Click OK to generate the printout.
    Ledger Account - jtypes.jpg


Ledger Account 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:

Choose to display a detailed or a simplified report.

Ledger Account: Used for internal purposes. Includes links to the voucher file.

Statement of Account: Used for external purposes. Provides an official summary of an account.

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)

NEOSYS provides several options for choosing the type of transactions to display.

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: Display entries/transactions that are pending allocation at the end of the selected period range.

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

Open items: Display all transactions that include open item accounts, providing 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: Display 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

Use this filter to either include or exclude any contra accounts from your report. Contra accounts are accounts with an opposite balance to the selected accounts.

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 all companies selected with all the 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.