Menu 03 - Financial Report Features

In this section all the applet features will be introduced accordingly.

3.1 General Access

Users are able to open up the sidebar by clicking on the icon highlighted in the image below, this will allow the user to switch to different sections of the applet easily. There are three sections: Journal Transaction, Sub Ledger and Ledger.

1440 x 900

3.2 Financial Report Feature

3.2.1 Journal Transaction Listing

1440 x 900

In this section which is the first page of the applet to display a list of financial reports in a table. In the financial report listing page there are plus “+” icon, search bar and table record. Plus icon functionality is to add a new financial report while search bar is to search for a particular financial report. Table records are financial reports when a user clicks on any record he/she is able to view all the financial report details. When a record clicked user will be directed into the clicked financial report details page. The table of the financial report is containing the following columns:

  • Set of Book

  • Start Date

  • End Date

  • Created Date

  • Updated Date

  • Created By

  • Updated By

3.2.2 Financial Report Create

1440 x 900

Financial report create page is the page to create a new financial report. At the top right side there is a plus icon to create a new financial report, users can click on the icon and the create page will popup. In the create page user is required to fill up all required data to create a financial report. Please be noted that if there is a “*” star sign on the text field, it is mandatory to fill in or select. In the create main tab these are the need data to be filled in to be able to create new financial report:

  • Set of Books

  • Start Year

  • Start Month

  • End Year

  • End Month

There are two buttons at the top left side: Rest button to clear data that has been inserted to the text box and create button to create the new financial report. Also there is a back icon to navigate users to the previous page.

3.2.3 Financial Report Listing Group By

1440 x 900

On the financial report listing page users can group data by column names. On the left side of the table there is a column menu list icon named columns. Users can click on it and the list will drop down the column names and on the bottom there is Row Group drag and drop area to allow users to drag a column name and drop it into the drag and drop area. The list of tables will be refreshed and display rows grouped by the selected column. In the shown example, the Set of the Book column is chosen to group rows based on it. So data on the table is refreshed and grouped by the set of books. Grouping can be a set of columns as well; just the user needs to drag and drop the extra columns he/she needs to group by. Pivot mode is a feature that allows you to rotate and reorganize the data in a pivot table to view it from different perspectives. It makes it easier to analyze and understand the data by summarizing it in a different way. To use pivot mode, you select the cells in the pivot table and use the feature to rearrange the rows and columns.

3.2.4 Financial Report Details Main Tab

1440 x 900

Users can view the financial report detail by clicking on any of the financial report rows on the financial report listing page. All the financial reports will be listed in a table as shown in the image above and each table row is clickable. Based on the financial report selected from the table the details page will display the details of the selected report. There are 4 tabs:

  • Main

  • Trial Balance

  • Profit And Loss

  • Balance Sheet

Here we are explaining the main tab, on the main tab there are five (5) main data of the financial report which are:

  • Set of Books

  • Start Year

  • Start Month

  • End Year

  • End Month

All these data are not editable but user is able to delete the main tab details by clicking on the delete button on the bottom of the page.

3.2.5 Profit And Loss Tab

1440 x 900

On trial balance tab a table will be list all the trial balance with the following data:

  • GL Section

  • GL Category

  • GL Code

  • Debit

  • Credit

Each row of the trial balance tab is clickable and when a user clicks on any row he/she will be directed into the GL section details page. Here is the GL sections:

  • Cost of Goods Sold

  • Current Assets - Cash

  • Current Assets - Credit Card Receivable

  • Current Assets - Receivable

  • Current Liabilities - Account Payable

  • Current Liabilities - Other Expenses Payable

  • Profit loss

  • Retained earnings

  • Sales Revenue

When a user clicks on any of these rows GL section / GL Category will be directed to the details page which will be shown on the image below with the following data:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

3.2.5.1 Trial Balance GLsection And GLCategory

1440 x 900

When a user clicks on the Journal Ledger column for any row he/she will be directed to the journal ledger main tab page.

3.2.5.2 Journal Ledger Main Tab

1440 x 900

In the main tab these are the following data but only description is editable:

  • IDA Company

  • IDA Branch

  • Primary

  • MYR

  • Reference No

  • Date

  • Server Doc Type

  • Server Doc No

  • Description

3.2.5.3 Journal Ledger Line Items Tab

1440 x 900

On line items tab there are five (5) columns with the following data:

  • GL Code

  • Entity

  • Description

  • Debit

  • Credit

3.2.6 Profit And Loss Tab

1440 x 900

On profit and loss tab a table of two column GL Code and Amount. The Profit and Loss tab contain the following details:

  • Sales Revenue

  • Net Sales

  • Total Cost of Goods Sold

  • Gross Profit/(Loss)

  • Gross Margin

  • Profit Before Taxes

  • Net Profit/(Loss)

  • Profit Margin

There is a button on the top right corner to regenerate the data on the table. Each row of the Profit and Loss tab is clickable and when a user clicks on any row a new page will be popped up displaying details. This will be elaborated more in the sub-heading below.

3.2.6.1 Sales Revenue

1440 x 900

In sales revenue details about the profit and loss revenue will be shown. User need to navigate to Sales Revenue > Sales > generalSales to be able to view the sales revenue detail which are:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

3.2.6.2 Profit and Loss Details

1440 x 900

All remaining profit and loss table rows are showing the same columns but with their own data. The columns names are the same for the

  • Net Sales

  • Total Cost of Goods Sold

  • Gross Profit/(Loss)

  • Gross Margin

  • Profit Before Taxes

  • Net Profit/(Loss)

  • Profit Margin

Which displaying their own data under the columns names:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Any row that has been clicked will be shown on the top of the financial report details page as shown on the above page with red underline.

3.2.7 Balance Sheet Tab

1440 x 900

On the balance sheet tab a table of two column GL Code and Amount. The Profit and Loss tab contain the following details:

  • Current Assets

  • Total Assets

  • Current Liabilities

  • Total Liabilities

  • Retained earnings

  • Profit loss

  • Total Shareholders’ Equity

  • Total Liabilities And Total Shareholders’ Equity

There is a button on the top right corner to regenerate the data on the table. Each row of the balance sheet tab is clickable and when a user clicks on any row a new page will be popped up displaying details. This will be elaborated more in the sub-heading below.

3.2.7.1 Current Assets Cash

1440 x 900

In Current Assets > Cash > Lazada, details about the balance sheet Lazada will be shown. User need to navigate to Current Assets - Cash - Lazada as shown in the above image to be able to view the Current Assets detail which are:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Each row is clickable and it will direct you to Ledger and Journal Applet since these data are interrelated with Ledger and Journal Applet.

3.2.7.2 Current Assets Credit Card Receivable

1440 x 900

In Current Assets > Credit Card Receivable > CashDraws, details about the balance sheet CashDraws will be shown. User need to navigate to Current Assets > Credit Card Receivable > CashDraws as shown in the above image to be able to view the Current Assets detail which are:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Each row is clickable and it will direct you to Ledger and Journal Applet since these data are interrelated with Ledger and Journal Applet.

3.2.7.3 Current Assets Receivable

1440 x 900

In Current Assets > Receivable > accReceivable, details about the balance sheet accReceivable will be shown. User need to navigate to Current Assets > Receivable > accReceivable as shown in the above image to be able to view the Current Assets detail which are:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Each row is clickable and it will direct you to Ledger and Journal Applet since these data are interrelated with Ledger and Journal Applet.

3.2.7.4 Current Liabilities Account Payable

1440 x 900

In Current Liabilities > Account Account > accPayable, details about the balance sheet accPayable will be shown. User need to navigate to Current Liabilities > Account Account > accPayable as shown in the above image to be able to view the Current Assets detail which are:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Each row is clickable and it will direct you to Ledger and Journal Applet since these data are interrelated with Ledger and Journal Applet

3.2.7.5 Balance Sheet Details

1440 x 900

All remaining profit and loss table rows are showing the same columns but with their own data. The columns names are the same for the

Current Assets Total Assets Current Liabilities Total Liabilities Retained earnings Profit loss Total Shareholders’ Equity Total Liabilities And Total Shareholders’ Equity

Which displaying their own data under the columns names:

  • Date

  • Journal Ledger

  • Description

  • Server Doc Type

  • Server Doc No

  • Debit

  • Credit

Any row that has been clicked will be shown on the top of the financial report details page as shown on the above page with red underline.