# Reports Queries

#### **REPORT QUERIES** **NAVIGATION** in **Uniq365** lists all the available reports in the Ledger 

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Gumimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Gumimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **CLICK REPORT QUERIES** will show list of reports to select:

- **MASTER LISTING**
- **TRANSACTION LISTING**
- **GST REPORT**
- **TRIAL BALANCE**
- **GENERAL LEDGER**
- **PROFIT AND LOSS**
- **BALANCE SHEET**
- **CASH FLOW STATEMENT**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/azbimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/azbimage.png)

<details id="bkmrk-master-listing-maste"><summary>MASTER LISTING</summary>

#### **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**

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/6USimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/6USimage.png)

</details><details id="bkmrk-transaction-listing-"><summary>TRANSACTION LISTING</summary>

#### **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

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/YlPimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/YlPimage.png)

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:

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/qXqimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/qXqimage.png)

</details><details id="bkmrk-gst-report-gst-repor"><summary>GST REPORT</summary>


#### **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

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Nwjimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Nwjimage.png)

#### **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.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/c75image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/c75image.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **HOW TO GENERATE GST IN OUT LISTING?**

**This report reflects all posted transactions with GST (sorted from payable to receivable).**

- **GST IN OUT LISTING**
- **DATE**
- **PROJECT**
- **DEPARTMENT**
- **SECTION**
- **UNIT**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/5nVimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/5nVimage.png)

####  **SAMPLE PREVIEW OF GST IN OUT LISTING:**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/1u6image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/1u6image.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

####  **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.

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/KsFimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/KsFimage.png)

####  **SAMPLE PREVIEW OF GST POSTING LISTING:**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/bQYimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/bQYimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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.

 [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/l17image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/l17image.png)

####  **SAMPLE PREVIEW OF GST GROUPING DETAIL LISTING BY GST TYPE?**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Groimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Groimage.png)

</details><details id="bkmrk-trial-balance-%C2%A0"><summary>TRIAL BALANCE</summary>

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/eg4image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/eg4image.png)

#### **SAMPLE FORMAT OF TRIAL BALANCE BY DATE:**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/8Osimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/8Osimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/98Ximage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/98Ximage.png)

#### **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. [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/4gWimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/4gWimage.png)

</details><details id="bkmrk-general-ledger-%C2%A0"><summary>GENERAL LEDGER</summary>

#### **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**

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/CrRimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/CrRimage.png)

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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/k5Vimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/k5Vimage.png)

#### **GENERAL LEDGER LISTING SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/anEimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/anEimage.png)

#### **GENERAL LEDGER LISTING NO NARRATION SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/J30image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/J30image.png)

#### **GENERAL LEDGER LISTING SUBLEDGER SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/z4Jimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/z4Jimage.png)

#### **GENERAL LEDGER LISTING BASE CURRENCY ONLY SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/N2limage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/N2limage.png)

#### **GENERAL LEDGER LISTING XLS SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/kYBimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/kYBimage.png)

</details><details id="bkmrk-profit-and-loss-%C2%A0"><summary>PROFIT AND LOSS</summary>

#### **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**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/uhPimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/uhPimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/ey9image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/ey9image.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/K34image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/K34image.png)

- **PREVIEW** - click
- **FORMAT SELECTION** - select custom 1, 2 or 3

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/pv7image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/pv7image.png)

#### **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

#### [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/xhKimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/xhKimage.png)

#### **SAMPLE PREVIEW PROFIT AND LOSS CLASSIFICATION**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/0jSimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/0jSimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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
- [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/ZdZimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/ZdZimage.png)

#### **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**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/1fTimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/1fTimage.png)

\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/Da8image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/Da8image.png)

</details><details id="bkmrk-balance-sheet-%C2%A0"><summary>BALANCE SHEET</summary>

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/yGPimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/yGPimage.png)

#### **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

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/z18image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/z18image.png)

#### **BALANCE SHEET SUBACCOUNT TYPE SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/4g3image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/4g3image.png)

#### **BALANCE SHEET CLASSIFICATION SAMPLE PREVIEW**

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-02/scaled-1680-/tY0image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-02/tY0image.png)

</details><details id="bkmrk-xbrl-report-%C2%A0"><summary>CASH FLOW STATEMENT</summary>

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">Question : How to set and generate Cash Flow Statement?</span>**

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif; color: black; mso-themecolor: text1;">Answer:</span>**

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">The cash flow statement format indirect method typically consists of three main cashflows from Operating activities, Investing activities and Financing activities, in sample below:</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/image.png)

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">SETTING:</span>**

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">In UNIQ365, To generate the CASH FLOW STATEMENT, setting must be done properly. </span>

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> </span>

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">STEP 1</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> – **CREATE SUB-TITLES**, in the CASH FLOW ACTIVITIES, fill the details of SECTION, ORDER and CASH FLOW ACTIVITES.</span>

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">Note that the CASH FLOW ACTIVITIES and CASH FLOW DESCRIPTION may vary ‘name’ base on your creation and for purpose of this guide, we name cash flow activities as follows:</span>

<span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';">  </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">**SECTION** – Operating, Investing and Financing as standard ‘terms’, nothing else.</span>

<span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">**ORDER**- Note that the report will be presented base on ORDER you set, in ascending from 10 to 50.</span>

<span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">**CASH FLOW ACTIVITIES** – in order ‘10’, it is advisable to assign the first SUB-TITLE name as ‘Adjustment to reconcile net income to net cash provided by operating activities’.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/Wu0image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/Wu0image.png)

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">STEP 2</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> – **CREATE CASH FLOW DESCRIPTION**, list CASH FLOW DESCRIPTION by add ORDER, CASH FLOW ACTIVITIES dropdown and SUB-SECTION. </span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-08/scaled-1680-/jc9image.png)](https://doc.uniq365.com/uploads/images/gallery/2025-08/jc9image.png)

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">In **CASH FLOW ACTIVITIES** select from dropdown list, fill sub-section then save.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-08/scaled-1680-/zKtimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-08/zKtimage.png)

  
**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">STEP 3 </span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">– **OPERATING, INVESTING AND FINANCING**, Identify the CHART OF ACCOUNT that belongs to OPERATING, INVESTING and FINANCING </span>

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">3.1 **OPERATING AND** **ACCUMULATED DEPRECIATION** – To list ‘accumulated depreciation’ under subtitle ‘operating activities’, select accumulated depreciation in CHART OF ACCOUNT&gt;FINANCE GROUP&gt;select 2 LEVELS:</span>

<span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">SUBTITLE</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as ‘Adjustment to reconcile net income..’ </span>

<span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">CASH FLOW DESCRIPTION</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as <span style="mso-spacerun: yes;"> </span>‘Depreciation of fixed assets’</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/Uuqimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/Uuqimage.png)

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">3.2 Trade receivables, inventory, other current assets, trade payables and othercurrent liabilities, same step on 3.1.</span>

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> </span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">3.3 **INVESTING** To list ‘computer’ under subtitle ‘investing activities’, select ‘computer’ in CHART OF ACCOUNT&gt;FINANCE GROUP&gt;select 2 LEVELS:</span>

- **<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> SUBTITLE</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as ‘Investing’</span>
- <span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;"><span style="font: 7.0pt 'Times New Roman';"> </span></span></span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">CASH FLOW DESCRIPTION</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as ‘Purchase of property plant and equipment’</span>
- [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/JVSimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/JVSimage.png)<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">3.4 **FINANCING** To list ‘share capital’ under subtitle ‘financing activities’, select ‘share capital’ in CHART OF ACCOUNT&gt;FINANCE GROUP&gt;select 2 LEVELS:</span>
- <span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;"><span style="font: 7.0pt 'Times New Roman';"> </span></span></span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">SUBTITLE</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as ‘Investing'</span>
- <span style="font: 7.0pt 'Times New Roman';"> </span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">CASH FLOW DESCRIPTION</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> as ‘Equity’</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/Axiimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/Axiimage.png)

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">STEP 4</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> – **BEGINNING CASH BALANCE**, Identify the CASH AND CASH EQUIVALENT beginning cash balance by going to chart of account – in this example, in CHART OF ACCOUNT, select DBS BANK, in FINANCE GROUP, tick ‘CASH ITEM’ then SAVE.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/8Wbimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/8Wbimage.png)

 <span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">In this preview:</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/MXmimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/MXmimage.png)

 **<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">STEP 5 –</span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> **GENERATE THE REPORT**, in ledger, reports queries, generate the report by selecting</span>

- <span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;"><span style="font: 7.0pt 'Times New Roman';"><span style="font-family: Symbol;"> </span></span><span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">CASH FLOW STATEMENT</span>
- <span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;"><span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">date range</span>
- <span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol;"><span style="mso-list: Ignore;"><span style="font: 7.0pt 'Times New Roman';"><span style="font-family: Symbol;"> </span></span><span style="font: 7.0pt 'Times New Roman';"> </span></span></span><span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">Preview</span>
- [![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/mpwimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/mpwimage.png)

**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">OTHER RELATED REPORTS OF CASH FLOW:</span>**

<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;"> </span><span lang="EN-US" style="font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-weight: bold;"><span style="mso-list: Ignore;">·<span style="font: 7.0pt 'Times New Roman';"> </span></span></span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">CHART OF ACCOUNT MASTERLISTING CASH FLOW- </span>**<span lang="EN-US" style="font-family: 'Tahoma',sans-serif;">in LEDGER&gt; REPORTS QUERIES&gt;MASTER LISTING CHART OF ACCOUNT CASH FLOW&gt;PREVIEW.</span>

[![image.png](https://doc.uniq365.com/uploads/images/gallery/2025-07/scaled-1680-/1gyimage.png)](https://doc.uniq365.com/uploads/images/gallery/2025-07/1gyimage.png)

</details>