Dashboard Overview

Dashboard Overview – Financial & Operational Snapshot

This dashboard provides a complete real-time overview of my bookkeeping work inside Xero for my mock company JiduffKelv Digital World. It highlights how I monitor bank accounts, track cash flow, oversee payables and receivables, review account balances, and maintain full financial visibility across the business. 

This snapshot demonstrates my ability to manage and interpret essential bookkeeping metrics that support decision-making and ensure accurate financial reporting.

1. Bank Accounts Overview

JiduffKelv Digital World (Mock Main Account)

• Status: Reconciled

• Statement Balance: ₦112,839,402.57 (as of Mar 31)

• Shows a consistent inflow/outflow trend from Oct to Nov

• Demonstrates completed bank reconciliation for the period

JiduffKelv Digital World (Mock Savings Account)

• Status: Reconciled

• Statement Balance: ₦5,000,000.00

• Reflects stable savings and internal transfers

• Fully reconciled to ensure accuracy

Petty Cash Account

• Balance in Xero: ₦70,000.00

• Statement Balance: ₦0.00 (no bank statement imported yet)

• Ready for reconciliation after statement upload

Skill Demonstrated: Multi-account reconciliation, cash monitoring, consistency review, and ensuring bank feeds match ledger balances.

2. Bills You Need to Pay (Accounts Payable Summary)

• 1 Draft Bill – 683,000.00

• 12 Awaiting Payment – ₦776,400.00

• 5 Overdue Bills – ₦896,400.00

Bar chart clearly shows aging of bills (Older, 9–15 Nov, This Week, 22–29 Nov, etc.).

Skills Demonstrated:

• AP aging analysis

• Monitoring overdue liabilities

• Vendor payment scheduling

• Ensuring timely settlement to avoid penalties

3. Invoices Owed to You (Accounts Receivable Summary)

• 2 Draft Invoices – ₦5,114,000.00

• 8 Awaiting Payment – ₦1,613,000.00

• 5 Overdue – ₦1,190,500.00

Shows aging similar to AP, with a chart for overdue receivables.

Skills Demonstrated:

• AR management

• Collection tracking

• Overdue invoice follow-up

• Cash flow forecasting based on receivables

4. Total Cash In and Out (Cash Movement Summary)

Bar chart showing monthly cash inflows/outflows (June–November).
This reflects how I monitor liquidity and financial health.

Skills Demonstrated:

• Cash flow trend analysis

• Monthly performance comparison

• Identifying high-spend months or strong revenue periods

5. Account Watchlist (General Ledger Monitoring)

The watchlist highlights strategic accounts I monitor closely, such as:

• Accounts Receivable – strong YTD balance ₦1,759,975.00

• Credit Card Payable – ₦1,312,000.00

• Inventory (Stock on Hand) – ₦31,307,963.47

• Customer Deposit/ Unearned Revenue ₦50,000.00

• Bad Debts Expense – posted for the month ₦251,700.00

• Wages Payable / Salaries Payable – ₦0.00

• Interest Payable – ₦25,000.00

• Expenses Claim Payable (Reimbursements Payable) – ₦0.0

• Inventory / Stock on Hand – ₦431,307,963.47

• Prepayments – ₦1,390,000.00

• Provision for Doubtful Debt – (₦251,700.00)

• Tax on Sales (VAT) – ₦926,447.01

• Undeposited Fund  – ₦0.0

Skills Demonstrated:

• Balance sheet control

• Monitoring accruals, payables, and receivables

• Identifying unusual movements

• Ensuring GL accuracy and expense tracking

6. Expense Claims Summary

• 1 Draft Claim: ₦7,990

• 1 To Review: ₦42,000

• 2 To Pay: ₦35,400

Shows how staff or user expense claims are processed.

Skills Demonstrated:

• Reviewing staff expense claims

• Approving reimbursements

• Ensuring supporting documents match claims

• Integrating claims into monthly expenses

7. Tax & Reporting Quick Access

Links to:

• Sales Tax Report

• Profit & Loss

• Balance Sheet

Skills Demonstrated:

• Quick access to financial statements

• Ability to generate tax and management reports

• Monitoring profitability and financial position

8. Key Insights From the Dashboard

This dashboard demonstrates the following core bookkeeping competencies:

✔ Full Multi-Account Reconciliation

Both main and savings accounts fully reconciled, proving strong control over bank records.

✔ Cash Flow Monitoring

Ability to read and interpret cash movement over months.

✔ AP & AR Management

Clear tracking of overdue bills and invoices, a critical skill for managing business liquidity.

✔ General Ledger Oversight

Account Watchlist shows I actively monitor key balance sheet and profit-and-loss accounts.

✔ Financial Health Awareness

I use Xero dashboard KPIs to assess:

• Liquidity

• Outstanding debts

• Profitability trends

• Tax obligations

• Behavioral trends of creditors & debtors

✔ Professional Accounting System Navigation

Confident use of Xero features like:

• Bank accounts panel

• Reporting tools

• Expense claims

• Watchlist

• Cash movement dashboard