SETTINGS

The Chart of Account is where the user can create account codes to be used in the system. The account codes can be classified into Assets, Liabilities, Income or Expense, as well as be grouped into various levels when designing layout of financial reports such as Balance Sheet.
In order to start using Uniq365, some basic Chart of Accounts such as the GST and Currency Codes must be created.

HERE IS VIEW OF LISTING OF CHART OF ACCOUNT-

• SEARCH - to search code by keying in 'description' for purpose of edit.
• ACTIVE - click to show only active codes, 'INACTIVE' to show all inactive codes or 'ALL' to show both active and inactive.
• CHANGE AUDIT TRAIL - to generate report of changes done in chart of account,
• NEW - click to add new code,
• EXPORT EXCEL - to generate the listing in excel format,
• EXPAND - to expand,
• COLLAPSE - to collapse.

HOW TO ADD NEW CHART OF ACCOUNT CODE?

• ACCOUNT - Enter a code for this Chart of Account. The maximum is 12 alpha-numeric characters.

• NAME -  Enter the description for this Chart of Account e.g. Sales Revenue Account. The maximum length allowed is 40 characters.

• ACCOUNT TYPE - Click to select account type. The 4 choices are Income, Expense, Asset and Liability

• SUB-LEVEL 1 - used in P&L presentation 
• SUB-LEVEL 2 - used in P&L presentation
• NEED REVALUATION [AR, AP, CASH CONTROL ACCOUNT ONLY - when ticked, the specific coa will be included in the revaluation of AR or AP. 
• AUTO-APPORTIONMENT OF GL ACCOUNT -
• REVENUE ITEM FOR GST F5 BOX13 REPORTING - when ticked, will include in BOX 13, applied to income Chart Of Account or COA,
• CONTROL ACCOUNT-applies to AR and AP main chart of account,
• 100% COMPOSITION IN P&L CLASSIFICATION- applied to main income chart of account.
• SAVE - click save and confirmation 'to store the data entered', select either 'cancel' or 'ok'. 

  

• DELETE - to delete a specific chart-of-account code, 
• LISTING - click to go back to the listing with 'search'.
• CUSTOM FORMAT - relates to the final accounts layout, to select the related level 1, level2 and level3. 

  

HOW TO EDIT CHART OF ACCOUNT CODE?

• Note that existing chart of account code after having historical transaction cannot be deleted but can be edited in limited fields such as on name, account type, custom format.
• In chart of account listing, search 'code' to edit or,
  
• Point cursor then double click from the existing list then you can edit,

  .

Uniq365 allows almost unlimited ways to display your Profit & Loss Statement and Balance Sheet layout through FINAL ACCOUNTS LAYOUT. This module will help to manage the Profit and Loss classification and Balance sheet classification.

• There are 3 custom format available for user to customize reports - custom 1, 2 and 3. 
• LEVEL 1- as main level, LEVEL 2 - are branches of Level 1 account, while LEVEL 3 - are branches of Level 2 account, key in your preferred description,
• SORT 1 _ FOOTER - key in the description of SUBTOTAL,
• SHOW LINE - will provide underline, can be none, single line or double lines.
  
• PROFIT - to show if the account is in normal credit balance or debit balance.
• RUNNING TOTAL under LEVEL 1 - sums up the total of Level 1, key in the description 'TOTAL'.
• +ADD - to add each account code corresponding chart of account.
• LEVEL 3_ SORT 3 - key in description, select print, select profit, select non stock and category trading.
• SAVE - tick will save any new addition or changes.
• DOWNLOAD TEMPLATE - to get template in excel format for filling up,
• IMPORT TEMPLATE - to forward to system the prepared template,
• EXPORT - to export in excel format.
• CHANGE AUDIT TRAIL-provide report of latest change done by user.

How to get the classification report?

•  In General ledger,
• reports queries,
• Profit and loss classification or,
• Profit and loss classification in month.

• Balance sheet classification
• Balance sheet  

UNIQ365, this option determines how the GL is updated when posting transactions. The GL ACCOUNT POSTING SETTINGS

• User is reminded that SETTINGS should be set permanently at the start of use of new account book and,
•  not to be accessed other than by ADMIN user.
• ACCOUNT NAME -control accounts of Exchange gain or loss realized and unrealized, 
• POSTING TYPE - select from dropdown 'FIXED' or 'CURRENCY',
• FIXED ACCOUNT - if posting type selected is FIXED, select the chart of account that corresponds to the exchange gain/loss account code.
• YEAR ENDING CLOSING - settings for the year ending.
• OTHER CONTROL ACCOUNTS - setting for the GST SALES, GST PURCHASES, GST FIXED ASSETS, GST CLEARING and ROUNDING DIFFERENCE ACCOUNT.
• SAVE. 

For example, the Chart of Account to be posted for Exchange Gain/Loss or GST tax depends on what has been selected for the respective account as shown below example-

In UNIQ365, CHART OF ACCOUNTS DATA IMPORT will help first-time user to import new CHART OF ACCOUNTS list. 

HOW TO IMPORT CHART OF ACCOUNTS?

• DOWNLOAD TEMPLATE - before import, download template for filling up of CHART OF ACCOUNTS,
• FIELDS MAPPING - choose file should be in excel format,
• UPLOAD button - after choose file,
• DATABASE FIELDS - select 'account' should match 'excel/access fields' or, 
• AUTO MAP - tick to auto map,
• VERIFY - tick then system will verify if fields are correctly mapped,
• IMPORT - import every field accordingly,
• VIEW ERROR LOG - will list the error log, pay attention to the mentioned fields and try to correct them. If anything else, contact UNIQ365 support for assistance.
• VIEW IMPORT LIST - will list imported fields.