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 [2026/07/10 07:59] – chillhubadminaccountreport [2026/10/02 03:54] (current) – chillhubadmin
Line 6: Line 6:
 === Journal === === Journal ===
   * 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** -> **Journal** \\ {{:journal:journal_1.jpg?500|}}+  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Journal** \\ {{gallery>:journal:journal_1.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
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}} 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. \\ {{gallery>:journal:journal_2.jpg?400x0&crop=off&0}}
   * **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).   * **Type**: Specifies the transaction type associated with the journal entry (e.g., Sales Invoice, Payment, Expense, Inventory Adjustment, or Manual Entry).
Line 57: Line 57:
       * **Debit to Creditor (-)**: Decreases the **Accounts Payable** for a creditor.       * **Debit to Creditor (-)**: Decreases the **Accounts Payable** for a creditor.
     * **Debtor**: Search and select an existing customer. //(Only visible when the entry is linked to a debtor.)//     * **Debtor**: Search and select an existing customer. //(Only visible when the entry is linked to a debtor.)//
-    * **Creditor**: Search and select an existing supplier. //(Only visible when the entry is linked to a creditor.)//    +    * **Creditor**: Search and select an existing supplier. //(Only visible when the entry is linked to a creditor.)//    
 +    * Attachment: Attach transaction documents as images or PDF files. 
 +      * **Upload File**: Click Upload File and select an image/pdf file. 
 +      * Alternatively, simply drag your file from your computer and drop it into the designated upload area 
 +      * Attachment Options: 
 +        * {{mdi>eye}}: Open and preview the image or PDF. 
 +        * {{mdi>delete}}: Remove the attachment.
 ++++ ++++
 ++++ General Ledger: Complete record of all journal entries organized by account.| ++++ General Ledger: Complete record of all journal entries organized by account.|
Line 63: Line 69:
   * From the **Journal Page**, select the desired date range. You may also choose a specific account to filter the journal entries (optional).   * From the **Journal Page**, select the desired date range. You may also choose a specific account to filter the journal entries (optional).
   * Click **General Ledger Report** to to generate the report based on the selected filters.   * Click **General Ledger Report** to to generate the report based on the selected filters.
-  \\ {{:journal:journal_3.jpg?500|}}+  \\ {{gallery>:journal:journal_3.jpg?500x0&crop=off&0}}
   * **Letterhead & Title**: The report begins with your company’s letterhead, followed by the title “General Ledger” prominently displayed at the top.   * **Letterhead & Title**: The report begins with your company’s letterhead, followed by the title “General Ledger” prominently displayed at the top.
   * **Date Range**: Just below the title, the selected date range is clearly shown, indicating the reporting period.   * **Date Range**: Just below the title, the selected date range is clearly shown, indicating the reporting period.
Line 92: Line 98:
   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.
   * Click **Generate Report** to generate the **Profit and Loss** statement.   * Click **Generate Report** to generate the **Profit and Loss** statement.
-  \\ {{:account_report:account_report_1.jpg?500|}}+  \\ {{gallery>:account_report:account_report_1.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 108: Line 114:
       * **Gross Profit**: Revenue minus COGS; shows profit before expenses.       * **Gross Profit**: Revenue minus COGS; shows profit before expenses.
       * **Net Profit**: Final profit after subtracting all expenses from revenue.       * **Net Profit**: Final profit after subtracting all expenses from revenue.
-  * Clicking **View Report** generates a document that looks like the following:  \\ {{:account_report:account_report_2.jpg?500|}}+  * Clicking **View Report** generates a document that looks like the following:  \\ {{gallery>:account_report:account_report_2.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ Balance Sheet: Shows assets, liabilities, and equity at a specific point in time. | ++++ Balance Sheet: Shows assets, liabilities, and equity at a specific point in time. |
Line 118: Line 124:
   * Click **Generate Report** to generate the **Profit and Loss** statement.   * Click **Generate Report** to generate the **Profit and Loss** statement.
     * **Note**: To generate a Balance Sheet, the **[[https://wiki.chillhub.com.my/doku.php?id=accountchart#configuring_financial_period|Financial period]]** and **Opening Balances** must be properly configured at the selected date.     * **Note**: To generate a Balance Sheet, the **[[https://wiki.chillhub.com.my/doku.php?id=accountchart#configuring_financial_period|Financial period]]** and **Opening Balances** must be properly configured at the selected date.
-  \\ {{:account_report:account_report_3.jpg?500|}}+  \\ {{gallery>:account_report:account_report_3.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 126: Line 132:
     * **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.
     * **Total Amount**: Shows the balance of each account as of the selected date.     * **Total Amount**: Shows the balance of each account as of the selected date.
-  * Clicking **View Report** generates a document that looks like the following: \\ {{:account_report:account_report_4.jpg?500|}}+  * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>:account_report:account_report_4.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ Trial Balance: A report that lists all accounts with their debit and credit balances to ensure total debits equal total credits. | ++++ Trial Balance: A report that lists all accounts with their debit and credit balances to ensure total debits equal total credits. |
Line 140: Line 146:
   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.
   * Click **Generate Report** to generate the **Trial Balance** statement.   * Click **Generate Report** to generate the **Trial Balance** statement.
-  \\ {{:account_report:account_report_5.jpg?500|}}+  \\ {{gallery>:account_report:account_report_5.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 149: Line 155:
     * **Debit**: Shows the total debit amount recorded for each account.     * **Debit**: Shows the total debit amount recorded for each account.
     * **Credit**: Shows the total credit amount recorded for each account.     * **Credit**: Shows the total credit amount recorded for each account.
-  * Clicking **View Report** generates a document that looks like the following:  \\ {{:account_report:account_report_6.jpg?500|}}+  * Clicking **View Report** generates a document that looks like the following:  \\ {{gallery>:account_report:account_report_6.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ Cash Flow Statement: A report that shows the inflow and outflow of cash over a specific period, categorized into operating, investing, and financing activities. | ++++ Cash Flow Statement: A report that shows the inflow and outflow of cash over a specific period, categorized into operating, investing, and financing activities. |
Line 163: Line 169:
   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.   * Use left/right arrow to navigate date range based on the selected periodicity, or manually adjust the **Date Range**.
   * Click **Generate Report** to generate the **Cash Flow Statement** statement.   * Click **Generate Report** to generate the **Cash Flow Statement** statement.
-  \\ {{:account_report:account_report_7.jpg?500|}}+  \\ {{gallery>:account_report:account_report_7.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 178: Line 184:
             * Increases or decreases in **Non-current Liabilities and Equity**.             * Increases or decreases in **Non-current Liabilities and Equity**.
     * **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:  \\ {{gallery>:account_report:account_report_8.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ A/R Aging Report: Summarizes outstanding customer receivables by how overdue they are. | ++++ A/R Aging Report: Summarizes outstanding customer receivables by how overdue they are. |
Line 187: Line 193:
   * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each invoice's due date relative to this date.//   * 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.   * Click **Generate Report** to generate the **A/R Aging** report.
-  \\ {{:account_report:account_report_15.jpg?500|}}+  \\ {{gallery>:account_report:account_report_15.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 202: Line 208:
     * **Total Balance**: The sum of all balances (current and overdue) for the customer.     * **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.     * 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|}}+  * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>:account_report:account_report_16.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ A/P Aging Report: Summarizes outstanding supplier payables by how overdue they are. | ++++ A/P Aging Report: Summarizes outstanding supplier payables by how overdue they are. |
Line 211: Line 217:
   * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each purchase invoice's due date relative to this date.//   * 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.   * Click **Generate Report** to generate the **A/P Aging** report.
-  \\ {{:account_report:account_report_17.jpg?500|}}+  \\ {{gallery>:account_report:account_report_17.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 226: Line 232:
     * **Total Balance**: The sum of all balances (current and overdue) for the supplier.     * **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.     * 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|}}+  * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>:account_report:account_report_18.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ 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. |
Line 242: Line 248:
   * **Account**: Select an taxes payable/deferred account.   * **Account**: Select an taxes payable/deferred account.
   * Click **Generate Report** to generate the **Tax Summary** report.   * Click **Generate Report** to generate the **Tax Summary** report.
-  \\ {{:account_report:account_report_13.jpg?500|}}+  \\ {{gallery>:account_report:account_report_13.jpg?500x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 257: Line 263:
     * **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.
-  * Clicking **View Report** generates a document that looks like the following:  \\ {{:account_report:account_report_14.jpg?500|}}+  * Clicking **View Report** generates a document that looks like the following:  \\ {{gallery>:account_report:account_report_14.jpg?400x0&crop=off&0}}
 ++++ ++++
 ++++ Debtor/Creditor Statement: Summary of outstanding amounts owed by customers (debtors) or to suppliers (creditors) over a selected period. | ++++ Debtor/Creditor Statement: Summary of outstanding amounts owed by customers (debtors) or to suppliers (creditors) over a selected period. |
 === Debtors/Creditors === === Debtors/Creditors ===
   * 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** -> **Debtor** or **Creditor** \\ {{:account_report:account_report_9.jpg?500|}}+  * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Debtor** or **Creditor** \\ {{gallery>:account_report:account_report_9.jpg?400x0&crop=off&0}}
   * The following options are located on the toolbar   * The following options are located on the toolbar
     * {{mdi>magnify}} **Search**: Allows you to search for specific data     * {{mdi>magnify}} **Search**: Allows you to search for specific data
Line 268: Line 274:
     * {{mdi>download}} **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}}: View detailed statement for the selected debtor or creditor.+    * {{mdi>file-document}}: View detailed statement for the selected debtor or creditor. 
 +    * {{mdi>cash-multiple}}: Record a payment and apply it to one or more outstanding invoices.
     * **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}} 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. \\ {{gallery>:account_report:account_report_10.jpg?400x0&crop=off&0}}
   * **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 298: Line 305:
   * **View Document**: Opens the full document in a separate view.    * **View Document**: Opens the full document in a separate view. 
     * Transactions with the same **Description**, **Date** and **Reference Number** (e.g. payment ref. no. or credit/debit note no.) are grouped together.     * Transactions with the same **Description**, **Date** and **Reference Number** (e.g. payment ref. no. or credit/debit note no.) are grouped together.
-    * **Aging Summary** is displayed at the bottom of the statement to show outstanding amounts grouped by how long they’ve been overdue. \\ {{:account_report:account_report_11.jpg?500|}}+    * **Aging Summary** is displayed at the bottom of the statement to show outstanding amounts grouped by how long they’ve been overdue. \\ {{gallery>:account_report:account_report_11.jpg?400x0&crop=off&0}} 
 +=== Record Payment === 
 +  * Clicking {{mdi>cash-multiple}} icon on a **Debtor** or **Creditor** row opens the **Record Payment** dialog to log a payment and allocate it across outstanding documents. \\ {{gallery>:account_report:account_report_19.jpg?400x0&crop=off&0}} 
 +  * **Customer** / **Supplier**: Name of the party the payment is being recorded for (read-only). 
 +  * **Currency**: Defaults to your base currency.  
 +    * //Enable the Multi-Currency add-on to select a foreign currency.// 
 +  * **Date**: The date the payment was made. 
 +  * **Amount**: The total payment amount received or paid.  
 +    * //If a foreign currency is selected, this field becomes **Amount (Foreign)**, entered in the foreign currency, with the equivalent base-currency **Amount** shown alongside it.// 
 +  * **Exchange Rate** //(foreign currency only)//: The exchange rate used to convert the payment to your base currency. 
 +    * {{mdi>currency-exchange}}: Fetch the latest exchange rate automatically. 
 +  * **Forex Gain/Loss** //(foreign currency only)//: Automatically calculated based on the difference between each allocated document's original billing exchange rate and this payment's exchange rate. 
 +  * **Account (Forex Gain/Loss)** //(foreign currency only)//: The account used to post the forex gain or loss.  
 +    * //Defaults automatically based on Account Rules, but can be changed manually.// 
 +  * **Payment Method**: Select how the payment was made (Cash on Hand, Bank Transfer, Credit Card, Debit Card, E-Wallet, or Cheque). 
 +  * **Cash Account**: The account the payment is deposited into or paid from.  
 +    * //Defaults automatically based on the selected Payment Method and Account Rules, but can be changed manually.// 
 +  * **Reference No.**: Payment reference number (e.g. bank transaction reference, cheque number). 
 +  * **Remark**: Any additional notes about the payment. 
 +  * **Attachment**: Upload supporting documents (e.g. payment slip, receipt) as image or PDF files, up to 5MB each.  
 +    * Uploaded files can be previewed, viewed, or removed before saving. 
 +  * **Include Sales Orders** checkbox //(Debtor mode only)//: Include unpaid Sales Orders, in addition to unpaid Invoices, in the allocation table below. 
 +  * **Allocation Table**: Lists all outstanding invoices (and, depending on party type, sales orders or expenses) for the selected customer/supplier. 
 +    * Entering an **Amount** automatically distributes the payment across outstanding items, earliest first, until fully allocated. 
 +    * **Amount to Pay** for each row can be manually adjusted to change how the payment is allocated. 
 +    * **Document**: The invoice, sales order, or expense reference. 
 +    * **Date**: The date of the document. 
 +    * **Total**: The original total amount of the document. 
 +    * **Outstanding**: The remaining unpaid balance of the document. 
 +    * **Amount to Pay**: The portion of this payment being allocated to the document. 
 +    * **Status** / **Error**: Shows the save status of each allocated item, and any error encountered, once submitted. 
 +    * The table footer shows **Payment** (total payment amount), **Allocated** (total allocated so far), and **Remaining** (unallocated balance) — shown in red until fully allocated, green once balanced. 
 +  * Click **Save** to submit the payment.  
 +    * //Only enabled once the Remaining balance is exactly 0 and at least one document has been allocated.// 
 +  * Click **Close** to exit without saving.
 ++++ ++++
 ++++ Bank Reconciliation : Matches internal transaction records with bank statements to ensure accuracy  | ++++ Bank Reconciliation : Matches internal transaction records with bank statements to ensure accuracy  |
 === 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** \\ {{gallery>:account_report:account_report_12.jpg?600x0&crop=off&0}}
   * 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.
  • accountreport.1783670349.txt.gz
  • Last modified: 2026/07/10 07:59
  • by chillhubadmin