accountreport

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
accountreport [2025/08/25 09:59] – chillhubadminaccountreport [2026/07/10 08:01] (current) – chillhubadmin
Line 8: Line 8:
   * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Journal** \\ {{:journal:journal_1.jpg?500|}}   * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Journal** \\ {{:journal:journal_1.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>refresh?24}} **Refresh**: Updates the current view by reloading the data +    * {{mdi>refresh}} **Refresh**: Updates the current view by reloading the data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>plus?24}} **New**: Creates a new **Manual Journal Entry** record in the system.+    * {{mdi>plus}} **New**: Creates a new **Manual Journal Entry** record in the system.
   * Additional filter and action:   * Additional filter and action:
     * **Date Range**: Choose the start and end dates to filter data accordingly.     * **Date Range**: Choose the start and end dates to filter data accordingly.
     * **All accounts**: Enable this to view data from all accounts within the selected date range.     * **All accounts**: Enable this to view data from all accounts within the selected date range.
     * **Filter by account**: Select a specific account to filter the data. (Visible only when **All Accounts** is unchecked.)     * **Filter by account**: Select a specific account to filter the data. (Visible only when **All Accounts** is unchecked.)
-    * **General Ledger Report**: Create a general ledger report summarizing all journal transactions for the specified period. +    * **General Ledger Report**: Create a general ledger report summarizing all journal transactions for the specified period.
   * Data Table: //(Note that some of these columns may be hidden in the row details)//   * Data Table: //(Note that some of these columns may be hidden in the row details)//
-    * {{mdi>chevron-up?24}}: Expand row to view more details. +    * {{mdi>chevron-up}}: Expand row to view more details. 
-    * {{mdi>pencil?24}}: Edit the related transaction (e.g., invoices, purchase orders, manual entries).+    * {{mdi>pencil}}: Edit the related transaction (e.g., invoices, purchase orders, manual entries).
       * //Mobile View: expand row to access//       * //Mobile View: expand row to access//
     * **Date**: The transaction date.     * **Date**: The transaction date.
Line 31: Line 31:
 ++++ Manual Journal Entry: Record custom financial transactions that are not automatically generated by the system | ++++ Manual Journal Entry: Record custom financial transactions that are not automatically generated by the system |
 === Manual Journal Entry === === Manual Journal Entry ===
-  * From the **Journal Page**, click the **New** button or select the {{mdi>pencil?24}} icon on the //Manual Entry// row to open the Manual Journal entry dialog. \\ {{:journal:journal_2.jpg?500|}}+  * From the **Journal Page**, click the **New** button or select the {{mdi>pencil}} icon on the //Manual Entry// row to open the Manual Journal entry dialog. \\ {{:journal:journal_2.jpg?500|}}
   * **Date**: Select the date of the journal entry.   * **Date**: Select the date of the journal entry.
 +  * **Type**: Specifies the transaction type associated with the journal entry (e.g., Sales Invoice, Payment, Expense, Inventory Adjustment, or Manual Entry).
 +  * **Ref. No.**: A reference number to identify or link the journal entry to its source document.
   * **Entries**: Add one or more debit/credit lines for the transaction:   * **Entries**: Add one or more debit/credit lines for the transaction:
     * **Account**: Search and select the relevant account.     * **Account**: Search and select the relevant account.
     * **Credit/Debit**: Specify whether the amount is a credit or a debit.     * **Credit/Debit**: Specify whether the amount is a credit or a debit.
     * **Amount**: Enter the transaction amount.      * **Amount**: Enter the transaction amount.
-    * {{mdi>pencil?24}}: Edit the selected entry. +    * {{mdi>pencil}}: Edit the selected entry. 
-    * {{mdi>delete?24}}: Delete the entry. +    * {{mdi>delete}}: Delete the entry. 
-    * {{mdi>check-circle?24}}: Save changes (when in edit mode) +    * {{mdi>check-circle}}: Save changes (when in edit mode) 
-    * {{mdi>close-circle?24}}: Cancel changes (when in edit mode)+    * {{mdi>close-circle}}: Cancel changes (when in edit mode)
   * **Total Credit**: Displays the total credit amount entered.   * **Total Credit**: Displays the total credit amount entered.
   * **Total Debit**: Displays the total debit amount entered.   * **Total Debit**: Displays the total debit amount entered.
Line 75: Line 77:
     * **Debit**: The debit amount recorded for the transaction.     * **Debit**: The debit amount recorded for the transaction.
     * **Credit**: The credit amount recorded for the transaction.     * **Credit**: The credit amount recorded for the transaction.
 +    * **Balance**: The cumulative account balance after each transaction.
     * **Remark**: Additional notes or comments related to the transaction.      * **Remark**: Additional notes or comments related to the transaction.
 ++++ ++++
Line 91: Line 94:
   \\ {{:account_report:account_report_1.jpg?500|}}   \\ {{:account_report:account_report_1.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>file-document?24}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.+    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
   * Data Table:   * Data Table:
     * **Account**: Displays accounts grouped under **Revenue**, **Cost of Goods Sold (COGS)**, and **Expense**, organized in a hierarchical structure.     * **Account**: Displays accounts grouped under **Revenue**, **Cost of Goods Sold (COGS)**, and **Expense**, organized in a hierarchical structure.
Line 117: Line 120:
   \\ {{:account_report:account_report_3.jpg?500|}}   \\ {{:account_report:account_report_3.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>file-document?24}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.+    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
   * Data Table:   * Data Table:
     * **Account**: Displays accounts grouped under **Assets**, **Liabilities**, and **Equity**, organized in a hierarchical structure.     * **Account**: Displays accounts grouped under **Assets**, **Liabilities**, and **Equity**, organized in a hierarchical structure.
Line 139: Line 142:
   \\ {{:account_report:account_report_5.jpg?500|}}   \\ {{:account_report:account_report_5.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>file-document?24}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.+    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
   * Data Table:   * Data Table:
     * **Account**: Lists all accounts, organized in a hierarchical structure.     * **Account**: Lists all accounts, organized in a hierarchical structure.
Line 162: Line 165:
   \\ {{:account_report:account_report_7.jpg?500|}}   \\ {{:account_report:account_report_7.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>file-document?24}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.+    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
   * Data Table:   * Data Table:
     * **Description**: Lists cash flow activities grouped under operating, investing, and financing categories.     * **Description**: Lists cash flow activities grouped under operating, investing, and financing categories.
Line 176: Line 179:
     * **Amount**: Shows the cash inflow or outflow amount for each activity.     * **Amount**: Shows the cash inflow or outflow amount for each activity.
   * Clicking **View Report** generates a document that looks like the following:  \\ {{:account_report:account_report_8.jpg?500|}}   * Clicking **View Report** generates a document that looks like the following:  \\ {{:account_report:account_report_8.jpg?500|}}
 +++++
 +++++ A/R Aging Report: Summarizes outstanding customer receivables by how overdue they are. |
 +=== A/R Aging Report ===
 +  * Log in to [[https://app.chillhub.com.my|Chillhub App]].
 +  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Reports**
 +  * Select **A/R Aging Report** as the Report Type.
 +  * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each invoice's due date relative to this date.//
 +  * Click **Generate Report** to generate the **A/R Aging** report.
 +  \\ {{:account_report:account_report_15.jpg?500|}}
 +  * The following options are located on the toolbar
 +    * {{mdi>magnify}} **Search**: Allows you to search for specific data
 +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file.
 +    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
 +  * Data Table:
 +    * **Customer**: The name of the customer with an outstanding balance.
 +    * **Term**: The payment terms agreed with the customer.
 +    * **Current Balance**: Outstanding balance that is not yet due, based on the invoice's payment terms.
 +    * **Overdue 1-30**: Outstanding balance that is 1 to 30 days past its due date.
 +    * **Overdue 31-60**: Outstanding balance that is 31 to 60 days past its due date.
 +    * **Overdue 61-90**: Outstanding balance that is 61 to 90 days past its due date.
 +    * **Overdue 90+**: Outstanding balance that is more than 90 days past its due date.
 +    * **Total Balance**: The sum of all balances (current and overdue) for the customer.
 +    * A **Total** row is shown at the bottom of the table, summarizing all columns across every customer.
 +  * Clicking **View Report** generates a document that looks like the following: \\ {{:account_report:account_report_16.jpg?500|}}
 +++++
 +++++ A/P Aging Report: Summarizes outstanding supplier payables by how overdue they are. |
 +=== A/P Aging Report ===
 +  * Log in to [[https://app.chillhub.com.my|Chillhub App]].
 +  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Reports**
 +  * Select **A/P Aging Report** as the Report Type.
 +  * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each purchase invoice's due date relative to this date.//
 +  * Click **Generate Report** to generate the **A/P Aging** report.
 +  \\ {{:account_report:account_report_17.jpg?500|}}
 +  * The following options are located on the toolbar
 +    * {{mdi>magnify}} **Search**: Allows you to search for specific data
 +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file.
 +    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
 +  * Data Table:
 +    * **Supplier**: The name of the supplier with an outstanding balance.
 +    * **Term**: The payment terms agreed with the supplier.
 +    * **Current Balance**: Outstanding balance that is not yet due, based on the purchase invoice's payment terms.
 +    * **Overdue 1-30**: Outstanding balance that is 1 to 30 days past its due date.
 +    * **Overdue 31-60**: Outstanding balance that is 31 to 60 days past its due date.
 +    * **Overdue 61-90**: Outstanding balance that is 61 to 90 days past its due date.
 +    * **Overdue 90+**: Outstanding balance that is more than 90 days past its due date.
 +    * **Total Balance**: The sum of all balances (current and overdue) for the supplier.
 +    * A **Total** row is shown at the bottom of the table, summarizing all columns across every supplier.
 +  * Clicking **View Report** generates a document that looks like the following: \\ {{:account_report:account_report_18.jpg?500|}}
 ++++ ++++
 ++++ Tax Summary Report: Displays the tax amounts incurred and outstanding balance, grouped by tax type and rate, for the selected period. | ++++ Tax Summary Report: Displays the tax amounts incurred and outstanding balance, grouped by tax type and rate, for the selected period. |
 === Tax Summary Report === === Tax Summary Report ===
 +\\ //Activate SST add-on in the subscription plan to enable this report//
   * Log in to [[https://app.chillhub.com.my|Chillhub App]].   * Log in to [[https://app.chillhub.com.my|Chillhub App]].
   * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Reports**    * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Reports** 
Line 192: Line 244:
   \\ {{:account_report:account_report_13.jpg?500|}}   \\ {{:account_report:account_report_13.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>file-document?24}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.+    * {{mdi>file-document}} **View Report**: Generates report that can be shared, printed, and downloaded in PDF format.
   * Data Table:   * Data Table:
     * **Tax Type**: The category of tax (e.g., Service Tax, Sales Tax).     * **Tax Type**: The category of tax (e.g., Service Tax, Sales Tax).
Line 202: Line 254:
     * **Debit**: Tax amounts recorded as debit entries, reducing the tax liability (e.g., payment made to Customs)     * **Debit**: Tax amounts recorded as debit entries, reducing the tax liability (e.g., payment made to Customs)
     * **Credit**: Tax amounts recorded as credit entries, increasing the tax liability (e.g., tax charged)     * **Credit**: Tax amounts recorded as credit entries, increasing the tax liability (e.g., tax charged)
-      * **//Invoiced Service Tax is first recorded in the **Service Tax Deferred Account** and transferred to **SST Payable Account** upon payment; Sales Tax is recorded directly in **SST Payable Account**.//+      * //Invoiced Service Tax is first recorded in the **Service Tax Deferred Account** and transferred to **SST Payable Account** upon payment; Sales Tax is recorded directly in **SST Payable Account**.//
     * **Description**: Notes explaining the change in tax liability.     * **Description**: Notes explaining the change in tax liability.
     * **Balance**: The tax liability account balance at period end.     * **Balance**: The tax liability account balance at period end.
Line 212: Line 264:
   * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Debtor** or **Creditor** \\ {{:account_report:account_report_9.jpg?500|}}   * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Debtor** or **Creditor** \\ {{:account_report:account_report_9.jpg?500|}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
- * {{mdi>refresh?24}} **Refresh**: Updates the current view by reloading the data + * {{mdi>refresh}} **Refresh**: Updates the current view by reloading the data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file.+    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file.
   * Data Table:   * Data Table:
-    * {{mdi>pencil?24}}: View detailed statement for the selected debtor or creditor.+    * {{mdi>pencil}}: View detailed statement for the selected debtor or creditor.
     * **Creditor** or **Debtor**: Name of the customer (debtor) or supplier (creditor).     * **Creditor** or **Debtor**: Name of the customer (debtor) or supplier (creditor).
     * **Balance**: Outstanding amount owed by or to the party.     * **Balance**: Outstanding amount owed by or to the party.
 === Debtor/Creditor Statement === === Debtor/Creditor Statement ===
-  * Clicking {{mdi>pencil?24}} icon on a **Debtor** or **Creditor** row opens a statement dialog showing detailed transactions for the selected customer or supplier. \\ {{:account_report:account_report_10.jpg?500|}}+  * Clicking {{mdi>pencil}} icon on a **Debtor** or **Creditor** row opens a statement dialog showing detailed transactions for the selected customer or supplier. \\ {{:account_report:account_report_10.jpg?500|}}
   * **Creditor**: The selected supplier whose statement is being viewed.   * **Creditor**: The selected supplier whose statement is being viewed.
   * **Debtor**: The selected customer whose statement is being viewed.   * **Debtor**: The selected customer whose statement is being viewed.
Line 227: Line 279:
   * **Export to Excel**: Downloads the statement as an Excel file.   * **Export to Excel**: Downloads the statement as an Excel file.
   * Data Table for **Creditor**:   * Data Table for **Creditor**:
-    * {{mdi>pencil?24}}: View or edit the linked document or transaction.+    * {{mdi>pencil}}: View or edit the linked document or transaction.
     * **Date**: The date of the transaction.     * **Date**: The date of the transaction.
     * **Payment Status**: Shows the current payment status of the purchase invoice (e.g., paid, not paid, partial).     * **Payment Status**: Shows the current payment status of the purchase invoice (e.g., paid, not paid, partial).
Line 236: Line 288:
     * **Credit**: Amount added to the supplier’s payable balance.     * **Credit**: Amount added to the supplier’s payable balance.
   * Data Table for **Debtor**:   * Data Table for **Debtor**:
-    * {{mdi>pencil?24}}: View or edit the linked document or transaction.+    * {{mdi>pencil}}: View or edit the linked document or transaction.
     * **Date**: The date of the transaction.     * **Date**: The date of the transaction.
     * **Payment Status**: Shows the current payment status of the sales invoice (e.g., paid, not paid, partial).     * **Payment Status**: Shows the current payment status of the sales invoice (e.g., paid, not paid, partial).
Line 251: Line 303:
 === Bank Reconciliation === === Bank Reconciliation ===
   * Log in to [[https://app.chillhub.com.my|Chillhub App]].   * Log in to [[https://app.chillhub.com.my|Chillhub App]].
-  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Bank Reconciliation** \\ {{:account_report:account_report_12.jpg?500|}}+  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Bank Reconciliation** \\ {{:account_report:account_report_12.jpg?700|}}
   * Select a **Cash Accounts**   * Select a **Cash Accounts**
   * Choose the **Month** or use the arrows to navigate.   * Choose the **Month** or use the arrows to navigate.
-  * Check **"Show Pending Reconciliation"** to include already reconciled transactions.+  * Uncheck **"Show Pending Reconciliation"** to include already reconciled transactions.
   * Click **Fetch Transactions** button to load bank/cash transactions of the selected account.   * Click **Fetch Transactions** button to load bank/cash transactions of the selected account.
   * The following options are located on the toolbar   * The following options are located on the toolbar
-    * {{mdi>magnify?24}} **Search**: Allows you to search for specific data +    * {{mdi>magnify}} **Search**: Allows you to search for specific data 
-    * {{mdi>download?24}} **Export to Excel**: Enables exporting the current view data to an Excel file. +    * {{mdi>download}} **Export to Excel**: Enables exporting the current view data to an Excel file. 
-    * {{mdi>content-save?24}} **Save**: Save updates made during the reconciliation process.+    * {{mdi>content-save}} **Save**: Save updates made during the reconciliation process.
   * Data Table:   * Data Table:
-    * {{mdi>pencil?24}}: View or edit the linked document or transaction. +    * {{mdi>pencil}}: View or edit the linked document or transaction.
     * **Date**: The date of the transaction.     * **Date**: The date of the transaction.
     * **Document Type**: Indicates the type of transaction. (e.g. Sales Invoice Payment, Purchase Invoice Payment, etc)     * **Document Type**: Indicates the type of transaction. (e.g. Sales Invoice Payment, Purchase Invoice Payment, etc)
Line 268: Line 320:
     * **Withdrawal**: Money paid out from the account (outflows).     * **Withdrawal**: Money paid out from the account (outflows).
     * **Ref. No.**: Payment reference number.     * **Ref. No.**: Payment reference number.
 +    * **Employee**: The employee associated with the payment.
     * **Payee/Payer**: Party who made or received the payment.     * **Payee/Payer**: Party who made or received the payment.
     * **Remark**: Any additional notes related to the transaction.     * **Remark**: Any additional notes related to the transaction.
     * **Checkbox** indicates whether the transaction has been reconciled.     * **Checkbox** indicates whether the transaction has been reconciled.
   * Manually tick the checkboxes for matched transactions, then click **Save** to complete the bank reconciliation.   * Manually tick the checkboxes for matched transactions, then click **Save** to complete the bank reconciliation.
 +  * **Upload Statement (AI)**: Instead of manually ticking each transaction, you can let AI match your bank statement against fetched transactions automatically.
 +    * {{mdi>creation}} **Upload Statement**: Upload a bank statement file (PDF or image). \\ //Requires a selected Cash Account, fetched transactions, the AI add-on to be enabled, and edit permission.//
 +      * //Note: Requires the AI Productivity add-on. Each request consume AI Credits dynamically based on the amount of content extracted. You can track your remaining free balance at the top right//
 +      * PDFs longer than 10 pages will prompt you to select a page range
 +    * **Date Range**: After the statement is uploaded, optionally set a date range to narrow which fetched transactions AI should attempt to match against.
 +    * AI will automatically tick the checkboxes for transactions it successfully matches between your statement and the fetched transaction list.
 +      * If one transaction on that date has the exact same amount, it's matched right away.
 +      * Otherwise, transactions on that date with the same Reference No. (or Payee/Payer, if no reference) are grouped together and matched if their combined amount equals the statement amount.
 +    * **Unmatched Transactions Warning**: If any statement transactions could not be matched to a fetched transaction, a warning banner is shown listing each one, including its date, deposit/withdrawal amount, description, and reference number, so you can review and reconcile them manually.
 +    * Review the AI-matched (and any manually ticked) transactions, then click **Save** to complete the bank reconciliation.
 ++++ ++++
 +<aichat button float>Welcome to Chillhub AI Assistant. I can help you understand and use your ERP system.</aichat>
  • accountreport.1756115957.txt.gz
  • Last modified: 2025/08/25 09:59
  • by chillhubadmin