REPORTS QUERIES

REPORTS QUERIES in ~~UNIQ365~~Uniq365 lists all the available reports in the Ledger.

In REPORT QUERIES, reports are:

MASTER LISTING
TRANSACTION LISTING
GST REPORT
TRIAL BALANCE
GENERAL LEDGER
PROFIT AND LOSS
BALANCE SHEET
XBRL REPORT

MASTER LISTING

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

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
CURRENCY
CASH BANK
PROJECT
DEPARTMENT
SECTION
UNIT
SORT BY - select TRANSACTION, REFERENCE, DATE or CLASSIFICATION
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:

GST REPORT

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

TRIAL BALANCE in UNIQ365Uniq365 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

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.