Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| accountreport [2026/07/10 07:23] – chillhubadmin | accountreport [2026/10/02 03:54] (current) – chillhubadmin | ||
|---|---|---|---|
| Line 6: | Line 6: | ||
| === Journal === | === Journal === | ||
| * Log in to [[https:// | * Log in to [[https:// | ||
| - | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Journal** \\ {{: | + | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Journal** \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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> | + | * From the **Journal Page**, click the **New** button or select the {{mdi> |
| * **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**: | + | * **Creditor**: |
| + | * Attachment: Attach transaction documents as images or PDF files. | ||
| + | * **Upload File**: Click Upload File and select an image/pdf file. | ||
| + | * Alternatively, | ||
| + | * Attachment Options: | ||
| + | * {{mdi> | ||
| + | * {{mdi> | ||
| ++++ | ++++ | ||
| ++++ 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. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * **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, | * Use left/right arrow to navigate date range based on the selected periodicity, | ||
| * Click **Generate Report** to generate the **Profit and Loss** statement. | * Click **Generate Report** to generate the **Profit and Loss** statement. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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: | + | * Clicking **View Report** generates a document that looks like the following: |
| ++++ | ++++ | ||
| ++++ Balance Sheet: Shows assets, liabilities, | ++++ Balance Sheet: Shows assets, liabilities, | ||
| 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:// | * **Note**: To generate a Balance Sheet, the **[[https:// | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| Line 126: | Line 132: | ||
| * **Account**: | * **Account**: | ||
| * **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: \\ {{: | + | * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>: |
| ++++ | ++++ | ||
| ++++ 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, | * Use left/right arrow to navigate date range based on the selected periodicity, | ||
| * Click **Generate Report** to generate the **Trial Balance** statement. | * Click **Generate Report** to generate the **Trial Balance** statement. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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: | + | * Clicking **View Report** generates a document that looks like the following: |
| ++++ | ++++ | ||
| ++++ 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, | * Use left/right arrow to navigate date range based on the selected periodicity, | ||
| * Click **Generate Report** to generate the **Cash Flow Statement** statement. | * Click **Generate Report** to generate the **Cash Flow Statement** statement. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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: | + | * Clicking **View Report** generates a document that looks like the following: |
| ++++ | ++++ | ||
| ++++ 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' | * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each invoice' | ||
| * Click **Generate Report** to generate the **A/R Aging** report. | * Click **Generate Report** to generate the **A/R Aging** report. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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: \\ {{: | + | * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>: |
| ++++ | ++++ | ||
| ++++ 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' | * Choose the **As of Date** for the report. \\ //Overdue buckets are calculated based on each purchase invoice' | ||
| * Click **Generate Report** to generate the **A/P Aging** report. | * Click **Generate Report** to generate the **A/P Aging** report. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| 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: \\ {{: | + | * Clicking **View Report** generates a document that looks like the following: \\ {{gallery>: |
| ++++ | ++++ | ||
| ++++ 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**: | * **Account**: | ||
| * Click **Generate Report** to generate the **Tax Summary** report. | * Click **Generate Report** to generate the **Tax Summary** report. | ||
| - | \\ {{: | + | \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| Line 257: | Line 263: | ||
| * **Description**: | * **Description**: | ||
| * **Balance**: | * **Balance**: | ||
| - | * Clicking **View Report** generates a document that looks like the following: | + | * Clicking **View Report** generates a document that looks like the following: |
| ++++ | ++++ | ||
| ++++ Debtor/ | ++++ Debtor/ | ||
| === Debtors/ | === Debtors/ | ||
| * Log in to [[https:// | * Log in to [[https:// | ||
| - | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Debtor** or **Creditor** \\ {{: | + | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Debtor** or **Creditor** \\ {{gallery>: |
| * The following options are located on the toolbar | * The following options are located on the toolbar | ||
| * {{mdi> | * {{mdi> | ||
| Line 268: | Line 274: | ||
| * {{mdi> | * {{mdi> | ||
| * 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> | ||
| * **Creditor** or **Debtor**: Name of the customer (debtor) or supplier (creditor). | * **Creditor** or **Debtor**: Name of the customer (debtor) or supplier (creditor). | ||
| * **Balance**: | * **Balance**: | ||
| === Debtor/ | === Debtor/ | ||
| - | * Clicking {{mdi> | + | * Clicking {{mdi> |
| * **Creditor**: | * **Creditor**: | ||
| * **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**, | * Transactions with the same **Description**, | ||
| - | * **Aging Summary** is displayed at the bottom of the statement to show outstanding amounts grouped by how long they’ve been overdue. \\ {{: | + | * **Aging Summary** is displayed at the bottom of the statement to show outstanding amounts grouped by how long they’ve been overdue. \\ {{gallery>: |
| + | === Record Payment === | ||
| + | * Clicking {{mdi> | ||
| + | * **Customer** / **Supplier**: | ||
| + | * **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)**, | ||
| + | * **Exchange Rate** //(foreign currency only)//: The exchange rate used to convert the payment to your base currency. | ||
| + | * {{mdi> | ||
| + | * **Forex Gain/Loss** //(foreign currency only)//: Automatically calculated based on the difference between each allocated document' | ||
| + | * **Account (Forex Gain/ | ||
| + | * //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**: | ||
| + | * 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/ | ||
| + | * 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**: | ||
| + | * **Date**: The date of the document. | ||
| + | * **Total**: The original total amount of the document. | ||
| + | * **Outstanding**: | ||
| + | * **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, | ||
| + | * 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:// | * Log in to [[https:// | ||
| - | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Bank Reconciliation** \\ {{: | + | * Navigate the Accounts Chart page by selecting **Menu** -> **Accounting** -> **Bank Reconciliation** \\ {{gallery>: |
| * 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. | ||
| Line 313: | Line 354: | ||
| * {{mdi> | * {{mdi> | ||
| * Data Table: | * Data Table: | ||
| - | * {{mdi> | + | * {{mdi> |
| * **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 320: | Line 361: | ||
| * **Withdrawal**: | * **Withdrawal**: | ||
| * **Ref. No.**: Payment reference number. | * **Ref. No.**: Payment reference number. | ||
| + | * **Employee**: | ||
| * **Payee/ | * **Payee/ | ||
| * **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, | * Manually tick the checkboxes for matched transactions, | ||
| + | * **Upload Statement (AI)**: Instead of manually ticking each transaction, | ||
| + | * {{mdi> | ||
| + | * //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/ | ||
| + | * **Unmatched Transactions Warning**: If any statement transactions could not be matched to a fetched transaction, | ||
| + | * Review the AI-matched (and any manually ticked) transactions, | ||
| ++++ | ++++ | ||
| <aichat button float> | <aichat button float> | ||