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:

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 
• 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.