REPORTS QUERIES

HOW TO GENERATE MASTER LISTING - CHART OF ACCOUNT?

• ACCOUNT - to view specific account or when left blank, will show full list of chart of account or

• ACCOUNT NAME - to view specific name

• USE SELECTED GL ACCOUNT button - tick, this selection is use when user want to select 2 or more chart of account

• then SELECT ACCOUNT - tick 2 or more chart of account

• PREVIEW - click will show list of chart of account in either select by 'ACCOUNT' or by 'USE SELECTED GL ACCOUNT 
  

TRANSACTION LISTING REPORT or otherwise know GL transaction listing, can be previewed here.

HOW TO PREVIEW TRANSACTION LISTING?

Fill up the following filter parameters:

• DETAIL REPORT 

• TRN TYPE 

• TRN NO 

• BUTTON - TODAY, THIS MONTH, THIS QUARTER, THIS YEAR, CUSTOM, LAST MONTH

• DATE
• REFERENCE

  DATE 

• CURRENCY

  REFERENCE 

• CURRENCY

• CASH BANK 

• PROJECT
• DEPARTMENT

  PROJECT 

• SECTION

  DEPARTMENT 

• UNIT

  SECTION 

• UNIT

• SORT BY - select  TRANSACTION, REFERENCE, DATE or CLASSIFICATION
  

• PREVIEW
• QUERY

  PREVIEW 

• QUERY 

• EXPORT EXCEL 

Sample transaction listing if selected a specific TRN TYPE GJ with selected date range 01 January 2025 to 13 February 2025, will show as below:

HOW TO GENERATE GST F5?

This report is generated for submission to IRAS.

• GST Form 5 Statement (By GST TYPE) - is the most commonly used Form5

• Date - select date range

• PREVIEW - click to view

• QUERY - to export excel with filter capability

• EXPORT EXCEL - to export to excel

SAMPLE PREVIEW OF GST FORM5 (BY GST TYPE):

• ARROW LEFT OR RIGHT- select pages [in sample will show pages 1 of total 1 page]

• - or +  - zoom from 1% to 100%

• PRINT - select to print

• DOWNLOAD - to pdf or excel.

 HOW TO GENERATE GST IN OUT LISTING?

This report reflects all posted transactions with GST (with all types of GST).

• GST IN OUT LISTING

• DATE 

• PROJECT 

• DEPARTMENT 

• SECTION 

• UNIT

 SAMPLE PREVIEW OF GST IN OUT LISTING:

 HOW TO GENERATE GST POSTING LISTING?

 This report reflects transactions sorted by GST CODE, grouped by GL ACCOUNT CODE.

Navigate on the GST Posting Listing Report and fill up your required parameters for the report generation.

 SAMPLE PREVIEW OF GST POSTING LISTING:

HOW TO GENERATE GST GROUPING DETAIL LISTING BY GST TYPE?

This report report reflect summary of transaction posted with GST involved, grouped by GST TYPE.

Navigate on the GST Grouping Detail Listing(By GST Type) and fill up your required parameters for the report generation.

 SAMPLE PREVIEW OF GST GROUPING DETAIL LISTING BY GST TYPE?

TRIAL BALANCE in Uniq365 can be previewed in 2 ways-

• Trial balance By Date

• Trial balance By Year / Period

HOW TO GENERATE TRIAL BALANCE BY DATE?

• select TRIAL BALANCE BY DATE

• YEAR - key in 
  

• TODAY - defaulted but you may select 'THIS MONTH', 'THIS QUARTER', 'THIS YEAR', 'CUSTOM' or 'LAST MONTH'

• DATE - select from and to (in this format DD-MM-YYYY)

• PROJECT - filter by project

• DEPARTMENT - filter by department

• SECTION - filter by section or
  

• UNIT - filter by unit

• PREVIEW - tick to preview

• QUERY - to export in excel with filter capability

• EXPORT EXCEL - to export in excel

SAMPLE FORMAT OF TRIAL BALANCE BY DATE:

HOW TO GENERATE TRIAL BALANCE BY YEAR PERIOD?

• select TRIAL BALANCE BY YEAR PERIOD

• YEAR - key in 
  

• PERIOD - key in from 1 to 12 [end of month basis]. Example, if you key period 12, system will take the sum from month 1 to 12. If the start period is January, system will sum up from January 1 to December 31 of the selected year.

• PROJECT - filter by project

• DEPARTMENT - filter by department

• SECTION - filter by section or
  

• UNIT - filter by unit

• PREVIEW - tick to preview

• QUERY - to export in excel with filter capability

• EXPORT EXCEL - to export in excel 

SAMPLE FORMAT OF TRIAL BALANCE BY YEAR PERIOD:

In this sample, year is 2025, the start month is January as period 1, so key in period 12 [system will sum up from period 1 to 12], trial balance will show as of [last day] DECEMBER 2025.

HOW TO READ THE COLUMNS OF TRIAL BALANCE?

• YEAR - as keyed in

• PERIOD - 12 as DECEMBER

• ACCOUNT - chart of account code

• NAME - description of chart of account

• PREV MONTH BALANCE - in this sample, balance is from November 30 2025

• CURR DR MONTH - sum of transactions from DECEMBER 1 to 31 2025

• CURR CR MONTH - sum of transactions from DECEMBER 1 to 31 2025

• CLOSING DR-sum of columns previous month bal, Curr Dr and Curr Cr

• CLOSING CR-sum of columns previous month bal, Curr Dr and Curr Cr. 

GENERAL LEDGER LISTING can be previewed in many ways

• GENERAL LEDGER LISTING 

• GENERAL LEDGER LISTING NO NARRATION

• GENERAL LEDGER LISTING SUB LEDGER

• GENERAL LEDGER LISTING BASE CURRENCY ONLY

• GENERAL LEDGER LISTING DETAILS IN XLS

• tick TODAY, THIS MONTH, THIS QUARTER, THIS YEAR, CUSTOM or LAST MONTH

• DATE - select from and to (in this format DD-MM-YYYY)

• ACCOUNT - select either from dropdown chart-of-account code or

• ACCOUNT NAME - select from and to

• PROJECT - you may leave blank if no project-department-section-unit use or select from and to

• DEPARTMENT -  you may leave blank if no department-section-unit use

• SECTION - you may leave blank if no section-unit use

• UNIT - you may leave blank if no unit use.

• USE SELECTED GL ACCOUNT - you may use this if you wish to view selected chart of account.

• SELECT ACCOUNT BUTTON - upon tick, another page will show, select the chart of account you wish to include in the preview by checking the box.

• SELECT ALL ACCOUNT - will help tick all chart of accounts

• UNSELECT ALL ACCOUNT - will untick all chart of accounts

• CANCEL - will let you return to the previous page

• ARROW LEFT and RIGHT on PAGES 1 to last - will let you select and tick chart of account.

• RECORDS - 10, 25, 50 100 and  200 lines to show on each page.

GENERAL LEDGER LISTING SAMPLE PREVIEW

GENERAL LEDGER LISTING NO NARRATION SAMPLE PREVIEW

GENERAL LEDGER LISTING SUBLEDGER SAMPLE PREVIEW

GENERAL LEDGER LISTING BASE CURRENCY ONLY SAMPLE PREVIEW

GENERAL LEDGER LISTING XLS SAMPLE PREVIEW

PROFIT AND LOSS can be previewed in many ways

• PROFIT AND LOSS

• PROFIT AND LOSS CLASSIFICATION IN MONTH

• PROFIT AND LOSS CLASSIFICATION 

• PROFIT AND LOSS SUBACCOUNT TYPE GROUP

• PROFIT AND LOSS SUBACCOUNT TYPE

HOW TO PREVIEW PROFIT AND LOSS?

• select the report - PROFIT AND LOSS, PROFIT AND LOSS CLASSIFICATION IN MONTH, PROFIT AND LOSS CLASSIFICATION, PROFIT AND LOSS SUBACCOUNT TYPE GROUP AND PROFIT AND LOSS SUBACCOUNT TYPE

• DATE - from and to 

• TODAY - will auto select date range from 'today' to 'today', this month, this quarter, custom or last month.

SAMPLE PREVIEW PROFIT AND LOSS

• HEADER - company, date generated, date of profit and loss statement

• PAGE - number of page

• TYPE - income or expense

• ACCOUNT - chart of account code

• DESCRIPTION - description

• INCOME - column of all debit balance

• EXPENSE - column of all credit balance

• PROFIT/LOSS - auto-indicate loss if 'debit balance' [this sample is loss] or profit if 'credit balance'

• TOTAL - total debit or income  and total credit or expense

HOW TO PREVIEW PROFIT AND LOSS CLASSIFICATION IN MONTH?

• select the report - PROFIT AND LOSS CLASSIFICATION IN MONTH

• YEAR AND PERIOD - key in 

• PROJECT - select from and to

• DEPARTMENT - select from and to

• SECTION - select from and to

• UNIT - select from and to

• SHOW PERCENTAGE - tick to show percentage per row

• PREVIEW - click

• FORMAT SELECTION - select custom 1, 2 or 3

SAMPLE PREVIEW PROFIT AND LOSS CLASSIFICATION IN MONTH

• report will show the monthly values in 12 months

• arrows left or right - show page 1 to 4

• - or + - zoom in report

• printer icon - click to print

• export - click to pdf or excel
  

SAMPLE PREVIEW PROFIT AND LOSS CLASSIFICATION

SAMPLE PREVIEW PROFIT AND LOSS SUBACCOUNT TYPE GROUP 

• YEAR and PERIOD - select from dropdown and key in period from 1 until 12

• PREVIEW - click to preview

• EXPORT EXCEL - to export to excel

• ALLOW ZERO BALANCE - tick to allow accounts with zero balances

• 

PROFIT AND LOSS STATEMENT BY SUB ACCOUNT or BY SUB LEVEL

• TYPE - income or expense

• ACCOUNT - chart of account code

• DESCRIPTION - chart of account

• MTD - month to date

• YTD - year to date

• LMTD 

• LYTD 

SAMPLE PREVIEW PROFIT AND LOSS SUBACCOUNT TYPE

• TYPE - income or expense

• ACCOUNT - chart of account code

• DESCRIPTION - chart of account

• INCOME - debit balance

• EXPENSE - credit balance

• PAGE - number of pages

BALANCE SHEET can be previewed in many ways

• BALANCE SHEET

• BALANCE SHEET SUBACCOUNT TYPE

• BALANCE SHEET WITH CLASSIFICATION

HOW TO PREVIEW BALANCE SHEET?

• YEAR - select 

• DATE - select date (date is in this format DD-MM-YYYY)

• PREVIEW - tick

• QUERY - export to excel with filter capability

• EXPORT EXCEL - export

BALANCE SHEET SAMPLE PREVIEW

• Type - Assets or Liabilities [wherein, in system, Equity is under Liabilities type]

• Account - chart of account code

• Description - chart of account description

• Assets - column of account with debit closing values

• Liabilities - column of account with credit closing values

BALANCE SHEET SUBACCOUNT TYPE SAMPLE PREVIEW

BALANCE SHEET CLASSIFICATION SAMPLE PREVIEW