Setting up and Configuring NEOSYS Finance System: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
 
(26 intermediate revisions by 6 users not shown)
Line 16: Line 16:
=== Configuring Financial year for new clients  ===
=== Configuring Financial year for new clients  ===


For configuring the start of a new financial year for new client setups, we need to go to:
For configuring the start of a new financial year while setting up a new Company, we need to go to:
Menu > Finance > Companies and enter the relevant number in the field - Financial Year.
Menu > Finance > Files > Company File and enter the relevant number in the field - Financial Year Starts.


The Financial year can be either
This MUST be done initially BEFORE posting any transactions into the system. If this is changed after posting any transactions, then it can cause confusion and various reports to show unexpected results.


1 - starts January to December
====Standard Financial Period====
or
4 - starts April to March


This has to be done initially before posting any transactions into the system.
The vast majority of companies financial year starts in 1st January and has 12 financial periods starting and stopping on the international calendar months.


NEOSYS also supports in ACCOUNTS ONLY mode non-standard financial periods as follows:
====Calendar month periods not starting January====
For example "7" means that the financial year starts on 1st July and consists of 12 financial periods starting and stopping on the international calendar months. Period 12 is 1-30 June in the following year.
You can get a table of the exact dates of each period from Maintenance mode Menu (F10), Finance, Company File, F6
[[File:accountperiods.jpg]]
====Weekly periods====
For example "13X4WEEK,1/7,5" means that the financial year is divided into 13 periods of 4 weeks each and starts after the Friday (5) nearest to the 1st July (1/7)


=== Posting transactions ===
=== Posting transactions ===
Line 40: Line 49:
Likewise 12/2007 would be March, 2008 and respectively for every consecutive year.
Likewise 12/2007 would be March, 2008 and respectively for every consecutive year.


== Creating New Charts or Control Accounts==
If clients ask to make any changes to the top level chart of accounts, then look at how the same item is handled in other clients especially those with skilled accountants, remembering that any single other client may be done badly or not optimally and support staff should not propagate anything less than the best practice.
Once you decide the best and truly correct way to handle this then also get it into Startup Database so that the request to add such an item does not come again in the future.
Editing top level chart of accounts MUST always be done by Support and MUST know what they are doing (such as creating new control accounts in GL & PL), since they can create an irrecoverable mess unless they know what they are doing because after financial postings are made to accounts they cannot be deleted, nor can control accounts be converted to real accounts or vice versa.
Creating new ledgers in Chart of Accounts MUST always be done by Support and clients can describe how they want it. This is because any unskilled client with this access can easily create a mess which could be irreversible.


== Configuring NEOSYS to convert Foreign Currency to Base Currency ==
== Configuring NEOSYS to convert Foreign Currency to Base Currency ==
Line 57: Line 75:
[[Image:foreignCurrency1.jpg]]
[[Image:foreignCurrency1.jpg]]


== How to copy cheque layouts ==
==[[Cheque_Design_and_Printing|Cheque Design and Printing]]==


Cheque layouts are designed in NEOSYS per bank account.
== Configuring Finance Email Alerts ==


There is no way in the normal user interface to copy layouts from one account to another but it can be done in maintenance mode.
=== Collections ===


=== Designating one bank account as the default layout for all other accounts ===
The NEOSYS Collections File allows you to record and manage activities such as telephone calls and emails etc related to the collection of debts from accounts receivables.


Check the "Use as default" checkbox in the cheque design screen of the bank that you want to be the default.
This section explains how to get NEOSYS to email and alert you when collection activity is due. Specifically it lists records from the Collection File where the "next action date" falls between 30 days ago and today. If there is nothing due for action then no email is sent.


Any bank accounts that do not have specific cheque layout designs will then use the designated default account.
For example to create an alert known as COLL01 that runs at 8pm, 12noon and 5pm that runs with the privileges of user STEVE and is emailed to STEVE, JIM and JOAN, issue the following command in maintenance mode/F5.


If no bank account is designated as the default then, if it exists, the cheque design of account XXX999 will be used as the default.
CREATEALERT COLL01 FINANCE COLLECTION 8,12,17 STEVE JIM,JOAN,STEVE


=== To copy a cheque design from bank account XXXX to YYYY ===
More information on Creating Alerts: [[NEOSYS_General#Creating_Email_Alerts_in_NEOSYS | Creating Email Alerts]]


In maintenance mode:
== Setting up Share Capital Accounts ==
“Share/Capital” is an account in the liabilities section of the chart of accounts. It represents the nominal value of shares that have been issued to shareholders. It might help to think of the balance of the account as a kind of debt repayable to the shareholders in case of liquidation of the company - in return for their initial provision of “capital” in the form of cash and assets to start the company up. In practice, the breakdown of the balance of the account per shareholder really indicates what percentage of the company the shareholders “own” … and their share of any profits or dividends.


COPY DEFINITIONS CHEQUEDESIGN*XXXX (O) TO: CHEQUEDESIGN*YYYY
In NEOSYS the Share/Capital account is typically setup as a control a/c in the Chart of Accounts of the General Ledger. Its subsidiary chart of accounts represents the share holders either individually or as blocks of shareholders or in total. Individual shareholders of course may be corporate entities themselves.


=== Copying cheque layouts between databases on the same NEOSYS installation ===
In a multi-company setup there are likely to be significant interrelated stock holdings – either existing or in the future. It is probably best to have one common subsidiary chart of accounts under the Share/Capital control A/c for all (or at least most) companies or legal entities in NEOSYS. NEOSYS can then produce consolidated and/or comparative financial statements showing stock holdings across all or selected entities.


To copy a cheque design from bank account XXXX in database A to YYYY in database B.
== Financial Report Design ==
NEOSYS Financial statements design splits the design of COLUMNS and design of ROWS into separate issues.


Step 1. In maintenance mode of database A:
*Design of COLUMNS is done per financial statement in NEOSYS, Finance, REPORTS, Financial Statements, New/Edit
*Design of ROWS is done per chart of account in NEOSYS, Finance, LEDGERS, Report Design


COPY DEFINITIONS CHEQUEDESIGN*XXXX (O) TO: (DOS DESIGN1.CQD)
=== Rows ===


Step 2. In maintenance mode of database B:
It is quite fiddly and hard to setup all the indented levels and subtotals in the chart in Financial Report Design for a typical P&L Statement. The model database P&L Chart of Accounts should be setup OK but might require modification.


COPY DOS DESIGN1.CQD (O) TO: (DEFINITIONS CHEQUEDESIGN*XXXX)
Sections can be very large (i.e. the subtotal is far away from the section heading) and have many levels of *nested* subsections like Russian dolls.


Notes:
Note that the subtotals that appear in the output do not actually appear in the chart since they are determined automatically by how you setup the section heading line. The titling and under/over lining of the subtotals is determined on the section heading line.


#(O) is optional and is required only if you are overwriting the target
[[image:sec-sub-titles.jpg]]
#DESIGN1.CQD can vary to allow copying multiple formats at the same time but "DESIGN1" must be no more than 8 alphanumeric characters and ".CQD" must be exactly ".CQD" otherwise there is risk of damaging the NEOSYS installation files.


=== Copying cheque layouts between NEOSYS installations ===
=== Columns ===


Use the instructions as for "Copying cheque layouts between databases on the same NEOSYS installation" but add the following step between the two steps.
To learn how to design a multi-financial year P&L Financial Statement see [[Designing_a_multi-financial_year_P%26L_Financial_Statement|Designing a multi-financial year P&L Financial Statement]]


Use operating system facilities copy the DESIGN1.CQD file(s) from the x:\neosys\neosys folder on the source installation to the same folder on the target installation.
==== Exchange rate and Unit Cost columns ====


== Configuring Finance Email Alerts ==
Column's Information Type: should be "Divide 2 previous columns". This is useful to show ratios such as exchange rates and unit costs.
 
*If the column title contains the word "exch" then the number of decimal places will be six.
*If the column title contains the word "cost" then the number of decimal places shown will be 3
 
=== Controlling bracketing of amounts in NEOSYS Financial Reports ===
 
By convention, high level financial reports show all figures as plain numbers without any arithmetic sign or indication of Dr/Cr EXCEPT where the amount is the opposite (negative) of what is expected. Where the amount is the opposite of what is expected then the numbers are surrounded by brackets in the report.
 
Sometimes the title next to the number will indicate what the brackets mean. For example the title might say "Profit/(Loss)" which gives the reader a clue that that plain amounts (those without brackets) are profit and any figures in brackets indicate losses.
 
Use NEOSYS Report Design screen, Column:  "Normally Dr/Cr" to control per chart section what is expected (Dr/Cr) and therefore what amounts will have brackets on them.


=== Collections ===
If you have indented sections within sections set the debit/credit for the main section and it will be effective for all the subsections


The NEOSYS Collections File allows you to record and manage activities such as telephone calls and emails etc related to the collection of debts from accounts receivables.
=== Controlling section titles and subtotal titles ===


This section explains how to get NEOSYS to email and alert you when collection activity is due. Specifically it lists records from the Collection File where the "next action date" falls between 30 days ago and today. If there is nothing due for action then no email is sent.
NEOSYS Report Design allows you to specify the section title (which shows at the top of the section) and the section subtotal title (which shows at the end of the section). If the subtotal title is omitted from the report design then the section title is used.


For example to create an alert known as COLL01 that runs at 8pm, 12noon and 5pm that runs with the privileges of user STEVE and is emailed to STEVE, JIM and JOAN, issue the following command in maintenance mode/F5.
Many financial reports omit the section title at the top and only label the subtotal at the bottom. To accomplish this, move the section title to the subtotal title column (where indentation is not significant) and leave only a dot (.) in the section title to indicate the indenting of sections and subtotals


  CREATEALERT COLL01 FINANCE COLLECTION 8,12,17 STEVE JIM,JOAN,STEVE
=== Typical Report Design for a P&L Chart of Account/Report ===


== Setting up Share Capital Accounts ==
NEOSYS relies on indentation to determine what sections there are in a chart of accounts and therefore where subtotals show in a report.
===Share/Capital Account in NEOSYS===
“Share/Capital” is an account in the liabilities section of the chart of accounts. It represents the nominal value of shares that have been issued to shareholders. It might help to think of the balance of the account as a kind of debt repayable to the shareholders in case of liquidation of the company - in return for their initial provision of “capital” in the form of cash and assets to start the company up. In practice, the breakdown of the balance of the account per shareholder really indicates what percentage of the company the shareholders “own” … and their share of any profits or dividends.


In NEOSYS the Share/Capital account is typically setup as a control a/c in the Chart of Accounts of the General Ledger. Its subsidiary chart of accounts represents the share holders either individually or as blocks of shareholders or in total. Individual shareholders of course may be corporate entities themselves.
Typically for a Profit and Loss chart the whole chart has a single master controlling section titled "Net Profit/(Loss)" and this section is marked as "Normally Credit". The purpose of the single master controlling section is to get a grand total for the whole P&L at the bottom of the report (titled "Net Profit/(Loss)") and which represents income less costs, less overheads.


[[image:shareholderscapital-gl.jpg]]
*PROFIT/(LOSS) (normally credit)
**REVENUE
***INCOME
***COSTS (normally debit)
**OVERHEADS or EXPENSES (normally debit)
***CATEGORY 1
***CATEGORY 2
***etc


=== Difference in Single & Multiple Company Setup ===
Within the single master controlling section are typically two subsections.
In a multi-company setup there are likely to be significant interrelated stock holdings – either existing or in the future. It is probably best to have one common subsidiary chart of accounts under the Share/Capital control A/c for all (or at least most) companies or legal entities in NEOSYS. NEOSYS can then produce consolidated and/or comparative financial statements showing stock holdings across all or selected entities.


'''''Single Company Capital Employed Ledger Setup'':'''
The REVENUE section commonly has two further subsections INCOME and COSTS. The total of the revenue section (ie the net of INCOME less COSTS) is typically titled something like "Gross Profit/(Loss)"


[[image:shareholderscapital-sci.jpg]]
The OVERHEADS section usually has further subsections to group the various categories of expenses.


Since the master controlling section is set to NORMALLY CREDIT then you will want to set the COSTS and OVERHEADS sections to NORMALLY DEBIT otherwise you will see brackets on all the cost and overhead accounts since they are normally debits.


'''''Multi Company Capital Employed Ledger Setup'':'''
It is unnecessary and wrong to set individually each subsection of the COSTS and OVERHEADS sections to NORMALLY DEBIT since setting the COST and OVERHEAD controlling sections will automatically set all their subsections to NORMALLY DEBIT. Indeed it would be confusing for future maintainers of the system, so do the proper thing and don't take short cut bodges that solve your problem today but make double work in future to work out what bodges have been made.


[[image:shareholderscapital-mci.jpg]]
Additional sections may be imposed between the above subsections where the structure of the business reporting is more complex. For example there may be sections "Net Profit/(Loss) Before Taxes" and "Taxes" imposed directly under the "Net Profit/(Loss)" section.

Latest revision as of 07:06, 26 February 2020

Financial Reports Access

Configuring access based on Charts

Inorder to block access of other users in a group to not to able to do Financial Reports on certain ledgers, we can configure the Authorisation File for the same:

Menu > Support > Authorisation File

Add task id - FINANCIAL REPORT ACCESS "GL" (where GL is the chart code you want to lock)
Give suitable Lock
Add this lock as a key to the persons who are authorised to access Financial Reports for GL


Financial year

Configuring Financial year for new clients

For configuring the start of a new financial year while setting up a new Company, we need to go to: Menu > Finance > Files > Company File and enter the relevant number in the field - Financial Year Starts.

This MUST be done initially BEFORE posting any transactions into the system. If this is changed after posting any transactions, then it can cause confusion and various reports to show unexpected results.

Standard Financial Period

The vast majority of companies financial year starts in 1st January and has 12 financial periods starting and stopping on the international calendar months.

NEOSYS also supports in ACCOUNTS ONLY mode non-standard financial periods as follows:

Calendar month periods not starting January

For example "7" means that the financial year starts on 1st July and consists of 12 financial periods starting and stopping on the international calendar months. Period 12 is 1-30 June in the following year.

You can get a table of the exact dates of each period from Maintenance mode Menu (F10), Finance, Company File, F6

Accountperiods.jpg

Weekly periods

For example "13X4WEEK,1/7,5" means that the financial year is divided into 13 periods of 4 weeks each and starts after the Friday (5) nearest to the 1st July (1/7)

Posting transactions

While posting transactions, there is a field 'Period' which actually means Financial Period.

There is nothing to worry about this while posting transactions for January to December.

But when you are posting transactions under April to March, you need to take special care here. The period should be 1/2007 for the 1st month of the financial period i.e. April, 2007 or 2/2007 for May 2007 and so on.

Likewise 12/2007 would be March, 2008 and respectively for every consecutive year.

Creating New Charts or Control Accounts

If clients ask to make any changes to the top level chart of accounts, then look at how the same item is handled in other clients especially those with skilled accountants, remembering that any single other client may be done badly or not optimally and support staff should not propagate anything less than the best practice.

Once you decide the best and truly correct way to handle this then also get it into Startup Database so that the request to add such an item does not come again in the future.

Editing top level chart of accounts MUST always be done by Support and MUST know what they are doing (such as creating new control accounts in GL & PL), since they can create an irrecoverable mess unless they know what they are doing because after financial postings are made to accounts they cannot be deleted, nor can control accounts be converted to real accounts or vice versa.

Creating new ledgers in Chart of Accounts MUST always be done by Support and clients can describe how they want it. This is because any unskilled client with this access can easily create a mess which could be irreversible.

Configuring NEOSYS to convert Foreign Currency to Base Currency

By default, the NEOSYS installation allows only a single currency to operate from the Finance System. Incase you do enter any foreign currency and expect the system to auto-calculate the amount to a base currency, you need to configure the Exchange & Coversion A/c details.

Error while using foreign currency in the finance system

ForeignCurrency.jpg

Before configuring the Exchange & Coversion A/c details, you will get a message saying: "COMPANY NAME is setup for AED currency only" (wherein AED would mean any base currency used in the system.

Configuring the use of foreign currency in the finance system

To enable the system to accept foreign currencies and to auto-calculate the amounts to the base currencies, you need to configure the Company File with the Exchange A/c No. and the Conversion A/c No. which is usually 982 and 982B in the chart of accounts:

ForeignCurrency1.jpg

Cheque Design and Printing

Configuring Finance Email Alerts

Collections

The NEOSYS Collections File allows you to record and manage activities such as telephone calls and emails etc related to the collection of debts from accounts receivables.

This section explains how to get NEOSYS to email and alert you when collection activity is due. Specifically it lists records from the Collection File where the "next action date" falls between 30 days ago and today. If there is nothing due for action then no email is sent.

For example to create an alert known as COLL01 that runs at 8pm, 12noon and 5pm that runs with the privileges of user STEVE and is emailed to STEVE, JIM and JOAN, issue the following command in maintenance mode/F5.

CREATEALERT COLL01 FINANCE COLLECTION 8,12,17 STEVE JIM,JOAN,STEVE

More information on Creating Alerts: Creating Email Alerts

Setting up Share Capital Accounts

“Share/Capital” is an account in the liabilities section of the chart of accounts. It represents the nominal value of shares that have been issued to shareholders. It might help to think of the balance of the account as a kind of debt repayable to the shareholders in case of liquidation of the company - in return for their initial provision of “capital” in the form of cash and assets to start the company up. In practice, the breakdown of the balance of the account per shareholder really indicates what percentage of the company the shareholders “own” … and their share of any profits or dividends.

In NEOSYS the Share/Capital account is typically setup as a control a/c in the Chart of Accounts of the General Ledger. Its subsidiary chart of accounts represents the share holders either individually or as blocks of shareholders or in total. Individual shareholders of course may be corporate entities themselves.

In a multi-company setup there are likely to be significant interrelated stock holdings – either existing or in the future. It is probably best to have one common subsidiary chart of accounts under the Share/Capital control A/c for all (or at least most) companies or legal entities in NEOSYS. NEOSYS can then produce consolidated and/or comparative financial statements showing stock holdings across all or selected entities.

Financial Report Design

NEOSYS Financial statements design splits the design of COLUMNS and design of ROWS into separate issues.

  • Design of COLUMNS is done per financial statement in NEOSYS, Finance, REPORTS, Financial Statements, New/Edit
  • Design of ROWS is done per chart of account in NEOSYS, Finance, LEDGERS, Report Design

Rows

It is quite fiddly and hard to setup all the indented levels and subtotals in the chart in Financial Report Design for a typical P&L Statement. The model database P&L Chart of Accounts should be setup OK but might require modification.

Sections can be very large (i.e. the subtotal is far away from the section heading) and have many levels of *nested* subsections like Russian dolls.

Note that the subtotals that appear in the output do not actually appear in the chart since they are determined automatically by how you setup the section heading line. The titling and under/over lining of the subtotals is determined on the section heading line.

Sec-sub-titles.jpg

Columns

To learn how to design a multi-financial year P&L Financial Statement see Designing a multi-financial year P&L Financial Statement

Exchange rate and Unit Cost columns

Column's Information Type: should be "Divide 2 previous columns". This is useful to show ratios such as exchange rates and unit costs.

  • If the column title contains the word "exch" then the number of decimal places will be six.
  • If the column title contains the word "cost" then the number of decimal places shown will be 3

Controlling bracketing of amounts in NEOSYS Financial Reports

By convention, high level financial reports show all figures as plain numbers without any arithmetic sign or indication of Dr/Cr EXCEPT where the amount is the opposite (negative) of what is expected. Where the amount is the opposite of what is expected then the numbers are surrounded by brackets in the report.

Sometimes the title next to the number will indicate what the brackets mean. For example the title might say "Profit/(Loss)" which gives the reader a clue that that plain amounts (those without brackets) are profit and any figures in brackets indicate losses.

Use NEOSYS Report Design screen, Column: "Normally Dr/Cr" to control per chart section what is expected (Dr/Cr) and therefore what amounts will have brackets on them.

If you have indented sections within sections set the debit/credit for the main section and it will be effective for all the subsections

Controlling section titles and subtotal titles

NEOSYS Report Design allows you to specify the section title (which shows at the top of the section) and the section subtotal title (which shows at the end of the section). If the subtotal title is omitted from the report design then the section title is used.

Many financial reports omit the section title at the top and only label the subtotal at the bottom. To accomplish this, move the section title to the subtotal title column (where indentation is not significant) and leave only a dot (.) in the section title to indicate the indenting of sections and subtotals

Typical Report Design for a P&L Chart of Account/Report

NEOSYS relies on indentation to determine what sections there are in a chart of accounts and therefore where subtotals show in a report.

Typically for a Profit and Loss chart the whole chart has a single master controlling section titled "Net Profit/(Loss)" and this section is marked as "Normally Credit". The purpose of the single master controlling section is to get a grand total for the whole P&L at the bottom of the report (titled "Net Profit/(Loss)") and which represents income less costs, less overheads.

  • PROFIT/(LOSS) (normally credit)
    • REVENUE
      • INCOME
      • COSTS (normally debit)
    • OVERHEADS or EXPENSES (normally debit)
      • CATEGORY 1
      • CATEGORY 2
      • etc

Within the single master controlling section are typically two subsections.

The REVENUE section commonly has two further subsections INCOME and COSTS. The total of the revenue section (ie the net of INCOME less COSTS) is typically titled something like "Gross Profit/(Loss)"

The OVERHEADS section usually has further subsections to group the various categories of expenses.

Since the master controlling section is set to NORMALLY CREDIT then you will want to set the COSTS and OVERHEADS sections to NORMALLY DEBIT otherwise you will see brackets on all the cost and overhead accounts since they are normally debits.

It is unnecessary and wrong to set individually each subsection of the COSTS and OVERHEADS sections to NORMALLY DEBIT since setting the COST and OVERHEAD controlling sections will automatically set all their subsections to NORMALLY DEBIT. Indeed it would be confusing for future maintainers of the system, so do the proper thing and don't take short cut bodges that solve your problem today but make double work in future to work out what bodges have been made.

Additional sections may be imposed between the above subsections where the structure of the business reporting is more complex. For example there may be sections "Net Profit/(Loss) Before Taxes" and "Taxes" imposed directly under the "Net Profit/(Loss)" section.