Excel Financial Database Creation

I need a professional and easy-to-use **Excel Financial Database** for **Muhammad Waseem**. The database should be clean, modern, professional and simple to use. I should only need to enter my daily financial transactions, while Excel should automatically calculate balances, totals, summaries and graphs. The database should have **4 main pages/sheets**. -------------------------------------------------- PAGE 1 — FINANCIAL DASHBOARD Title: **Muhammad Waseem** **Personal Financial Management Dashboard** At the top, show: - Name: Muhammad Waseem - Year - Current Month - Professional dashboard header Main financial summary cards: 1. Total Credit / Income 2. Total Debit / Expenses 3. Opening Balance 4. Closing Balance 5. Total Money to Receive 6. Total Money to Pay 7. Total Savings Example: Total Credit: Rs. 250,000 Total Debit: Rs. 145,000 Closing Balance: Rs. 105,000 Money to Receive: Rs. 35,000 Money to Pay: Rs. 22,000 Total Savings: Rs. 105,000 Graphs: - Credit vs Debit Graph - Monthly Balance Trend - Expense by Category Graph - Top 5 Expenses The Dashboard should automatically update when new transactions are added. There should be no need to manually enter totals or create graphs. -------------------------------------------------- PAGE 2 — DAILY TRANSACTIONS This page will contain all daily financial transactions. Columns: - Transaction Number - Date - Type — Credit / Debit - Category - Description - Amount - Payment Method - Person / Source - Running Balance - Notes Example: 01-Oct | Credit | Salary | Monthly Income | Rs. 200,000 | Bank | Company | Rs. 200,000 02-Oct | Debit | Grocery | Home Grocery | Rs. 8,000 | Cash | — | Rs. 192,000 04-Oct | Debit | Electricity | Electricity Bill | Rs. 12,000 | Bank | — | Rs. 180,000 05-Oct | Debit | Car Fuel | Petrol | Rs. 5,000 | Cash | — | Rs. 175,000 Categories should include: - Salary - Freelancing - Business - Other Income - Home Expenses - Grocery - Electricity - Gas - Internet - Car Fuel - Bike Fuel - Medical - Education - Shopping - Entertainment - Travel - Business Expenses - Other Payment Method dropdown: - Cash - Bank - Easypaisa - JazzCash - Card - Other The Type, Category and Payment Method should preferably have dropdown menus to make data entry easy. The Running Balance should calculate automatically. -------------------------------------------------- PAGE 3 — MONEY TO RECEIVE & MONEY TO PAY This page should have two separate sections. SECTION A — MONEY TO RECEIVE This section shows people who owe me money. Columns: - Person Name - Reason - Total Amount - Received Amount - Remaining Amount - Due Date - Status - Notes Example: Ali | Loan | Rs. 30,000 | Rs. 10,000 | Rs. 20,000 | 15-Oct | Pending Status can be: - Pending - Partially Received - Completed SECTION B — MONEY TO PAY This section shows people or companies that I have to pay. Columns: - Person Name - Reason - Total Amount - Paid Amount - Remaining Amount - Due Date - Status - Notes Example: Ahmed | Borrowed Money | Rs. 20,000 | Rs. 5,000 | Rs. 15,000 | 20-Oct | Pending The remaining amount should calculate automatically. The Dashboard should automatically show: Money to Receive = Total Remaining Receivable Money to Pay = Total Remaining Payable -------------------------------------------------- PAGE 4 — YEARLY FINANCIAL SUMMARY This page should show the complete yearly financial report. Year: 2026 Monthly table: | Month | Total Credit | Total Debit | Monthly Saving | Closing Balance | | January | — | — | — | — | | February | — | — | — | — | | March | — | — | — | — | | April | — | — | — | — | | May | — | — | — | — | | June | — | — | — | — | | July | — | — | — | — | | August | — | — | — | — | | September | — | — | — | — | | October | — | — | — | — | | November | — | — | — | — | | December | — | — | — | — | At the bottom show: - Total Yearly Credit - Total Yearly Debit - Total Yearly Saving - Highest Income Month - Highest Expense Month - Final Year Closing Balance Graphs: - Monthly Credit vs Debit - Monthly Balance Trend - Monthly Savings Trend All yearly figures should be automatically calculated from the transaction data. -------------------------------------------------- MONTHLY SYSTEM The database should support monthly financial tracking. Every transaction must have a Date and Month. The system should allow me to select a month and see that month's data. For example: January 2026 February 2026 March 2026 ... December 2026 When a new month starts, I should be able to start entering the new month's transactions without affecting the previous month's records. Previous months' data must remain saved and available for yearly reporting. The previous month's closing balance should automatically become the next month's opening balance. Example: October Closing Balance = Rs. 105,000 Then: November Opening Balance = Rs. 105,000 -------------------------------------------------- AUTOMATIC CALCULATIONS The Excel file should automatically calculate: - Total Credit - Total Debit - Opening Balance - Closing Balance - Total Savings - Category-wise Expenses - Money to Receive - Money to Pay - Remaining Receivables - Remaining Payables - Monthly Totals - Yearly Totals - Running Balance I should not have to manually calculate these figures. -------------------------------------------------- DESIGN REQUIREMENTS The Excel database should look like a professional financial management dashboard, not like a simple basic spreadsheet. Design should be: - Clean - Modern - Professional - Easy to read - Organized - Minimal but attractive - Consistent fonts - Consistent headings - Clear tables - Professional charts - Proper spacing - Easy navigation Use professional colors for Credit, Debit, Balance, Receive and Pay. Avoid unnecessary decoration. The Dashboard should look visually impressive but should remain easy to understand. -------------------------------------------------- IMPORTANT FUNCTIONAL REQUIREMENTS 1. All calculations must be automatic. 2. Graphs must update automatically when new data is