Description

• Dashboard — A real-time executive overview displaying key performance indicators including Total Income ($143,776), Total Expenses ($46,276), Net Profit ($97,500), Cash Balance, A/R Outstanding ($27,310), A/P Outstanding ($13,078), and Profit Margin (67.8%). Visual analytics include monthly income vs. expense charts, expense breakdown by category, cash flow trends, and budget vs. actual comparisons.
• Lists — Centralized master data management for Income Categories (Sales, Services, Consulting, Affiliate Income, Advertising, Other Income), Expense Categories (12 categories from Advertising to Professional Services), Payment Methods (Cash, Bank Transfer, Credit Card, Debit Card, Check, Other), Statuses, Customers (10 clients), and Vendors (10 suppliers).
• Setup — Business configuration hub containing company details (Lynzaa Demo Inc.), financial settings (USD currency, fiscal year starting 2026-01-01), starting balances ($25,000 cash / $45,000 bank), and default preferences.
• Transactions — The core data entry sheet with 60 pre-loaded transactions spanning January through August 2026. Each record includes Transaction ID, Date, Type (Income/Expense), Category, Description, Customer/Vendor, Payment Method, Account, Amount, Tax (10%), Total, Status, and Reference.
• Income & Expenses — Dedicated tracking sheets with 25 detailed records each, showing invoice numbers, due dates, payment status (Paid, Due, Partially Paid), and outstanding balances.
• Accounts Receivable & Payable — Aging reports that categorize outstanding balances by time periods (Current, 1-30 Days, 31-60 Days, 61-90 Days, 90+ Days), helping prioritize collection and payment efforts.
• Cash Flow — Monthly cash flow statement tracking Opening Cash, Inflows, Outflows, Net Cash Flow, and Closing Cash — showing growth from $25,000 to $95,190 YTD.
• Budget — Annual budget vs. actual comparison across 12 expense categories with monthly allocations, total actuals, variance calculations, and variance percentages.
• Bank Reconciliation — Side-by-side comparison of bank statement amounts vs. book amounts with reconciliation status, difference tracking, and unreconciled item flags.
• Reports — Automated financial reports including Income Statement, Monthly Income Report, Expense Report by Category, Cash Flow Summary, A/R Aging, A/P Aging, Budget vs. Actual, and Annual Financial Summary.