image_pdfimage_print

The Accounts Report gives the users the possibility to view and print the reports for management reporting. The user can generate and print the list of the financial reports based on the selected Criteria. The following are the available reports:-

Report Description
Explanations
Financial Reports
Trial Balance Report Shows the opening balance, transacted debit and credit amounts and closing balance of all accounts for a selected period
Profit And Loss Report Shows the detailed profit or loss for the company for a given period of time
Balance Sheet Report Show the detailed Balance Sheet report of the company with account balances for a given period of time
Cash Flow Report Shows the company’s incoming and outgoing money during a given period of time
Journal Report Show the transactions made in a journal during a given period of time
General Ledger Report Shows the transactions posted for all accounts during a given period of time
Account Register Report Show the transactions posted for the selected account during a given period of time
Forex Gain or Loss Report Generates the forex gain or loss report per foreign currency account
Bank Reconciliation Report Generates a report with the list of unreconciled transactions for the selected Bank a/c as of Selected Date
Chart Of Accounts Shows the chart of accounts defined for the company
Customized Financial Report Shows the customized financial report for the company for a given period of time
Business Partner Reports
Business Partners List Shows the list of all Business Partners (Customers, Vendors, Employees) of the Company
Business Partners Balance Report Shows the opening balance, transacted debit and credit amounts and closing balance of all business partners for the selected period
Business Partner Detailed Report Shows all the transactions posted for the selected business partner during the selected period
Business Partner Monthly Detailed Report Shows the business partner detailed report for the 12 months from the selected month onwards
Statement Of Account Report Shows the statement of account for business partner with ageing balances
Non Trade Note List Shows the statement of account for debit and credit
A/c Receivable Reports
Receivable Ageing Balances Summary Report Shows the statement for Receivable Ageing balances due from all Customers
Receivable Ageing Balances – Detailed Report Shows the transaction details on Receivable Ageing balances due from a Customer
Collection Summary Report Shows the Collection summary report of future receivables from customers
Days Sales Outstanding Report Shows the Monthly Days Sales Outstanding summary report
Customer Curriculum Report Shows the customer curriculum report
A/c Payable Reports
Payable Ageing Balances Summary Report Shows the statement for Payable ageing balances due to all Vendors/Employees
Payable Ageing Balances – Detailed Report Shows the transaction details on Payable Ageing balances due to a Vendor/Employee
Payable Summary Report Shows the Payable summary report of payables to vendors/employees
Days Payable Outstanding Report Shows the Monthly days Payable Outstanding summary report
Analytical Group Reports
Analytical Group – Profit And Loss Report Generates the analytical group profit/loss report based on the selected analytical group
Analytical Group Profit And Loss – 12 Months Report Generates the 12 Months detailed analytical group profit/loss report based on the selected analytical group
Analytical Group Details Report Generates the analytical group detailed report based on the selected analytical group
Analytical Group Summary Report Generates the analytical group summary report based on the selected analytical group
Analytical Group Sales Margin Report Generates the analytical group gross to net sales margin report based on the selected analytical plan, business-unit, and category of accounts
Analytical Group Register Chart Shows Analytical Group Register Chart
Cost Center Reports
Cost Center – Profit And Loss Report Generates the cost center profit/loss report based on the selected cost center
Cost Center – 12 Months Report Generates the 12 Months detailed cost center report based on the selected cost center
Cost Center Details Report Generates the cost center details report based on the selected cost center
Cost Center Summary Report Generates the cost center summary report based on the selected cost center
Comparison Reports
Profit And Loss – Month, Year To Date Report Shows the detailed profit or loss report for the selected month and the year to date transactions
Profit And Loss – 2 Months Comparison Report Shows the detailed profit or loss report for the selected months and the variations also
Profit And Loss – 3 Months Detailed Report Shows the detailed profit or loss report for the 3 month from the selected month onwards
Profit And Loss – 12 Months Detailed Report Shows the detailed profit or loss report for the 12 months from the selected month onwards
Profit And Loss – Previous Year Comparison Report Shows the profit or loss for the company compared to previous years for the selected period intervals
Group Financial Reports
Group Currency – Trial Balance Report Shows the opening balance, transacted debit and credit amounts and closing balance of all accounts for a selected period
Group Currency – Profit And Loss Report Shows the detailed profit or loss for the company for a given period of time
Group Currency – Balance Sheet Report Shows the detailed Balance Sheet report of the company with account balances for a given period of time
Group Currency – Business Partner Balance Report Shows the opening balance, transacted debit and credit amounts and closing balance of all business partners for the selected period
Group Currency – Account Register Report Shows the transactions posted for the selected Groups Account during a given period of time
Group Currency – Business Partner Detailed Report Shows all the transactions posted for the selected business partner during the selected period
Group Currency – Receivable Ageing Balances Summary Shows the statement for Receivable Ageing balances due from a Customer
Group Currency – Payable Ageing Balances Summary Shows the statement for Payable ageing balances due to all Vendors/Employees
Group Currency – Forex Gain/Loss Report Generates the Forex Gain/Loss report per account and translates gain/loss amounts to Group Currency using average rate
Group Currency – Translation Gain/Loss Report Generates the Translation gain or loss report per account
Chart Of Accounts Mapping Report Shows all the Char of Accounts mapping
Hyperion Data Export Export the Financial Data (FMI & BMI) to a csv file in Hyperion format
Asset Reports
Asset Summary Report Generates the Asset Summary Report for the selected asset group, location, supplier and date range
Asset Detail Report Generates the Asset Detail Report for the selected asset group, location, supplier and date range
12 Months Asset Summary Report Generates the 12 Months Asset Summary Report for the selected asset group, location, supplier and date range
Asset Acquisition Report Generates the Asset Acquisition Report for the selected asset group, location, supplier and date range
Asset List Report Generates the Asset List Report for the selected asset group, location, supplier and date range
Budget Reports
Budget Report – Profit And Loss Generates Profit and Loss Budget
Budget Report – Balance Sheet Generates Balance Sheet Budget
Actual Vs Budget Monthly Comparison Report – Profit And Loss Generates the profit and loss monthly comparison report for Actual vs Budgeted amounts for the selected actual month against the selected budgeted month
Actual Vs Budget Monthly Comparison Report – Balance Sheet Generates the balance sheet monthly comparison report for Actual vs Budgeted amounts for the selected actual month against the selected budgeted month
Actual Vs Budget Yearly Comparison Report – Profit And Loss Generates the profit and loss yearly comparison report for Actual vs Budgeted amounts for the selected actual year against the selected budget
Actual Vs Budget Yearly Comparison Report – Balance Sheet Generates the balance sheet yearly comparison report for Actual vs Budgeted amounts for the selected actual year against the selected budget
Budget Year To Go Report – Profit And Loss Generates the profit and loss year to go report
Budget Year To Go Report – Balance Sheet Generates the balance sheet year to go report
Audit Reports
Journal Audit Trail Report Generates the Audit Trail Report for the selected journal, accounts, modified by user and date range
Customer Audit Trail Report Generates the Audit Trail Report for the changes logged for the selected customer
Authorisation Audit Report Generates the Authorisation Audit Report showing roles assigned to Users
User Roles Audit Report Generates the audit of all the roles assigned for the selected user and date range
Role Features Report Generates the role feature report for the selected user
GST Audit File Export Generates the Malaysia GST audit report file based on the selected date range
Accounts Charts
Accounts Management Pie Chart Shows Accounts Management Pie Chart
Accounts Management Line Charts Shows Accounts Management Line Charts
Treasury Weekly Balance Chart Shows Treasury Weekly Balance Chart
Treasury Monthly Balance Chart Shows Treasury Monthly Balance Chart

 

Below actions are available under “Accounts Reports”:

Samooha icon2  View reports for the Accounts modules, print and export reports as pdf or excel file. The report can be generated by different groups, department, expense category, year and date range.

Accounts Reports

View and Search Reports for Accounts Module

1. Enter search parameter to filter the result, i.e. type in the report name in the search textfield box at the top of the screen

Accounts Reports - search

2. Select a report from the list of reports available

3. Select the parameters to filter the report, i.e. by specific “Branch”, time period

4. Some reports allow multiple entry selection for its parameters, denoted by plus_button button next to the list. Click plus_button button next to drop-down list to select multiple items (i.e. certain partner groups). On the pop-up window, tick the box(es) of items to be included in the report, then click “OK” button

Accounts Reports - multi

Accounts Reports - multi select

5. Click “Generate Report” button at the bottom right of the screen to generate the report; it will open a new tab with the selected report

Accounts Reports - generate report

6. On the selected report tab, some records are clickable – in this case the mouse pointer will change to a hand pointer hand_pointer– it is possible to click on these hyperlink records to open another report for that particular record or show transaction details of the record (see pictures below for an example of inventory cost reports’ hyperlinks)

Inventory Reports - sample

7 At the bottom of the report tab, the following options are available:

Inventory Reports - buttons

 

(Malaysia only) GST Audit File Export

Audit Reports - GST Audit File Export - marked

1. Select “Audit Reports” under “Accounts Module” and select “GST Audit File Export

2. Select “Year“, “From” and “To” period of the GST audit report

3. Click “Generate Report” button

4. A window dialog will appear, select the folder location and click “Save” button to save the XML file

Audit Reports - GST Audit File Export - save