# Bookkeeping Overview

## Purpose

The **Bookkeeping Overview** dashboard provides a real-time summary of the company's financial status, including receivables, payables, cash flow, revenue, expenses, and overdue accounts. It helps users monitor financial performance and manage outstanding transactions.

---

# Dashboard Components

## 1. Outstanding Receivable

**Type**

- KPI Card

**Description**

Displays the total outstanding Accounts Receivable (AR) amount that customers have not yet paid.

**Purpose**

Monitor outstanding customer payments and improve collection management.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/SGJimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/SGJimage.png)

---

## 2. Outstanding Payable

**Type**

- KPI Card

**Description**

Displays the total outstanding Accounts Payable (AP) amount owed to suppliers.

**Purpose**

Monitor unpaid supplier balances and manage payment schedules.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/Yoiimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/Yoiimage.png)

---

## 3. Cash Received / Payment

**Chart Type**

- Bar Chart

**Display**

Monthly comparison of:

- Cash Received
- Cash Payment

**Purpose**

Monitor monthly cash inflow and cash outflow.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/0hAimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/0hAimage.png)

---

## 4. YTD Revenue vs Expenses by Month

**Chart Type**

- Pie Chart

**Display**

Year-to-Date (YTD) comparison between:

- Revenue
- Expenses
- Cost of Good Sold

Displayed based on the selected month.

**Purpose**

Provide a quick overview of the relationship between company income and operating expenses.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/snSimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/snSimage.png)

---

## 5. 8 Month Aging Summary

**Chart Type**

- Bar Chart

**Display**

Outstanding balances categorized by aging periods over the past eight months.

Example:

- Current
- 1 Month
- 2 Month
- 3 Month
- 4 Month
- 5 Month
- 6 Month
- 7 Month+

**Purpose**

Monitor overdue receivables and payables according to aging periods.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/y80image.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/y80image.png)

---

## 6. Monthly Expenses Summary

**Chart Type**

- Pie Chart

**Display**

Breakdown of monthly expenses by expense category.

Example:

- Salary
- Rental
- Utilities
- Transportation
- Office Expenses
- Others

**Purpose**

Identify major expense categories during the selected month.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/8oHimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/8oHimage.png)

---

## 7. Income and Expenses

**Chart Type**

- Bar Chart

**Display**

Monthly comparison between:

- Sales
- Cost of Good Sold
- Expenses
- Net Profit

**Purpose**

Evaluate business profitability and compare income against operating expenses.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/a2Iimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/a2Iimage.png)

---

# Financial Tables

## 8. Top 30 Debtors with Overdue

Displays the top 30 customers with overdue outstanding invoices.

<div class="TyagGW_tableContainer" id="bkmrk-column-no.-customer-"><div class="group TyagGW_tableWrapper flex flex-col-reverse w-fit" tabindex="-1"><table class="w-fit min-w-(--thread-content-width)" data-end="2541" data-start="2419"><thead data-end="2429" data-start="2419"><tr data-end="2429" data-start="2419"><th class="last:pe-10" data-col-size="sm" data-end="2429" data-start="2419">Column</th></tr></thead><tbody data-end="2541" data-start="2442"><tr data-end="2449" data-start="2442"><td data-col-size="sm" data-end="2449" data-start="2442">No.</td></tr><tr data-end="2467" data-start="2450"><td data-col-size="sm" data-end="2467" data-start="2450">Customer Code</td></tr><tr data-end="2485" data-start="2468"><td data-col-size="sm" data-end="2485" data-start="2468">Customer Name</td></tr><tr data-end="2524" data-start="2502"><td data-col-size="sm" data-end="2524" data-start="2502">Outstanding Amount</td></tr></tbody></table>

</div></div>**Purpose**

Identify customers requiring collection follow-up.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/GvCimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/GvCimage.png)

---

## 9. Recent Overdue Invoice &amp; Bills

Displays recently overdue customer invoices and supplier bills.

<div class="TyagGW_tableContainer" id="bkmrk-column-no.-document-"><div class="group TyagGW_tableWrapper flex flex-col-reverse w-fit" tabindex="-1"><table class="w-fit min-w-(--thread-content-width)" data-end="2849" data-start="2716" style="width: 17.619%; height: 251.2px;"><thead data-end="2726" data-start="2716"><tr data-end="2726" data-start="2716" style="height: 29.6px;"><th class="last:pe-10" data-col-size="sm" data-end="2726" data-start="2716" style="width: 99.5101%; height: 29.6px;">Column</th></tr></thead><tbody data-end="2849" data-start="2739"><tr data-end="2746" data-start="2739" style="height: 29.6px;"><td data-col-size="sm" data-end="2746" data-start="2739" style="width: 99.5101%; height: 29.6px;">No.</td></tr><tr style="height: 29.6px;"><td style="width: 99.5101%; height: 29.6px;">Type</td></tr><tr data-end="2763" data-start="2747" style="height: 29.6px;"><td data-col-size="sm" data-end="2763" data-start="2747" style="width: 99.5101%; height: 29.6px;">Document No.</td></tr><tr style="height: 29.6px;"><td style="width: 99.5101%; height: 29.6px;">Code</td></tr><tr data-end="2796" data-start="2773" style="height: 29.6px;"><td data-col-size="sm" data-end="2796" data-start="2773" style="width: 99.5101%; height: 29.6px;">Customer / Supplier</td></tr><tr data-end="2819" data-start="2797" style="height: 14.4px;"><td data-col-size="sm" data-end="2819" data-start="2797" style="width: 99.5101%; height: 14.4px;">Total</td></tr><tr><td style="width: 99.5101%;">Terms</td></tr><tr><td style="width: 99.5101%;">Date</td></tr><tr data-end="2832" data-start="2820" style="height: 29.6px;"><td data-col-size="sm" data-end="2832" data-start="2820" style="width: 99.5101%; height: 29.6px;">Due Date</td></tr><tr data-end="2849" data-start="2833" style="height: 29.6px;"><td data-col-size="sm" data-end="2849" data-start="2833" style="width: 99.5101%; height: 29.6px;">Created Date</td></tr></tbody></table>

</div></div>**Purpose**

Monitor recently overdue financial documents to support timely collection and payment.

[![image.png](https://documentation.xccel.my/uploads/images/gallery/2026-06/scaled-1680-/LYcimage.png)](https://documentation.xccel.my/uploads/images/gallery/2026-06/LYcimage.png)