Skip to main content

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

    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

      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

          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

              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

                  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

                      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

                          Financial Tables

                          8. Top 30 Debtors with Overdue

                          Displays the top 30 customers with overdue outstanding invoices.

                          Column No. Customer Code Customer Name Outstanding Amount

                          Purpose

                          Identify customers requiring collection follow-up.

                          image.png

                          9. Recent Overdue Invoice & Bills

                          Displays recently overdue customer invoices and supplier bills.

                          Column No. Document No. Date Customer / Supplier Outstanding Amount Due Date Overdue Days

                          Purpose

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

                          image.png

                          Back to top